erp/template/erp/boss_qtcs.html

{Template header}
<style>
.new_bossok {
    width: 70px;
    height: 30px;
    line-height: 30px;
    background: #2ca8a1;
    text-align: center;
    color: #fff;
    border-radius: 5px;
    display: inline-block;
    margin-left: 20px;
    cursor: pointer;
}
</style>
<div class="warp">
<ul class="search bossspexcel" style="border-bottom: 1px solid #ccc;padding:16px 0" id="bossspexcel">
<p style="color:#F00;font-size: 18px;line-height:50px;">单次导出数据条数不可超过65535条！</p>
<p style="color:#333;font-size: 18px;line-height:50px;">按订单商品排列下载</p>
<li>
店铺：<select name="shop" class="select">
<option value="">请选择</option>
{loop usershop() as $val}
<option value="{$val['id']}">{$val['shopname']}</option>
{/loop}</select>
</select>
</li>
<li>
类型：<select name="category" class="select">
<option value="128">Wigs</option>
{loop typeclass(16) as $val}
{if $val['id'] != 128}
<option value="{$val['id']}">{$val['title']} - {$val['zh']}</option>
{/if}
{/loop}
<option value="">全部</option>
</select>
</li>
<li>
颜色：<select name="color" class="select">
<option value="">请选择</option>
<option value="57">Natural Black</option>
{loop typeclassyc(8) as $val}
{if $val['id'] != 57}
<option value="{$val['id']}">{$val['title']} - {$val['zh']}</option>
{/if}
{/loop}
</select>
</li>
<li>
等级：<select name="grade" class="select">
<option value="">请选择</option>
{loop typeclass(13) as $val}
<option value="{$val['id']}">{$val['title']} - {$val['zh']}</option>
{/loop}
</select>
</li>
<li>
曲度：<select name="lowe" class="select">
<option value="">请选择</option>
{loop typeclassyc(15) as $val}
<option value="{$val['id']}">{$val['title']} - {$val['zh']}</option>
{/loop}
</select>
</li>
<li>
密度：<select name="density" class="select">
<option value="">请选择</option>
{loop typeclassyc(10) as $val}
<option value="{$val['id']}">{$val['title']} - {$val['zh']}</option>
{/loop}
</select>
</li>
<li>
头套种类：<select name="lacetype" class="select">
<option value="">请选择</option>
{loop typeclassyc(18) as $val}
<option value="{$val['id']}">{$val['title']} - {$val['zh']}</option>
{/loop}
</select>
</li>
<li>
长度：<select name="size" class="select">
<option value="">请选择</option>
{loop typeclassyc(14) as $val} <!-- 这个是不显示部分曲度 -->
<option value="{$val['id']}">{$val['title']}</option>
{/loop}
</select>
</li>
<li>
仓库：<select name="warehouse" class="select">
<option value="">请选择</option>
{loop $wh as  $val} <!-- 这个是不显示部分曲度 -->
<option value="{$val['id']}">{$val['title']}</option>
{/loop}
</select>
</li>
<li><select name="time" class="select">
<option value="librarytime">出库时间</option>
<option value="dtime">订单时间</option>
</select> ：<input id="outk"  value="{date('Y-m-d',time()-30*24*3600)} 0:00" name="timetk" type="text" onClick="laydate({istime: true,format:'YYYY-MM-DD hh:mm'})" readonly>
至&nbsp;&nbsp;&nbsp;&nbsp; <input id="outj" value="{date('Y-m-d',time())} 23:59" name="timetj" type="text" onClick="laydate({istime: true,format:'YYYY-MM-DD hh:mm'})" readonly></li>
<li><font class="new_bossok" onclick="bossspexcel('bossspexcel')">下载结果</font></li>
</ul>

<ul class="search excellkh" style="border-bottom: 1px solid #ccc;padding:16px 0">
<p style="color:#333;font-size: 18px;line-height:50px;">下载老客户数据: <font style="color:#888;font-size: 16px;">数据仅包含店内订单。分母：店内全部订单，分子：购买次数大于1的店内订单</font></p>
<li>
店铺：<select name="shop" class="select">
<option value="">全部</option>
{loop usershop() as $val}
<option value="{$val['id']}">{$val['shopname']}</option>
{/loop}</select>
</select>
</li>
<li><select name="time" class="select">
<option value="dtime">订单时间</option>
</select> ：<input id="lkhk"  value="{date('Y-m-d',time()-24*3600)} 0:00" name="timetk" type="text" onClick="laydate({istime: true,format:'YYYY-MM-DD hh:mm'})" readonly>
至&nbsp;&nbsp;&nbsp;&nbsp; <input id="lkhj" value="{date('Y-m-d',time())} 23:59" name="timetj" type="text" onClick="laydate({istime: true,format:'YYYY-MM-DD hh:mm'})" readonly></li>
<li><font class="bossok" data-c="excellkh" data-u="excellkh" data-e="1">下载结果</font></li>
</ul>

<ul class="search excelshop" style="border-bottom: 1px solid #ccc;padding:16px 0">
<p style="color:#333;font-size: 18px;line-height:50px;">下载店铺数据: <font style="color:#888;font-size: 16px;">数据包含本店全部订单，含店内单和线下单。</font></p>
<li>
店铺：<select name="shop" class="select">
<option value="">全部</option>
{loop usershop() as $val}
<option value="{$val['id']}">{$val['shopname']}</option>
{/loop}</select>
</select>
</li>
<li><select name="time" class="select">
<option value="dtime">订单时间</option>
</select> ：<input id="outk"  value="{date('Y-m-d',time()-24*3600)} 0:00" name="timetk" type="text" onClick="laydate({istime: true,format:'YYYY-MM-DD hh:mm'})" readonly>
至&nbsp;&nbsp;&nbsp;&nbsp; <input id="outj" value="{date('Y-m-d',time())} 23:59" name="timetj" type="text" onClick="laydate({istime: true,format:'YYYY-MM-DD hh:mm'})" readonly></li>
<li><font class="bossok" data-c="excelshop" data-u="excelshop" data-e="1">下载结果</font></li>
</ul>

<ul class="search excelpass" style="border-bottom: 1px solid #ccc;padding:16px 0">
<p style="color:#333;font-size: 18px;line-height:50px;">Excel密码</p>
<li>Excel密码：<input value="{$excelpass}" name="excelpass" type="text"></li>
<li>每个账号每天使用解密次数：<input value="{$excelusernum}" name="excelusernum" type="text"></li>
<li>每个账号每次解密数量：<input value="{$exceljmnum}" name="exceljmnum" type="text"></li>
<li><font class="bossok" data-c="excelpass" data-u="setting">修改密码</font></li>
</ul>

<ul class="search dpay" style="border-bottom: 1px solid #ccc;padding:16px 0">
<p style="color:#333;font-size: 18px;line-height:50px;">调整费率</p>
<li>订单时间：<input id="outk"  value="{date('Y-m-d',time()-30*24*3600)} 0:00" name="timetk" type="text" onClick="laydate({istime: true,format:'YYYY-MM-DD hh:mm'})" readonly>
至&nbsp;&nbsp;&nbsp;&nbsp; <input id="outk" value="{date('Y-m-d',time())} 23:59" name="timetj" type="text" onClick="laydate({istime: true,format:'YYYY-MM-DD hh:mm'})" readonly></li>
<li>支付类型：<select name="pay" class="select" style="width:90px">
<option value="">请选择</option>
{loop typeclass(4,3) as $val}
<option value="{$val['id']}">{$val['title']}</option>
{/loop}
</select></li>
<li><font class="bossok" data-c="dpay" data-u="dpay">确定调整</font></li>
</ul>

<ul class="search sctime" style="border-bottom: 1px solid #ccc;padding:16px 0">
<p style="color:#333;font-size: 18px;line-height:50px;">订单时差</p>
<li>需要减去的时间（小时）：<input value="{$sctime}" name="sctime" type="text" style="width:150px;text-align: center;"></li>
<li><font class="bossok" data-c="sctime" data-u="sctime">确定</font></li>
</ul>
</div>
<script type="text/javascript" src="{$theme}js/laydate2.js"></script>
<script>
$("select[name='en']").change(function(){
    var index = $(this).find("option:selected").index();
	$(this).parent("li").find("select[name='zh'] option:eq("+index+")").prop('selected','selected'); 
	$(this).parent("li").find("select[name='hg'] option:eq("+index+")").prop('selected','selected'); 
 });
$("select[name='zh']").change(function(){
    var index = $(this).find("option:selected").index();
	$(this).parent("li").find("select[name='en'] option:eq("+index+")").prop('selected','selected'); 
	$(this).parent("li").find("select[name='hg'] option:eq("+index+")").prop('selected','selected'); 
 });
 $("select[name='hg']").change(function(){
    var index = $(this).find("option:selected").index();
	$(this).parent("li").find("select[name='zh'] option:eq("+index+")").prop('selected','selected'); 
	$(this).parent("li").find("select[name='en'] option:eq("+index+")").prop('selected','selected'); 
 });
 
 $(".sc").click(function() {
	 $(this).parent("li").remove();
 });
 
 $(".bossdpex").click(function() {
var f = {}; var i = 0;
 $(".dpexxq li").each(function() {
	 var v = {};
	 $(this).find('input').each(function() {
       v[$(this).attr("name")] = $(this).val();
    });
	$(this).find('.select').each(function() {
        v[$(this).attr("name")] = $(this).children("option:selected").val();
    });
	f[i] = v;
	i++;
 });
   var d = "n=" + $(".dpex input[name='number']").val() + "&postdata="+JSON.stringify(f);
   
        layx.load('loadId','处理中，请稍后');
        $.ajax({
        url: "/boss/dpex",
        data: d,
        type: "POST",
        dataType: "json",
        success: function(a) {
			layx.destroy('loadId');
            if (a && a.success) {
                $(".dpexyd").html(a.msg);
            } else {
               $(".express p:eq(0)").html(a.msg);
				$(".express p:eq(1)").html("<font class='esc'>确 定</font>");
                $(".express").show();
            }
        }
        });
	
});
 </script>
 <script>

    function bossspexcel(id_name){
        var f = "";
        $("."+id_name+" input:text").each(function() {
            var str2 = escape($(this).val());
            str2 = $(this).val().replace(/\</g,"&lt;");
            str2 = str2.replace(/\>/g,"&gt;");
            str2 = str2.replace(/\+/g,"%2B");
            str2 = str2.replace(/&/g,"%26");
        f = f + $(this).attr("name") + "=" + str2 + "&";
        });
        $("."+id_name+" .select").each(function() {
            f = f + $(this).attr("name") + "=" + $(this).children("option:selected").val() + "&";
        });
        let url = "/boss/spexceljs?"+f;
        $.get(url,function(res){
            if(res.code==0){
                layx.destroy('loadId');
                layx.confirm('提示',res.msg,null,{
                    buttons:[
                        {
                            label:'确定',
                            callback:function(id, button, event){
                            
                                layx.destroy(id);
                            }
                        }
                    ],dialogIcon:'error',shadable:0.6
                });
            }else{
                const fileName = res.filename+'.xlsx' ;
                // 将数据转换为工作表

                let  list = [];
                let  data = res.data;
                for(let item in data){
                    list.push({
                        "名称":data[item].t,
                        "中文":data[item].z,
                        "类型":data[item].c,
                        "SKU":data[item].w,
                        "用友料号":data[item].j,
                        "数量":data[item].n*1,
                        "许昌仓发货量":data[item].xcc*1,
                        "美仓发货量":data[item].mc*1,
                        "定制仓发货量":data[item].dzc*1,
                        "其他仓发货量":data[item].qtc*1,
                    })
                }
                const worksheet = XLSX.utils.json_to_sheet(list);
                // 创建工作簿
                const workbook = XLSX.utils.book_new();
            
                worksheet['!cols'] = 
                [
                    { wch: 80 }, 
                    { wch: 80 },  
                    { wch: 20 },  
                    { wch: 20 },  
                    { wch: 20 },  
                    { wch: 10 },  
                    { wch: 10 },
                    { wch: 10 },
                    { wch: 10 },
                    { wch: 10 },
                ];
                // 将工作表添加到工作簿
                XLSX.utils.book_append_sheet(workbook, worksheet, res.filename);
                
                // 导出文件
                XLSX.writeFile(workbook, fileName);
                layx.destroy('loadId');
            }
        },'json')
    }
    function bossspexcelbak(id_name){
        let obj = {}
        let shop = $("select[name='shop']").val();
        if(shop){
            obj.shop = shop;
        }
        let category = $("select[name='category']").val();
        if(category){
            obj.category = category;
        }
        let color = $("select[name='color']").val();
        if(color){
            obj.color = color;
        }
        let grade = $("select[name='grade']").val();
        if(grade){
            obj.grade = grade;
        }
        let lowe = $("select[name='lowe']").val();
        if(lowe){
            obj.lowe = lowe;
        }
        let density = $("select[name='density']").val();
        if(density){
            obj.density = density;
        }
        let lacetype = $("select[name='lacetype']").val();
        if(lacetype){
            obj.lacetype = lacetype;
        }
        let size = $("select[name='size']").val();
        if(size){
            obj.size = size;
        }
        let warehouse = $("select[name='warehouse']").val();
        if(warehouse){
            obj.warehouse = warehouse;
        }
        let time = $("select[name='time']").val();
        if(time){
            obj.time = time;
        }
        let timetk = $("input[name='timetk']").val();
        if(timetk){
            obj.timetk = timetk;
        }
        let timetj = $("input[name='timetj']").val();
        if(timetj){
            obj.timetj = timetj;
        }
        layx.load('loadId','处理中，请稍后');
        $.post("/boss/spexceljs",obj,function(res){
            if(res.code==0){
                layx.destroy('loadId');
                layx.confirm('提示',res.msg,null,{
                    buttons:[
                        {
                            label:'确定',
                            callback:function(id, button, event){
                            
                                layx.destroy(id);
                            }
                        }
                    ],dialogIcon:'error',shadable:0.6
                });
            }else{
                const fileName = res.filename+'.xlsx' ;
                // 将数据转换为工作表

                let  list = [];
                let  data = res.data;
                for(let item in data){
                    list.push({
                        "名称":data[item].t,
                        "中文":data[item].z,
                        "类型":data[item].c,
                        "SKU":data[item].w,
                        "用友料号":data[item].j,
                        "数量":data[item].n*1,
                        "许昌仓发货量":data[item].xcc*1,
                        "美仓发货量":data[item].mc*1,
                        "定制仓发货量":data[item].dzc*1,
                        "其他仓发货量":data[item].qtc*1,
                    })
                }
                const worksheet = XLSX.utils.json_to_sheet(list);
                // 创建工作簿
                const workbook = XLSX.utils.book_new();
            
                worksheet['!cols'] = 
                [
                    { wch: 80 }, 
                    { wch: 80 },  
                    { wch: 20 },  
                    { wch: 20 },  
                    { wch: 20 },  
                    { wch: 10 },  
                    { wch: 10 },
                    { wch: 10 },
                    { wch: 10 },
                    { wch: 10 },
                ];
                // 将工作表添加到工作簿
                XLSX.utils.book_append_sheet(workbook, worksheet, res.filename);
                
                // 导出文件
                XLSX.writeFile(workbook, fileName);
                layx.destroy('loadId');
            }
        },'json')
    }
 </script>
 <script type="text/javascript" src="{$theme}js/excel/xlxs.js" ></script>
{Template footer}