chengwenliang
/
erp


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
							{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="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()-10*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())
   $.post("/returngoodsexcel/caiwuexcel",$("form").serialize(),function(a){
        layx.destroy('loadId');
            if (a && a.success) {
                if (a.data.length > 0){
                    $(".ts p").html(a.msg);
                    $(".ts").fadeIn();
                    explortExcel(a.data,"退货单列表.xlsx")
                }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();
    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}