SMRSO21200_품목별창고출고조회(경북대).xrw 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet ype="text/css" href="../../../com/commonweb/css/common.css" ?>
  3. <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:ms="urn:schemas-microsoft-com:xslt" xmlns:my="http://www.comsquare.co.kr/example" 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">
  4. <xhtml:head>
  5. <xhtml:title>품목별 창고 출고 조회</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <delivelist/>
  11. </main>
  12. <send>
  13. <search>
  14. <instcd/>
  15. <ddfrom/>
  16. <ddto/>
  17. <wareflag/>
  18. <wareflagnm/>
  19. <goodcdfrom/>
  20. <goodcdto/>
  21. <delivedeptcd/>
  22. <delivedeptnm/>
  23. </search>
  24. <save/>
  25. </send>
  26. <init>
  27. <acnt/>
  28. </init>
  29. <hidden/>
  30. <temp>
  31. <maxasset/>
  32. </temp>
  33. <popgood>
  34. <instcd/>
  35. <wareflag/>
  36. <goodcd/>
  37. <goodnm/>
  38. <returntype/>
  39. <selectyn/>
  40. </popgood>
  41. </root>
  42. </instance>
  43. <script type="javascript" ev:event="xforms-ready">
  44. <![CDATA[
  45. //화면 Control을 초기화한다
  46. misfGridInit(grd_delive);
  47. misfMsterDetailSet(grd_delive, null, "TRRSO21201" ,"Y");
  48. //화면에 repor 형식으로 보여줄 경우
  49. //makeReportPreview(0,123,1195,637);
  50. //model.removenode( "/root/main/delivelist");
  51. //misfComboComCdListMulti("Z0007","cmb_instcd"); //기관코드
  52. misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
  53. //2012.08.14 박준범 - 창고에 전체 항목 추가
  54. misfComboComCdList("030M0001",cmb_wareflag, "Y"); //창고 (Y: 전체 item 추가시)
  55. model.setValue("/root/send/search/instcd", getUserInfo("dutplceinstcd")); //기관 설정
  56. model.setValue("/root/send/search/ddfrom" , getCurrentDate()) //기간 설정 //.substr(0,6));
  57. model.setValue("/root/send/search/ddto" , getCurrentDate()) //기간 설정 //.substr(0,6));
  58. //test -> 향후 삭제할 것
  59. //model.setValue("/root/send/search/reqdd", "20110816");
  60. model.refresh();
  61. cmb_wareflag.dispatch("xforms-value-changed"); //출력 버튼 setting을 위해
  62. ]]>
  63. </script>
  64. <submission id="TRRSO20602" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/init/acnt"/>
  65. <submission id="TRRSO20802" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/temp/maxasset"/>
  66. <submission id="TRRSO21201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/main/"/>
  67. </model>
  68. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  69. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  70. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  71. <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
  72. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  73. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  74. <script type="javascript">
  75. <![CDATA[
  76. ]]>
  77. </script>
  78. </xhtml:head>
  79. <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  80. <group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
  81. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:243px; height:14px; ">품목별 창고 출고 조회</caption>
  82. </group>
  83. <group id="group1" style="left:0px; top:12; width:1195px; height:27px; ">
  84. <line id="line17" class="line_6" style="x1:0px; y1:25; x2:1195px; y2:25px; "/>
  85. <button id="btn_cust" class="btn3_letter7" style="left:948px; top:3px; width:116px; height:22px; ">
  86. <caption>거래처별 출력</caption>
  87. <script type="javascript" ev:event="DOMActivate">
  88. <![CDATA[
  89. //조회된 자료가 없으면 먼저 조회하라고 message
  90. if(grd_delive.rows < 2) {
  91. messageBox("조회된 결과가 존재하지 않습니다. \n\n먼저 조회 후 출력하십시요.", "E999", "");
  92. return;
  93. }
  94. //창고명을 report 에 넘겨주기 위해 instance에 setting한다.
  95. model.setValue("/root/send/search/wareflagnm", cmb_wareflag.label);
  96. exeReportPreview("RPRSO21201", "XMLSTR");//, "/root/main/payamt");
  97. ]]>
  98. </script>
  99. </button>
  100. <button id="btn_dd" class="btn3_letter6" style="left:843px; top:3px; width:104px; height:22px; ">
  101. <caption>일자별 출력</caption>
  102. <script type="javascript" ev:event="DOMActivate">
  103. <![CDATA[
  104. //조회된 자료가 없으면 먼저 조회하라고 message
  105. if(grd_delive.rows < 2) {
  106. messageBox("조회된 결과가 존재하지 않습니다. \n\n먼저 조회 후 출력하십시요.", "E999", "");
  107. return;
  108. }
  109. //창고명을 report 에 넘겨주기 위해 instance에 setting한다.
  110. model.setValue("/root/send/search/wareflagnm", cmb_wareflag.label);
  111. exeReportPreview("RPRSO21202", "XMLSTR");//, "/root/main/payamt");
  112. ]]>
  113. </script>
  114. </button>
  115. <button id="btn_good" class="btn3_letter8" style="left:1065px; top:3px; width:128px; height:22px; ">
  116. <caption>품목별 합계 출력</caption>
  117. <script type="javascript" ev:event="DOMActivate">
  118. <![CDATA[
  119. //조회된 자료가 없으면 먼저 조회하라고 message
  120. if(grd_delive.rows < 2) {
  121. messageBox("조회된 결과가 존재하지 않습니다. \n\n먼저 조회 후 출력하십시요.", "E999", "");
  122. return;
  123. }
  124. //창고명을 report 에 넘겨주기 위해 instance에 setting한다.
  125. model.setValue("/root/send/search/wareflagnm", cmb_wareflag.label);
  126. exeReportPreview("RPRSO21203", "XMLSTR");//, "/root/main/payamt");
  127. ]]>
  128. </script>
  129. </button>
  130. </group>
  131. <group id="group3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
  132. <group id="grp_search" style="left:0px; top:9px; width:1195px; height:66px; vertical-align:top; ">
  133. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:61px; background-color:#fffbf2; border-color:#ffd799; "/>
  134. <button id="btn_search" class="btn1_letter2" navindex="8" style="left:1069px; top:19px; width:56px; height:22px; ">
  135. <caption>조회</caption>
  136. <script type="javascript" ev:event="DOMActivate">
  137. <![CDATA[
  138. //2012.08.14 박준범 - 창고 "전체" 를 추가하면서 comment처리
  139. /*
  140. //창고에 선택된 값이 없으면, 창고를 선택하라고 alert함
  141. if(cmb_wareflag.value == "") {
  142. messageBox("창고가 선택되지 않았습니다. \n\n먼저 창고를 선택하십시요.", "E999", "");
  143. model.setFocus("cmb_wareflag");
  144. return;
  145. }
  146. */
  147. //년월에 입력된 값이 올바르지 않으면, 년월을 선택하라고 alert함
  148. if(ipt_ddfrom.value.length < 8) {
  149. messageBox("출고일자가 올바로 선택되지 않았습니다. \n\n먼저 출고일자을 선택하십시요.", "E999", "");
  150. model.setFocus("ipt_ddfrom");
  151. return;
  152. }
  153. if(ipt_ddto.value.length < 8) {
  154. messageBox("출고일자가 올바로 선택되지 않았습니다. \n\n먼저 출고일자을 선택하십시요.", "E999", "");
  155. model.setFocus("ipt_ddto");
  156. return;
  157. }
  158. misfMsterDetailRetrieve();
  159. ]]>
  160. </script>
  161. </button>
  162. <select1 id="cmb_instcd" ref="/root/send/search/instcd" class="combo_default" disabled="true" navindex="1" appearance="minimal" style="left:137px; top:10px; width:136px; height:19px; ">
  163. <choices>
  164. <itemset nodeset="/root/main/init">
  165. <label ref="cnstnm"/>
  166. <value ref="cnstcd"/>
  167. </itemset>
  168. </choices>
  169. </select1>
  170. <caption id="cap_instcd" class="search_name" style="left:58px; top:10px; width:77px; height:17px; ">기관코드</caption>
  171. <input id="ipt_ddfrom" ref="/root/send/search/ddfrom" navindex="5" inputtype="date" format="yyyy-mm-dd" style="left:754px; top:33px; width:87px; height:19px; "/>
  172. <line id="line30" class="line_4" style="x1:1045px; y1:8px; x2:1045px; y2:53px; "/>
  173. <caption id="caption2" class="search_name" style="left:321px; top:10px; width:104px; height:17px; ">창 고</caption>
  174. <select1 id="cmb_wareflag" ref="/root/send/search/wareflag" class="combo_default" navindex="2" appearance="minimal" style="left:426px; top:10px; width:135px; height:19px; ">
  175. <choices>
  176. <itemset nodeset="/root/init/wareflag">
  177. <label ref="cdnm"/>
  178. <value ref="cdid"/>
  179. </itemset>
  180. </choices>
  181. <script type="javascript" ev:event="xforms-value-changed">
  182. <![CDATA[
  183. //2012.08.14 박준범 - 창고가 "전체" 인 경우에만 품목별 합계를 출력할 수 있도록 한다.
  184. if(cmb_wareflag.value == "") {
  185. btn_dd.disabled = true;
  186. btn_cust.disabled = true;
  187. } else {
  188. btn_dd.disabled = false;
  189. btn_cust.disabled = false;
  190. }
  191. ]]>
  192. </script>
  193. </select1>
  194. <caption id="caption9" class="search_name" style="left:674px; top:33px; width:79px; height:17px; ">출고일자</caption>
  195. <caption id="caption4" style="left:843px; top:33px; width:10px; height:20px; font-weight:bold; ">-</caption>
  196. <input id="ipt_ddto" ref="/root/send/search/ddto" navindex="6" inputtype="date" format="yyyy-mm-dd" style="left:855px; top:33px; width:87px; height:19px; "/>
  197. <input id="ipt_goodcdfrom" ref="/root/send/search/goodcdfrom" class="input_default" navindex="3" maxlength="12" style="left:753px; top:10px; width:88px; height:19px; "/>
  198. <button id="btn_goodcdto" class="icon_search" navindex="3" style="left:961px; top:10px; width:16px; height:16px; ">
  199. <caption/>
  200. <script type="javascript" ev:event="DOMActivate">
  201. <![CDATA[
  202. //popup 에 전달할 parameter를 setting한다.
  203. model.setValue("/root/popgood/instcd", cmb_instcd.value);
  204. model.setValue("/root/popgood/wareflag", cmb_wareflag.value);
  205. model.setValue("/root/popgood/returntype", "2"); //goodnm도 함께 return 받고자 할때, returntype을 "2" 로 설정.
  206. //selectyn(popup 창에서 선택버튼을 click했는지 아닌지를 나타내는 구분값) 을 초기화함
  207. model.setValue("/root/popgood/selectyn", "");
  208. //popup 프로그램 호출
  209. window.load("SPRSO20300.xrw", "modal","", "", "/root/popgood","/root/popdata");
  210. //popup에서 특정 물품코드를 선택한 경우, 해당 물품코드에 대한 상세 사항을 조회해서 그리드에 보여준다.
  211. if(model.getValue("/root/popgood/selectyn") == "Y") { //popup 창에서 선택버튼을 click했는지 아닌지를 나타내는 구분값
  212. ipt_goodcdto.value = model.getValue("/root/popgood/goodcd");
  213. //2012.09.17 박준범 - 아래 comment처리
  214. //opt_goodnmto.value = model.getValue("/root/popgood/goodnm");
  215. }
  216. ]]>
  217. </script>
  218. </button>
  219. <input id="ipt_goodcdto" ref="/root/send/search/goodcdto" class="input_default" navindex="4" maxlength="12" style="left:870px; top:10px; width:88px; height:19px; "/>
  220. <caption id="caption13" class="search_name" style="left:674px; top:10px; width:80px; height:17px; vertical-align:middle; ">물품코드</caption>
  221. <caption id="caption14" style="left:858px; top:9px; width:13px; height:20px; font-weight:bold; ">-</caption>
  222. <button id="btn_goodcdfrom" class="icon_search" navindex="3" style="left:844px; top:10px; width:16px; height:16px; ">
  223. <caption/>
  224. <script type="javascript" ev:event="DOMActivate">
  225. <![CDATA[
  226. //popup 에 전달할 parameter를 setting한다.
  227. model.setValue("/root/popgood/instcd", cmb_instcd.value);
  228. model.setValue("/root/popgood/wareflag", cmb_wareflag.value);
  229. model.setValue("/root/popgood/returntype", "2"); //goodnm도 함께 return 받고자 할때, returntype을 "2" 로 설정.
  230. //selectyn(popup 창에서 선택버튼을 click했는지 아닌지를 나타내는 구분값) 을 초기화함
  231. model.setValue("/root/popgood/selectyn", "");
  232. //popup 프로그램 호출
  233. window.load("SPRSO20300.xrw", "modal","", "", "/root/popgood","/root/popdata");
  234. //popup에서 특정 물품코드를 선택한 경우, 해당 물품코드에 대한 상세 사항을 조회해서 그리드에 보여준다.
  235. if(model.getValue("/root/popgood/selectyn") == "Y") { //popup 창에서 선택버튼을 click했는지 아닌지를 나타내는 구분값
  236. ipt_goodcdfrom.value = model.getValue("/root/popgood/goodcd");
  237. //2012.09.17 박준범 - 아래 comment처리
  238. //opt_goodnmfrom.value = model.getValue("/root/popgood/goodnm");
  239. }
  240. ]]>
  241. </script>
  242. </button>
  243. <input id="ipt_delivedeptcd" ref="/root/send/search/delivedeptcd" class="input_default" navindex="2" style="left:426px; top:33px; width:70px; height:19px; ">
  244. <script type="javascript" ev:event="xforms-value-changed">
  245. <![CDATA[
  246. //2013.02.26 박준범 : 부서코드 변경시 부서코드명을 먼저 지워준다.
  247. opt_delivedeptnm.value = "";
  248. misfValidationCheck("02", "", "delivedeptcd,delivedeptnm" );
  249. ]]>
  250. </script>
  251. <script type="javascript" ev:event="onkeypress">
  252. <![CDATA[
  253. //if( event.keyCode == 13 ) {
  254. //btn_search.dispatch("DOMActivate");
  255. // --> 위의 코드를 사용하면 input에 입력된 값이 인식이 안됨. TrustForm bug 같습니다.
  256. // --> 대신, 아래 코드 사용하면 input의 값이 인식이 됨
  257. //input 에서 EnterKey 이벤트 인식시 아래 function을 사용하세요!!
  258. inputEnterKey("ipt_delivedeptcd", "xforms-value-changed");
  259. //}
  260. ]]>
  261. </script>
  262. </input>
  263. <button id="btn_delivedeptcd" class="icon_search" navindex="3" style="left:498px; top:33px; width:16px; height:16px; ">
  264. <caption/>
  265. <script type="javascript" ev:event="DOMActivate">
  266. <![CDATA[
  267. var recv_list = "delivedeptcd,delivedeptnm";
  268. misfOpenPopUpList("02", ipt_delivedeptcd,"", recv_list) ;
  269. ipt_delivedeptcd.refresh();
  270. opt_delivedeptnm.refresh();
  271. ]]>
  272. </script>
  273. </button>
  274. <output id="opt_delivedeptnm" ref="/root/send/search/delivedeptnm" class="output_fix" appearance="output" style="left:516px; top:33px; width:126px; height:19px; "/>
  275. <caption id="caption20" class="search_name" style="left:321px; top:33px; width:102px; height:17px; vertical-align:middle; ">물품받는부서</caption>
  276. </group>
  277. <line id="line1" class="line_1" style="x1:0px; y1:100px; x2:1195px; y2:100px; "/>
  278. <caption id="caption1" class="tit_2" style="left:0px; top:83px; width:180px; height:13px; ">품목별 창고 출고 내역</caption>
  279. <datagrid id="grd_delive" nodeset="/root/main/delivelist" caption="출고일자^번호^거래처^출고부서^물품코드^물품명^규격^Box당 수^수량^단위" colsep="^" colwidth="78, 39, 153, 179, 91, 311, 129, 60, 70, 63" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:105px; width:1195px; height:600px; ">
  280. <col ref="delivedd" format="yyyy-mm-dd" style="text-align:center; "/>
  281. <col ref="deliveno" style="text-align:center; "/>
  282. <col ref="custnm"/>
  283. <col ref="deptnm"/>
  284. <col ref="goodcd" style="text-align:center; "/>
  285. <col ref="goodnm"/>
  286. <col ref="goodspec"/>
  287. <col ref="exchqty" format="#,###" style="text-align:right; "/>
  288. <col ref="deliveqty" format="(-)#,###.##" style="text-align:right; "/>
  289. <col ref="purcunit" style="text-align:center; "/>
  290. </datagrid>
  291. <button id="btn_excel" class="btn2_letter3" navindex="21" style="left:1138px; top:77px; width:53px; height:19px; ">
  292. <caption>엑셀</caption>
  293. <script type="javascript" ev:event="DOMActivate">
  294. <![CDATA[
  295. misfSaveExcel(grd_delive);
  296. ]]>
  297. </script>
  298. </button>
  299. </group>
  300. </xhtml:body>
  301. </xhtml:html>