SMRAD00325_외상매입금 잔액조회(결산).xrw 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/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. <settlebalancesheet/>
  11. </main>
  12. <send>
  13. <condition>
  14. <instcd/>
  15. <acntcd4/>
  16. <acntcd>1</acntcd>
  17. <entrregno/>
  18. <custnm/>
  19. <fromdd/>
  20. <todd/>
  21. <custflag/>
  22. </condition>
  23. <data>
  24. <instcd/>
  25. <mngtcd/>
  26. </data>
  27. </send>
  28. <init>
  29. <code>
  30. <code>
  31. <acnt4/>
  32. </code>
  33. </code>
  34. </init>
  35. <temp/>
  36. <hidden>
  37. </hidden>
  38. </root>
  39. </instance>
  40. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  41. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  42. <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
  43. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  44. <script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
  45. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  46. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  47. <script type="javascript" src="../../../mis/miscommonweb/js/RAM001.js"/>
  48. <script type="javascript" src="../../../mis/acntcommonweb/js/RAD001.js"/>
  49. <script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
  50. <script type="javascript" ev:event="xforms-ready">
  51. <![CDATA[
  52. fInitialize();
  53. ]]>
  54. </script>
  55. <script type="javascript">
  56. <![CDATA[
  57. function fInitialize()
  58. {
  59. model.removenode("/root/main/balancesheet");
  60. var instcd = getUserInfo("dutplceinstcd");
  61. model.setValue("/root/send/condition/instcd", instcd);
  62. model.setValue(ipt_fromdd.attribute("ref"), getCurrentDate().toString());
  63. model.setValue(ipt_todd.attribute("ref"), getCurrentDate().toString());
  64. model.setValue("/root/send/data/instcd", instcd);
  65. model.setValue("/root/send/data/mngtcd", "%");
  66. submit("TRRAZ00001");
  67. model.makeNode("/root/init/code/code/acnt4");
  68. model.makeValue("/root/init/code/code/acnt4[1]/cdnm", "전 체");
  69. model.makeValue("/root/init/code/code/acnt4[1]/cdid", "");
  70. // model.makeValue("/root/init/code/code/acnt4[1]/cdgbn", "R0010");
  71. var seq = 1;
  72. for (i=1; i<= instance1.selectNodes("root/init/code/code/codelist").length; i++)
  73. {
  74. cdgbn = model.getValue("/root/init/code/code/codelist[" + i + "]/cdgbn");
  75. seq++;
  76. //alert(i + " " + cdgbn)
  77. if (cdgbn == "R0010")
  78. {
  79. //alert(i + " " + cdgbn + " " + seq)
  80. model.makeNode( "/root/init/code/code/acnt4[" + seq + "]");
  81. model.makeValue( "/root/init/code/code/acnt4[" + seq + "]/cdid", model.getValue("/root/init/code/code/codelist[" + i + "]/cdid"));
  82. model.makeNode( "/root/init/code/code/acnt4[" + seq + "]");
  83. model.makeValue( "/root/init/code/code/acnt4[" + seq + "]/cdnm", model.getValue("/root/init/code/code/codelist[" + i + "]/cdnm"));
  84. }
  85. }
  86. cmb_supacntcd4.dispatch("xforms-value-changed");
  87. cmb_supacntcd4.select(0);
  88. }
  89. function fCheckAuth()
  90. {
  91. btn_search.disabled = !checkAuth("R");
  92. }
  93. //========================================================================================
  94. // 부서코드 조회
  95. //========================================================================================
  96. function fOpenPopupDeptHelp(pControl, pInstance)
  97. {
  98. misfOpenPopUpList("02", pControl, "", pInstance);
  99. model.refresh();
  100. }
  101. ]]>
  102. </script>
  103. <submission id="TRRAZ00001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/data" resultref="/root/init/code/codelist"/>
  104. <submission id="TRRAD00325" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/main/balancesheet"/>
  105. </model>
  106. </xhtml:head>
  107. <xhtml:body guideline="1,1195;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  108. <group id="grp_1" style="left:0px; top:0px; width:1195px; height:13px; ">
  109. <caption id="cap_title" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">외상매입금 잔액 LIST (결산)</caption>
  110. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  111. </group>
  112. <group id="grp_3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
  113. <group id="grp_sea" style="left:0px; top:10px; width:1195px; height:85px; vertical-align:top; ">
  114. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:85px; background-color:#fffbf2; border-color:#ffd799; "/>
  115. <button id="btn_search" class="btn1_letter2" navindex="4" style="left:1123px; top:28px; width:56px; height:22px; text-align:left; ">
  116. <caption>조회</caption>
  117. <script type="javascript" ev:event="DOMActivate">
  118. <![CDATA[
  119. model.removeNodeset(grd_settlebalancesheet.nodeset);
  120. submit("TRRAD00325");
  121. ]]>
  122. </script>
  123. </button>
  124. <line id="lin_5" class="line_4" style="x1:1107px; y1:18px; x2:1107px; y2:65px; border-color:#ffe4bb; border-left-style:solid; "/>
  125. <caption id="caption1" class="search_name" style="left:445px; top:10px; width:90px; height:17px; ">일 자 :</caption>
  126. <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; ">
  127. <choices>
  128. <itemset>
  129. <label/>
  130. <value/>
  131. </itemset>
  132. </choices>
  133. </select1>
  134. <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; ">
  135. <choices>
  136. <itemset nodeset="/root/init/code/code/acnt4">
  137. <label ref="cdnm"/>
  138. <value ref="cdid"/>
  139. </itemset>
  140. </choices>
  141. <script type="javascript" ev:event="xforms-value-changed">
  142. <![CDATA[
  143. racfGetSupAcntPrAcntListCombo(model.getValue("/root/send/condition/acntcd4"), cmb_acntcd, "Y");
  144. model.setValue(cmb_acntcd.choices.itemset.attribute("nodeset") + "[1]/acntnm", "전 체");
  145. cmb_acntcd.refresh();
  146. cmb_acntcd.select(0);
  147. ]]>
  148. </script>
  149. </select1>
  150. <caption id="caption37" class="search_name" style="left:55px; top:10px; width:100px; height:17px; ">계정과목 :</caption>
  151. <input id="ipt_fromdd" ref="/root/send/condition/fromdd" class="input_s_essential" inputtype="date" style="left:545px; top:10px; width:95px; height:19px; ">
  152. <script type="javascript" ev:event="xforms-value-changed">
  153. <![CDATA[
  154. ]]>
  155. </script>
  156. </input>
  157. <caption id="cap_regno" class="search_name" style="left:445px; top:40px; width:104px; height:17px; ">사업자번호 :</caption>
  158. <input id="ipt_regnm" ref="/root/send/condition/custnm" navindex="6" imemode="hangul" style="left:662px; top:40px; width:158px; height:19px; ">
  159. <script type="javascript" ev:event="onkeypress">
  160. <![CDATA[
  161. if(event.keyCode == 13)
  162. {
  163. racfCustValidCheck("entrregno,custnm", "name");
  164. }
  165. ]]>
  166. </script>
  167. <script type="javascript" ev:event="xforms-value-changed">
  168. <![CDATA[
  169. racfCustValidCheck("entrregno,custnm", "name");
  170. ]]>
  171. </script>
  172. </input>
  173. <button id="btn_entregnohelp" class="icon_search" style="left:643px; top:41px; width:16px; height:16px; ">
  174. <caption/>
  175. <script type="javascript" ev:event="DOMActivate">
  176. <![CDATA[
  177. misfOpenPopUpList("14", ipt_regno, "", "entrregno,custnm");
  178. model.refresh();
  179. ]]>
  180. </script>
  181. </button>
  182. <input id="ipt_regno" ref="/root/send/condition/entrregno" navindex="5" format="999-99-99999" style="left:545px; top:40px; width:95px; height:19px; text-align:center; ">
  183. <script type="javascript" ev:event="onkeypress">
  184. <![CDATA[
  185. if(event.keyCode == 13)
  186. {
  187. racfCustValidCheck("entrregno,custnm", "code");
  188. }
  189. ]]>
  190. </script>
  191. <script type="javascript" ev:event="xforms-value-changed">
  192. <![CDATA[
  193. racfCustValidCheck("entrregno,custnm", "code");
  194. ]]>
  195. </script>
  196. </input>
  197. <input id="ipt_todd" ref="/root/send/condition/todd" class="input_s_essential" inputtype="date" style="left:662px; top:10px; width:95px; height:19px; ">
  198. <script type="javascript" ev:event="xforms-value-changed">
  199. <![CDATA[
  200. ]]>
  201. </script>
  202. </input>
  203. <caption id="caption6" style="left:644px; top:10px; width:20px; height:20px; ">~</caption>
  204. <select1 id="cmb_custflag" ref="/root/send/condition/custflag" class="combo_s_essential" navindex="1" appearance="minimal" style="left:156px; top:40px; width:274px; height:19px; text-align:center; ">
  205. <choices>
  206. <item>
  207. <label>전체</label>
  208. <value/>
  209. </item>
  210. <item>
  211. <label>거래처</label>
  212. <value>1</value>
  213. </item>
  214. <item>
  215. <label>부서</label>
  216. <value>3</value>
  217. </item>
  218. <item>
  219. <label>교직원</label>
  220. <value>4</value>
  221. </item>
  222. <item>
  223. <label>소득자</label>
  224. <value>5</value>
  225. </item>
  226. <item>
  227. <label>기타</label>
  228. <value>9</value>
  229. </item>
  230. </choices>
  231. <script type="javascript" ev:event="xforms-value-changed">
  232. <![CDATA[
  233. if(model.getValue(cmb_custflag.attribute("ref")) == "1")
  234. {
  235. ipt_regno.disabled = false;
  236. btn_entregnohelp.disabled = false;
  237. ipt_regnm.disabled = false;
  238. }
  239. else
  240. {
  241. model.setValue(ipt_regno.attribute("ref"), "");
  242. model.setValue(ipt_regnm.attribute("ref"), "");
  243. ipt_regno.disabled = true;
  244. btn_entregnohelp.disabled = true;
  245. ipt_regnm.disabled = true;
  246. model.refresh();
  247. }
  248. ]]>
  249. </script>
  250. </select1>
  251. <caption id="caption3" class="search_name" style="left:55px; top:40px; width:100px; height:17px; ">상대처구분 :</caption>
  252. </group>
  253. <datagrid id="grd_settlebalancesheet" nodeset="/root/main/settlebalancesheet" backcoloralternate="#ffffff" caption="기관코드^회계년도^상대처구분^상대처코드^상대처명^매 입^지 출^기간 잔액^이월 잔액^전체 잔액" colsep="^" colwidth="0, 0, 150, 130, 220, 120, 120, 120, 120, 120" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:1px; top:120px; width:1193px; height:620px; font-size:10pt; ">
  254. <col ref="instcd" visibility="hidden"/>
  255. <col ref="acntyy" visibility="hidden"/>
  256. <col ref="custflag"/>
  257. <col ref="custcd" format="999-99-99999" style="text-align:center; vertical-align:middle; "/>
  258. <col ref="custnm" style="text-align:left; vertical-align:middle; padding-left:10; "/>
  259. <col ref="cramt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  260. <col ref="dramt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  261. <col ref="currbalamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  262. <col ref="prevbalamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  263. <col ref="totbalamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  264. </datagrid>
  265. <caption id="caption2" class="tit_2" style="left:5px; top:101px; width:215px; height:13px; ">외상매입금 잔액 LIST</caption>
  266. <caption id="caption9" style="left:165px; top:100px; width:950px; height:20px; font-weight:bold; color:#0000ff; ">결산데이터를 합산합니다. 마이그레이션 시 거래처별 부채 정보가 없다면 이월잔액은 정확하지 않습니다.</caption>
  267. </group>
  268. <group id="grp_4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
  269. <line id="lin_2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
  270. <button id="btn_11" class="btn6_letter2" visibility="hidden" style="left:0px; top:3px; width:56px; height:22px; ">
  271. <caption>출력</caption>
  272. <script type="javascript" ev:event="DOMActivate">
  273. <![CDATA[
  274. ]]>
  275. </script>
  276. </button>
  277. <caption id="caption8" style="left:65px; top:5px; width:1110px; height:20px; font-weight:bold; color:#0000ff; ">조회조건의 두 일자가 같은 회계년도 내의 날짜로 조회하세요</caption>
  278. </group>
  279. <button id="btn_9" class="btn2_letter4" style="left:1130px; top:138px; width:64px; height:19px; text-align:left; ">
  280. <caption>엑셀출력</caption>
  281. <script type="javascript" ev:event="DOMActivate">
  282. <![CDATA[
  283. radfSaveExcel(grd_settlebalancesheet);
  284. ]]>
  285. </script>
  286. </button>
  287. </xhtml:body>
  288. </xhtml:html>