YNU_JEUS/app_home/himed/webapps/mis/stocsumweb/xrw/SMRST05900_자재수불증감분석.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>
							<winacntnm/>
							<befinputamt/>
							<inputamt/>
							<befyyinputamt/>
							<befyyinputavg/>
							<subinputamt/>
							<cmt/>
						</mtallist>
					</main>
					<send>
						<goodreq>
							<instcd/>
							<inputmonth/>
						</goodreq>
						<savedata/>
					</send>
					<init>
					</init>
					<temp/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();
				]]>
			</script>
			<submission id="TRRST05901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/goodreq" resultref="/root/main/mtallist"/>
			<submission id="TXRST05901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/savedata" resultref="/root/temp"/>
		</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() 
				{	
					rszfUserReqInstList(cmb_instcd,getUserInfo("userid"),"%","B");
					cmb_instcd.refresh();
					
					model.setValue(cmb_instcd.attribute("ref"), getUserInfo("dutplceinstcd"));
					cmb_instcd.refresh();
					
					model.setValue(ipt_inputmonth.attribute("ref"), getCurrentDate().substr(0, 6));
					
					ipt_inputmonth.refresh();
					
					fSetGridTitle();
				}
				
				function fSetGridTitle() {
					var inputmonth = model.getValue(ipt_inputmonth.attribute("ref"));
					var inputnm = inputmonth.substr(2,2) + "년 " + String(Number(inputmonth.substr(4,2))) + "월입고";
					
					var befinputnm;
					var tmp;
					
					if(inputmonth.substr(4, 2) == "01") {
						tmp = String(Number(inputmonth.substr(0,4)) - 1);
						befinputnm = tmp.substr(2,2) + "년 " + "12월입고";
					
					} else {
						befinputnm = inputmonth.substr(2,2) + "년 " + String(Number(inputmonth.substr(4,2)) - 1) + "월입고";
					}
					
					grd_mtallist.valueMatrix(0, grd_mtallist.colRef("befinputamt"))   = befinputnm;
					grd_mtallist.valueMatrix(0, grd_mtallist.colRef("inputamt"))      = inputnm;
					grd_mtallist.valueMatrix(0, grd_mtallist.colRef("befyyinputamt")) = "전년 " + String(Number(inputmonth.substr(4, 2))) + "월입고";
					
				}
								
			]]>
		</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:12px; width:1195px; height:744px; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:40px; "/>
			<select1 id="cmb_instcd" ref="/root/send/goodreq/instcd" class="combo_s_essential" appearance="minimal" style="left:95px; top:19px; 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:19px; width:91px; height:17px; ">기관코드 :</caption>
			<line id="line14" class="line_4" style="x1:1060px; y1:17px; x2:1060px; y2:44px; "/>
			<button id="btn_search" class="btn1_letter2" navindex="7" style="left:1070px; top:20px; width:56px; height:22px; text-align:left; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[	
					
			          	submit("TRRST05901");
			          	fSetGridTitle();
			          	grd_mtallist.refresh();
					]]>
				</script>
			</button>
			<datagrid id="grd_mtallist" nodeset="/root/main/mtallist" caption="품명^09년 4월입고^09년 5월입고^전년 5월입고^전년도 평균입고^전월입고차액^증감율^증감율^증감사유^instcd^inputmonth^winacnt" colsep="^" colwidth="166, 120, 120, 100, 0, 100, 48, 23, 478, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:0px; top:80px; width:1195px; height:565px; ">
				<col ref="winacntnm" style="text-align:left; "/>
				<col ref="befinputamt" format="#,###.##" style="text-align:right; "/>
				<col ref="inputamt" format="#,###.##" style="text-align:right; "/>
				<col ref="befyyinputamt" format="#,###.##" style="text-align:right; "/>
				<col ref="befyyinputavg" visibility="hidden" format="#,###.##" style="text-align:right; "/>
				<col ref="subinputamt" format="(-)#,###.##" style="text-align:right; "/>
				<col ref="incrateamt" format="(-)#,####.##" style="text-align:right; "/>
				<col ref="percent" style="text-align:center; "/>
				<col ref="cmt" type="input"/>
				<col ref="instcd" visibility="hidden"/>
				<col ref="inputmonth" visibility="hidden"/>
				<col ref="winacnt" visibility="hidden"/>
			</datagrid>
			<caption id="caption5" class="tit_2" style="left:5px; top:60px; width:136px; height:14px; ">자재 수불 증감 분석</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:75px; x2:1195px; y2:75px; "/>
			<caption id="caption1" class="search_name" style="left:230px; top:20px; width:91px; height:17px; ">입고년월 :</caption>
			<input id="ipt_inputmonth" ref="/root/send/goodreq/inputmonth" class="input_s_essential" inputtype="date" maxlength="6" format="yyyy-mm" style="left:318px; top:20px; width:75px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						fSetGridTitle();
						
					]]>
				</script>
			</input>
			<button id="btn_save" class="btn5_letter2" style="left:1150px; top:55px; width:42px; height:19px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.makeValue("/root/send/savedata/mtallist", getGridUpdateData(grd_mtallist));
						
						if(submit("TXRST05901")) {
							messageBox("저장이 완료되었습니다.", "E");
							btn_search.dispatch("DOMActivate");
						}
					]]>
				</script>
			</button>
			<button id="btn_print" class="btn1_letter2" style="left:1130px; top:20px; width:56px; height:22px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.makeNode("/root/send/report/mtallist");
						
						model.makeValue("/root/send/report/inputmonth", model.getValue(ipt_inputmonth.attribute("ref")));
						copyNodesetType("/root/send/report/mtallist", "/root/main/mtallist");
						
											
						exeReportPreview("RPRST05901", "XMLSTR", "/root/send/report");
						
					]]>
				</script>
			</button>
			<button id="button1" class="btn2_letter4" style="left:1085px; top:55px; width:100px; height:20px; ">
				<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>
		</group>
	</xhtml:body>
</xhtml:html>