SMRAD00320_외상매입금 잔액조회.xrw 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406
  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>외상매입금 잔액 LIST</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <balancesheet/>
  11. </main>
  12. <send>
  13. <condition>
  14. <instcd/>
  15. <acntcd4/>
  16. <acntcd/>
  17. <balamtflag>Y</balamtflag>
  18. <slipdeptcd/>
  19. <slipdepthngnm/>
  20. <costcntrdeptcd/>
  21. <costcntrdepthngnm/>
  22. <entrregno/>
  23. <custnm/>
  24. <fromdd/>
  25. <todd/>
  26. <seqflag>custcd</seqflag>
  27. <printflag/>
  28. </condition>
  29. <data>
  30. <instcd/>
  31. <mngtcd/>
  32. </data>
  33. <retrparams>
  34. <frdate/>
  35. <todate/>
  36. <acntnm4/>
  37. <acntnm/>
  38. <slipdeptcd/>
  39. <slipdepthngnm/>
  40. </retrparams>
  41. </send>
  42. <init>
  43. <code>
  44. <code>
  45. <acnt4/>
  46. </code>
  47. </code>
  48. </init>
  49. <temp/>
  50. <hidden>
  51. <balancesheet/>
  52. </hidden>
  53. </root>
  54. </instance>
  55. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  56. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  57. <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
  58. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  59. <script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
  60. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  61. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  62. <script type="javascript" src="../../../mis/miscommonweb/js/RAM001.js"/>
  63. <script type="javascript" src="../../../mis/acntcommonweb/js/RAD001.js"/>
  64. <script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
  65. <script type="javascript" ev:event="xforms-ready">
  66. <![CDATA[
  67. fInitialize();
  68. ]]>
  69. </script>
  70. <script type="javascript">
  71. <![CDATA[
  72. function fInitialize()
  73. {
  74. model.removenode("/root/main/balancesheet");
  75. var instcd = getUserInfo("dutplceinstcd");
  76. model.setValue("/root/send/condition/instcd", instcd);
  77. model.setValue(ipt_fromdd.attribute("ref"), getCurrentDate().toString());
  78. model.setValue(ipt_todd.attribute("ref"), getCurrentDate().toString());
  79. model.setValue("/root/send/data/instcd", instcd);
  80. model.setValue("/root/send/data/mngtcd", "%");
  81. submit("TRRAZ00001");
  82. model.makeNode("/root/init/code/code/acnt4");
  83. model.makeValue("/root/init/code/code/acnt4[1]/cdnm", "전 체");
  84. model.makeValue("/root/init/code/code/acnt4[1]/cdid", "");
  85. // model.makeValue("/root/init/code/code/acnt4[1]/cdgbn", "R0010");
  86. var seq = 1;
  87. for (i=1; i<= instance1.selectNodes("root/init/code/code/codelist").length; i++)
  88. {
  89. cdgbn = model.getValue("/root/init/code/code/codelist[" + i + "]/cdgbn");
  90. seq++;
  91. //alert(i + " " + cdgbn)
  92. if (cdgbn == "R0010")
  93. {
  94. //alert(i + " " + cdgbn + " " + seq)
  95. model.makeNode( "/root/init/code/code/acnt4[" + seq + "]");
  96. model.makeValue( "/root/init/code/code/acnt4[" + seq + "]/cdid", model.getValue("/root/init/code/code/codelist[" + i + "]/cdid"));
  97. model.makeNode( "/root/init/code/code/acnt4[" + seq + "]");
  98. model.makeValue( "/root/init/code/code/acnt4[" + seq + "]/cdnm", model.getValue("/root/init/code/code/codelist[" + i + "]/cdnm"));
  99. }
  100. }
  101. cmb_supacntcd4.dispatch("xforms-value-changed");
  102. cmb_supacntcd4.select(0);
  103. }
  104. function fCheckAuth()
  105. {
  106. btn_search.disabled = !checkAuth("R");
  107. }
  108. //========================================================================================
  109. // 부서코드 조회
  110. //========================================================================================
  111. function fOpenPopupDeptHelp(pControl, pInstance)
  112. {
  113. misfOpenPopUpList("02", pControl, "", pInstance);
  114. model.refresh();
  115. }
  116. ]]>
  117. </script>
  118. <submission id="TRRAZ00001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/data" resultref="/root/init/code/codelist"/>
  119. <submission id="TRRAD00321" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/main/balancesheet"/>
  120. <submission id="TRRAD00322" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/hidden/balancesheet"/>
  121. </model>
  122. </xhtml:head>
  123. <xhtml:body guideline="1,1195;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  124. <group id="grp_1" style="left:0px; top:0px; width:1195px; height:13px; ">
  125. <caption id="cap_title" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">외상매입금 잔액 LIST</caption>
  126. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  127. </group>
  128. <group id="grp_3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
  129. <group id="grp_sea" style="left:0px; top:10px; width:1195px; height:85px; vertical-align:top; ">
  130. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:85px; background-color:#fffbf2; border-color:#ffd799; "/>
  131. <button id="btn_search" class="btn1_letter2" navindex="4" style="left:1123px; top:18px; width:56px; height:22px; text-align:left; ">
  132. <caption>조회</caption>
  133. <script type="javascript" ev:event="DOMActivate">
  134. <![CDATA[
  135. radfRenewalBebtClos(getUserInfo("dutplceinstcd"), '', model.getValue(ipt_fromdd.attribute("ref")));
  136. submit("TRRAD00321");
  137. ]]>
  138. </script>
  139. </button>
  140. <line id="lin_5" class="line_4" style="x1:1107px; y1:18px; x2:1107px; y2:40px; border-color:#ffe4bb; border-left-style:solid; "/>
  141. <caption id="caption1" class="search_name" style="left:790px; top:10px; width:90px; height:17px; ">일 자 :</caption>
  142. <select1 id="cmb_acntcd" ref="/root/send/condition/acntcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:270px; top:9px; width:160px; height:19px; ">
  143. <choices>
  144. <itemset>
  145. <label/>
  146. <value/>
  147. </itemset>
  148. </choices>
  149. </select1>
  150. <select1 id="cmb_supacntcd4" ref="/root/send/condition/acntcd4" class="combo_s_essential" navindex="1" appearance="minimal" style="left:156px; top:9px; width:109px; height:19px; ">
  151. <choices>
  152. <itemset nodeset="/root/init/code/code/acnt4">
  153. <label ref="cdnm"/>
  154. <value ref="cdid"/>
  155. </itemset>
  156. </choices>
  157. <script type="javascript" ev:event="xforms-value-changed">
  158. <![CDATA[
  159. racfGetSupAcntPrAcntListCombo(model.getValue("/root/send/condition/acntcd4"), cmb_acntcd, "Y");
  160. model.setValue(cmb_acntcd.choices.itemset.attribute("nodeset") + "[1]/acntnm", "전 체");
  161. cmb_acntcd.refresh();
  162. cmb_acntcd.select(0);
  163. ]]>
  164. </script>
  165. </select1>
  166. <caption id="caption37" class="search_name" style="left:55px; top:10px; width:100px; height:17px; ">계정과목 :</caption>
  167. <input id="ipt_fromdd" ref="/root/send/condition/fromdd" class="input_s_essential" inputtype="date" style="left:885px; top:10px; width:90px; height:19px; ">
  168. <script type="javascript" ev:event="xforms-value-changed">
  169. <![CDATA[
  170. ]]>
  171. </script>
  172. </input>
  173. <select1 id="rdo_balamtflag" ref="/root/send/condition/balamtflag" disabled="false" navindex="-1" appearance="full" cellspacing="75" cols="2" style="left:885px; top:35px; width:163px; height:17px; border-style:none; ">
  174. <choices>
  175. <item>
  176. <label>포함</label>
  177. <value>Y</value>
  178. </item>
  179. <item>
  180. <label>제외</label>
  181. <value>N</value>
  182. </item>
  183. </choices>
  184. </select1>
  185. <caption id="caption3" class="search_name" style="left:790px; top:35px; width:90px; height:17px; ">잔액없음 :</caption>
  186. <caption id="caption5" class="search_name" style="left:55px; top:35px; width:104px; height:17px; ">사업자번호 :</caption>
  187. <input id="ipt_regnm" ref="/root/send/condition/custnm" navindex="6" imemode="hangul" style="left:272px; top:35px; width:158px; height:19px; ">
  188. <script type="javascript" ev:event="onkeypress">
  189. <![CDATA[
  190. if(event.keyCode == 13)
  191. {
  192. racfCustValidCheck("entrregno,custnm", "name");
  193. }
  194. ]]>
  195. </script>
  196. <script type="javascript" ev:event="xforms-value-changed">
  197. <![CDATA[
  198. racfCustValidCheck("entrregno,custnm", "name");
  199. ]]>
  200. </script>
  201. </input>
  202. <button id="btn_entregnohelp" class="icon_search" style="left:254px; top:35px; width:16px; height:16px; ">
  203. <caption/>
  204. <script type="javascript" ev:event="DOMActivate">
  205. <![CDATA[
  206. misfOpenPopUpList("14", ipt_regno, "", "entrregno,custnm");
  207. model.refresh();
  208. ]]>
  209. </script>
  210. </button>
  211. <input id="ipt_regno" ref="/root/send/condition/entrregno" navindex="5" format="999-99-99999" style="left:155px; top:35px; width:95px; height:19px; text-align:center; ">
  212. <script type="javascript" ev:event="onkeypress">
  213. <![CDATA[
  214. if(event.keyCode == 13)
  215. {
  216. racfCustValidCheck("entrregno,custnm", "code");
  217. }
  218. ]]>
  219. </script>
  220. <script type="javascript" ev:event="xforms-value-changed">
  221. <![CDATA[
  222. racfCustValidCheck("entrregno,custnm", "code");
  223. ]]>
  224. </script>
  225. </input>
  226. <button id="btn_slipdepthelp" class="icon_search" navindex="-1" style="left:614px; top:9px; width:16px; height:16px; ">
  227. <caption/>
  228. <script type="javascript" ev:event="DOMActivate">
  229. <![CDATA[
  230. fOpenPopupDeptHelp(ipt_slipdeptcd, "slipdeptcd,slipdepthngnm"); //전체부서
  231. ]]>
  232. </script>
  233. </button>
  234. <button id="btn_costcntrdepthelp" class="icon_search" navindex="-1" style="left:614px; top:34px; width:16px; height:16px; ">
  235. <caption/>
  236. <script type="javascript" ev:event="DOMActivate">
  237. <![CDATA[
  238. fOpenPopupDeptHelp(ipt_costcntrdeptcd, "costcntrdeptcd,costcntrdepthngnm"); //전체부서
  239. ]]>
  240. </script>
  241. </button>
  242. <caption id="caption12" class="search_name" style="left:445px; top:10px; width:107px; height:17px; ">발의부서 :</caption>
  243. <caption id="caption13" class="search_name" style="left:445px; top:35px; width:107px; height:17px; ">귀속부서 :</caption>
  244. <input id="ipt_slipdeptcd" ref="/root/send/condition/slipdeptcd" class="input_essential" navindex="-1" maxlength="11" style="left:535px; top:8px; width:74px; height:19px; ">
  245. <script type="javascript" ev:event="xforms-value-changed">
  246. <![CDATA[
  247. racfDeptValidCheck("slipdeptcd,slipdepthngnm"); // 전체부서
  248. ]]>
  249. </script>
  250. <script type="javascript" ev:event="onkeypress">
  251. <![CDATA[
  252. if(event.keyCode == 13)
  253. {
  254. model.setFocus("btn_search");
  255. }
  256. ]]>
  257. </script>
  258. </input>
  259. <input id="ipt_costcntrdeptcd" ref="/root/send/condition/costcntrdeptcd" class="input_essential" navindex="-1" maxlength="11" style="left:535px; top:33px; width:74px; height:19px; ">
  260. <script type="javascript" ev:event="xforms-value-changed">
  261. <![CDATA[
  262. racfDeptValidCheck("costcntrdeptcd,costcntrdepthngnm"); // 전체부서
  263. ]]>
  264. </script>
  265. <script type="javascript" ev:event="onkeypress">
  266. <![CDATA[
  267. if(event.keyCode == 13)
  268. {
  269. model.setFocus("btn_search");
  270. }
  271. ]]>
  272. </script>
  273. </input>
  274. <input id="ipt_costcntrdepthngnm" ref="/root/send/condition/costcntrdepthngnm" class="input_essential" style="left:634px; top:33px; width:135px; height:19px; ">
  275. <script type="javascript" ev:event="xforms-value-changed">
  276. <![CDATA[
  277. racfDeptValidCheck("costcntrdeptcd,costcntrdepthngnm"); // 전체부서
  278. ]]>
  279. </script>
  280. <script type="javascript" ev:event="onkeypress">
  281. <![CDATA[
  282. if(event.keyCode == 13)
  283. {
  284. model.setFocus("btn_search");
  285. }
  286. ]]>
  287. </script>
  288. </input>
  289. <input id="ipt_slipdepthngnm" ref="/root/send/condition/slipdepthngnm" class="input_essential" style="left:634px; top:8px; width:135px; height:19px; ">
  290. <script type="javascript" ev:event="xforms-value-changed">
  291. <![CDATA[
  292. racfDeptValidCheck("slipdeptcd,slipdepthngnm"); // 전체부서
  293. ]]>
  294. </script>
  295. <script type="javascript" ev:event="onkeypress">
  296. <![CDATA[
  297. if(event.keyCode == 13)
  298. {
  299. model.setFocus("btn_search");
  300. }
  301. ]]>
  302. </script>
  303. </input>
  304. <input id="ipt_todd" ref="/root/send/condition/todd" class="input_s_essential" inputtype="date" style="left:997px; top:10px; width:90px; height:19px; ">
  305. <script type="javascript" ev:event="xforms-value-changed">
  306. <![CDATA[
  307. ]]>
  308. </script>
  309. </input>
  310. <caption id="caption6" style="left:980px; top:10px; width:20px; height:20px; ">~</caption>
  311. <caption id="caption7" class="search_name" style="left:790px; top:60px; width:90px; height:17px; ">정렬기준 :</caption>
  312. <select1 id="rdo_seqflag" ref="/root/send/condition/seqflag" disabled="false" navindex="-1" appearance="full" cellspacing="15" cols="2" style="left:885px; top:60px; width:215px; height:17px; border-style:none; ">
  313. <choices>
  314. <item>
  315. <label>사업자등록번호</label>
  316. <value>custcd</value>
  317. </item>
  318. <item>
  319. <label>거래처명</label>
  320. <value>custnm</value>
  321. </item>
  322. </choices>
  323. </select1>
  324. </group>
  325. <datagrid id="grd_balancesheet" nodeset="/root/main/balancesheet" backcoloralternate="#ffffff" caption="기관코드^회계년도^사업자등록번호^상 호^이월잔액^매 입^지 출^잔 액^비 고" colsep="^" colwidth="0, 0, 120, 330, 150, 150, 150, 150, 90" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:1px; top:120px; width:1193px; height:620px; font-size:10pt; ">
  326. <col ref="instcd" visibility="hidden"/>
  327. <col ref="acntyy" visibility="hidden"/>
  328. <col ref="custcd" format="999-99-99999" style="text-align:center; vertical-align:middle; "/>
  329. <col ref="custnm" style="text-align:left; vertical-align:middle; padding-left:10; "/>
  330. <col ref="prevbalamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  331. <col ref="cramt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  332. <col ref="dramt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  333. <col ref="balamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  334. <col ref="cmt"/>
  335. </datagrid>
  336. <caption id="caption2" class="tit_2" style="left:5px; top:101px; width:215px; height:13px; ">외상매입금 잔액 LIST</caption>
  337. </group>
  338. <group id="grp_4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
  339. <line id="lin_2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
  340. <button id="btn_11" class="btn6_letter2" visibility="visible" style="left:0px; top:3px; width:56px; height:22px; ">
  341. <caption>출력</caption>
  342. <script type="javascript" ev:event="DOMActivate">
  343. <![CDATA[
  344. radfRenewalBebtClos(getUserInfo("dutplceinstcd"), '', model.getValue(ipt_fromdd.attribute("ref")));
  345. submit("TRRAD00322");
  346. if(instance1.selectNodes("/root/hidden/balancesheet").length == 0)
  347. {
  348. messageBox("출력할 내용이" ,"I004");
  349. return;
  350. }
  351. model.setValue("/root/send/retrparams/frdate", ipt_fromdd.value);
  352. model.setValue("/root/send/retrparams/todate", ipt_todd.value);
  353. model.setValue("/root/send/retrparams/acntnm4", cmb_supacntcd4.label);
  354. model.setValue("/root/send/retrparams/acntnm", cmb_acntcd.label);
  355. model.setValue("/root/send/retrparams/slipdeptcd", ipt_slipdeptcd.value);
  356. model.setValue("/root/send/retrparams/slipdepthngnm", ipt_slipdepthngnm.value);
  357. exeReportPreview("RPRAD00320", "XMLSTR", "/root/send/retrparams");
  358. ]]>
  359. </script>
  360. </button>
  361. <caption id="caption8" style="left:65px; top:5px; width:1110px; height:20px; font-weight:bold; color:#0000ff; ">조회조건의 두 일자가 같은 회계년도 내의 날짜로 조회하세요</caption>
  362. </group>
  363. <button id="btn_9" class="btn2_letter4" style="left:1130px; top:138px; width:64px; height:19px; text-align:left; ">
  364. <caption>엑셀출력</caption>
  365. <script type="javascript" ev:event="DOMActivate">
  366. <![CDATA[
  367. radfSaveExcel(grd_balancesheet);
  368. ]]>
  369. </script>
  370. </button>
  371. </xhtml:body>
  372. </xhtml:html>