SMRFC00401_재물기준정보관리.xrw 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230
  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: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. <grid>
  11. <propllist/>
  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" ev:event="xforms-ready">
  36. <![CDATA[
  37. fInitialize();
  38. ]]>
  39. </script>
  40. <submission id="TRRFC00410" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/grid/propllist"/>
  41. <submission id="TXRFC00403" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/grid/propllist" resultref="/root/temp"/>
  42. </model>
  43. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  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="../../../com/commonweb/js/dateHelper.js"/>
  47. <script type="javascript">
  48. <![CDATA[
  49. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  50. function fInitialize() {
  51. misfGridInit(grd_propllist);
  52. misfComboComCdList("C0048",cmb_instcd,"Y"); //기관코드
  53. misfMsterDetailSet(grd_propllist, null, "TRRFC00410","Y"); //마스터 설정
  54. model.setValue(cmb_instcd.attribute("ref"), getUserInfo("dutplceinstcd")); // 기관 설정
  55. model.setValue(ipt_yyyy.attribute("ref"),getCurrentDate().substring(0, 4));
  56. var dutplcecd = getUserInfo("dutplcecd");
  57. if(dutplcecd == "4020334000" || getUserInfo("userid") == "MIS" || getUserInfo("userid") == "99207" ){
  58. btn_search.dispatch("DOMActivate");
  59. }else{
  60. messageBox("물류팀외 조회할 수","I004");
  61. btn_search.disabled = true;
  62. btn_save.disabled = true;
  63. btn_clear.disabled = true;
  64. ipt_yyyy.disabled = true;
  65. }
  66. model.refresh();
  67. }
  68. function fsearch(){
  69. // var updtdata = getGridUpdateData(grd_propllist);
  70. // if ( updtdata != "") {
  71. // var ret = messageBox("그리드에 작업 중인 내용이 있습니다. 조회 작업을","Q003");
  72. // if (ret != 6) { // not OK
  73. // return;
  74. // }
  75. // }
  76. isRequiredControls("cmb_instcd");
  77. misfMsterDetailRetrieve();
  78. // misfSetReadOnlyCol(grd_rfcmetpllist, "instcd,deptcd,deptnm", true);
  79. }
  80. ]]>
  81. </script>
  82. </xhtml:head>
  83. <xhtml:body pagewidth="1211" pageheight="784" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  84. <group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
  85. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:186px; height:15px; ">재물조사 기준정보 설정</caption>
  86. </group>
  87. <group id="grp_biz" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
  88. <group id="grp_sea" style="left:0px; top:10px; width:1195px; height:35px; vertical-align:top; ">
  89. <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; "/>
  90. <caption id="cap_instcd" class="search_name" style="left:15px; top:9px; width:86px; height:17px; ">기관코드 :</caption>
  91. <line id="line13" class="line_4" style="x1:1110px; y1:5px; x2:1110px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
  92. <caption id="cap_deptcd" class="search_name" style="left:511px; top:9px; width:90px; height:17px; ">기준년도 :</caption>
  93. <button id="btn_search" class="btn1_letter2" navindex="6" style="left:1125px; top:6px; width:56px; height:22px; ">
  94. <caption>조회</caption>
  95. <script type="javascript" ev:event="DOMActivate">
  96. <![CDATA[
  97. fsearch();
  98. ]]>
  99. </script>
  100. </button>
  101. <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; ">
  102. <choices>
  103. <itemset>
  104. <label/>
  105. <value/>
  106. </itemset>
  107. </choices>
  108. <script type="javascript" ev:event="xforms-value-changed">
  109. <![CDATA[
  110. btn_search.dispatch("DOMActivate");
  111. ]]>
  112. </script>
  113. </select1>
  114. <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; "/>
  115. </group>
  116. <line id="line2" class="line_1" style="x1:0px; y1:94px; x2:1194; y2:94px; "/>
  117. <caption id="caption8" class="tit_2" style="left:5px; top:79px; width:133px; height:15px; ">기준정보 리스트</caption>
  118. <button id="btn_grdadd" class="btn2_letter3" navindex="9" style="left:1085px; top:74px; width:53px; height:19px; ">
  119. <caption>행추가</caption>
  120. <script type="javascript" ev:event="DOMActivate">
  121. <![CDATA[
  122. misfGridIUD(grd_propllist, "A");
  123. var acntnm = grd_propllist.valueMatrix(grd_propllist.row, grd_propllist.colRef("acntnm"));
  124. grd_propllist.valueMatrix(grd_propllist.row, grd_propllist.colRef("yyyy")) = getCurrentDate().substring(0, 4);
  125. grd_propllist.valueMatrix(grd_propllist.row, grd_propllist.colRef("useyn")) = "Y";
  126. if(acntnm == ""){
  127. //popup 프로그램 호출
  128. window.load("SPRFC04000.xrw", "modal","", "", "/root/popacnt","/root/popdata");
  129. }
  130. ]]>
  131. </script>
  132. </button>
  133. <button id="btn_grddel" class="btn2_letter3" navindex="10" style="left:1141px; top:74px; width:53px; height:19px; ">
  134. <caption>행삭제</caption>
  135. <script type="javascript" ev:event="DOMActivate">
  136. <![CDATA[
  137. misfGridIUD(grd_propllist, "D");
  138. ]]>
  139. </script>
  140. </button>
  141. <datagrid id="grd_propllist" nodeset="/root/main/grid/propllist" autoresize="true" caption="년도^기준일자(MMDD)^부서확인기간(FROM~TO)^부서확인기간(FROM~TO)^기준금액(MIN~MAX)^기준금액(MIN~MAX)^계정과목^비고" colsep="^" colwidth="60, 109, 100, 100, 100, 90, 289, 300" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" navindex="7" style="left:0px; top:100px; width:1195px; height:644px; ">
  142. <col ref="yyyy" type="input" style="text-align:center; "/>
  143. <col ref="basedd" type="input" format="mm-dd" maxbyte="100" style="text-align:center; "/>
  144. <col ref="dfromdd" type="inputdate" format="yyyy-mm-dd" style="text-align:center; "/>
  145. <col ref="dtodd" type="inputdate" format="yyyy-mm-dd" style="text-align:center; "/>
  146. <col ref="passnmin" type="input" format="#,##0" style="text-align:center; "/>
  147. <col ref="passnmax" type="input" format="#,##0" style="text-align:center; "/>
  148. <col disabled="false" editable="true" ref="acntnm" type="inputbutton" style="text-align:left; padding-left:10; "/>
  149. <col ref="cmt" type="input" style="text-align:center; "/>
  150. <script type="javascript" ev:event="onbuttonclick">
  151. <![CDATA[
  152. if(grd_propllist.col == grd_propllist.colRef("acntnm")) {
  153. model.setValue("/root/popacnt/instcd", cmb_instcd.value);
  154. // alert( grd_propllist.valueMatrix(grd_propllist.row, grd_propllist.colRef("yyyy")));
  155. model.setValue("/root/popacnt/yyyy", grd_propllist.valueMatrix(grd_propllist.row, grd_propllist.colRef("yyyy")));
  156. model.setValue("/root/popacnt/selectyn", "")
  157. //popup 프로그램 호출
  158. window.load("SPRFC04000.xrw", "modal","", "", "/root/popacnt","/root/popdata");
  159. btn_search.dispatch("DOMActivate");
  160. }
  161. ]]>
  162. </script>
  163. <script type="javascript" ev:event="xforms-value-changed">
  164. <![CDATA[
  165. // if(grd_propllist.col == grd_propllist.colRef("deptcd")) {
  166. // misfValidationCheck("02", "grd_propllist", "deptcd,deptnm", model.getValue(cmb_instcd.attribute("ref")),"instcd");
  167. // }
  168. ]]>
  169. </script>
  170. </datagrid>
  171. <button id="button1" class="btn2_letter4" navindex="8" style="left:1017px; top:74px; width:64px; height:19px; ">
  172. <caption>엑셀저장</caption>
  173. <script type="javascript" ev:event="DOMActivate">
  174. <![CDATA[
  175. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  176. if (fileName != "") {
  177. grd_propllist.saveExcel(fileName, "sheetname:sheet1;colhiddenextend:true;rowhiddenextend:false;exportfalsecols:0,0;col_1:value;");
  178. }
  179. ]]>
  180. </script>
  181. </button>
  182. <caption id="caption1" style="left:135px; top:72px; width:395px; height:20px; font-weight:bold; background-color:#ffff99; ">* 계정과목을 먼저 저장 후에 기준정보를 저장하시기 바랍니다.*</caption>
  183. </group>
  184. <group id="group2" style="left:0px; top:12px; width:1195px; height:27px; ">
  185. <line id="line16" class="line_2" style="x1:0px; y1:25px; x2:1195px; y2:25px; "/>
  186. <button id="btn_clear" class="btn4_letter3" navindex="13" style="left:1127px; top:3; width:68px; height:22px; ">
  187. <caption>초기화</caption>
  188. <script type="javascript" ev:event="DOMActivate">
  189. <![CDATA[
  190. fInitialize();
  191. ]]>
  192. </script>
  193. </button>
  194. <button id="btn_save" class="btn4_letter2" navindex="12" style="left:1069px; top:3; width:56px; height:22px; ">
  195. <caption>저장</caption>
  196. <script type="javascript" ev:event="DOMActivate">
  197. <![CDATA[
  198. var updtdata = getGridUpdateData(grd_propllist);
  199. if (updtdata == "") {
  200. messageBox("변경된 데이터가","I004");
  201. return;
  202. }
  203. if(!checkKeyColumn("grd_propllist")) return;
  204. rtn = messageBox("", "Q002");
  205. if(rtn != "6" ) return false;
  206. misfSave("TXRFC00403");
  207. btn_search.dispatch("DOMActivate");
  208. ]]>
  209. </script>
  210. </button>
  211. </group>
  212. </xhtml:body>
  213. </xhtml:html>