<!DOCTYPE html>
|
<html>
|
|
<head>
|
<meta charset="utf-8">
|
<title>库存信息列表</title>
|
<meta name="renderer" content="webkit">
|
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
|
<meta name="viewport"
|
content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
|
<link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
|
<link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
|
<link rel="stylesheet" href="../../css/public.css" media="all">
|
<style type="text/css">
|
.layui-form-item .layui-inline {
|
margin-bottom: 1px;
|
margin-right: 1px;
|
}
|
</style>
|
<script>
|
// 这里是需要在页面渲染之前执行的代码
|
document.addEventListener("DOMContentLoaded", function () {
|
//获取table默认显示数
|
pageCntFirst();
|
//判断是否开启table列表列宽调整功能。
|
GetIsSetColW();
|
});
|
</script>
|
|
</head>
|
|
<body id="body">
|
|
<div class="layui-fluid" style="padding-bottom: 0;">
|
<div class="layui-card">
|
<div class="layui-form layui-card-header layuiadmin-card-header-auto" id="top">
|
<div class="layui-form-item" style="margin-bottom: 0px;">
|
|
<div class="layui-inline zongdan">
|
<label class="layui-form-label" style="width: 60px;">物料编码</label>
|
<div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
|
<input type="text" id="SkuNo" name="SkuNo" placeholder="物料编码" autocomplete="off"
|
class="layui-input">
|
</div>
|
</div>
|
<div class="layui-inline zongdan">
|
<label class="layui-form-label" style="width: 60px;">物料名称</label>
|
<div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
|
<input type="text" id="SkuName" name="SkuName" placeholder="物料名称" autocomplete="off"
|
class="layui-input">
|
</div>
|
</div>
|
<div class="layui-inline mingxi">
|
<label class="layui-form-label" style="width: 60px;">进厂编号</label>
|
<div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
|
<input type="text" id="LotNo" name="LotNo" placeholder="进厂编号" autocomplete="off"
|
class="layui-input">
|
</div>
|
</div>
|
|
|
<div class="layui-inline">
|
<!-- 类型 -->
|
<label class="layui-form-label" style="width: 60px;">物料类型</label>
|
<div class="layui-input-inline">
|
<select name="Type" id="Type" lay-verify="" lay-verify="" lay-search>
|
<option value=""></option>
|
<option value="0">原辅料</option>
|
<option value="1">包材</option>
|
<option value="2">成品</option>
|
<option value="3">耗材</option>
|
<option value="4">中间品</option>
|
</select>
|
</div>
|
</div>
|
|
<div class="layui-inline mingxi">
|
<label class="layui-form-label" style="width: 60px;">货主编码</label>
|
<div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
|
<input type="text" id="OwnerNo" name="OwnerNo" placeholder="货主编码" autocomplete="off"
|
class="layui-input">
|
</div>
|
</div>
|
<div class="layui-inline mingxi">
|
<label class="layui-form-label" style="width: 60px;">货主名称</label>
|
<div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
|
<input type="text" id="OwnerName" name="OwnerName" placeholder="货主名称" autocomplete="off"
|
class="layui-input">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 60px;">所属仓库</label>
|
<div class="layui-input-inline">
|
<select name="WareHouseNo" id="WareHouseNo" lay-filter="getWareHouseNo" lay-search>
|
<option value=""></option>
|
</select>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 60px;">所属区域</label>
|
<div class="layui-input-inline">
|
<select name="AreaNo" id="AreaNo" lay-filter="getAreaNo" lay-search>
|
<option value=""></option>
|
</select>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 60px;">逻辑库区</label>
|
<div class="layui-input-inline">
|
<select name="CategoryNo" id="CategoryNo" lay-filter="getCategoryNo" lay-search>
|
<option value=""></option>
|
</select>
|
</div>
|
</div>
|
<div class="layui-inline mingxi">
|
<label class="layui-form-label" style="width: 60px;">储位地址</label>
|
<div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
|
<input type="text" id="LocatNo" name="LocatNo" placeholder="储位地址" autocomplete="off"
|
class="layui-input">
|
</div>
|
</div>
|
<div class="layui-inline mingxi">
|
<label class="layui-form-label" style="width: 60px;">托盘号</label>
|
<div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
|
<input type="text" id="PalletNo" name="PalletNo" placeholder="托盘号" autocomplete="off"
|
class="layui-input">
|
</div>
|
</div>
|
<div class="layui-inline zhijian">
|
<label class="layui-form-label" style="width: 60px;">质检状态</label>
|
<div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
|
<select name="InspectStatus" id="InspectStatus" lay-filter="InspectStatus" lay-search>
|
<option value=""></option>
|
<option value="0">待质检</option><!-- 待检验 -->
|
<option value="1">检验合格</option><!-- 合格品 -->
|
<option value="2">不合格</option><!-- 不合格 -->
|
<option value="3">放置期</option><!-- 不合格 -->
|
</select>
|
</div>
|
</div>
|
<div class="layui-inline ">
|
<label class="layui-form-label" style="width: 60px;">库存状态</label>
|
<div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
|
<select name="Status" id="Status" lay-filter="Status" lay-search>
|
<option value=""></option>
|
<option value="0">待分配</option>
|
<option value="1">部分分配</option>
|
<option value="2">已分配</option>
|
<option value="3">盘点锁定</option>
|
<option value="4">移库锁定</option>
|
<option value="5">异常锁定</option>
|
</select>
|
</div>
|
</div>
|
|
<div class="layui-inline sousuo">
|
<button class="layui-btn layui-btn-sm layuiadmin-btn-list" lay-submit
|
lay-filter="LAY-app-contlist-search">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>搜索
|
</button>
|
<button class="layui-btn layui-btn-sm layuiadmin-btn-list" lay-submit lay-filter="daochu">
|
<i class="layui-icon layui-icon-edit layuiadmin-button-btn"></i>导出
|
</button>
|
</div>
|
</div>
|
</div>
|
|
|
<div class="layui-card-body">
|
<div style="position: relative;">
|
<div class="layui-tab layui-tab-brief" lay-filter="docDemoTabBrief">
|
<ul class="layui-tab-title" id="tab">
|
<li class="layui-this">库存总量</li>
|
<li>库存明细</li>
|
</ul>
|
|
<div id="center"></div>
|
|
<div class="layui-tab-content">
|
<div class="layui-tab-item layui-show">
|
<div class="position-relative"><!-- class="position-relative" --><!-- 自定义表头加上 -->
|
<table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table>
|
<!-- #region 自定义表头 -->
|
<div class="headerSetIcon">
|
<button class="layui-btn layui-btn-primary layui-btn-sm" data-type="customCols">
|
<i class="layui-icon"></i>
|
</button>
|
</div>
|
<!-- #endregion -->
|
</div>
|
</div>
|
<div class="layui-tab-item">
|
<div class="position-relative"><!-- class="position-relative" --><!-- 自定义表头加上 -->
|
<table id="LAY-app-content-list2" lay-filter="LAY-app-content-list2"></table>
|
<!-- #region 自定义表头 -->
|
<div class="headerSetIcon">
|
<button class="layui-btn layui-btn-primary layui-btn-sm"
|
data-type="customCols2">
|
<i class="layui-icon"></i>
|
</button>
|
</div>
|
<!-- #endregion -->
|
|
<!-- #region 自定义表头 -->
|
<script type="text/html" id="templetCompleteTime">
|
{{# function GetBtn(d){
|
return formatDate(d.CompleteTime);
|
}
|
}}
|
{{ GetBtn(d) }}
|
</script>
|
<!-- #endregion -->
|
</div>
|
</div>
|
</div>
|
</div>
|
|
</div>
|
|
<script type="text/html" id="buttonTpl">
|
{{# if(d.Status=='0'){ }}
|
<button class="layui-btn layui-btn-radius layui-btn-normal layui-btn-xs">待分配</button>
|
{{# } else if(d.Status == '1') { }}
|
<button class="layui-btn layui-btn-radius layui-btn-normal layui-btn-xs">部分分配</button>
|
{{# } else if(d.Status == '2') { }}
|
<button class="layui-btn layui-btn-radius layui-btn-normal layui-btn-xs">已分配</button>
|
{{# } else if(d.Status == '3') { }}
|
<button class="layui-btn layui-btn-radius layui-btn-normal layui-btn-xs">盘点锁定</button>
|
{{# } else if(d.Status == '4') { }}
|
<button class="layui-btn layui-btn-radius layui-btn-normal layui-btn-xs">移库锁定</button>
|
{{# } else if(d.Status == '5') { }}
|
<button class="layui-btn layui-btn-radius layui-btn-xs layui-btn-normal">异常锁定</button>
|
{{# } }}
|
</script>
|
<script type="text/html" id="buttonTp2">
|
{{# if(d.InspectStatus == '0') { }}
|
<button class="layui-btn layui-btn-radius layui-btn-warm layui-btn-xs">待检验</button>
|
{{# } else if(d.InspectStatus == '1'){ }}
|
<button class="layui-btn layui-btn-radius layui-btn-xs">检验合格</button>
|
{{# } else if(d.InspectStatus == '2'){ }}
|
<button class="layui-btn layui-btn-radius layui-btn-danger layui-btn-xs">不合格</button>
|
{{# } else if(d.InspectStatus == '4') { }}
|
<button class="layui-btn layui-btn-radius layui-btn-danger layui-btn-xs">放置期</button>
|
{{# } }}
|
</script>
|
|
<script type="text/html" id="buttonTp7">
|
{{# if(d.AbnormalStatu=='0'){ }}
|
<button class="layui-btn layui-btn-radius layui-btn-xs">正常</button>
|
{{# } else { }}
|
<button class="layui-btn layui-btn-radius layui-btn-danger layui-btn-xs">异常</button>
|
{{# } }}
|
</script>
|
|
<script type="text/html" id="SkuType">
|
{{# if(d.Type=='0'){ }}
|
<p>原料</p>
|
{{# } else if(d.Type=='1') { }}
|
<p>包材</p>
|
{{# } else if(d.Type=='2') { }}
|
<p>成品</p>
|
{{# } else if(d.Type=='3') { }}
|
<p>耗材</p>
|
{{# } else if(d.Type=='4') { }}
|
<p>中间品</p>
|
{{# } }}
|
</script>
|
</div>
|
</div>
|
</div>
|
|
<script src="../../layuiadmin/layui/layui.js"></script>
|
<script src="../../js/public.js"></script>
|
<script src="../../js/jquery-3.5.1.min.js"></script>
|
<script src="../../js/jquery.cookie.js"></script>
|
<script>
|
var uid = $.cookie('userId');
|
layui.config({
|
base: '../../layuiadmin/' //静态资源所在路径
|
}).extend({
|
index: 'lib/index' //主入口模块
|
}).use(['index', 'table', 'laypage', 'layer', 'element', 'laydate'], function () {
|
var table = layui.table,
|
form = layui.form,
|
laypage = layui.laypage,
|
layer = layui.layer;
|
element = layui.element;
|
laydate = layui.laydate;
|
|
var h1 = GetTableTabHeight();
|
|
laydate.render({
|
elem: '#StartTime',
|
format: 'yyyy-MM-dd' //可任意组合
|
});
|
laydate.render({
|
elem: '#EndTime',
|
format: 'yyyy-MM-dd' //可任意组合
|
});
|
//获取当前时间
|
function getNowTime() {
|
var date = new Date();
|
//年 getFullYear()：四位数字返回年份
|
var year = date.getFullYear(); //getFullYear()代替getYear()
|
//月 getMonth()：0 ~ 11
|
var month = date.getMonth() + 1;
|
//日 getDate()：(1 ~ 31)
|
var day = date.getDate();
|
//时 getHours()：(0 ~ 23)
|
var hour = date.getHours();
|
//分 getMinutes()： (0 ~ 59)
|
var minute = date.getMinutes();
|
//秒 getSeconds()：(0 ~ 59)
|
var second = date.getSeconds();
|
|
var time = year + addZero(month) + addZero(day) + addZero(hour) + addZero(minute) + addZero(second);
|
return time;
|
|
//小于10的拼接上0字符串
|
|
};
|
function addZero(s) {
|
return s < 10 ? ('0' + s) : s;
|
};
|
|
var $ = layui.$;
|
var yemianid = 0;
|
refreshTable("", "", "", "", "");
|
|
// 表单需要的变量
|
var infoOptions;
|
|
//#region 自定义表头
|
var TotalColsArr = [[
|
{ field: '', title: '序号', type: 'numbers', align: 'center', fixed: 'left', "disabled": true },
|
{ field: 'SkuNo', title: '物料编码', align: 'center', totalRowText: "合计:", "disabled": true },
|
{ field: 'SkuName', title: '物料名称', align: 'center', "disabled": true },
|
{ field: 'Standard', title: '物料规格', align: 'center', "disabled": true },
|
{ field: 'LotNo', title: '进厂编号', align: 'center', "disabled": true },
|
{ field: 'LotText', title: '批次描述', align: 'center' },
|
{ field: 'OwnerNo', title: '货主编码', align: 'center' },
|
{ field: 'OwnerName', title: '货主名称', align: 'center' },
|
{ field: 'Qty', title: '库存数量', align: 'center', totalRow: true },
|
{ field: 'LockQty', title: '锁定数量', align: 'center', totalRow: true },
|
{ field: 'FrozenQty', title: '冻结数量', align: 'center', totalRow: true },
|
{ field: 'InspectStatus', templet: '#buttonTp2', title: '质检状态', width: 90, align: 'center' },
|
{ field: 'ProductionTime', title: '生产日期', width: 130, align: 'center' },
|
{ field: 'ExpirationTime', title: '有效期至', width: 130, align: 'center' },
|
]];
|
var TotalColsSysArr = encodeURIComponent(encodeURIComponent(JSON.stringify(TotalColsArr)))//将表头数据进行url编码
|
//#endregion
|
//获取总量信息
|
function refreshTable(SkuNo, SkuName, OwnerNo, OwnerName, LotNo) {
|
//#region 自定义表头
|
var colsJson
|
var param1 = {
|
Href: 'Statistical/GetInventoryList'
|
};
|
sendData(IP + "/Sys/GetTableColsByUserId", param1, 'post', function (res) {
|
if (res.code == 0) {
|
if (res.data == '' || res.data == undefined || res.data == null) {
|
colsJson = TotalColsArr
|
} else {
|
colsJson = eval(res.data);
|
}
|
} else {
|
colsJson = TotalColsArr
|
}
|
infoOptions = {
|
elem: '#LAY-app-content-list',
|
height: h1,
|
id: 'LAY-app-content-list',
|
totalRow: true,
|
page: true,
|
limit: pageCnt,
|
limits: pageLimits,
|
even: true,
|
cellMinWidth: 80, //全局定义常规单元格的最小宽度，layui 2.2.1 新增
|
done: function () {
|
//自定义列宽
|
SetTableColW('LAY-app-content-list', 'Statistical/GetInventoryList', TotalColsSysArr);
|
},
|
cols: colsJson
|
};
|
var param = {
|
SkuNo: SkuNo, //物料号
|
SkuName: SkuName, //物料名称
|
OwnerNo: OwnerNo, //货主编码
|
OwnerName: OwnerName, //货主名称
|
LotNo: LotNo, //进厂编号
|
};
|
sendData(IP + "/Statistical/GetInventoryList", param, 'get', function (res) {
|
console.log(res)
|
if (res.code == 0) { //成功
|
var list = res.data;
|
$.extend(infoOptions, {
|
data: list
|
});
|
infoOptions.page = {
|
curr: 1
|
}
|
tableIns = table.render(infoOptions);
|
}
|
else { //不成功
|
layer.msg('获取总量列表信息失败！', {
|
icon: 2,
|
time: 2000 //2秒关闭（如果不配置，默认是3秒）
|
}, function () { });
|
}
|
});
|
});
|
//#endregion
|
}
|
|
// 表单需要的变量
|
var infoOptions2;
|
|
//获取明细信息
|
//#region 自定义表头
|
var DetailColsArr = [[
|
{ field: 'PalletNo', title: '托盘号', align: 'center', width: 110, },
|
{ field: 'LocatNo', title: '储位地址', align: 'center', width: 100, },
|
{ field: 'PLCLocatNo', title: '设备地址', align: 'center', width: 100, },
|
{ field: 'WareHouseName', title: '所属仓库', width: 90, align: 'center' },
|
{ field: 'RoadwayName', title: '所属巷道', width: 90, align: 'center' },
|
{ field: 'AreaName', title: '所属区域', width: 90, align: 'center' },
|
{ field: 'SkuNo', title: '物料编码', width: 100, align: 'center' },
|
{ field: 'SkuName', title: '物料名称', align: 'center' },
|
{ field: 'Standard', title: '物料规格', width: 130, align: 'center' },
|
{ field: 'Type', title: '物料类型', width: 130, align: 'center', templet: '#SkuType' },
|
{ field: 'ProductionTime', title: '生产日期', width: 130, align: 'center' },
|
{ field: 'ExpirationTime', title: '有效期至', width: 130, align: 'center' },
|
{ field: 'LotNo', title: '进厂编号', align: 'center' },
|
{ field: 'OwnerNo', title: '货主编码', align: 'center' },
|
{ field: 'OwnerName', title: '货主名称', align: 'center' },
|
{ field: 'SupplierNo', title: '生产商编码', align: 'center' },
|
{ field: 'SupplierName', title: '生产商名称', align: 'center' },
|
{ field: 'Qty', title: '库存数量', width: 110, align: 'center' },
|
{ field: 'LockQty', title: '锁定数量', width: 110, align: 'center' },
|
{ field: 'Status', templet: '#buttonTpl', title: '库存状态', width: 90, align: 'center' },
|
{ field: 'InspectStatus', templet: '#buttonTp2', title: '质检状态', width: 90, align: 'center' },
|
{ field: 'CompleteTime', title: '入库时间', align: 'center', width: 150, templet: '#templetCompleteTime' },
|
]];
|
var DetailColsSysArr = encodeURIComponent(encodeURIComponent(JSON.stringify(DetailColsArr)))//将表头数据进行url编码
|
//#endregion
|
function refreshTable2(SkuNo, SkuName,OwnerNo, OwnerName, LotNo, LocatNo, PalletNo, Status, InspectStatus, HouseNo, AreaNo,CategoryNo, Type) {
|
//#region 自定义表头
|
var colsJson2
|
var param1 = {
|
Href: 'Statistical/GetInventoryList1'
|
};
|
sendData(IP + "/Sys/GetTableColsByUserId", param1, 'post', function (res) {
|
if (res.code == 0) {
|
if (res.data == '' || res.data == undefined || res.data == null) {
|
colsJson2 = DetailColsArr
|
} else {
|
colsJson2 = eval(res.data);
|
}
|
} else {
|
colsJson2 = DetailColsArr
|
}
|
infoOptions2 = {
|
elem: '#LAY-app-content-list2',
|
height: h1,
|
id: 'LAY-app-content-list2',
|
page: true,
|
limit: pageCnt,
|
limits: pageLimits,
|
even: true,
|
cellMinWidth: 80, //全局定义常规单元格的最小宽度，layui 2.2.1 新增
|
done: function () {
|
//自定义列宽
|
SetTableColW('LAY-app-content-list2', 'Statistical/GetInventoryList1', DetailColsSysArr);
|
},
|
cols: colsJson2
|
};
|
var param = {
|
SkuNo: SkuNo, //物料号
|
SkuName: SkuName, //物料名称
|
OwnerNo: OwnerNo, //货主编码
|
OwnerName: OwnerName, //货主名称
|
LotNo: LotNo, //进厂编号
|
LocatNo: LocatNo,//储位地址
|
PalletNo: PalletNo, //托盘号
|
Status: Status,//库存状态
|
InspectStatus: InspectStatus, //质检状态
|
HouseNo: HouseNo,
|
AreaNo: AreaNo, // 所属区域
|
CategoryNo:CategoryNo, //逻辑库区
|
Type: Type,
|
};
|
sendData(IP + "/Statistical/GetInventoryList1", param, 'get', function (res) {
|
if (res.code == 0) //成功
|
{
|
var list = res.data;
|
$.extend(infoOptions2, {
|
data: list
|
});
|
infoOptions2.page = {
|
curr: 1
|
}
|
tableIns2 = table.render(infoOptions2);
|
}
|
else //不成功
|
{
|
layer.msg('获取明细列表信息失败！', {
|
icon: 2,
|
time: 2000 //2秒关闭（如果不配置，默认是3秒）
|
}, function () { });
|
}
|
})
|
});
|
//#endregion
|
}
|
|
//接受全局变量
|
let quanSkuNo = '';
|
let quanLotNo = '';
|
//监听搜索
|
form.on('submit(LAY-app-contlist-search)', function (data) {
|
var SkuNo = $("#SkuNo").val();
|
var SkuName = $("#SkuName").val();
|
var LotNo = $("#LotNo").val();
|
var LocatNo = $("#LocatNo").val();
|
var PalletNo = $("#PalletNo").val();
|
var OwnerNo = $("#OwnerNo").val();
|
var OwnerName = $("#OwnerName").val();
|
var Status = $("#Status").val();
|
var InspectStatus = $("#InspectStatus").val();
|
var HouseNo = $("#WareHouseNo").val(); // 所属仓库
|
var AreaNo = $("#AreaNo").val(); // 所属区域
|
var CategoryNo =$("#CategoryNo").val();
|
var Type = $("#Type").val(); // 物料类型
|
|
if (yemianid == 0) {
|
console.log("总单");
|
refreshTable(SkuNo, SkuName, OwnerNo, OwnerName, LotNo);
|
} else if (yemianid == 1) {
|
quanSkuNo = '';
|
quanLotNo = '';
|
console.log("明细33");
|
console.log(HouseNo);
|
refreshTable2(SkuNo, SkuName, OwnerNo, OwnerName, LotNo, LocatNo, PalletNo, Status, InspectStatus, HouseNo, AreaNo,CategoryNo, Type);
|
}
|
|
});
|
//触发行双击事件
|
table.on('rowDouble(LAY-app-content-list)', function (obj) {
|
$(".layui-tab-title>li").attr("class", "");
|
$('.layui-tab-title>li').eq(1).attr('class', 'layui-this');
|
$('.layui-tab-content .layui-tab-item').attr('class', 'layui-tab-item')
|
$('.layui-tab-content .layui-tab-item').eq(1).attr('class', 'layui-tab-item layui-show')
|
console.log(obj);
|
quanSkuNo = obj.data.SkuNo;
|
quanLotNo = obj.data.lotNo;
|
refreshTable2(obj.data.SkuNo, "", "", "", obj.data.LotNo);
|
yemianid = 1;
|
});
|
|
//监听Tab切换，以改变地址hash值
|
element.on('tab(docDemoTabBrief)', function (data) {
|
var SkuNo = $("#SkuNo").val();
|
var SkuName = $("#SkuName").val();
|
var LotNo = $("#LotNo").val();
|
var LocatNo = $("#LocatNo").val();
|
var PalletNo = $("#PalletNo").val();
|
var OwnerNo = $("#OwnerNo").val();
|
var OwnerName = $("#OwnerName").val();
|
var Status = $("#Status").val();
|
var InspectStatus = $("#InspectStatus").val();
|
var HouseNo = $("#WareHouseNo").val(); // 所属仓库
|
var AreaNo = $("#AreaNo").val(); // 所属区域
|
var CategoryNo = $("#CategoryNo").val();
|
var Type = $("#Type").val(); // 物料类型
|
console.log(data.index);
|
yemianid = data.index
|
if (yemianid == 0) {
|
console.log("总单");
|
refreshTable(SkuNo, SkuName, OwnerNo, OwnerName, LotNo);
|
} else if (yemianid == 1) {
|
console.log("明细11");
|
refreshTable2(SkuNo, SkuName, OwnerNo, OwnerName, LotNo, LocatNo, PalletNo, Status, InspectStatus, HouseNo, AreaNo,CategoryNo, Type);
|
}
|
});
|
|
form.on('submit(daochu)', function () {
|
layer.confirm('确定导出当前数据吗？', function (index) {
|
if (yemianid == 0) {
|
console.log("总单");
|
var param = {
|
SkuNo: $("#SkuNo").val(),
|
SkuName: $("#SkuName").val(),
|
};
|
sendData(IP + "/Statistical/GetInventoryListDaoChu", param, 'get', function (res) {
|
console.log(res);
|
if (res.code == 0) { //成功
|
var list = res.data;
|
table.exportFile(tableIns.config.id, list, 'xls', "库存信息" + getNowTime(),); //data 为该实例中的任意数量的数据
|
layer.msg('导出成功！', {
|
icon: 1,
|
time: 2000 //2秒关闭（如果不配置，默认是3秒）
|
}, function () {
|
|
});
|
|
} else { //不成功
|
layer.msg('获取信息失败！', {
|
icon: 2,
|
time: 2000 //2秒关闭（如果不配置，默认是3秒）
|
}, function () { });
|
}
|
});
|
} else if (yemianid == 1) {
|
console.log("明细22");
|
var SkuNo = $("#SkuNo").val();
|
if (SkuNo == '') {
|
SkuNo = quanSkuNo;
|
}
|
var param = {
|
SkuNo: SkuNo,
|
SkuName: $("#SkuName").val(),
|
LotNo: $("#LotNo").val(),
|
LocatNo: $("#LocatNo").val(),
|
PalletNo: $("#PalletNo").val(),
|
Status: $("#Status").val(),
|
InspectStatus: $("#InspectStatus").val(),
|
IsSamolingTray: $("#IsSamolingTray").val(),
|
StartTime: $("#StartTime").val(),
|
EndTime: $("#EndTime").val(),
|
};
|
sendData(IP + "/Statistical/GetInventoryList1DaoChu", param, 'get', function (res) {
|
console.log(res);
|
if (res.code == 0) { //成功
|
var list = res.data;
|
table.exportFile(tableIns2.config.id, list, 'xls', "库存明细信息" + getNowTime(),); //data 为该实例中的任意数量的数据
|
layer.msg('导出成功！', {
|
icon: 1,
|
time: 2000 //2秒关闭（如果不配置，默认是3秒）
|
}, function () {
|
|
});
|
|
} else { //不成功
|
layer.msg('获取信息失败！', {
|
icon: 2,
|
time: 2000 //2秒关闭（如果不配置，默认是3秒）
|
}, function () { });
|
}
|
});
|
}
|
});
|
|
|
});
|
//#region 自定义表头
|
active = {
|
customCols: function () {
|
layer.open({
|
type: 2,
|
title: '自定义列',
|
content: '../SystemSettings/HeaderSetting.html?Href=Statistical/GetInventoryList&ColsSysArr=' + TotalColsSysArr,
|
maxmin: false,
|
resize: false,
|
area: ['970px', '650px']
|
});
|
},
|
customCols2: function () {
|
layer.open({
|
type: 2,
|
title: '自定义列',
|
content: '../SystemSettings/HeaderSetting.html?Href=Statistical/GetInventoryList1&ColsSysArr=' + DetailColsSysArr,
|
maxmin: false,
|
resize: false,
|
area: ['970px', '650px']
|
});
|
}
|
|
};
|
$('.layui-btn').on('click', function () {
|
var type = $(this).data('type');
|
active[type] ? active[type].call(this) : '';
|
});
|
//#endregion
|
|
// 初始绑定所属仓库
|
sendData(IP + "/Sys/GetWarehouseDic", {}, 'get', function (res) {
|
if (res.code == 0) { //成功
|
for (var i = 0; i < res.data.length; i++) {
|
$("#WareHouseNo").append('<option value =' + res.data[i].WareHouseNo + '>' + res.data[i].WareHouseNo + '-' +
|
res.data[i].WareHouseName + '</option>');
|
}
|
form.render('select');
|
} else { //不成功
|
layer.msg(res.msg, {
|
icon: 2,
|
time: 2000
|
}, function () { });
|
}
|
});
|
|
getAR("");
|
form.on('select(getWareHouseNo)', function (data) {
|
console.log(data);
|
getAR(data.value);
|
});
|
function getAR(val) {
|
//获取 巷道下拉框
|
sendData(IP + "/Sys/GetStorageRoadwayByHouseNo?wareHouseNo=" + val, {}, 'get', function (res) {
|
$("#RoadwayNo").empty();
|
$("#RoadwayNo").append('<option value =""></option>');
|
if (res.code == 0) { //成功
|
for (var i = 0; i < res.data.length; i++) {
|
$("#RoadwayNo").append('<option value =' + res.data[i].RoadwayNo + '>' + res.data[i].RoadwayNo + '-' +
|
res.data[i].RoadwayName + '</option>');
|
}
|
form.render('select');
|
} else { //不成功
|
layer.msg('获取巷道信息失败', {
|
icon: 2,
|
time: 2000
|
}, function () {
|
form.render('select');
|
});
|
}
|
});
|
//获取 区域下拉框
|
sendData(IP + "/Sys/GetStorageAreaByHouseNo?wareHouseNo=" + val, {}, 'get', function (res) {
|
$("#AreaNo").empty();
|
$("#AreaNo").append('<option value =""></option>');
|
if (res.code == 0) { //成功
|
for (var i = 0; i < res.data.length; i++) {
|
$("#AreaNo").append('<option value =' + res.data[i].AreaNo + '>' + res.data[i].AreaNo + '-' +
|
res.data[i].AreaName + '</option>');
|
}
|
form.render('select');
|
} else {
|
layer.msg('获取区域信息失败', {
|
icon: 2,
|
time: 2000
|
}, function () {
|
|
form.render('select');
|
});
|
}
|
});
|
|
//获取逻辑库区下拉框
|
sendData(IP + "/Sys/GetMaterialCategories?wareHouseNo=" + val, {}, 'get', function (res) {
|
console.log("ret.data:"+res.data[4].CategoryNo)
|
console.log("code:"+res.code)
|
$("#CategoryNo").empty();
|
$("#CategoryNo").append('<option value =""></option>');
|
if (res.code == 1) { //成功
|
for (var i = 0; i < res.data.length; i++) {
|
$("#CategoryNo").append('<option value =' + res.data[i].CategoryNo + '>' + res.data[i].CategoryNo + '-' +
|
res.data[i].CategoryName + '</option>');
|
}
|
form.render('select');
|
} else {
|
layer.msg('获取区域信息失败', {
|
icon: 2,
|
time: 2000
|
}, function () {
|
|
form.render('select');
|
});
|
}
|
});
|
|
};
|
|
});
|
</script>
|
</body>
|
|
</html>
|
