SMRFR00100_장비진행등록및조회.xrw 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614
  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. <eqmtref>
  11. <eqmtreflist/>
  12. </eqmtref>
  13. <eqmtprcs>
  14. <eqmtprcslist/>
  15. </eqmtprcs>
  16. <bugtamt>
  17. <bugtamtlist/>
  18. </bugtamt>
  19. <rpdmhsch>
  20. <rpdmhschlist/>
  21. </rpdmhsch>
  22. <rfcmaappview>
  23. <rfcmaappviewlist/>
  24. </rfcmaappview>
  25. </main>
  26. <send>
  27. <instcd/>
  28. <bugtyy/>
  29. <prcsstat/>
  30. <purcacptfd/>
  31. <purcacptld/>
  32. <bugtflag/>
  33. <iopsnflag/>
  34. <winfrym/>
  35. <wintoym/>
  36. <reqdeptcd/>
  37. <reqdeptnm/>
  38. <budgetflag/>
  39. </send>
  40. <init>
  41. </init>
  42. <temp/>
  43. </root>
  44. </instance>
  45. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  46. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  47. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  48. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  49. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  50. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  51. <script type="javascript" ev:event="xforms-ready">
  52. <![CDATA[
  53. fInitialize();
  54. ]]>
  55. </script>
  56. <submission id="TRRFR00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/eqmtref"/>
  57. <submission id="TRRFR00102" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/eqmtprcs"/>
  58. <submission id="TRRFR00103" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/bugtamt"/>
  59. <submission id="TRRFR00104" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/rpdmhschlist"/>
  60. <submission id="TRRFR00105" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/rfcmaappviewlist"/>
  61. </model>
  62. <script type="javascript">
  63. <![CDATA[
  64. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  65. function fInitialize() {
  66. model.removeNodeset("/root/main/grd_eqmtref");
  67. model.resetInstanceNode("/root/send");
  68. model.refresh();
  69. misfGridInit(grd_eqmtref);
  70. misfGridInit(grd_eqmtprcs);
  71. misfGridInit(grd_bugtamt);
  72. misfGridInit(grd_rfcmaappviewlist);
  73. misfGridInit(grd_winfrym);
  74. misfComboComCdListMulti("Z0007,R0116,R0047", "cmb_instcd,cmb_prcsstat,grd_eqmtref.curncyunit"); //기관코드, 예산계정 세팅 , 외화금액
  75. misfMsterDetailSet(grd_eqmtref,null,"TRRFR00101","Y" ,"byrow");
  76. misfMsterDetailSet(grd_eqmtprcs,null,"TRRFR00102","Y");
  77. misfMsterDetailSet(grd_bugtamt,null,"TRRFR00103","N");
  78. misfMsterDetailSet(grd_rfcmaappviewlist,null,"TRRFR00105","N");
  79. model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
  80. //rszfComboBugtList(cmb_bugtflag,getUserInfo("dutplceinstcd"));
  81. //rszfComboAppendBlankChild("cmb_instcd,cmb_prcsstat"); // 코드 리스트 에 blank를 넣는 것임
  82. rszfComboAppendBlankChild("cmb_instcd","전체","%"); // 코드 리스트 에 blank를 넣는 것임
  83. // rszfComboAppendBlankChild("cmb_bugtflag","전체",""); // 코드 리스트 에 blank를 넣는 것임
  84. rszfComboAppendBlankChild("cmb_prcsstat"); // 코드 리스트 에 blank를 넣는 것임
  85. var curdate = getCurrentDate();
  86. var cvtdate = curdate.toDate("YYYYMMDD");
  87. model.setValue(ipt_purcacptfd.attribute("ref"), cvtdate.getAddDate(-10,"D").getDateFormat("YYYYMMDD") );
  88. model.setValue(ipt_purcacptld.attribute("ref"), curdate );
  89. model.setValue(ipt_bugtyy.attribute("ref"), curdate.substr(0,4) );
  90. btn_search.dispatch("DOMActivate");
  91. ipt_winfrym.value = curdate.substr(0, 6);
  92. ipt_winfrym.dispatch("xforms-value-changed");
  93. model.refresh();
  94. }
  95. function fGridSubTotal(){
  96. if(multilinegrid1.rows > 2){
  97. var freqcnt=0, freqamt=0, fordcnt=0, fordamt=0, fwincnt=0, fwinamt=0;
  98. for(var i=2; multilinegrid1.rows-1 >= i; i++){
  99. freqcnt += parseInt( multilinegrid1.valueMatrix( i, multilinegrid1.colRef("reqcnt")) );
  100. freqamt += parseInt( multilinegrid1.valueMatrix( i, multilinegrid1.colRef("reqamt")) );
  101. fordcnt += parseInt( multilinegrid1.valueMatrix( i, multilinegrid1.colRef("ordcnt")) );
  102. fordamt += parseInt( multilinegrid1.valueMatrix( i, multilinegrid1.colRef("ordamt")) );
  103. fwincnt += parseInt( multilinegrid1.valueMatrix( i, multilinegrid1.colRef("wincnt")) );
  104. fwinamt += parseInt( multilinegrid1.valueMatrix( i, multilinegrid1.colRef("winamt")) );
  105. }
  106. multilinegrid1.insertRow(2, "above", "false", "true");
  107. multilinegrid1.rowstyle(2, "data", "background-color") = "#ffff00";
  108. multilinegrid1.valueMatrix(2, multilinegrid1.colRef("instnm")) = "TOTAL";
  109. multilinegrid1.valueMatrix(2, multilinegrid1.colRef("reqcnt")) = freqcnt;
  110. multilinegrid1.valueMatrix(2, multilinegrid1.colRef("reqamt")) = freqamt;
  111. multilinegrid1.valueMatrix(2, multilinegrid1.colRef("ordcnt")) = fordcnt;
  112. multilinegrid1.valueMatrix(2, multilinegrid1.colRef("ordamt")) = fordamt;
  113. multilinegrid1.valueMatrix( 2, multilinegrid1.colRef("wincnt")) = fwincnt;
  114. multilinegrid1.valueMatrix( 2, multilinegrid1.colRef("winamt")) = fwinamt;
  115. multilinegrid1.row = 3;
  116. }
  117. }
  118. function fnullCheck(){
  119. //if(!isRequiredControls("cmb_instcd") || !isRequiredControls("ipt_purcacptfd") || !isRequiredControls("ipt_purcacptld"))return;
  120. if(!isRequiredControls("ipt_purcacptfd") || !isRequiredControls("ipt_purcacptld"))return;
  121. //if(!isRequiredControls("cmb_instcd") || !isRequiredControls("ipt_bugtyy") || !isRequiredControls("ipt_purcacptfd") || !isRequiredControls("ipt_purcacptld"))return;
  122. misfMsterDetailRetrieve();
  123. /* [2007.12.23 HBH] multi grid 삭제 */
  124. //fGridSubTotal();
  125. }
  126. function fValueMonth()
  127. {
  128. //조회 마지막 년월 설정.
  129. model.setValue(ipt_wintoym.attribute("ref"), getCurrentDate().toDate("YYYYMMDD").getAddDate(11, "M").getDateFormat("YYYYMM") );
  130. var resultTemp;
  131. var valueMonth;
  132. var grd_title = "기관명";
  133. if(ipt_winfrym.value.substr(4,1) == '0' )
  134. {
  135. valueMonth = parseInt( ipt_winfrym.value.substr(5,1) );
  136. }else
  137. {
  138. valueMonth = parseInt( ipt_winfrym.value.substr(4,2) );
  139. }
  140. for(var s = 0; s < 12; s++)
  141. {
  142. resultTemp = ( valueMonth + s ) % 12;
  143. if(resultTemp == 0)
  144. {
  145. grd_title += "^12月";
  146. grd_title += "^12月";
  147. }else{
  148. grd_title += "^" + resultTemp + "月";
  149. grd_title += "^" + resultTemp + "月";
  150. }
  151. }
  152. grd_winfrym.caption = grd_title + "^기관명^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액";
  153. }
  154. ]]>
  155. </script>
  156. </xhtml:head>
  157. <xhtml:body>
  158. <group id="grp_title" style="left:0px; top:0px; width:1195px; height:13px; ">
  159. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">장비진행등록및 조회</caption>
  160. </group>
  161. <group id="grp_ref" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
  162. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:61px; background-color:#fffbf2; border-color:#ffd799; "/>
  163. <caption id="cap_instcd" class="search_name" style="left:15px; top:20px; width:86px; height:17px; ">기 관 :</caption>
  164. <caption id="cap_bugtyy" class="search_name" style="left:859px; top:20px; width:91px; height:17px; ">예산년도 :</caption>
  165. <input id="ipt_bugtyy" ref="/root/send/bugtyy" class="input_s_essential" format="yyyy" style="left:950px; top:20px; width:100px; height:19px; ">
  166. <script type="javascript" ev:event="xforms-value-changed">
  167. <![CDATA[
  168. btn_search.dispatch("DOMActivate");
  169. ]]>
  170. </script>
  171. </input>
  172. <caption id="cap_purcacptfd" class="search_name" style="left:15px; top:45px; width:86px; height:17px; ">승인일자 :</caption>
  173. <caption id="cap_bugtflag" class="search_name" style="left:859px; top:45px; width:89px; height:17px; ">예산구분 :</caption>
  174. <button id="btn_search" class="btn1_letter2" navindex="8" style="left:1125px; top:29px; width:56px; height:22px; text-align:left; ">
  175. <caption>조회</caption>
  176. <script type="javascript" ev:event="DOMActivate">
  177. <![CDATA[
  178. fnullCheck();
  179. ]]>
  180. </script>
  181. </button>
  182. <line id="line2" class="line_4" style="x1:1110px; y1:18px; x2:1110px; y2:61px; border-color:#ffe4bb; border-left-style:solid; "/>
  183. <caption id="cap_prcsstat" class="search_name" style="left:585px; top:45px; width:86px; height:17px; ">진행상태 :</caption>
  184. <select1 id="cmb_bugtflag" ref="/root/send/budgetflag" class="combo_s_essential" appearance="minimal" style="left:950px; top:44px; width:100px; height:19px; ">
  185. <choices>
  186. <item>
  187. <label>전체</label>
  188. <value/>
  189. </item>
  190. <item>
  191. <label>기자재</label>
  192. <value>1</value>
  193. </item>
  194. <item>
  195. <label>응급</label>
  196. <value>2</value>
  197. </item>
  198. <item>
  199. <label>기타</label>
  200. <value>3</value>
  201. </item>
  202. <item>
  203. <label>Nego예산</label>
  204. <value>4</value>
  205. </item>
  206. <item>
  207. <label>교비</label>
  208. <value>5</value>
  209. </item>
  210. <item>
  211. <label>연구비</label>
  212. <value>6</value>
  213. </item>
  214. </choices>
  215. </select1>
  216. <select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_s_essential" appearance="minimal" style="left:100px; top:18px; width:215px; height:19px; ">
  217. <choices>
  218. <itemset>
  219. <label/>
  220. <value/>
  221. </itemset>
  222. </choices>
  223. <script type="javascript" ev:event="xforms-value-changed">
  224. <![CDATA[
  225. //rszfComboBugtList(cmb_bugtflag,model.getValue(cmb_instcd.attribute("ref")));
  226. btn_search.dispatch("DOMActivate");
  227. ]]>
  228. </script>
  229. </select1>
  230. <select1 id="cmb_prcsstat" ref="/root/send/prcsstat" class="combo_s_essential" appearance="minimal" style="left:673px; top:44px; width:100px; height:19px; ">
  231. <choices>
  232. <itemset>
  233. <label/>
  234. <value/>
  235. </itemset>
  236. </choices>
  237. <script type="javascript" ev:event="xforms-value-changed">
  238. <![CDATA[
  239. btn_search.dispatch("DOMActivate");
  240. ]]>
  241. </script>
  242. </select1>
  243. <caption id="cap_purcacpt" style="left:202px; top:47px; width:15px; height:20px; font-weight:bold; ">~</caption>
  244. <input id="ipt_purcacptfd" ref="/root/send/purcacptfd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:100px; top:44px; width:100px; height:19px; ">
  245. <script type="javascript" ev:event="xforms-value-changed">
  246. <![CDATA[
  247. btn_search.dispatch("DOMActivate");
  248. ]]>
  249. </script>
  250. </input>
  251. <input id="ipt_purcacptld" ref="/root/send/purcacptld" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:215px; top:44px; width:100px; height:19px; ">
  252. <script type="javascript" ev:event="xforms-value-changed">
  253. <![CDATA[
  254. btn_search.dispatch("DOMActivate");
  255. ]]>
  256. </script>
  257. </input>
  258. <caption id="caption1" class="search_name" style="left:330px; top:45px; width:99px; height:17px; ">내자/외자 :</caption>
  259. <select1 id="cmb_iopsnflag" ref="/root/send/iopsnflag" class="combo_s_essential" appearance="minimal" style="left:438px; top:44px; width:100px; height:19px; ">
  260. <choices>
  261. <item>
  262. <label>전체</label>
  263. <value/>
  264. </item>
  265. <item>
  266. <label>내자</label>
  267. <value>H</value>
  268. </item>
  269. <item>
  270. <label>외자</label>
  271. <value>F</value>
  272. </item>
  273. </choices>
  274. <script type="javascript" ev:event="xforms-value-changed">
  275. <![CDATA[
  276. btn_search.dispatch("DOMActivate");
  277. ]]>
  278. </script>
  279. </select1>
  280. <button id="button1" class="btn_sw" group="tab" selected="true" style="left:0px; top:76px; width:128px; height:22px; ">
  281. <caption>장비진행현황</caption>
  282. <toggle case="case2" ev:event="DOMActivate"/>
  283. </button>
  284. <button id="button2" class="btn_sw" visibility="visible" group="tab" style="left:129px; top:76px; width:147px; height:22px; ">
  285. <caption>장비진행상태</caption>
  286. <toggle case="case1" ev:event="DOMActivate"/>
  287. </button>
  288. <switch id="switch1" style="left:0px; top:100px; width:1195px; height:625px; ">
  289. <case id="case1">
  290. <line id="line3" class="line_1" style="x1:0px; y1:22px; x2:1193px; y2:23px; "/>
  291. <caption id="caption4" class="tit_2" style="left:0px; top:7px; width:197px; height:14px; ">건수 진행률</caption>
  292. <caption id="caption3" class="tit_2" style="left:0px; top:148px; width:223px; height:14px; ">금액별 집행률</caption>
  293. <line id="line6" class="line_1" style="x1:0px; y1:163px; x2:1193px; y2:164px; "/>
  294. <datagrid id="grd_bugtamt" nodeset="/root/main/bugtamt/bugtamtlist" caption="기관명^총 접수현황^총 접수현황^입고현황^입고현황^잔존현황^잔존현황^절감액(누적)^절감율(누적)|기관명^건수^예산^건수^지불금액^건수^잔액^절감액(누적)^절감율(누적)" colsep="^" colwidth="148, 125, 125, 125, 125, 122, 125, 137, 131" dataheight="25" frozencols="1" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:322px; width:1188px; height:129px; ">
  295. <col ref="instnm" style="text-align:left; padding-left:10; "/>
  296. <col ref="reqcnt" format="#,###" style="text-align:right; "/>
  297. <col ref="reqamt" format="#,###" style="text-align:right; "/>
  298. <col ref="wincnt" format="#,###" style="text-align:right; "/>
  299. <col ref="winamt" format="#,###" style="text-align:right; "/>
  300. <col ref="reqremaincnt" format="#,###" style="text-align:right; "/>
  301. <col ref="reqremainamt" format="#,###" style="text-align:right; "/>
  302. <col ref="windcamt" format="#,###.##" style="text-align:right; "/>
  303. <col ref="windcrate" format="#,###.##" style="text-align:right; "/>
  304. </datagrid>
  305. <caption id="caption2" class="tit_2" style="left:1px; top:303px; width:157px; height:13px; ">장비예산 누적 집행현황</caption>
  306. <caption id="cap_winfrym" class="tit_2" style="left:0px; top:461px; width:138px; height:13px; ">장비입고예정년월 :</caption>
  307. <datagrid id="grd_winfrym" nodeset="/root/main/rpdmhsch/rpdmhschlist" caption="기관명^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액|기관명^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액^건수^발주금액" colsep="^" colwidth="148, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70" dataheight="25" frozencols="1" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:485px; width:1188px; height:128px; ">
  308. <col ref="instnm" style="text-align:left; padding-left:10; "/>
  309. <col ref="mon00cnt" format="#,###" style="text-align:right; "/>
  310. <col ref="mon00amt" format="#,###" style="text-align:right; "/>
  311. <col ref="mon01cnt" format="#,###" style="text-align:right; "/>
  312. <col ref="mon01amt" format="#,###" style="text-align:right; "/>
  313. <col ref="mon02cnt" format="#,###" style="text-align:right; "/>
  314. <col ref="mon02amt" format="#,###" style="text-align:right; "/>
  315. <col ref="mon03cnt" format="#,###" style="left:588px; top:43px; width:70px; height:23px; text-align:right; "/>
  316. <col ref="mon03amt" format="#,###" style="text-align:right; "/>
  317. <col ref="mon04cnt" format="#,###" style="text-align:right; "/>
  318. <col ref="mon04amt" format="#,###" style="text-align:right; "/>
  319. <col ref="mon05cnt" format="#,###" style="text-align:right; "/>
  320. <col ref="mon05amt" format="#,###" style="text-align:right; "/>
  321. <col ref="mon06cnt" format="#,###" style="text-align:right; "/>
  322. <col ref="mon06amt" format="#,###" style="text-align:right; "/>
  323. <col ref="mon07cnt" format="#,###" style="text-align:right; "/>
  324. <col ref="mon07amt" format="#,###" style="text-align:right; "/>
  325. <col ref="mon08cnt" format="#,###" style="text-align:right; "/>
  326. <col ref="mon08amt" format="#,###" style="text-align:right; "/>
  327. <col ref="mon09cnt" format="#,###" style="text-align:right; "/>
  328. <col ref="mon09amt" format="#,###" style="text-align:right; "/>
  329. <col ref="mon10cnt" format="#,###" style="text-align:right; "/>
  330. <col ref="mon10amt" format="#,###" style="text-align:right; "/>
  331. <col ref="mon11cnt" format="#,###" style="text-align:right; "/>
  332. <col ref="mon11amt" format="#,###" style="text-align:right; "/>
  333. </datagrid>
  334. <line id="line4" class="line_1" style="x1:0px; y1:318px; x2:1193px; y2:319px; "/>
  335. <input id="ipt_wintoym" ref="/root/send/wintoym" visibility="hidden" inputtype="date" maxlength="6" format="yyyy-mm" calss="input_search" style="left:243px; top:456px; width:100px; height:19px; "/>
  336. <input id="ipt_winfrym" ref="/root/send/winfrym" inputtype="date" maxlength="6" format="yyyy-mm" calss="input_search" style="left:135px; top:456px; width:100px; height:19px; text-align:center; ">
  337. <script type="javascript" ev:event="xforms-value-changed">
  338. <![CDATA[
  339. misfGridInit(grd_winfrym);
  340. if(ipt_winfrym.value != "")
  341. {
  342. fValueMonth();
  343. submit("TRRFR00104");
  344. }
  345. ]]>
  346. </script>
  347. </input>
  348. <line id="line5" class="line_1" style="x1:0px; y1:480px; x2:1193px; y2:481px; "/>
  349. <button id="button3" class="btn5_letter3" style="left:1135px; top:1px; width:53px; height:19px; ">
  350. <caption>Excel</caption>
  351. <script type="javascript" ev:event="DOMActivate">
  352. <![CDATA[
  353. var fileName = window.fileDialog("save", ",", false, "청구 발주 입고별 건수 진행률", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  354. if (fileName != "")
  355. {
  356. grd_eqmtprcs.saveExcel(fileName, "청구/발주/입고별 건수 진행률",true,true, "");
  357. }
  358. ]]>
  359. </script>
  360. </button>
  361. <button id="button7" class="btn5_letter3" style="left:1132px; top:142px; width:53px; height:19px; ">
  362. <caption>Excel</caption>
  363. <script type="javascript" ev:event="DOMActivate">
  364. <![CDATA[
  365. var fileName = window.fileDialog("save", ",", false, "입고 발주 청구별 금액별 집행률", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  366. if (fileName != "")
  367. {
  368. grd_rfcmaappviewlist.saveExcel(fileName, "입고/발주/청구별 금액별 집행률",true,true, "");
  369. }
  370. ]]>
  371. </script>
  372. </button>
  373. <button id="button4" class="btn5_letter3" style="left:1131px; top:296px; width:53px; height:19px; ">
  374. <caption>Excel</caption>
  375. <script type="javascript" ev:event="DOMActivate">
  376. <![CDATA[
  377. var fileName = window.fileDialog("save", ",", false, "장비예산 누적 집행현황", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  378. if (fileName != "")
  379. {
  380. grd_bugtamt.saveExcel(fileName, "장비예산 누적 집행현황",true,true, "");
  381. }
  382. ]]>
  383. </script>
  384. </button>
  385. <datagrid id="grd_eqmtprcs" nodeset="/root/main/eqmtprcs/eqmtprcslist" visibility="visible" caption="기관명^총 접수현황^청구^청구^발주^발주^입고^입고|기관명^총 접수현황^건수^비율(%)^건수^비율(%)^건수^비율(%)" colsep="^" colwidth="170, 118, 145, 145, 145, 145, 145, 145" dataheight="25" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:26px; width:1188px; height:114px; ">
  386. <col ref="instnm" style="text-align:left; padding-left:10; "/>
  387. <col ref="totcnt" format="#,###" style="text-align:right; "/>
  388. <col ref="reqcnt" format="#,###" style="text-align:right; "/>
  389. <col ref="reqrate" format="##.#" style="text-align:right; "/>
  390. <col ref="ordcnt" format="#,###" style="text-align:right; "/>
  391. <col ref="ordrate" format="#,###" style="text-align:right; "/>
  392. <col ref="wincnt" format="#,###" style="text-align:right; "/>
  393. <col ref="winrate" format="#,###" style="text-align:right; "/>
  394. <script type="javascript" ev:event="onaftersort">
  395. <![CDATA[
  396. grd_eqmtprcs.gridToInstance();
  397. ]]>
  398. </script>
  399. </datagrid>
  400. <datagrid id="grd_rfcmaappviewlist" nodeset="/root/main/rfcmaappview/rfcmaappviewlist" caption="기관명^총 접수 현황^총 접수 현황^접수^접수^접수^접수^발주^발주^발주^발주^입고^입고^입고^입고|기관명^건수^예산^건수^지불금액^절감액^절감율^건수^지불금액^절감액^절감율^건수^발주금액^절감액^절감율" colsep="^" colwidth="147, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" frozencols="1" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:167px; width:1188px; height:128px; ">
  401. <col ref="instnm" style="text-align:left; padding-left:10; "/>
  402. <col ref="totcnt" format="#,###" style="text-align:right; "/>
  403. <col ref="totamt" format="#,###" style="text-align:right; "/>
  404. <col ref="reqcnt" format="#,###" style="text-align:right; "/>
  405. <col ref="reqamt" format="#,###" style="text-align:right; "/>
  406. <col ref="reqdcamt" format="#,###" style="text-align:right; "/>
  407. <col ref="reqdcrate" format="#,###.##" style="text-align:right; "/>
  408. <col ref="ordcnt" format="#,###" style="text-align:right; "/>
  409. <col ref="ordamt" format="#,###" style="text-align:right; "/>
  410. <col ref="orddcamt" format="#,###" style="text-align:right; "/>
  411. <col ref="orddcrate" format="#,###.##" style="text-align:right; "/>
  412. <col ref="wincnt" format="#,###" style="text-align:right; "/>
  413. <col ref="winamt" format="#,###" style="text-align:right; "/>
  414. <col ref="windcamt" format="#,###" style="text-align:right; "/>
  415. <col ref="windcrate" format="#,###.##" style="text-align:right; "/>
  416. </datagrid>
  417. <button id="button6" class="btn5_letter3" style="left:1131px; top:455px; width:53px; height:19px; ">
  418. <caption>Excel</caption>
  419. <script type="javascript" ev:event="DOMActivate">
  420. <![CDATA[
  421. var fileName = window.fileDialog("save", ",", false, "장비입고예정 현황", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  422. if (fileName != "")
  423. {
  424. grd_winfrym.saveExcel(fileName, "장비입고예정 현황",true,true, "");
  425. }
  426. ]]>
  427. </script>
  428. </button>
  429. </case>
  430. <case id="case2" selected="true" style="left:0px; top:0px; width:1193px; height:623px; ">
  431. <datagrid id="grd_eqmtref" nodeset="/root/main/eqmtref/eqmtreflist" caption="진행상태^기관^청구번호^청구부서^장비명(영문)^장비명(한글)^모델^수량^예산금액^발주금액^구입금액^외화금액^화폐단위^절감액^절감율^제조회사명^제조국명^거래처명^내/외자^예산구분^설치장소^사용부서^입고예정일" colsep="^" colwidth="62, 93, 93, 97, 143, 129, 111, 56, 72, 74, 78, 70, 65, 78, 43, 90, 75, 101, 56, 78, 90, 100, 76, 100, 100, 100, 100, 100, 100, 100, 100" dataheight="25" ellipsis="true" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" selectionmode="byrow" style="left:0px; top:0px; width:1193px; height:590px; ">
  432. <col ref="prcsstatnm"/>
  433. <col ref="instnm"/>
  434. <col ref="reqno"/>
  435. <col ref="reqdeptnm"/>
  436. <col ref="goodflagengnm"/>
  437. <col ref="goodflaghngnm"/>
  438. <col ref="goodmodel"/>
  439. <col ref="plceordqty" format="#,###" style="text-align:right; "/>
  440. <col ref="bugtwncurncy" format="#,###" style="text-align:right; "/>
  441. <col ref="plceordamt" format="#,###" style="text-align:right; "/>
  442. <col ref="plcewinamt" format="#,###" style="text-align:right; "/>
  443. <col ref="forgncurncyamt" format="#,###" style="text-align:right; "/>
  444. <col disabled="true" ref="curncyunit" type="combo">
  445. <choices>
  446. <itemset>
  447. <label/>
  448. <value/>
  449. </itemset>
  450. </choices>
  451. </col>
  452. <col ref="dcamt" format="#,###" style="text-align:right; "/>
  453. <col ref="dcrate" format="#,###" style="text-align:right; "/>
  454. <col ref="prodcmpynm"/>
  455. <col ref="prodplcenm"/>
  456. <col ref="suppcustnm" visibility="hidden"/>
  457. <col ref="iopsnflag"/>
  458. <col class="gridcombo" ref="budgetflag" type="combo">
  459. <choices>
  460. <item>
  461. <label>기자재</label>
  462. <value>1</value>
  463. </item>
  464. <item>
  465. <label>응급</label>
  466. <value>2</value>
  467. </item>
  468. <item>
  469. <label>기타</label>
  470. <value>3</value>
  471. </item>
  472. <item>
  473. <label>Nego예산</label>
  474. <value>4</value>
  475. </item>
  476. <item>
  477. <label>교비</label>
  478. <value>5</value>
  479. </item>
  480. <item>
  481. <label>연구비</label>
  482. <value>6</value>
  483. </item>
  484. </choices>
  485. </col>
  486. <col ref="installplcenm"/>
  487. <col ref="mngtdeptnm"/>
  488. <col ref="winschedd" format="yyyy-mm-dd"/>
  489. <col ref="prcsstat" visibility="hidden"/>
  490. <col ref="instcd" visibility="hidden"/>
  491. <col ref="reqdeptcd" visibility="hidden"/>
  492. <col ref="mngtdeptcd" visibility="hidden"/>
  493. <col ref="prodcmpy" visibility="hidden"/>
  494. <col ref="prodplce" visibility="hidden"/>
  495. <col ref="suppcustcd" visibility="hidden"/>
  496. <col ref="installplcecd" visibility="hidden"/>
  497. <script type="javascript" ev:event="onaftersort">
  498. <![CDATA[
  499. grd_eqmtref.gridToInstance();
  500. ]]>
  501. </script>
  502. </datagrid>
  503. </case>
  504. </switch>
  505. <caption id="caption8" class="search_name" style="left:330px; top:20px; width:117px; height:17px; ">청구부서 :</caption>
  506. <output id="opt_reqdeptnm_search" ref="/root/send/reqdeptnm" class="output_fix" appearance="output" style="left:574px; top:20px; width:201px; height:19px; "/>
  507. <button id="button5" class="icon_search" style="left:553px; top:21px; width:16px; height:16px; ">
  508. <caption/>
  509. <script type="javascript" ev:event="DOMActivate">
  510. <![CDATA[
  511. var recv_list = "reqdeptcd,reqdeptnm";
  512. misfOpenPopUpList("02", ipt_reqdeptcd_search,"", recv_list) ;
  513. model.refresh();
  514. ]]>
  515. </script>
  516. </button>
  517. <input id="ipt_reqdeptcd_search" ref="/root/send/reqdeptcd" class="input_s_essential" style="left:425px; top:20px; width:120px; height:19px; ">
  518. <script type="javascript" ev:event="xforms-value-changed">
  519. <![CDATA[
  520. if(ipt_reqdeptcd_search.value.length == 0)
  521. opt_reqdeptnm_search.value = "";
  522. else
  523. misfValidationCheck("02", "", "reqdeptcd,reqdeptnm", cmb_instcd.value, "instcd" );
  524. model.refresh();
  525. ]]>
  526. </script>
  527. </input>
  528. <button id="btn_excel" class="btn5_letter3" style="left:1134px; top:75px; width:53px; height:19px; ">
  529. <caption>Excel</caption>
  530. <script type="javascript" ev:event="DOMActivate">
  531. <![CDATA[
  532. var fileName = window.fileDialog("save", ",", false, "장비진행현황", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  533. if (fileName != "")
  534. {
  535. grd_eqmtref.saveExcel(fileName, "장비진행현황List",true,true, "");
  536. }
  537. ]]>
  538. </script>
  539. </button>
  540. </group>
  541. <group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
  542. <line id="line1" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
  543. <button id="btn_init" class="btn4_letter3" style="left:1127px; top:3; width:68px; height:22px; ">
  544. <caption>초기화</caption>
  545. <script type="javascript" ev:event="DOMActivate">
  546. <![CDATA[
  547. fInitialize();
  548. ]]>
  549. </script>
  550. </button>
  551. </group>
  552. </xhtml:body>
  553. </xhtml:html>