DailyTradingForm.html 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214
  1. <!DOCTYPE html>
  2. <html lang="ko"
  3. xmlns:th="http://www.thymeleaf.org">
  4. <!--
  5. *******************************************************************************
  6. * @source : DailyTradingForm.html
  7. * @desc : 일일거래내역 Page
  8. *============================================================================
  9. * STYLE24
  10. * Copyright(C) 2020 TSIT, All rights reserved.
  11. *============================================================================
  12. * VER DATE AUTHOR DESCRIPTION
  13. * === =========== ========== =============================================
  14. * 1.0 2021.08.31 gagamel 최초 작성
  15. *******************************************************************************
  16. -->
  17. <div id="main">
  18. <!-- 메인타이틀 영역 -->
  19. <div class="main-title">
  20. </div>
  21. <!-- //메인타이틀 영역 -->
  22. <!-- 메뉴 설명 -->
  23. <div class="infoBox menu-desc">
  24. </div>
  25. <!-- //메뉴 설명 -->
  26. <!-- 검색조건 영역 -->
  27. <div class="panelStyle">
  28. <form id="searchForm" name="searchForm" action="#" th:action="@{'/statistics/daily/trading/list'}" onsubmit="$('#btnSearch').trigger('click'); return false;">
  29. <table class="frmStyle" aria-describedby="검색조건">
  30. <colgroup>
  31. <col style="width:10%;"/>
  32. <col/>
  33. </colgroup>
  34. <tr>
  35. <th>발생일<i class="required" title="필수" aria-hidden="true"></i></th>
  36. <td>
  37. <input type="text" class="schDate w80" name="occurDt" maxlength="10" th:value="${#calendars.format(#calendars.createNow(), 'yyyy-MM-dd')}" required="required" data-valid-type="calendar" data-valid-name="발생일"/>
  38. </td>
  39. </tr>
  40. </table>
  41. <ul class="panelBar">
  42. <li class="center">
  43. <button type="button" class="btn btn-base btn-lg" id="btnSearch">조회</button>
  44. </li>
  45. </ul>
  46. </form>
  47. </div>
  48. <!-- 검색조건 영역 -->
  49. <!-- 리스트 영역 -->
  50. <div class="panelStyle">
  51. <!-- 버튼 배치 영역 -->
  52. <ul class="panelBar">
  53. <li class="left">
  54. <span class="infoTxt cBlue">* 항목 설명</span>
  55. <!-- 아이콘 툴팁 -->
  56. <div class="iconTooltip marL10">
  57. <i class="fa fa-info" aria-hidden="true"></i>
  58. <span class="left" style="width: 600px;">
  59. <strong>1.판매구분</strong>: 판매, 취소, 품절, 반품, 교환<br/>
  60. <strong>2.판매금액</strong>: 판매가 * 판매수량<br/>
  61. <strong>3.쿠폰할인금액</strong>: 즉시할인쿠폰금액 + 상품쿠폰할인금액 <br/>
  62. <strong>4.수수료</strong>: 실판매금액(쿠폰할인금액과 다다익선할인금액만 차감. 포인트와 상품권은 포함) * 판매수수료율(%)<br/>
  63. </span>
  64. </div>
  65. <!-- //아이콘 툴팁 -->
  66. </li>
  67. <li class="right">
  68. <button type="button" class="btn btn-default btn-lg" id="btnExcel">엑셀다운로드</button>
  69. </li>
  70. </ul>
  71. <!-- //버튼 배치 영역 -->
  72. <div id="gridList" style="width: 100%; height: 470px" class="ag-theme-balham"></div>
  73. </div>
  74. <!-- //리스트 영역 -->
  75. </div>
  76. <script th:inline="javascript">
  77. /*<![CDATA[*/
  78. let columnDefs = [
  79. { headerName: "주문번호", field: "ordNo", width: 100, cellClass: 'text-center' },
  80. { headerName: "주문상세번호", field: "ordDtlNo", width: 150, cellClass: 'text-center' },
  81. { headerName: "판매구분", field: "sellGb", width: 80, cellClass: 'text-center' },
  82. { headerName: "몰구분", field: "mallGbNm", width: 100, cellClass: 'text-center' },
  83. { headerName: "제휴몰주문번호", field: "extmallOrderId", width: 150, cellClass: 'text-center' },
  84. { headerName: "제휴몰명", field: "extmallNm", width: 150, cellClass: 'text-center' },
  85. { headerName: "상위제휴채널", field: "afChannelNm", width: 150, cellClass: 'text-center' },
  86. { headerName: "제휴채널", field: "afLinkNm", width: 150, cellClass: 'text-center' },
  87. { headerName: "유통구분", field: "distributionGbNm", width: 100, cellClass: 'text-center'},
  88. { headerName: "공급업체", field: "supplyCompNm", width: 150, cellClass: 'text-center' },
  89. { headerName: "공급벤더", field: "supplyVendorNm", width: 150, cellClass: 'text-center' },
  90. { headerName: "주문일시", field: "ordDt", width: 150, cellClass: 'text-center' },
  91. { headerName: "발생일시", field: "occurDt", width: 150, cellClass: 'text-center' },
  92. { headerName: "브랜드", field: "brandEnm", width: 100, cellClass: 'text-center' },
  93. { headerName: "상품코드", field: "goodsCd", width: 120, cellClass: 'text-center' },
  94. { headerName: "상품명", field: "goodsNm", width: 300 },
  95. { headerName: "단품코드", field: "itemCd", width: 120, cellClass: 'text-center' },
  96. { headerName: "옵션1", field: "optCd1", width: 100, cellClass: 'text-center' },
  97. { headerName: "옵션2", field: "optCd2", width: 100, cellClass: 'text-center' },
  98. {
  99. headerName: "품목", field: "itemkindNm", width: 200,
  100. cellRenderer: function (params) { return gagajf.isNull(params.value) ? '' : params.value.replaceAll('&gt;','>'); }
  101. },
  102. { headerName: "품목1", field: "itemkindNm1", width: 100 },
  103. { headerName: "품목2", field: "itemkindNm2", width: 100 },
  104. { headerName: "품목3", field: "itemkindNm3", width: 100 },
  105. { headerName: "품목4", field: "itemkindNm4", width: 100 },
  106. {
  107. headerName: "판매가", field: "sellPrice", width: 100, cellClass: 'text-right',
  108. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  109. },
  110. {
  111. headerName: "판매수량", field: "sellQty", width: 100, cellClass: 'text-center',
  112. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); },
  113. cellStyle : function(params) { if (Number(params.value) < 0) return { 'color' : 'red' } }
  114. },
  115. {
  116. headerName: "판매금액", field: "sellAmt", width: 100, cellClass: 'text-right',
  117. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); },
  118. cellStyle : function(params) { if (Number(params.value) < 0) return { 'color' : 'red' } }
  119. },
  120. {
  121. headerName: "쿠폰할인금액", field: "cpnDcAmt", width: 120, cellClass: 'text-right',
  122. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.data.cpn1DcAmt + params.data.goodsCpnDcAmt); }
  123. },
  124. {
  125. headerName: "즉시사용쿠폰금액", field: "cpn1DcAmt", width: 120, cellClass: 'text-right',
  126. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  127. },
  128. {
  129. headerName: "상품쿠폰사용금액", field: "goodsCpnDcAmt", width: 120, cellClass: 'text-right',
  130. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  131. },
  132. {
  133. headerName: "주문서쿠폰사용금액", field: "cartCpnDcAmt", width: 130, cellClass: 'text-right',
  134. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  135. },
  136. {
  137. headerName: "포인트사용금액", field: "pntDcAmt", width: 120, cellClass: 'text-right',
  138. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  139. },
  140. {
  141. headerName: "다다익선할인금액", field: "tmtbDcAmt", width: 120, cellClass: 'text-right',
  142. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  143. },
  144. {
  145. headerName: "자사다다익선분담액", field: "selfTmtbDcAmt", width: 150, cellClass: 'text-right',
  146. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  147. },
  148. {
  149. headerName: "입점다다익선분담액", field: "supplyCompTmtbDcAmt", width: 150, cellClass: 'text-right',
  150. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  151. },
  152. {
  153. headerName: "상품권사용금액", field: "gfcdUseAmt", width: 120, cellClass: 'text-right',
  154. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  155. },
  156. {
  157. headerName: "자사쿠폰분담액", field: "selfCpnDcAmt", width: 120, cellClass: 'text-right',
  158. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  159. },
  160. {
  161. headerName: "입점쿠폰분담액", field: "supplyCompCpnDcAmt", width: 120, cellClass: 'text-right',
  162. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  163. },
  164. {
  165. headerName: "실판매가", field: "realSellPrice", width: 100, cellClass: 'text-right',
  166. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); }
  167. },
  168. {
  169. headerName: "실판매금액", field: "realSellAmt", width: 100, cellClass: 'text-right',
  170. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); },
  171. cellStyle : function(params) { if (Number(params.value) < 0) return { 'color' : 'red' } }
  172. },
  173. {
  174. headerName: "수수료율(%)", field: "sellFeeRate", width: 120, cellClass: 'text-center',
  175. cellRenderer: function (params) { return params.value + '%'; }
  176. },
  177. {
  178. headerName: "수수료", field: "sellFeeAmt", width: 100, cellClass: 'text-right',
  179. cellRenderer: function (params) { return gagaAgGrid.toAddComma(params.value); },
  180. cellStyle : function(params) { if (Number(params.value) < 0) return { 'color' : 'red' } }
  181. },
  182. { headerName: "담당MD", field: "mdNm", width: 100, cellClass: 'text-center' },
  183. ];
  184. let gridOptions = gagaAgGrid.getGridOptions(columnDefs);
  185. // 검색
  186. $('#btnSearch').on('click', function() {
  187. // 입력 값 체크
  188. if (!gagajf.validation($('#searchForm')))
  189. return false;
  190. gagaAgGrid.fetch($('#searchForm').prop('action'), gridOptions, '#searchForm');
  191. });
  192. // 엑셀다운로드
  193. $('#btnExcel').on('click', function() {
  194. gagaAgGrid.exportToExcel('일일거래내역', gridOptions);
  195. });
  196. $(document).ready(function() {
  197. // Create a agGrid
  198. gagaAgGrid.createGrid('gridList', gridOptions);
  199. });
  200. /*]]>*/
  201. </script>
  202. </html>