YNU_JEUS/app_home/himed/webapps/mis/stocsumweb/xrw/SMRST01300_재고종합조회.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>
							<goodwin>
								<goodwinlist/>
							</goodwin>
							<gooddelive>
								<gooddelivelist/>
							</gooddelive>
							<goodsum>
								<goodsumlist/>
							</goodsum>
							<goodstoc>
								<goodstoclist/>
							</goodstoc>
						</list>
					</main>
					<init>
						<stocsumqty/>
					</init>
					<send>
						<goodiolist>
							<instcd/>
							<goodflag/>
							<deptcd/>
							<deptnm/>
							<goodcd/>
							<goodnm/>
							<goodspec/>
							<goodmodel/>
							<prodcmpynm/>
							<iofrdd/>
							<iotodd/>
							<stocym/>
							<lrgcd/>
							<lrgnm/>
						</goodiolist>
						<goodstoc>
							<instcd/>
							<goodcd/>
						</goodstoc>
					</send>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					//화면 Control을 초기화한다
					fInitialize();	
				]]>
			</script>
			<submission id="TRRSI01301" ref="/root/send/goodiolist" method="post" mediatype="application/x-www-form-urlencoded" resultref="/root/main/list/goodwin"/>
			<submission id="TRRST01301" ref="/root/send/goodiolist" method="post" mediatype="application/x-www-form-urlencoded" resultref="/root/main/list/goodstoc"/>
			<submission id="TRRSO01301" ref="/root/send/goodiolist" method="post" mediatype="application/x-www-form-urlencoded" resultref="/root/main/list/gooddelive"/>
			<submission id="TRRST01302" ref="/root/send/goodiolist" method="post" mediatype="application/x-www-form-urlencoded" resultref="/root/main/list/goodsum"/>
		</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/commonweb/js/dateHelper.js"/>
		<script type="javascript">
			<![CDATA[
			// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
			function fInitialize() {	
				rszfUserGoodFlagList(cmb_goodflag,getUserInfo("userid"));
				rszfUserInstList(cmb_instcd,getUserInfo("userid"));
				model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
				model.setValue(ipt_deptcd.attribute("ref") , getUserInfo("dutplcecd"));
				model.setValue(ipt_deptnm.attribute("ref") , getUserInfo("dutplcenm"));
				
				var curdate = getCurrentDate();
				var cvtdate = curdate.toDate("YYYYMMDD");
				
				model.setValue(ipt_frdd.attribute("ref") ,cvtdate.getAddDate(-10,"D").getDateFormat("YYYYMMDD"));
				model.setValue(ipt_todd.attribute("ref") , curdate);

				misfGridInit(grd_win);
				misfGridInit(grd_gooddelive);
				misfGridInit(grd_stoclist);
				misfGridInit(grd_goodsum);
				
				misfMsterDetailSet(grd_win,null, "TRRSI01301" ,"N"); 
				misfMsterDetailSet(grd_gooddelive,null, "TRRSO01301" ,"N"); 
				misfMsterDetailSet(grd_stoclist,null, "TRRST01301" ,"N"); 
				misfMsterDetailSet(grd_goodsum,null, "TRRST01302" ,"N"); 

				grd_stoclist.subtotalposition = "after";
				model.refresh();
			}
			function fRetrevie()
			{
				if(fCheckRetrieveData() == false)return;
				misfGridInit(grd_win);
				misfGridInit(grd_gooddelive);
				misfGridInit(grd_stoclist);
				misfGridInit(grd_goodsum);
				misfMsterDetailRetrieve();	

				grd_stoclist.subtotal("clear", 0, 0);
				//grd_stoclist.subtotal("sum", grd_stoclist.colRef("instcd"), grd_stoclist.colRef("stocqty"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 0, "합계");	
				grd_stoclist.subtotal("sum", 0, 2, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");	

			}
			function fCheckRetrieveData()
			{
				if(model.getValue(cmb_instcd.attribute("ref")).length== 0 )
				{
					model.setFocus("cmb_instcd");
					return false;
				}				
				if(model.getValue(cmb_goodflag.attribute("ref")).length== 0 )
				{
					model.setFocus("cmb_goodflag");
					return false;
				}				
				if(model.getValue(ipt_frdd.attribute("ref")).length== 0 )
				{
					model.setFocus("ipt_frdd");
					return false;
				}	
				
				if(model.getValue(ipt_todd.attribute("ref")).length== 0 )
				{
					model.setFocus("ipt_todd");
					return false;
				}	
				if(model.getValue(ipt_goodcd.attribute("ref")).length== 0 )
				{
					model.setFocus("ipt_goodcd");
					return false;
				}	
			}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:189px; height:14px; ">재고종합조회</caption>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:38px; width:1195px; height:702px; ">
			<line id="line7" class="line_2" style="x1:0px; y1:581px; x2:594px; y2:581px; "/>
			<line id="line3" class="line_2" style="x1:0px; y1:557px; x2:594px; y2:557px; "/>
			<line id="line2" class="line_2" style="x1:0px; y1:533px; x2:594px; y2:533px; "/>
			<line id="line8" class="line_3" style="x1:0px; y1:605px; x2:594px; y2:605px; "/>
			<caption id="caption21" class="tit_2" style="left:5px; top:81px; width:188px; height:13px; ">입고내역</caption>
			<group id="group6" style="left:0px; top:10px; width:1195px; height:61px; vertical-align:top; ">
				<shape id="roundrect3" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:61px; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="button4" navindex="8" class="btn1_letter2" style="left:1124px; top:20px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						fRetrevie();
						]]>
					</script>
				</button>
				<line id="line14" class="line_4" style="x1:1109px; y1:9px; x2:1109px; y2:52px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption10" class="search_name" style="left:15px; top:9px; width:97px; height:17px; ">기관코드 :</caption>
				<caption id="caption4" class="search_name" style="left:15px; top:36px; width:86px; height:17px; ">입출기간 :</caption>
				<caption id="caption7" class="search_name" style="left:712px; top:9px; width:93px; height:17px; ">부     서 :</caption>
				<select1 id="cmb_instcd" ref="/root/send/goodiolist/instcd" class="combo_s_essential" appearance="minimal" style="left:100px; top:8px; width:113px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/instcd">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</select1>
				<input id="ipt_frdd" ref="/root/send/goodiolist/iofrdd" class="input_s_essential" inputtype="date" style="left:100px; top:35px; width:118px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						
						]]>
					</script>
				</input>
				<input id="ipt_todd" ref="/root/send/goodiolist/iotodd" class="input_s_essential" inputtype="date" style="left:238px; top:35px; width:118px; height:19px; "/>
				<caption id="caption11" class="search_n_b" style="left:222px; top:38px; width:12px; height:17px; font-weight:bolder; ">~</caption>
				<input id="ipt_deptcd" ref="/root/send/goodiolist/deptcd" class="input_s_default" style="left:796px; top:8px; width:78px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							if(ipt_deptcd.value.length == 0) 
								ipt_deptnm.value = "";
							else 
								rszfValidationCheck("TRRPZ00201", "deptcodelist", "refcond,deptcd", 
										    	       "deptcd," + ipt_deptcd.value, "", "deptcd,deptnm",
												ipt_deptcd, "SPRPZ00200", "","");
							model.refresh();
						]]>
					</script>
				</input>
				<button id="button1" class="icon_search" style="left:876px; top:8px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						var recv_list = "deptcd,deptnm";
						misfOpenPopUpList("02", ipt_deptcd,"", recv_list) ; 	
						model.refresh();
						]]>
					</script>
				</button>
				<input id="ipt_deptnm" ref="/root/send/goodiolist/deptnm" class="input_fix" appearance="input" style="left:894px; top:8px; width:186px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							if(ipt_deptnm.value.length == 0) 
								ipt_deptcd.value = "";
							else 
								rszfValidationCheck("TRRPZ00201", "deptcodelist", "refcond,deptnm", 
										      "deptnm," + ipt_deptnm.value, "", "deptcd,deptnm",
											ipt_deptnm, "SPRPZ00200", "","");
						model.refresh();
						]]>
					</script>
				</input>
				<caption id="caption9" class="search_name" style="left:381px; top:9px; width:93px; height:17px; ">물품구분 :</caption>
				<select1 id="cmb_goodflag" ref="/root/send/goodiolist/goodflag" class="combo_s_essential" appearance="minimal" style="left:466px; top:8px; width:133px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/goodflag">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</select1>
				<button id="btn_searchgoodcd" class="icon_search" style="left:582px; top:36px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						rszfOpenPopUpListByWndName(ipt_goodcd,"","goodcd,goodnm,goodspec,goodmodel,prodcmpynm","SPRSD00210","instcd,goodflag","cmb_instcd,cmb_goodflag");
						model.refresh();
						]]>
					</script>
				</button>
				<output id="opt_goodspec" ref="/root/send/goodiolist/goodspec" class="output_fix" appearance="output" style="left:796px; top:35px; width:78px; height:19px; "/>
				<input id="input9" class="input_s_essential" style="left:600px; top:35px; width:107px; height:19px; "/>
				<input id="ipt_goodcd" ref="/root/send/goodiolist/goodcd" class="input_s_essential" _chartype="upper" style="left:466px; top:35px; width:113px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							if(ipt_goodcd.value.length == 0) 
							{
						 	 	ipt_goodnm.value = "";
						 	 	opt_goodspec.value = "";
						 	 	opt_goodmodel.value = "";
						 	 	opt_prodcmpynm.value = "";
							}
							else 
								rszfValidationCheck("TRRSD00191", "goodlist" , "refcond,instcd,goodflag,goodcd,goodnm,indexgb,indexnm",
												"goodcd," + model.getValue(cmb_instcd.attribute("ref")) + "," +model.getValue(cmb_goodflag.attribute("ref")) + "," +  model.getValue(ipt_goodcd.attribute("ref")) + ",,,," ,"","goodcd,goodnm,goodspec,goodmodel,prodcmpynm",
												ipt_goodcd,"SPRSD00190","instcd,goodflag","cmb_instcd,cmb_goodflag" ,"Y");
							model.refresh();	
						]]>
					</script>
					<script type="javascript" ev:event="onkeydown">
						<![CDATA[
							if (event.keyCode == 13)
							{
								ipt_goodcd.value = ipt_goodcd.currentText;
								ipt_goodcd.refresh();
								ipt_goodcd.dispatch("xforms-value-changed");
							}
						
						]]>
					</script>
				</input>
				<caption id="caption1" class="search_name" style="left:381px; top:36px; width:86px; height:17px; ">물품코드 :</caption>
				<output id="opt_goodmodel" ref="/root/send/goodiolist/goodmodel" class="output_fix" appearance="output" style="left:876px; top:35px; width:96px; height:19px; "/>
				<input id="ipt_goodnm" ref="/root/send/goodiolist/goodnm" class="input_fix" appearance="input" style="left:600px; top:35px; width:195px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							if(ipt_goodnm.value.length == 0) 
							{
						 	 	ipt_goodcd.value = "";
						 	 	opt_goodspec.value = "";
						 	 	opt_goodmodel.value = "";
						 	 	opt_prodcmpynm.value = "";
							}
							else 
								rszfValidationCheck("TRRSD00191", "goodlist" , "refcond,instcd,goodflag,goodnm",
												"goodnm," + model.getValue(cmb_instcd.attribute("ref")) + "," + model.getValue(cmb_goodflag.attribute("ref")) + "," +  model.getValue(ipt_goodnm.attribute("ref")) ,"","goodcd,goodnm,goodspec,goodmodel,prodcmpynm",
												ipt_goodcd,"SPRSD00210","instcd,goodflag","cmb_instcd,cmb_goodflag");
							model.refresh();	
						]]>
					</script>
					<script type="javascript" ev:event="onkeydown">
						<![CDATA[
							if (event.keyCode == 13)
							{
								ipt_goodnm.value = ipt_goodnm.currentText;
								ipt_goodnm.refresh();
								ipt_goodnm.dispatch("xforms-value-changed");
							}
						
						]]>
					</script>
				</input>
				<output id="opt_prodcmpynm" ref="/root/send/goodiolist/prodcmpynm" class="output_fix" appearance="output" style="left:973px; top:35px; width:108px; height:19px; "/>
			</group>
			<line id="line15" class="line_1" style="x1:0px; y1:95px; x2:730; y2:95px; "/>
			<datagrid id="grd_win" nodeset="/root/main/list/goodwin/goodwinlist" caption="입고일자^번호^순번^입고유형^규격^수량^단가^금액^보조거래처^주거래처" colwidth="67, 48, 48, 72, 100, 62, 80, 73, 120, 116, 100, 100" dataheight="25" ellipsis="true" mergecellsfixedrows="bycolrec" rowsep="|" colsep="^" style="left:0px; top:100px; width:730; height:387px; ">
				<col ref="windd" format="yyyy-mm-dd"/>
				<col ref="winno" style="text-align:center; "/>
				<col ref="winseqno" style="text-align:center; "/>
				<col ref="iokindnm" format="#,###" style="text-align:left; "/>
				<col ref="goodspec"/>
				<col ref="winqty" style="text-align:right; "/>
				<col ref="winunitcost" format="#,###" style="text-align:right; "/>
				<col ref="winamt" format="#,###" style="text-align:right; "/>
				<col ref="subsuplplcenm"/>
				<col ref="suplplcenm"/>
				<col ref="instcd" visibility="hidden"/>
				<col ref="goodcd" visibility="hidden"/>
			</datagrid>
			<datagrid id="grd_gooddelive" nodeset="/root/main/list/gooddelive/gooddelivelist" caption="출고일자^번호^순번^출고유형^규격^수량^입고부서" colwidth="84, 43, 42, 75, 81, 58, 86" dataheight="25" ellipsis="true" mergecellsfixedrows="bycolrec" rowsep="|" colsep="^" style="left:735px; top:100px; width:460px; height:387px; ">
				<col ref="delivedd" format="yyyy-mm-dd"/>
				<col ref="deliveno" style="text-align:center; "/>
				<col ref="deliveseqno" style="text-align:center; "/>
				<col ref="iokindnm"/>
				<col ref="goodspec"/>
				<col ref="delivedeptqty" format="#,###" style="text-align:right; "/>
				<col ref="windeptnm"/>
			</datagrid>
			<line id="line1" class="line_1" style="x1:735px; y1:95px; x2:1195; y2:95px; "/>
			<caption id="caption3" class="tit_2" style="left:740; top:81px; width:188px; height:13px; ">출고내역</caption>
			<datagrid id="grd_stoclist" nodeset="/root/main/list/goodstoc/goodstoclist" caption="caption1^부서^수     량" colwidth="53, 279, 225" dataheight="25" mergecellsfixedrows="bycolrec" rowsep="|" colsep="^" style="left:599px; top:511px; width:596px; height:181px; ">
				<col ref="instcd" visibility="hidden"/>
				<col ref="stocdeptnm"/>
				<col ref="stocqty" style="text-align:right; "/>
			</datagrid>
			<line id="line5" class="line_1" style="x1:599px; y1:506px; x2:1195; y2:506px; "/>
			<caption id="caption5" class="tit_2" style="left:604px; top:492px; width:188px; height:13px; ">부서별 ONLINE 재고</caption>
			<output id="ss" ref="/root/main/list/goodsum/goodsumlist/brngfwrdqty" class="output_fix" appearance="output" style="left:87px; top:513px; width:140px; height:19px; text-align:right; "/>
			<caption id="caption13" class="tit_2" style="left:5px; top:492px; width:188px; height:13px; ">입출고 합계</caption>
			<line id="line6" class="line_1" style="x1:0px; y1:506px; x2:594px; y2:506px; "/>
			<output id="output1" ref="/root/main/list/goodsum/goodsumlist/winqty" class="output_fix" appearance="output" style="left:87px; top:537px; width:140px; height:19px; text-align:right; "/>
			<output id="output2" ref="/root/main/list/goodsum/goodsumlist/winamt" class="output_fix" appearance="output" style="left:230px; top:537px; width:165px; height:19px; text-align:right; "/>
			<output id="output3" ref="/root/main/list/goodsum/goodsumlist/deliveqty" class="output_fix" appearance="output" style="left:87px; top:561px; width:140px; height:19px; text-align:right; "/>
			<datagrid id="grd_goodsum" nodeset="/root/main/list/goodsum/goodsumlist" visibility="hidden" caption="이월수량^입고수량^입고금액^출고합계^재고수량" colwidth="80, 80, 100, 100, 100" dataheight="25" mergecellsfixedrows="bycolrec" rowsep="|" colsep="^" style="left:385px; top:545px; width:410px; height:95px; ">
				<col ref="brngfwrdqty"/>
				<col ref="winqty"/>
				<col ref="winamt"/>
				<col ref="deliveqty"/>
				<col ref="stocqty"/>
			</datagrid>
			<output id="output4" ref="/root/main/list/goodsum/goodsumlist/stocqty" class="output_fix" appearance="output" style="left:87px; top:585px; width:140px; height:19px; text-align:right; "/>
			<caption id="caption2" class="cell_1" style="left:0px; top:511px; width:85px; height:23px; vertical-align:middle; ">이월수량</caption>
			<caption id="caption16" class="cell_1" style="left:0px; top:535px; width:85px; height:23px; vertical-align:middle; ">입고합계</caption>
			<caption id="caption17" class="cell_1" style="left:0px; top:559px; width:85px; height:23px; vertical-align:middle; ">출고합계</caption>
			<caption id="caption18" class="cell_1" style="left:0px; top:583px; width:85px; height:23px; vertical-align:middle; ">재고수량</caption>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
			<button id="btn_init" class="btn4_letter3" style="left:1127px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					fInitialize();	
					]]>
				</script>
			</button>
			<line id="line4" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
		</group>
	</xhtml:body>
</xhtml:html>