SMRSG04201_계정 부서별 불출증감 현황.xrw 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309
  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. <headdata>
  11. <instcd/>
  12. <instnm/>
  13. <prtname/>
  14. </headdata>
  15. <printdatalist>
  16. <windeptcd/>
  17. <deptnm>
  18. </deptnm>
  19. <ym/>
  20. <purcacntcd/>
  21. <purcacntnm>
  22. </purcacntnm>
  23. <outamt/>
  24. </printdatalist>
  25. <ViewLists>
  26. <ViewList>
  27. <purcacntnm/>
  28. <purcacntcd/>
  29. </ViewList>
  30. </ViewLists>
  31. </main>
  32. <init>
  33. <ViewList>
  34. <purcacntnm/>
  35. <purcacntcd/>
  36. </ViewList>
  37. </init>
  38. <send>
  39. <frmonth/>
  40. <tomonth/>
  41. <payinstcd/>
  42. <deptcd/>
  43. <deptnm/>
  44. <frstocdeptcd/>
  45. <frstocdeptcdnm/>
  46. <tostocdeptcd/>
  47. <tostocdeptcdnm/>
  48. </send>
  49. <hidden/>
  50. </root>
  51. </instance>
  52. <script type="javascript" ev:event="xforms-ready">
  53. <![CDATA[
  54. fInit() ; // 화면 Control을 초기화한다
  55. ]]>
  56. </script>
  57. <submission id="TRRSG04201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/printdatalist"/>
  58. </model>
  59. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  60. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  61. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  62. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  63. <script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
  64. <script type="javascript" src="../../../mis/paybnusmngtweb/js/RWP001.js"/>
  65. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  66. <script type="javascript" src="../../../mis/stocsumweb/js/SMRSG04201.js"/>
  67. <script type="javascript">
  68. <![CDATA[
  69. ]]>
  70. </script>
  71. </xhtml:head>
  72. <xhtml:body style="margin-left:8; margin-right:8; ">
  73. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  74. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">계정별 부서별 불출 현황</caption>
  75. </group>
  76. <group id="group2" scroll="auto" style="left:0px; top:20px; width:1195px; height:760px; ">
  77. <caption id="caption1" style="left:480px; top:16px; width:15px; height:20px; ">~</caption>
  78. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1193px; height:55px; background-color:#fffbf2; border-color:#ffd799; "/>
  79. <button id="btn_search" class="btn1_letter2" style="left:1130px; top:27px; width:56px; height:22px; ">
  80. <caption>조회</caption>
  81. <script type="javascript" ev:event="DOMActivate">
  82. <![CDATA[
  83. model.setValue("/root/main/headdata/instcd", cmb_instcd.value);
  84. model.setValue("/root/main/headdata/instnm", cmb_instcd.label);
  85. if (model.getValue(ipt_frstocdeptcd.attribute("ref") ) == "") {
  86. model.setValue(ipt_tostocdeptcd.attribute("ref"), "");
  87. }
  88. if ((model.getValue(ipt_frstocdeptcd.attribute("ref") ) != "") &&
  89. (model.getValue(ipt_tostocdeptcd.attribute("ref")) == "") ) {
  90. model.setValue(ipt_tostocdeptcd.attribute("ref"), model.getValue(ipt_frstocdeptcd.attribute("ref") ));
  91. }
  92. if (model.getValue(ipt_frstocdeptcd.attribute("ref")) >
  93. model.getValue(ipt_tostocdeptcd.attribute("ref")) ) {
  94. alert("시작부서가 끝부서보다 큽니다 확인 하십시요!!");
  95. return;
  96. }
  97. submit("TRRSG04201");
  98. fViewDataTitle();
  99. // fViewData();
  100. ]]>
  101. </script>
  102. </button>
  103. <line id="line13" class="line_4" style="x1:1120px; y1:20px; x2:1120px; y2:54px; "/>
  104. <input id="ipt_topayym" ref="/root/send/tomonth" class="input_default" inputtype="date" format="yyyy-mm" style="left:480px; top:16px; width:94px; height:19px; text-align:center; vertical-align:middle; "/>
  105. <input id="ipt_frpayym" ref="/root/send/frmonth" class="input_default" inputtype="date" format="yyyy-mm" style="left:480px; top:16px; width:94px; height:19px; text-align:center; vertical-align:middle; ">
  106. <script type="javascript" ev:event="xforms-value-changed">
  107. <![CDATA[
  108. model.setValue(ipt_topayym.attribute("ref"), model.getValue(ipt_frpayym.attribute("ref")));
  109. ]]>
  110. </script>
  111. </input>
  112. <caption id="caption28" class="tit_2" style="left:5px; top:73px; width:162px; height:13px; ">계정별 불출 현황</caption>
  113. <line id="line193" class="line_1" style="x1:0px; y1:91px; x2:1192px; y2:91px; "/>
  114. <caption id="cap_payym" class="search_name" style="left:390px; top:17px; width:90px; height:17px; ">작업년월 :</caption>
  115. <select1 id="cmb_instcd" ref="/root/send/payinstcd" appearance="minimal" style="left:80px; top:16px; width:238px; height:19px; text-align:center; ">
  116. <choices>
  117. <itemset>
  118. <label/>
  119. <value/>
  120. </itemset>
  121. </choices>
  122. </select1>
  123. <caption id="cap_instcd" class="search_name" style="left:10px; top:17px; width:70px; height:17px; ">기 관 :</caption>
  124. <output id="opt_deptnm" ref="/root/send/deptnm" class="output_fix" style="left:183px; top:40px; width:135px; height:19px; text-align:center; "/>
  125. <output id="opt_deptcd" ref="/root/send/deptcd" class="output_fix" style="left:80px; top:40px; width:100px; height:19px; text-align:center; "/>
  126. <caption id="cap_deptcd" class="search_name" style="left:10px; top:41px; width:70px; height:17px; ">부 서 :</caption>
  127. <button id="button1" class="icon_search" style="left:839px; top:16px; width:16px; height:16px; ">
  128. <caption/>
  129. <script type="javascript" ev:event="DOMActivate">
  130. <![CDATA[
  131. var recv_list = "frstocdeptcd,frstocdeptcdnm";
  132. misfOpenPopUpList("02", ipt_frstocdeptcd,"", recv_list) ;
  133. model.refresh();
  134. btn_search.dispatch("DOMActivate");
  135. ]]>
  136. </script>
  137. </button>
  138. <caption id="caption11" class="search_name" style="left:668px; top:17px; width:86px; height:17px; ">출고부서 :</caption>
  139. <input id="ipt_frstocdeptcdnm" ref="/root/send/frstocdeptcdnm" class="input_search" style="left:860px; top:16px; width:197px; height:19px; ">
  140. <script type="javascript" ev:event="xforms-value-changed">
  141. <![CDATA[
  142. misfValidationCheck("02", "", "frstocdeptcd,frstocdeptcdnm" );
  143. model.refresh();
  144. // btn_search.dispatch("DOMActivate");
  145. ]]>
  146. </script>
  147. </input>
  148. <input id="ipt_frstocdeptcd" ref="/root/send/frstocdeptcd" class="input_default" maxlength="10" appearance="input" style="left:755px; top:16px; width:81px; height:19px; ">
  149. <script type="javascript" ev:event="xforms-value-changed">
  150. <![CDATA[
  151. if (model.getValue(ipt_frstocdeptcd.attribute("ref") ) == "") {
  152. model.setValue(ipt_tostocdeptcd.attribute("ref"), "");
  153. return;
  154. }
  155. misfValidationCheck("02", "", "frstocdeptcd,frstocdeptcdnm" );
  156. if (model.getValue(ipt_frstocdeptcdnm.attribute("ref") ) != "") {
  157. if (model.getValue(ipt_tostocdeptcdnm.attribute("ref") ) == "") {
  158. model.setValue(ipt_tostocdeptcd.attribute("ref") , model.getValue(ipt_frstocdeptcd.attribute("ref")) );
  159. model.setValue(ipt_tostocdeptcdnm.attribute("ref"), model.getValue(ipt_tostocdeptcdnm.attribute("ref")));
  160. }
  161. }
  162. model.refresh();
  163. ]]>
  164. </script>
  165. </input>
  166. <button id="button2" class="icon_search" style="left:841px; top:40px; width:16px; height:16px; ">
  167. <caption/>
  168. <script type="javascript" ev:event="DOMActivate">
  169. <![CDATA[
  170. var recv_list = "tostocdeptcd,tostocdeptcdnm";
  171. misfOpenPopUpList("02", ipt_tostocdeptcd,"", recv_list) ;
  172. model.refresh();
  173. ]]>
  174. </script>
  175. </button>
  176. <input id="ipt_tostocdeptcdnm" ref="/root/send/tostocdeptcdnm" class="input_search" style="left:860px; top:40px; width:197px; height:19px; ">
  177. <script type="javascript" ev:event="xforms-value-changed">
  178. <![CDATA[
  179. misfValidationCheck("02", "", "tostocdeptcd,tostocdeptcdnm" );
  180. model.refresh();
  181. ]]>
  182. </script>
  183. </input>
  184. <input id="ipt_tostocdeptcd" ref="/root/send/tostocdeptcd" class="input_default" maxlength="10" appearance="input" style="left:755px; top:40px; width:81px; height:19px; ">
  185. <script type="javascript" ev:event="xforms-value-changed">
  186. <![CDATA[
  187. misfValidationCheck("02", "", "tostocdeptcd,tostocdeptcdnm" );
  188. model.refresh();
  189. ]]>
  190. </script>
  191. </input>
  192. <caption id="caption2" style="left:1065px; top:16px; width:26px; height:20px; ">에서</caption>
  193. <caption id="caption3" style="left:1065px; top:40px; width:26px; height:20px; ">까지</caption>
  194. <caption id="caption4" style="left:739px; top:40px; width:15px; height:20px; ">~</caption>
  195. <datagrid id="grd_viewlist" nodeset="/root/main/ViewLists/ViewList" caption="계정/부서^계정코드|계정/부서^계정코드" colsep="^" colwidth="161, 100" explorerbar="sortshow" frozencols="1" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:96px; width:1192px; height:660px; ">
  196. <col ref="purcacntnm"/>
  197. <col ref="purcacntcd" visibility="hidden"/>
  198. </datagrid>
  199. <datagrid id="grd_source" nodeset="/root/main/printdatalist" visibility="hidden" caption="부서코드^부서명^작업년월^계정코드^계정명^출고수량^전월^증감율^부서위치^계정위치" colsep="^" colwidth="100, 100, 100, 100, 100, 100, 100, 100, 100, 100" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:105px; top:430px; width:975px; height:110px; ">
  200. <col ref="windeptcd"/>
  201. <col ref="deptnm"/>
  202. <col ref="ym"/>
  203. <col ref="purcacntcd"/>
  204. <col ref="purcacntnm"/>
  205. <col ref="outamt"/>
  206. <col ref="befoutamt"/>
  207. <col ref="percent"/>
  208. <col ref="colpos"/>
  209. <col ref="rowpos"/>
  210. </datagrid>
  211. <button id="btn_excel" class="btn5_letter3" style="left:1125px; top:69px; width:53px; height:19px; ">
  212. <caption>Excel</caption>
  213. <script type="javascript" ev:event="DOMActivate">
  214. <![CDATA[
  215. misfSaveExcel(grd_viewlist);
  216. ]]>
  217. </script>
  218. </button>
  219. <button id="btn_print" class="btn6_letter2" visibility="visible" style="left:1060px; top:68px; width:56px; height:22px; ">
  220. <caption>출력</caption>
  221. <script type="javascript" ev:event="DOMActivate">
  222. <![CDATA[
  223. exeReportPreview("RPRSG04201", "XMLSTR");//, "/root/main/payamt");
  224. ]]>
  225. </script>
  226. </button>
  227. <button id="button3" visibility="hidden" style="left:285px; top:70px; width:63px; height:20px; ">
  228. <caption>addCol</caption>
  229. <script type="javascript" ev:event="DOMActivate">
  230. <![CDATA[
  231. grd_viewlist.col = 2;
  232. // var vColWidth = "154, 100" ;
  233. var sViewCaption10 = "계정/부서^계정코드";
  234. var sViewCaption20 = "계정/부서^계정코드";
  235. var sViewNm = "";
  236. var sViewNm2 = "^전월^금월^증감율";
  237. // 계정/부서^계정코드|계정/부서^계정코드
  238. var vDept = "";
  239. for (var i = 1; i < 5 ; i++ ) {
  240. sViewNm = "^d"+ lpad(i , 3, "0");
  241. // vColWidth += "100, 100, 60" ;
  242. sViewCaption20 += sViewNm2;
  243. sViewCaption10 += sViewNm+sViewNm + sViewNm;
  244. grd_viewlist.insertColumn(2+i, "ref:b" + lpad(i , 3, "0")+";format=(-)#,### style=text-align:right;", "after", false);
  245. grd_viewlist.insertColumn(3+i, "ref:d" + lpad(i , 3, "0")+";format=(-)#,### style=text-align:right;", "after", false);
  246. grd_viewlist.insertColumn(4+i, "ref:p" + lpad(i , 3, "0")+";format=(-)#,### style=text-align:right;", "after", false);
  247. //grd_viewlist.colWidth( 4+i) ='60';
  248. }
  249. // grd_viewlist.colwidth = vColWidth;
  250. grd_viewlist.caption = sViewCaption10+"|"+ sViewCaption20;
  251. grd_viewlist.refresh();
  252. ]]>
  253. </script>
  254. </button>
  255. <button id="button4" visibility="hidden" style="left:430px; top:70px; width:55px; height:20px; ">
  256. <caption>delCol</caption>
  257. <script type="javascript" ev:event="DOMActivate">
  258. <![CDATA[
  259. if (grd_viewlist.cols < 3) return;
  260. alert("cols==>>"+grd_viewlist.cols );
  261. for (var i = grd_viewlist.cols-1; i > 2 ; i-- ) {
  262. grd_viewlist.deleteColumn(i);
  263. }
  264. grd_viewlist.refresh();
  265. ]]>
  266. </script>
  267. </button>
  268. <button id="button5" visibility="hidden" style="left:350px; top:70px; width:55px; height:20px; ">
  269. <caption>InsCol</caption>
  270. </button>
  271. <button id="button6" visibility="hidden" style="left:485px; top:70px; width:55px; height:20px; ">
  272. <caption>remCol</caption>
  273. <script type="javascript" ev:event="DOMActivate">
  274. <![CDATA[
  275. grd_viewlist.col= 3;
  276. grd_viewlist.removeColumn(true);
  277. ]]>
  278. </script>
  279. </button>
  280. </group>
  281. </xhtml:body>
  282. </xhtml:html>