var pageCurr; function getCol() { var cols = [ {field: 'locNo', align: 'center', title: '库位号'}, {field: 'matnr', align: 'center', title: '品号', sort: true} , {field: 'maktx', align: 'center', title: '名称', sort: true} , {field: 'orderNo', align: 'center', title: '单据编号', hide: false} , {field: 'orderType', align: 'center', title: '单据类型', hide: false} , {field: 'batch', align: 'center', title: '批号', width: 80, sort: true} , {field: 'anfme', align: 'center', title: '数量', width: 100} , {field: 'zpallet', align: 'center', title: '托盘码', sort: true} , { field: 'templet', align: 'center', title: '机型', templet: function (row) { return row.mat$.model } } , { field: 'templet', align: 'center', title: '制令', templet: function (row) { return row.mat$.decrees } } , {field: 'owner', align: 'center', title: '货主'} , {field: 'memo', align: 'center', title: '备注'} // ,{field: 'owner$', align: 'center',title: '拥有者'} , {field: 'specs', align: 'center', title: '规格'} , {field: 'model', align: 'center', title: '代码', hide: true} , {field: 'color', align: 'center', title: '颜色', hide: true} , {field: 'brand', align: 'center', title: '品牌', hide: true} , {field: 'unit', align: 'center', title: '单位', hide: true} , {field: 'price', align: 'center', title: '单价', hide: true} , {field: 'sku', align: 'center', title: 'sku', hide: true} , {field: 'units', align: 'center', title: '单位量', hide: true} , {field: 'barcode', align: 'center', title: '条码', hide: true} , {field: 'origin', align: 'center', title: '仓库号', hide: false} , {field: 'manu', align: 'center', title: '厂家', hide: true} , {field: 'manuDate', align: 'center', title: '生产日期', hide: true} , {field: 'itemNum', align: 'center', title: '品项数', hide: true} , {field: 'safeQty', align: 'center', title: '安全库存量', hide: true} , {field: 'weight', align: 'center', title: '单箱净重', hide: true} , {field: 'length', align: 'center', title: '单箱毛重', hide: true} , {field: 'volume', align: 'center', title: '单箱体积', hide: true} , {field: 'threeCode', align: 'center', title: '箱子尺寸', hide: true} , {field: 'supp', align: 'center', title: '供应商', hide: true} , {field: 'suppCode', align: 'center', title: '供应商编码', hide: true} , {field: 'beBatch$', align: 'center', title: '是否批次', hide: true} , {field: 'deadTime', align: 'center', title: '保质期', hide: true} , {field: 'deadWarn', align: 'center', title: '预警天数', hide: true} , {field: 'source$', align: 'center', title: '制购', hide: true} , {field: 'check$', align: 'center', title: '要求检验', hide: true} , {field: 'danger$', align: 'center', title: '危险品', hide: true} ]; // cols.push.apply(cols, detlCols); cols.push({field: 'modiUser$', align: 'center', title: '修改人员', hide: true} , {field: 'modiTime$', align: 'center', title: '修改时间'} ) return cols; } layui.use(['table', 'laydate', 'form'], function () { var table = layui.table; var $ = layui.jquery; var layer = layui.layer; var layDate = layui.laydate; var form = layui.form; // 数据渲染 tableIns = table.render({ elem: '#locDetl', headers: {token: localStorage.getItem('token')}, url: baseUrl + '/locDetl/page/auth', page: true, limit: 20, where: { unreason: false }, limits: [20, 30, 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; limit(); form.on('checkbox(tableCheckbox)', function (data) { var _index = $(data.elem).attr('table-index') || 0; if (data.elem.checked) { res.data[_index][data.value] = 'Y'; } else { res.data[_index][data.value] = 'N'; } }); } }); // 监听排序事件 table.on('sort(locDetl)', function (obj) { var searchData = {}; $.each($('#search-box [name]').serializeArray(), function () { searchData[this.name] = this.value; }); searchData['orderByField'] = obj.field; searchData['orderByType'] = obj.type; tableIns.reload({ where: searchData, page: { curr: 1 }, done: function (res, curr, count) { if (res.code === 403) { top.location.href = baseUrl + "/"; } pageCurr = curr; limit(); } }); }); // 监听头工具栏事件 table.on('toolbar(locDetl)', function (obj) { var checkStatus = table.checkStatus(obj.config.id); switch (obj.event) { case 'addData': layer.open({ type: 2, title: '新增', maxmin: true, area: [top.detailWidth, top.detailHeight], shadeClose: false, content: 'locDetl_detail.html', success: function (layero, index) { layer.getChildFrame('#data-detail-submit-edit', index).hide(); clearFormVal(layer.getChildFrame('#detail', index)); layer.iframeAuto(index); layer.style(index, {top: (($(window).height() - layer.getChildFrame('#data-detail', index).height()) / 3) + "px"}); } }); break; case 'refreshData': tableIns.reload({ page: { curr: pageCurr } }); limit(); break; case 'deleteData': var data = checkStatus.data; if (data.length === 0) { layer.msg('请选择数据'); } else { layer.confirm('确定删除' + (data.length === 1 ? '此' : data.length) + '条数据吗', function () { $.ajax({ url: baseUrl + "/locDetl/delete/auth", headers: {'token': localStorage.getItem('token')}, data: {param: JSON.stringify(data)}, method: 'POST', traditional: true, success: function (res) { if (res.code === 200) { layer.closeAll(); tableReload(false); } else if (res.code === 403) { top.location.href = baseUrl + "/"; } else { layer.msg(res.msg) } } }) }); } break; 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 exportData = {}; $.each($('#search-box [name]').serializeArray(), function () { exportData[this.name] = this.value; }); var param = { 'locDetl': exportData, 'fields': fields }; var loadIndex = layer.msg('正在导出...', {icon: 16, shade: 0.01, time: false}); $.ajax({ url: baseUrl + "/locDetl/export/auth", headers: {'token': localStorage.getItem('token')}, data: JSON.stringify(param), dataType: 'json', contentType: 'application/json;charset=UTF-8', method: 'POST', success: function (res) { layer.close(loadIndex); layer.closeAll(); if (res.code === 200) { res.data.forEach((item, index) => { if (item[0] != null) { item[0] = "'" + item[0]; } if (item[1] != null) { item[1] = "'" + item[1]; } if (item[2] != null) { item[2] = "'" + item[2]; } }) table.exportFile(titles, res.data, 'xls'); } else if (res.code === 403) { top.location.href = baseUrl + "/"; } else { layer.msg(res.msg) } } }); }); // debugger; // 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 exportData = {}; // $.each($('#search-box [name]').serializeArray(), function() { // exportData[this.name] = this.value; // }); // var param = { // 'wrkDetlLog': exportData, // 'fields': fields // }; // // layer.load('Loading...', { // shade: [0.1,'#fff'] // }); // $.ajax({ // url: baseUrl + "/locDetl/export/auth", // headers: {'token': localStorage.getItem('token')}, // data: JSON.stringify(param), // contentType:'application/json;charset=UTF-8', // method: 'POST', // xhrFields: { // responseType: "blob" // 设置响应类型为二进制数据 // }, // success: function (res) { // // 创建一个临时的下载链接 // const url = window.URL.createObjectURL(res); // // 创建一个隐藏的 元素并设置下载链接 // const a = document.createElement("a"); // a.style.display = "none"; // a.href = url; // a.download = "export.xlsx"; // 指定下载的文件名 // document.body.appendChild(a); // // // 触发点击事件以开始下载 // a.click(); // // // 清理临时资源 // setTimeout(function () { // window.URL.revokeObjectURL(url); // document.body.removeChild(a); // layer.closeAll(); // }, 100); // }, // fail: function (){ // layer.msg('导出失败', {icon: 2}) // layer.closeAll(); // } // }); // }); break; } }); // 监听行工具事件 table.on('tool(locDetl)', function (obj) { var data = obj.data; switch (obj.event) { // 详情 case 'detail': layer.open({ type: 2, title: '详情', maxmin: true, area: [top.detailWidth, top.detailHeight], shadeClose: false, content: 'locDetl_detail.html', success: function (layero, index) { setFormVal(layer.getChildFrame('#detail', index), data, true); top.convertDisabled(layer.getChildFrame('#data-detail :input', index), true); layer.getChildFrame('#data-detail-submit-save,#data-detail-submit-edit,#prompt', index).hide(); layer.iframeAuto(index); layer.style(index, {top: (($(window).height() - layer.getChildFrame('#data-detail', index).height()) / 3) + "px"}); layero.find('iframe')[0].contentWindow.layui.form.render('select'); layero.find('iframe')[0].contentWindow.layui.form.render('checkbox'); } }); break; // 编辑 case 'edit': layer.open({ type: 2, title: '修改', maxmin: true, area: [top.detailWidth, top.detailHeight], shadeClose: false, content: 'locDetl_detail.html', success: function (layero, index) { layer.getChildFrame('#data-detail-submit-save', index).hide(); setFormVal(layer.getChildFrame('#detail', index), data, false); top.convertDisabled(layer.getChildFrame('#data-detail :input', index), false); top.convertDisabled(layer.getChildFrame('#locNo,#matnr', index), true); layer.iframeAuto(index); layer.style(index, {top: (($(window).height() - layer.getChildFrame('#data-detail', index).height()) / 3) + "px"}); layero.find('iframe')[0].contentWindow.layui.form.render('select'); layero.find('iframe')[0].contentWindow.layui.form.render('checkbox'); } }); break; } }); // 数据保存动作 form.on('submit(save)', function () { if (banMsg != null) { layer.msg(banMsg); return; } method("add"); }); // 数据修改动作 form.on('submit(edit)', function () { method("update") }); function method(name) { var index = layer.load(1, { shade: [0.5, '#000'] //0.1透明度的背景 }); var data = { // id: $('#id').val(), locNo: $('#locNo').val(), matnr: $('#matnr').val(), lgnum: $('#lgnum').val(), tbnum: $('#tbnum').val(), tbpos: $('#tbpos').val(), zmatid: $('#zmatid').val(), maktx: $('#maktx').val(), werks: $('#werks').val(), anfme: $('#anfme').val(), altme: $('#altme').val(), zpallet: $('#zpallet').val(), bname: $('#bname').val(), memo: $('#memo').val(), modiUser: $('#modiUser').val(), modiTime: top.strToDate($('#modiTime\\$').val()), appeUser: $('#appeUser').val(), appeTime: top.strToDate($('#appeTime\\$').val()), }; $.ajax({ url: baseUrl + "/locDetl/" + name + "/auth", headers: {'token': localStorage.getItem('token')}, data: top.reObject(data), method: 'POST', success: function (res) { if (res.code === 200) { parent.layer.closeAll(); parent.$(".layui-laypage-btn")[0].click(); $("#data-detail :input").each(function () { $(this).val(""); }); } else if (res.code === 403) { top.location.href = baseUrl + "/"; } else { layer.msg(res.msg) } layer.close(index); } }) } // 复选框事件 form.on('checkbox(detailCheckbox)', function (data) { var el = data.elem; if (el.checked) { $(el).val('Y'); } else { $(el).val('N'); } }); // 搜索栏搜索事件 form.on('submit(search)', function (data) { pageCurr = 1; tableReload(false); }); // 搜索栏重置事件 form.on('submit(reset)', function (data) { pageCurr = 1; clearFormVal($('#search-box')); tableReload(false); }); //查看异常数据 form.on('submit(unreason)', function (data) { pageCurr = 1; tableIns.reload({ where: { unreason: true }, page: { curr: pageCurr }, done: function (res, curr, count) { if (res.code === 403) { top.location.href = baseUrl + "/"; } pageCurr = curr; limit(); } }); }); // 时间选择器 layDate.render({ elem: '#modiTime\\$', type: 'datetime' }); layDate.render({ elem: '#appeTime\\$', type: 'datetime' }); }); // 关闭动作 $(document).on('click', '#data-detail-close', function () { parent.layer.closeAll(); }); function tableReload(child) { var searchData = { unreason: false }; $.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); } }); } function setFormVal(el, data, showImg) { for (var val in data) { var find = el.find(":input[id='" + val + "']"); if (find[0] != null) { if (find[0].type === 'checkbox') { if (data[val] === 'Y') { find.attr("checked", "checked"); find.val('Y'); } else { find.remove("checked"); find.val('N'); } continue; } } find.val(data[val]); if (showImg) { var next = find.next(); if (next.get(0)) { if (next.get(0).localName === "img") { find.hide(); next.attr("src", data[val]); next.show(); } } } } } function clearFormVal(el) { $(':input', el) .val('') .removeAttr('checked') .removeAttr('selected'); } function detailScreen(index) { var detail = layer.getChildFrame('#data-detail', index); var height = detail.height() + 60; if (height > ($(window).height() * 0.9)) { height = ($(window).height() * 0.8); } layer.style(index, { // top: (($(window).height()-height)/3)+"px", height: height + 'px' }); } $('body').keydown(function () { if (event.keyCode === 13) { $("#search").click(); } });