SMAGR03300_물품재고현황.xrw 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
  3. <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">
  4. <xhtml:head>
  5. <xhtml:title>물품재고현황</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <ipgoinfo>
  11. <ipgolist>
  12. <goodcd/>
  13. <goodnm/>
  14. <goodspec/>
  15. <allsizespecidnm/>
  16. <goodmodel/>
  17. <prodcmpynm/>
  18. <custnm/>
  19. <inqty/>
  20. <rtninqty/>
  21. <outqty/>
  22. <jaego/>
  23. <safestocqty/>
  24. <sendqty/>
  25. <outamt/>
  26. </ipgolist>
  27. </ipgoinfo>
  28. </main>
  29. <send>
  30. <iodate/>
  31. <custnm/>
  32. <prodcmpynm/>
  33. <goodcd/>
  34. <goodnm/>
  35. <totinqty/>
  36. <totrtninqty/>
  37. <totoutqty/>
  38. <totjaego/>
  39. <prcpdd/>
  40. <globalinstance>
  41. <instance1/>
  42. </globalinstance>
  43. <req>
  44. <data/>
  45. </req>
  46. </send>
  47. <init>
  48. <baseinfo>
  49. <intiunit/>
  50. </baseinfo>
  51. </init>
  52. <hidden>
  53. <item/>
  54. </hidden>
  55. <cmb_info>
  56. <dpcminfo>
  57. <dpcmcust>
  58. <custnm/>
  59. <perchgr/>
  60. <cntctel/>
  61. <faxno/>
  62. <mpphontel/>
  63. <email/>
  64. <auttrsmflag/>
  65. <custcd/>
  66. <suppdeptcd/>
  67. <instcd/>
  68. <trsmtrid/>
  69. <useyn/>
  70. </dpcmcust>
  71. </dpcminfo>
  72. </cmb_info>
  73. </root>
  74. </instance>
  75. <submission id="TRAGR03301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/ipgoinfo"/>
  76. <script type="javascript" ev:event="xforms-ready">
  77. <![CDATA[
  78. aezfSetSuppDeptcd();
  79. zbcfGetCodeList( new Array("R0039"), new Array("/root/init/baseinfo/intiunit") );
  80. submit("TRAGA00101");
  81. model.setValue("/root/send/iodate", getCurrentDate().substr(0, 6) + "01");
  82. model.setValue("/root/send/prcpdd", getCurrentDate());
  83. //btn_sea.dispatch("DOMActivate");
  84. model.refresh();
  85. ]]>
  86. </script>
  87. <submission id="TRZBC00101"/>
  88. <submission id="TRAGA00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/cmb_info/dpcminfo"/>
  89. </model>
  90. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  91. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  92. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  93. <script type="javascript" src="../../../ast/commonweb/js/AST.js"/>
  94. <script type="javascript" src="../../../ast/examcureweb/js/AEZ0001.js"/>
  95. <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
  96. <script type="javascript" src="../../../com/departmentcodeweb/js/ZSD001.js"/>
  97. <script type="javascript" src="../../../com/authinfoweb/js/ZSA001.js"/>
  98. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  99. </xhtml:head>
  100. <xhtml:body guideline="1,1195;2,784;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  101. <group id="grp_biz" scroll="auto" style="left:0px; top:13px; width:1195px; height:744px; ">
  102. <group id="grp_sea" style="left:0px; top:10px; width:1194px; height:67px; vertical-align:top; ">
  103. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:1px; width:1194px; height:65px; background-color:#fffbf2; border-color:#ffd799; "/>
  104. <line id="line13" class="line_4" style="x1:1102px; y1:7px; x2:1102px; y2:59px; "/>
  105. <button id="btn_sea" class="btn1_letter2" navindex="6" style="left:1120px; top:20px; width:56px; height:22px; ">
  106. <caption>조회</caption>
  107. <script type="javascript" ev:event="DOMActivate">
  108. <![CDATA[
  109. var siodate = model.getValue("/root/send/iodate");
  110. var sprcpdd = model.getValue("/root/send/prcpdd");
  111. if (siodate.substr(0, 6) != sprcpdd.substr(0, 6)){
  112. messageBox("재고현황은 같은 달 기준으로 조회할 수 있습니다.", "E999", "");
  113. return;
  114. }
  115. model.removeNodeset("/root/main/ipgoinfo/ipgolist");
  116. submit("TRAGR03301");
  117. var inqty = 0;
  118. var rtninqty = 0;
  119. var outqty = 0;
  120. var jaegoqty = 0;
  121. for (var i = 1; i < datagrid1.rows; i++){
  122. inqty = parseFloat(inqty) + parseFloat(model.getValue("/root/main/ipgoinfo/ipgolist[" + i + "]/inqty"));
  123. rtninqty = parseFloat(rtninqty) + parseFloat(model.getValue("/root/main/ipgoinfo/ipgolist[" + i + "]/rtninqty"));
  124. outqty = parseFloat(outqty) + parseFloat(model.getValue("/root/main/ipgoinfo/ipgolist[" + i + "]/outqty"));
  125. jaegoqty = parseFloat(jaegoqty) + parseFloat(model.getValue("/root/main/ipgoinfo/ipgolist[" + i + "]/jaego"));
  126. }
  127. model.setValue("/root/send/totinqty", inqty);
  128. model.setValue("/root/send/totrtninqty", rtninqty);
  129. model.setValue("/root/send/totoutqty", outqty);
  130. model.setValue("/root/send/totjaego", jaegoqty);
  131. model.refresh();
  132. ]]>
  133. </script>
  134. </button>
  135. <caption id="caption2" class="search_name" style="left:15px; top:12px; width:86px; height:17px; ">조회일자 :</caption>
  136. <input id="input1" ref="/root/send/iodate" navindex="1" inputtype="date" style="left:110px; top:11px; width:120px; height:19px; text-align:center; "/>
  137. <caption id="caption3" class="search_name" style="left:485px; top:12px; width:86px; height:17px; ">거래처명 :</caption>
  138. <caption id="caption4" class="search_name" style="left:745px; top:12px; width:99px; height:17px; ">제조회사명 :</caption>
  139. <input id="input3" ref="/root/send/prodcmpynm" navindex="3" style="left:855px; top:11px; width:145px; height:19px; "/>
  140. <caption id="caption1" class="search_name" style="left:15px; top:42px; width:86px; height:17px; ">물품코드 :</caption>
  141. <caption id="caption5" class="search_name" style="left:250px; top:42px; width:93px; height:17px; ">물 품 명 :</caption>
  142. <input id="input4" ref="/root/send/goodcd" navindex="4" style="left:110px; top:39px; width:120px; height:19px; "/>
  143. <input id="input5" ref="/root/send/goodnm" navindex="5" style="left:345px; top:39px; width:120px; height:19px; "/>
  144. <caption id="caption7" style="left:490px; top:45px; width:65px; height:20px; ">총입고량 :</caption>
  145. <output id="output1" ref="/root/send/totinqty" format="#,###" style="left:555px; top:45px; width:65px; height:19px; text-align:center; "/>
  146. <input id="input6" ref="/root/send/prcpdd" navindex="1" inputtype="date" style="left:260px; top:11px; width:120px; height:19px; text-align:center; "/>
  147. <caption id="caption8" style="left:235px; top:13px; width:20px; height:20px; text-align:center; ">~</caption>
  148. <button id="btn_excel" class="btn2_letter4" disable.background-image="../../../com/commonweb/images/dis_btn2_letter2.gif" style="left:1031px; top:45px; width:64px; height:19px; background-image:../../../com/commonweb/images/btn2_letter2.gif; ">
  149. <caption>엑셀저장</caption>
  150. <script type="javascript" ev:event="DOMActivate">
  151. <![CDATA[
  152. var file = window.fileDialog("save","","true","","xls","Excel Files(*.xls)|*.xls");
  153. if(file == "") return;
  154. datagrid1.saveExcel(file, "sheet1");
  155. ]]>
  156. </script>
  157. </button>
  158. <caption id="caption9" style="left:625px; top:45px; width:65px; height:20px; ">총반납량 :</caption>
  159. <output id="output2" ref="/root/send/totrtninqty" format="#,###" style="left:690px; top:45px; width:65px; height:19px; text-align:center; "/>
  160. <caption id="caption10" style="left:760px; top:45px; width:65px; height:20px; ">총사용량 :</caption>
  161. <output id="output3" ref="/root/send/totoutqty" format="#,###" style="left:825px; top:45px; width:65px; height:19px; text-align:center; "/>
  162. <caption id="caption11" style="left:895px; top:45px; width:65px; height:20px; ">총재고량 :</caption>
  163. <output id="output4" ref="/root/send/totoutqty" format="#,###" style="left:960px; top:45px; width:65px; height:19px; text-align:center; "/>
  164. <select1 id="combo1" ref="/root/send/custnm" appearance="minimal" editmode="input" style="left:580px; top:11px; width:145px; height:19px; ">
  165. <choices>
  166. <itemset nodeset="/root/cmb_info/dpcminfo">
  167. <label ref="dpcmcust/custnm"/>
  168. <value ref="dpcmcust/custnm"/>
  169. </itemset>
  170. </choices>
  171. </select1>
  172. </group>
  173. <line id="line1" class="line_1" style="x1:3px; y1:79px; x2:1194px; y2:80px; "/>
  174. <datagrid id="datagrid1" nodeset="/root/main/ipgoinfo/ipgolist" caption="물품코드^물품명^규격^All Size^모델^제조회사^거래처^입고량^반납량^사용량^재고량^안전재고^전송수량^사용량금액" colsep="^" colwidth="83, 146, 92, 80, 72, 106, 91, 75, 68, 63, 68, 66, 65, 116" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowsep="|" style="left:3px; top:82px; width:1191px; height:660px; ">
  175. <col ref="goodcd" style="text-align:left; "/>
  176. <col ref="goodnm" style="text-align:left; "/>
  177. <col ref="goodspec" style="text-align:left; "/>
  178. <col ref="allsizespecidnm" style="text-align:left; "/>
  179. <col ref="goodmodel" style="text-align:left; "/>
  180. <col ref="prodcmpynm" style="text-align:left; "/>
  181. <col ref="custnm" style="text-align:left; "/>
  182. <col ref="inqty" format="999999" style="text-align:right; "/>
  183. <col ref="rtninqty" format="999999" style="text-align:right; "/>
  184. <col ref="outqty" format="#,###" style="text-align:right; "/>
  185. <col ref="jaego" format="#,###" style="text-align:right; "/>
  186. <col ref="safestocqty" format="#,###" style="text-align:right; "/>
  187. <col ref="sendqty" format="#,###" style="text-align:right; "/>
  188. <col ref="outamt" format="#,###" style="text-align:right; "/>
  189. <script type="javascript" ev:event="xforms-value-changed">
  190. <![CDATA[
  191. ]]>
  192. </script>
  193. <script type="javascript" ev:event="onaftersort">
  194. <![CDATA[
  195. datagrid1.gridToInstance();
  196. ]]>
  197. </script>
  198. </datagrid>
  199. </group>
  200. <group id="grp_btn" style="left:0px; top:757px; width:1195px; height:27px; ">
  201. <line id="line32" class="line_6" style="x1:0px; y1:0px; x2:1194px; y2:0px; "/>
  202. </group>
  203. <group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
  204. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:144px; height:14px; ">물품재고현황</caption>
  205. </group>
  206. </xhtml:body>
  207. </xhtml:html>