123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206 |
- {Template header}
- <style>
- .btn {
- display: inline-block;
- padding: 6px 12px;
- margin-bottom: 0;
- font-size: 14px;
- font-weight: 400;
- line-height: 1.42857143;
- text-align: center;
- white-space: nowrap;
- vertical-align: middle;
- -ms-touch-action: manipulation;
- touch-action: manipulation;
- cursor: pointer;
- -webkit-user-select: none;
- -moz-user-select: none;
- -ms-user-select: none;
- user-select: none;
- background-image: none;
- border: 1px solid transparent;
- border-radius: 4px;
- }
- .btn-success {
- color: #fff !important;
- background-color: #5cb85c !important;
- border-color: #4cae4c;
- }
- .btn-info {
- color: #fff;
- background-color: #5bc0de;
- border-color: #46b8da;
- }
- .btn_warning{
- color: #fff;
- background-color: #f39c12 !important;
- border-color: #e08e0b !important;
- }
- .btn-xs {
- padding: 1px 5px;
- font-size: 12px;
- line-height: 1.5;
- border-radius: 3px;
- }
- </style>
- <body>
- <div class="warp">
- <div class="fixed">
- <form>
- <ul class="search">
- <li>订单号:<input value="" name="orderinfo" type="text" ></li>
- <li>编号:<input value="" name="number" type="text" ></li>
- <li>
- 店铺:
- <select name="shop" class="select">
- <option value="">选择店铺</option>
- {loop $shop_list as $key=>$val}
- <option value="{$key}">{$val}</option>
- {/loop}
- </select>
- </li>
- <li>
- 状态:
- <select name="status" class="select">
- <option value="">全部</option>
- <option value="30">待审核</option>
- </select>
- </li>
- <li>
- 售后类型:
- <select name="back_status" class="select">
- <option value="">选择售后类型</option>
- {loop $back_status_list as $key=>$val}
- <option value="{$key}">{$val}</option>
- {/loop}
- </select>
- </li>
- <li>
- 登记时间:
- <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'})">
- 至
- <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'})">
- </li>
- <li><span>确 定</span></li>
- </ul>
- </form>
- <div class="control">
- <a href="javascript:void(0);" class="btn btn_warning btn-xs" onclick="excelexport()">按条件导出</a>
- </div>
- <table class="datatitle data" border="0" style="border-collapse:collapse;">
- <tr>
- <td>
- <label onClick="swapCheck()"><input name="checkbox" type="checkbox" class="regular-checkbox"></label>
- </td>
- <td>订单号</td>
- <td>店铺</td>
- <td>编号</td>
- <td>状态</td>
- <td>登记原因</td>
- <td>售后类型</td>
- <td>重发单号</td>
- <td>退款金额</td>
- <td>登记时间</td>
- <td>操作</td>
- </tr>
- </table>
- </div>
- <table class="datatext data" border="0" style="border-collapse:collapse;">
- </table>
- <div class="bomf"></div>
- </div>
- <script>
- var dataurl = "/returngoods/caiwudata";
- function excelexport(){
- layx.load('loadId','请求中',{shadable:0.6});
- // return console.log($("form").serialize())
- let select_list = [];
- $("input[name=check]").each(function(){
- if($(this).prop('checked')){
- select_list.push($(this).val())
- }
- })
- let form_data = $("form").serialize();
- if(select_list.length > 0){
- form_data = {sid:select_list}
- }
- $.post("/returngoodsexcel/caiwuexcel",form_data,function(a){
- layx.destroy('loadId');
- if (a && a.success) {
- if (a.data.length > 0){
- $(".ts p").html(a.msg);
- $(".ts").fadeIn();
- const now = new Date();
- const dateString = now.toISOString().split('T')[0];
- const [year, month, day] = dateString.split('-');
- let filename = "售后登记清单"+year+month+day+".xlsx";
- explortExcel(a.data,filename)
- }else{
- $(".ts p").html("没有数据");
- $(".ts").fadeIn();
- }
- }else{
- $(".ts p").html(a.msg);
- $(".ts").fadeIn();
- }
- },'json')
- }
- function explortExcel(data,filename){
-
- let sheet = XLSX.utils.json_to_sheet(data)
- let workbook = XLSX.utils.book_new();
- sheet['!cols'] = [
- //订单号
- {
- wch:20,
- },
- //订单编码
- {
- wch:20,
- },
- //店铺名称
- {
- wch:18,
- },
- //状态
- {
- wch:15,
- },
- //登记原因
- {
- wch:25,
- },
-
- //售后类型
- {
- wch:15,
- },
- //重发单号
- {
- wch:20,
- },
- //退款金额
- {
- wch:10,
- },
-
- //登记时间
- {
- wch:21,
- }
-
-
- ];
- XLSX.utils.book_append_sheet(workbook, sheet, "Sheet1");
- XLSX.writeFile(workbook, filename);
- }
- </script>
- <script type="text/javascript" src="{$theme}js/excel/xlxs.js" ></script>
- <script type="text/javascript" src="{$theme}js/laydate.js"></script>
- {Template footer}
|