YNU_JEUS/app_home/himed/webapps/mis/stocsumweb/xrw/SMRST06300_자재재고조회.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="">
					<main>
						<mtallist>
							<acntflagnm/>
							<goodcd/>
							<goodnm/>
							<goodspec/>
							<goodmodel/>
							<deliveunit/>
							<trnsqty/>
							<inputqty/>
							<outputqty/>
							<endmonqty/>
							<inunitcost/>
							<trnsamt/>
							<inputamt/>
							<outputamt/>
							<endmonamt/>
							<cmt/>
							<instcd/>
							<acntflag/>
						</mtallist>
						<cond>
							<instcd/>
							<stkmonth/>
							<acntflagnm/>
							<goodcd/>
							<goodnm/>
							<acntflag/>
							<purcflag/>
						</cond>
					</main>
					<send>
						<instcd/>
						<stkmonth/>
						<acntflagnm/>
						<goodcd/>
						<goodnm/>
						<acntflag/>
					</send>
					<init>
					</init>
					<temp/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
   				     fInitialize() ;
   				     
					var acntflag     = model.property("acntflag");
					var stkmonth   = model.property("stkmonth");
					var instcd        = model.property("instcd");
					var acntflagnm = model.property("acntflagnm");
					
					if(acntflag != "") {
						model.setValue(ipt_acntflag.attribute("ref"), acntflag);
					} 
					
					if(stkmonth != "") {
						model.setValue(ipt_stkmonth.attribute("ref"), stkmonth);
					}
					
					if(instcd != "") {
						model.setValue(cmb_instcd.attribute("ref"), instcd);
					}
					
					if(acntflagnm != "") {
						model.setValue(ipt_acntflagnm.attribute("ref"), acntflagnm);
					}
					
					
					ipt_acntflag.refresh();
					ipt_stkmonth.refresh();
					cmb_instcd.refresh();
					ipt_acntflagnm.refresh();
					
					if(acntflag != "") {
						btn_search.dispatch("DOMActivate");
					}
				]]>
			</script>
			<submission id="TRRST06301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/mtallist"/>
			<submission id="TRRST06302" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/mtallist"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript">
			<![CDATA[
			
				// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
				function fInitialize() 
				{	
					misfComboComCdListMulti("R0111","cmb_purcflag");
					rszfComboAppendBlankChild("cmb_purcflag");
					
					rszfUserReqInstList(cmb_instcd,getUserInfo("userid"),"%","B");
					
					model.setValue(cmb_instcd.attribute("ref"), getUserInfo("dutplceinstcd"));
					cmb_instcd.refresh();
					
					model.setValue(ipt_stkmonth.attribute("ref"), getCurrentDate().substr(0,6));
					ipt_stkmonth.refresh();
				}
				
			 // --------------------------------------------------------------   
			 // 불출 재고 현황 Excel 저장처리 
			 // --------------------------------------------------------------   
			 function fSaveExcel() {
			          var files = window.fileDialog("save","|", true, "불출 재고 현황_"+getCurrentDate(),"xls","Excel Files(*.xls)|*.xls");
			       // var filesarr= files.split("\\");
			       // var filenm  = filesarr[filesarr.length-1];
			       // var filepath= files.split(filenm);
			       
			          if (files != "") {
			              var sendPath = "/root/main/cond/";
			              
			              var ptxt = "";
			              ptxt += "&instcd="          + model.getValue(sendPath+"instcd"        );    // 기관코드   
			              ptxt += "&stkmonth="     + model.getValue(sendPath+"stkmonth"   );    // 수불년월   
			              ptxt += "&goodcd="       + model.getValue(sendPath+"goodcd"      );    // 물품코드   
			              ptxt += "&acntflag="       + model.getValue(sendPath+"acntflag"     );    // 계정구분   
			              ptxt += "&purcflag="       + model.getValue(sendPath+"purcflag"     );    // 구매구분   
			              ptxt += "&acntflagnm="   + model.getValue(sendPath+"acntflagnm");    // 계정구분명 
			              ptxt += "&goodnm="       + model.getValue(sendPath+"goodnm"    );    // 물품명     
			              // 
						//  alert(  ptxt);
						  
			              try {
			                   model.download(getActionURL("TRRST06302")+ptxt, files, false);
			              } catch(e) {
			              }
			          }
			 }
				
				
			]]>
		</script>
	</xhtml:head>
	<xhtml:body 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:243px; height:14px; ">불출재고현황</caption>
		</group>
		<group id="grp_biz" scroll="auto" style="left:0px; top:38; width:1195; height:744; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:2px; width:1195px; height:51px; "/>
			<select1 id="cmb_instcd" ref="/root/main/cond/instcd" class="combo_s_essential" appearance="minimal" style="left:95px; top:6px; width:120px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/instcd">
						<label ref="cdnm"/>
						<value ref="cdid"/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption14" class="search_name" style="left:5px; top:6px; width:91px; height:17px; ">기관코드 :</caption>
			<caption id="caption31" class="search_name" style="left:230px; top:6px; width:86px; height:17px; ">재고년월 :</caption>
			<line id="line14" class="line_4" style="x1:1110px; y1:19px; x2:1110px; y2:41px; "/>
			<button id="btn_search" class="btn1_letter2" navindex="7" style="left:1125px; top:20px; width:56px; height:22px; text-align:left; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[	
						 model.setValue(ipt_acntflag.attribute("ref"), "");
						 ipt_acntflag.refresh();
						
						model.copyNode("/root/send", "/root/main/cond");
						submit("TRRST06301");
					]]>
				</script>
			</button>
			<caption id="caption5" class="tit_2" style="left:5px; top:60px; width:110px; height:14px; ">불출재고현황</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:75px; x2:1195px; y2:75px; "/>
			<input id="ipt_stkmonth" ref="/root/main/cond/stkmonth" class="input_s_essential" inputtype="date" maxlength="6" format="yyyy-mm" style="left:320px; top:6px; width:130px; height:19px; "/>
			<caption id="caption1" class="search_name" style="left:230px; top:29px; width:83px; height:17px; ">계 정 명 :</caption>
			<input id="ipt_acntflagnm" ref="/root/main/cond/acntflagnm" class="input_default" style="left:320px; top:29px; width:130px; height:19px; "/>
			<caption id="caption2" class="search_name" style="left:500px; top:6px; width:86px; height:17px; ">물품코드 :</caption>
			<datagrid id="grd_mtallist" nodeset="/root/main/mtallist" caption="계정명^물품코드^물품코드^물품명^규격^모델^단위^전월수량^입고수량^출고수량^재고수량^단가^전월금액^입고금액^출고금액^재고금액^비고^기관코드^계정코드" colsep="^" colwidth="100, 80, 26, 170, 100, 100, 57, 60, 60, 60, 60, 79, 100, 100, 100, 100, 100, 100, 100" frozencols="6" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:80px; width:1195px; height:660px; ">
				<col ref="acntflagnm"/>
				<col ref="goodcd"/>
				<col ref="allsizespecid"/>
				<col ref="goodnm"/>
				<col ref="goodspec"/>
				<col ref="goodmodel"/>
				<col ref="deliveunit"/>
				<col ref="trnsqty" format="(-)#,###" style="text-align:right; "/>
				<col ref="inputqty" format="(-)#,###" style="text-align:right; "/>
				<col ref="outputqty" format="(-)#,###" style="text-align:right; "/>
				<col ref="endmonqty" format="(-)#,###" style="text-align:right; "/>
				<col ref="inunitcost" format="(-)#,###" style="text-align:right; "/>
				<col ref="trnsamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="inputamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="outputamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="endmonamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="cmt" visibility="hidden"/>
				<col ref="instcd" visibility="hidden"/>
				<col ref="acntflag" visibility="hidden"/>
			</datagrid>
			<input id="ipt_goodcd" ref="/root/main/cond/goodcd" style="left:590px; top:6px; width:100px; height:19px; "/>
			<caption id="caption3" class="search_name" style="left:500px; top:29px; width:83px; height:17px; ">물 품 명 :</caption>
			<input id="ipt_goodnm" ref="/root/main/cond/goodnm" style="left:590px; top:29px; width:160px; height:19px; "/>
			<input id="ipt_acntflag" ref="/root/main/cond/acntflag" visibility="hidden" style="left:315px; top:55px; width:100px; height:19px; "/>
			<button id="button1" class="btn2_letter4" style="left:1130px; top:55px; 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_mtallist.saveExcel(fileName, "자재수불증감분석");
						}
					]]>
				</script>
			</button>
			<caption id="caption10" class="search_name" style="left:810px; top:29px; width:87px; height:17px; ">구매구분 :</caption>
			<select1 id="cmb_purcflag" ref="/root/main/cond/purcflag" class="combo_default" appearance="minimal" style="left:895px; top:29px; width:110px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/purcflag">
						<label ref="cdnm"/>
						<value ref="cdid"/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						btn_search.dispatch("DOMActivate");
						]]>
				</script>
			</select1>
		</group>
		<group id="group1" style="left:0px; top:12; width:1195px; height:27px; ">
			<button id="btn_print" class="btn6_letter5" style="left:0px; top:3px; width:92px; height:22px; ">
				<caption>리스트출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
									fSaveExcel() ;	// 불출 재고 현황 Excel 저장처리 

								// exeReportPreview("RPRST05301", "XMLSTR");
					]]>
				</script>
			</button>
			<line id="line17" class="line_6" style="x1:0px; y1:25px; x2:1195px; y2:25px; "/>
		</group>
	</xhtml:body>
</xhtml:html>