SPPAE00203_마감현황.xrw 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187
  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. <magmlist>
  11. <magminfo>
  12. <rcptexecdd/>
  13. <rcptrcnt/>
  14. <rcptcnt/>
  15. <magmflag/>
  16. <magmcnt/>
  17. <aprvflag/>
  18. <aprvcnt/>
  19. <mrflag/>
  20. <mrcnt/>
  21. <cashamt/>
  22. <cardamt/>
  23. <onlineamt/>
  24. <suipamt/>
  25. <uncoamt/>
  26. <aprv2flag/>
  27. <aprv2/>
  28. <aprv3flag/>
  29. <aprv3/>
  30. </magminfo>
  31. </magmlist>
  32. </main>
  33. <send>
  34. <fromdd/>
  35. <todd/>
  36. <enddd/>
  37. </send>
  38. <report>
  39. <prtinfo>
  40. <instcd/>
  41. <fromdd/>
  42. <todd/>
  43. <prtdt/>
  44. </prtinfo>
  45. </report>
  46. </root>
  47. </instance>
  48. <submission id="TRPAE00203" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/magmlist/magminfo"/>
  49. <submission id="TRPAE00107" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/report/prtinfo"/>
  50. </model>
  51. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  52. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  53. <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
  54. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  55. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  56. <script type="javascript" ev:event="xforms-ready">
  57. <![CDATA[
  58. var fromdd = getCurrentDate().toDate().getAddDate(-1).getDateFormat();
  59. model.setValue("/root/send/fromdd", fromdd);
  60. model.setValue("/root/send/todd", fromdd);
  61. ipt_fromdd.refresh();
  62. ipt_todd.refresh();
  63. ]]>
  64. </script>
  65. </xhtml:head>
  66. <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  67. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:142px; height:14px; ">일일 마감관리 현황</caption>
  68. <shape id="roundrect1" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:0px; top:20px; width:1195px; height:40px; "/>
  69. <button id="btn_search" class="btn1_letter2" navindex="3" style="left:1125px; top:29px; width:56px; height:22px; background-image:../../../com/commonweb/images/btn1_letter2.gif; ">
  70. <caption>조회</caption>
  71. <script type="javascript" ev:event="DOMActivate">
  72. <![CDATA[
  73. var dd = getDateInterval(model.getValue("/root/send/fromdd"), model.getValue("/root/send/todd"), "mm");
  74. if (dd > 5) {
  75. messageBox("6개월 이상은 조회할 수 없습니다.", "E999");
  76. return;
  77. }
  78. submit("TRPAE00203");
  79. grd_magm.rebuildStyle();
  80. var path = "/root/main/magmlist/magminfo";
  81. var cnt = instance1.selectNodes(path).length;
  82. var bcol = "#ffffb4";
  83. for (var i = 1; i <= cnt; i++) {
  84. if (model.getValue(path + "[" + i + "]/magmflag") == "Y") {
  85. grd_magm.cellStyle("background-color", i, grd_magm.colRef("magmcnt")) = bcol;
  86. grd_magm.cellStyle("font-weight", i, grd_magm.colRef("magmcnt")) = "bold";
  87. grd_magm.cellStyle("color", i, grd_magm.colRef("magmcnt")) = "crimson";
  88. }
  89. if (model.getValue(path + "[" + i + "]/aprvflag") == "Y") {
  90. grd_magm.cellStyle("background-color", i, grd_magm.colRef("aprvcnt")) = bcol;
  91. grd_magm.cellStyle("font-weight", i, grd_magm.colRef("aprvcnt")) = "bold";
  92. grd_magm.cellStyle("color", i, grd_magm.colRef("aprvcnt")) = "blue";
  93. }
  94. if (model.getValue(path + "[" + i + "]/mrflag") == "Y") {
  95. grd_magm.cellStyle("background-color", i, grd_magm.colRef("mrcnt")) = bcol;
  96. grd_magm.cellStyle("font-weight", i, grd_magm.colRef("mrcnt")) = "bold";
  97. grd_magm.cellStyle("color", i, grd_magm.colRef("mrcnt")) = "darkmagenta";
  98. }
  99. if (model.getValue(path + "[" + i + "]/aprv2flag") == "Y") {
  100. grd_magm.cellStyle("background-color", i, grd_magm.colRef("aprv2")) = bcol;
  101. grd_magm.cellStyle("font-weight", i, grd_magm.colRef("aprv2")) = "bold";
  102. grd_magm.cellStyle("color", i, grd_magm.colRef("aprv2")) = "darkblue";
  103. }
  104. if (model.getValue(path + "[" + i + "]/aprv3flag") == "Y") {
  105. grd_magm.cellStyle("background-color", i, grd_magm.colRef("aprv3")) = bcol;
  106. grd_magm.cellStyle("font-weight", i, grd_magm.colRef("aprv3")) = "bold";
  107. grd_magm.cellStyle("color", i, grd_magm.colRef("aprv3")) = "darkblue";
  108. }
  109. if (model.getValue(path + "[" + i + "]/aprv4flag") == "Y") {
  110. grd_magm.cellStyle("background-color", i, grd_magm.colRef("aprv4")) = bcol;
  111. grd_magm.cellStyle("font-weight", i, grd_magm.colRef("aprv4")) = "bold";
  112. grd_magm.cellStyle("color", i, grd_magm.colRef("aprv4")) = "darkblue";
  113. }
  114. }
  115. ]]>
  116. </script>
  117. </button>
  118. <caption id="caption35" class="search_name" style="left:5px; top:31px; width:90px; height:17px; ">마감일자 :</caption>
  119. <input id="ipt_fromdd" ref="/root/send/fromdd" navindex="1" inputtype="date" style="left:97px; top:30px; width:90px; height:19px; "/>
  120. <caption id="caption4" style="left:189px; top:34px; width:15px; height:15px; text-align:center; ">~</caption>
  121. <input id="ipt_todd" ref="/root/send/todd" navindex="2" inputtype="date" style="left:205px; top:30px; width:90px; height:19px; "/>
  122. <line id="line14" class="line_4" style="x1:1110px; y1:28px; x2:1110px; y2:53px; font-family:돋움체; border-color:#ffd799; "/>
  123. <caption id="caption77" class="tit_2" style="left:0px; top:70px; width:105px; height:14px; ">마감 내역</caption>
  124. <datagrid id="grd_magm" nodeset="/root/main/magmlist/magminfo" backcoloralternate="transparent" caption="수납일^수납자수^수납건수^magmflag^마감^aprvflag^결제^mrflag^마감후수납^현금^카드^온라인^수입 합계^미수^aprv2flag^담당자결재^aprv3flag^팀장결재^aprv4flag^부서장결재" colsep="^" colwidth="80, 60, 0, 0, 70, 0, 70, 0, 75, 90, 90, 90, 90, 90, 0, 125, 0, 125, 0, 125" extendlastcol="scroll" focuscolor="transparent" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:90px; width:1195px; height:690px; ">
  125. <col ref="rcptexecdd" format="yyyy-mm-dd" style="text-align:center; "/>
  126. <col ref="rcptrcnt" format="#,###" style="text-align:center; "/>
  127. <col ref="rcptcnt" format="#,###" style="text-align:center; "/>
  128. <col ref="magmflag"/>
  129. <col ref="magmcnt" style="text-align:center; "/>
  130. <col ref="aprvflag"/>
  131. <col ref="aprvcnt" style="text-align:center; "/>
  132. <col ref="mrflag"/>
  133. <col ref="mrcnt" style="text-align:center; "/>
  134. <col ref="cashamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  135. <col ref="cardamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  136. <col ref="onlineamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  137. <col ref="suipamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  138. <col ref="uncoamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  139. <col ref="aprv2flag"/>
  140. <col ref="aprv2" style="text-align:center; "/>
  141. <col ref="aprv3flag"/>
  142. <col ref="aprv3" style="text-align:center; "/>
  143. <col ref="aprv4flag"/>
  144. <col ref="aprv4" style="text-align:center; "/>
  145. </datagrid>
  146. <button id="btn_xls" class="btn2_letter2" style="left:1153px; top:65px; width:42px; height:19px; ">
  147. <caption>엑셀</caption>
  148. <script type="javascript" ev:event="DOMActivate">
  149. <![CDATA[
  150. var days = model.getValue("/root/send/fromdd") + "-" + model.getValue("/root/send/todd");
  151. var file = window.fileDialog("save", "", "false", "마감 현황_" + days, "xls", "Excel Files(*.xls)|*.xls");
  152. grd_magm.saveExcel(file);
  153. ]]>
  154. </script>
  155. </button>
  156. <line id="line_comp" class="line_1" style="x1:0px; y1:85px; x2:1195px; y2:85px; "/>
  157. <button id="btn_prt" class="btn2_letter2" style="left:1110px; top:65px; width:42px; height:19px; ">
  158. <caption>출력</caption>
  159. <script type="javascript" ev:event="DOMActivate">
  160. <![CDATA[
  161. model.setValue("/root/send/enddd", model.getValue("/root/send/fromdd"));
  162. submit("TRPAE00107", false);
  163. model.makeValue("/root/report/prtinfo/fromdd", model.getValue("/root/send/fromdd"));
  164. model.makeValue("/root/report/prtinfo/todd", model.getValue("/root/send/todd"));
  165. exeReportPreview("RPPAE00104", "XMLSTR");
  166. ]]>
  167. </script>
  168. </button>
  169. </xhtml:body>
  170. </xhtml:html>