SMRBP01000_예산요구내역서.xrw 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356
  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. <list>
  11. <datalist>
  12. <instcd/>
  13. <gubn/>
  14. <acntyy/>
  15. <deptcd/>
  16. <depthngnm/>
  17. <supacntnm2/>
  18. <supacntnm3/>
  19. <supacntnm4/>
  20. <acntnm/>
  21. <totalorgbugtamt/>
  22. <calculation1/>
  23. <calculation2/>
  24. <calculation3/>
  25. </datalist>
  26. </list>
  27. </main>
  28. <send>
  29. <retrparams>
  30. <instcd/>
  31. <acntyy/>
  32. <deptcd/>
  33. <depthngnm/>
  34. <bugtflag/>
  35. <quarter/>
  36. <todate/>
  37. </retrparams>
  38. <date/>
  39. </send>
  40. <hidden>
  41. </hidden>
  42. <init>
  43. </init>
  44. <temp/>
  45. </root>
  46. </instance>
  47. <submission id="TRRBP01001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/list"/>
  48. </model>
  49. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  50. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  51. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  52. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  53. <script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
  54. <script type="javascript" src="../../../mis/bugtcommonweb/js/RBC001.js"/>
  55. <script type="javascript" src="../../../mis/acntcommonweb/js/RAD001.js"/>
  56. <script type="javascript" ev:event="xforms-ready">
  57. <![CDATA[
  58. // fQuarterChange();
  59. fCheckAuth();
  60. fInitialize();
  61. btn_search.dispatch("DOMActivate");
  62. ]]>
  63. </script>
  64. <script type="javascript">
  65. <![CDATA[
  66. var acntdept = ""; //재무팀 부서코드 default 값 "4030100000"
  67. var bugtdept = ""; //기획팀 부서코드 default 값 "4060100000"
  68. var Deptcd = getUserInfo("dutplcecd");
  69. var Deptnm = getUserInfo("dutplcenm");
  70. //========================================================================================
  71. //화면 권한 체크
  72. //========================================================================================
  73. function fCheckAuth()
  74. {
  75. btn_search.disabled = !checkAuth("R") ;
  76. }
  77. //========================================================================================
  78. //초기화
  79. //========================================================================================
  80. function fInitialize()
  81. {
  82. model.removenode("/root/main/list/bugtexeclist");
  83. misfComboComCdListMulti("Z0007","cmb_instcd");
  84. model.setValue("/root/send/retrparams/instcd", getUserInfo("dutplceinstcd"));
  85. model.setValue("/root/send/retrparams/acntyy", getCurrentDate().substr(0,4));
  86. //model.setValue("/root/send/retrparams/todate", getCurrentDate().substr(0,6));
  87. //racfGetCadlYmd("/root/send/date", "/root/temp");
  88. //ipt_acntyy.value = model.getValue("/root/temp/acntyy");
  89. model.setValue("/root/send/retrparams/deptcd", Deptcd);
  90. model.setValue("/root/send/retrparams/depthngnm", Deptnm);
  91. rdo_bugtflag.value = "2"
  92. if(getUserInfo("dutplceinstcd") != "001")
  93. {
  94. cmb_instcd.disabled = true;
  95. }
  96. model.setFocus("ipt_deptcd");
  97. model.refresh();
  98. }
  99. //========================================================================================
  100. //부서코드 Help Open
  101. //========================================================================================
  102. function fOpenPopupDeptHelp(pControl, pInstance)
  103. {
  104. misfOpenPopUpList("11", pControl, "", pInstance);
  105. model.refresh();
  106. }
  107. //========================================================================================
  108. //분기수정
  109. //========================================================================================
  110. function fQuarterChange()
  111. {
  112. if (ipt_acntyy.value >= ipt_acntyy.value.substr(0,4) + "0101" && ipt_acntyy.value <= ipt_acntyy.value.substr(0,4) + "0331"){
  113. model.setValue("/root/send/retrparams/quarter", "1");
  114. }else if (ipt_acntyy.value >= ipt_acntyy.value.substr(0,4) + "0401" && ipt_acntyy.value <= ipt_acntyy.value.substr(0,4) + "0630"){
  115. model.setValue("/root/send/retrparams/quarter", "2");
  116. }else if (ipt_acntyy.value >= ipt_acntyy.value.substr(0,4) + "0701" && ipt_acntyy.value <= ipt_acntyy.value.substr(0,4) + "0930"){
  117. model.setValue("/root/send/retrparams/quarter", "3");
  118. }else if (ipt_acntyy.value >= ipt_acntyy.value.substr(0,4) + "1001" && ipt_acntyy.value <= ipt_acntyy.value.substr(0,4) + "1231"){
  119. model.setValue("/root/send/retrparams/quarter", "4");
  120. }
  121. model.setValue("/root/send/retrparams/acntyy", ipt_acntyy.value.substr(0,4));
  122. model.refresh();
  123. }
  124. //========================================================================================
  125. //각종 코드 Help Open
  126. //========================================================================================
  127. function fOpenPopupHelp(pHelper, pControl, pInstance, pCdgrupid, pValueControl, pNodeName)
  128. {
  129. misfOpenPopUpList(pHelper, pControl, pCdgrupid, pInstance, pValueControl, pNodeName);
  130. model.refresh();
  131. }
  132. //========================================================================================
  133. //출력
  134. //========================================================================================
  135. function fPrint()
  136. {
  137. exeReportPreview("RPRBP01001", "XMLSTR");
  138. model.refresh();
  139. }
  140. ]]>
  141. </script>
  142. </xhtml:head>
  143. <xhtml:body pagewidth="1211" pageheight="784" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  144. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  145. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:250px; height:14px; ">부서별예산요구내역서</caption>
  146. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  147. </group>
  148. <group id="group3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
  149. <line id="line1" class="line_1" style="x1:0px; y1:80px; x2:1195px; y2:80px; "/>
  150. <group id="group2" style="left:0px; top:10px; width:1194px; height:40px; vertical-align:top; ">
  151. <shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1194px; height:40px; background-color:#fffbf2; border-color:#ffd799; "/>
  152. <caption id="caption9" class="search_name" style="left:270px; top:12px; width:93px; height:17px; ">예산년월 :</caption>
  153. <button id="btn_search" class="btn1_letter2" navindex="8" style="left:1123px; top:9px; width:56px; height:22px; text-align:left; ">
  154. <caption>조회</caption>
  155. <script type="javascript" ev:event="DOMActivate">
  156. <![CDATA[
  157. model.removeNodeset(grd_bugtexecist.nodeset);
  158. model.refresh();
  159. //fQuarterChange();
  160. submit("TRRBP01001");
  161. for(var i = 0 ; i < grd_bugtexecist.rows ; i++)
  162. {
  163. if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "0"){
  164. grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ff99cc";
  165. }else if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "1"){
  166. grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ffcc99";
  167. }else if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "2"){
  168. grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ffff99";
  169. }else if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "3"){
  170. grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ccffcc";
  171. }else if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "4"){
  172. grd_bugtexecist.rowStyle(i, "all", "background-color") = "#cc99ff";
  173. }else if(grd_bugtexecist.valueMatrix(i, grd_bugtexecist.colRef("gubn")) == "5"){
  174. grd_bugtexecist.rowStyle(i, "all", "background-color") = "#ffffff";
  175. }
  176. }
  177. ]]>
  178. </script>
  179. </button>
  180. <line id="line2" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:31px; border-color:#ffe4bb; border-left-style:solid; "/>
  181. <select1 id="cmb_instcd" ref="/root/send/retrparams/instcd" class="combo_search" navindex="1" appearance="minimal" style="left:102px; top:11px; width:153px; height:19px; ">
  182. <choices>
  183. <itemset>
  184. <label/>
  185. <value/>
  186. </itemset>
  187. </choices>
  188. </select1>
  189. <caption id="caption8" class="search_name" style="left:14px; top:12px; width:86px; height:17px; ">소속기관 :</caption>
  190. <select1 id="rdo_bugtflag" ref="/root/send/retrparams/bugtflag" navindex="27" appearance="full" cellspacing="10" cols="4" overflow="visible" style="left:899px; top:11px; width:206px; height:20px; border-style:none; ">
  191. <choices>
  192. <item>
  193. <label>수입</label>
  194. <value>1</value>
  195. </item>
  196. <item>
  197. <label>비용</label>
  198. <value>2</value>
  199. </item>
  200. <item>
  201. <label>구매</label>
  202. <value>3</value>
  203. </item>
  204. <item>
  205. <label>자본</label>
  206. <value>4</value>
  207. </item>
  208. </choices>
  209. <script type="javascript" ev:event="xforms-value-changed">
  210. <![CDATA[
  211. btn_search.dispatch("DOMActivate");
  212. ]]>
  213. </script>
  214. </select1>
  215. <caption id="caption5" class="search_name" style="left:810px; top:12px; width:87px; height:17px; ">예산구분 :</caption>
  216. <input id="ipt_acntyy" ref="/root/send/retrparams/acntyy" class="input_s_essential" navindex="2" style="left:360px; top:11px; width:100px; height:19px; text-align:center; "/>
  217. <input id="ipt_depthngnm" ref="/root/send/retrparams/depthngnm" class="input_s_essential" disabled="false" navindex="3" imemode="hangul" style="left:645px; top:11px; width:150px; height:19px; ">
  218. <script type="javascript" ev:event="onkeypress">
  219. <![CDATA[
  220. racfBugtDeptValidCheck("deptcd,depthngnm", "name");
  221. if(event.keyCode == 13)
  222. {
  223. btn_search.dispatch("DOMActivate");
  224. }
  225. ]]>
  226. </script>
  227. <script type="javascript" ev:event="xforms-value-changed">
  228. <![CDATA[
  229. racfBugtDeptValidCheck("deptcd,depthngnm", "name");
  230. if(ipt_deptcd.value != "" && ipt_depthngnm.value != "")
  231. {
  232. btn_search.dispatch("DOMActivate");
  233. }
  234. ]]>
  235. </script>
  236. </input>
  237. <button id="btn_depthelp" class="icon_search" disabled="false" style="left:624px; top:11px; width:16px; height:16px; ">
  238. <caption/>
  239. <script type="javascript" ev:event="DOMActivate">
  240. <![CDATA[
  241. fOpenPopupDeptHelp(ipt_deptcd, "deptcd,depthngnm");
  242. if(ipt_deptcd.value != "" &&ipt_depthngnm.value != "")
  243. {
  244. btn_search.dispatch("DOMActivate");
  245. }
  246. ]]>
  247. </script>
  248. </button>
  249. <caption id="caption3" class="search_name" style="left:476px; top:12px; width:107px; height:17px; ">부서 :</caption>
  250. <input id="ipt_deptcd" ref="/root/send/retrparams/deptcd" class="input_s_essential" disabled="false" navindex="2" maxlength="10" style="left:540px; top:11px; width:80px; height:19px; ">
  251. <script type="javascript" ev:event="onkeypress">
  252. <![CDATA[
  253. if(event.keyCode == 13)
  254. {
  255. model.setFocus("ipt_depthngnm");
  256. }
  257. ]]>
  258. </script>
  259. <script type="javascript" ev:event="xforms-value-changed">
  260. <![CDATA[
  261. racfBugtDeptValidCheck("deptcd,depthngnm", "code");
  262. if(ipt_deptcd.value != "" &&ipt_depthngnm.value != "")
  263. {
  264. btn_search.dispatch("DOMActivate");
  265. }
  266. ]]>
  267. </script>
  268. </input>
  269. </group>
  270. <caption id="caption2" class="tit_2" style="left:5px; top:65px; width:147px; height:14px; ">부서별예산요구내역서</caption>
  271. <datagrid id="grd_bugtexecist" nodeset="/root/main/list/datalist" caption="계정과목^계정과목^계정과목^계정과목^예산요구액^산출내역^산출내역^산출내역^기관코드^구분^예산연도^부서코드^부서명|관^항^목^세목^예산요구액^산출내역^산출내역^산출내역^기관코드^구분^예산연도^부서코드^부서명" colsep="^" colwidth="80, 80, 90, 160, 120, 210, 210, 120, 100, 100, 100, 100, 100" ellipsis="true" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" tooltip="true" style="left:0px; top:85px; width:1195px; height:645px; ">
  272. <col ref="supacntnm2" style="vertical-align:top; padding-top:3; "/>
  273. <col ref="supacntnm3" style="vertical-align:top; padding-top:3; "/>
  274. <col ref="supacntnm4" style="vertical-align:top; padding-top:3; "/>
  275. <col ref="acntnm" style="vertical-align:top; padding-top:3; "/>
  276. <col ref="totalorgbugtamt" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
  277. <col ref="calculation1"/>
  278. <col ref="calculation2"/>
  279. <col ref="calculation3" format="(-)#,###" style="text-align:right; "/>
  280. <col ref="instcd" visibility="hidden"/>
  281. <col ref="gubn" visibility="hidden"/>
  282. <col ref="acntyy" visibility="hidden" style="background-color:#ffffff; "/>
  283. <col ref="deptcd" visibility="hidden" style="background-color:#ffffff; "/>
  284. <col ref="depthngnm" visibility="hidden"/>
  285. </datagrid>
  286. <button id="btn_5" class="btn2_letter4" style="left:1125px; top:60px; width:64px; height:19px; text-align:left; ">
  287. <caption>엑셀출력</caption>
  288. <script type="javascript" ev:event="DOMActivate">
  289. <![CDATA[
  290. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  291. grd_bugtexecist.saveExcel(fileName,"SheetName:sheet1");
  292. //radfSaveExcel(grd_exceloutput1);
  293. ]]>
  294. </script>
  295. </button>
  296. </group>
  297. <group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
  298. <line id="line5" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
  299. <button id="btn_print" class="btn4_letter2" style="left:1136px; top:3px; width:56px; height:22px; ">
  300. <caption>출력</caption>
  301. <script type="javascript" ev:event="DOMActivate">
  302. <![CDATA[
  303. fPrint();
  304. ]]>
  305. </script>
  306. </button>
  307. </group>
  308. </xhtml:body>
  309. </xhtml:html>