123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235 |
- <?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>
- <daysumrept/>
- <detail>
- <wlnlist/>
- <delivelist/>
- <mngtlist/>
- </detail>
- </main>
- <send>
- <srchdd/>
- <tempym/>
- <srchbdioflag/>
- <srchym/>
- <globalinstance>
- <instance1/>
- </globalinstance>
- <wlnlist/>
- <delivelist/>
- <mngtlist/>
- <srchitemcd/>
- <srchflag/>
- </send>
- <tmp>
- <tmpym/>
- <qty/>
- </tmp>
- </root>
- </instance>
- <submission id="TRAEQ01001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/daysumrept"/>
- <submission id="TRAEQ01002" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/detail"/>
- <submission id="TXAEQ01001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/result"/>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- aezfSetSuppDeptcd();
- model.setValue("/root/send/srchflag","A");
- model.setValue("/root/send/srchbdioflag","I");
- model.setValue("/root/send/srchym", (new Date()).getDateFormat("YYYYMM"));
- model.refresh();
- ]]>
- </script>
- </model>
- <script type="javascript" src="../../../com/commonweb/js/common.js"/>
- <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
- <script type="javascript" src="../../../ast/examcureweb/js/AEZ0001.js"/>
- <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
- </xhtml:head>
- <xhtml:body guideline="1,1195;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
- <group id="group1" style="left:0px; top:0px; width:1194px; height:13px; ">
- <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:106px; height:14px; ">일계표</caption>
- </group>
- <group id="group3" scroll="auto" style="left:0px; top:13px; width:1195px; height:744px; ">
- <group id="group2" style="left:0px; top:10px; width:1195px; height:35px; vertical-align:top; ">
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
- <line id="line1" style="x1:1115px; y1:9px; x2:1115px; y2:24px; border-color:#ffe4bb; border-left-style:solid; "/>
- <input id="input3" ref="/root/send/srchym" class="input_default" inputtype="date" format="yyyy-mm" style="left:100px; top:8px; width:90px; height:19px; "/>
- <caption id="caption11" class="search_name" style="left:10px; top:8px; width:86px; height:17px; text-align:left; ">기준월 :</caption>
- <button id="btn_sea" class="btn1_letter2" style="left:1125px; top:5px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- model.setValue("/root/tmp/tmpym", model.getValue("/root/send/srchym"));
- submit("TRAEQ01001");
- ]]>
- </script>
- </button>
- </group>
- <line id="line2" class="line_1" style="x1:0px; y1:70px; x2:1195px; y2:70px; "/>
- <datagrid id="grd_list" nodeset="/root/main/daysumrept/daysumreptlist" allowbigselection="false" allowselection="false" caption="품명^규격^구분^이월^1^2^3^4^5^6^7^8^9^10^11^12^13^14^15^16^17^18^19^20^21^22^23^24^25^26^27^28^29^30^31^합계" colsep="^" colwidth="130,80,80,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50" fixedcols="3" mergecellsfixedcols="bycol" rowsep="|" selectionmode="free" style="left:0px; top:75px; width:1195px; height:405px; ">
- <col ref="itemnm" style="text-align:center; "/>
- <col ref="specnm" style="text-align:center; "/>
- <col ref="ioflag" style="left:210px; top:23px; width:80px; height:23px; text-align:center; "/>
- <col ref="d00" style="text-align:right; "/>
- <col ref="d01" style="text-align:right; "/>
- <col ref="d02" style="text-align:right; "/>
- <col ref="d03" style="text-align:right; "/>
- <col ref="d04" style="text-align:right; "/>
- <col ref="d05" style="text-align:right; "/>
- <col ref="d06" style="text-align:right; "/>
- <col ref="d07" style="text-align:right; "/>
- <col ref="d08" style="text-align:right; "/>
- <col ref="d09" style="text-align:right; "/>
- <col ref="d10" style="text-align:right; "/>
- <col ref="d11" style="text-align:right; "/>
- <col ref="d12" style="text-align:right; "/>
- <col ref="d13" style="text-align:right; "/>
- <col ref="d14" style="text-align:right; "/>
- <col ref="d15" style="text-align:right; "/>
- <col ref="d16" style="text-align:right; "/>
- <col ref="d17" style="text-align:right; "/>
- <col ref="d18" style="text-align:right; "/>
- <col ref="d19" style="text-align:right; "/>
- <col ref="d20" style="text-align:right; "/>
- <col ref="d21" style="text-align:right; "/>
- <col ref="d22" style="text-align:right; "/>
- <col ref="d23" style="text-align:right; "/>
- <col ref="d24" style="text-align:right; "/>
- <col ref="d25" style="text-align:right; "/>
- <col ref="d26" style="text-align:right; "/>
- <col ref="d27" style="text-align:right; "/>
- <col ref="d28" style="text-align:right; "/>
- <col ref="d29" style="text-align:right; "/>
- <col ref="d30" style="text-align:right; "/>
- <col ref="d31" style="text-align:right; "/>
- <col ref="d32" style="text-align:right; "/>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- if ( grd_list.isCell(event.target) && grd_list.row >= grd_list.fixedRows ) {
- var col = grd_list.colAttribute(grd_list.col, "ref")
- col = col.replace("d", "");
- model.setValue("/root/send/srchdd", model.getValue("/root/tmp/tmpym") + col);
- model.setValue("/root/send/srchitemcd", model.getValue("/root/main/daysumrept/daysumreptlist[" + grd_list.row + "]/itemcd"));
- submit("TRAEQ01002");
-
- var itemnm = grd_list.valueMatrix(grd_list.row, grd_list.colRef("itemnm"));
- var specnm = grd_list.valueMatrix(grd_list.row, grd_list.colRef("specnm"));
- var ioflag = grd_list.valueMatrix(grd_list.row, grd_list.colRef("ioflag"));
- var icol = grd_list.col;
-
- var itemnm1 = ""
- var qty = ""
- var ioflag1 = ""
-
- for (var i=1; i <grd_list.rows; i ++) {
- itemnm1 = grd_list.valueMatrix(i, grd_list.colRef("itemnm"));
- ioflag1 = grd_list.valueMatrix(i, grd_list.colRef("ioflag"));
-
- if (itemnm == itemnm1 && ioflag1 == "재고") {
- qty = grd_list.valueMatrix(i, icol);
- model.setValue("/root/tmp/qty", qty);
- }
- }
- model.refresh();
- }
- ]]>
- </script>
- </datagrid>
- <datagrid id="grd_wlnlist" nodeset="/root/main/detail/wlnlist" caption="거래처^항목^규격^수량" colsep="^" colwidth="140,100,65,65" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:510px; width:390px; height:220px; ">
- <col ref="suplcustnm" type="output"/>
- <col ref="goodnm" type="output"/>
- <col ref="specnm" type="output"/>
- <col ref="qty" type="output"/>
- <col ref="suplcustcd" visibility="hidden"/>
- <col ref="lossresncd" visibility="hidden"/>
- <col ref="iodd" visibility="hidden"/>
- <col ref="ioflag" visibility="hidden"/>
- <col ref="bdioflag" visibility="hidden"/>
- <col ref="itemflag" visibility="hidden"/>
- <col ref="goodcd" visibility="hidden"/>
- <col ref="rem" visibility="hidden"/>
- <col ref="suppdeptcd" visibility="hidden" style="text-align:center; "/>
- </datagrid>
- <datagrid id="grd_delivelist" nodeset="/root/main/detail/delivelist" caption="거래처^항목^규격^수량" colsep="^" colwidth="140,100,65,65" mergecellsfixedrows="bycolrec" rowsep="|" style="left:400px; top:510px; width:395px; height:220px; ">
- <col ref="suplcustnm" type="output"/>
- <col ref="goodnm" type="output"/>
- <col ref="specnm" type="output"/>
- <col ref="qty" type="output"/>
- <col ref="suplcustcd" visibility="hidden"/>
- <col ref="lossresncd" visibility="hidden"/>
- <col ref="iodd" visibility="hidden"/>
- <col ref="ioflag" visibility="hidden"/>
- <col ref="bdioflag" visibility="hidden"/>
- <col ref="itemflag" visibility="hidden"/>
- <col ref="goodcd" visibility="hidden"/>
- <col ref="rem" visibility="hidden"/>
- <col ref="suppdeptcd" visibility="hidden" style="text-align:center; "/>
- </datagrid>
- <datagrid id="grd_mngtlist" nodeset="/root/main/detail/mngtlist" caption="거래처^항목^규격^수량^사유" colsep="^" colwidth="140, 100, 65, 65, 180" mergecellsfixedrows="bycolrec" rowsep="|" style="left:805px; top:510px; width:390px; height:220px; ">
- <col ref="suplcustnm" type="output"/>
- <col ref="goodnm" type="output"/>
- <col ref="specnm" type="output"/>
- <col ref="qty" type="input"/>
- <col ref="suplcustcd" visibility="hidden"/>
- <col ref="lossresncd" visibility="hidden"/>
- <col ref="iodd" visibility="hidden"/>
- <col ref="ioflag" visibility="hidden"/>
- <col ref="bdioflag" visibility="hidden"/>
- <col ref="itemflag" visibility="hidden"/>
- <col ref="goodcd" visibility="hidden"/>
- <col ref="rem" visibility="hidden"/>
- <col ref="suppdeptcd" visibility="hidden" style="text-align:center; "/>
- </datagrid>
- <caption id="caption4" class="tit_2" style="left:400px; top:495px; width:84px; height:13px; ">사용 현황</caption>
- <caption id="caption1" class="tit_2" style="left:5px; top:495px; width:84px; height:13px; ">입고현황</caption>
- <caption id="caption2" class="tit_2" style="left:805px; top:495px; width:84px; height:13px; ">관리 현황</caption>
- <button id="btn_excsave" class="btn2_letter4" visibility="visible" style="left:1130px; top:50px; 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_list.saveExcel(fileName);
- }
- ]]>
- </script>
- </button>
- <caption id="caption26" class="cell_1" style="left:1020px; top:485px; width:84px; height:23px; font-weight:bold; text-align:center; vertical-align:middle; ">재고량</caption>
- <input id="input1" ref="/root/tmp/qty" style="left:1105px; top:487px; width:84px; height:19px; font-weight:bold; text-align:right; "/>
- </group>
- <group id="grp_btn" style="left:0px; top:757px; width:1195px; height:27px; "/>
- <button id="btnSave" class="btn4_letter2" style="left:1136px; top:762px; width:56px; height:22px; ">
- <caption>저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var uptwln = getGridUpdateData(grd_wlnlist);
- var uptdelive = getGridUpdateData(grd_delivelist);
- var uptmngt = getGridUpdateData(grd_mngtlist);
-
- model.setValue("/root/send/wlnlist", uptwln);
- model.setValue("/root/send/delivelist", uptdelive);
- model.setValue("/root/send/mngtlist", uptmngt);
-
- if ( submit("TXAEQ01001")) {
- // 저장 후 재 조회
- submit("TRAEQ01001");
- model.refresh();
- }
-
- ]]>
- </script>
- </button>
- </xhtml:body>
- </xhtml:html>
|