SMRSO20700_월 재고수불장(부서재고)(경북대).xrw 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194
  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: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">
  4. <xhtml:head>
  5. <xhtml:title>월 재고수불장(부서재고)</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <cond>
  10. <instcd/>
  11. <srchmm/>
  12. <deptcd/>
  13. <deptnm/>
  14. <fromacntcd/>
  15. <toacntcd/>
  16. <gubun>1</gubun>
  17. </cond>
  18. <main>
  19. <list>
  20. <deptstocmmlist/>
  21. <deptstocexcel/>
  22. </list>
  23. </main>
  24. <send>
  25. </send>
  26. <init>
  27. <acnt>
  28. <acntlist/>
  29. </acnt>
  30. </init>
  31. <hidden>
  32. <acnt>
  33. <acntlist/>
  34. </acnt>
  35. </hidden>
  36. <temp>
  37. </temp>
  38. </root>
  39. </instance>
  40. <script type="javascript" ev:event="xforms-ready">
  41. <![CDATA[
  42. //화면 Control을 초기화한다
  43. makeReportPreview(0,123,1195,637);
  44. model.removeNodeset( "/root/main/list/deptstocmmlist");
  45. model.removeNodeset( "/root/main/list/deptstocexcel"); //excel 출력용
  46. //misfComboComCdListMulti("Z0007","cmb_instcd"); //기관코드
  47. misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
  48. model.setValue("/root/cond/instcd" , getUserInfo("dutplceinstcd")); //기관 설정
  49. model.setValue("/root/cond/srchmm" , getCurrentDate().substr(0,6)); //청구일자 설정
  50. model.makeValue("/root/send/reqdata/instcd",getUserInfo("dutplceinstcd"));
  51. if(submit("TRRSO20602")){
  52. //model.removeNodeset("/root/hidden/acnt/acntlist");
  53. //model.makeNode();
  54. copyNodesetType("/root/hidden/acnt/acntlist", "/root/init/acnt/acntlist","replace");
  55. }
  56. model.refresh();
  57. ]]>
  58. </script>
  59. <submission id="TRRSO20701" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/cond" resultref="/root/main/list"/>
  60. <submission id="TRRSO20602" method="post" ref="/root/send/reqdata" resultref="/root/init/acnt"/>
  61. </model>
  62. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  63. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  64. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  65. <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
  66. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  67. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  68. <script type="javascript">
  69. <![CDATA[
  70. ]]>
  71. </script>
  72. </xhtml:head>
  73. <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  74. <group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
  75. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:243px; height:14px; ">월 재고수불장(부서재고)</caption>
  76. </group>
  77. <group id="group1" style="left:0px; top:12; width:1195px; height:27px; ">
  78. <line id="line17" class="line_6" style="x1:0px; y1:25; x2:1195px; y2:25px; "/>
  79. </group>
  80. <group id="group3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
  81. <group id="grp_search" style="left:0px; top:9px; width:1195px; height:48px; vertical-align:top; ">
  82. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:40px; background-color:#fffbf2; border-color:#ffd799; "/>
  83. <button id="btn_search" class="btn1_letter2" navindex="7" style="left:1129px; top:9px; width:56px; height:22px; ">
  84. <caption>조회</caption>
  85. <script type="javascript" ev:event="DOMActivate">
  86. <![CDATA[
  87. if (submit("TRRSO20701") ){
  88. //exeReportPreview("RPRSO20701", "XMLSTR");//, "/root/main/payamt"); 가로양식
  89. exeReportPreview("RPRSO20702", "XMLSTR");//, "/root/main/payamt"); 세로양식
  90. }
  91. ]]>
  92. </script>
  93. </button>
  94. <select1 id="cmb_instcd" ref="/root/cond/instcd" class="combo_default" disabled="true" navindex="1" appearance="minimal" style="left:69px; top:10px; width:136px; height:19px; ">
  95. <choices>
  96. <itemset nodeset="/root/main/init">
  97. <label ref="cnstnm"/>
  98. <value ref="cnstcd"/>
  99. </itemset>
  100. </choices>
  101. </select1>
  102. <caption id="cap_instcd" class="search_name" style="left:13px; top:10px; width:86px; height:17px; ">기관:</caption>
  103. <input id="ipt_reqdd" ref="/root/cond/srchmm" navindex="2" inputtype="date" format="yyyy-mm" style="left:257px; top:10px; width:74px; height:19px; text-align:left; "/>
  104. <caption id="caption20" class="search_name" style="left:346px; top:10px; width:59px; height:17px; vertical-align:middle; ">부서:</caption>
  105. <line id="line30" class="line_4" style="x1:1120px; y1:4px; x2:1120px; y2:36px; "/>
  106. <button id="btn_reqdeptcd" class="icon_search" navindex="4" style="left:473px; top:10px; width:16px; height:16px; ">
  107. <caption/>
  108. <script type="javascript" ev:event="DOMActivate">
  109. <![CDATA[
  110. var recv_list = "deptcd,deptnm";
  111. misfOpenPopUpList("02", ipt_deptcd,"", recv_list) ;
  112. ipt_deptcd.refresh();
  113. ipt_deptnm.refresh();
  114. ]]>
  115. </script>
  116. </button>
  117. <input id="ipt_deptcd" ref="/root/cond/deptcd" class="input_default" navindex="3" style="left:401px; top:10px; width:70px; height:19px; ">
  118. <script type="javascript" ev:event="xforms-value-changed">
  119. <![CDATA[
  120. misfValidationCheck("02", "", "deptcd,deptnm" );
  121. ]]>
  122. </script>
  123. </input>
  124. <output id="ipt_deptnm" ref="/root/cond/deptnm" class="output_fix" appearance="output" style="left:491px; top:10px; width:109px; height:19px; "/>
  125. <caption id="caption9" class="search_name" style="left:215px; top:10px; width:69px; height:17px; ">월:</caption>
  126. <caption id="caption2" class="search_name" style="left:615px; top:10px; width:125px; height:17px; vertical-align:middle; ">계정:</caption>
  127. <select1 id="combo1" ref="/root/cond/fromacntcd" class="combo_default" navindex="5" appearance="minimal" editmode="search" itemcount="20" showvalue="true" style="left:670px; top:10px; width:145px; height:19px; ">
  128. <choices>
  129. <itemset nodeset="/root/init/acnt/acntlist">
  130. <label ref="acntnm"/>
  131. <value ref="acntcd"/>
  132. </itemset>
  133. </choices>
  134. </select1>
  135. <caption id="caption3" style="left:817px; top:10px; width:15px; height:20px; ">~</caption>
  136. <select1 id="combo2" ref="/root/cond/toacntcd" class="combo_default" navindex="6" appearance="minimal" editmode="search" itemcount="20" showvalue="true" style="left:830px; top:10px; width:145px; height:19px; ">
  137. <choices>
  138. <itemset nodeset="/root/hidden/acnt/acntlist">
  139. <label ref="acntnm"/>
  140. <value ref="acntcd"/>
  141. </itemset>
  142. </choices>
  143. </select1>
  144. <caption id="caption4" class="search_name" style="left:980px; top:10px; width:60px; height:17px; vertical-align:middle; ">구분:</caption>
  145. <select1 id="cmb_gubun" ref="/root/cond/gubun" appearance="minimal" style="left:1038px; top:10px; width:67px; height:19px; ">
  146. <choices>
  147. <item>
  148. <label>무산정+창고</label>
  149. <value>1</value>
  150. </item>
  151. <item>
  152. <label>전체</label>
  153. <value>2</value>
  154. </item>
  155. </choices>
  156. </select1>
  157. </group>
  158. <line id="line1" class="line_1" style="x1:0px; y1:78px; x2:1195px; y2:78px; "/>
  159. <caption id="caption1" class="tit_2" style="left:0px; top:63px; width:180px; height:14px; ">월 재고수불장(부서재고)</caption>
  160. <datagrid id="grd_deptstocexcel" nodeset="/root/main/list/deptstocexcel" visibility="hidden" caption="계정과목^품목코드^품목명^규격^전기이월^전기이월^당월입고^당월입고^당월출고^당월출고^당월재고^당월재고|계정과목^품목코드^품목명^규격^수량^금액^수량^금액^수량^금액^수량^금액" colsep="^" colwidth="138, 97, 239, 184, 90, 90, 90, 91, 90, 91, 90, 90" mergecellsfixedrows="bycolrec" rowsep="|" style="left:70px; top:110px; width:850px; height:105px; font-size:10pt; ">
  161. <col ref="acntnm" style="font-size:10pt; "/>
  162. <col ref="goodcd" style="font-size:10pt; text-align:center; "/>
  163. <col ref="goodnm" style="font-size:10pt; "/>
  164. <col ref="goodspec" style="font-size:10pt; "/>
  165. <col ref="transqty" format="#,###.##" style="font-size:10pt; text-align:right; "/>
  166. <col ref="transamt" format="#,###.##" style="font-size:10pt; text-align:right; "/>
  167. <col ref="winqty" format="#,###.##" style="font-size:10pt; text-align:right; "/>
  168. <col ref="winamt" format="#,###.##" style="font-size:10pt; text-align:right; "/>
  169. <col ref="deliveqty" format="#,###.##" style="font-size:10pt; text-align:right; "/>
  170. <col ref="deliveamt" format="#,###.##" style="font-size:10pt; text-align:right; "/>
  171. <col ref="stocqty" format="#,###.##" style="font-size:10pt; text-align:right; "/>
  172. <col ref="stocamt" format="#,###.##" style="font-size:10pt; text-align:right; "/>
  173. </datagrid>
  174. <button id="btn_excel" class="btn2_letter3" navindex="21" style="left:1138px; top:57px; width:53px; height:19px; ">
  175. <caption>엑셀</caption>
  176. <script type="javascript" ev:event="DOMActivate">
  177. <![CDATA[
  178. if (grd_deptstocexcel.rows == grd_deptstocexcel.fixedRows) return;
  179. misfSaveExcel(grd_deptstocexcel);
  180. ]]>
  181. </script>
  182. </button>
  183. </group>
  184. </xhtml:body>
  185. </xhtml:html>