YNU_JEUS/app_home/himed/webapps/crd/reptweb/xrw/SMDRM00200_보고서-식수통계.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>Untitle</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<list>
							<msg>
								<instnm/>
								<eatnm/>
								<count/>
								<duration/>
							</msg>
						</list>
					</main>
					<send>
						<eatdds/>
						<eatdde/>
						<instcd/>
						<eatddselect/>
					</send>
					<properties>
						<error>
							<msg/>
						</error>
					</properties>
					<temp>
					</temp>
					<init>
						<instcd>
							<itemlist>
								<cdid/>
								<cdnm/>
							</itemlist>
						</instcd>
						<dept>
							<itemlist>
								<deptcd/>
								<depthngnm/>
							</itemlist>
						</dept>
					</init>
					<total>
						<issdgtotal>0</issdgtotal>
					</total>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					submit("TRDDP00203");
					model.setValue("/root/total/issdgtotal", 0);
					// 당일날짜 세팅
					addComboItem("cmb_instcd");
					model.removeNodeset("/root/main/list/msg");
					model.setValue("/root/send/eatdds", getCurrentDate());
					model.setValue("/root/send/eatdde", getCurrentDate());
					model.refresh();	
				]]>
			</script>
			<submission id="TRDDP00203" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/temp" replace="instance" resultref="/root/init/instcd"/>
			<submission id="TRDRM00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/list"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/authinfoweb/js/ZSA001.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
	</xhtml:head>
	<xhtml:body guideline="1,1194;1,1195;2,49;2,10;2,87;2,33;2,773;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1194px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">보고서 - 식수 통계</caption>
		</group>
		<group id="group3" style="left:0px; top:13px; width:1195px; height:767px; ">
			<group id="group2" style="left:0px; top:10px; width:1194px; height:35px; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1194px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="button1" class="btn1_letter2" style="left:1125px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						var issddsDate = input11.value;
						var issddeDate = input12.value;
						if(issddsDate>issddeDate){
							messageBox("조회하고자 하는 식수기간을 제대로", "C001");
						}else if(issddsDate.length<8 | issddeDate.length<8){
							messageBox("조회하고자 하는 식수기간을 제대로", "C001");
						}else{
		                              	submit("TRDRM00201");
		                              	var vRow = grd_scrnlist.rows;
		                              	var issdgtotal=0;
		                              	for(var i = 1; i<vRow; i++){
		                              		if((model.getValue("/root/main/list/msg["+i+"]/count"))==""){
		                              			issdgtotal +=0;
		                              		}else{
									issdgtotal +=parseInt(model.getValue("/root/main/list/msg["+i+"]/count"));
		                              		}
		                              	}
		                              	model.setValue("/root/total/issdgtotal", issdgtotal);
		                              	var eatdds = (model.getValue("/root/send/eatdds").toDate("YYYYMMDD")).getDateFormat("YYYY-MM-DD");
							var eatdde = (model.getValue("/root/send/eatdde").toDate("YYYYMMDD")).getDateFormat("YYYY-MM-DD");
							for(var j=1; j<vRow; j++){
		                              		model.setValue("/root/main/list/msg["+j+"]/duration",  eatdds+"  ~  "+eatdde);
		                              		
							}
		                              	model.refresh();	
						}								
						]]>
					</script>
				</button>
				<line id="line2" class="line_4" style="x1:1110px; y1:7px; x2:1110px; y2:27px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption5" class="search_name" style="left:11px; top:9px; width:84px; height:17px; ">식수기간</caption>
				<select1 id="cmb_instcd" ref="/root/send/instcd" appearance="minimal" style="left:410px; top:8px; width:135px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/instcd/itemlist">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption4" class="search_name" style="left:335px; top:9px; width:80px; height:17px; vertical-align:middle; ">기관명</caption>
				<input id="input11" ref="/root/send/eatdds" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:105px; top:8px; width:100px; height:19px; "/>
				<input id="input12" ref="/root/send/eatdde" class="input_s_essential" editable="true" inputtype="date" style="left:221px; top:8px; width:100px; height:19px; "/>
				<caption id="caption3" class="search_no_b" style="left:207px; top:8px; width:15px; height:17px; ">~</caption>
			</group>
			<caption id="caption2" class="tit_2" style="left:5px; top:60px; width:300px; height:14px; font-family:돋움; vertical-align:middle; ">식수 통계 리스트</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:75px; x2:1194px; y2:75px; "/>
			<datagrid id="grd_scrnlist" nodeset="/root/main/list/msg" caption="기관명^식수유형^식수량^식수기간" colsep="^" colwidth="226, 150, 100, 267" dataheight="23" defaultrows="1" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="23" style="left:0px; top:80px; width:1194px; height:659px; ">
				<col explorerbar="sortshowmove" ref="instnm" style="text-align:center; "/>
				<col explorerbar="sortshowmove" ref="eatnm" format="#,###" style="text-align:center; "/>
				<col explorerbar="sortshowmove" ref="count" style="text-align:center; "/>
				<col explorerbar="sortshowmove" ref="duration" visibility="hidden" style="text-align:center; "/>
			</datagrid>
			<button id="btn_cle" class="btn4_letter3" style="left:1124px; top:745px; width:68px; height:22px; background-image:../../../com/commonweb/images/btn4_letter3.gif; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.reset();
						model.refresh();
					]]>
				</script>
			</button>
			<select1 id="combo1" ref="/root/send/eatddselect" appearance="minimal" style="left:645px; top:17px; width:100px; height:19px; ">
				<choices>
					<item>
						<label>- 선택 -</label>
						<value/>
					</item>
					<item>
						<label>일</label>
						<value>D</value>
					</item>
					<item>
						<label>주</label>
						<value>W</value>
					</item>
					<item>
						<label>월</label>
						<value>M</value>
					</item>
					<item>
						<label>년</label>
						<value>Y</value>
					</item>
				</choices>
				<script type="javascript" ev:event="xforms-select">
					<![CDATA[
						var eatddSelect  = model.getValue("/root/send/eatddselect");
						var date2  = (model.getValue("/root/send/eatdde"));
						var eatddedate = date2.toDate();
						
						if(eatddSelect =='D'){
							model.setValue("/root/send/eatdds" ,  (eatddedate.getAddDate(0,"D")).getDateFormat());
						}else if(eatddSelect =='W'){
							model.setValue("/root/send/eatdds" , (eatddedate.getAddDate(-6,"D")).getDateFormat());
						}else if(eatddSelect =='M'){
							model.setValue("/root/send/eatdds" , (eatddedate.getAddDate(-1,"M")).getDateFormat());
						}else if(eatddSelect =='Y'){
							model.setValue("/root/send/eatdds" , (eatddedate.getAddDate(-1,"Y")).getDateFormat());
						}else{
							model.setValue("/root/send/eatdds" ,getCurrentDate());
							model.setValue("/root/send/eatdde", getCurrentDate());
						}
						model.refresh();
					]]>
				</script>
			</select1>
			<caption id="caption1" class="search_name" style="left:560px; top:19px; width:76px; height:17px; vertical-align:middle; ">기간선택</caption>
			<button id="button3" class="btn2_letter4" style="left:1070px; top:54px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var dataYn = model.getValue("/root/main/list/msg["+1+"]/count");
						if(dataYn == ""){
							messageBox("조회된 ", "E013");
							return;
						}else{
							var fileName = window.fileDialog("save",",",false,"보고서-식수통계","xls","All Files(*.*)|*.*|Excel Files(*.xls)|*.xls");
						}
						if(fileName !=""){
							grd_scrnlist.saveExcel(fileName);
						}			
					]]>
				</script>
			</button>
			<caption id="caption7" class="output_text" style="left:185px; top:747px; width:30px; height:13px; ">건</caption>
			<button id="btn_print" class="btn6_letter2" style="left:1138px; top:52px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					var dataYn = model.getValue("/root/main/list/msg["+1+"]/count");
					if(dataYn == ""){
						messageBox("조회된 ", "E013");
						return;
					}else{
						exeReportPreview("RPDRM00201", "XMLSTR" , "/root/main/list/msg");	
					}
					]]>
				</script>
			</button>
			<caption id="caption8" class="search_name" style="left:10px; top:744px; width:107px; height:17px; ">총 식수량</caption>
			<output id="output1" ref="/root/total/issdgtotal" style="left:115px; top:744px; width:65px; height:19px; text-align:right; "/>
		</group>
	</xhtml:body>
</xhtml:html>