var pageCurr; var locNormalList = []; var locArea = []; function getCol() { var cols = []; cols.push( {field: 'createTime$', align: 'center', title: '出入库时间', width: 180} , {field: 'updateTime$', align: 'center', title: '修改时间', width: 180, hide: true} , {field: 'warehouse', align: 'center', title: '库区', width: 100} , {field: 'matnr', align: 'center', title: '物料编码', width: 140} , {field: 'maktx', align: 'center', title: '物料名称', width: 400} , {field: 'anfme', align: 'center', title: '数量', width: 120} , {field: 'lgnum', align: 'center', title: '规格', width: 120} , {field: 'type', align: 'center', title: '物料类别', width: 120} , {field: 'mnemonic', align: 'center', title: '生产单号', width: 140} , {field: 'supplier', align: 'center', title: '通知单号', width: 140} , {field: 'memo', align: 'center', title: '备注'} ) return cols; } layui.use(['table', 'laydate', 'form', 'upload'], function () { var table = layui.table; var $ = layui.jquery; var layer = layui.layer; var layDate = layui.laydate; var form = layui.form; var upload = layui.upload; // 库区下拉 // 获取仓库下拉 $.ajax({ url: baseUrl + "/locArea/query/allArea", headers: {'token': localStorage.getItem('token')}, method: 'POST', success: function (res) { if (res.code === 200) { var html = ""; if (res.data && res.data.length > 0) { locArea = res.data; html += res.data.map(function (item) { return ""; }); } $('#putSiteSelect').append(html); layui.form.render('select'); } else if (res.code === 403) { top.location.href = baseUrl + "/"; } else { layer.msg(res.msg) } } }); // 数据渲染 tableIns = table.render({ elem: '#locNormal', headers: {token: localStorage.getItem('token')}, url: baseUrl + '/locNomal/getInListByDay', where: { io_type: '1', }, page: true, limit: 16, limits: [16, 30, 50, 100, 200, 500], even: true, toolbar: '#toolbar', cellMinWidth: 50, cols: [getCol()], request: { pageName: 'curr', pageSize: 'limit' }, parseData: function (res) { // 解析库区名称 var records = res.data.records; records.map(function (item) { locArea.map(function (d) { if (d.uuid == item.warehouse) { item.warehouse = d.name; } }) }); return { 'code': res.code, 'msg': res.msg, 'count': res.data.total, 'data': res.data.records, } }, response: { statusCode: 200 }, done: function (res, curr, count) { if (res.code === 403) { top.location.href = baseUrl + "/"; } pageCurr = curr; limit(); // 当前分页数据存储 locNormalList = res.data; } }); // 搜索栏重置事件 form.on('submit(reset)', function (data) { pageCurr = 1; clearFormVal($('#search-box')); $("#io_type").val("1"); form.render(); tableReload(false); }); // 搜索栏搜索事件 form.on('submit(search)', function (data) { pageCurr = 1; tableReload(false); }); layDate.render({ elem: '.layui-laydate-range' , type: 'datetime' , range: true }); // 监听头工具栏事件 table.on('toolbar(locNormal)', function (obj) { switch(obj.event) { case 'exportData': layer.confirm('确定导出Excel吗', {shadeClose: true}, function(){ var titles=[]; var fields=[]; obj.config.cols[0].map(function (col) { if (col.type === 'normal' && col.hide === false && col.toolbar == null) { titles.push(col.title); fields.push(col.field); } }); var param = { fields: fields, exportData: locNormalList }; $.ajax({ url: baseUrl+"/locNomal/normalReportExport.action", headers: {'token': localStorage.getItem('token')}, data: JSON.stringify(param), dataType:'json', contentType:'application/json;charset=UTF-8', method: 'POST', success: function (res) { layer.closeAll(); if (res.code === 200) { table.exportFile(titles,res.data,'xls'); } else if (res.code === 403) { top.location.href = baseUrl+"/"; } else { layer.msg(res.msg) } } }); }); break; } }); }); /* 表格数据重载 */ function tableReload(child) { var searchData = {}; $.each($('#search-box [name]').serializeArray(), function () { searchData[this.name] = this.value; }); (child ? parent.tableIns : tableIns).reload({ where: searchData, page: { curr: pageCurr }, done: function (res, curr, count) { if (res.code === 403) { top.location.href = baseUrl + "/"; } pageCurr = curr; if (res.data.length === 0 && count !== 0) { tableIns.reload({ where: searchData, page: { curr: pageCurr - 1 } }); pageCurr -= 1; } limit(child); // 当前分页数据存储 locNormalList = res.data; } }); } /* 监听回车事件 */ $('body').keydown(function () { if (event.keyCode === 13) { $("#search").click(); } });