YNU_JEUS/app_home/himed/webapps/ast/healexamstatweb/xrw/SMAHS01200_미수금현황.xrw

<?xml version="1.0" encoding="UTF-8"?>
<?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>
						<uncolst>
							<item>
								<cmpynm/>
								<exclamamt/>
								<nowclamamt/>
								<incmamt/>
								<uncoamt/>
								<discamt/>
								<lastincmdd/>
								<lastclamdd/>
								<clamtrgtcd/>
							</item>
						</uncolst>
						<export/>
					</main>
					<send>
						<srchfromdd/>
						<srchtodd/>
						<srchinstcd/>
						<srchyear/>
						<srchmonth/>
					</send>
					<hidden>
					</hidden>
					<init>
						<baseinfo>
							<yearlst/>
							<monthlst/>
						</baseinfo>
					</init>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
										
					// 기관코드 초기화
					model.setValue("/root/send/srchinstcd" , getUserInfo("posinstcd"));
					
					// 공통코드 조회
					zbcfGetCodeList( new Array("P0167","R0009"),
								   new Array("/root/init/baseinfo/yearlst" ,"/root/init/baseinfo/monthlst"  ) );          									    		 				
					
					// 일자초기화
					model.setValue("/root/send/srchyear" , getCurrentDate().substr(0,4));
					model.setValue("/root/send/srchmonth" , getCurrentDate().substr(4,2));
					
					cmb_year.dispatch("xforms-select");
					
					model.refresh();
										
					
				]]>
			</script>
			<submission id="TRZBC00101"/>
			<script type="javascript">
				<![CDATA[
					/*
					* 건진종류 소계 및 총계를 생성한다.
					*/
					function fSetRcptSum() {
						// 그리드 merge 및 합계 초기화
						
						grd_uncolst.subtotalPosition = "below";						
						grd_uncolst.multiTotals = true;
						grd_uncolst.subtotal("clear", 0, 0);
						for(var i =0; i < grd_uncolst.cols ; i++) {
							
							// 소계 및 합계
							if((i >= grd_uncolst.colRef("bfmuncoamt") && i <= grd_uncolst.colRef("discamt")) ) {																		
								grd_uncolst.subtotal("sum", -1 , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", grd_uncolst.colRef("cmpynm") , "총계" );																
							}														
						}
					}
					
					/*
					* 일자 초기화 (srchfromdd , srchtodd)
					*/
					function fDate(vYear , vMon) {
						
						var dd = new Date(vYear, vMon  ,0);						
						model.setValue("/root/send/srchfromdd" , vYear + vMon + "01");
						model.setValue("/root/send/srchtodd" , vYear + vMon + dd.getDate());
						
					}
				]]>
			</script>
			<submission id="TRAHS01201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/uncolst"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
		<script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784" guideline="1,1206;1,1049;">
		<group id="group3" style="left:0px; top:0px; width:1211px; height:13px; ">
			<caption id="caption60" class="tit_1" style="left:0px; top:0px; width:183px; height:14px; font-family:돋움; vertical-align:middle; ">미수금현황</caption>
		</group>
		<group id="group2" style="left:4px; top:23px; width:1203px; height:35px; ">
			<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1202px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<line id="line2" class="line_4" style="x1:1132px; y1:7px; x2:1132px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
			<button id="btn_search" class="btn1_letter2" style="left:1139px; top:7px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[						
						var ret = submit("TRAHS01201");
						if(ret) {
							fSetRcptSum();
							model.refresh();
						}						
					]]>
				</script>
			</button>
			<button id="btn_excelsave" class="btn6_letter4" visibility="visible" style="left:976px; top:7px; width:80px; height:22px; ">
				<caption>액셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[				
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*"); 
						grd_uncolst.saveExcel(fileName, "SheetName", true, true, "", "", false);
					]]>
				</script>
			</button>
			<button id="btn_prt" class="btn6_letter2" style="left:1070px; top:7px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.makeValue("/root/main/export/srchfromdd" , model.getValue("/root/send/srchfromdd").toDate().getDateFormat("YYYY/MM/DD"));
						model.makeValue("/root/main/export/srchtodd" , model.getValue("/root/send/srchtodd").toDate().getDateFormat("YYYY/MM/DD"));						
						model.makeValue("/root/main/export/srchmonth" , model.getValue("/root/send/srchmonth"));						
						exeReportPreview("RPAHS01201", "XMLSTR", "/root/main/export","", "false","","","","","false");	
					]]>
				</script>
			</button>
			<line id="line3" class="line_4" visibility="hidden" style="x1:1063px; y1:7px; x2:1063px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
			<caption id="caption2" class="search_name" style="left:15px; top:9px; width:73px; height:17px; ">연도 :</caption>
			<caption id="caption1" class="search_name" style="left:205px; top:9px; width:73px; height:17px; ">월 :</caption>
			<select1 id="cmb_year" ref="/root/send/srchyear" appearance="minimal" style="left:80px; top:8px; width:100px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/baseinfo/yearlst/P0167">
						<label ref="cdnm"/>
						<value ref="cdid"/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-select">
					<![CDATA[					
						fDate(cmb_year.value , cmb_month.value);
					]]>
				</script>
			</select1>
			<select1 id="cmb_month" ref="/root/send/srchmonth" appearance="minimal" style="left:255px; top:8px; width:100px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/baseinfo/monthlst/R0009">
						<label ref="cdnm"/>
						<value ref="cdid"/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-select">
					<![CDATA[
						fDate(cmb_year.value , cmb_month.value);
					]]>
				</script>
			</select1>
		</group>
		<datagrid id="grd_uncolst" nodeset="/root/main/uncolst/item" caption="사업장명^전월미수금^당월미수금^총입금액^총미수금^삭감액^최종입금일^최종청구일^비고" colsep="^" colwidth="200, 130, 130, 100, 110, 110, 110, 110, 182, 100" explorerbar="sortshow" mergecellsfixedcols="bycol" mergecellsfixedrows="byrowrec" multitotal="true" rowsep="|" subtotalposition="below" style="left:4px; top:65px; width:1203px; height:707px; text-align:center; ">
			<col ref="cmpynm" style="font-weight:bold; text-align:center; "/>
			<col ref="exclamamt" format="(-,+)#,###"/>
			<col ref="nowclamamt" format="(-,+)#,###"/>
			<col ref="incmamt" format="(-,+)#,###"/>
			<col ref="uncoamt" format="(-,+)#,###"/>
			<col ref="discamt" format="(-,+)#,###"/>
			<col ref="lastincmdd" format="yyyy-mm-dd"/>
			<col ref="lastclamdd" format="yyyy-mm-dd"/>
			<col ref="remfact" type="input"/>
			<col ref="clamtrgtcd" type="input" visibility="hidden"/>
			<script type="javascript" ev:event="onaftersort">
				<![CDATA[
					fSetRcptSum();	
					grd_uncolst.gridToInstance();
				]]>
			</script>
			<script type="javascript" ev:event="onbeforesort">
				<![CDATA[
					grd_uncolst.subtotal("clear", 0, 5)
				]]>
			</script>
		</datagrid>
	</xhtml:body>
</xhtml:html>