YNU_JEUS/app_home/himed/webapps/ast/dietweb/xrw/SMANB00900_식품월재고마감관리.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/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:ms="urn:schemas-microsoft-com:xslt" xmlns:my="http://www.comsquare.co.kr/example" 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>
						<srch1>
							<instcd/>
							<instnm/>
							<strmm/>
							<userid/>
							<usernm/>
						</srch1>
						<srch2>
							<instcd/>
							<instnm/>
							<strmm/>
							<endmm/>
							<sumflag/>
						</srch2>
					</cond>
					<main>
						<stocinfo>
							<foodstocrsltlist/>
						</stocinfo>
					</main>
					<send>
						<reqdata/>
						<savedata/>
					</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.setValue("/root/cond/srch1/instcd",getUserInfo("dutplceinstcd"));   
				model.setValue("/root/cond/srch1/instnm",getUserInfo("dutplceinstnm"));
				model.setValue("/root/cond/srch1/strmm"	,getCurrentDate().substring(0,6));
				model.setValue("/root/cond/srch1/userid",getUserInfo("userid"));   
				model.setValue("/root/cond/srch1/usernm",getUserInfo("usernm"));   
				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.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="TXANB00901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/savedata" resultref="/root/hidden"/>
			<submission id="TRANB00901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" resultref="/root/main/stocinfo"/>
		</model>
	</xhtml:head>
	<xhtml:body guideline="2,765;1,1182;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:132px; height:14px; ">식품월재고마감처리</caption>
		<case id="case1" selected="true" style="left:0px; top:0px; width:640px; height:340px; "/>
		<switch id="switch1" style="left:0px; top:40px; width:1135px; height:705px; ">
			<case id="cse_stocrslt" selected="true">
				<datagrid id="grd_foodstocrsltlist" nodeset="/root/main/stocinfo/foodstocrsltlist" caption="작업년월^비용계정명^ 이월수량^ 전월이월&#xA;금액^ 입고수량^ 입고금액^출고수량^ 출고금액^ 재고수량^재고금액|작업년월^비용계정명^ 이월수량^ 전월이월&#xA;금액^ 입고수량^ 입고금액^출고수량^ 출고금액^ 재고수량^재고금액" colsep="^" colwidth="57, 94, 82, 113, 112, 113, 98, 127, 91, 118" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" subtotalposition="below" style="left:0px; top:62px; width:1090px; height:635px; ">
					<col ref="stocym" format="yyyy-mm" style="text-align:center; "/>
					<col ref="acntnm" style="text-align:left; "/>
					<col ref="beftotqty" format="#,###.##" style="text-align:right; "/>
					<col ref="beftotamt" format="#,###.##" style="text-align:right; "/>
					<col ref="inputqty" format="#,###.##" style="text-align:right; "/>
					<col ref="inputamt" format="#,###.##" style="text-align:right; "/>
					<col ref="outputqty" format="#,###.##" style="text-align:right; "/>
					<col ref="outputamt" format="#,###.##" style="text-align:right; "/>
					<col ref="apptotqty" format="#,###.##" style="text-align:right; "/>
					<col ref="apptotamt" format="#,###.##" style="text-align:right; "/>
				</datagrid>
				<caption id="caption18" class="tit_2" style="left:0px; top:45px; width:140px; height:14px; ">재고마감 처리결과</caption>
				<button id="button4" class="btn2_letter2" style="left:1044px; top:42px; 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:0px; width:1090px; height:40px; vertical-align:top; ">
					<shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:-10px; 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:970px; 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/sumflag"		,model.getValue("/root/cond/srch2/sumflag"));
							if(submit("TRANB00901")){
								var sumflag = model.getValue("/root/cond/srch2/sumflag");
								if(sumflag=="Y"){
									grd_foodstocrsltlist.subtotal("clear", 0, 0);
									for(iCol =  1; iCol <=grd_foodstocrsltlist.cols ; iCol++){
										if((grd_foodstocrsltlist.colRef("stocym")!= iCol)&&(grd_foodstocrsltlist.colRef("acntnm")!= iCol)) {
											grd_foodstocrsltlist.subtotal("sum", 2, iCol, "format:#,###.##; ", "background-color:#ffff99; font-weight:bold; ", grd_foodstocrsltlist.colRef("acntnm"), "합계");	
										}
									}
								}else{
									grd_foodstocrsltlist.subtotal("clear", 0, 0);
									for(iCol =  1; iCol <=grd_foodstocrsltlist.cols ; iCol++){
										if((grd_foodstocrsltlist.colRef("stocym")!= iCol)&&(grd_foodstocrsltlist.colRef("acntnm")!= iCol)) {
											grd_foodstocrsltlist.subtotal("sum", 1, iCol, "format:#,###.##; ", "background-color:#ffff99; font-weight:bold; ", grd_foodstocrsltlist.colRef("stocym"), "합계");	
										}
									}
									
								}
								
							}
							]]>
						</script>
					</button>
					<caption id="caption19" class="search_name" style="left:355px; top:11px; width:101px; height:17px; ">작업년월 :</caption>
					<input id="input4" ref="/root/cond/srch2/strmm" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:455px; top:10px; width:97px; height:19px; text-align:center; "/>
					<line id="line14" class="line_4" style="x1:950px; y1:5px; x2:950px; y2:33px; "/>
					<caption id="caption11" class="search_no_b" style="left:560px; top:10px; width:12px; height:17px; ">~</caption>
					<input id="input5" ref="/root/cond/srch2/endmm" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:575px; top:10px; width:97px; height:19px; text-align:center; "/>
					<select id="checkbox1" ref="/root/cond/srch2/sumflag" overflow="visible" appearance="full" style="left:695px; top:10px; width:70px; height:20px; border-style:none; ">
						<choices>
							<item>
								<label>월별합계</label>
								<value>Y</value>
							</item>
						</choices>
						<script type="javascript" ev:event="xforms-value-changed">
							<![CDATA[
							/*var sumflag = model.getValue("/root/cond/srch2/sumflag");
							if(sumflag=="Y"){
								grd_foodstocrsltlist.colHidden(grd_foodstocrsltlist.colRef("stocym"))=true;
							}else{
								grd_foodstocrsltlist.colHidden(grd_foodstocrsltlist.colRef("stocym"))=false;
							}
							grd_foodstocrsltlist.refresh();*/
							]]>
						</script>
					</select>
				</group>
				<button id="button13" class="btn6_letter2" style="left:980px; top:40px; width:56px; height:22px; ">
					<caption>출력</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						 exeReportPreview("RPANB00901","XMLSTR");  
					]]>
					</script>
				</button>
			</case>
			<case id="cse_cretstoc" style="left:0px; top:0px; width:1133px; height:703px; ">
				<group id="group1" style="left:0px; top:5px; width:470px; height:205px; border-left-style:solid; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; ">
					<caption id="caption61" class="tit_2" style="left:45px; top:35px; width:157px; height:13px; ">식품월재고마감처리</caption>
					<line id="line23" class="line_2" style="x1:40px; y1:129px; x2:417px; y2:129px; "/>
					<line id="line35" class="line_3" style="x1:40px; y1:133px; x2:417px; y2:133px; "/>
					<button id="btn_del" class="btn2_letter2" style="left:329px; top:142px; width:42px; height:19px; ">
						<caption>삭제</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
							model.makeValue("/root/send/savedata/iudflag"	,"D");
							model.makeValue("/root/send/savedata/instcd"	,model.getValue("/root/cond/srch1/instcd"));
							model.makeValue("/root/send/savedata/strmm"		,model.getValue("/root/cond/srch1/strmm"));
							model.makeValue("/root/send/savedata/userid"	,model.getValue("/root/cond/srch1/userid"));
							if(submit("TXANB00901")==true){
								var certflag = model.getValue("/root/hidden/certinfo/certflag");
								if(certflag=="N"){
									messageBox("재고마감 삭제가","I001");
									return;
								}else{
									messageBox("재고마감 삭제가 실패하였습니다\n다시한번","C003");
									return;
								}
								
							}
							]]>
						</script>
					</button>
					<line id="line1" class="line_2" style="x1:40px; y1:77px; x2:417px; y2:77px; "/>
					<button id="btn_gen" class="btn2_letter2" style="left:374px; top:142px; width:42px; height:19px; ">
						<caption>실행</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
						model.makeValue("/root/send/savedata/iudflag"	,"I");
						model.makeValue("/root/send/savedata/instcd"	 	,model.getValue("/root/cond/srch1/instcd"));
						model.makeValue("/root/send/savedata/strmm"		,model.getValue("/root/cond/srch1/strmm"));
						model.makeValue("/root/send/savedata/userid"		,model.getValue("/root/cond/srch1/userid"));
						
						if(submit("TXANB00901")){
							var certflag = model.getValue("/root/hidden/certinfo/certflag");
							if(certflag=="Y"){
								messageBox("재고마감 생성이","I001");	
								return;
							}else{
								messageBox("재고마감 생성이 실패하였습니다\n다시한번","C003");
								return;
							}
						}				
						]]>
						</script>
					</button>
					<line id="line19" class="line_2" style="x1:40px; y1:104px; x2:417px; y2:104px; "/>
					<caption id="caption7" class="cell_1" style="left:40px; top:55px; width:108px; height:23px; text-align:center; vertical-align:middle; ">기관코드</caption>
					<line id="line7" class="line_1" style="x1:40px; y1:50px; x2:417px; y2:50px; "/>
					<input id="input1" ref="/root/cond/srch1/strmm" class="input_default" inputtype="date" format="yyyy-mm" style="left:150px; top:81px; width:120px; height:19px; text-align:center; "/>
					<caption id="caption5" class="cell_1" style="left:40px; top:79px; width:108px; height:23px; text-align:center; ">작업년월</caption>
					<caption id="caption2" class="cell_1" style="left:40px; top:104px; width:108px; height:23px; text-align:center; ">작업자</caption>
					<input id="input2" ref="/root/cond/srch1/userid" class="input_default" appearance="input" style="left:150px; top:106px; width:79px; height:19px; "/>
					<input id="input3" ref="/root/cond/srch1/usernm" class="input_default" appearance="input" style="left:233px; top:106px; width:130px; height:19px; "/>
					<output id="output1" ref="/root/cond/srch1/instcd" class="output_fix" visibility="hidden" style="left:369px; top:54px; width:30px; height:19px; "/>
					<output id="output4" ref="/root/cond/srch1/instnm" class="output_fix" style="left:149px; top:55px; width:212px; height:19px; text-align:center; "/>
				</group>
			</case>
		</switch>
		<button id="button1" class="btn_sw" group="tab" style="left:1px; top:20px; width:115px; height:22px; ">
			<caption>재고마감처리</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
				model.toggle("cse_cretstoc");
				]]>
			</script>
		</button>
		<button id="button8" class="btn_sw" group="tab" selected="true" style="left:115px; top:20px; width:115px; height:22px; ">
			<caption>처리결과</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
				model.toggle("cse_stocrslt");
				]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>