SMRAF00200_자금계획.xrw 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659
  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>Untitle</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <list1>
  11. <fundsplanstate/>
  12. <premonthlist>
  13. </premonthlist>
  14. </list1>
  15. <list2>
  16. <fundsplanlist/>
  17. </list2>
  18. <daylist/>
  19. </main>
  20. <send>
  21. <retrparams>
  22. <instcd/>
  23. <fundsplanym/>
  24. <amtunit>1</amtunit>
  25. <dutym/>
  26. </retrparams>
  27. <retrparams2>
  28. <instcd/>
  29. <fundsplandd/>
  30. <fundscd/>
  31. <amtunit/>
  32. </retrparams2>
  33. <tmpparams>
  34. <fundsplandd/>
  35. <fundscd/>
  36. <fundsnm/>
  37. <setfundscd/>
  38. </tmpparams>
  39. <temp>
  40. <sumamt/>
  41. </temp>
  42. <savelist>
  43. <premonthlist>
  44. </premonthlist>
  45. <fundsplanlist/>
  46. </savelist>
  47. </send>
  48. <init/>
  49. <temp/>
  50. </root>
  51. </instance>
  52. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  53. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  54. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  55. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  56. <script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
  57. <submission id="TRRAF00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/list1"/>
  58. <submission id="TRRAF00202" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams2" resultref="/root/main/list2"/>
  59. <bind id="bindDayPlaySumAmt" ref="/root/send/temp/sumamt" calculate="sum(/root/main/list2/fundsplanlist/amt)"/>
  60. <submission id="TXRAF00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/savelist" resultref="/root/temp"/>
  61. <submission id="TRRPD02206" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/daylist"/>
  62. <submission id="TXRAF00202" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/temp"/>
  63. </model>
  64. <script type="javascript" ev:event="xforms-ready">
  65. <![CDATA[
  66. fInit();
  67. ]]>
  68. </script>
  69. <script type="javascript">
  70. <![CDATA[
  71. var arrBaseDD = new Array();
  72. var arrHoliFlag = new Array();
  73. var arrDayNm = new Array();
  74. function fInit()
  75. {
  76. model.removenode("/root/main/list1/fundsplanstate");
  77. model.removenode("/root/main/list1/premonthlist");
  78. model.removenode("/root/main/list2/fundsplanlist");
  79. misfMsterDetailSet(grd_fundsplanstate, null, "TRRAF00201", "N");
  80. misfMsterDetailSet(grd_premonthlist, null, "TRRAF00201", "Y");
  81. misfMsterDetailSet(grd_fundsplanlist, null, "TRRAF00202", "Y");
  82. misfComboComCdListMulti("Z0007", "cmb_instcd");
  83. model.setValue("/root/send/retrparams/instcd", getUserInfo("dutplceinstcd"));
  84. model.setValue("/root/send/retrparams/fundsplanym", getCurrentDate().substr(0, 6));
  85. fSetGridMonth("C");
  86. if(getUserInfo("dutplceinstcd") == '001')
  87. {
  88. cmb_instcd.visible = true;
  89. }
  90. model.refresh();
  91. }
  92. function fRetrieve()
  93. {
  94. submit("TRRAF00201");
  95. for(var i=grd_fundsplanstate.fixedRows; i<grd_fundsplanstate.rows; i++)
  96. {
  97. var sOrderFlag = model.getValue(grd_fundsplanstate.nodeset + "[" + i + "]/orderflag");
  98. var sFundsCd = model.getValue(grd_fundsplanstate.nodeset + "[" + i + "]/setfundscd");
  99. if(sOrderFlag == "1")
  100. {
  101. if(sFundsCd == "0000" || sFundsCd == "9700") grd_fundsplanstate.rowStyle(i, "all", "background-color") = "#eaeaea";
  102. else if(sFundsCd == "9800") grd_fundsplanstate.rowStyle(i, "all", "background-color") = "#dddddd";
  103. else if(sFundsCd == "9900") grd_fundsplanstate.rowStyle(i, "all", "background-color") = "#c0c0c0";
  104. else grd_fundsplanstate.rowStyle(i, "all", "background-color") = "#ffffff";
  105. }
  106. else if(sOrderFlag == "2") grd_fundsplanstate.rowStyle(i, "all", "background-color") = "#ffffcc";
  107. else if(sOrderFlag == "3") grd_fundsplanstate.rowStyle(i, "all", "background-color") = "#ccffcc";
  108. }
  109. fSetGridMonth("R");
  110. fSetSumAmt();
  111. }
  112. function fRetrieveDayPlanList()
  113. {
  114. var iDay = (grd_fundsplanstate.col - 7).toString().length == 1 ? "0" + (grd_fundsplanstate.col - 7).toString() : (grd_fundsplanstate.col - 7).toString();
  115. model.setValue("/root/send/retrparams2/instcd", cmb_instcd.value);
  116. model.setValue("/root/send/retrparams2/fundsplandd", ipt_fundsplanym.value + iDay);
  117. model.setValue("/root/send/retrparams2/fundscd", model.getValue(grd_fundsplanstate.nodeset + "[" + grd_fundsplanstate.row + "]/setfundscd"));
  118. model.setValue("/root/send/retrparams2/amtunit", rdo_amtunit.value);
  119. model.setValue("/root/send/tmpparams/fundsplandd", ipt_fundsplanym.value + iDay);
  120. model.setValue("/root/send/tmpparams/fundscd", model.getValue(grd_fundsplanstate.nodeset + "[" + grd_fundsplanstate.row + "]/fundscd"));
  121. model.setValue("/root/send/tmpparams/fundsnm", model.getValue(grd_fundsplanstate.nodeset + "[" + grd_fundsplanstate.row + "]/fundsnm"));
  122. model.setValue("/root/send/tmpparams/setfundscd", model.getValue(grd_fundsplanstate.nodeset + "[" + grd_fundsplanstate.row + "]/setfundscd"));
  123. submit("TRRAF00202");
  124. model.refresh();
  125. }
  126. function fSave()
  127. {
  128. model.removenode("/root/send/savelist/premonthlist");
  129. model.removenode("/root/send/savelist/fundsplanlist");
  130. model.makeNode("/root/send/savelist/premonthlist");
  131. model.makeNode("/root/send/savelist/fundsplanlist");
  132. model.setValue("/root/send/savelist/premonthlist", grd_premonthlist.getUpdateData());
  133. model.setValue("/root/send/savelist/fundsplanlist", grd_fundsplanlist.getUpdateData());
  134. misfSave("TXRAF00201");
  135. }
  136. function fSetSumAmt()
  137. {
  138. var iFundsGb1Sum = 0;
  139. var iFundsGb1DrAmt = 0;
  140. var iFundsGb1CrAmt = 0;
  141. var iFundsGb1RowIdx = -1;
  142. var iFundsGB2Sum = 0;
  143. var iFundsGb2DrAmt = 0;
  144. var iFundsGb2CrAmt = 0;
  145. var iFundsGb2RowIdx = -1;
  146. var iFundsGB3Sum = 0;
  147. var iFundsGb3DrAmt = 0;
  148. var iFundsGb3CrAmt = 0;
  149. var iFundsGb3RowIdx = -1;
  150. var iFundsGB4Sum = 0;
  151. var iFundsGb4DrAmt = 0;
  152. var iFundsGb4CrAmt = 0;
  153. var iFundsGb4RowIdx = -1;
  154. var iFundsGB5Sum = 0;
  155. var iFundsGb5DrAmt = 0;
  156. var iFundsGb5CrAmt = 0;
  157. var iFundsGb5RowIdx = -1;
  158. var iPreMonthAmt = 0; // 전기이월금액
  159. var iNextACntAmt = 0; // 차기이월금액
  160. var iAcntAmt = 0; // 제예금잔액 = 차입실행액 - 예금인출액
  161. var iSendAmt = 0; // 차입금잔액 = 차입실행액 - 차입상환액
  162. var iPreMonthRowIdx = grd_fundsplanstate.findRow("0000", 1, grd_fundsplanstate.colRef("setfundscd")); // 전기이월 Row Index
  163. var iNextAcntRowIdx = grd_fundsplanstate.findRow("9700", 1, grd_fundsplanstate.colRef("setfundscd")); // 차기이월금액 Row Index
  164. var iAcntRowIdx = grd_fundsplanstate.findRow("9800", 1, grd_fundsplanstate.colRef("setfundscd")); // 제예금잔액 Row Index
  165. var iSendRowIdx = grd_fundsplanstate.findRow("9900", 1, grd_fundsplanstate.colRef("setfundscd")); // 차입금잔액 Row Index
  166. var i7100Amt = 0; // 예금인출액
  167. var i8100Amt = 0; // 예금불입액
  168. var i7300Amt = 0; // 차입실행액
  169. var i8300Amt = 0; // 차입상환액
  170. var i7100RowIdx = grd_fundsplanstate.findRow("7100", 1, grd_fundsplanstate.colRef("setfundscd")); // 예금인출 Row Index
  171. var i8100RowIdx = grd_fundsplanstate.findRow("8100", 1, grd_fundsplanstate.colRef("setfundscd")); // 예금불입 Row Index
  172. var i7300RowIdx = grd_fundsplanstate.findRow("7300", 1, grd_fundsplanstate.colRef("setfundscd")); // 차입실행 Row Index
  173. var i8300RowIdx = grd_fundsplanstate.findRow("8300", 1, grd_fundsplanstate.colRef("setfundscd")); // 차입상환 Row Index
  174. for(var i=1; i<grd_fundsplanstate.rows; i++)
  175. {
  176. if(grd_fundsplanstate.valueMatrix(i, grd_fundsplanstate.colRef("fundssumgb")) == "02" && grd_fundsplanstate.valueMatrix(i, grd_fundsplanstate.colRef("orderflag")) == "3")
  177. {
  178. iFundsGb1RowIdx = i;
  179. }
  180. else if(grd_fundsplanstate.valueMatrix(i, grd_fundsplanstate.colRef("fundssumgb")) == "04" && grd_fundsplanstate.valueMatrix(i, grd_fundsplanstate.colRef("orderflag")) == "3")
  181. {
  182. iFundsGb2RowIdx = i;
  183. }
  184. else if(grd_fundsplanstate.valueMatrix(i, grd_fundsplanstate.colRef("fundssumgb")) == "06" && grd_fundsplanstate.valueMatrix(i, grd_fundsplanstate.colRef("orderflag")) == "3")
  185. {
  186. iFundsGb3RowIdx = i;
  187. }
  188. else if(grd_fundsplanstate.valueMatrix(i, grd_fundsplanstate.colRef("fundssumgb")) == "08" && grd_fundsplanstate.valueMatrix(i, grd_fundsplanstate.colRef("orderflag")) == "3")
  189. {
  190. iFundsGb4RowIdx = i;
  191. }
  192. else if(grd_fundsplanstate.valueMatrix(i, grd_fundsplanstate.colRef("fundssumgb")) == "10" && grd_fundsplanstate.valueMatrix(i, grd_fundsplanstate.colRef("orderflag")) == "3")
  193. {
  194. iFundsGb5RowIdx = i;
  195. }
  196. }
  197. for(var i=grd_fundsplanstate.frozenCols; i<grd_fundsplanstate.cols - 1; i++)
  198. {
  199. for(var j=1; j<grd_fundsplanstate.rows; j++)
  200. {
  201. if(grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("fundssumgb")) == "01" && grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("orderflag")) == "2")
  202. {
  203. iFundsGb1DrAmt = parseInt(grd_fundsplanstate.valueMatrix(j, i), 10);
  204. }
  205. else if(grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("fundssumgb")) == "02" && grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("orderflag")) == "2")
  206. {
  207. iFundsGb1CrAmt = parseInt(grd_fundsplanstate.valueMatrix(j, i), 10);
  208. }
  209. else if(grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("fundssumgb")) == "03" && grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("orderflag")) == "1")
  210. {
  211. iFundsGb2DrAmt = parseInt(grd_fundsplanstate.valueMatrix(j, i), 10);
  212. }
  213. else if(grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("fundssumgb")) == "04" && grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("orderflag")) == "1")
  214. {
  215. iFundsGb2CrAmt = parseInt(grd_fundsplanstate.valueMatrix(j, i), 10);
  216. }
  217. else if(grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("fundssumgb")) == "05" && grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("orderflag")) == "1")
  218. {
  219. iFundsGb3DrAmt = parseInt(grd_fundsplanstate.valueMatrix(j, i), 10);
  220. }
  221. else if(grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("fundssumgb")) == "06" && grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("orderflag")) == "1")
  222. {
  223. iFundsGb3CrAmt = parseInt(grd_fundsplanstate.valueMatrix(j, i), 10);
  224. }
  225. else if(grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("fundssumgb")) == "07" && grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("orderflag")) == "2")
  226. {
  227. iFundsGb4DrAmt = parseInt(grd_fundsplanstate.valueMatrix(j, i), 10);
  228. }
  229. else if(grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("fundssumgb")) == "08" && grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("orderflag")) == "2")
  230. {
  231. iFundsGb4CrAmt = parseInt(grd_fundsplanstate.valueMatrix(j, i), 10);
  232. }
  233. else if(grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("fundssumgb")) == "09" && grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("orderflag")) == "1")
  234. {
  235. iFundsGb5DrAmt = parseInt(grd_fundsplanstate.valueMatrix(j, i), 10);
  236. }
  237. else if(grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("fundssumgb")) == "10" && grd_fundsplanstate.valueMatrix(j, grd_fundsplanstate.colRef("orderflag")) == "1")
  238. {
  239. iFundsGb5CrAmt = parseInt(grd_fundsplanstate.valueMatrix(j, i), 10);
  240. }
  241. }
  242. i7100Amt = parseInt(grd_fundsplanstate.valueMatrix(i7100RowIdx, i), 10)
  243. i8100Amt = parseInt(grd_fundsplanstate.valueMatrix(i8100RowIdx, i), 10)
  244. i7300Amt = parseInt(grd_fundsplanstate.valueMatrix(i7300RowIdx, i), 10)
  245. i8300Amt = parseInt(grd_fundsplanstate.valueMatrix(i8300RowIdx, i), 10)
  246. if(i == grd_fundsplanstate.frozenCols)
  247. {
  248. iPreMonthAmt = parseInt(grd_fundsplanstate.valueMatrix(iPreMonthRowIdx, grd_fundsplanstate.colRef("sumamt")) == "" ? 0 : grd_fundsplanstate.valueMatrix(iPreMonthRowIdx, grd_fundsplanstate.colRef("sumamt")), 10);
  249. iAcntAmt = parseInt(grd_fundsplanstate.valueMatrix(iAcntRowIdx, grd_fundsplanstate.colRef("sumamt")) == "" ? 0 : grd_fundsplanstate.valueMatrix(iAcntRowIdx, grd_fundsplanstate.colRef("sumamt")), 10);
  250. iSendAmt = parseInt(grd_fundsplanstate.valueMatrix(iSendRowIdx, grd_fundsplanstate.colRef("sumamt")) == "" ? 0 : grd_fundsplanstate.valueMatrix(iSendRowIdx, grd_fundsplanstate.colRef("sumamt")), 10);
  251. }
  252. else
  253. {
  254. iPreMonthAmt = 0;
  255. iAcntAmt = 0;
  256. iSendAmt = 0;
  257. }
  258. iFundsGb1Sum = iFundsGb1DrAmt - iFundsGb1CrAmt;
  259. iFundsGB2Sum = iFundsGb2DrAmt - iFundsGb2CrAmt;
  260. iFundsGB3Sum = iFundsGb3DrAmt - iFundsGb3CrAmt;
  261. iFundsGB4Sum = iFundsGb4DrAmt - iFundsGb4CrAmt;
  262. iFundsGB5Sum = iFundsGb5DrAmt - iFundsGb5CrAmt;
  263. iNextACntAmt = iPreMonthAmt + (iFundsGb1Sum + iFundsGB2Sum + iFundsGB3Sum + iFundsGB4Sum + iFundsGB5Sum);
  264. iAcntAmt = iAcntAmt + (i8100Amt - i7100Amt);
  265. iSendAmt = iSendAmt + (i7300Amt - i8300Amt);
  266. model.setValue(grd_fundsplanstate.nodeset + "[" + iFundsGb1RowIdx + "]/" + grd_fundsplanstate.colAttribute(i, "ref"), iFundsGb1Sum);
  267. model.setValue(grd_fundsplanstate.nodeset + "[" + iFundsGb1RowIdx + "]/" + grd_fundsplanstate.colAttribute(i, "ref"), iFundsGb1Sum);
  268. model.setValue(grd_fundsplanstate.nodeset + "[" + iFundsGb2RowIdx + "]/" + grd_fundsplanstate.colAttribute(i, "ref"), iFundsGB2Sum);
  269. model.setValue(grd_fundsplanstate.nodeset + "[" + iFundsGb3RowIdx + "]/" + grd_fundsplanstate.colAttribute(i, "ref"), iFundsGB3Sum);
  270. model.setValue(grd_fundsplanstate.nodeset + "[" + iFundsGb4RowIdx + "]/" + grd_fundsplanstate.colAttribute(i, "ref"), iFundsGB4Sum);
  271. model.setValue(grd_fundsplanstate.nodeset + "[" + iFundsGb5RowIdx + "]/" + grd_fundsplanstate.colAttribute(i, "ref"), iFundsGB5Sum);
  272. model.setValue(grd_fundsplanstate.nodeset + "[" + iNextAcntRowIdx + "]/" + grd_fundsplanstate.colAttribute(i, "ref"), iNextACntAmt);
  273. model.setValue(grd_fundsplanstate.nodeset + "[" + iAcntRowIdx + "]/" + grd_fundsplanstate.colAttribute(i, "ref"), iAcntAmt);
  274. model.setValue(grd_fundsplanstate.nodeset + "[" + iSendRowIdx + "]/" + grd_fundsplanstate.colAttribute(i, "ref"), iSendAmt);
  275. }
  276. }
  277. function fSetGridMonth(sType)
  278. {
  279. arrBaseDD = new Array();
  280. arrHoliFlag = new Array();
  281. arrDayNm = new Array();
  282. if(sType == "C")
  283. {
  284. model.setValue("/root/send/retrparams/dutym", model.getValue("/root/send/retrparams/fundsplanym"));
  285. submit("TRRPD02206");
  286. }
  287. else
  288. {
  289. for(var i=1; i<=31; i++)
  290. {
  291. arrBaseDD[i - 1] = model.getValue("/root/main/daylist[" + i + "]/basedd");
  292. arrHoliFlag[i - 1] = model.getValue("/root/main/daylist[" + i + "]/holiflag");
  293. arrDayNm[i - 1] = model.getValue("/root/main/daylist[" + i + "]/daynm");
  294. if(arrBaseDD[i - 1] == "")
  295. {
  296. grd_fundsplanstate.colHidden(i + 7) = true;
  297. }
  298. else
  299. {
  300. grd_fundsplanstate.colHidden(i + 7) = false;
  301. }
  302. if(arrHoliFlag[i - 1] == '4')
  303. {
  304. grd_fundsplanstate.colStyle((i + 7), "all", "color") = "#0000FF";
  305. }
  306. else if(arrHoliFlag[i - 1] == '0')
  307. {
  308. grd_fundsplanstate.colStyle((i + 7), "all", "color") = "#FF0000";
  309. }
  310. else
  311. {
  312. grd_fundsplanstate.colStyle((i + 7), "all", "color") = "#000000";
  313. }
  314. }
  315. }
  316. }
  317. ]]>
  318. </script>
  319. </xhtml:head>
  320. <xhtml:body pagewidth="1211" pageheight="784" guideline="1,1193;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  321. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  322. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">자금계획</caption>
  323. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  324. </group>
  325. <group id="group3" scroll="auto" style="left:0px; top:35px; width:1195px; height:744px; ">
  326. <group id="grp_sea" style="left:0px; top:10px; width:1195; height:35px; vertical-align:top; ">
  327. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1194px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
  328. <caption id="caption7" class="search_name" style="left:16px; top:9px; width:86px; height:17px; ">기관구분 :</caption>
  329. <line id="line5" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
  330. <caption id="caption1" class="search_name" style="left:340px; top:9px; width:86px; height:17px; ">계획년월 :</caption>
  331. <select1 id="cmb_instcd" ref="/root/send/retrparams/instcd" class="combo_search" disabled="true" navindex="1" appearance="minimal" style="left:105px; top:8px; width:185px; height:19px; ">
  332. <choices>
  333. <itemset>
  334. <label/>
  335. <value/>
  336. </itemset>
  337. </choices>
  338. <script type="javascript" ev:event="xforms-value-changed">
  339. <![CDATA[
  340. fRetrieve();
  341. grd_fundsplanstate.dispatch("onclick");
  342. ]]>
  343. </script>
  344. </select1>
  345. <button id="btn_search" class="btn1_letter2" navindex="4" style="left:1123px; top:8px; width:56px; height:22px; text-align:left; ">
  346. <caption>조회</caption>
  347. <script type="javascript" ev:event="DOMActivate">
  348. <![CDATA[
  349. fRetrieve();
  350. grd_fundsplanstate.dispatch("onclick");
  351. ]]>
  352. </script>
  353. </button>
  354. <caption id="caption8" class="search_name" style="left:580px; top:9px; width:86px; height:17px; ">원단위 :</caption>
  355. <select1 id="rdo_amtunit" ref="/root/send/retrparams/amtunit" overflow="visible" appearance="full" cellspacing="20" cols="3" style="left:663px; top:9px; width:187px; height:15px; border-style:none; ">
  356. <choices>
  357. <item>
  358. <label>백만원</label>
  359. <value>1000000</value>
  360. </item>
  361. <item>
  362. <label>천원</label>
  363. <value>1000</value>
  364. </item>
  365. <item>
  366. <label>원</label>
  367. <value>1</value>
  368. </item>
  369. </choices>
  370. <script type="javascript" ev:event="xforms-value-changed">
  371. <![CDATA[
  372. fRetrieve();
  373. fRetrieveDayPlanList();
  374. ]]>
  375. </script>
  376. </select1>
  377. <input id="ipt_fundsplanym" ref="/root/send/retrparams/fundsplanym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:430px; top:8px; width:100px; height:19px; text-align:center; ">
  378. <script type="javascript" ev:event="xforms-value-changed">
  379. <![CDATA[
  380. fSetGridMonth();
  381. fRetrieve();
  382. fRetrieveDayPlanList();
  383. ]]>
  384. </script>
  385. </input>
  386. </group>
  387. <line id="line3" class="line_1" style="x1:0px; y1:70px; x2:838px; y2:70px; "/>
  388. <caption id="caption21" class="tit_2" style="left:5px; top:55px; width:131px; height:14px; ">계획현황</caption>
  389. <caption id="caption2" class="tit_2" style="left:840px; top:56px; width:131px; height:14px; ">일일계획</caption>
  390. <line id="line1" class="line_1" style="x1:836px; y1:71px; x2:1193px; y2:72px; "/>
  391. <caption id="cap_acntyy" class="cell_1" style="left:836px; top:75px; width:115px; height:23px; text-align:center; vertical-align:middle; ">계획일자</caption>
  392. <line id="line4" class="line_2" style="x1:835px; y1:125px; x2:1193px; y2:125px; "/>
  393. <line id="line6" class="line_2" style="x1:835px; y1:99px; x2:1193px; y2:99px; "/>
  394. <line id="line12" class="line_3" style="x1:835px; y1:126px; x2:1193px; y2:126px; "/>
  395. <line id="line7" class="line_1" style="x1:833px; y1:72px; x2:832px; y2:741px; "/>
  396. <button id="btn_addrow" class="btn2_letter3" style="left:1043px; top:50px; width:53px; height:19px; text-align:left; ">
  397. <caption>행추가</caption>
  398. <script type="javascript" ev:event="DOMActivate">
  399. <![CDATA[
  400. if(grd_fundsplanstate.rows == 1)
  401. {
  402. return;
  403. }
  404. if(model.getValue("/root/send/tmpparams/setfundscd") == "")
  405. {
  406. return;
  407. }
  408. misfGridIUD(grd_fundsplanlist, "A");
  409. var strUnit ;
  410. strUnit = model.getValue("/root/send/tmpparams/amtunit");
  411. if (strUnit == "") {
  412. strUnit = model.getValue("/root/send/retrparams/amtunit")
  413. }
  414. model.setValue(grd_fundsplanlist.nodeset + "[" + grd_fundsplanlist.row + "]/instcd", model.getValue("/root/send/retrparams/instcd"));
  415. model.setValue(grd_fundsplanlist.nodeset + "[" + grd_fundsplanlist.row + "]/fundsplandd", model.getValue("/root/send/tmpparams/fundsplandd"));
  416. model.setValue(grd_fundsplanlist.nodeset + "[" + grd_fundsplanlist.row + "]/fundscd", model.getValue("/root/send/tmpparams/setfundscd"));
  417. model.setValue(grd_fundsplanlist.nodeset + "[" + grd_fundsplanlist.row + "]/fundsnm", model.getValue("/root/send/tmpparams/fundsnm"));
  418. // model.setValue(grd_fundsplanlist.nodeset + "[" + grd_fundsplanlist.row + "]/amtunit", model.getValue("/root/send/tmpparams/amtunit"));
  419. model.setValue(grd_fundsplanlist.nodeset + "[" + grd_fundsplanlist.row + "]/amtunit", strUnit);
  420. model.refresh();
  421. ]]>
  422. </script>
  423. </button>
  424. <button id="btn_delrow" class="btn2_letter3" style="left:1097px; top:50px; width:53px; height:19px; text-align:left; ">
  425. <caption>행삭제</caption>
  426. <script type="javascript" ev:event="DOMActivate">
  427. <![CDATA[
  428. misfGridIUD(grd_fundsplanlist, "D");
  429. ]]>
  430. </script>
  431. </button>
  432. <button id="btn_excellist" class="btn2_letter2" style="left:1151px; top:50px; width:42px; height:19px; text-align:left; ">
  433. <caption>엑셀</caption>
  434. <script type="javascript" ev:event="DOMActivate">
  435. <![CDATA[
  436. misfSaveExcel(fundsplanlist);
  437. ]]>
  438. </script>
  439. </button>
  440. <button id="btn_excelstate" class="btn2_letter2" style="left:786px; top:50px; width:42px; height:19px; text-align:left; ">
  441. <caption>엑셀</caption>
  442. <script type="javascript" ev:event="DOMActivate">
  443. <![CDATA[
  444. misfSaveExcel(grd_fundsplanstate);
  445. ]]>
  446. </script>
  447. </button>
  448. <input id="ipt_fundsplandd" ref="/root/send/tmpparams/fundsplandd" class="input_essential" editable="false" format="yyyy-mm-dd" style="left:953px; top:77px; width:238px; height:19px; "/>
  449. <input id="ipt_fundsnm" ref="/root/send/tmpparams/fundsnm" class="input_essential" editable="false" style="left:1048px; top:103px; width:143px; height:19px; "/>
  450. <datagrid id="grd_fundsplanstate" nodeset="/root/main/list1/fundsplanstate" autoresize="false" backcoloralternate="#ffffff" caption="구분^^자금과목^자금과목^합계Gb^정렬Flag^합계^1^2^3^4^5^6^7^8^9^10^11^12^13^14^15^16^17^18^19^20^21^22^23^24^25^26^27^28^29^30^31^Set자금코드" colsep="^" colwidth="80, 0, 110, 50, 0, 0, 100, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 90, 0" frozencols="7" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:0px; top:75px; width:830px; height:667px; ">
  451. <col ref="fundsgb" style="text-align:center; "/>
  452. <col ref="fundssumgb" visibility="hidden"/>
  453. <col ref="fundsnm" style="text-align:center; "/>
  454. <col ref="fundscd" style="text-align:center; "/>
  455. <col ref="fundssumgb" visibility="hidden"/>
  456. <col ref="orderflag" visibility="hidden"/>
  457. <col ref="sumamt" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  458. <col ref="day01" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  459. <col ref="day02" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  460. <col ref="day03" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  461. <col ref="day04" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  462. <col ref="day05" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  463. <col ref="day06" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  464. <col ref="day07" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  465. <col ref="day08" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  466. <col ref="day09" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  467. <col ref="day10" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  468. <col ref="day11" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  469. <col ref="day12" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  470. <col ref="day13" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  471. <col ref="day14" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  472. <col ref="day15" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  473. <col ref="day16" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  474. <col ref="day17" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  475. <col ref="day18" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  476. <col ref="day19" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  477. <col ref="day20" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  478. <col ref="day21" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  479. <col ref="day22" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  480. <col ref="day23" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  481. <col ref="day24" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  482. <col ref="day25" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  483. <col ref="day26" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  484. <col ref="day27" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  485. <col ref="day28" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  486. <col ref="day29" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  487. <col ref="day30" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  488. <col ref="day31" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  489. <col ref="setfundscd" visibility="hidden"/>
  490. <script type="javascript" ev:event="onclick">
  491. <![CDATA[
  492. var sFundsCd = grd_fundsplanstate.valueMatrix(grd_fundsplanstate.row, grd_fundsplanstate.colRef("setfundscd"));
  493. var sOrderFlag = grd_fundsplanstate.valueMatrix(grd_fundsplanstate.row, grd_fundsplanstate.colRef("orderflag"));
  494. if(grd_fundsplanstate.col > 7 && grd_fundsplanstate.row > grd_fundsplanstate.fixedRows && sFundsCd != "0000" && sFundsCd != "9700" && sFundsCd != "9800" && sFundsCd != "9900" && sOrderFlag == "1")
  495. {
  496. fRetrieveDayPlanList();
  497. }
  498. else
  499. {
  500. model.setValue("/root/send/tmpparams/fundsplandd", "");
  501. model.setValue("/root/send/tmpparams/fundscd", "");
  502. model.setValue("/root/send/tmpparams/fundsnm", "");
  503. model.setValue("/root/send/tmpparams/setfundscd", "");
  504. model.removenode("/root/main/list2");
  505. model.refresh();
  506. }
  507. ]]>
  508. </script>
  509. </datagrid>
  510. <caption id="caption9" class="cell_1" style="left:836px; top:101px; width:115px; height:23px; text-align:center; vertical-align:middle; ">자금과목</caption>
  511. <input id="ipt_setfundscd" ref="/root/send/tmpparams/setfundscd" class="input_essential" editable="false" style="left:953px; top:103px; width:93px; height:19px; "/>
  512. <input id="ipt_fundscd" ref="/root/send/tmpparams/fundscd" class="input_essential" editable="false" style="left:953px; top:103px; width:93px; height:19px; "/>
  513. <caption id="caption3" class="tit_2" style="left:839px; top:628px; width:131px; height:14px; ">전기잔액</caption>
  514. <line id="line8" class="line_1" style="x1:835px; y1:643px; x2:1192px; y2:644px; "/>
  515. <line id="line10" class="line_3" style="x1:835px; y1:742px; x2:1193px; y2:742px; "/>
  516. <caption id="cap_sumamt" ref="/root/send/temp/sumamt" format="(-)#,###" style="left:855px; top:597px; width:111px; height:20px; text-align:right; padding-right:2; background-color:#ccffcc; "/>
  517. <datagrid id="grd_premonthlist" nodeset="/root/main/list1/premonthlist" caption="기관^일자^자금코드^자금과목명^Seq^금액^원단위" colsep="^" colwidth="0, 0, 0, 170, 0, 165, 0" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" style="left:836px; top:647px; width:357px; height:94px; ">
  518. <col ref="instcd" visibility="hidden"/>
  519. <col ref="fundsplandd" visibility="hidden"/>
  520. <col ref="fundscd" visibility="hidden"/>
  521. <col ref="fundsnm" style="text-align:center; "/>
  522. <col ref="seq"/>
  523. <col ref="amt" type="input" format="(-)#,###" style="text-align:right; "/>
  524. <col ref="amtunit" visibility="hidden"/>
  525. <script type="javascript" ev:event="xforms-value-changed">
  526. <![CDATA[
  527. var sSeq = grd_premonthlist.valueMatrix(grd_premonthlist.row, grd_premonthlist.colRef("seq"));
  528. if(sSeq == "")
  529. {
  530. grd_premonthlist.addStatus(grd_premonthlist.row, "insert");
  531. }
  532. ]]>
  533. </script>
  534. </datagrid>
  535. <datagrid id="grd_fundsplanlist" nodeset="/root/main/list2/fundsplanlist" autoresize="false" backcoloralternate="#ffffff" caption="기관^일자^자금코드^자금과목명^Seq^금액^적요^단위" colsep="^" colwidth="0, 0, 0, 0, 0, 110, 208, 0" frozencols="7" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:836px; top:128px; width:357px; height:467px; ">
  536. <col ref="instcd" visibility="hidden"/>
  537. <col ref="fundsplandd" visibility="hidden"/>
  538. <col ref="fundscd" visibility="hidden"/>
  539. <col ref="fundsnm" visibility="hidden"/>
  540. <col ref="seq"/>
  541. <col ref="amt" type="input" format="(-)#,###" style="text-align:right; padding-right:2; "/>
  542. <col ref="cmt" type="input" style="left:150px; top:23px; width:280px; height:23px; text-align:left; padding-left:2; "/>
  543. <col ref="amtunit" visibility="hidden"/>
  544. </datagrid>
  545. </group>
  546. <group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
  547. <line id="line2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
  548. <button id="btn_save" class="btn4_letter2" style="left:1135px; top:3px; width:56px; height:22px; ">
  549. <caption>저장</caption>
  550. <script type="javascript" ev:event="DOMActivate">
  551. <![CDATA[
  552. fSave();
  553. fRetrieve();
  554. //grd_fundsplanstate.dispatch("onclick");
  555. ]]>
  556. </script>
  557. </button>
  558. <button id="btn_copypremonth" class="btn4_letter4" style="left:1053px; top:3px; width:80px; height:22px; ">
  559. <caption>전월복사</caption>
  560. <script type="javascript" ev:event="DOMActivate">
  561. <![CDATA[
  562. var dlgRslt = messageBox("전월복사를 실행하면 현재년월의 계획은 삭제 됩니다.", "Q004");
  563. if(dlgRslt == 6)
  564. {
  565. if(submit("TXRAF00202"))
  566. {
  567. fRetrieve();
  568. }
  569. }
  570. ]]>
  571. </script>
  572. </button>
  573. </group>
  574. </xhtml:body>
  575. </xhtml:html>