YNU_JEUS/app_home/himed/webapps/sts/stscmcnwweb/xrw/SMSDT07200_사회사업장기이식상담실적B.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목   : SMSDT07100.사회사업장기이식상담실적.xrw
	* 설    명   : 사회사업장기이식상담실적
	* 작 성 자  : 임여원
	* 작 성 일  : 2008.11.17
	* 수정이력 : 
	* 기    타   : 
-->
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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>
						<brgstincmexpspres>
							<brgstincmexpsprescond>
								<cond/>
								<a1/>
								<a2/>
								<a3/>
								<atotal/>
								<b1/>
								<b2/>
								<b3/>
								<btotal/>
								<c1/>
								<c2/>
								<c3/>
								<ctotal/>
								<total1/>
								<total2/>
								<total3/>
								<total4/>
							</brgstincmexpsprescond>
						</brgstincmexpspres>
						<search>
							<reqflag>1</reqflag>
							<fromdd/>
							<todd/>
							<fromentryy/>
							<fromendyy/>
							<toendyy/>
							<toentryy/>
						</search>
					</main>
					<send>
						<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="TRSDT04002" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/cnstinfo"/>
			<bind id="bfreqcntconsult" ref="/root/main/cnstinfo/cnstlist/bfreqcntconsult" calculate="../reqtot -    ../bfreqcnt"/>
			<bind id="bfreplcntreply" ref="/root/main/cnstinfo/cnstlist/bfreplcntreply" calculate="../repltot -    ../bfreplcnt"/>
			<submission id="TRSDT07201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" replace="instance" resultref="/root/main/brgstincmexpspres"/>
		</model>
		<script type="javascript">
			<![CDATA[
/**========================================================================================================================================
* 조회기간 그리드초기화
=========================================================================================================================================*/	
				function fInit()
				{
					//cmb_reqflag.select(0);
					caption1.visible=true;
					model.removeNodeset("/root/main/brgstincmexpspres");
					
					var CurrentDate=getCurrentDate();
					var CurrentDateYM=CurrentDate.substr(0,6);
					var LastDate=CurrentDate.toDate().getAddDate(-1,"M").getDateFormat();
					var LastDateYM=LastDate.substr(0,6);
					model.makeValue("/root/main/search/fromdd",LastDateYM);
					model.makeValue("/root/main/search/todd",LastDateYM);
					
					model.refresh();
					
					
					
				}			
/**========================================================================================================================================
*  조회 
=========================================================================================================================================*/		
				function fReqBrgstIncmExpsCond()
				{
					model.removeNodeset("/root/send/reqdata");
					model.makeNode("/root/send/reqdata");
					
					var fdate=model.getValue("/root/main/search/fromdd");
					var todate=model.getValue("/root/main/search/todd");
					var reqflag=model.getValue("/root/main/search/reqflag");
					
					var fromdd=fdate.substr(4,2);
					var todd=todate.substr(4,2);
					var fromendyy=fdate.substr(0,4);
					var toendyy=todate.substr(0,4);
					
					//alert(todd.substring(6,2));
					model.makeValue("/root/send/reqdata/fromdd",fromdd);
					model.makeValue("/root/send/reqdata/todd",todd);
					model.makeValue("/root/send/reqdata/fromendyy",fromendyy);
					model.makeValue("/root/send/reqdata/toendyy",toendyy);
					model.makeValue("/root/send/reqdata/reqflag",reqflag);
					
						if(isNull(fromdd))
						{
							messageBox("조회시작일자는","I003");
							model.setFocus("ipt_fromdd");
							return;
						}
						if(isNull(todd))
						{
							messageBox("조회종료일자는","I003");
							model.setFocus("ipt_todd");
							return;
						}
						var dateintval=getDateInterval(fdate+"01",todate+"31");
						
						if(fdate>todate)
						{
							messageBox("조회시작일보다 큰 조회종료일을 입력하십시요.","I");
							model.setFocus("ipt_todd");
							return;
						}
						
						if(dateintval>"370")
						{
							messageBox("조회기간은 최대 1년까지 할 수 있습니다","I");
							model.setFocus("ipt_fromdd");
							return;
						}
						
					submit("TRSDT07201");
					
					var idxRow=grd_brgstincmexpsprescond.rows;
					var fixRow=grd_brgstincmexpsprescond.fixedRows;
					var reqflag=model.getValue("/root/main/search/reqflag");
					
					for(i=1;i<=idxRow-fixRow;i++)
					{
						var cond=model.getValue("/root/main/brgstincmexpspres/brgstincmexpsprescond"+"["+i+"]/cond");
						

							if(cond=='전기간실적'&&i=='1')
							{
									//grd_brgstincmexpsprescond.removeRow(false);
									model.removeNodeset("/root/main/brgstincmexpspres/brgstincmexpsprescond");
							}
							else
							{
								if(reqflag=='1')
								{
									fGetBfResult();
									return;
								}
								
							}
						
					}
					
					model.refresh();
					
				}
  /**========================================================================================================================================                 
  * 전년실적                                                                                                                                                  
  =========================================================================================================================================*/					
                                                                                                                                                              
  				                                                                                                                                             
  					function fGetBfResult(){	                                                                                                             
  					if(grd_brgstincmexpsprescond.rows - grd_brgstincmexpsprescond.fixedRows >1){                                                             
  						var sStat = 0;                                                                                                                       
  						var insRow = grd_brgstincmexpsprescond.rows;                                                                                         
  						grd_brgstincmexpsprescond.addRow(insRow, false);                                                                                     
  						grd_brgstincmexpsprescond.valueMatrix(insRow, grd_brgstincmexpsprescond.colRef("cond") ) = "전기간대비실적비교";                    
  							                                                                                                                                 
  						for(var i= grd_brgstincmexpsprescond.colRef("a1"); i<= grd_brgstincmexpsprescond.colRef("total"); i++)                               
  						{                                                                                                                                    
  							var bfResult = eval(grd_brgstincmexpsprescond.valueMatrix(insRow -1 , i));							                             
  							var sSum = eval(grd_brgstincmexpsprescond.valueMatrix(insRow-2, i));		                                                     
  																											                                                 
  							sStat = eval(sSum)- eval(bfResult) ;							                                                                 
  							grd_brgstincmexpsprescond.valueMatrix(insRow, i ) = eval(sStat);								                                 				                                             
  						}	                                                                                                                                 
  															                                                                                                                       
  																                                                                                             
  					}else{						                                                                                                             
  						model.removeNodeset("/root/main/brgstincmexpspres/brgstincmexpsprescond");						                                     
  					}                                                                                                                                        
  					model.refresh();                                                                                                                         
  				}                                                                                                                                            
                                                                                                                                            
  				                                                                                                                                               


/**========================================================================================================================================
* 초기화 
=========================================================================================================================================*/					
				function	fResetBrgstIncmExps()
	 			{
	 				model.removeNodeset("/root/main/brgstincmexpspres");
	 				model.refresh();
	 			}

/**========================================================================================================================================
* 엑셀저장 버튼 클릭시
=========================================================================================================================================*/					
				function fExcel() {
					if (grd_brgstincmexpsprescond.rows <= 2) {
						messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
						return;
					}
					
					var fileName = window.fileDialog("save", ",", false, "장기이식상담실적", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");  
					if (fileName != ""){
						 grd_brgstincmexpsprescond.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:230px; 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[
								fResetBrgstIncmExps();
					]]>
				</script>
			</button>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:13px; width:1195px; height:744px; ">
			<caption id="caption21" class="tit_2" style="left:0px; top:55px; width:232px; 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" navindex="4" style="left:1123px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
								fReqBrgstIncmExpsCond();					
						]]>
					</script>
				</button>
				<caption id="caption23" class="search_name" style="left:15px; top:10px; width:86px; height:17px; ">조회구분 :</caption>
				<line id="line2" style="x1:1113px; y1:7px; x2:1113px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="cap1" style="left:409px; top:8px; width:25px; height:20px; text-align:center; ">~</caption>
				<input id="ipt_fromdd" ref="/root/main/search/fromdd" class="input_search" navindex="2" inputtype="date" format="yyyy-mm" style="left:332px; top:8px; width:73px; height:19px; "/>
				<input id="ipt_todd" ref="/root/main/search/todd" class="input_search" navindex="3" inputtype="date" format="yyyy-mm" style="left:445px; top:8px; width:73px; height:19px; "/>
				<caption id="caption1" class="search_name" style="left:240px; top:10px; width:100px; height:17px; ">조회기간 :</caption>
				<select1 id="cmb_reqflag" ref="/root/main/search/reqflag" navindex="1" appearance="minimal" style="left:110px; top:10px; width:85px; height:19px; ">
					<choices>
						<item>
							<label>월별</label>
							<value>1</value>
						</item>
						<item>
							<label>적격여부별</label>
							<value>2</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
									model.removeNodeset("/root/send/reqdata");
									model.makeNode("/root/send/reqdata");
									fReqBrgstIncmExpsCond(); //조회함수 
						
						]]>
					</script>
				</select1>
			</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_brgstincmexpsprescond" nodeset="/root/main/brgstincmexpspres/brgstincmexpsprescond" class="datagrid2" caption="구분^신장^신장^신장^신장^간^간^간^간^기타^기타^기타^기타^합계^장소^장소명^장소^담당자|구분^혈연^비혈연^대상자미선정^합계^혈연^비혈연^대상자미선정^합계^혈연^비혈연^대상자미선정^합계^합계^장소^장소명^장소^담당자" colsep="^" colwidth="161, 78, 78, 82, 78, 78, 78, 82, 78, 78, 78, 82, 78, 77" dataheight="25" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheight="25" rowsep="|" style="left:1px; top:76px; width:1190px; height:664px; ">
				<col ref="cond" style="text-align:center; "/>
				<col ref="a1" style="text-align:center; "/>
				<col ref="a2" style="text-align:center; "/>
				<col ref="a3" style="text-align:center; "/>
				<col ref="atotal" style="text-align:center; "/>
				<col ref="b1" style="text-align:center; "/>
				<col ref="b2" style="text-align:center; "/>
				<col ref="b3" style="text-align:center; "/>
				<col ref="btotal" style="text-align:center; "/>
				<col ref="c1" style="text-align:center; "/>
				<col ref="c2" style="text-align:center; "/>
				<col ref="c3" style="text-align:center; "/>
				<col ref="ctotal" style="text-align:center; "/>
				<col ref="total" style="text-align:center; "/>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>