chengwenliang
/
erp


			
							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'})">
    至&nbsp;&nbsp;&nbsp;&nbsp; 
    <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}