YNU_JEUS/app_home/himed/webapps/ast/dietstatsweb/xrw/SMANS01000_식수통계.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?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>
						<list>
							<item>
								<emplno/>
								<name/>
								<dutplcedeptnm/>
								<deptnm/>
								<instnm/>
								<count/>
								<amount/>
							</item>
						</list>
					</main>
					<send>
						<fromdd/>
						<todd/>
						<globalinstance>
							<instance1/>
						</globalinstance>
					</send>
					<hidden/>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[		
					//var fromdd = getCurrentDate().toDate().getAddDate(-1, "D").getDateFormat("YYYYMMDD");
					//var todd = getCurrentDate().substr(0,6) + fromdd.toDate().getMonthDay();
					var fromdd = getCurrentDate().substring(0, 6) + '00';		// 적용일자 현재일자 셋팅
					var todd = getCurrentDate().substring(0, 6) + '99';		// 적용일자 현재일자 셋팅
					
					model.removenode("/root/main/list/item");
					model.setValue("/root/send/fromdd", fromdd);
					model.setValue("/root/send/todd", todd);
				    
					model.refresh();
				]]>
			</script>
			<script type="javascript">
				<![CDATA[
					/*
					* 소속에 따른 소계 및 총계를 생성한다.
					*/
					function fSetSicksuSum() {
						// 그리드 merge 및 합계 초기화
						grd_sicksulist.autoMerge = false;
						grd_sicksulist.mergeCells = "bycolrec";
						
						grd_sicksulist.subtotalPosition = "below";						
						grd_sicksulist.multiTotals = true;
						
						grd_sicksulist.subtotal("clear", 0, 0);
						for(var i =0; i < grd_sicksulist.cols ; i++) {
							
							// 소계
							if(i >= grd_sicksulist.colRef("count") && i <= grd_sicksulist.colRef("amount")) {										
								grd_sicksulist.subtotal("sum", grd_sicksulist.colRef("instnm") , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#ccffff; font-weight:bold", grd_sicksulist.colRef("instnm"), "소계" );
								grd_sicksulist.subtotal("sum", -1 , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#33cccc; font-weight:bold", grd_sicksulist.colRef("instnm") , "총계" );
							}							
							// 화면 merge														
							if( i ==  grd_sicksulist.colRef("instnm")) {
								grd_sicksulist.mergeCol(i) = true;
							}else{
								grd_sicksulist.mergeCol(i) = false;
							}	
						}
						grd_sicksulist.merge();																
					}
				]]>
			</script>
			<submission id="TRANS01001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/list"/>
		</model>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:209px; height:14px; ">본원,칠곡 소속 구분별 식수 통계</caption>
		</group>
		<group id="grp_biz" scroll="auto" style="left:0px; top:13px; width:1195px; height:744px; ">
			<caption id="caption1" class="tit_2" style="left:5px; top:50px; width:200px; height:14px; ">월별 소속 구분별 식수 리스트</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:65px; x2:1183px; y2:65px; "/>
			<group id="grp_sea" style="left:0px; top:10px; width:1195px; height:30px; vertical-align:top; ">
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1193px; height:30px; background-color:#fffbf2; border-color:#ffd799; "/>
				<caption id="caption2" class="search_name" style="left:15px; top:7px; width:86px; height:17px; ">조회기간 :</caption>
				<line id="line13" class="line_4" style="x1:1110px; y1:4px; x2:1110px; y2:26px; "/>
				<button id="btn_sea" class="btn1_letter2" navindex="4" style="left:1120px; top:4px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[							
							if (model.getValue("/root/send/fromdd") == ""){
								messageBox("조회시작일자는", "I003");
								model.setFocus("ipt_fromdd");
								return;
							}
							if (model.getValue("/root/send/todd") == ""){
								messageBox("조회종료일자는", "I003");
								model.setFocus("ipt_todd");
								return;
							}
							if (model.getValue("/root/send/fromdd") > model.getValue("/root/send/todd")){
								messageBox("조회 시작일자는 종료일자 보다 클 수", "I004");
								model.setFocus("ipt_fromdd");
								return;
							}
							
							var fromdd = model.getValue("/root/send/fromdd")+ '00';		// 적용일자 현재일자 셋팅
							var todd = model.getValue("/root/send/todd") + '99';		// 적용일자 현재일자 셋팅

							model.setValue("/root/send/fromdd", fromdd);
							model.setValue("/root/send/todd", todd);							
							
							var ret = submit("TRANS01001");
					     	if(ret) {
						             	fSetSicksuSum();
							            model.refresh();
					     	}								
						]]>
					</script>
				</button>
				<input id="ipt_todd" ref="/root/send/todd" class="input_default" navindex="2" inputtype="date" format="yyyy-mm" style="left:207px; top:6px; width:85px; height:19px; "/>
				<caption id="caption5" class="search_no_b" style="left:192px; top:7px; width:12px; height:17px; ">~</caption>
				<input id="ipt_fromdd" ref="/root/send/fromdd" class="input_default" navindex="1" inputtype="date" format="yyyy-mm" style="left:106px; top:6px; width:85px; height:19px; "/>
			</group>
			<button id="btn_excsave" class="btn2_letter4" style="left:1120px; top:45px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("save", ",", false, "", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");	
						if (fileName != "") {
							grd_sicksulist.saveExcel(fileName);
						}
					]]>
				</script>
			</button>
			<datagrid id="grd_sicksulist" nodeset="/root/main/list/item" class="datagrid2" caption="소속^사번^성명^본원부서^칠곡부서^사용수^총금액" colsep="^" colwidth="100, 70, 100, 300, 300, 100, 100" explorerbar="sortshow" frozencols="7" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" selectionmode="free" style="left:0px; top:71px; width:1183px; height:624px; ">
				<col disabled="true" ref="instnm" style="text-align:center; "/>
				<col disabled="true" ref="emplno" style="text-align:center; "/>
				<col disabled="true" ref="name" style="text-align:center; "/>
				<col disabled="true" ref="dutplcedeptnm" style="text-align:center; "/>
				<col disabled="true" ref="deptnm" style="text-align:center; "/>
				<col disabled="true" ref="count" style="text-align:center; "/>
				<col disabled="true" ref="amount" style="text-align:center; "/>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
					grd_sicksulist.gridtoinstance();
					]]>
				</script>
			</datagrid>
			<button id="btn_prt" class="btn1_letter5" style="left:1010px; top:14px; width:92px; height:22px; ">
				<caption>PDF 저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[	
						// 매개변수
						model.makeValue("/root/main/export/weeknm" , model.getValue("/root/send/srchdd").toDate("YYYYMMDD").getDayOfWeek("k"));
						model.makeValue("/root/main/export/srchdd" , model.getValue("/root/send/srchdd").toDate("YYYYMMDD").getDateFormat("YYYY/MM/DD"));
						
						exeReportPreview("RPANS01001", "XMLSTR" , ""                , ""          , ""    , ""            , "pdf"     , "식수통계"    , "true"           , "true"    ,""         ,""               ,""                  ,""                ,""               ,""             ,""             ,"" );
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>