SMRAD00800_거래처원장.xrw 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747
  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. <balamtpr>
  11. <list/>
  12. </balamtpr>
  13. <totalnotepr>
  14. <list/>
  15. </totalnotepr>
  16. <totalbalamtpr>
  17. <list/>
  18. </totalbalamtpr>
  19. <balamt>
  20. <instcd/>
  21. <supacntcd4/>
  22. <acntcd/>
  23. <entrregno/>
  24. <custnm/>
  25. <frdate/>
  26. <todate/>
  27. <acntyy/>
  28. </balamt>
  29. <totalnote>
  30. <instcd/>
  31. <supacntcd4/>
  32. <acntcd/>
  33. <entrregno/>
  34. <custnm/>
  35. <frdate/>
  36. <todate/>
  37. <acntyy/>
  38. </totalnote>
  39. <totalbalamt>
  40. <instcd/>
  41. <supacntcd4/>
  42. <acntcd/>
  43. <entrregno/>
  44. <custnm/>
  45. <frdate/>
  46. <todate/>
  47. <acntyy/>
  48. </totalbalamt>
  49. </main>
  50. <send>
  51. <retrparams>
  52. <instcd/>
  53. <supacntcd4/>
  54. <acntcd/>
  55. <entrregno/>
  56. <frdate/>
  57. <todate/>
  58. <acntyy/>
  59. <flag/>
  60. <instnm/>
  61. <selectedIndex/>
  62. <custnm/>
  63. </retrparams>
  64. <date/>
  65. <prntlist>
  66. </prntlist>
  67. </send>
  68. <init/>
  69. <temp/>
  70. </root>
  71. </instance>
  72. <submission id="TRRAD00801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/balamtpr"/>
  73. <submission id="TRRAD00802" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/totalnotepr"/>
  74. <submission id="TRRAD00803" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/totalbalamtpr"/>
  75. </model>
  76. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  77. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  78. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  79. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  80. <script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
  81. <script type="javascript" src="../../../mis/acntcommonweb/js/RAD001.js"/>
  82. <script type="javascript" ev:event="xforms-ready">
  83. <![CDATA[
  84. // fCheckAuth();//권한체크
  85. fInit();
  86. fSetDate();
  87. ]]>
  88. </script>
  89. <script type="javascript">
  90. <![CDATA[
  91. function fInit()
  92. {
  93. model.removenode("/root/main/balamtpr/list");
  94. model.removenode("/root/main/totalnotepr/list");
  95. model.removenode("/root/main/totalbalamtpr/list");
  96. misfComboComCdList("Z0007", cmb_instcd1, "N");
  97. misfComboComCdList("Z0007", cmb_instcd2, "N");
  98. misfComboComCdList("Z0007", cmb_instcd3, "N");
  99. model.setValue("/root/main/balamt/instcd", getUserInfo("dutplceinstcd"));
  100. model.setValue("/root/main/totalnote/instcd", getUserInfo("dutplceinstcd"));
  101. model.setValue("/root/main/totalbalamt/instcd", getUserInfo("dutplceinstcd"));
  102. racfAcntMngtListCombo("R0010", model.getValue("/root/main/balamt/instcd"), cmb_supacntcd41, "N");
  103. racfAcntMngtListCombo("R0010", model.getValue("/root/main/totalnote/instcd"), cmb_supacntcd42, "N");
  104. racfAcntMngtListCombo("R0010", model.getValue("/root/main/totalbalamt/instcd"), cmb_supacntcd43, "N");
  105. cmb_supacntcd41.select(0);
  106. cmb_supacntcd42.select(0);
  107. cmb_supacntcd43.select(0);
  108. model.setValue("/root/send/retrparams/flag", "balamt");
  109. radfCheckInstSearchAuth(getUserInfo("dutplceinstcd"), cmb_instcd1);
  110. radfCheckInstSearchAuth(getUserInfo("dutplceinstcd"), cmb_instcd2);
  111. radfCheckInstSearchAuth(getUserInfo("dutplceinstcd"), cmb_instcd3);
  112. model.refresh();
  113. }
  114. function fSetDate()
  115. {
  116. var dt = new Date(getCurrentDate().substr(0, 4), getCurrentDate().substr(4, 2), 0);
  117. ipt_frdate1.value = getCurrentDate().substr(0, 6) + "01";
  118. ipt_todate1.value = getCurrentDate().substr(0, 6) + dt.getDate();
  119. ipt_frdate2.value = getCurrentDate().substr(0, 6) + "01";
  120. ipt_todate2.value = getCurrentDate().substr(0, 6) + dt.getDate();
  121. ipt_frdate3.value = getCurrentDate().substr(0, 6) + "01";
  122. ipt_todate3.value = getCurrentDate().substr(0, 6) + dt.getDate();
  123. ipt_frdate1.dispatch("xforms-value-changed");
  124. ipt_frdate2.dispatch("xforms-value-changed");
  125. ipt_frdate3.dispatch("xforms-value-changed");
  126. }
  127. /*******************************
  128. 그리드에 색깔 넣기.
  129. ********************************/
  130. function fSetRowColor(pGrid)
  131. {
  132. var iCnt = 0;
  133. for(var i=0; i<pGrid.rows;i++)
  134. {
  135. if(pGrid.valueMatrix(i, pGrid.colRef("gubn")) == "0")
  136. {
  137. pGrid.rowStyle(i, "all", "background-color") = "#ccffff";
  138. }
  139. else if(pGrid.valueMatrix(i, pGrid.colRef("gubn")) == "3")
  140. {
  141. pGrid.rowStyle(i, "all", "background-color") = "#ffccff";
  142. }
  143. else if(pGrid.valueMatrix(i, pGrid.colRef("gubn")) == "4")
  144. {
  145. pGrid.rowStyle(i, "all", "background-color") = "#ffffcc";
  146. }
  147. }
  148. //pGrid.frozenRows = 1;
  149. // pGrid.frozenBottomRows = 1;
  150. // pGrid.backColorFrozen = "#dddddd";
  151. }
  152. function fRetrieve()
  153. {
  154. model.setValue("/root/send/retrparams/instcd", model.getValue("/root/main/" + model.getValue("/root/send/retrparams/flag") + "/instcd"));
  155. model.setValue("/root/send/retrparams/supacntcd4", model.getValue("/root/main/" + model.getValue("/root/send/retrparams/flag") + "/supacntcd4"));
  156. model.setValue("/root/send/retrparams/acntcd", model.getValue("/root/main/" + model.getValue("/root/send/retrparams/flag") + "/acntcd"));
  157. model.setValue("/root/send/retrparams/entrregno", model.getValue("/root/main/" + model.getValue("/root/send/retrparams/flag") + "/entrregno"));
  158. model.setValue("/root/send/retrparams/frdate", model.getValue("/root/main/" + model.getValue("/root/send/retrparams/flag") + "/frdate"));
  159. model.setValue("/root/send/retrparams/todate", model.getValue("/root/main/" + model.getValue("/root/send/retrparams/flag") + "/todate"));
  160. model.setValue("/root/send/retrparams/acntyy", model.getValue("/root/main/" + model.getValue("/root/send/retrparams/flag") + "/acntyy"));
  161. model.refresh();
  162. switch(model.getValue("/root/send/retrparams/flag"))
  163. {
  164. case "balamt":
  165. submit("TRRAD00801");
  166. break;
  167. case "totalnote":
  168. model.removeNodeset("/root/main/totalnotepr/list");
  169. model.refresh();
  170. submit("TRRAD00802");
  171. fSetRowColor(grd_totalnotelist);
  172. break;
  173. case "totalbalamt":
  174. submit("TRRAD00803");
  175. break;
  176. }
  177. }
  178. ]]>
  179. </script>
  180. </xhtml:head>
  181. <xhtml:body guideline="1,1193;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  182. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  183. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:230px; height:14px; ">거래처원장</caption>
  184. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  185. </group>
  186. <group id="group3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
  187. <switch id="switch1" class="sw_box" style="left:0px; top:26px; width:1195px; height:712px; border-style:solid; ">
  188. <case id="case_balamt" style="left:0px; top:0px; width:1193px; height:710px; ">
  189. <button id="btn_excel1" class="btn2_letter4" style="left:1125px; top:74px; width:64px; height:19px; text-align:left; ">
  190. <caption>엑셀출력</caption>
  191. <script type="javascript" ev:event="DOMActivate">
  192. <![CDATA[
  193. // radfSaveExcel(grd_balamtlist);
  194. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  195. grd_balamtlist.saveExcel(fileName,"SheetName:sheet1");
  196. ]]>
  197. </script>
  198. </button>
  199. <caption id="caption21" class="tit_2" style="left:5px; top:80px; width:131px; height:14px; ">잔액</caption>
  200. <group id="group4" style="left:0px; top:10px; width:1193px; height:60px; vertical-align:top; ">
  201. <shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1193px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
  202. <line id="line30" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:51px; "/>
  203. <caption id="caption24" style="left:609px; top:35px; width:15px; height:20px; ">~</caption>
  204. <caption id="caption25" class="search_name" style="left:420px; top:33px; width:86px; height:17px; ">기 간 :</caption>
  205. <caption id="caption26" class="search_name" style="left:16px; top:35px; width:88px; height:17px; ">거 래 처 :</caption>
  206. <caption id="caption27" class="search_name" style="left:16px; top:8px; width:90px; height:17px; ">기관코드 :</caption>
  207. <caption id="caption28" class="search_name" style="left:420px; top:9px; width:90px; height:17px; ">계정과목 :</caption>
  208. <caption id="caption29" class="search_name" visibility="hidden" style="left:930px; top:36px; width:86px; height:17px; ">출력구분 :</caption>
  209. <select1 id="cmb_instcd1" ref="/root/main/balamt/instcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:105px; top:8px; width:299px; height:19px; ">
  210. <choices>
  211. <itemset>
  212. <label/>
  213. <value/>
  214. </itemset>
  215. </choices>
  216. </select1>
  217. <input id="ipt_entrregno1" ref="/root/main/balamt/entrregno" class="input_s_essential" navindex="6" style="left:105px; top:34px; width:90px; height:19px; ">
  218. <script type="javascript" ev:event="onkeypress">
  219. <![CDATA[
  220. if(event.keyCode == 13)
  221. {
  222. racfCustValidCheck("entrregno,custnm");
  223. model.setFocus("ipt_custnm1");
  224. }
  225. ]]>
  226. </script>
  227. <script type="javascript" ev:event="xforms-value-changed">
  228. <![CDATA[
  229. racfCustValidCheck("entrregno,custnm");
  230. ]]>
  231. </script>
  232. </input>
  233. <button id="btn_custhelp1" class="icon_search" style="left:201px; top:36px; width:16px; height:16px; ">
  234. <caption/>
  235. <script type="javascript" ev:event="DOMActivate">
  236. <![CDATA[
  237. misfOpenPopUpList("14", ipt_entrregno1, "", "entrregno,custnm");
  238. model.setValue("/root/main/totalnote/entrregno" , model.getValue("/root/main/balamt/entrregno"));
  239. model.setValue("/root/main/totalnote/custnm" , model.getValue("/root/main/balamt/custnm"));
  240. model.refresh();
  241. ]]>
  242. </script>
  243. </button>
  244. <input id="ipt_custnm1" ref="/root/main/balamt/custnm" class="input_s_essential" navindex="6" style="left:219px; top:34px; width:185px; height:19px; ">
  245. <script type="javascript" ev:event="onkeypress">
  246. <![CDATA[
  247. if(event.keyCode == 13)
  248. {
  249. racfCustValidCheck("entrregno,custnm");
  250. model.setFocus("ipt_frdate1");
  251. }
  252. ]]>
  253. </script>
  254. <script type="javascript" ev:event="xforms-value-changed">
  255. <![CDATA[
  256. racfCustValidCheck("entrregno,custnm");
  257. ]]>
  258. </script>
  259. </input>
  260. <input id="ipt_frdate1" ref="/root/main/balamt/frdate" class="input_s_essential" inputtype="date" style="left:510px; top:34px; width:95px; height:19px; ">
  261. <script type="javascript" ev:event="xforms-value-changed">
  262. <![CDATA[
  263. model.setValue("/root/send/date", model.getValue("/root/main/balamt/frdate"));
  264. racfGetCadlYmd("/root/send/date", "/root/temp");
  265. model.setValue("/root/main/balamt/acntyy", model.getValue("/root/temp/acntyy"));
  266. ]]>
  267. </script>
  268. </input>
  269. <input id="ipt_todate1" ref="/root/main/balamt/todate" class="input_s_essential" inputtype="date" style="left:622px; top:34px; width:95px; height:19px; "/>
  270. <button id="btn_search1" class="btn1_letter2" style="left:1122px; top:19px; width:56px; height:22px; ">
  271. <caption>조회</caption>
  272. <script type="javascript" ev:event="DOMActivate">
  273. <![CDATA[
  274. fRetrieve();
  275. model.refresh();
  276. ]]>
  277. </script>
  278. </button>
  279. <select1 id="cmb_supacntcd41" ref="/root/main/balamt/supacntcd4" class="combo_s_essential" navindex="1" appearance="minimal" style="left:510px; top:8px; width:155px; height:19px; ">
  280. <choices>
  281. <itemset>
  282. <label/>
  283. <value/>
  284. </itemset>
  285. </choices>
  286. <script type="javascript" ev:event="xforms-value-changed">
  287. <![CDATA[
  288. racfGetSupAcntPrAcntListCombo(model.getValue("/root/main/balamt/supacntcd4"), cmb_acntcd1, "Y");
  289. ]]>
  290. </script>
  291. </select1>
  292. <select1 id="cmb_acntcd1" ref="/root/main/balamt/acntcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:664px; top:8px; width:155px; height:19px; ">
  293. <choices>
  294. <itemset>
  295. <label/>
  296. <value/>
  297. </itemset>
  298. </choices>
  299. </select1>
  300. </group>
  301. <line id="line3" class="line_1" style="x1:0px; y1:95px; x2:1193px; y2:95px; "/>
  302. <datagrid id="grd_balamtlist" nodeset="/root/main/balamtpr/list" caption="사업자등록번호^거래처명^계정코드^계정명^전기(월) 이월^차변(지불)^대변(구입)^잔액^잔액^은행" colwidth="120, 250, 40, 40, 190, 190, 190, 190, 40, 40" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:0px; top:100px; width:1193px; height:605px; ">
  303. <col ref="cstmcd" format="999-99-99999" style="text-align:center; "/>
  304. <col ref="custnm"/>
  305. <col ref="acntcd" visibility="hidden"/>
  306. <col ref="acntnm" visibility="hidden"/>
  307. <col ref="preamt" format="(-)#,###" savetype="digit" style="text-align:right; "/>
  308. <col ref="dramnt" format="(-)#,###" savetype="digit" style="text-align:right; "/>
  309. <col ref="cramnt" format="(-)#,###" savetype="digit" style="text-align:right; "/>
  310. <col ref="janamt" format="(-)#,###" savetype="digit" style="text-align:right; "/>
  311. <col ref="janamtsum" visibility="hidden" format="(-)#,###" savetype="digit" style="text-align:right; "/>
  312. <col ref="banknm" visibility="hidden"/>
  313. <script type="javascript" ev:event="onaftersort">
  314. <![CDATA[
  315. grd_balamtlist.gridToInstance();
  316. ]]>
  317. </script>
  318. </datagrid>
  319. </case>
  320. <case id="case_totalnote" selected="true">
  321. <caption id="caption1" class="tit_2" style="left:5px; top:80px; width:131px; height:14px; ">총괄내용</caption>
  322. <group id="group5" style="left:0px; top:10px; width:1193px; height:60px; vertical-align:top; ">
  323. <shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1193px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
  324. <line id="line1" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:51px; "/>
  325. <caption id="caption3" class="search_name" style="left:16px; top:35px; width:88px; height:17px; ">거 래 처 :</caption>
  326. <caption id="caption11" style="left:609px; top:35px; width:15px; height:20px; ">~</caption>
  327. <caption id="caption12" class="search_name" style="left:420px; top:33px; width:86px; height:17px; ">기 간 :</caption>
  328. <select1 id="cmb_instcd2" ref="/root/main/totalnote/instcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:105px; top:8px; width:299px; height:19px; ">
  329. <choices>
  330. <itemset>
  331. <label/>
  332. <value/>
  333. </itemset>
  334. </choices>
  335. </select1>
  336. <caption id="caption13" class="search_name" style="left:16px; top:8px; width:90px; height:17px; ">기관코드 :</caption>
  337. <caption id="caption14" class="search_name" style="left:420px; top:9px; width:90px; height:17px; ">계정과목 :</caption>
  338. <caption id="caption15" class="search_name" visibility="hidden" style="left:930px; top:36px; width:86px; height:17px; ">출력구분 :</caption>
  339. <input id="ipt_entrregno2" ref="/root/main/totalnote/entrregno" class="input_s_essential" navindex="6" style="left:105px; top:34px; width:90px; height:19px; ">
  340. <script type="javascript" ev:event="onkeypress">
  341. <![CDATA[
  342. if(event.keyCode == 13)
  343. {
  344. racfCustValidCheck("entrregno,custnm");
  345. model.setFocus("ipt_custnm2");
  346. }
  347. ]]>
  348. </script>
  349. <script type="javascript" ev:event="xforms-value-changed">
  350. <![CDATA[
  351. racfCustValidCheck("entrregno,custnm");
  352. ]]>
  353. </script>
  354. </input>
  355. <input id="ipt_custnm2" ref="/root/main/totalnote/custnm" class="input_s_essential" navindex="6" style="left:219px; top:34px; width:185px; height:19px; ">
  356. <script type="javascript" ev:event="onkeypress">
  357. <![CDATA[
  358. if(event.keyCode == 13)
  359. {
  360. racfCustValidCheck("entrregno,custnm");
  361. model.setFocus("ipt_frdate2");
  362. }
  363. ]]>
  364. </script>
  365. <script type="javascript" ev:event="xforms-value-changed">
  366. <![CDATA[
  367. racfCustValidCheck("entrregno,custnm");
  368. ]]>
  369. </script>
  370. </input>
  371. <button id="btn_custhelp2" class="icon_search" style="left:201px; top:36px; width:16px; height:16px; ">
  372. <script type="javascript" ev:event="DOMActivate">
  373. <![CDATA[
  374. misfOpenPopUpList("14", ipt_entrregno2, "", "entrregno,custnm");
  375. model.setValue("/root/main/balamt/entrregno" , model.getValue("/root/main/totalnote/entrregno"));
  376. model.setValue("/root/main/balamt/custnm" , model.getValue("/root/main/totalnote/custnm"));
  377. model.refresh();
  378. ]]>
  379. </script>
  380. <caption/>
  381. </button>
  382. <input id="ipt_frdate2" ref="/root/main/totalnote/frdate" class="input_s_essential" inputtype="date" style="left:510px; top:34px; width:95px; height:19px; ">
  383. <script type="javascript" ev:event="xforms-value-changed">
  384. <![CDATA[
  385. model.setValue("/root/send/date", model.getValue("/root/main/totalnote/frdate"));
  386. racfGetCadlYmd("/root/send/date", "/root/temp");
  387. model.setValue("/root/main/totalnote/acntyy", model.getValue("/root/temp/acntyy"));
  388. ]]>
  389. </script>
  390. </input>
  391. <input id="ipt_todate2" ref="/root/main/totalnote/todate" class="input_s_essential" inputtype="date" style="left:622px; top:34px; width:95px; height:19px; "/>
  392. <button id="btn_search2" class="btn1_letter2" style="left:1122px; top:19px; width:56px; height:22px; ">
  393. <caption>조회</caption>
  394. <script type="javascript" ev:event="DOMActivate">
  395. <![CDATA[
  396. fRetrieve();
  397. model.refresh();
  398. ]]>
  399. </script>
  400. </button>
  401. <select1 id="cmb_acntcd2" ref="/root/main/totalnote/acntcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:664px; top:8px; width:155px; height:19px; ">
  402. <choices>
  403. <itemset>
  404. <label/>
  405. <value/>
  406. </itemset>
  407. </choices>
  408. </select1>
  409. <select1 id="cmb_supacntcd42" ref="/root/main/totalnote/supacntcd4" class="combo_s_essential" navindex="1" appearance="minimal" style="left:510px; top:8px; width:155px; height:19px; ">
  410. <choices>
  411. <itemset>
  412. <label/>
  413. <value/>
  414. </itemset>
  415. </choices>
  416. <script type="javascript" ev:event="xforms-value-changed">
  417. <![CDATA[
  418. racfGetSupAcntPrAcntListCombo(model.getValue("/root/main/totalnote/supacntcd4"), cmb_acntcd2, "Y");
  419. ]]>
  420. </script>
  421. </select1>
  422. </group>
  423. <line id="line4" class="line_1" style="x1:0px; y1:95px; x2:1193px; y2:95px; "/>
  424. <button id="btn_excel2" class="btn2_letter4" style="left:1125px; top:74px; width:64px; height:19px; text-align:left; ">
  425. <caption>엑셀출력</caption>
  426. <script type="javascript" ev:event="DOMActivate">
  427. <![CDATA[
  428. //radfSaveExcel(grd_totalnotelist);
  429. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  430. grd_totalnotelist.saveExcel(fileName,"SheetName:sheet1");
  431. ]]>
  432. </script>
  433. </button>
  434. <datagrid id="grd_totalnotelist" nodeset="/root/main/totalnotepr/list" caption="결재전표일자^전표일자^전표번호^사업자등록번호^거래처명^계정코드^계정명^기재사항^차변^대변^잔액^누계^년월^구분" colsep="^" colwidth="120, 100, 60, 40, 150, 40, 150, 300, 140, 140, 40, 140, 40, 40" ellipsis="true" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" tooltip="true" style="left:0px; top:100px; width:1193px; height:605px; ">
  435. <col ref="apsldt" style="text-align:center; "/>
  436. <col ref="unsldt" visibility="hidden"/>
  437. <col ref="unslno" style="text-align:center; "/>
  438. <col ref="cstmcd" visibility="hidden"/>
  439. <col ref="custnm"/>
  440. <col ref="acntcd" visibility="hidden"/>
  441. <col ref="acntnm"/>
  442. <col ref="kije00"/>
  443. <col ref="dramnt" format="(-)#,###" savetype="digit" style="text-align:right; "/>
  444. <col ref="cramnt" format="(-)#,###" savetype="digit" style="text-align:right; "/>
  445. <col ref="janamt" visibility="hidden" format="(-)#,###" savetype="digit" style="text-align:right; "/>
  446. <col ref="janamtsum" format="(-)#,###" savetype="digit" style="text-align:right; "/>
  447. <col ref="yyyymm" visibility="hidden"/>
  448. <col ref="gubn" visibility="hidden"/>
  449. <script type="javascript" ev:event="onaftersort">
  450. <![CDATA[
  451. grd_totalnotelist.gridToInstance();
  452. ]]>
  453. </script>
  454. <script type="javascript" ev:event="ondblclick">
  455. <![CDATA[
  456. if (grd_totalnotelist.row > 0 && grd_totalnotelist.valueMatrix(grd_totalnotelist.row, grd_totalnotelist.colRef("gubn")) == "1")
  457. {
  458. model.makeValue("/root/source/slipinfo/instcd", getUserInfo("dutplceinstcd"));
  459. model.makeValue("/root/source/slipinfo/slipdt", model.getValue(grd_totalnotelist.nodeset + "[" + grd_totalnotelist.row + "]/unsldt"));
  460. model.makeValue("/root/source/slipinfo/slipno", model.getValue(grd_totalnotelist.nodeset + "[" + grd_totalnotelist.row + "]/unslno").substr(0, 4));
  461. model.refresh();
  462. modal("SMRAD00100","","","","","/root/source", "/root/target" );
  463. }
  464. ]]>
  465. </script>
  466. </datagrid>
  467. </case>
  468. <case id="case_totalbalamt">
  469. <caption id="caption16" class="tit_2" style="left:5px; top:80px; width:131px; height:14px; ">총괄잔액</caption>
  470. <group id="group6" style="left:0px; top:10px; width:1193px; height:60px; vertical-align:top; ">
  471. <shape id="roundrect3" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1193px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
  472. <caption id="caption18" class="search_name" style="left:420px; top:9px; width:90px; height:17px; ">계정과목 :</caption>
  473. <line id="line5" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:51px; "/>
  474. <caption id="caption19" class="search_name" visibility="hidden" style="left:930px; top:36px; width:86px; height:17px; ">출력구분 :</caption>
  475. <select1 id="combo3" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:1020px; top:35px; width:80px; height:19px; ">
  476. <choices>
  477. <item>
  478. <label>combo1</label>
  479. <value>combo1</value>
  480. </item>
  481. </choices>
  482. </select1>
  483. <caption id="caption20" class="search_name" style="left:16px; top:35px; width:88px; height:17px; ">거 래 처 :</caption>
  484. <caption id="caption22" style="left:609px; top:35px; width:15px; height:20px; ">~</caption>
  485. <caption id="caption23" class="search_name" style="left:420px; top:33px; width:86px; height:17px; ">기 간 :</caption>
  486. <caption id="caption17" class="search_name" style="left:16px; top:8px; width:90px; height:17px; ">기관코드 :</caption>
  487. <select1 id="cmb_instcd3" ref="/root/main/totalbalamt/instcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:105px; top:8px; width:299px; height:19px; ">
  488. <choices>
  489. <itemset>
  490. <label/>
  491. <value/>
  492. </itemset>
  493. </choices>
  494. </select1>
  495. <input id="ipt_frdate3" ref="/root/main/totalbalamt/frdate" class="input_s_essential" inputtype="date" style="left:510px; top:34px; width:95px; height:19px; ">
  496. <script type="javascript" ev:event="xforms-value-changed">
  497. <![CDATA[
  498. model.setValue("/root/send/date", model.getValue("/root/main/totalbalamt/frdate"));
  499. racfGetCadlYmd("/root/send/date", "/root/temp");
  500. model.setValue("/root/main/totalbalamt/acntyy", model.getValue("/root/temp/acntyy"));
  501. ]]>
  502. </script>
  503. </input>
  504. <input id="ipt_todate3" ref="/root/main/totalbalamt/todate" class="input_s_essential" inputtype="date" style="left:622px; top:34px; width:95px; height:19px; "/>
  505. <input id="ipt_entrregno3" ref="/root/main/totalbalamt/entrregno" class="input_s_essential" navindex="6" style="left:105px; top:34px; width:90px; height:19px; ">
  506. <script type="javascript" ev:event="onkeypress">
  507. <![CDATA[
  508. if(event.keyCode == 13)
  509. {
  510. racfCustValidCheck("entrregno,custnm");
  511. model.setFocus("ipt_custnm3");
  512. }
  513. ]]>
  514. </script>
  515. <script type="javascript" ev:event="xforms-value-changed">
  516. <![CDATA[
  517. racfCustValidCheck("entrregno,custnm");
  518. ]]>
  519. </script>
  520. </input>
  521. <input id="ipt_custnm3" ref="/root/main/totalbalamt/custnm" class="input_s_essential" navindex="6" style="left:219px; top:34px; width:185px; height:19px; ">
  522. <script type="javascript" ev:event="onkeypress">
  523. <![CDATA[
  524. if(event.keyCode == 13)
  525. {
  526. racfCustValidCheck("entrregno,custnm");
  527. model.setFocus("ipt_frdate3");
  528. }
  529. ]]>
  530. </script>
  531. <script type="javascript" ev:event="xforms-value-changed">
  532. <![CDATA[
  533. racfCustValidCheck("entrregno,custnm");
  534. ]]>
  535. </script>
  536. </input>
  537. <button id="btn_custhelp3" class="icon_search" style="left:201px; top:36px; width:16px; height:16px; ">
  538. <caption/>
  539. <script type="javascript" ev:event="DOMActivate">
  540. <![CDATA[
  541. misfOpenPopUpList("14", ipt_entrregno3, "", "entrregno,custnm");
  542. alert(model.getValue("/root/main/totalbalamt/entrregno"));
  543. alert(model.getValue("/root/main/totalbalamt/custnm"));
  544. model.refresh();
  545. ]]>
  546. </script>
  547. </button>
  548. <button id="btn_search3" class="btn1_letter2" style="left:1122px; top:19px; width:56px; height:22px; ">
  549. <caption>조회</caption>
  550. <script type="javascript" ev:event="DOMActivate">
  551. <![CDATA[
  552. fRetrieve();
  553. ]]>
  554. </script>
  555. </button>
  556. <select1 id="cmb_acntcd3" ref="/root/main/totalbalamt/acntcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:664px; top:8px; width:155px; height:19px; ">
  557. <choices>
  558. <itemset>
  559. <label/>
  560. <value/>
  561. </itemset>
  562. </choices>
  563. </select1>
  564. <select1 id="cmb_supacntcd43" ref="/root/main/totalbalamt/supacntcd4" class="combo_s_essential" navindex="1" appearance="minimal" style="left:510px; top:8px; width:155px; height:19px; ">
  565. <choices>
  566. <itemset>
  567. <label/>
  568. <value/>
  569. </itemset>
  570. </choices>
  571. <script type="javascript" ev:event="xforms-value-changed">
  572. <![CDATA[
  573. racfGetSupAcntPrAcntListCombo(model.getValue("/root/main/totalbalamt/supacntcd4"), cmb_acntcd3, "Y");
  574. ]]>
  575. </script>
  576. </select1>
  577. </group>
  578. <line id="line6" class="line_1" style="x1:0px; y1:95px; x2:1193px; y2:95px; "/>
  579. <button id="btn_excel3" class="btn2_letter4" style="left:1125px; top:74px; width:64px; height:19px; text-align:left; ">
  580. <caption>엑셀출력</caption>
  581. <script type="javascript" ev:event="DOMActivate">
  582. <![CDATA[
  583. //radfSaveExcel(grd_totalbalamtlist);
  584. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  585. grd_totalbalamtlist.saveExcel(fileName,"SheetName:sheet1");
  586. ]]>
  587. </script>
  588. </button>
  589. <datagrid id="grd_totalbalamtlist" nodeset="/root/main/totalbalamtpr/list" caption="코드^계정과목^전기(월)이월^증가^감소^잔액" colsep="^" colwidth="100, 260, 200, 200, 200, 200" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:0px; top:100px; width:1193px; height:610px; ">
  590. <col/>
  591. <col/>
  592. <col/>
  593. <col/>
  594. <col/>
  595. <col/>
  596. </datagrid>
  597. </case>
  598. </switch>
  599. <button id="btn_swbalamt" class="btn_sw" group="tab" selected="true" style="left:0px; top:5px; width:36px; height:22px; ">
  600. <caption>잔액</caption>
  601. <toggle case="case_balamt" ev:event="onclick"/>
  602. <script type="javascript" ev:event="DOMActivate">
  603. <![CDATA[
  604. model.setValue("/root/send/retrparams/flag", "balamt");
  605. model.setValue("/root/main/balamt/frdate", model.getValue("/root//main/totalnote/frdate"));
  606. model.setValue("/root/main/balamt/todate", model.getValue("/root/main/totalnote/todate"));
  607. fRetrieve();
  608. ]]>
  609. </script>
  610. </button>
  611. <button id="btn_swtotalnote" class="btn_sw" group="tab" style="left:36px; top:5px; width:60px; height:22px; ">
  612. <caption>총괄내용</caption>
  613. <toggle case="case_totalnote" ev:event="onclick"/>
  614. <script type="javascript" ev:event="DOMActivate">
  615. <![CDATA[
  616. model.setValue("/root/send/retrparams/flag", "totalnote");
  617. model.setValue("/root//main/totalnote/frdate", model.getValue("/root/main/balamt/frdate"));
  618. model.setValue("/root//main/totalnote/todate", model.getValue("/root/main/balamt/todate"));
  619. fRetrieve();
  620. ]]>
  621. </script>
  622. </button>
  623. <button id="btn_swtotalbalamt" class="btn_sw" visibility="hidden" group="tab" style="left:96px; top:5px; width:60px; height:22px; ">
  624. <caption>총괄잔액</caption>
  625. <toggle case="case_totalbalamt" ev:event="onclick"/>
  626. <script type="javascript" ev:event="DOMActivate">
  627. <![CDATA[
  628. model.setValue("/root/send/retrparams/flag", "totalbalamt");
  629. ]]>
  630. </script>
  631. </button>
  632. </group>
  633. <group id="group2" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
  634. <line id="line2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
  635. <button id="btn_print" class="btn6_letter2" style="left:0px; top:3px; width:56px; height:22px; ">
  636. <caption>출력</caption>
  637. <script type="javascript" ev:event="DOMActivate">
  638. <![CDATA[
  639. model.setValue("/root/send/retrparams/instnm", cmb_instcd1.label);
  640. model.setValue("/root/send/retrparams/frdate", model.getValue("/root/main/totalnote/frdate"));
  641. model.setValue("/root/send/retrparams/todate", model.getValue("/root/main/totalnote/todate"));
  642. model.setValue("/root/send/retrparams/supacntcd4", model.getValue("/root/main/totalnote/supacntcd4"));
  643. model.setValue("/root/send/retrparams/custnm", model.getValue("/root/main/totalnote/custnm"));
  644. model.setValue("/root/send/retrparams/selectedIndex", switch1.selectedIndex);
  645. if(switch1.selectedIndex == 0){
  646. model.resetInstanceNode("/root/send/prntlist");
  647. model.copyNode("/root/send/prntlist", "/root/main/balamtpr");
  648. }else if(switch1.selectedIndex == 1){
  649. model.resetInstanceNode("/root/send/prntlist");
  650. model.copyNode("/root/send/prntlist", "/root/main/totalnotepr");
  651. }
  652. exeReportPreview("RPRAD01500", "XMLSTR", "/root/send/retrparams");
  653. ]]>
  654. </script>
  655. </button>
  656. </group>
  657. </xhtml:body>
  658. </xhtml:html>