var pageCurr = 1; var limit = 16; function getCol() { var cols = []; cols.push( {field: 'orderCode', align: 'center', title: '订单编号'} , {field: 'orderDate', align: 'center', title: '订单日期'} , {field: 'invCode', align: 'center', title: '物料编码'} , {field: 'invName', align: 'center', title: '物料名称'} , {field: 'invStd', align: 'center', title: '规格型号'} , {field: 'invUnit', align: 'center', title: '单位'} , {field: 'orderQty', align: 'center', title: '订单数量'} , {field: 'izMrp', align: 'center', title: '是否mrp计算', hide: true} , {field: 'productQty', align: 'center', title: '生产任务单数量'} , {field: 'izReceive', align: 'center', title: '是否收料', hide: true} , {field: 'inQty', align: 'center', title: '产成品入库数量'} , {field: 'outQty', 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; // 数据渲染 tableIns = table.render({ elem: '#salesOrder', headers: {token: localStorage.getItem('token')}, url: 'http://192.168.0.253:8073/api/report/getorderreport', // where: { // orderCode: 'NX5288', // startTime: '2021-01-01', // endTime: '2021-01-01', // }, page: true, limit: limit, limits: [16, 50, 100, 200, 500], even: true, toolbar: '#toolbar', cellMinWidth: 50, cols: [getCol()], request: { pageName: 'curr', pageSize: 'limit' }, parseData: function (res) { 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; } }); // 搜索栏重置事件 form.on('submit(reset)', function (data) { pageCurr = 1; clearFormVal($('#search-box')); debugger tableReload(false); }); // 搜索栏搜索事件 form.on('submit(search)', function (data) { pageCurr = 1; tableReload(false); }); // 时间选择器 layDate.render({ elem: '.layui-laydate-range' ,style: 'width: 150px' , range: true }); }); /* 表格数据重载 */ function tableReload(child) { var searchData = {}; $.each($('#search-box [name]').serializeArray(), function () { if (this.name == 'orderCode') { searchData.orderCode = this.value; } if (this.name == 'orderTime') { searchData.startTime = this.value.substring(0, 10); searchData.endTime = this.value.substring(13, this.value.length); } }); console.log(searchData); (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(); } });