SMRST06000_자재재고총괄표.xrw 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet type="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. <main>
  10. <mtaltotllist>
  11. <acntflagnm/>
  12. <trnsamt/>
  13. <inputamt/>
  14. <outputamt/>
  15. <endmonamt/>
  16. <instcd/>
  17. <winacnt/>
  18. </mtaltotllist>
  19. </main>
  20. <send>
  21. <goodreq>
  22. <instcd/>
  23. <inputmonth/>
  24. <purcflag/>
  25. </goodreq>
  26. <savedata/>
  27. </send>
  28. <init>
  29. </init>
  30. <temp/>
  31. <temp>
  32. <mtaltotllist>
  33. <acntflagnm/>
  34. <trnsamt/>
  35. <inputamt/>
  36. <outputamt/>
  37. <endmonamt/>
  38. <instcd/>
  39. <winacnt/>
  40. </mtaltotllist>
  41. </temp>
  42. </root>
  43. </instance>
  44. <script type="javascript" ev:event="xforms-ready">
  45. <![CDATA[
  46. fInitialize();
  47. ]]>
  48. </script>
  49. <submission id="TRRST06001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/goodreq" resultref="/root/main/mtaltotllist"/>
  50. </model>
  51. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  52. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  53. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  54. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  55. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  56. <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
  57. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  58. <script type="javascript">
  59. <![CDATA[
  60. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  61. function fInitialize()
  62. {
  63. rszfUserReqInstList(cmb_instcd,getUserInfo("userid"),"%","B");
  64. cmb_instcd.refresh();
  65. model.setValue(cmb_instcd.attribute("ref"), getUserInfo("dutplceinstcd"));
  66. cmb_instcd.refresh();
  67. model.setValue(ipt_inputmonth.attribute("ref"), getCurrentDate().substr(0, 6));
  68. ipt_inputmonth.refresh();
  69. }
  70. function fSetSumAmt() {
  71. var trnsamt = 0;
  72. var inputamt = 0;
  73. var outputamt = 0;
  74. var endmonamt = 0;
  75. var winacnt = "";
  76. //진료재료
  77. var trnsamt_11202 = 0;
  78. var inputamt_11202 = 0;
  79. var outputamt_11202 = 0;
  80. var endmonamt_11202 = 0;
  81. var idx_11202 = 0;
  82. //급식재료
  83. var trnsamt_11203 = 0;
  84. var inputamt_11203 = 0;
  85. var outputamt_11203 = 0;
  86. var endmonamt_11203 = 0;
  87. var idx_11203 =0;
  88. //저장품
  89. var trnsamt_11204 = 0;
  90. var inputamt_11204 = 0;
  91. var outputamt_11204 = 0;
  92. var endmonamt_11204 = 0;
  93. var idx_11204 = 0;
  94. //공기구비품
  95. var trnsamt_12207 = 0;
  96. var inputamt_12207 = 0;
  97. var outputamt_12207 = 0;
  98. var endmonamt_12207 = 0;
  99. var idx_12207 = 0;
  100. //기계장치
  101. var trnsamt_12204 = 0;
  102. var inputamt_12204 = 0;
  103. var outputamt_12204 = 0;
  104. var endmonamt_12204 = 0;
  105. var idx_12204 = 0;
  106. //의료장비
  107. var trnsamt_12205 = 0;
  108. var inputamt_12205 = 0;
  109. var outputamt_12205 = 0;
  110. var endmonamt_12205 = 0;
  111. var idx_12205 = 0;
  112. //차량운반구
  113. var trnsamt_12206 = 0;
  114. var inputamt_12206 = 0;
  115. var outputamt_12206 = 0;
  116. var endmonamt_12206 = 0;
  117. var idx_12206 = 0;
  118. var cnt_11202 = 0;
  119. var cnt_11203 = 0;
  120. var cnt_11204 = 0;
  121. var cnt_12204 = 0;
  122. var cnt_12205 = 0;
  123. var cnt_12206 = 0;
  124. var cnt_12207 = 0;
  125. var sumtrnsamt =0;
  126. var suminputamt = 0;
  127. var sumoutputamt = 0;
  128. var sumendmonamt =0;
  129. for(var i = grd_mtaltotllist.fixedRows; i < grd_mtaltotllist.rows; i++) {
  130. winacnt = grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("winacnt")).substr(0, 5);
  131. sumtrnsamt += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
  132. suminputamt += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
  133. sumoutputamt += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
  134. sumendmonamt += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
  135. if(winacnt == "11202") { //진료재료
  136. trnsamt_11202 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
  137. inputamt_11202 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
  138. outputamt_11202 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
  139. endmonamt_11202 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
  140. idx_11202 = i;
  141. cnt_11202++;
  142. } else if(winacnt == "11203") { //급식재료
  143. trnsamt_11203 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
  144. inputamt_11203 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
  145. outputamt_11203 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
  146. endmonamt_11203 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
  147. idx_11203 = i;
  148. cnt_11203++;
  149. } else if(winacnt =="11204") { //저장품
  150. trnsamt_11204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
  151. inputamt_11204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
  152. outputamt_11204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
  153. endmonamt_11204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
  154. idx_11204 = i;
  155. cnt_11204++;
  156. } else if(winacnt =="12204") { //기계장치
  157. trnsamt_12204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
  158. inputamt_12204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
  159. outputamt_12204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
  160. endmonamt_12204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
  161. idx_12204 = i;
  162. cnt_12204++;
  163. } else if(winacnt =="12205") { //의료장비
  164. trnsamt_12205 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
  165. inputamt_12205 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
  166. outputamt_12205 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
  167. endmonamt_12205 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
  168. idx_12205 = i;
  169. cnt_12205++;
  170. } else if(winacnt =="12206") { //차량운반구
  171. trnsamt_12206 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
  172. inputamt_12206 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
  173. outputamt_12206 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
  174. endmonamt_12206 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
  175. idx_12206 = i;
  176. cnt_12206++
  177. }else if(winacnt =="12207") { //공기구비품
  178. trnsamt_12207 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
  179. inputamt_12207 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
  180. outputamt_12207 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
  181. endmonamt_12207 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
  182. idx_12207 = i;
  183. cnt_12207++;
  184. }
  185. }
  186. if(cnt_11202 != 0) {
  187. grd_mtaltotllist.insertRow(idx_11202 ,"below", "false", "true");
  188. grd_mtaltotllist.valueMatrix(idx_11202+1, grd_mtaltotllist.colRef("acntflagnm")) = "▶진료재료품";
  189. grd_mtaltotllist.valueMatrix(idx_11202+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_11202;
  190. grd_mtaltotllist.valueMatrix(idx_11202+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_11202;
  191. grd_mtaltotllist.valueMatrix(idx_11202+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_11202;
  192. grd_mtaltotllist.valueMatrix(idx_11202+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_11202;
  193. idx_11202 += 1;
  194. idx_11203 += 1;
  195. idx_11204 += 1;
  196. idx_12204 += 1;
  197. idx_12205 += 1;
  198. idx_12206 += 1;
  199. idx_12207 += 1;
  200. }
  201. if(cnt_11203 != 0) {
  202. grd_mtaltotllist.insertRow(idx_11203 ,"below", "false", "true");
  203. grd_mtaltotllist.valueMatrix(idx_11203+1, grd_mtaltotllist.colRef("acntflagnm")) = "▶급식재료품";
  204. grd_mtaltotllist.valueMatrix(idx_11203+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_11203;
  205. grd_mtaltotllist.valueMatrix(idx_11203+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_11203;
  206. grd_mtaltotllist.valueMatrix(idx_11203+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_11203;
  207. grd_mtaltotllist.valueMatrix(idx_11203+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_11203;
  208. idx_11202 += 1;
  209. idx_11203 += 1;
  210. idx_11204 += 1;
  211. idx_12204 += 1;
  212. idx_12205 += 1;
  213. idx_12206 += 1;
  214. idx_12207 += 1;
  215. }
  216. if(cnt_11204 != 0) {
  217. grd_mtaltotllist.insertRow(idx_11204 ,"below", "false", "true");
  218. grd_mtaltotllist.valueMatrix(idx_11204+1, grd_mtaltotllist.colRef("acntflagnm")) = "▶저장품";
  219. grd_mtaltotllist.valueMatrix(idx_11204+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_11204;
  220. grd_mtaltotllist.valueMatrix(idx_11204+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_11204;
  221. grd_mtaltotllist.valueMatrix(idx_11204+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_11204;
  222. grd_mtaltotllist.valueMatrix(idx_11204+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_11204;
  223. idx_11202 += 1;
  224. idx_11203 += 1;
  225. idx_11204 += 1;
  226. idx_12204 += 1;
  227. idx_12205 += 1;
  228. idx_12206 += 1;
  229. idx_12207 += 1;
  230. }
  231. if(cnt_12204 != 0) {
  232. grd_mtaltotllist.insertRow(idx_12204 ,"below", "false", "true");
  233. grd_mtaltotllist.valueMatrix(idx_12204+1, grd_mtaltotllist.colRef("acntflagnm")) = "[기계장치]";
  234. grd_mtaltotllist.valueMatrix(idx_12204+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_12204;
  235. grd_mtaltotllist.valueMatrix(idx_12204+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_12204;
  236. grd_mtaltotllist.valueMatrix(idx_12204+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_12204;
  237. grd_mtaltotllist.valueMatrix(idx_12204+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_12204;
  238. idx_11202 += 1;
  239. idx_11203 += 1;
  240. idx_11204 += 1;
  241. idx_12204 += 1;
  242. idx_12205 += 1;
  243. idx_12206 += 1;
  244. idx_12207 += 1;
  245. }
  246. if(cnt_12205 != 0) {
  247. grd_mtaltotllist.insertRow(idx_12205 ,"below", "false", "true");
  248. grd_mtaltotllist.valueMatrix(idx_12205+1, grd_mtaltotllist.colRef("acntflagnm")) = "[의료장비]";
  249. grd_mtaltotllist.valueMatrix(idx_12205+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_12205;
  250. grd_mtaltotllist.valueMatrix(idx_12205+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_12205;
  251. grd_mtaltotllist.valueMatrix(idx_12205+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_12205;
  252. grd_mtaltotllist.valueMatrix(idx_12205+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_12205;
  253. idx_11202 += 1;
  254. idx_11203 += 1;
  255. idx_11204 += 1;
  256. idx_12204 += 1;
  257. idx_12205 += 1;
  258. idx_12206 += 1;
  259. idx_12207 += 1;
  260. }
  261. if(cnt_12206 != 0) {
  262. grd_mtaltotllist.insertRow(idx_12206 ,"below", "false", "true");
  263. grd_mtaltotllist.valueMatrix(idx_12206+1, grd_mtaltotllist.colRef("acntflagnm")) = "[차량운반구]";
  264. grd_mtaltotllist.valueMatrix(idx_12206+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_12206;
  265. grd_mtaltotllist.valueMatrix(idx_12206+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_12206;
  266. grd_mtaltotllist.valueMatrix(idx_12206+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_12206;
  267. grd_mtaltotllist.valueMatrix(idx_12206+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_12206;
  268. //
  269. idx_11202 += 1;
  270. idx_11203 += 1;
  271. idx_11204 += 1;
  272. idx_12204 += 1;
  273. idx_12205 += 1;
  274. idx_12206 += 1;
  275. idx_12207 += 1;
  276. }
  277. if(cnt_12207 != 0) {
  278. grd_mtaltotllist.insertRow(idx_12207 ,"below", "false", "true");
  279. grd_mtaltotllist.valueMatrix(idx_12207+1, grd_mtaltotllist.colRef("acntflagnm")) = "[공기구비품]";
  280. grd_mtaltotllist.valueMatrix(idx_12207+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_12207;
  281. grd_mtaltotllist.valueMatrix(idx_12207+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_12207;
  282. grd_mtaltotllist.valueMatrix(idx_12207+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_12207;
  283. grd_mtaltotllist.valueMatrix(idx_12207+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_12207;
  284. idx_11202 += 1;
  285. idx_11203 += 1;
  286. idx_11204 += 1;
  287. idx_12204 += 1;
  288. idx_12205 += 1;
  289. idx_12206 += 1;
  290. idx_12207 += 1;
  291. }
  292. grd_mtaltotllist.addRow();
  293. grd_mtaltotllist.valueMatrix(grd_mtaltotllist.rows-1, grd_mtaltotllist.colRef("acntflagnm")) = "총계";
  294. grd_mtaltotllist.valueMatrix(grd_mtaltotllist.rows-1, grd_mtaltotllist.colRef("trnsamt")) = sumtrnsamt;
  295. grd_mtaltotllist.valueMatrix(grd_mtaltotllist.rows-1, grd_mtaltotllist.colRef("inputamt")) = suminputamt;
  296. grd_mtaltotllist.valueMatrix(grd_mtaltotllist.rows-1, grd_mtaltotllist.colRef("outputamt")) = sumoutputamt;
  297. grd_mtaltotllist.valueMatrix(grd_mtaltotllist.rows-1, grd_mtaltotllist.colRef("endmonamt")) = sumendmonamt;
  298. }
  299. ]]>
  300. </script>
  301. </xhtml:head>
  302. <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  303. <group id="grp_tle" style="left:0px; top:0px; width:805px; height:13px; ">
  304. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:243px; height:14px; ">자재재고총괄표</caption>
  305. </group>
  306. <group id="grp_biz" scroll="auto" style="left:0px; top:12px; width:805px; height:744px; ">
  307. <datagrid id="grd_mtaltotllist2" caption="품명^이월금액^입고금액^출고금액^재고금액^caption1^caption2^caption3^caption4" colsep="^" colwidth="166, 150, 150, 150, 150, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:80px; width:805px; height:660px; ">
  308. <col ref="acntflagnm" style="text-align:left; padding-left:10; "/>
  309. <col ref="trnsamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
  310. <col ref="inputamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
  311. <col ref="outputamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
  312. <col ref="endmonamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
  313. <col ref="inputmonth" visibility="hidden"/>
  314. <col ref="logurl" visibility="hidden"/>
  315. <col ref="instcd" visibility="hidden"/>
  316. <col ref="winacnt"/>
  317. <script type="javascript" ev:event="ondblclick">
  318. <![CDATA[
  319. model.property("acntflag") = grd_mtaltotllist
  320. ]]>
  321. </script>
  322. </datagrid>
  323. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:804px; height:40px; "/>
  324. <select1 id="cmb_instcd" ref="/root/send/goodreq/instcd" class="combo_s_essential" appearance="minimal" style="left:95px; top:19px; width:120px; height:19px; ">
  325. <choices>
  326. <itemset nodeset="/root/init/instcd">
  327. <label ref="cdnm"/>
  328. <value ref="cdid"/>
  329. </itemset>
  330. </choices>
  331. </select1>
  332. <caption id="caption14" class="search_name" style="left:5px; top:19px; width:91px; height:17px; ">기관코드 :</caption>
  333. <line id="line14" class="line_4" style="x1:665px; y1:17px; x2:665px; y2:44px; "/>
  334. <button id="btn_search" class="btn1_letter2" navindex="7" style="left:675px; top:20px; width:56px; height:22px; text-align:left; ">
  335. <caption>조회</caption>
  336. <script type="javascript" ev:event="DOMActivate">
  337. <![CDATA[
  338. grd_mtaltotllist2.visible = true;
  339. submit("TRRST06001");
  340. //
  341. fSetSumAmt();
  342. grd_mtaltotllist2.visible = false;
  343. ]]>
  344. </script>
  345. </button>
  346. <datagrid id="grd_mtaltotllist" nodeset="/root/main/mtaltotllist" caption="품명^이월금액^입고금액^출고금액^재고금액^수탁재고^가납재고^구매재고^caption1^caption2^caption3^caption4^caption5" colsep="^" colwidth="166, 150, 150, 150, 150, 100, 100, 100, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:80px; width:805px; height:660px; ">
  347. <col ref="acntflagnm" style="text-align:left; "/>
  348. <col ref="trnsamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
  349. <col ref="inputamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
  350. <col ref="outputamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
  351. <col ref="endmonamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
  352. <col ref="endmonamt2" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
  353. <col ref="endmonamt3" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
  354. <col ref="endmonamt1" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
  355. <col ref="inputmonth" visibility="hidden"/>
  356. <col ref="logurl" visibility="hidden"/>
  357. <col ref="instcd" visibility="hidden"/>
  358. <col ref="winacnt" visibility="hidden"/>
  359. <col ref="acntflag" visibility="hidden"/>
  360. <script type="javascript" ev:event="ondblclick">
  361. <![CDATA[
  362. if(grd_mtaltotllist.valueMatrix(grd_mtaltotllist.row, grd_mtaltotllist.colRef("acntflag")) != "") {
  363. model.property("acntflag") = grd_mtaltotllist.valueMatrix(grd_mtaltotllist.row, grd_mtaltotllist.colRef("acntflag"))
  364. model.property("acntflagnm") = grd_mtaltotllist.valueMatrix(grd_mtaltotllist.row, grd_mtaltotllist.colRef("acntflagnm"))
  365. model.property("stkmonth") = model.getValue(ipt_inputmonth.attribute("ref"));
  366. model.property("instcd") = model.getValue(cmb_instcd.attribute("ref"));
  367. modal("SMRST06300");
  368. } else {
  369. messageBox("계정세부항목을 선택하여주세요.", "E");
  370. return;
  371. }
  372. ]]>
  373. </script>
  374. </datagrid>
  375. <caption id="caption5" class="tit_2" style="left:5px; top:60px; width:136px; height:14px; ">자재재고총괄표</caption>
  376. <line id="line1" class="line_1" style="x1:0px; y1:75px; x2:805px; y2:75px; "/>
  377. <caption id="caption1" class="search_name" style="left:230px; top:20px; width:91px; height:17px; ">입고년월 :</caption>
  378. <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; "/>
  379. <button id="btn_print" class="btn1_letter2" style="left:735px; top:20px; width:56px; height:22px; ">
  380. <caption>출력</caption>
  381. <script type="javascript" ev:event="DOMActivate">
  382. <![CDATA[
  383. model.makeNode("/root/send/report/mtaltotllist");
  384. for(var i = grd_mtaltotllist.fixedRows; i < grd_mtaltotllist.rows; i++) {
  385. grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputmonth")) = model.getValue(ipt_inputmonth.attribute("ref"));
  386. grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("logurl")) = getImageURL("biglogo"+getUserInfo("dutplceinstcd"), "jpg");
  387. }
  388. copyNodesetType("/root/send/report/mtaltotllist", grd_mtaltotllist.nodeset);
  389. exeReportPreview("RPRST06001", "XMLSTR", "/root/send/report");
  390. ]]>
  391. </script>
  392. </button>
  393. <button id="button1" class="btn2_letter4" style="left:740px; top:55px; width:64px; height:19px; ">
  394. <caption>엑셀저장</caption>
  395. <script type="javascript" ev:event="DOMActivate">
  396. <![CDATA[
  397. var fileName = window.fileDialog("save", ",", false, "자재재고총괄표", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  398. if (fileName != "")
  399. {
  400. grd_mtaltotllist.saveExcel(fileName, "자재재고총괄표");
  401. }
  402. ]]>
  403. </script>
  404. </button>
  405. <select id="ckb_goodflagyn" ref="/root/send/goodreq/purcflag" overflow="visible" appearance="full" style="left:500px; top:56px; width:155px; height:15px; border-style:none; ">
  406. <choices>
  407. <item>
  408. <label>재고금액 수탁/가납 제외</label>
  409. <value>Y</value>
  410. </item>
  411. </choices>
  412. </select>
  413. </group>
  414. </xhtml:body>
  415. </xhtml:html>