SMRFC00404_재물조사실사관리.xrw 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340
  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: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. <grid>
  11. <degolist/>
  12. </grid>
  13. </main>
  14. <send>
  15. <instcd/>
  16. <yyyy/>
  17. <mngtdeptcd_search/>
  18. <mngtdeptnm_search/>
  19. <dfromdd/>
  20. <dtodd/>
  21. <basedd/>
  22. <useyn/>
  23. <deptaprvnm/>
  24. <senddd/>
  25. <passnmin/>
  26. <passnmax/>
  27. </send>
  28. <init>
  29. </init>
  30. <hidden/>
  31. <temp>
  32. <userinfo/>
  33. </temp>
  34. <popacnt>
  35. <instcd/>
  36. <yyyy/>
  37. <selectyn/>
  38. </popacnt>
  39. <popacntlist>
  40. <acntlist/>
  41. </popacntlist>
  42. </root>
  43. </instance>
  44. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  45. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  46. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  47. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  48. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  49. <script type="javascript" ev:event="xforms-ready">
  50. <![CDATA[
  51. fInitialize();
  52. ]]>
  53. </script>
  54. <submission id="TRRFC00403" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/grid/degolist"/>
  55. <submission id="TRRFC00404" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp/userinfo"/>
  56. <submission id="TXRFC00405" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/grid/degolist" resultref="/root/temp"/>
  57. <submission id="TXRFC00406" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
  58. <submission id="TXRFC00408" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
  59. </model>
  60. <script type="javascript">
  61. <![CDATA[
  62. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  63. function fInitialize() {
  64. misfGridInit(grd_degolist);
  65. misfComboComCdList("C0048",cmb_instcd,"Y"); //기관코드
  66. model.setValue(cmb_instcd.attribute("ref"), getUserInfo("dutplceinstcd")); // 기관 설정
  67. model.setValue(ipt_yyyy.attribute("ref"),getCurrentDate().substring(0, 4));
  68. misfMsterDetailSet(grd_degolist, null, "TRRFC00403","Y"); //마스터 설정
  69. model.setValue(ipt_mngtdeptcd_search.attribute("ref") , getUserInfo("dutplcecd"));
  70. model.setValue(ipt_mngtdeptnm_search.attribute("ref") , getUserInfo("dutplcenm"));
  71. if(getUserInfo("dutplceinstcd") == "031"){
  72. cap_dept031.visible = true;
  73. cap_dept032.visible = false;
  74. }else{
  75. cap_dept031.visible = false;
  76. cap_dept032.visible = true;
  77. }
  78. var dutplcecd = getUserInfo("dutplcecd");
  79. if(dutplcecd == "4020334000" || getUserInfo("userid") == "MIS" || getUserInfo("userid") == "99207" ){
  80. btn_search.dispatch("DOMActivate");
  81. }else{
  82. messageBox("물류팀외 조회할 수","I004");
  83. btn_search.disabled = true;
  84. btn_save.disabled = true;
  85. btn_proc.disabled = true;
  86. ipt_yyyy.disabled = true;
  87. btn_mngtdeptcd_search.disabled = true;
  88. ipt_mngtdeptcd_search.disabled = true;
  89. }
  90. model.refresh();
  91. }
  92. ]]>
  93. </script>
  94. </xhtml:head>
  95. <xhtml:body pagewidth="1200" pageheight="800" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  96. <group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
  97. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:186px; height:15px; ">재물조사 실사 관리</caption>
  98. </group>
  99. <group id="grp_biz" scroll="auto" style="left:0px; top:38px; width:1195px; height:722px; ">
  100. <group id="grp_sea" style="left:0px; top:10px; width:1185px; height:35px; vertical-align:top; ">
  101. <shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1185px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
  102. <line id="line13" class="line_4" style="x1:1110px; y1:5px; x2:1110px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
  103. </group>
  104. </group>
  105. <group id="group2" style="left:0px; top:12px; width:1195px; height:27px; ">
  106. <line id="line16" class="line_2" style="x1:0px; y1:25px; x2:1185px; y2:25px; "/>
  107. <button id="btn_clear" class="btn4_letter3" navindex="13" visibility="hidden" style="left:555px; top:0px; width:68px; height:22px; ">
  108. <caption>초기화</caption>
  109. <script type="javascript" ev:event="DOMActivate">
  110. <![CDATA[
  111. fInitialize();
  112. ]]>
  113. </script>
  114. </button>
  115. <button id="btn_save" class="btn4_letter2" navindex="12" style="left:1130px; top:3px; width:56px; height:22px; ">
  116. <caption>저장</caption>
  117. <script type="javascript" ev:event="DOMActivate">
  118. <![CDATA[
  119. var updtdata = getGridUpdateData(grd_degolist);
  120. if (updtdata == "") {
  121. messageBox("변경된 데이터가","I004");
  122. return;
  123. }
  124. misfSave("TXRFC00405");
  125. btn_search.dispatch("DOMActivate");
  126. messageBox("저장", "I002");
  127. ]]>
  128. </script>
  129. </button>
  130. <button id="btn_proc" class="btn1_letter4" navindex="12" visibility="visible" style="left:1048px; top:3px; width:80px; height:22px; ">
  131. <caption>일괄처리</caption>
  132. <script type="javascript" ev:event="DOMActivate">
  133. <![CDATA[
  134. var deptcd = model.getValue("/root/send/mngtdeptcd_search");
  135. if(deptcd == ""){
  136. messageBox("부서코드가", "I004");
  137. return;
  138. }else{
  139. if ( messageBox("일괄 실사결과입력을", "Q004") == 6 ) {
  140. if(misfSave("TXRFC00408")){
  141. btn_search.dispatch("DOMActivate");
  142. messageBox("저장", "I002");
  143. }
  144. model.refresh();
  145. }
  146. }
  147. ]]>
  148. </script>
  149. </button>
  150. </group>
  151. <group id="group1" scroll="auto" style="left:0px; top:38px; width:1195px; height:722px; ">
  152. <group id="group3" style="left:0px; top:10px; width:1185px; height:35px; vertical-align:top; ">
  153. <shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1185px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
  154. <caption id="cap_instcd" class="search_name" style="left:15px; top:9px; width:86px; height:17px; ">기관코드 :</caption>
  155. <line id="line1" class="line_4" style="x1:1110px; y1:5px; x2:1110px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
  156. <button id="btn_search" class="btn1_letter2" navindex="6" style="left:1125px; top:6px; width:56px; height:22px; ">
  157. <caption>조회</caption>
  158. <script type="javascript" ev:event="DOMActivate">
  159. <![CDATA[
  160. submit("TRRFC00403");
  161. var yyyy = model.getValue("/root/main/grid/degolist[1]/yyyy");
  162. var basedd = model.getValue("/root/main/grid/degolist[1]/basedd");
  163. var tbasedd = yyyy + "-" + basedd.substr(0,2) + "-" + basedd.substr(2,2);
  164. var dfromdd = model.getValue("/root/main/grid/degolist[1]/dfromdd"); //부서확인기간(fromdd)
  165. var dtodd = model.getValue("/root/main/grid/degolist[1]/dtodd"); //부서확인기간(todd)
  166. var useyn = model.getValue("/root/main/grid/degolist[1]/useyn"); //사용여부
  167. var passnmin = model.getValue("/root/main/grid/degolist[1]/passnmin"); //기준금액(min)
  168. var passnmax = model.getValue("/root/main/grid/degolist[1]/passnmax"); //기준금액(max)
  169. var deptaprvnm = model.getValue("/root/main/grid/degolist[1]/deptaprvnm"); //부서장 승인자명
  170. var senddd = model.getValue("/root/main/grid/degolist[1]/senddd"); //최종제출일자
  171. var dd = getCurrentDate();
  172. model.setValue("/root/send/basedd",tbasedd);
  173. model.setValue("/root/send/dfromdd",dfromdd);
  174. model.setValue("/root/send/dtodd",dtodd);
  175. model.setValue("/root/send/useyn",useyn);
  176. model.setValue("/root/send/deptaprvnm",deptaprvnm);
  177. model.setValue("/root/send/senddd",senddd);
  178. model.setValue("/root/send/passnmin",passnmin);
  179. model.setValue("/root/send/passnmax",passnmax);
  180. model.refresh();
  181. ]]>
  182. </script>
  183. </button>
  184. <select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_s_essential" disabled="true" navindex="1" appearance="minimal" style="left:108px; top:8px; width:177px; height:19px; text-align:center; ">
  185. <choices>
  186. <itemset>
  187. <label/>
  188. <value/>
  189. </itemset>
  190. </choices>
  191. <script type="javascript" ev:event="xforms-value-changed">
  192. <![CDATA[
  193. btn_search.dispatch("DOMActivate");
  194. ]]>
  195. </script>
  196. </select1>
  197. <input id="ipt_mngtdeptcd_search" ref="/root/send/mngtdeptcd_search" class="input_search" disabled="false" navindex="4" style="left:790px; top:5px; width:95px; height:19px; ">
  198. <script type="javascript" ev:event="xforms-value-changed">
  199. <![CDATA[
  200. misfSearchDept(ipt_mngtdeptnm_search);
  201. ]]>
  202. </script>
  203. </input>
  204. <button id="btn_mngtdeptcd_search" class="icon_search" disabled="false" navindex="-1" style="left:888px; top:5px; width:16px; height:16px; ">
  205. <caption/>
  206. <script type="javascript" ev:event="DOMActivate">
  207. <![CDATA[
  208. misfOpenPopUpList("02", ipt_mngtdeptcd_search,"","mngtdeptcd_search,mngtdeptnm_search");
  209. ipt_mngtdeptcd_search.refresh();
  210. ipt_mngtdeptnm_search.refresh();
  211. ]]>
  212. </script>
  213. </button>
  214. <caption id="cap_dept031" class="search_name" visibility="hidden" style="left:690px; top:5px; width:92px; height:17px; ">사용부서 :</caption>
  215. <input id="ipt_mngtdeptnm_search" ref="/root/send/mngtdeptnm_search" class="output_fix" navindex="-1" editable="false" appearance="input" style="left:907px; top:5px; width:150px; height:19px; "/>
  216. <caption id="cap_dept032" class="search_name" visibility="hidden" style="left:690px; top:5px; width:92px; height:17px; ">설치장소 :</caption>
  217. </group>
  218. <line id="line3" class="line_1" style="x1:0px; y1:149px; x2:1195px; y2:149px; "/>
  219. <caption id="caption10" class="tit_2" style="left:5px; top:134px; width:205px; height:13px; ">부서별 대상품목 리스트</caption>
  220. <datagrid id="grd_degolist" nodeset="/root/main/grid/degolist" caption="계정과목^계정과목^자산코드^자산명^규격^수량^취득금액^취득일^잔존가^보유상태^실사결과^실사비고^부서비고^사용부서^설치부서^년도^기준일자^부서확인(fromdd)^부서확인(todd)^사용여부^기준금액(min)^기준금액(max)^사용부서코드^부서장승인자명^최종제출일자" colsep="^" colwidth="55,100, 100, 216, 131, 35, 75, 70, 75,60,60,115,115,90,90,0,0,0,0,0,0,0,0,0,0" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" navindex="7" style="left:0px; top:155px; width:1195px; height:563px; ">
  221. <col ref="acntcd" visibility="hidden" style="text-align:center; "/>
  222. <col ref="acntnm" style="padding-left:5; "/>
  223. <col ref="fixasetcd" style="text-align:center; "/>
  224. <col ref="goodflaghngnm" style="padding-left:5; "/>
  225. <col ref="goodspec" style="padding-left:5; "/>
  226. <col ref="goodqty" style="text-align:center; "/>
  227. <col ref="possnamt" format="#,##0" style="text-align:right; "/>
  228. <col ref="possndd" format="yyyy-mm-dd" style="text-align:center; "/>
  229. <col ref="janjonsak" format="#,##0" style="text-align:right; "/>
  230. <col disabled="true" ref="status" type="combo" style="text-align:center; ">
  231. <choices>
  232. <item>
  233. <label>보유</label>
  234. <value>1</value>
  235. </item>
  236. <item>
  237. <label>미보유</label>
  238. <value>2</value>
  239. </item>
  240. <item>
  241. <label>불용</label>
  242. <value>3</value>
  243. </item>
  244. </choices>
  245. </col>
  246. <col ref="silstatus" type="combo" style="text-align:center; background-color:#C4E693; ">
  247. <choices>
  248. <item>
  249. <label>보유</label>
  250. <value>1</value>
  251. </item>
  252. <item>
  253. <label>미보유</label>
  254. <value>2</value>
  255. </item>
  256. <item>
  257. <label>불용</label>
  258. <value>3</value>
  259. </item>
  260. </choices>
  261. </col>
  262. <col ref="silcmt" type="input" style="text-align:center; background-color:#C4E693; "/>
  263. <col ref="remark" style="text-align:center; "/>
  264. <col ref="mngtdeptnm" style="text-align:center; "/>
  265. <col ref="installplcenm" style="text-align:center; "/>
  266. <col ref="yyyy" visibility="hidden"/>
  267. <col ref="basedd" visibility="hidden"/>
  268. <col ref="dfromdd" visibility="hidden"/>
  269. <col ref="dtodd" visibility="hidden"/>
  270. <col ref="useyn" visibility="hidden"/>
  271. <col ref="passnmin" visibility="hidden"/>
  272. <col ref="passnmax" visibility="hidden"/>
  273. <col ref="mngtdeptcd" visibility="hidden"/>
  274. <col ref="deptaprvnm" visibility="hidden"/>
  275. <col ref="senddd" visibility="hidden"/>
  276. <col ref="instcd" visibility="hidden"/>
  277. <script type="javascript" ev:event="xforms-value-changed">
  278. <![CDATA[
  279. // if(grd_propllist.col == grd_propllist.colRef("deptcd")) {
  280. // misfValidationCheck("02", "grd_propllist", "deptcd,deptnm", model.getValue(cmb_instcd.attribute("ref")),"instcd");
  281. // }
  282. ]]>
  283. </script>
  284. <script type="javascript" ev:event="onaftersort">
  285. <![CDATA[
  286. grd_degolist.gridToInstance();
  287. ]]>
  288. </script>
  289. </datagrid>
  290. <button id="button4" class="btn2_letter4" navindex="8" style="left:1122px; top:129px; width:64px; height:19px; ">
  291. <caption>엑셀저장</caption>
  292. <script type="javascript" ev:event="DOMActivate">
  293. <![CDATA[
  294. var deptnm = model.getValue("/root/send/mngtdeptnm_search");
  295. if( grd_degolist.rows - grd_degolist.fixedRows > 0 ) {
  296. var fileName ="("+ deptnm +")"+"재물대상품목_" + getCurrentDate();
  297. var fileName = window.fileDialog("save", ",", false, fileName, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  298. grd_degolist.saveExcel(fileName, "Sheet");
  299. } else {
  300. messageBox("저장 데이터가","I004");
  301. }
  302. ]]>
  303. </script>
  304. </button>
  305. <input id="ipt_yyyy" ref="/root/send/yyyy" class="input_search" navindex="2" visibility="hidden" style="left:450px; top:15px; width:105px; height:19px; text-align:center; "/>
  306. <caption id="caption11" class="tit_2" style="left:5px; top:50px; width:205px; height:15px; ">재물조사 정보</caption>
  307. <shape id="rectangle2" appearance="rectangle" style="left:1px; top:66px; width:1185px; height:62px; background-color:#ffffcc; border-color:#99ccff; "/>
  308. <caption id="caption12" class="cell_1" style="left:225px; top:72px; width:105px; height:23px; text-align:center; vertical-align:middle; ">부서 확인기간 :</caption>
  309. <input id="input8" ref="/root/send/dfromdd" disabled="true" navindex="2" format="yyyy-mm-dd" style="left:333px; top:73px; width:105px; height:19px; text-align:center; "/>
  310. <input id="input9" ref="/root/send/dtodd" disabled="true" navindex="2" format="yyyy-mm-dd" style="left:457px; top:73px; width:105px; height:19px; text-align:center; "/>
  311. <caption id="caption13" class="cell_1" style="left:10px; top:72px; width:90px; height:23px; text-align:center; vertical-align:middle; ">기준일자 :</caption>
  312. <input id="input10" ref="/root/send/basedd" disabled="true" navindex="2" style="left:103px; top:73px; width:92px; height:19px; text-align:center; "/>
  313. <caption id="caption14" class="cell_1" style="left:590px; top:72px; width:80px; height:23px; text-align:center; vertical-align:middle; ">사용여부 :</caption>
  314. <input id="input11" ref="/root/send/useyn" disabled="true" navindex="2" style="left:673px; top:73px; width:45px; height:19px; text-align:center; "/>
  315. <caption id="caption16" style="left:442px; top:74px; width:20px; height:20px; ">~</caption>
  316. <caption id="caption1" class="cell_1" style="left:745px; top:72px; width:105px; height:23px; text-align:center; vertical-align:middle; ">부서장 승인자명 :</caption>
  317. <caption id="caption2" class="cell_1" style="left:970px; top:72px; width:105px; height:23px; text-align:center; vertical-align:middle; ">최종제출일자 :</caption>
  318. <input id="input1" ref="/root/send/deptaprvnm" disabled="true" navindex="2" style="left:853px; top:73px; width:90px; height:19px; text-align:center; "/>
  319. <input id="input2" ref="/root/send/senddd" disabled="true" navindex="2" format="yyyy-mm-dd" style="left:1078px; top:73px; width:85px; height:19px; text-align:center; "/>
  320. <caption id="caption3" class="cell_1" style="left:10px; top:101px; width:90px; height:23px; text-align:center; vertical-align:middle; ">기준금액 :</caption>
  321. <input id="input3" ref="/root/send/passnmin" disabled="true" navindex="2" format="#,##0" style="left:104px; top:102px; width:105px; height:19px; text-align:center; "/>
  322. <input id="input4" ref="/root/send/passnmax" disabled="true" navindex="2" format="#,##0" style="left:228px; top:102px; width:105px; height:19px; text-align:center; "/>
  323. <caption id="caption4" style="left:213px; top:103px; width:20px; height:20px; ">~</caption>
  324. </group>
  325. </xhtml:body>
  326. </xhtml:html>