YNU_JEUS/app_home/himed/webapps/lis/gooddelivemngtweb/xrw/SMLAW00800_입출고현황(시점).xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목		: SMLAW00700_입출고현황(년별).xrw
	* 설    명		: 입출고현황 
	* 설 계 자	        : (주)에이씨케이 - 
	* 작 성 자	        : (주)에이씨케이 - 송요셉 
	* 작 성 일	        : 2007.11.27
	* 수정이력	: 
	* 기    타	: 
-->
<?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>
						<goodtimelist>
							<goodcd/>
							<goodnm/>
							<allsizespecid/>
							<goodspec/>
							<purcunit/>
							<purcqty/>
							<useunitcd/>
							<useqty/>
							<tunitcost/>
							<tstocqty/>
							<tstocmon/>
							<twinqty/>
							<twinmon/>
							<tuseqty/>
							<tusemon/>
							<tadjtqty/>
							<tadjtmon/>
							<suppcustnm/>
						</goodtimelist>
					</main>
					<send>
						<deptcd/>
						<deptcdlist/>
						<goodflag/>
						<goodtext/>
					</send>
					<init>
						<deptinfo>
							<cd/>
						</deptinfo>
						<dept>
							<appdeptcd/>
						</dept>
						<appdeptcd/>
						<goodflag>0</goodflag>
						<goodtext/>
						<goodshop>0</goodshop>
						<custinfo>
							<custlist>
								<instcd/>
								<entrregno/>
								<custnm/>
							</custlist>
						</custinfo>
						<stocdd/>
						<popupmenu>
							<item>
								<funt>fExeUseQtyList</funt>
								<nm>불출내역보기</nm>
							</item>
						</popupmenu>
					</init>
					<hidden>
						<ref>
						</ref>
					</hidden>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../lis/commonweb/js/LPZ001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					 fExeInitialize();		
				]]>
			</script>
			<submission id="TRLAF00402" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/init/deptinfo"/>
			<submission id="TRLAA00103" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/init/dept/appdeptcd"/>
			<submission id="TRLAA00107" mediatype="application/x-www-form-urlencoded" method="post" replace="instance" resultref="/root/appdeptcd"/>
			<submission id="TRLAW00801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/goodtimelist"/>
			<submission id="TRLAW00802" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/init/custinfo/custlist"/>
		</model>
		<script type="javascript">
			<![CDATA[			
			
				/* @group	: 입출고현황(시점)
				 * @ver		: 2007.12.03 
				 * @by		: 송요셉(ACK)
				 * @-----------------------------------
				 * @type		: function
				 * @access	: public
				 * @desc		: 입출고목록 초기화면설정
				*/
				function fExeInitialize() {										
				
					//--------------------------------
					model.removeNodeset("/root/send");
					model.removeNodeset("/root/main/goodtimelist");					
					model.makeValue("/root/send/instcd",    getUserInfo("dutplceinstcd"));
					model.makeValue("/root/send/userid",    getUserInfo("userid"));
					submit("TRLAF00402", false);		// 사용자가 속한 과코드 조회
					
					model.makeValue("/root/send/posdeptcd", model.getValue("/root/init/deptinfo/cd"));
					submit("TRLAA00103", false); 			// 부서코드 목록 
					submit("TRLAW00802"); 				// 거래처 목록 

					//-----------------------------------------------------------------
					iMaxCnt = Number(getNodesetCount("/root/init/dept/appdeptcd")) + 1;
					//model.makeValue("/root/init/dept/appdeptcd["+iMaxCnt+"]/cd", "00");
					//model.makeValue("/root/init/dept/appdeptcd["+iMaxCnt+"]/nm", "전체");
					
					//----------------------
					//cmb_seadept.select(0);
					model.setValue("/root/init/appdeptcd", "-");
					//model.setValue("/root/init/goodflag",  "0");
					//model.setValue("/root/init/goodtext",  "");
					model.setValue("/root/init/goodshop",  "00");
					model.setValue("/root/init/stocdd",    getCurrentDate());
					model.refresh();
				}
				
				
							
				/* @group	: 입출고현황(시점)
				 * @ver		: 2007.12.03 
				 * @by		: 송요셉(ACK)
				 * @-----------------------------------
				 * @type		: function
				 * @access	: public
				 * @desc		: 입출고목록 엑셀파일저장
				*/
				function fExeSaveToExcel() {
					goodyearlist.saveExcel("C:\\SMLAW00800_입출고목록(시점).xls", "시점별입출고목록", false, true);
				}
				
				
				/* @group	: 입출고현황(시점)
				 * @ver		: 2007.12.03 
				 * @by		: 송요셉(ACK)
				 * @-----------------------------------
				 * @type		: function
				 * @access	: public
				 * @desc		: 입출고목록 조회
				*/
				function fGetGoodList() {
					
					//--------------------------------
					model.removeNodeset("/root/send");
					model.removeNodeset("/root/main/goodtimelist");			
								
					//--------------------------------------------------------------------
					model.makeValue("/root/send/instcd",    getUserInfo("dutplceinstcd"));
					model.makeValue("/root/send/posdeptcd", model.getValue("/root/init/deptinfo/cd"));
					model.makeValue("/root/send/dutdeptcd", model.getValue("/root/init/appdeptcd"));	
					model.makeValue("/root/send/goodflag",  model.getValue("/root/init/goodflag"));	
					model.makeValue("/root/send/goodtext",  model.getValue("/root/init/goodtext"));
					model.makeValue("/root/send/goodshop",  model.getValue("/root/init/goodshop"));
					model.makeValue("/root/send/stocdd",    model.getValue("/root/init/stocdd"));

					//-------------------
					submit("TRLAW00801");	
				}
				
				/* @group		: 입출고현황(시점)
				 * @ver		: 2008.12.08
				 * @by		: 유동철(ACK)
				 * @-----------------------------------
				 * @type		: function
				 * @access	: public
				 * @desc		: 출고상세내역 조회
				*/
				function fExeUseQtyList(pRow, pCol) {
					
					var sDate = model.getValue("/root/init/stocdd");
					setParameter("SPLAW00900_instcd",    getUserInfo("dutplceinstcd"));
					setParameter("SPLAW00900_posdeptcd", model.getValue("/root/init/deptinfo/cd"));
					setParameter("SPLAW00900_outdeptcd", model.getValue("/root/init/appdeptcd"));
					setParameter("SPLAW00900_goodshop",  model.getValue("/root/init/goodshop"));
					setParameter("SPLAW00900_fromdd",    sDate.substring(0,6)+"01");
					setParameter("SPLAW00900_todd",      sDate.substring(0,6)+"31");
					setParameter("SPLAW00900_goodcd",    model.getValue("/root/main/goodtimelist["+(Number(grd_goodtimelist.row)-1)+"]/goodcd"));
					setParameter("SPLAW00900_allsize",   model.getValue("/root/main/goodtimelist["+(Number(grd_goodtimelist.row)-1)+"]/allsizespecid"));
					modal("SPLAW00900");
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group3" scroll="auto" style="left:0px; top:40px; width:1195px; height:744; ">
			<line id="line1" class="line_1" style="x1:0px; y1:70px; x2:1194px; y2:70px; "/>
			<group id="group1" style="left:0px; top:10px; width:1195px; height:35px; font-weight:bold; ">
				<shape id="roundrect2" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1194px; height:35px; "/>
				<line id="line3" class="line_4" style="x1:1108px; y1:7px; x2:1108px; y2:29px; "/>
				<button id="btn_Ref" class="btn1_letter2" navindex="6" style="left:1123px; top:7px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fGetGoodList();	
						]]>
					</script>
				</button>
				<select1 id="cmb_seadept" ref="/root/init/appdeptcd" navindex="1" appearance="minimal" style="left:84px; top:8px; width:114px; height:19px; font-weight:normal; ">
					<choices>
						<itemset nodeset="/root/init/dept/appdeptcd">
							<label ref="nm"/>
							<value ref="cd"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption26" class="search_name" style="left:19px; top:9px; width:61px; height:17px; ">부서 :</caption>
				<caption id="caption1" class="search_name" style="left:309px; top:9px; width:68px; height:17px; ">검색 :</caption>
				<caption id="caption2" class="search_name" style="left:919px; top:9px; width:73px; height:17px; ">거래처 :</caption>
				<select1 id="cbo_seaflagcd" ref="/root/init/goodflag" disabled="true" navindex="2" appearance="minimal" style="left:375px; top:8px; width:80px; height:19px; font-weight:normal; ">
					<choices>
						<item>
							<label>물품코드</label>
							<value>0</value>
						</item>
						<item>
							<label>물품명</label>
							<value>1</value>
						</item>
					</choices>
				</select1>
				<input id="ipt_seaval" ref="/root/init/goodtext" navindex="3" style="left:458px; top:8px; width:100px; height:19px; font-weight:normal; "/>
				<select1 id="cbo_custlist" ref="/root/init/goodshop" navindex="5" appearance="minimal" style="left:996px; top:8px; width:99px; height:19px; font-weight:normal; ">
					<choices>
						<itemset nodeset="/root/init/custinfo/custlist">
							<label ref="custnm"/>
							<value ref="entrregno"/>
						</itemset>
					</choices>
				</select1>
				<input id="ipt_stocdd" ref="/root/init/stocdd" navindex="4" inputtype="date" format="yyyy-mm-dd" mask="exclude" showmask="true" style="left:745px; top:8px; width:100px; height:19px; "/>
				<caption id="caption4" class="search_name" style="left:655px; top:9px; width:86px; height:17px; ">기준일자 :</caption>
			</group>
			<caption id="caption3" class="tit_2" style="left:5px; top:55px; width:134px; height:14px; ">입출고목록</caption>
			<datagrid id="grd_goodtimelist" nodeset="/root/main/goodtimelist" caption="물품코드^물품명^ALL SIZE^거래처^규격^청구&#xA;단위^청구단위&#xA;수량^사용&#xA;단위^사용단위&#xA;수량^단가^재고^재고^입고^입고^출고^출고^재고보정^재고보정^3월^3월^3월^3월^3월^3월^3월^4월^4월^4월^4월^4월^4월^4월^5월^5월^5월^5월^5월^5월^5월^6월^6월^6월^6월^6월^6월^6월^7월^7월^7월^7월^7월^7월^7월^8월^8월^8월^8월^8월^8월^8월^9월^9월^9월^9월^9월^9월^9월^10월^10월^10월^10월^10월^10월^10월^11월^11월^11월^11월^11월^11월^11월^12월^12월^12월^12월^12월^12월^12월^합계^합계^합계^합계^합계^합계|물품코드^물품명^^거래처^규격^청구&#xA;단위^청구단위&#xA;수량^사용&#xA;단위^사용단위&#xA;수량^단가^수량^금액^수량^금액^수량^금액^수량^금액^단가^재고^재고^입고^입고^출고^출고^단가^재고^재고^입고^입고^출고^출고^단가^재고^재고^입고^입고^출고^출고^단가^재고^재고^입고^입고^출고^출고^단가^재고^재고^입고^입고^출고^출고^단가^재고^재고^입고^입고^출고^출고^단가^재고^재고^입고^입고^출고^출고^단가^재고^재고^입고^입고^출고^출고^단가^재고^재고^입고^입고^출고^출고^단가^재고^재고^입고^입고^출고^출고^재고^재고^입고^입고^출고^출고" colwidth="70, 180, 0, 100, 80, 50, 60, 50, 60, 60, 50, 60, 50, 60, 50, 60, 50, 60" dataheight="25" defaultrows="1" ellipsis="true" explorerbar="sortshow" frozencols="4" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" navindex="7" fixed.background-image="../../../com/commonweb/images/grid_bg.gif" style="left:0px; top:75px; width:1194px; height:665px; font-weight:normal; ">
				<col ref="goodcd" style="text-align:center; "/>
				<col ref="goodnm" style="text-align:left; "/>
				<col ref="allsizespecid"/>
				<col ref="suppcustnm"/>
				<col class="text_center" ref="goodspec"/>
				<col class="text_center" ref="purcunit"/>
				<col ref="purcqty" format="(-)#,###" style="text-align:right; "/>
				<col class="text_center" ref="useunitcd"/>
				<col class="text_center" ref="useqty" format="(-)#,###"/>
				<col ref="tunitcost" format="(-)#,###" style="text-align:right; "/>
				<col ref="tstocqty" format="(-)#,###" style="text-align:right; "/>
				<col ref="tstocmon" format="(-)#,###" style="text-align:right; "/>
				<col ref="twinqty" format="(-)#,###" style="text-align:right; "/>
				<col ref="twinmon" format="(-)#,###" style="text-align:right; "/>
				<col ref="tuseqty" format="(-)#,###" style="text-align:right; "/>
				<col ref="tusemon" format="(-)#,###" style="text-align:right; "/>
				<col ref="tadjtqty"/>
				<col ref="tadjtmon"/>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_goodtimelist.gridToInstance();
					]]>
				</script>
				<script type="javascript" ev:event="onmousedown">
					<![CDATA[
						setPopupMenu("grd_goodtimelist", false, "/root/init/popupmenu/item", "nm", "funt");
					]]>
				</script>
				<script type="javascript" ev:event="DOMFocusOut">
					<![CDATA[
						initPopupMenu();
					]]>
				</script>
			</datagrid>
		</group>
		<group id="group2" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">입출고현황(시점)</caption>
		</group>
		<group id="grp_btn" style="left:0px; top:13px; width:1195px; height:27px; ">
			<line id="line32" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
			<button id="button13" class="btn6_letter5" navindex="8" style="left:0px; top:3px; width:92px; height:22px; ">
				<caption>EXCEL출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						//fExeSaveToExcel();	
						lpzfExeSaveToExcel(grd_goodtimelist, "입출고현황(시점)");		
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>