YNU_JEUS/app_home/himed/webapps/ast/dietweb/xrw/SMANB01000_식품별입출고현황.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
<xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:my="http://www.comsquare.co.kr/example" xmlns:ms="urn:schemas-microsoft-com:xslt" 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" xmlns:cs="http://www.comsquare.co.kr/xforms">
	<xhtml:head>
		<xhtml:title>식품월재고마감처리</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<cond>
						<srch2>
							<instcd/>
							<instnm/>
							<strmm/>
							<endmm/>
							<pat_emp/>
						</srch2>
					</cond>
					<main>
						<stocinfo>
							<foodstocrsltlist/>
						</stocinfo>
					</main>
					<send>
						<reqdata/>
					</send>
					<init>
					</init>
					<hidden/>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.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/stringHelper.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				model.removeNodeset(grd_foodstocrsltlist.nodeset);
				model.setValue("/root/cond/srch2/instcd",getUserInfo("dutplceinstcd"));   
				model.setValue("/root/cond/srch2/instnm",getUserInfo("dutplceinstnm"));
				model.setValue("/root/cond/srch2/strmm"	,getCurrentDate().substring(0,6));
				model.setValue("/root/cond/srch2/endmm"	,getCurrentDate().substring(0,6));
				model.setValue("/root/cond/srch2/pat_emp" , "P");
				model.refresh();
				]]>
			</script>
			<script type="javascript">
				<![CDATA[
					function saveGridToExcel(grdObj){
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
						if (fileName != ""){
							grdObj.saveExcel(fileName, "SheetName", false, false, "", "", true);
						}
					}				
				]]>
			</script>
			<submission id="TRANB01001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" resultref="/root/main/stocinfo"/>
		</model>
	</xhtml:head>
	<xhtml:body guideline="2,701;1,1104;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<caption id="caption6" class="tit_1" style="left:0px; top:5px; width:132px; height:13px; ">식품별 입출고 현황</caption>
		<case id="case1" selected="true" style="left:0px; top:0px; width:640px; height:340px; "/>
		<datagrid id="grd_foodstocrsltlist" nodeset="/root/main/stocinfo/foodstocrsltlist" caption="식품코드^식품명^ 이월수량^ 전월이월금액^ 입고수량^ 입고금액^출고수량^ 출고금액^ 재고수량^재고금액|식품코드^식품명^ 이월수량^ 전월이월금액^ 입고수량^ 입고금액^출고수량^ 출고금액^ 재고수량^재고금액" colsep="^" colwidth="99, 190, 70, 113, 70, 113, 70, 113, 70, 113" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" subtotalposition="below" style="left:0px; top:97px; width:1090px; height:678px; ">
			<col ref="goodcd" style="text-align:center; "/>
			<col ref="goodnm" style="text-align:left; "/>
			<col ref="beftotqty" format="#,###.##" style="text-align:center; "/>
			<col ref="beftotamt" format="#,###.##" style="text-align:right; "/>
			<col ref="inputqty" format="#,###.##" style="text-align:center; "/>
			<col ref="inputamt" format="#,###.##" style="text-align:right; "/>
			<col ref="outputqty" format="#,###.##" style="text-align:center; "/>
			<col ref="outputamt" format="#,###.##" style="text-align:right; "/>
			<col ref="apptotqty" format="#,###.##" style="text-align:center; "/>
			<col ref="apptotamt" format="#,###.##" style="text-align:right; "/>
		</datagrid>
		<caption id="caption18" class="tit_2" style="left:5px; top:75px; width:140px; height:20px; ">식품별 리스트</caption>
		<button id="button4" class="btn2_letter2" style="left:1049px; top:72px; width:42px; height:19px; ">
			<caption>엑셀</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
								saveGridToExcel(grd_foodstocrsltlist);
							]]>
			</script>
		</button>
		<group id="group3" style="left:0px; top:20px; width:1100px; height:40px; vertical-align:top; ">
			<shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1095px; height:40px; background-color:#fffbf2; border-color:#ffd799; "/>
			<caption id="caption17" class="search_name" style="left:5px; top:11px; width:89px; height:17px; ">기관코드 :</caption>
			<output id="output2" ref="/root/cond/srch2/instcd" class="output_fix" style="left:95px; top:10px; width:30px; height:19px; "/>
			<output id="output3" ref="/root/cond/srch2/instnm" class="output_fix" style="left:128px; top:10px; width:202px; height:19px; text-align:center; "/>
			<button id="button9" class="btn4_letter2" style="left:1010px; top:10px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[   
							model.makeValue("/root/send/reqdata/instcd"	 	,model.getValue("/root/cond/srch2/instcd"));
							model.makeValue("/root/send/reqdata/strmm"		,model.getValue("/root/cond/srch2/strmm"));
							model.makeValue("/root/send/reqdata/endmm"		,model.getValue("/root/cond/srch2/endmm"));
							model.makeValue("/root/send/reqdata/pat_emp"   ,model.getValue("/root/cond/srch2/pat_emp"));
							if(submit("TRANB01001")){
                            grd_foodstocrsltlist.subtotalPosition = "below";
							
							grd_foodstocrsltlist.subtotal("clear", -1, i, "format:(-,+)#,###.#; roundmode:round; roundpostion:2", "background-color:#ffff99; font-weight:bold; text-align:center", 1, "총계" );
							for(var i=0; i < grd_foodstocrsltlist.cols; i++){
							  if(i >= grd_foodstocrsltlist.colRef("beftotqty")){
							   grd_foodstocrsltlist.subtotal("sum", -1, i, "format:(-,+)#,###.#; roundmode:round; roundpostion:2", "background-color:#ffff99; font-weight:bold; text-align:center", 1, "총계" );
							  }
							}							
							grd_foodstocrsltlist.refresh();

							}
							]]>
				</script>
			</button>
			<caption id="caption19" class="search_name" style="left:355px; top:10px; width:101px; height:17px; ">기간 :</caption>
			<input id="input4" ref="/root/cond/srch2/strmm" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:416px; top:11px; width:97px; height:19px; text-align:center; "/>
			<line id="line14" class="line_4" style="x1:990px; y1:5px; x2:990px; y2:33px; "/>
			<caption id="caption11" class="search_no_b" style="left:521px; top:11px; width:12px; height:17px; ">~</caption>
			<input id="input5" ref="/root/cond/srch2/endmm" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:536px; top:11px; width:97px; height:19px; text-align:center; "/>
			<caption id="caption1" class="search_name" style="left:685px; top:10px; width:60px; height:17px; ">구분:</caption>
			<select1 id="rdo_diet" ref="/root/cond/srch2/pat_emp" class="radio_search" appearance="full" cellspacing="2" cols="4" rows="1" overflow="visible" style="left:743px; top:11px; width:134px; height:19px; ">
				<choices>
					<item>
						<label>환자식</label>
						<value>P</value>
					</item>
					<item>
						<label>직원식</label>
						<value>E</value>
					</item>
				</choices>
			</select1>
		</group>
		<button id="button13" class="btn6_letter2" style="left:985px; top:70px; width:56px; height:22px; ">
			<caption>출력</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
						 exeReportPreview("RPANB01001","XMLSTR");  
					]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>