SPPIE04210_재료수가변경내역조회.xrw 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593
  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. <mech>
  11. <instcd/>
  12. <calcscorcd/>
  13. <insuedicd/>
  14. <hngnm/>
  15. <fromdd/>
  16. <todd/>
  17. <purcamt/>
  18. <gnrlrbpnt/>
  19. <fstrgstrid/>
  20. <fstrgstdt/>
  21. <lastupdtrid/>
  22. <lastupdtdt/>
  23. </mech>
  24. <cont>
  25. <instcd/>
  26. <goodflag/>
  27. <goodcd/>
  28. <goodnm/>
  29. <purccondd/>
  30. <purcconno/>
  31. <purcconseq/>
  32. <conqty/>
  33. <congoodunitcost/>
  34. <chkyn/>
  35. <fstrgstrid/>
  36. <fstrgstdt/>
  37. <lastupdtrid/>
  38. <lastupdtdt/>
  39. </cont>
  40. <wchk>
  41. <instcd/>
  42. <goodflag/>
  43. <goodcd/>
  44. <purcchkdd/>
  45. <purcchkno/>
  46. <purcchkseq/>
  47. <purccondd/>
  48. <purcconno/>
  49. <chkqty/>
  50. <chkgoodunitcost/>
  51. <chkamt/>
  52. <acntcd/>
  53. <delivedeptcd/>
  54. <fstrgstrid/>
  55. <fstrgstdt/>
  56. <lastupdtrid/>
  57. <lastupdtdt/>
  58. </wchk>
  59. <pur>
  60. <instcd/>
  61. <kwanri_gubun/>
  62. <pum_code/>
  63. <pum_name/>
  64. <ky_ymd/>
  65. <ky_seq/>
  66. <ibgo_ymd/>
  67. <ibgo_seq/>
  68. <qty/>
  69. <danga1/>
  70. <keumak/>
  71. <chul_buseo/>
  72. <user_id/>
  73. <sys_date/>
  74. <upd_date/>
  75. </pur>
  76. <h604>
  77. <instcd/>
  78. <goodcd/>
  79. <edicd/>
  80. <itemnm/>
  81. <appdd/>
  82. <appseqno/>
  83. <windd/>
  84. <winqty/>
  85. <winamt/>
  86. <oneunitcost/>
  87. <notiyn/>
  88. <fstrgstrid/>
  89. <fstrgstdt/>
  90. <lastupdtrid/>
  91. <lastupdtdt/>
  92. </h604>
  93. <h602>
  94. <instcd/>
  95. <goodcd/>
  96. <appitemcd/>
  97. <itemnm/>
  98. <appno/>
  99. <reptflag/>
  100. <lnno/>
  101. <winno/>
  102. <winseqno/>
  103. <purcdd/>
  104. <purcqty/>
  105. <purcamt/>
  106. <oneunitcost/>
  107. <statcd/>
  108. <fstrgstrid/>
  109. <fstrgstdt/>
  110. <lastupdtrid/>
  111. <lastupdtdt/>
  112. </h602>
  113. </main>
  114. <send>
  115. <fromdd/>
  116. <todd/>
  117. <srchflag/>
  118. </send>
  119. <init>
  120. <target>
  121. <cont>계약</cont>
  122. <wchk>검수</wchk>
  123. <pur>입고</pur>
  124. <h604>집계</h604>
  125. <h602>신고</h602>
  126. </target>
  127. </init>
  128. <hidden>
  129. <rowcnt/>
  130. </hidden>
  131. <temp>
  132. <xlslist>
  133. <col1/>
  134. </xlslist>
  135. </temp>
  136. </root>
  137. </instance>
  138. <submission id="TRPIE04301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main"/>
  139. </model>
  140. <script type="javascript" ev:event="xforms-ready">
  141. <![CDATA[
  142. grd_mech.rowHeightMin = 23;
  143. grd_cont.rowHeightMin = 23;
  144. grd_wchk.rowHeightMin = 23;
  145. grd_pur.rowHeightMin = 23;
  146. grd_h604.rowHeightMin = 23;
  147. grd_h602.rowHeightMin = 23;
  148. grd_target.row = 0;
  149. grd_target.col = 0;
  150. model.toggle("cont");
  151. model.setValue("/root/send/srchflag", "cont");
  152. model.setValue("/root/send/fromdd", getCurrentDate());
  153. model.setValue("/root/send/todd", getCurrentDate());
  154. ipt_fromdd.refresh();
  155. ipt_todd.refresh();
  156. ]]>
  157. </script>
  158. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  159. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  160. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  161. <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
  162. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  163. <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
  164. </xhtml:head>
  165. <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  166. <caption id="caption1" class="tit_1" style="left:0px; top:0px; width:165px; height:14px; ">재료 수가 변경 내역 조회</caption>
  167. <datagrid id="grd_mech" nodeset="/root/main/mech" autoresize="true" backcoloralternate="transparent" caption="기관코드^수가코드^EDI코드^수가명^수가시작일^수가종료일^구입가^최초작성자^최초작성일^최종수정자^최종수정일^일반가^보험가" colsep="^" colwidth="0, 80, 0, 200, 75, 0, 75, 0, 0, 0, 0, 75, 75" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:85px; width:595px; height:680px; ">
  168. <col ref="instcd"/>
  169. <col explorerbar="sortshow" ref="calcscorcd" style="text-align:center; "/>
  170. <col ref="insuedicd" style="text-align:center; "/>
  171. <col explorerbar="sortshow" ref="hngnm"/>
  172. <col ref="fromdd" format="yyyy-mm-dd" style="text-align:center; "/>
  173. <col ref="todd" format="yyyy-mm-dd" style="text-align:center; "/>
  174. <col explorerbar="sortshow" ref="purcamt" format="#,###" style="font-weight:bold; text-align:right; "/>
  175. <col ref="fstrgstrid"/>
  176. <col ref="fstrgstdt"/>
  177. <col ref="lastupdtrid"/>
  178. <col ref="lastupdtdt"/>
  179. <col ref="gnrlrbpnt" format="#,###.#" style="font-weight:bold; text-align:right; "/>
  180. <col ref="insurbpnt" format="#,###.#" style="font-weight:bold; text-align:right; "/>
  181. <script type="javascript" ev:event="onclick">
  182. <![CDATA[
  183. if (!grd_mech.isCell(event.target) || grd_mech.row < 1) {
  184. return;
  185. }
  186. var calcscorcd = model.getValue("/root/main/mech[" + grd_mech.row + "]/calcscorcd");
  187. var flag = model.getValue("/root/send/srchflag");
  188. var grd = document.controls("grd_" + flag);
  189. var row = grd.findRow(calcscorcd, 0, 2, false, true);
  190. if (row > 0) {
  191. model.setFocus("grd_" + flag);
  192. grd.row = row;
  193. } else {
  194. grd.row = 0;
  195. }
  196. ]]>
  197. </script>
  198. <script type="javascript" ev:event="onaftersort">
  199. <![CDATA[
  200. grd_mech.gridToInstance();
  201. grd_mech.resizeCells();
  202. ]]>
  203. </script>
  204. </datagrid>
  205. <caption id="caption6" class="tit_2" style="left:5px; top:65px; width:90px; height:13px; ">재료 수가</caption>
  206. <line id="line3" class="line_1" style="x1:0px; y1:80px; x2:595px; y2:80px; "/>
  207. <switch id="switch1" style="left:600px; top:60px; width:595px; height:705px; border-width:0; border-style:solid; ">
  208. <case id="cont" selected="true" style="left:0px; top:0px; width:100.00%; height:100.00%; ">
  209. <line id="line1" class="line_1" style="x1:0px; y1:20px; x2:595px; y2:20px; "/>
  210. <datagrid id="grd_cont" nodeset="/root/main/cont" autoresize="true" backcoloralternate="transparent" caption="기관코드^물품구분^물품코드^물품명^계약일자^계약번호^계약순번^계약량^계약단가^검수여부^최초작성자^최초작성일시^최종수정자^최종수정일시^최종수정일" colsep="^" colwidth="0, 0, 80, 200, 80, 60, 0, 0, 80, 0, 0, 0, 0, 0, 80" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:595px; height:680px; ">
  211. <col ref="instcd"/>
  212. <col ref="goodflag"/>
  213. <col explorerbar="sortshow" ref="goodcd" style="text-align:center; "/>
  214. <col explorerbar="sortshow" ref="goodnm"/>
  215. <col ref="purccondd" format="yyyy-mm-dd" style="text-align:center; "/>
  216. <col ref="purcconno" style="text-align:center; "/>
  217. <col ref="purcconseq"/>
  218. <col ref="conqty"/>
  219. <col ref="congoodunitcost" format="#,###" style="font-weight:bold; text-align:right; "/>
  220. <col ref="chkyn"/>
  221. <col ref="fstrgstrid"/>
  222. <col ref="fstrgstdt"/>
  223. <col ref="lastupdtrid"/>
  224. <col ref="lastupdtdt"/>
  225. <col ref="lastupdtdd" format="yyyy-mm-dd" style="text-align:center; "/>
  226. <script type="javascript" ev:event="onclick">
  227. <![CDATA[
  228. if (!grd_cont.isCell(event.target) || grd_cont.row < 1) {
  229. return;
  230. }
  231. var goodcd = model.getValue("/root/main/cont[" + grd_cont.row + "]/goodcd");
  232. var row = grd_mech.findRow(goodcd, 0, 1, false, true);
  233. if (row > 0) {
  234. model.setFocus("grd_mech");
  235. grd_mech.row = row;
  236. } else {
  237. grd_mech.row = 0;
  238. }
  239. ]]>
  240. </script>
  241. <script type="javascript" ev:event="onaftersort">
  242. <![CDATA[
  243. grd_cont.gridToInstance();
  244. grd_cont.resizeCells();
  245. ]]>
  246. </script>
  247. </datagrid>
  248. <caption id="caption7" class="tit_2" style="left:0px; top:5px; width:105px; height:13px; ">계약 내역</caption>
  249. </case>
  250. <case id="wchk">
  251. <datagrid id="grd_wchk" nodeset="/root/main/wchk" autoresize="true" backcoloralternate="transparent" caption="기관코드^물품구분^물품코드^검수일자^검수번호^검수순번^계약일자^계약번호^검수수량^검수단가^검수금액^계정과목^출고부서^최초작성자^최초작성일시^최종수정자^최종수정일시^최종수정일" colsep="^" colwidth="0, 0, 80, 80, 60, 0, 80, 60, 60, 80, 0, 0, 0, 0, 0, 0, 0, 80" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:595px; height:680px; ">
  252. <col ref="instcd"/>
  253. <col ref="goodflag"/>
  254. <col explorerbar="sortshow" ref="goodcd" style="text-align:center; "/>
  255. <col explorerbar="sortshow" ref="purcchkdd" format="yyyy-mm-dd" style="text-align:center; "/>
  256. <col ref="purcchkno" style="text-align:center; "/>
  257. <col ref="purcchkseq"/>
  258. <col explorerbar="sortshow" ref="purccondd" format="yyyy-mm-dd" style="text-align:center; "/>
  259. <col ref="purcconno" style="text-align:center; "/>
  260. <col ref="chkqty" style="text-align:center; "/>
  261. <col ref="chkgoodunitcost" format="#,###" style="font-weight:bold; text-align:right; "/>
  262. <col ref="chkamt"/>
  263. <col ref="acntcd"/>
  264. <col ref="delivedeptcd"/>
  265. <col ref="fstrgstrid"/>
  266. <col ref="fstrgstdt"/>
  267. <col ref="lastupdtrid"/>
  268. <col ref="lastupdtdt"/>
  269. <col ref="lastupdtdd" format="yyyy-mm-dd" style="text-align:center; "/>
  270. <script type="javascript" ev:event="onclick">
  271. <![CDATA[
  272. if (!grd_wchk.isCell(event.target) || grd_wchk.row < 1) {
  273. return;
  274. }
  275. var goodcd = model.getValue("/root/main/wchk[" + grd_wchk.row + "]/goodcd");
  276. var row = grd_mech.findRow(goodcd, 0, 1, false, true);
  277. if (row > 0) {
  278. model.setFocus("grd_mech");
  279. grd_mech.row = row;
  280. } else {
  281. grd_mech.row = 0;
  282. model.resetInstanceNode("/root/main/mech");
  283. grd_mech.refresh();
  284. }
  285. ]]>
  286. </script>
  287. <script type="javascript" ev:event="onaftersort">
  288. <![CDATA[
  289. grd_wchk.gridToInstance();
  290. grd_wchk.resizeCells();
  291. ]]>
  292. </script>
  293. </datagrid>
  294. <caption id="caption2" class="tit_2" style="left:5px; top:5px; width:100px; height:13px; ">검수 내역</caption>
  295. <line id="line4" class="line_1" style="x1:0px; y1:20px; x2:595px; y2:20px; "/>
  296. </case>
  297. <case id="pur">
  298. <line id="line2" class="line_1" style="x1:0px; y1:20px; x2:595px; y2:20px; "/>
  299. <caption id="caption8" class="tit_2" style="left:0px; top:5px; width:85px; height:13px; ">구매 내역</caption>
  300. <datagrid id="grd_pur" nodeset="/root/main/pur" autoresize="true" backcoloralternate="transparent" caption="기관코드^관리구분^물품코드^물품명^계약일자^계약번호^입고일자^입고순번^구입량^구입단가^구입금액^출고부서^최초작성자^최초작성일시^최종수정일시^최종수정일" colsep="^" colwidth="0, 0, 80, 200, 0, 0, 80, 0, 60, 80, 0, 0, 0, 0, 0, 80" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:595px; height:680px; ">
  301. <col ref="instcd"/>
  302. <col ref="kwanri_gubun"/>
  303. <col explorerbar="sortshow" ref="pum_code" style="text-align:center; "/>
  304. <col explorerbar="sortshow" ref="pum_name"/>
  305. <col ref="ky_ymd"/>
  306. <col ref="ky_seq"/>
  307. <col ref="ibgo_ymd" format="yyyy-mm-dd" style="text-align:center; "/>
  308. <col ref="ibgo_seq"/>
  309. <col ref="qty" style="text-align:center; "/>
  310. <col ref="danga1" format="#,###" style="font-weight:bold; text-align:right; "/>
  311. <col ref="keumak"/>
  312. <col ref="chul_buseo"/>
  313. <col ref="user_id"/>
  314. <col ref="sys_date"/>
  315. <col ref="upd_date"/>
  316. <col ref="upd_dd" format="yyyy-mm-dd" style="text-align:center; "/>
  317. <script type="javascript" ev:event="onclick">
  318. <![CDATA[
  319. if (!grd_pur.isCell(event.target) || grd_pur.row < 1) {
  320. return;
  321. }
  322. var pum_code = model.getValue("/root/main/pur[" + grd_pur.row + "]/pum_code");
  323. var row = grd_mech.findRow(pum_code, 0, 1, false, true);
  324. if (row > 0) {
  325. model.setFocus("grd_mech");
  326. grd_mech.row = row;
  327. } else {
  328. grd_mech.row = 0;
  329. model.resetInstanceNode("/root/main/mech");
  330. grd_mech.refresh();
  331. }
  332. ]]>
  333. </script>
  334. <script type="javascript" ev:event="onaftersort">
  335. <![CDATA[
  336. grd_pur.gridToInstance();
  337. grd_pur.resizeCells();
  338. ]]>
  339. </script>
  340. </datagrid>
  341. </case>
  342. <case id="h604">
  343. <datagrid id="grd_h604" nodeset="/root/main/h604" autoresize="true" backcoloralternate="transparent" caption="기관코드^신청여부^물품코드^EDI코드^물품명^신청일자^신청일련번호^구입량^구입가^개당단가^입고일자" colsep="^" colwidth="0, 0, 80, 0, 200, 80, 0, 60, 0, 80, 80" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:595px; height:680px; ">
  344. <col ref="instcd"/>
  345. <col ref="notiyn"/>
  346. <col explorerbar="sortshow" ref="goodcd" style="text-align:center; "/>
  347. <col ref="edicd"/>
  348. <col explorerbar="sortshow" ref="itemnm"/>
  349. <col ref="appdd" format="yyyy-mm-dd" style="text-align:center; "/>
  350. <col ref="appseqno"/>
  351. <col ref="winqty" style="text-align:center; "/>
  352. <col ref="winamt"/>
  353. <col ref="oneunitcost" format="#,###" style="font-weight:bold; text-align:right; "/>
  354. <col ref="windd" format="yyyy-mm-dd" style="text-align:center; "/>
  355. <script type="javascript" ev:event="onclick">
  356. <![CDATA[
  357. if (!grd_h604.isCell(event.target) || grd_h604.row < 1) {
  358. return;
  359. }
  360. var goodcd = model.getValue("/root/main/h604[" + grd_h604.row + "]/goodcd");
  361. var row = grd_mech.findRow(goodcd, 0, 1, false, true);
  362. if (row > 0) {
  363. model.setFocus("grd_mech");
  364. grd_mech.row = row;
  365. } else {
  366. grd_mech.row = 0;
  367. model.resetInstanceNode("/root/main/mech");
  368. grd_mech.refresh();
  369. }
  370. ]]>
  371. </script>
  372. <script type="javascript" ev:event="onaftersort">
  373. <![CDATA[
  374. grd_h604.gridToInstance();
  375. grd_h604.resizeCells();
  376. ]]>
  377. </script>
  378. </datagrid>
  379. <line id="line5" class="line_1" style="x1:0px; y1:20px; x2:595px; y2:20px; "/>
  380. <caption id="caption5" class="tit_2" style="left:0px; top:5px; width:85px; height:13px; ">발주 내역</caption>
  381. </case>
  382. <case id="h602">
  383. <caption id="caption9" class="tit_2" style="left:0px; top:5px; width:85px; height:13px; ">신고 내역</caption>
  384. <line id="line6" class="line_1" style="x1:0px; y1:20px; x2:595px; y2:20px; "/>
  385. <datagrid id="grd_h602" nodeset="/root/main/h602" autoresize="true" backcoloralternate="transparent" caption="기관코드^신고서구분^물품코드^신고품목코드^물품명^신청번호^줄번호^입고번호^입고순번^구입일자^구립량^구입가^개당단가^상태^최초작성자^최초작성일시^최종수정자^최종수정일시^최종수정일" colsep="^" colwidth="0, 0, 80, 0, 195, 85, 0, 0, 0, 0, 0, 0, 80, 60, 0, 0, 0, 0, 80" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:595px; height:680px; text-align:center; ">
  386. <col ref="instcd"/>
  387. <col ref="reptflag"/>
  388. <col explorerbar="sortshow" ref="goodcd" style="text-align:center; "/>
  389. <col ref="appitemcd"/>
  390. <col explorerbar="sortshow" ref="itemnm"/>
  391. <col ref="appno" style="text-align:center; "/>
  392. <col ref="lnno"/>
  393. <col ref="winno"/>
  394. <col ref="winseqno"/>
  395. <col ref="purcdd"/>
  396. <col ref="purcqty"/>
  397. <col ref="purcamt"/>
  398. <col ref="oneunitcost" format="#,###" style="font-weight:bold; text-align:right; "/>
  399. <col disabled="true" ref="statcd" type="combo">
  400. <choices>
  401. <item>
  402. <label>완료</label>
  403. <value>1</value>
  404. </item>
  405. <item>
  406. <label>미완료</label>
  407. <value>2</value>
  408. </item>
  409. <item>
  410. <label>SAM생성</label>
  411. <value>3</value>
  412. </item>
  413. <item>
  414. <label>전송</label>
  415. <value>4</value>
  416. </item>
  417. </choices>
  418. </col>
  419. <col ref="fstrgstrid"/>
  420. <col ref="fstrgstdt"/>
  421. <col ref="lastupdtrid"/>
  422. <col ref="lastupdtdt"/>
  423. <col ref="lastupdtdd" format="yyyy-mm-dd" style="text-align:center; "/>
  424. <script type="javascript" ev:event="onclick">
  425. <![CDATA[
  426. if (!grd_h602.isCell(event.target) || grd_h602.row < 1) {
  427. return;
  428. }
  429. var goodcd = model.getValue("/root/main/h602[" + grd_h602.row + "]/goodcd");
  430. var row = grd_mech.findRow(goodcd, 0, 1, false, true);
  431. if (row > 0) {
  432. model.setFocus("grd_mech");
  433. grd_mech.row = row;
  434. } else {
  435. grd_mech.row = 0;
  436. model.resetInstanceNode("/root/main/mech");
  437. grd_mech.refresh();
  438. }
  439. ]]>
  440. </script>
  441. <script type="javascript" ev:event="onaftersort">
  442. <![CDATA[
  443. grd_h602.gridToInstance();
  444. grd_h602.resizeCells();
  445. ]]>
  446. </script>
  447. </datagrid>
  448. </case>
  449. </switch>
  450. <shape id="roundrect1" appearance="roundrect" style="left:0px; top:20px; width:815px; height:35px; "/>
  451. <caption id="caption3" class="search_name" style="left:5px; top:30px; width:87px; height:17px; ">적용일자 :</caption>
  452. <input id="ipt_fromdd" ref="/root/send/fromdd" class="input_search" inputtype="date" format="yyyy-mm-dd" appearance="input" style="left:100px; top:29px; width:90px; height:19px; "/>
  453. <input id="ipt_todd" ref="/root/send/todd" class="input_search" inputtype="date" format="yyyy-mm-dd" appearance="input" style="left:206px; top:29px; width:90px; height:19px; "/>
  454. <caption id="cap_period" style="left:190px; top:31px; width:17px; height:17px; text-align:center; ">~</caption>
  455. <datagrid id="grd_target" nodeset="/root/init/target" allowselection="false" backcoloralternate="transparent" colsep="^" colwidth="50,50,50,50,50" mergecellsfixedrows="bycolrec" rowsep="|" selectionmode="free" style="left:454px; top:26px; width:251px; height:24px; background-color:#ffffff; border-left-width:1; border-top-width:1; border-right-width:0; border-bottom-width:0; border-style:solid; ">
  456. <col ref="cont" style="font-weight:bold; text-align:center; "/>
  457. <col ref="wchk" style="font-weight:bold; text-align:center; "/>
  458. <col ref="pur" style="font-weight:bold; text-align:center; "/>
  459. <col ref="h604" style="font-weight:bold; text-align:center; "/>
  460. <col ref="h602" style="font-weight:bold; text-align:center; "/>
  461. <script type="javascript" ev:event="onclick">
  462. <![CDATA[
  463. if (!grd_target.isCell(event.target)) {
  464. return;
  465. }
  466. var flag = grd_target.colAttribute(grd_target.col, "ref");
  467. model.toggle(flag);
  468. model.setValue("/root/send/srchflag", flag);
  469. ]]>
  470. </script>
  471. </datagrid>
  472. <caption id="caption4" class="search_name" style="left:350px; top:30px; width:87px; height:17px; ">비교대상 :</caption>
  473. <button id="btnSearch" class="btn1_letter2" navindex="13" style="left:745px; top:27px; width:56px; height:22px; ">
  474. <caption>조회</caption>
  475. <script type="javascript" ev:event="DOMActivate">
  476. <![CDATA[
  477. submit("TRPIE04301");
  478. model.setValue("/root/hidden/rowcnt", "Count : " + instance1.selectNodes("/root/main/mech").length);
  479. cap_rowcnt.refresh();
  480. ]]>
  481. </script>
  482. </button>
  483. <line id="line7" style="x1:726px; y1:25px; x2:726px; y2:50px; border-color:#FFD799; "/>
  484. <caption id="cap_rowcnt" ref="/root/hidden/rowcnt" style="left:465px; top:60px; width:115px; height:20px; font-weight:bold; color:#808080; text-align:right; "/>
  485. <button id="btn_excel" class="btn2_letter4" style="left:820px; top:35px; width:64px; height:19px; ">
  486. <caption>엑셀저장</caption>
  487. <script type="javascript" ev:event="DOMActivate">
  488. <![CDATA[
  489. var flag = model.getValue("/root/send/srchflag");
  490. var fileName = window.fileDialog("save", ",", false, "재료수가변경내역_" + "수가 vs " + model.getValue("/root/init/target/" + flag) + "_" + getCurrentDate(), "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  491. if (fileName == "") {
  492. return;
  493. }
  494. var grd = document.controls("grd_" + flag);
  495. model.resetInstanceNode("/root/temp/xlslist");
  496. var cols = grd_xls.cols;
  497. if (cols > 0) {
  498. for (var i = 0; i < cols; i++) {
  499. grd_xls.removeColumn(false);
  500. }
  501. }
  502. model.removeNode("/root/temp/xlslist");
  503. model.makeNode("/root/temp/xlslist");
  504. var colArr = new Array();
  505. var idx1 = 0;
  506. var capArr = grd_mech.caption.split("^");
  507. var cap = "";
  508. var wArr = new Array();
  509. for (var i = 0; i < grd_mech.cols; i++) {
  510. if (!grd_mech.colHidden(i)) {
  511. colArr[idx1] = grd_mech.colAttribute(i, "ref");
  512. cap += capArr[i] + "^";
  513. wArr[idx1] = Math.round(grd_mech.colWidth(i) * 1.2);
  514. idx1++;
  515. }
  516. }
  517. cap+= "VS^";
  518. colArr[idx1] = "blank";
  519. wArr[idx1] = 100;
  520. var idx2 = idx1 + 1;
  521. capArr = grd.caption.split("^");
  522. for (var i = 0; i < grd.cols; i++) {
  523. if (!grd.colHidden(i)) {
  524. colArr[idx2] = "t" + grd.colAttribute(i, "ref");
  525. cap += capArr[i] + "^";
  526. wArr[idx2] = Math.round(grd.colWidth(i) * 1.2);
  527. idx2++;
  528. }
  529. }
  530. cap = cap.substr(0, cap.length - 1);
  531. for (var i = 0; i < colArr.length; i++) {
  532. grd_xls.addColumn("ref:" + colArr[i] + "; type:output; ", false);
  533. grd_xls.colWidth(i) = wArr[i];
  534. }
  535. grd_xls.caption = cap;
  536. var cnt = instance1.selectNodes("/root/main/mech").length;
  537. for (var i = 1; i <= cnt; i++) {
  538. for (var j = 0; j < colArr.length; j++) {
  539. if (j == idx1) {
  540. continue;
  541. }
  542. if (j < idx1) {
  543. model.makeValue("/root/temp/xlslist[" + i + "]/" + colArr[j], model.getValue("/root/main/mech[" + i + "]/" + colArr[j]));
  544. } else {
  545. var ref = colArr[j].substr(1, colArr[j].length - 1);
  546. model.makeValue("/root/temp/xlslist[" + i + "]/" + colArr[j], model.getValue("/root/main/" + flag + "[" + i + "]/" + ref));
  547. }
  548. }
  549. }
  550. grd_xls.refresh();
  551. grd_xls.saveExcel(fileName, "sheetname:수가 vs " + model.getValue("/root/init/target/" + flag) + ";colhiddenextend:false;rowhiddenextend:false");
  552. messageBox("엑셀 저장이 완료되었습니다.", "I999");
  553. ]]>
  554. </script>
  555. </button>
  556. <datagrid id="grd_xls" nodeset="/root/temp/xlslist" visibility="hidden" caption="caption1" colsep="^" mergecellsfixedrows="bycolrec" rowsep="|" style="left:890px; top:20px; width:100px; height:35px; ">
  557. <col ref="col1"/>
  558. </datagrid>
  559. </xhtml:body>
  560. </xhtml:html>