YNU_JEUS/app_home/himed/webapps/mis/stocsumweb/xrw/SMRST02800_품목별 입출고현황 출력.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>
						<instcd/>
						<goodflag/>
						<stocdeptcd/>
						<stocdeptnm/>
						<stocym/>
						<prtflag>B</prtflag>
						<goodcd/>
						<goodnm/>
					</cond>
					<main>
						<goodinoutinfo>
							<goodinoutlist>
								<stkdeptnm/>
								<goodcd/>
								<goodnm/>
								<purcunit/>
								<unitcost/>
								<beftotqty/>
								<beftotamt/>
								<winqty/>
								<winamt/>
								<outqty/>
								<outamt/>
								<stocqty/>
								<stocamt/>
							</goodinoutlist>
						</goodinoutinfo>
					</main>
					<send>
						<reqdata/>
					</send>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					//화면 Control을 초기화한다
					fInitialize();	
				]]>
			</script>
			<submission id="TRRSD00192" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/goodiolist" resultref="/root/init/main"/>
			<submission id="TRRST02802" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/cond" resultref="/root/main/goodinoutinfo"/>
		</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/purccommonweb/js/PURC.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
		<script type="javascript">
			<![CDATA[
			// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
			function fInitialize() {		
			
						
				rszfUserInstList(cmb_instcd,getUserInfo("userid"));			

				model.setValue(cmb_instcd.attribute("ref") 	   , getUserInfo("dutplceinstcd"));
				
				var curdate = getCurrentDate().substring(0,6);
				model.setValue(ipt_stocym.attribute("ref") ,curdate);
				grd_goodinoutlist.colHidden(grd_goodinoutlist.colRef("stkdeptnm"))=true;
				misfGridInit(grd_goodinoutlist);
			
				model.refresh();
			}
			//필수항목 체크하는 메소드
			function fCheckRetrieveData()
			{
				if(!isRequiredControls("cmb_instcd") )return false;		// 기관코드 , commonweb/js/tfHelper.js
				if(!isRequiredControls("cmb_goodflag") )return false;		// 물품구분
				if(!isRequiredControls("ipt_stocym") )return false;		// 기준년월
				//if(!isRequiredControls("ipt_delivetodd") )return false;		// 출고종료일자
				//if(!isRequiredControls("cmb_stocdeptcd") )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:1195; 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:744px; ">
			<caption id="caption21" class="tit_2" style="left:5px; top:83px; width:216px; height:13px; ">품목별 입출고현황</caption>
			<group id="group6" style="left:0px; top:13px; width:1195px; height:61; 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; "/>
				<caption id="cap_instcd" class="search_name" style="left:15px; top:9; width:93px; height:17px; ">기관코드 :</caption>
				<caption id="cap_stocym" class="search_name" style="left:323px; top:9px; width:93px; height:17px; ">기 준 월 :</caption>
				<caption id="cap_prtflag" class="search_name" style="left:595px; top:9px; width:112px; height:17px; ">조회구분 :</caption>
				<select1 id="cmb_instcd" ref="/root/cond/instcd" class="combo_s_essential" disabled="true" appearance="minimal" style="left:100px; top:8px; width:141px; height:19px; text-align:center; ">
					<choices>
						<itemset nodeset="/root/init/instcd">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</select1>
				<input id="ipt_stocym" ref="/root/cond/stocym" class="input_s_essential" inputtype="date" maxlength="4" format="yyyy-mm" style="left:406px; top:8px; width:105px; height:19px; "/>
				<select1 id="rdo_prtflag" ref="/root/cond/prtflag" appearance="full" cellspacing="20" cols="2" overflow="visible" style="left:688px; top:10px; width:207px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>불출부서별</label>
							<value>A</value>
						</item>
						<item>
							<label>약품코드별</label>
							<value>B</value>
						</item>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						var vPrtFlag = model.getValue("/root/cond/prtflag");
						
						if(vPrtFlag =="A"){
							grd_goodinoutlist.colHidden(grd_goodinoutlist.colRef("stkdeptnm"))=false;
							grd_goodinoutlist.colHidden(grd_goodinoutlist.colRef("goodcd"))=true;
							grd_goodinoutlist.colHidden(grd_goodinoutlist.colRef("goodnm"))=true;
							grd_goodinoutlist.colHidden(grd_goodinoutlist.colRef("purcunit"))=true;
							grd_goodinoutlist.colHidden(grd_goodinoutlist.colRef("unitcost"))=true;
							ipt_goodcd.disabled = true;
							btn_searchgoodcd.disabled =true;
							ipt_goodnm.disabled = true;
						}else if(vPrtFlag =="B"){
							grd_goodinoutlist.colHidden(grd_goodinoutlist.colRef("stkdeptnm"))=true;
							grd_goodinoutlist.colHidden(grd_goodinoutlist.colRef("goodcd"))=false;
							grd_goodinoutlist.colHidden(grd_goodinoutlist.colRef("goodnm"))=false;
							grd_goodinoutlist.colHidden(grd_goodinoutlist.colRef("purcunit"))=false;
							grd_goodinoutlist.colHidden(grd_goodinoutlist.colRef("unitcost"))=false;
							ipt_goodcd.disabled = false;
							btn_searchgoodcd.disabled =false;
							ipt_goodnm.disabled = false;
						}
						model.refresh();
						]]>
					</script>
				</select1>
				<button id="button3" class="icon_search" visibility="hidden" style="left:890px; top:35px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						var recv_list = "stocdeptcd,stocdeptnm";
						misfOpenPopUpList("02", ipt_stocdeptcd,"", recv_list) ; 	
						model.refresh();
						]]>
					</script>
				</button>
				<input id="ipt_stocdeptcd" ref="/root/cond/stocdeptcd" class="input_s_essential" visibility="hidden" style="left:810px; top:35px; width:78px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						misfValidationCheck("02", "", "stocdeptcd,stocdeptnm" );
						model.refresh();						
						]]>
					</script>
				</input>
				<input id="ipt_stocdeptnm" ref="/root/cond/stocdeptnm" class="input_s_essential" visibility="hidden" style="left:915px; top:35px; width:127px; height:19px; "/>
				<caption id="caption1" class="search_name" visibility="hidden" style="left:710px; top:35px; width:90px; height:17px; ">부     서 :</caption>
				<caption id="cap_goodflag" class="search_name" visibility="hidden" style="left:520px; top:35px; width:93px; height:17px; ">물품구분 :</caption>
				<select1 id="cmb_goodflag" ref="/root/cond/goodflag" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:605px; top:34px; width:141px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/goodflag">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</select1>
				<button id="button4" class="btn1_letter2" navindex="8" style="left:1125px; top:20px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						submit("TRRST02802");
						]]>
					</script>
				</button>
				<line id="line14" class="line_4" style="x1:1110px; y1:9px; x2:1110px; y2:52px; border-color:#ffe4bb; border-left-style:solid; "/>
				<input id="ipt_goodnm" ref="/root/cond/goodnm" class="input_fix" appearance="input" style="left:234px; top:34px; width:215px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							if(ipt_goodnm.value.length == 0) 
							{
						 	 	ipt_goodcd.value = "";
							}
							else {
								model.setValue("/root/cond/goodcd",  "")								
								btn_searchgoodcd.dispatch("DOMActivate");
							}
							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>
				<button id="btn_searchgoodcd" class="icon_search" style="left:215px; top:35px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						
						model.makeValue("/root/send/goodiolist/instcd"	,model.getValue("/root/cond/instcd"));
						// [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH) 
						model.makeValue("/root/send/goodiolist/goodflag","PH");
						model.makeValue("/root/send/goodiolist/goodcd"	,model.getValue("/root/cond/goodcd"));
						model.makeValue("/root/send/goodiolist/goodnm"	,model.getValue("/root/cond/goodnm"));
						
						if (submit("TRRSD00192") == true) {
							var nodecnts = getNodesetCount("/root/init/main/goodlist");

							if (nodecnts >= "2") {
								group2.visible = true;
							} else if (nodecnts == "1") {
						
								var goodcd = model.getValue("/root/init/main/goodlist/goodcd");
								var goodnm = model.getValue("/root/init/main/goodlist/goodnm");
																			
								model.setValue("/root/cond/goodcd"	, goodcd)
								model.setValue("/root/cond/goodnm"	, goodnm)
							} else { 
								messageBox("검색된 코드가 없습니다.", "I");
							}
							
						}
						model.refresh();
						]]>
					</script>
				</button>
				<input id="ipt_goodcd" ref="/root/cond/goodcd" class="input_s_essential" _chartype="upper" style="left:100px; top:34px; width:111px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						   						
							if(ipt_goodcd.value.length == 0) 
							{
						 	 	ipt_goodnm.value = "";
							}
							else {
								model.setValue("/root/cond/goodnm"				,  "")								
								btn_searchgoodcd.dispatch("DOMActivate");
							}
							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="caption2" class="search_name" style="left:15px; top:35px; width:95px; height:17px; ">약품코드 :</caption>
			</group>
			<line id="line15" class="line_1" style="x1:0px; y1:98px; x2:1195px; y2:98px; "/>
			<datagrid id="grd_goodinoutlist" nodeset="/root/main/goodinoutinfo/goodinoutlist" caption="불출부서^물품코드^품명 및 규격^단     위^단     가^전월재고^전월재고^입고량^입고량^출고량^출고량^재고량^재고량|불출부서^물품코드^품명 및 규격^단     위^단     가^수량^금액^수량^금액^수량^금액^수량^금액" colsep="^" colwidth="115, 91, 314, 56, 102, 60, 72, 60, 62, 60, 64, 60, 78" dataheight="25" ellipsis="true" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:103px; width:1195px; height:631px; ">
				<col ref="stkdeptnm" style="text-align:center; "/>
				<col ref="goodcd" style="text-align:left; "/>
				<col ref="goodnm" style="text-align:left; "/>
				<col ref="purcunit" style="text-align:right; "/>
				<col ref="unitcost" format="#,###.##" style="text-align:right; "/>
				<col ref="beftotqty" style="text-align:right; "/>
				<col ref="beftotamt" format="#,###.##" style="text-align:right; "/>
				<col ref="winqty" style="text-align:right; "/>
				<col ref="winamt" format="#,###.##" style="text-align:right; "/>
				<col ref="outqty" style="text-align:right; "/>
				<col ref="outamt" format="#,###.##" style="text-align:right; "/>
				<col ref="stocqty" style="text-align:right; "/>
				<col ref="stocamt" format="#,###.##" style="text-align:right; "/>
			</datagrid>
			<button id="button1" class="btn2_letter6" style="left:1108px; top:77px; width:86px; height:19px; ">
				<caption>엑셀파일저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					misfSaveExcel(grd_goodinoutlist , "품목별입출고현황출력");
					]]>
				</script>
			</button>
			<button id="button2" class="btn2_letter6" visibility="hidden" style="left:1020px; top:77px; width:86px; height:19px; ">
				<caption>엑셀파일열기</caption>
			</button>
			<group id="group2" visibility="hidden" style="left:55px; top:75px; width:415px; height:165px; ">
				<datagrid id="grd_goodlist" nodeset="/root/init/main/goodlist" visibility="visible" caption="약품코드^약품명^기관코드^물품구분^작업년월^부서코드^대분류코드^재고조정처리여부" colsep="^" colwidth="102, 270, 0, 0" dataheight="25" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:25px; width:410px; height:139px; ">
					<col imemode="alpha" ref="goodcd" type="output" _chartype="upper" _key="true" style="left:161px; top:25px; width:115px; height:25px; text-align:left; "/>
					<col ref="goodnm" type="output" style="text-align:left; "/>
					<col ref="instcd" visibility="hidden" _key="true"/>
					<col ref="goodflag" visibility="hidden" _key="true"/>
					<script type="javascript" ev:event="ondblclick">
						<![CDATA[
						if (isDataCell() == true) {
						
							var goodcd = model.getValue("/root/init/main/goodlist[" + grd_goodlist.row + "]/goodcd");
							var goodnm = model.getValue("/root/init/main/goodlist[" + grd_goodlist.row + "]/goodnm");
						
							model.setValue("/root/cond/goodcd"	, goodcd)
							model.setValue("/root/cond//goodnm"	, goodnm)
						
							group2.visible = false;
						}
						ipt_goodcd.refresh();
						ipt_goodnm.refresh();
					]]>
					</script>
				</datagrid>
				<button id="button5" class="btn2_letter3" style="left:340px; top:4px; width:53px; height:19px; ">
					<caption>숨기기</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							group2.visible = false
						]]>
					</script>
				</button>
			</group>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:12; width:1195px; height:27px; ">
			<button id="button46" class="btn6_letter2" visibility="hidden" style="left:0; top:3px; width:56px; height:22px; font-size:10pt; ">
				<caption>출력</caption>
			</button>
			<line id="line1" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<button id="btn_init" class="btn4_letter3" style="left:1127px; top:3; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[	
						fInitialize();
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>