YNU_JEUS/app_home/himed/webapps/sts/stscmcnwweb/xrw/SMSDT06800_사회사업수가실적.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목   : SMSDT06800.사회사업 수가실적.xrw
	* 설    명   : 사회사업 수가실적
	* 작 성 자  : 박성호
	* 작 성 일  : 2008.11.20
	* 수정이력 : 
	* 기    타   : 
-->
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
<xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
	<xhtml:head>
		<xhtml:title>사회사업 수가실적</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<calcinfo>
							<calclist>
								<cdnm/>
								<cnt3/>
								<psnno3/>
								<cnt4/>
								<psnno4/>
								<cnt5/>
								<psnno5/>
								<cnt6/>
								<psnno6/>
								<cnt7/>
								<psnno7/>
								<cnt8/>
								<psnno8/>
								<cnt9/>
								<psnno9/>
								<cnt10/>
								<psnno10/>
								<cnt11/>
								<psnno11/>
								<cnt12/>
								<psnno12/>
								<cnt1/>
								<psnno1/>
								<cnt2/>
								<psnno2/>
								<totcnt/>
								<totpsnno/>
								<bfcnt/>
								<bfpsnno/>
								<cntrate/>
								<psnnorate/>
								<befcompare/>
							</calclist>
						</calcinfo>
						<cond>
							<entryy/>
						</cond>
					</main>
					<send>
						<reqdata>
						</reqdata>
					</send>
					<init/>
					<hidden/>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
			<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
			<script type="javascript" src="../../../ast/commonweb/js/AST.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[					
					fInit();			
				]]>
			</script>
			<submission id="TRSDT06801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/calcinfo"/>
			<bind id="cntrate" ref="/root/main/calcinfo/calclist/cntrate" calculate="../totcnt  -    ../bfcnt"/>
			<bind id="psnnorate" ref="/root/main/calcinfo/calclist/psnnorate" calculate="../totpsnno   -    ../bfpsnno"/>
		</model>
		<script type="javascript">
			<![CDATA[
/**========================================================================================================================================
* 조회기간 그리드초기화
=========================================================================================================================================*/	
				function fInit(){
					model.removeNodeset("/root/main/calcinfo/calclist");
					
					var currentDate = getCurrentDate();
					var currentYear = currentDate.substring(0, 4); 
					
					model.setValue("/root/main/cond/entryy"		,currentYear);
					ipt_entryy.visible    = true;
					
					// 그리드초기화
					model.removeNodeset(grd_calclist.nodeset);	
					model.refresh();
				}			
/**========================================================================================================================================
*  조회 
=========================================================================================================================================*/		
				function fGetCalcInfo(){
					
					/*
					var currentDate = getCurrentDate();
					var currentYear = currentDate.substring(0, 4); 
					var entryy   = model.getValue("/root/main/cond/entryy");
					model.setValue("/root/main/cond/entryy"		,currentYear);
					*/
					var entryy   = model.getValue("/root/main/cond/entryy");
					if(entryy ==""){
						messageBox("조회년도를","C001" );
						model.removeNodeset(grd_calclist.nodeset);	
						model.refresh();
						return;
					}
						
					ipt_entryy.visible 	= true;
					
					model.removeNodeset("/root/send/reqdata");
					model.makeNode("/root/send/reqdata");
					model.copyNode("/root/send/reqdata", "/root/main/cond");
					model.refresh();
					
					submit("TRSDT06801");
					fStat();

				}

/**========================================================================================================================================
* 전년대비실적비교 계산
=========================================================================================================================================*/					
				function fStat() {	
					
					//데이터가없을때 return 
					if (model.instances(0).selectNodes("/root/main/calcinfo/calclist").length == 0){
						return;
					}
					//전년대비실적비교계산
					if(grd_calclist.rows - grd_calclist.fixedRows >1){
						var sStat = 0;
						var insRow = grd_calclist.rows;
						grd_calclist.addRow(insRow, false);
						grd_calclist.valueMatrix(insRow, grd_calclist.colRef("cdnm") ) = "전년대비실적비교";
							
						for(var i= grd_calclist.colRef("cnt1"); i<= grd_calclist.colRef("totpsnno"); i++){
							var bfResult = eval(grd_calclist.valueMatrix(insRow -1 , i));												
							var sSum = eval(grd_calclist.valueMatrix(insRow-2, i));		
																											
							sStat = eval(sSum)- eval(bfResult) ;							
							grd_calclist.valueMatrix(insRow, i ) = eval(sStat);								
						}					
						grd_calclist.valueMatrix(insRow-1, grd_calclist.colRef("cntrate")) = "";
						grd_calclist.valueMatrix(insRow, grd_calclist.colRef("cntrate")) = "";
						grd_calclist.valueMatrix(insRow-1, grd_calclist.colRef("psnnorate")) = "";
						grd_calclist.valueMatrix(insRow, grd_calclist.colRef("psnnorate")) = "";	
					}
				}

/**========================================================================================================================================
* 엑셀저장 버튼 클릭시
=========================================================================================================================================*/					
				function fExcel() {
					if (grd_calclist.rows <= 1) {
						messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
						return;
					}
					
					var fileName = window.fileDialog("save", ",", false, "사회사업 수가실적실적", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");  
					if (fileName != ""){
						 grd_calclist.saveExcel(fileName, "SheetName", false, false, "", "", false);
					}
				}
				
					
			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1195;1,1191;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:264px; height:14px; ">사회사업 수가실적</caption>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:757px; width:1195px; height:27px; ">
			<line id="line37" class="line_6" style="x1:0px; y1:0px; x2:1194px; y2:0px; "/>
			<button id="btn_search0" class="btn4_letter3" style="left:1126px; top:5px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fInit();
					]]>
				</script>
			</button>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:13px; width:1195px; height:737px; ">
			<caption id="caption21" class="tit_2" style="left:0px; top:55px; width:266px; height:14px; ">사회사업 수가실적</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:73px; x2:1190px; y2:72px; "/>
			<group id="group4" style="left:0px; top:5px; width:1194px; height:35px; vertical-align:top; ">
				<shape id="roundrect3" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1194px; height:35px; "/>
				<button id="button2" class="btn1_letter2" style="left:1123px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fGetCalcInfo();					
						]]>
					</script>
				</button>
				<line id="line2" style="x1:1113px; y1:7px; x2:1113px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption1" class="search_name" style="left:25px; top:10px; width:100px; height:17px; ">사업년도 :</caption>
				<input id="ipt_entryy" ref="/root/main/cond/entryy" class="input_search" inputtype="date" format="yyyy" style="left:120px; top:10px; width:58px; height:19px; "/>
			</group>
			<button id="btn_excel" class="btn2_letter4" style="left:1126px; top:50px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fExcel();
					]]>
				</script>
			</button>
			<datagrid id="grd_calclist" nodeset="/root/main/calcinfo/calclist" class="datagrid2" autoresize="true" caption="구분^1월^1월^2월^2월^3월^3월^4월^4월^5월^5월^6월^6월^7월^7월^8월^8월^9월^9월^10월^10월^11월^11월^12월^12월^합계^합계^   전기간실적^   전기간실적^전기간대비실적비교^전기간대비실적비교^장소^장소^장소^장소명^장소^담당자|구분^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^장소^장소^장소^장소명^장소^담당자|구분^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^건수^금액^장소^장소^장소^장소명^장소^담당자" colsep="^" colwidth="190, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 60, 60, 80, 80, 80, 80" dataheight="25" fixedcols="1" mergecellsfixedrows="bycolrec" rowheight="25" rowsep="|" style="left:0px; top:75px; width:1190px; height:659px; ">
				<col ref="cdnm" style="text-align:left; "/>
				<col ref="cnt1" style="text-align:center; "/>
				<col ref="psnno1" format="(-)#,###" style="text-align:center; "/>
				<col ref="cnt2" style="text-align:center; "/>
				<col ref="psnno2" format="(-)#,###" style="text-align:center; "/>
				<col ref="cnt3" style="text-align:center; "/>
				<col ref="psnno3" format="(-)#,###" style="text-align:center; "/>
				<col ref="cnt4" style="text-align:center; "/>
				<col ref="psnno4" format="(-)#,###" style="text-align:center; "/>
				<col ref="cnt5" style="text-align:center; "/>
				<col ref="psnno5" format="(-)#,###" style="text-align:center; "/>
				<col ref="cnt6" style="text-align:center; "/>
				<col ref="psnno6" format="(-)#,###" style="text-align:center; "/>
				<col ref="cnt7" style="text-align:center; "/>
				<col ref="psnno7" format="(-)#,###" style="text-align:center; "/>
				<col ref="cnt8" style="text-align:center; "/>
				<col ref="psnno8" format="(-)#,###" style="text-align:center; "/>
				<col ref="cnt9" style="text-align:center; "/>
				<col ref="psnno9" format="(-)#,###" style="text-align:center; "/>
				<col ref="cnt10" style="text-align:center; "/>
				<col ref="psnno10" format="(-)#,###" style="text-align:center; "/>
				<col ref="cnt11" style="text-align:center; "/>
				<col ref="psnno11" format="(-)#,###" style="text-align:center; "/>
				<col ref="cnt12" style="text-align:center; "/>
				<col ref="psnno12" format="(-)#,###" style="text-align:center; "/>
				<col ref="totcnt" style="text-align:center; "/>
				<col ref="totpsnno" format="(-)#,###" style="text-align:center; "/>
				<col ref="bfcnt" style="text-align:center; "/>
				<col ref="bfpsnno" format="(-)#,###" style="text-align:center; "/>
				<col ref="cntrate" style="text-align:center; "/>
				<col ref="psnnorate" format="(-)#,###" style="text-align:center; "/>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>