SMRFC00919_년도별자산현황.xrw 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
  3. <xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:ms="urn:schemas-microsoft-com:xslt" xmlns:my="http://www.comsquare.co.kr/example" 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" xmlns:cs="http://www.comsquare.co.kr/xforms">
  4. <xhtml:head>
  5. <xhtml:title>년도별자산현황</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <list>
  11. <fixaset>
  12. <fixasetlist/>
  13. </fixaset>
  14. <fixasetmodel/>
  15. </list>
  16. <fixasetdet>
  17. <fixasettmplist/>
  18. </fixasetdet>
  19. </main>
  20. <send>
  21. <fixasetlist>
  22. <instcd_search/>
  23. <mngtdeptcd_search/>
  24. <mngtdeptnm_search/>
  25. <possnfrdd_search/>
  26. <possntodd_search/>
  27. <deptflag_search/>
  28. <mdlcd_search/>
  29. <smlcd_search/>
  30. <possndd_search/>
  31. <gubun_search/>
  32. </fixasetlist>
  33. </send>
  34. <init>
  35. <goodflag>
  36. <label>비품</label>
  37. <value>GE</value>
  38. <label>의료장비</label>
  39. <value>EQ</value>
  40. </goodflag>
  41. </init>
  42. <temp>
  43. <searchresult>
  44. <fixaset/>
  45. </searchresult>
  46. <fixcdinfo>
  47. <mdlcd/>
  48. <smlcd/>
  49. <possndd/>
  50. <gubun/>
  51. <mngtdeptcd/>
  52. <deptflag/>
  53. </fixcdinfo>
  54. </temp>
  55. </root>
  56. </instance>
  57. <script type="javascript" ev:event="xforms-ready">
  58. <![CDATA[
  59. //화면 Control을 초기화한다
  60. fInitialize();
  61. ]]>
  62. </script>
  63. <submission id="TXRFC00919" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/fixasetlist" resultref="/root/temp"/>
  64. <submission id="TRRFC00919" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/fixasetlist" resultref="/root/main/list/fixaset"/>
  65. </model>
  66. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  67. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  68. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  69. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  70. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  71. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  72. <script type="javascript">
  73. <![CDATA[
  74. function fInitialize()
  75. {
  76. misfGridInit(grd_fixasetlist);
  77. misfComboComCdListMulti("C0048,R0480",
  78. "cmb_instcd_search,cmb_deptflag_search");
  79. addComboItem("cmb_deptflag_search", "전체", "", "above" );
  80. model.setValue("/root/send/fixasetlist/instcd_search", getUserInfo("dutplceinstcd")); // 기관 설정
  81. model.resetInstanceNode("/root/main/fixasetdet/fixasettmplist");
  82. model.resetInstanceNode("/root/main/list/fixasetdet/fixasettmplist");
  83. misfMsterDetailSet(grd_fixasetlist, null, "TRRFC00919", "Y" , "byrow");
  84. var curdate = getCurrentDate();
  85. model.setValue(ipt_possnfrdd_search.attribute("ref"),"20040101");
  86. model.setValue(ipt_possntodd_search.attribute("ref"),curdate);
  87. model.refresh();
  88. // makeReportPreview(0, 0, 1188, 550, "case_fixasetmodel");
  89. }
  90. function fDefaultSetting(prow)
  91. {
  92. model.setValue(grd_fixasetlist.nodeset +"[" + prow+ "]/instcd" ,model.getValue(cmb_instcd_search.attribute("ref")));
  93. model.setValue("/root/main/fixasetdet/fixasettmplist/instcd", model.getValue(cmb_instcd_search.attribute("ref"))); // 기관 설정
  94. model.setValue("/root/main/fixasetdet/fixasettmplist/goodqty", "1"); // 수량
  95. }
  96. function fDisableSetting() {
  97. var disValue = "";
  98. if(btn_fixasetlistcase.selected == true) {
  99. disValue = false;
  100. } else {
  101. disValue = true;
  102. }
  103. btn_excel.disabled = disValue;
  104. btn_print.disabled = disValue;
  105. model.refresh();
  106. }
  107. function fSubmitOnScroll() {
  108. if(grd_fixasetlist.vscroll.attribute("max") == grd_fixasetlist.vscroll.attribute("pos")) {
  109. // end of scroll
  110. model.makeValue("/root/send/fixasetlist/offset",grd_fixasetlist.rows-grd_fixasetlist.fixedRows); // grid의 header row는 제외
  111. submit("TRRFC00917");
  112. grd_fixasetlist.dispatch("onmouseup");
  113. }
  114. }
  115. ]]>
  116. </script>
  117. </xhtml:head>
  118. <xhtml:body pagewidth="1200" pageheight="800" guideline="1,-2;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  119. <group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
  120. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:186px; height:15px; ">년도별 자산현황</caption>
  121. </group>
  122. <group id="group4" scroll="auto" style="left:0px; top:36px; width:1195px; height:738px; ">
  123. <group id="group5" style="left:0px; top:5px; width:1193px; height:70px; vertical-align:top; ">
  124. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1190px; height:65px; background-color:#fffbf2; border-color:#ffd799; "/>
  125. <input id="ipt_mngtdeptcd_search" ref="/root/send/fixasetlist/mngtdeptcd_search" class="input_search" navindex="3" style="left:95px; top:33px; width:85px; height:19px; ">
  126. <script type="javascript" ev:event="xforms-value-changed">
  127. <![CDATA[
  128. misfSearchDept(ipt_mngtdeptnm_search);
  129. ]]>
  130. </script>
  131. </input>
  132. <button id="btn_mngtdeptcd_search" class="icon_search" navindex="-1" style="left:184px; top:34px; width:16px; height:16px; ">
  133. <caption/>
  134. <script type="javascript" ev:event="DOMActivate">
  135. <![CDATA[
  136. misfOpenPopUpList("02", ipt_mngtdeptcd_search,"","mngtdeptcd_search,mngtdeptnm_search");
  137. model.refresh();
  138. ]]>
  139. </script>
  140. </button>
  141. <input id="ipt_mngtdeptnm_search" ref="/root/send/fixasetlist/mngtdeptnm_search" class="input_search" navindex="4" appearance="input" style="left:203px; top:33px; width:197px; height:19px; ">
  142. <script type="javascript" ev:event="onkeyup">
  143. <![CDATA[
  144. inputEnterKey("btn_search", "DOMActivate");
  145. ]]>
  146. </script>
  147. </input>
  148. <caption id="cap_possndd_search" class="search_name" visibility="visible" style="left:507px; top:6px; width:94px; height:17px; ">취득일자 :</caption>
  149. <input id="ipt_possnfrdd_search" ref="/root/send/fixasetlist/possnfrdd_search" class="input_default" navindex="15" visibility="visible" inputtype="date" format="yyyy-mm-dd" style="left:597px; top:4px; width:90px; height:19px; text-align:center; "/>
  150. <button id="btn_search" class="btn1_letter2" navindex="20" style="left:1120px; top:26px; width:56px; height:22px; ">
  151. <caption>조회</caption>
  152. <script type="javascript" ev:event="DOMActivate">
  153. <![CDATA[
  154. var mngtdeptcd= model.getValue("/root/send/fixasetlist/mngtdeptcd_search");
  155. var deptflag = model.getValue("/root/send/fixasetlist/deptflag_search");
  156. if (mngtdeptcd == ""){
  157. model.setValue("/root/send/fixasetlist/mngtdeptcd_search",'%%');
  158. }
  159. if(deptflag == ""){
  160. model.setValue("/root/send/fixasetlist/deptflag_search",'%%');
  161. }
  162. misfGridInit(grd_fixasetlist);
  163. submit("TXRFC00919");
  164. submit("TRRFC00919"); //리스트 조회
  165. grd_fixasetlist.subtotalPosition = "below";
  166. grd_fixasetlist.subtotal("clear", -1, i, "format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#99ccff; font-weight:bold; text-align:center", 1, "총계" );
  167. for(var i=0; i < grd_fixasetlist.cols; i++){
  168. if(i >= grd_fixasetlist.colRef("com1_qty")){
  169. grd_fixasetlist.subtotal("sum", -1, i, "format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#99ccff; font-weight:bold; text-align:center", 1, "총계" );
  170. }
  171. }
  172. grd_fixasetlist.refresh();
  173. //
  174. if(grd_fixasetlist.rows - grd_fixasetlist.fixedRows > 0) {
  175. grd_fixasetlist.row = 1;
  176. grd_fixasetlist.dispatch("onrowchanged");
  177. }else{
  178. model.removenode("/root/main/fixasetdet/fixasettmplist");
  179. }
  180. ]]>
  181. </script>
  182. </button>
  183. <caption id="cap_instcd_search" class="search_name" style="left:3px; top:6px; width:117px; height:17px; ">기관코드 :</caption>
  184. <select1 id="cmb_instcd_search" ref="/root/send/fixasetlist/instcd_search" class="combo_s_essential" disabled="true" navindex="1" appearance="minimal" style="left:95px; top:4px; width:195px; height:19px; ">
  185. <choices>
  186. <itemset>
  187. <label/>
  188. <value/>
  189. </itemset>
  190. </choices>
  191. </select1>
  192. <line id="line12" class="line_4" style="x1:1105px; y1:13px; x2:1105px; y2:59px; border-color:#ffd799; "/>
  193. <input id="ipt_possntodd_search" ref="/root/send/fixasetlist/possntodd_search" class="input_default" navindex="16" visibility="visible" inputtype="date" format="yyyy-mm-dd" style="left:704px; top:4px; width:90px; height:19px; text-align:center; "/>
  194. <caption id="caption2" visibility="visible" style="left:689px; top:5px; width:15px; height:20px; font-weight:bold; ">~</caption>
  195. <caption id="cap_installplcecd" class="search_name" style="left:3px; top:32px; width:92px; height:17px; ">운용부서 :</caption>
  196. <select1 id="cmb_deptflag_search" ref="/root/send/fixasetlist/deptflag_search" navindex="19" visibility="visible" appearance="minimal" style="left:937px; top:4px; width:80px; height:19px; ">
  197. <choices>
  198. <itemset>
  199. <label/>
  200. <value/>
  201. </itemset>
  202. </choices>
  203. </select1>
  204. <caption id="caption1" class="search_name" style="left:847px; top:6px; width:116px; height:17px; ">부서구분 :</caption>
  205. </group>
  206. <button id="btn_excel" class="btn5_letter5" navindex="21" style="left:1114px; top:74px; width:75px; height:19px; ">
  207. <caption>Excel 저장</caption>
  208. <script type="javascript" ev:event="DOMActivate">
  209. <![CDATA[
  210. if( grd_fixasetlist.rows - grd_fixasetlist.fixedRows > 0 ) {
  211. var fileName = "년도별 자산현황_" + getCurrentDate();
  212. var fileName = window.fileDialog("save", ",", false, fileName, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  213. grd_fixasetlist.saveExcel(fileName, "Sheet");
  214. } else {
  215. messageBox("저장 데이터가","I004");
  216. }
  217. ]]>
  218. </script>
  219. </button>
  220. <line id="line16" class="line_1" style="x1:0px; y1:158px; x2:1190px; y2:157px; "/>
  221. <switch id="switch1" style="left:0px; top:95px; width:1190px; height:630px; ">
  222. <case id="case_fixasetlist">
  223. <datagrid id="grd_fixasetlist" nodeset="/root/main/list/fixaset/fixasetlist" class="datagrid2" caption="년도/분류^컴퓨터^컴퓨터^컴퓨터^컴퓨터^컴퓨터^컴퓨터^모니터^모니터^모니터^모니터^모니터^프린터^프린터^프린터^프린터^프린터|년도/분류^정리^정리^정리^미비^노트북^계^정리^정리^정리^미비^계^정리^정리^정리^미비^계|년도/분류^10.01(정상)^10.05(기금)^10.91(CDIS)^03.11^노트북^계^10.02(정상)^10.05(기금)^10.91(CDIS)^03.26^계^10.03(정상)^10.05(기금)^10.91(CDIS)^03.09^계" colsep="^" colwidth="70,70, 70, 75, 60, 45, 60, 70, 70, 75, 60, 60, 70, 70, 75, 60, 60" ellipsis="true" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" selectionmode="byrow" navindex="22" style="left:0px; top:0px; width:1152px; height:625px; ">
  224. <col ref="year" style="height:35; text-align:center; "/>
  225. <col ref="com1_qty" style="text-align:center; "/>
  226. <col ref="com2_qty" style="text-align:center; "/>
  227. <col ref="com3_qty" style="text-align:center; "/>
  228. <col ref="com4_qty" style="text-align:center; "/>
  229. <col ref="com5_qty" style="text-align:center; "/>
  230. <col ref="comt_qty" format="#,###" style="text-align:center; "/>
  231. <col ref="mon1_qty" style="text-align:center; "/>
  232. <col ref="mon2_qty" style="text-align:center; "/>
  233. <col ref="mon3_qty" style="text-align:center; "/>
  234. <col ref="mon4_qty" style="text-align:center; "/>
  235. <col ref="mont_qty" format="#,###" style="text-align:center; "/>
  236. <col ref="prt1_qty" style="text-align:center; "/>
  237. <col ref="prt2_qty" style="text-align:center; "/>
  238. <col ref="prt3_qty" style="text-align:center; "/>
  239. <col ref="prt4_qty" style="text-align:center; "/>
  240. <col ref="prtt_qty" format="#,###" style="text-align:center; "/>
  241. <script type="javascript" ev:event="onaftersort">
  242. <![CDATA[
  243. grd_fixasetlist.gridToInstance();
  244. ]]>
  245. </script>
  246. <script type="javascript" ev:event="onentercell">
  247. <![CDATA[
  248. for ( i=0; i<grd_fixasetlist.selectedRows; i++ ) {
  249. var col = grd_fixasetlist.col;
  250. // var row = grd_fixasetlist.row;
  251. if(col == 2){ // 컴퓨터 정리 정상
  252. model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
  253. model.setValue("/root/send/fixasetlist/smlcd_search", "01");
  254. model.setValue("/root/send/fixasetlist/gubun_search", "컴퓨터");
  255. }else if(col == 3){
  256. model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
  257. model.setValue("/root/send/fixasetlist/smlcd_search", "05");
  258. model.setValue("/root/send/fixasetlist/gubun_search", "컴퓨터");
  259. }else if(col == 4){
  260. model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
  261. model.setValue("/root/send/fixasetlist/smlcd_search", "91");
  262. model.setValue("/root/send/fixasetlist/gubun_search", "컴퓨터");
  263. }else if(col == 5){
  264. model.setValue("/root/send/fixasetlist/mdlcd_search", "03");
  265. model.setValue("/root/send/fixasetlist/smlcd_search", "11");
  266. model.setValue("/root/send/fixasetlist/gubun_search", "컴퓨터");
  267. }else if(col == 6){
  268. model.setValue("/root/send/fixasetlist/mdlcd_search", "03");
  269. model.setValue("/root/send/fixasetlist/smlcd_search", "37");
  270. model.setValue("/root/send/fixasetlist/gubun_search", "노트북");
  271. }else if(col == 7){
  272. model.setValue("/root/send/fixasetlist/mdlcd_search", "");
  273. model.setValue("/root/send/fixasetlist/smlcd_search", "");
  274. }else if(col == 8){
  275. model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
  276. model.setValue("/root/send/fixasetlist/smlcd_search", "02");
  277. model.setValue("/root/send/fixasetlist/gubun_search", "모니터");
  278. }else if(col == 9){
  279. model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
  280. model.setValue("/root/send/fixasetlist/smlcd_search", "05");
  281. model.setValue("/root/send/fixasetlist/gubun_search", "모니터");
  282. }else if(col == 10){
  283. model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
  284. model.setValue("/root/send/fixasetlist/smlcd_search", "91");
  285. model.setValue("/root/send/fixasetlist/gubun_search", "모니터");
  286. }else if(col == 11){
  287. model.setValue("/root/send/fixasetlist/mdlcd_search", "03");
  288. model.setValue("/root/send/fixasetlist/smlcd_search", "26");
  289. model.setValue("/root/send/fixasetlist/gubun_search", "모니터");
  290. }else if(col == 12){
  291. model.setValue("/root/send/fixasetlist/mdlcd_search", "");
  292. model.setValue("/root/send/fixasetlist/smlcd_search", "");
  293. }else if(col == 13){
  294. model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
  295. model.setValue("/root/send/fixasetlist/smlcd_search", "03");
  296. model.setValue("/root/send/fixasetlist/gubun_search", "프린터");
  297. }else if(col == 14){
  298. model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
  299. model.setValue("/root/send/fixasetlist/smlcd_search", "05");
  300. model.setValue("/root/send/fixasetlist/gubun_search", "프린터");
  301. }else if(col == 15){
  302. model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
  303. model.setValue("/root/send/fixasetlist/smlcd_search", "91");
  304. model.setValue("/root/send/fixasetlist/gubun_search", "프린터");
  305. }else if(col == 16){
  306. model.setValue("/root/send/fixasetlist/mdlcd_search", "03");
  307. model.setValue("/root/send/fixasetlist/smlcd_search", "09");
  308. model.setValue("/root/send/fixasetlist/gubun_search", "프린터");
  309. }
  310. // var mdlcd = model.getValue("/root/temp/fixcdinfo/mdlcd");
  311. // var smlcd = model.getValue("/root/temp/fixcdinfo/smlcd");
  312. var tt = parseInt(grd_fixasetlist.selectedRow(i))-2;
  313. var yeardd = model.getValue("/root/main/list/fixaset/fixasetlist["+ tt +"]/year");
  314. }
  315. model.setValue("/root/send/fixasetlist/possndd_search" , yeardd);
  316. // model.setValue("/root/temp/fixcdinfo/mngtdeptcd" , model.getValue("/root/send/fixasetlist/mngtdeptcd_search"));
  317. // model.setValue("/root/temp/fixcdinfo/deptflag" , model.getValue("/root/send/fixasetlist/deptflag_search"));
  318. window.load("SPRSD00919.xrw", "modal","", "", "/root/send/fixasetlist","/root/send/fixasetlist");
  319. //modal("SPRSD00919", 1, 0, 0 ,"SPRSD00919","/root/temp/fixcdinfo","/root/temp/fixcdinfo");
  320. ]]>
  321. </script>
  322. </datagrid>
  323. </case>
  324. <case id="case_fixasetmodel"/>
  325. </switch>
  326. </group>
  327. <group id="group1" style="left:0px; top:12; width:1195; height:27px; ">
  328. <button id="btn_init" class="btn4_letter3" navindex="24" style="left:1120px; top:4px; width:68px; height:22px; ">
  329. <caption>초기화</caption>
  330. <script type="javascript" ev:event="DOMActivate">
  331. <![CDATA[
  332. model.resetInstanceNode("/root/send");
  333. fInitialize();
  334. ]]>
  335. </script>
  336. </button>
  337. <line id="line14" class="line_6" style="x1:0; y1:25; x2:1194; y2:25; "/>
  338. </group>
  339. </xhtml:body>
  340. </xhtml:html>