returngoods_caiwu.html 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206
  1. {Template header}
  2. <style>
  3. .btn {
  4. display: inline-block;
  5. padding: 6px 12px;
  6. margin-bottom: 0;
  7. font-size: 14px;
  8. font-weight: 400;
  9. line-height: 1.42857143;
  10. text-align: center;
  11. white-space: nowrap;
  12. vertical-align: middle;
  13. -ms-touch-action: manipulation;
  14. touch-action: manipulation;
  15. cursor: pointer;
  16. -webkit-user-select: none;
  17. -moz-user-select: none;
  18. -ms-user-select: none;
  19. user-select: none;
  20. background-image: none;
  21. border: 1px solid transparent;
  22. border-radius: 4px;
  23. }
  24. .btn-success {
  25. color: #fff !important;
  26. background-color: #5cb85c !important;
  27. border-color: #4cae4c;
  28. }
  29. .btn-info {
  30. color: #fff;
  31. background-color: #5bc0de;
  32. border-color: #46b8da;
  33. }
  34. .btn_warning{
  35. color: #fff;
  36. background-color: #f39c12 !important;
  37. border-color: #e08e0b !important;
  38. }
  39. .btn-xs {
  40. padding: 1px 5px;
  41. font-size: 12px;
  42. line-height: 1.5;
  43. border-radius: 3px;
  44. }
  45. </style>
  46. <body>
  47. <div class="warp">
  48. <div class="fixed">
  49. <form>
  50. <ul class="search">
  51. <li>订单号:<input value="" name="orderinfo" type="text" ></li>
  52. <li>编号:<input value="" name="number" type="text" ></li>
  53. <li>
  54. 店铺:
  55. <select name="shop" class="select">
  56. <option value="">选择店铺</option>
  57. {loop $shop_list as $key=>$val}
  58. <option value="{$key}">{$val}</option>
  59. {/loop}
  60. </select>
  61. </li>
  62. <li>
  63. 状态:
  64. <select name="status" class="select">
  65. <option value="">全部</option>
  66. <option value="30">待审核</option>
  67. </select>
  68. </li>
  69. <li>
  70. 售后类型:
  71. <select name="back_status" class="select">
  72. <option value="">选择售后类型</option>
  73. {loop $back_status_list as $key=>$val}
  74. <option value="{$key}">{$val}</option>
  75. {/loop}
  76. </select>
  77. </li>
  78. <li>
  79. 登记时间:
  80. <input id="ktime" value="{date('Y-m-d',time()-30*24*3600)} 0:00" name="ktime" type="text" onClick="laydate({istime: true,format:'YYYY-MM-DD hh:mm'})">
  81. 至&nbsp;&nbsp;&nbsp;&nbsp;
  82. <input id="jtime" value="{date('Y-m-d',time()+24*3600)} 0:00" name="jtime" type="text" onClick="laydate({istime: true,format:'YYYY-MM-DD hh:mm'})">
  83. </li>
  84. <li><span>确 定</span></li>
  85. </ul>
  86. </form>
  87. <div class="control">
  88. <a href="javascript:void(0);" class="btn btn_warning btn-xs" onclick="excelexport()">按条件导出</a>
  89. </div>
  90. <table class="datatitle data" border="0" style="border-collapse:collapse;">
  91. <tr>
  92. <td>
  93. <label onClick="swapCheck()"><input name="checkbox" type="checkbox" class="regular-checkbox"></label>
  94. </td>
  95. <td>订单号</td>
  96. <td>店铺</td>
  97. <td>编号</td>
  98. <td>状态</td>
  99. <td>登记原因</td>
  100. <td>售后类型</td>
  101. <td>重发单号</td>
  102. <td>退款金额</td>
  103. <td>登记时间</td>
  104. <td>操作</td>
  105. </tr>
  106. </table>
  107. </div>
  108. <table class="datatext data" border="0" style="border-collapse:collapse;">
  109. </table>
  110. <div class="bomf"></div>
  111. </div>
  112. <script>
  113. var dataurl = "/returngoods/caiwudata";
  114. function excelexport(){
  115. layx.load('loadId','请求中',{shadable:0.6});
  116. // return console.log($("form").serialize())
  117. let select_list = [];
  118. $("input[name=check]").each(function(){
  119. if($(this).prop('checked')){
  120. select_list.push($(this).val())
  121. }
  122. })
  123. let form_data = $("form").serialize();
  124. if(select_list.length > 0){
  125. form_data = {sid:select_list}
  126. }
  127. $.post("/returngoodsexcel/caiwuexcel",form_data,function(a){
  128. layx.destroy('loadId');
  129. if (a && a.success) {
  130. if (a.data.length > 0){
  131. $(".ts p").html(a.msg);
  132. $(".ts").fadeIn();
  133. const now = new Date();
  134. const dateString = now.toISOString().split('T')[0];
  135. const [year, month, day] = dateString.split('-');
  136. let filename = "售后登记清单"+year+month+day+".xlsx";
  137. explortExcel(a.data,filename)
  138. }else{
  139. $(".ts p").html("没有数据");
  140. $(".ts").fadeIn();
  141. }
  142. }else{
  143. $(".ts p").html(a.msg);
  144. $(".ts").fadeIn();
  145. }
  146. },'json')
  147. }
  148. function explortExcel(data,filename){
  149. let sheet = XLSX.utils.json_to_sheet(data)
  150. let workbook = XLSX.utils.book_new();
  151. sheet['!cols'] = [
  152. //订单号
  153. {
  154. wch:20,
  155. },
  156. //订单编码
  157. {
  158. wch:20,
  159. },
  160. //店铺名称
  161. {
  162. wch:18,
  163. },
  164. //状态
  165. {
  166. wch:15,
  167. },
  168. //登记原因
  169. {
  170. wch:25,
  171. },
  172. //售后类型
  173. {
  174. wch:15,
  175. },
  176. //重发单号
  177. {
  178. wch:20,
  179. },
  180. //退款金额
  181. {
  182. wch:10,
  183. },
  184. //登记时间
  185. {
  186. wch:21,
  187. }
  188. ];
  189. XLSX.utils.book_append_sheet(workbook, sheet, "Sheet1");
  190. XLSX.writeFile(workbook, filename);
  191. }
  192. </script>
  193. <script type="text/javascript" src="{$theme}js/excel/xlxs.js" ></script>
  194. <script type="text/javascript" src="{$theme}js/laydate.js"></script>
  195. {Template footer}