chengwenliang
/
erp


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101
							{Template header}
<body>
<div class="warp">
<div class="fixed">
<form >
<ul class="search">

<li>手机号：<input value="" name="mobile" type="text" ></li>
<li>持有人：<input value="" name="mobile_user" type="text" ></li>
<li>
    部门：
    <select name="depart_id" class="select">
            <option value="">选择部门</option>
            {loop $depart_list as $key=>$val}
            <option value="{$key}">{$val}</option>
            {/loop}
    </select>
</li>
<li>
    组别：
    <select name="type_id" class="select">
            <option value="">选择组别</option>
            {loop $type_list as $key=>$val}
            <option value="{$key}">{$val}</option>
            {/loop}
    </select>
</li>
<li>
    店铺：
    <select name="shop_id" class="select">
            <option value="">选择店铺</option>
            {loop $shop_list as $key=>$val}
            <option value="{$key}">{$val}</option>
            {/loop}
    </select>
</li>
<li>
    平台：
    <select name="plat_id" class="select">
            <option value="">选择平台</option>
            {loop $plat_list as $key=>$val}
            <option value="{$key}">{$val}</option>
            {/loop}
    </select>
</li>
<li><span>确 定</span></li>
</ul>
</form>
<div class="control">
<a href="javascript:void(0);" class="window" data-h="/devicemaster/add/" data-t="用户管理 - 添加">添 加</a>
<a href="javascript:void(0);" class="check">删 除</a>
<a href="javascript:void(0);" class="export_excel">按条件导出</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>ID账号</td>
<td>ID密码</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 src="{$theme}js/excel/xlxs.js"></script>
<script>
var dataurl = "/devicemaster";
var editurl = "/devicemaster/edit/";
var editdj = 1;
var editt = "用户管理 - 修改";

$(".export_excel").on("click",function(){
    $.post("/devicemaster/indexexcel",$("form").serialize(),function(res){
        console.log(res)
        explortExcel(res.data,"设备信息.xlsx");
    },'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>
{Template footer}