SMRFE00300_자산기간별변동사항조회.xrw 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/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:my="http://www.comsquare.co.kr/example" xmlns:ms="urn:schemas-microsoft-com:xslt" 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. <chgnhistinfo>
  12. <chgnhistlist/>
  13. </chgnhistinfo>
  14. <asetmoveinfo>
  15. <asetmovelist/>
  16. </asetmoveinfo>
  17. </list>
  18. </main>
  19. <send>
  20. <search>
  21. <instcd/>
  22. <goodflag/>
  23. <updtdd1/>
  24. <updtdd2/>
  25. <updtflag/>
  26. <deptcd/>
  27. <deptnm/>
  28. <installplcecd/>
  29. <installplcenm/>
  30. <fixasetcd/>
  31. <fixasetnm/>
  32. </search>
  33. <prntsearch>
  34. <instcd/>
  35. <goodflag/>
  36. <fixasetcd/>
  37. <goodflaghngnm/>
  38. </prntsearch>
  39. </send>
  40. <init>
  41. <possnflagcd>
  42. <label>내자</label>
  43. <value>H</value>
  44. <label>외자</label>
  45. <value>F</value>
  46. </possnflagcd>
  47. <goodflag>
  48. <label>- 전 체 -</label>
  49. <value/>
  50. <label>일반비품</label>
  51. <value>GE</value>
  52. <label>의료장비</label>
  53. <value>EQ</value>
  54. </goodflag>
  55. </init>
  56. <temp/>
  57. </root>
  58. </instance>
  59. <submission id="TRRFE00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/main/list/chgnhistinfo/chgnhistlist"/>
  60. <submission id="TRRFE00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/prntsearch" resultref="/root/main/list/asetmoveinfo/asetmovelist"/>
  61. </model>
  62. <script type="javascript" ev:event="xforms-ready">
  63. <![CDATA[
  64. //화면 Control을 초기화한다
  65. fInitialize();
  66. ]]>
  67. </script>
  68. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  69. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  70. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  71. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  72. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  73. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  74. <script type="javascript">
  75. <![CDATA[
  76. function fInitialize()
  77. {
  78. misfGridInit(grd_rfchcgmtlist);
  79. rszfGoodFlagListByPgmGubn(cmb_goodflag,"2","Y");
  80. misfComboComCdListMulti("C0048,R0044,R0044,R0047",
  81. "cmb_instcd,cmb_updtflag,grd_rfchcgmtlist.updtflag,grd_rfchcgmtlist.curncyunit");
  82. addComboItem( "cmb_updtflag", "- 전 체 -", "", "above");
  83. cmb_goodflag.select(0);
  84. misfComboCopyItemSet(cmb_goodflag,"",grd_rfchcgmtlist,"goodflag");
  85. grd_rfchcgmtlist.fixedcellcheckbox(0,grd_rfchcgmtlist.colRef("choice"),false) = true;
  86. grd_rfchcgmtlist.refresh();
  87. // 현재 날짜 기본 입력(3개월 간격 설정)
  88. var reqdate = getCurrentDate().toDate("YYYYMMDD");
  89. model.setValue(ipt_updtdd1.attribute("ref"), reqdate.getAddDate(-3, "M").getDateFormat("YYYYMMDD") );
  90. model.setValue(ipt_updtdd2.attribute("ref"), getCurrentDate());
  91. model.setValue(cmb_instcd.attribute("ref"), getUserInfo("dutplceinstcd")); // 기관 설정
  92. //misfMsterDetailSet(grd_rfchcgmtlist, null, "TRRFE00201", "N");
  93. model.refresh();
  94. model.setFocus("ipt_fixasetcd");
  95. }
  96. ]]>
  97. </script>
  98. </xhtml:head>
  99. <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  100. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  101. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:230px; height:14px; ">자산기간별 변동사항 조회</caption>
  102. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  103. </group>
  104. <group id="group3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
  105. <line id="line1" class="line_1" style="x1:0px; y1:116px; x2:1194; y2:116px; "/>
  106. <group id="group4" style="left:0px; top:10px; width:1194px; height:81px; vertical-align:top; ">
  107. <shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1194; height:81 px; background-color:#fffbf2; border-color:#ffd799; "/>
  108. <caption id="cap_goodflag" class="search_name" style="left:309px; top:9px; width:86px; height:17px; ">자산구분 :</caption>
  109. <button id="btn_search" class="btn1_letter2" navindex="12" style="left:1123; top:30; width:56px; height:22px; text-align:left; ">
  110. <caption>조회</caption>
  111. <script type="javascript" ev:event="DOMActivate">
  112. <![CDATA[
  113. if(!isRequiredControls("cmb_instcd")) return;
  114. //if(!isRequiredControls("cmb_goodflag")) return;
  115. if(!isRequiredControls("ipt_updtdd1")) return;
  116. if(!isRequiredControls("ipt_updtdd2")) return;
  117. submit("TRRFE00201");
  118. grd_rfchcgmtlist.fixedcellischeck(0,grd_rfchcgmtlist.colRef("choice")) = false;
  119. ]]>
  120. </script>
  121. </button>
  122. <caption id="cap_fixasetcd" class="search_name" style="left:15px; top:57px; width:89px; height:17px; ">자산코드 :</caption>
  123. <line id="line3" class="line_4" style="top:54; x1:1107; y1:8; x2:1107; y2:75; "/>
  124. <select1 id="cmb_goodflag" ref="/root/send/search/goodflag" class="combo_s_essential" navindex="2" appearance="minimal" style="left:399px; top:8px; width:171px; height:19px; text-align:center; ">
  125. <choices>
  126. <itemset nodeset="/root/init/goodflag">
  127. <label ref="label"/>
  128. <value ref="value"/>
  129. </itemset>
  130. </choices>
  131. <script type="javascript" ev:event="xforms-value-changed">
  132. <![CDATA[
  133. ipt_fixasetcd.value = "";
  134. ipt_fixasetnm.value = "";
  135. ]]>
  136. </script>
  137. </select1>
  138. <caption id="cap_updtflag" class="search_name" style="left:15px; top:33px; width:86px; height:17px; ">변동구분 :</caption>
  139. <caption id="cap_updtdd1" class="search_name" style="left:703px; top:9px; width:86px; height:17px; ">변동일자 :</caption>
  140. <caption id="cap_installplcecd" class="search_name" style="left:703px; top:33px; width:88px; height:17px; ">설치장소 :</caption>
  141. <caption id="cap_deptcd" class="search_name" style="left:309px; top:33px; width:89px; height:17px; ">사용부서 :</caption>
  142. <input id="ipt_installplcenm" ref="/root/send/search/installplcenm" class="output_fix" navindex="-1" editable="false" style="left:923px; top:32px; width:168px; height:19px; "/>
  143. <input id="ipt_installplcecd" ref="/root/send/search/installplcecd" class="input_search" navindex="8" style="left:793px; top:32px; width:106px; height:19px; ">
  144. <script type="javascript" ev:event="xforms-value-changed">
  145. <![CDATA[
  146. if(ipt_installplcecd.value == ""){
  147. ipt_installplcenm.value = "";
  148. }else {
  149. misfValidationCheck("02", "", "installplcecd,installplcenm");
  150. }
  151. ipt_installplcecd.refresh();
  152. ipt_installplcenm.refresh();
  153. ]]>
  154. </script>
  155. </input>
  156. <input id="ipt_fixasetnm" ref="/root/send/search/fixasetnm" class="input_search" navindex="11" style="left:399px; top:56px; width:277px; height:19px; ">
  157. <script type="javascript" ev:event="onkeyup">
  158. <![CDATA[
  159. inputEnterKey("btn_search", "DOMActivate");
  160. ]]>
  161. </script>
  162. </input>
  163. <input id="ipt_fixasetcd" ref="/root/send/search/fixasetcd" class="input_search" navindex="10" imemode="disabled" _chartype="upper" style="left:104px; top:56px; width:171px; height:19px; ">
  164. <script type="javascript" ev:event="onkeyup">
  165. <![CDATA[
  166. inputEnterKey("btn_search", "DOMActivate");
  167. ]]>
  168. </script>
  169. </input>
  170. <select1 id="cmb_updtflag" ref="/root/send/search/updtflag" class="combo_search" navindex="5" appearance="minimal" style="left:104px; top:32px; width:171px; height:19px; text-align:center; ">
  171. <choices>
  172. <itemset>
  173. <label/>
  174. <value/>
  175. </itemset>
  176. </choices>
  177. </select1>
  178. <input id="ipt_deptnm" ref="/root/send/search/deptnm" class="output_fix" navindex="-1" editable="false" style="left:528px; top:32px; width:147px; height:19px; "/>
  179. <input id="ipt_deptcd" ref="/root/send/search/deptcd" class="input_search" navindex="6" style="left:399px; top:32px; width:106px; height:19px; ">
  180. <script type="javascript" ev:event="xforms-value-changed">
  181. <![CDATA[
  182. misfSearchDept(ipt_deptnm);
  183. ]]>
  184. </script>
  185. </input>
  186. <input id="ipt_updtdd1" ref="/root/send/search/updtdd1" class="input_s_essential" navindex="3" inputtype="date" style="left:794px; top:8px; width:100px; height:19px; text-align:center; "/>
  187. <input id="ipt_updtdd2" ref="/root/send/search/updtdd2" class="input_s_essential" navindex="4" inputtype="date" style="left:916px; top:8px; width:100px; height:19px; text-align:center; "/>
  188. <caption id="caption16" style="left:899px; top:9px; width:17px; height:20px; vertical-align:middle; ">~</caption>
  189. <caption id="cap_instcd" class="search_name" style="left:15px; top:9px; width:86px; height:17px; ">기관코드 :</caption>
  190. <select1 id="cmb_instcd" ref="/root/send/search/instcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:104px; top:8px; width:171px; height:19px; text-align:center; ">
  191. <choices>
  192. <itemset>
  193. <label/>
  194. <value/>
  195. </itemset>
  196. </choices>
  197. </select1>
  198. <button id="btn_deptcd" class="icon_search" navindex="7" style="left:509px; top:34px; width:16px; height:16px; ">
  199. <caption/>
  200. <script type="javascript" ev:event="DOMActivate">
  201. <![CDATA[
  202. misfOpenPopUpList("02", ipt_deptcd,"","deptcd,deptnm");
  203. model.refresh();
  204. ]]>
  205. </script>
  206. </button>
  207. <button id="btn_installplcecd" class="icon_search" navindex="9" style="left:903px; top:33px; width:16px; height:16px; ">
  208. <caption/>
  209. <script type="javascript" ev:event="DOMActivate">
  210. <![CDATA[
  211. misfOpenPopUpList("02", ipt_installplcecd,"","installplcecd,installplcenm");
  212. model.refresh();
  213. ]]>
  214. </script>
  215. </button>
  216. <caption id="caption2" class="search_name" style="left:310px; top:55px; width:89px; height:17px; ">자 산 명 :</caption>
  217. </group>
  218. <caption id="caption21" class="tit_2" style="left:5px; top:101px; width:131px; height:14px; ">변동사항이력List</caption>
  219. <button id="btn_excel" class="btn2_letter4" navindex="15" style="left:1128px; top:96px; width:64px; height:19px; ">
  220. <caption>엑셀저장</caption>
  221. <script type="javascript" ev:event="DOMActivate">
  222. <![CDATA[
  223. var fileName = window.fileDialog ("save", ",", false, "자산변동사항이력List", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  224. if (fileName != "")
  225. {
  226. grd_rfchcgmtlist.saveExcel(fileName);
  227. }
  228. ]]>
  229. </script>
  230. </button>
  231. <datagrid id="grd_rfchcgmtlist" nodeset="/root/main/list/chgnhistinfo/chgnhistlist" caption="^변동구분^변동일자^자산구분^자산코드^명칭^명칭(영문)^규격^모델명^제조회사^제조국^취득일자^금액^외화액/단위^외화액/단위^거래처^도입구분^변동전 사용부서^사용부서^비고^적요^변경설치장소^기관코드" colsep="^" colwidth="24, 55, 69, 55, 95, 161, 100, 91, 80, 80, 45, 69, 62, 60, 40, 79, 56, 100, 100, 200, 138, 100, 100" ellipsis="true" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="23" rowsep="|" tooltip="true" navindex="13" style="left:0px; top:120px; width:1194px; height:604px; ">
  232. <col checkvalue="Y,N" ref="choice" type="checkbox"/>
  233. <col disabled="true" ref="updtflag" type="combo" _key="true" style="text-align:center; ">
  234. <choices>
  235. <itemset>
  236. <label/>
  237. <value/>
  238. </itemset>
  239. </choices>
  240. </col>
  241. <col ref="updtdd" format="yyyy-mm-dd" style="text-align:center; "/>
  242. <col disabled="true" ref="goodflag" type="combo" style="text-align:center; ">
  243. <choices>
  244. <itemset>
  245. <label/>
  246. <value/>
  247. </itemset>
  248. </choices>
  249. </col>
  250. <col ref="fixasetcd" style="text-align:center; "/>
  251. <col ref="goodflaghngnm" style="text-align:left; "/>
  252. <col ref="goodflagengnm" visibility="hidden" style="text-align:left; "/>
  253. <col ref="goodspec" style="text-align:left; "/>
  254. <col ref="goodmodel" style="text-align:left; "/>
  255. <col ref="prodcmpynm"/>
  256. <col ref="prodplcenm"/>
  257. <col ref="possndd" format="yyyy-mm-dd"/>
  258. <col ref="fixasetamt" format="#,###" maxlength="12" style="text-align:right; "/>
  259. <col format="#,###" maxlength="12" ef="forgncurncyamt" style="text-align:right; "/>
  260. <col disabled="true" ref="curncyunit" type="combo" maxlength="2" style="text-align:left; ">
  261. <choices>
  262. <itemset>
  263. <label/>
  264. <value/>
  265. </itemset>
  266. </choices>
  267. </col>
  268. <col ref="suplplcenm"/>
  269. <col ref="acqtflagnm" style="text-align:center; "/>
  270. <col ref="premngtdeptnm"/>
  271. <col disabled="true" ref="upddeptnm" type="input" _key="true" style="text-align:center; ">
  272. <choices>
  273. <itemset>
  274. <label/>
  275. <value/>
  276. </itemset>
  277. </choices>
  278. </col>
  279. <col ref="cmt" style="text-align:left; "/>
  280. <col ref="mainrec" visibility="hidden" style="text-align:center; "/>
  281. <col ref="installplcenm" visibility="hidden" style="left:639px; top:23px; width:130px; height:23px; text-align:center; "/>
  282. <col ref="instcd" visibility="hidden"/>
  283. </datagrid>
  284. <button id="btn_barcodeprt" class="btn2_letter4" navindex="14" style="left:1060px; top:95px; width:64px; height:19px; ">
  285. <caption>라벨출력</caption>
  286. <script type="javascript" ev:event="DOMActivate">
  287. <![CDATA[
  288. var goodnm, mngtdeptnm, installplcenm;
  289. var node = instance1.selectNodes("/root/main/list/chgnhistinfo/chgnhistlist[choice='Y']");
  290. if (node == null || node.length < 1){
  291. messageBox("선택 된 자산이","I004");
  292. return false;
  293. }
  294. model.removeNodeset(grd_cpfixasetlist.nodeset);
  295. grd_cpfixasetlist.refresh();
  296. for (var i=0; i<node.length; i++) {
  297. var selectItem = node.item(i);
  298. var goodflag = selectItem.selectSingleNode("goodflag").value.getTrim();
  299. // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= E) => (goodflag= EQ)
  300. if (goodflag == "EQ") {
  301. goodnm = selectItem.selectSingleNode("goodflagengnm").value.getTrim();
  302. } else {
  303. goodnm = selectItem.selectSingleNode("goodflaghngnm").value.getTrim();
  304. }
  305. mngtdeptnm = selectItem.selectSingleNode("upddeptnm").value.getTrim();
  306. installplcenm = selectItem.selectSingleNode("installplcenm").value.getTrim();
  307. grd_cpfixasetlist.addRow(false);
  308. grd_cpfixasetlist.valueMatrix(grd_cpfixasetlist.row, grd_cpfixasetlist.colRef("fixasetcd" )) = selectItem.selectSingleNode("fixasetcd").value;
  309. grd_cpfixasetlist.valueMatrix(grd_cpfixasetlist.row, grd_cpfixasetlist.colRef("possndd" )) = selectItem.selectSingleNode("possndd").value;
  310. grd_cpfixasetlist.valueMatrix(grd_cpfixasetlist.row, grd_cpfixasetlist.colRef("goodnm1" )) = goodnm;
  311. grd_cpfixasetlist.valueMatrix(grd_cpfixasetlist.row, grd_cpfixasetlist.colRef("goodspec" )) = selectItem.selectSingleNode("goodspec").value;
  312. grd_cpfixasetlist.valueMatrix(grd_cpfixasetlist.row, grd_cpfixasetlist.colRef("deptnm1" )) = mngtdeptnm;
  313. grd_cpfixasetlist.valueMatrix(grd_cpfixasetlist.row, grd_cpfixasetlist.colRef("deptnm2" )) = installplcenm;
  314. grd_cpfixasetlist.valueMatrix(grd_cpfixasetlist.row, grd_cpfixasetlist.colRef("mngtno" )) = selectItem.selectSingleNode("mngtno").value;
  315. grd_cpfixasetlist.valueMatrix(grd_cpfixasetlist.row, grd_cpfixasetlist.colRef("suplplcenm" )) = selectItem.selectSingleNode("suplplcenm").value;
  316. }
  317. grd_cpfixasetlist.refresh();
  318. exeReportPreview("RPRFC00702","XMLSTR");
  319. ]]>
  320. </script>
  321. </button>
  322. <datagrid id="grd_cpfixasetlist" nodeset="/root/main/list/cpfixaset/cpfixasetlist" visibility="hidden" caption="기관코드^자산코드^품명^모델^규격^SERIAL NO^공급처^구입일자^사용부서^설치장소^물품명2" colsep="^" colwidth="53, 110, 230, 100, 160, 123, 159, 75, 130, 130, 100" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:490px; top:440px; width:679px; height:262px; ">
  323. <col ref="instcd" visibility="hidden"/>
  324. <col ref="fixasetcd" style="text-align:center; "/>
  325. <col ref="goodnm1" style="padding-left:5; "/>
  326. <col ref="goodmodel" visibility="hidden"/>
  327. <col ref="goodspec" style="padding-left:5; "/>
  328. <col ref="mngtno"/>
  329. <col ref="suplplcenm" style="padding-left:5; "/>
  330. <col ref="possndd" format="yyyy-mm-dd" style="text-align:center; "/>
  331. <col ref="deptnm1"/>
  332. <col ref="deptnm2"/>
  333. <col ref="goodnm2" visibility="hidden"/>
  334. </datagrid>
  335. </group>
  336. <group id="group2" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
  337. <line id="line7" class="line_6" style="x1:0px; y1:25; x2:1194px; y2:25; "/>
  338. <button id="btn_init" class="btn4_letter3" navindex="20" style="left:1126; top:3; width:68px; height:22px; ">
  339. <caption>초기화</caption>
  340. <script type="javascript" ev:event="DOMActivate">
  341. <![CDATA[
  342. fInitialize();
  343. ]]>
  344. </script>
  345. </button>
  346. <button id="btn_prnt" class="btn6_letter7" navindex="16" style="left:0px; top:5px; width:56px; height:22px; ">
  347. <caption>자산이동내역서</caption>
  348. <script type="javascript" ev:event="DOMActivate">
  349. <![CDATA[
  350. /*if (model.getValue(ipt_fixasetcd_prnt.attribute("ref")).getTrim() == ""){
  351. messageBox("자산코드가 입력되지 ", "E007");
  352. return;
  353. }*/
  354. var fixasetcd = grd_rfchcgmtlist.valueMatrix(grd_rfchcgmtlist.row, grd_rfchcgmtlist.colRef("fixasetcd"));
  355. var instcd = grd_rfchcgmtlist.valueMatrix(grd_rfchcgmtlist.row, grd_rfchcgmtlist.colRef("instcd"));
  356. if(fixasetcd == null || fixasetcd.length < 1) {
  357. messageBox("자산이 선택 되지 ", "E007");
  358. return;
  359. }
  360. model.setValue("/root/send/prntsearch/instcd" , instcd);
  361. model.setValue("/root/send/prntsearch/fixasetcd" , fixasetcd);
  362. if(submit("TRRFE00301")) {
  363. exeReportPreview("RPRFE00301","XMLSTR");
  364. }
  365. ]]>
  366. </script>
  367. </button>
  368. <input id="ipt_fixasetcd_prnt" ref="/root/send/prntsearch/fixasetcd" class="input_search" navindex="17" visibility="hidden" style="left:214px; top:6px; width:96px; height:19px; text-align:center; "/>
  369. <caption id="caption1" class="tit_2" visibility="hidden" style="left:125px; top:7px; width:89px; height:17px; ">자산코드 :</caption>
  370. </group>
  371. </xhtml:body>
  372. </xhtml:html>