YNU_JEUS/app_home/himed/webapps/ast/healexamstatweb/xrw/SMAHS01300_사업장실시인원.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>
						<cmpylst>
							<item>
								<cmpynm/>
								<pkgnm/>
								<condd/>
								<cmpyamt/>
								<cmpycnt/>
								<chrgnm/>
								<mon1/>
								<mon2/>
								<mon3/>
								<mon4/>
								<mon5/>
								<mon6/>
								<mon7/>
								<mon8/>
								<mon9/>
								<mon10/>
								<mon11/>
								<mon12/>
							</item>
						</cmpylst>
						<export/>
					</main>
					<send>
						<srchinstcd/>
						<srchfromdd/>
						<srchtodd/>
						<srchyear/>
					</send>
					<hidden>
					</hidden>
					<init>
						<baseinfo>
							<yearlst/>
						</baseinfo>
						<srch>
							<year/>
						</srch>
					</init>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
										
					// 기관코드 초기화
					model.setValue("/root/send/srchinstcd" , getUserInfo("posinstcd"));
					
					// 공통코드 조회
					zbcfGetCodeList( new Array("P0167"),
								   new Array("/root/init/baseinfo/yearlst" 
													) );        				
																									
					// 일자초기화
					model.setValue("/root/init/srch/year" , getCurrentDate().substr(0,4));       		
					
					cmb_year.dispatch("xforms-select");
																								
					model.refresh();
										
					
				]]>
			</script>
			<submission id="TRZBC00101"/>
			<script type="javascript">
				<![CDATA[
					/*
					* 건진종류 소계 및 총계를 생성한다.
					*/
					function fSetRcptSum() {
						// 그리드 merge 및 합계 초기화
						grd_cmpylst
						grd_cmpylst.subtotalPosition = "below";						
						grd_cmpylst.multiTotals = true;
						
						grd_cmpylst.subtotal("clear", 0, 0);
						for(var i =0; i < grd_cmpylst.cols ; i++) {
							
							// 소계 및 합계
							if((i >= grd_cmpylst.colRef("cmpyamt") && i <= grd_cmpylst.colRef("cmpycnt")) ||
							(i >= grd_cmpylst.colRef("mon1") && i <= grd_cmpylst.colRef("mon12")) ) {																		
								grd_cmpylst.subtotal("sum", -1 , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", grd_cmpylst.colRef("cmpynm") , "합계" );																
							}														
						}																																																								
					}
					
					/*
					* 날짜 초기화
					*/
					function fDate(vYear) {
						var dd = new Date(vYear , 14 , 0 );
						model.setValue("/root/send/srchfromdd" , vYear + "0101");
					//	model.setValue("/root/send/srchtodd" , dd.getYear() + new String(dd.getMonth() + 1).getLeftPad(2,"0")  + new String(dd.getDate() ) );
					    model.setValue("/root/send/srchtodd" , vYear + "1231" );
						model.setValue("/root/send/srchyear" , vYear);
					}
				]]>
			</script>
			<submission id="TRAHS01301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/cmpylst"/>
		</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("TRAHS01301");
						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_cmpylst.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/srchyear" , model.getValue("/root/send/srchyear"));						
						exeReportPreview("RPAHS01301", "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>
			<select1 id="cmb_year" ref="/root/init/srch/year" 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);
					]]>
				</script>
			</select1>
		</group>
		<datagrid id="grd_cmpylst" nodeset="/root/main/cmpylst/item" caption="사업장명^계약항목^계약일자^실시금액^실시인원(명)^담당자^실 시 기 간^실 시 기 간^실 시 기 간^실 시 기 간^실 시 기 간^실 시 기 간^실 시 기 간^실 시 기 간^실 시 기 간^실 시 기 간^실 시 기 간^실 시 기 간|사업장명^계약항목^계약일자^실시금액^실시인원(명)^담당자^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월" colsep="^" colwidth="150, 100, 80, 100, 80, 80, 55,55, 55, 55, 55, 55, 55, 55, 55, 55, 55, 55" mergecellsfixedcols="bycol" mergecellsfixedrows="byrowrec" multitotal="true" rowheader="seq" rowsep="|" subtotalposition="below" style="left:4px; top:65px; width:1203px; height:707px; text-align:center; ">
			<col ref="cmpynm" style="font-weight:bold; text-align:left; "/>
			<col ref="pkgnm"/>
			<col ref="condd"/>
			<col ref="cmpyamt" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="cmpycnt" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="chrgnm"/>
			<col ref="mon1" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="mon2" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="mon3" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="mon4" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="mon5" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="mon6" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="mon7" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="mon8" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="mon9" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="mon10" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="mon11" format="(-,+)#,###" style="text-align:right; "/>
			<col ref="mon12" format="(-,+)#,###" style="text-align:right; "/>
		</datagrid>
	</xhtml:body>
</xhtml:html>