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: 'batch', align: 'center',title: '序列码', width: 300, sort:true}
|
,{field: 'anfme', align: 'center',title: '数量', width: 100}
|
,{field: 'zpallet', 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 = {
|
'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);
|
// 创建一个隐藏的 <a> 元素并设置下载链接
|
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();
|
}
|
});
|
