SMRFC00403_부서별물품보유제출현황.xrw 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197
  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. <deptgoodlist/>
  12. </grid>
  13. </main>
  14. <send>
  15. <instcd/>
  16. <yyyy/>
  17. </send>
  18. <init>
  19. </init>
  20. <hidden/>
  21. <temp/>
  22. <popacnt>
  23. <instcd/>
  24. <yyyy/>
  25. <selectyn/>
  26. </popacnt>
  27. <popacntlist>
  28. <acntlist/>
  29. </popacntlist>
  30. </root>
  31. </instance>
  32. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  33. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  34. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  35. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  36. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  37. <script type="javascript" ev:event="xforms-ready">
  38. <![CDATA[
  39. fInitialize();
  40. ]]>
  41. </script>
  42. <submission id="TRRFC00405" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/grid/propllist"/>
  43. <submission id="TXRFC00403" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/grid/propllist" resultref="/root/temp"/>
  44. </model>
  45. <script type="javascript">
  46. <![CDATA[
  47. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  48. function fInitialize() {
  49. misfGridInit(grd_deptgoodlist);
  50. misfComboComCdList("C0048",cmb_instcd,"Y"); //기관코드
  51. misfMsterDetailSet(grd_deptgoodlist, null, "TRRFC00405","Y"); //마스터 설정
  52. model.setValue(cmb_instcd.attribute("ref"), getUserInfo("dutplceinstcd")); // 기관 설정
  53. model.setValue(ipt_yyyy.attribute("ref"),getCurrentDate().substring(0, 4));
  54. var dutplcecd = getUserInfo("dutplcecd");
  55. if(dutplcecd == "4020334000" || getUserInfo("userid") == "MIS" || getUserInfo("userid") == "99207" ){
  56. btn_search.dispatch("DOMActivate");
  57. }else{
  58. messageBox("물류팀외 조회할 수","I004");
  59. btn_search.disabled = true;
  60. btn_save.disabled = true;
  61. ipt_yyyy.disabled = true;
  62. }
  63. model.refresh();
  64. }
  65. ]]>
  66. </script>
  67. </xhtml:head>
  68. <xhtml:body pagewidth="1211" pageheight="784" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  69. <group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
  70. <caption id="caption6" class="tit_1" style="left:0px; top:-5px; width:250px; height:18px; ">부서별 물품보유현황 제출내역</caption>
  71. </group>
  72. <group id="grp_biz" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
  73. <group id="grp_sea" style="left:0px; top:10px; width:1195px; height:35px; vertical-align:top; ">
  74. <shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
  75. <caption id="cap_instcd" class="search_name" style="left:15px; top:9px; width:86px; height:17px; ">기관코드 :</caption>
  76. <line id="line13" class="line_4" style="x1:1110px; y1:5px; x2:1110px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
  77. <caption id="cap_deptcd" class="search_name" style="left:511px; top:9px; width:90px; height:17px; ">기준년도 :</caption>
  78. <button id="btn_search" class="btn1_letter2" navindex="6" style="left:1125px; top:6px; width:56px; height:22px; ">
  79. <caption>조회</caption>
  80. <script type="javascript" ev:event="DOMActivate">
  81. <![CDATA[
  82. var yyyy = parseInt(model.getValue("/root/send/yyyy"));
  83. var year = parseInt(getCurrentDate().substring(0, 4));
  84. if(yyyy < '2017' || yyyy > year ) {
  85. messageBox("조회할 수 없는 년도","I009");
  86. return;
  87. }else{
  88. model.removeNodeset("/root/main/grid/deptgoodlist");
  89. submit("TRRFC00405");
  90. // 그리드 색깔표시
  91. for(var i=grd_deptgoodlist.fixedRows;i<grd_deptgoodlist.rows;i++){
  92. var sendyn = grd_deptgoodlist.valueMatrix(i,grd_deptgoodlist.colRef("sendyn"));
  93. if(sendyn == "Y"){
  94. grd_deptgoodlist.rowStyle(i,"data","background-color") = "#FFFFCC";
  95. }else{
  96. grd_deptgoodlist.rowStyle(i,"data","background-color") = "white";
  97. }
  98. }
  99. grd_deptgoodlist.refresh();
  100. }
  101. ]]>
  102. </script>
  103. </button>
  104. <select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_s_essential" disabled="true" navindex="1" appearance="minimal" style="left:108px; top:8px; width:238px; height:19px; text-align:center; ">
  105. <choices>
  106. <itemset>
  107. <label/>
  108. <value/>
  109. </itemset>
  110. </choices>
  111. </select1>
  112. <input id="ipt_yyyy" ref="/root/send/yyyy" class="input_search" navindex="2" style="left:605px; top:8px; width:105px; height:19px; text-align:center; ">
  113. <script type="javascript" ev:event="onkeyup">
  114. <![CDATA[
  115. if(event.keyCode == "13") misfNoFormat();
  116. inputEnterKey("btn_search", "DOMActivate");
  117. ]]>
  118. </script>
  119. </input>
  120. </group>
  121. <line id="line2" class="line_1" style="x1:0px; y1:94px; x2:1194; y2:94px; "/>
  122. <caption id="caption8" class="tit_2" style="left:5px; top:79px; width:280px; height:15px; ">부서별 물품 보유현황 제출 리스트</caption>
  123. <button id="btn_grdadd" class="btn2_letter3" navindex="9" visibility="hidden" style="left:240px; top:70px; width:53px; height:19px; ">
  124. <caption>행추가</caption>
  125. <script type="javascript" ev:event="DOMActivate">
  126. <![CDATA[
  127. misfGridIUD(grd_deptgoodlist, "A");
  128. ]]>
  129. </script>
  130. </button>
  131. <button id="btn_grddel" class="btn2_letter3" navindex="10" visibility="hidden" style="left:296px; top:70px; width:53px; height:19px; ">
  132. <caption>행삭제</caption>
  133. <script type="javascript" ev:event="DOMActivate">
  134. <![CDATA[
  135. misfGridIUD(grd_deptgoodlist, "D");
  136. ]]>
  137. </script>
  138. </button>
  139. <datagrid id="grd_deptgoodlist" nodeset="/root/main/grid/deptgoodlist" caption="기관^부서코드^부서명^최종제출 여부^제출비고" colsep="^" colwidth="60, 125, 257, 100, 502" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" navindex="7" style="left:0px; top:100px; width:1195px; height:644px; ">
  140. <col ref="instcd" style="text-align:center; "/>
  141. <col ref="deptcd" style="text-align:center; "/>
  142. <col ref="deptnm" style="text-align:center; "/>
  143. <col ref="sendyn" style="text-align:center; "/>
  144. <col ref="cmt" type="input" style="text-align:center; "/>
  145. <script type="javascript" ev:event="onaftersort">
  146. <![CDATA[
  147. grd_deptgoodlist.gridToInstance();
  148. ]]>
  149. </script>
  150. </datagrid>
  151. <button id="button1" class="btn2_letter4" navindex="8" style="left:1127px; top:74px; width:64px; height:19px; ">
  152. <caption>엑셀저장</caption>
  153. <script type="javascript" ev:event="DOMActivate">
  154. <![CDATA[
  155. if( grd_deptgoodlist.rows - grd_deptgoodlist.fixedRows > 0 ) {
  156. var fileName ="부서별 물품보유현황 제출내역_" + getCurrentDate();
  157. var fileName = window.fileDialog("save", ",", false, fileName, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  158. grd_deptgoodlist.saveExcel(fileName, "Sheet");
  159. } else {
  160. messageBox("저장 데이터가","I004");
  161. }
  162. ]]>
  163. </script>
  164. </button>
  165. <caption id="caption1" style="left:636px; top:72px; width:484px; height:20px; background-color:#C4E693; ">* 최종제출 여부 - 무 : 저장내역(X), Y : 최종제출, N : 저장내역(O).최종제출(X)</caption>
  166. </group>
  167. <group id="group2" style="left:0px; top:12px; width:1195px; height:27px; ">
  168. <line id="line16" class="line_2" style="x1:0px; y1:25px; x2:1195px; y2:25px; "/>
  169. <button id="btn_save" class="btn4_letter2" navindex="12" style="left:1124px; top:3px; width:56px; height:22px; ">
  170. <caption>저장</caption>
  171. <script type="javascript" ev:event="DOMActivate">
  172. <![CDATA[
  173. var updtdata = getGridUpdateData(grd_deptgoodlist);
  174. if (updtdata == "") {
  175. messageBox("변경된 데이터가","I004");
  176. return;
  177. }
  178. if(!checkKeyColumn("grd_deptgoodlist")) return;
  179. rtn = messageBox("", "Q002");
  180. if(rtn != "6" ) return false;
  181. misfSave("TXRFC00403");
  182. btn_search.dispatch("DOMActivate");
  183. ]]>
  184. </script>
  185. </button>
  186. </group>
  187. </xhtml:body>
  188. </xhtml:html>