<!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">
|
<style type="text/css">
|
.layui-form-item .layui-inline {
|
margin-bottom: 1px;
|
margin-right: 1px;
|
}
|
|
</style>
|
|
</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">
|
<label class="layui-form-label" >物料信息</label>
|
<div class="layui-input-inline">
|
<select name="SkuNo" id="SkuNo" lay-verify="" lay-search>
|
<option value=""></option>
|
</select>
|
</div>
|
</div>
|
<!-- <div class="layui-inline">
|
<label class="layui-form-label">物料编码</label>
|
<div class="layui-input-inline">
|
<input type="text" id="SkuNo" name="SkuNo" placeholder="物料编码" autocomplete="off"
|
class="layui-input">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label">物料名称</label>
|
<div class="layui-input-inline">
|
<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 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;">
|
<input type="text" autocomplete="off" id="StartTime" class="layui-input"
|
placeholder="开始时间">
|
</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;">
|
<input type="text" autocomplete="off" id="EndTime" class="layui-input"
|
placeholder="结束时间">
|
</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-search layuiadmin-button-btn"></i>导出
|
</button>
|
</div>
|
|
|
</div>
|
</div>
|
|
<div id="center"></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">
|
<li class="layui-this">总量</li>
|
<li >记录</li>
|
</ul>
|
<div class="layui-tab-content">
|
<div class="layui-tab-item layui-show">
|
<table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table>
|
</div>
|
<div class="layui-tab-item">
|
<table id="LAY-app-content-list2" lay-filter="LAY-app-content-list2"></table>
|
</div>
|
</div>
|
</div>
|
|
</div>
|
|
</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;
|
|
//获取物料信息
|
sendData(IP + "/basis/GetMateList", {}, 'get', function(res) {
|
var html = '';
|
if (res.code == 0) //成功
|
{
|
var list = res.data;
|
for (var i = 0; i < list.length; i++) {
|
//判断空托盘
|
if (list[i].SkuNo != "100099" && list[i].SkuNo != "100098" && list[i].SkuNo != "100097" && list[i].SkuNo != "100096" && list[i].SkuNo != "100095")
|
{
|
html += '<option value = "' + list[i].SkuNo + '">' + list[i].SkuName + '</option>';
|
}
|
}
|
$("#SkuNo").append(html);
|
form.render('select');
|
}
|
else //不成功
|
{
|
layer.msg('获取物料信息失败！', {
|
icon: 2,
|
time: 2000 //2秒关闭（如果不配置，默认是3秒）
|
}, function() {});
|
}
|
});
|
|
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 myDate = new Date();
|
console.log(myDate.getFullYear()+'-'+(myDate.getMonth() + 1)+'-'+myDate.getDate()+' 00:00:00')
|
myDate.getFullYear(); //获取完整的年份(4位,1970-????)
|
myDate.getMonth(); //获取当前月份(0-11,0代表1月)
|
myDate.getDate(); //获取当前日(1-31)
|
// 每日初始时间
|
var chudate = myDate.getFullYear()+'-'+(myDate.getMonth() + 1)+'-'+myDate.getDate()+' 00:00:00'
|
var jiedate = myDate.getFullYear()+'-'+(myDate.getMonth() + 1)+'-'+myDate.getDate()+' 23:59:59'
|
var $ = layui.$;
|
var yemianid =0;
|
|
|
var h1 = GetTableHeight();
|
refreshTable("","","",chudate,jiedate);
|
//获取出入库总量
|
function refreshTable(SkuNo,SkuName,LotNo,StartTime,EndTime) {
|
var param = {
|
SkuNo:SkuNo, //物料号
|
// SkuName:SkuName, //物料名称
|
LotNo:LotNo, //批次号
|
// StartTime:StartTime, //开始时间
|
// EndTime:EndTime, //结束时间
|
//StartTime:StartTime?""=chudate:StartTime, //开始时间
|
//EndTime:EndTime?""=jiedate:EndTime, //结束时间
|
};
|
// if(StartTime == "")
|
// {
|
// param.StartTime = chudate;
|
// }
|
// if(EndTime == "")
|
// {
|
// param.EndTime = jiedate;
|
// }
|
//sendData(IP + "/Statistical/GetBindList?SkuNo="+$("#SkuNo").val()+"&&SkuName="+$("#SkuName").val()+"&&PalletNo="+$("#PalletNo").val()+"&&LotNo="+$("#LotNo").val()+"&&BoxNo="+$("#BoxNo").val()+"&&Status="+$("#Status").val()+"&&InspectMark="+$("#InspectMark").val()+"&&BitPalletMark="+$("#BitPalletMark").val()+"&&BitBoxMark="+$("#BitBoxMark").val()+"&&InspectStatus="+$("#InspectStatus").val(), {}, 'post', function(res) {
|
sendData(IP + "/Statistical/GetTotalRecord", 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() {});
|
}
|
});
|
}
|
// 表单需要的变量
|
var infoOptions = {
|
elem: '#LAY-app-content-list',
|
height: 'full-164',
|
id: 'LAY-app-content-list',
|
page: true,
|
limit: pageCnt,
|
limits: pageLimits,
|
even: true,
|
cellMinWidth: 80, //全局定义常规单元格的最小宽度，layui 2.2.1 新增
|
cols:
|
[[
|
{
|
title: '序号', type: 'numbers', fixed: 'left'
|
},
|
{
|
field: 'LotNo', title: '批次号', align: 'center',sort: true,
|
},
|
{
|
field: 'SkuNo', title: '物料编码', align: 'center'
|
},
|
{
|
field: 'SkuName', title: '物料名称', align: 'center',
|
},
|
{
|
field: 'RQty', title: '入库数量', align: 'center'
|
},
|
{
|
field: 'RFactQty', title: '已组数量', align: 'center',
|
},
|
{
|
field: 'RCompleteQty', title: '完成数量', align: 'center'
|
},
|
{
|
field: 'CQty', title: '出库数量', align: 'center'
|
},
|
{
|
field: 'CAllotQty', title: '分配数量', align: 'center'
|
},
|
{
|
field: 'CFactQty', title: '下架数量', align: 'center',
|
},
|
{
|
field: 'CompleteQty', title: '拣货数量', align: 'center'
|
},
|
|
]]
|
};
|
|
//LotNo LocatNo PalletNo Status InspectStatus
|
function refreshTable2(SkuNo,LotNo,PalletNo,StartTime,EndTime) {
|
var param = {
|
SkuNo:SkuNo,
|
// SkuName:SkuName,
|
LotNo:LotNo,
|
PalletNo:PalletNo,
|
// StartTime:StartTime,
|
// EndTime:EndTime
|
}
|
//sendData(IP + "/Statistical/GetBoxInfor?Id="+Id+"&&SkuNo="+$("#SkuNo").val()+"&&SkuName="+$("#SkuName").val()+"&&PalletNo="+$("#PalletNo").val()+"&&LotNo="+$("#LotNo").val()+"&&BoxNo="+$("#BoxNo").val()+"&&Status="+$("#Status").val()+"&&InspectMark="+$("#InspectMark").val()+"&&BitBoxMark="+$("#BitBoxMark").val()+"&&InspectStatus="+$("#InspectStatus").val(), {}, 'get', function(res) {
|
sendData(IP + "/Statistical/GetDetailedRecord", 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() {});
|
}
|
})
|
}
|
// 表单需要的变量
|
var infoOptions2 = {
|
elem: '#LAY-app-content-list2',
|
height: 'full-164',
|
id: 'LAY-app-content-list2',
|
page: true,
|
limit: pageCnt,
|
limits: pageLimits,
|
even: true,
|
cellMinWidth: 80, //全局定义常规单元格的最小宽度，layui 2.2.1 新增
|
cols:
|
[[
|
{
|
title: '序号', type: 'numbers', fixed: 'left', width: 70
|
},
|
{
|
field: 'LotNo', title: '批次号', align: 'center', width: 100,sort: true,
|
},
|
{
|
field: 'SupplierLot', title: '供货批次', align: 'center', width: 100
|
},
|
{
|
field: 'SkuNo', title: '物料编码', align: 'center', width: 100
|
},
|
{
|
field: 'SkuName', title: '物料名称', align: 'center', width: 100
|
},
|
{
|
field: 'PalletNo', title: '托盘号', align: 'center', width: 100
|
},
|
{
|
field: 'LotText', title: '批次描述', align: 'center', width: 100
|
},
|
{
|
field: 'CompleteTime', title: '入库时间', align: 'center', width: 160,
|
templet: function(d) {
|
return formatDate(d.CompleteTime);
|
},
|
},
|
{
|
field: 'RQty', title: '入库数量', align: 'center', width: 100
|
},
|
{
|
field: 'RFactQty', title: '已组数量', align: 'center',
|
},
|
{
|
field: 'RCompleteQty', title: '完成数量', align: 'center', width: 100
|
},
|
{
|
field: 'CCreateTime', title: '拣货时间', align: 'center',width: 160,
|
templet: function(d) {
|
return formatDate(d.CCreateTime);
|
},
|
},
|
{
|
field: 'CQty', title: '出库数量', align: 'center', width: 100
|
},
|
{
|
field: 'CAllotQty', title: '分配数量', align: 'center', width: 100
|
},
|
{
|
field: 'CFactQty', title: '下架数量', align: 'center', width: 100
|
},
|
{
|
field: 'CompleteQty', title: '拣货数量', align: 'center', width: 100
|
},
|
]]
|
};
|
//var url = IP + "/Statistical/GetInventoryList1";
|
|
|
|
//接受全局变量
|
let quanlotno = '';
|
//监听搜索
|
form.on('submit(LAY-app-contlist-search)', function(data) {
|
var SkuNo = $("#SkuNo").val();
|
// var SkuName = $("#SkuName").val();
|
var LotNo = $("#LotNo").val();
|
var StartTime = $("#StartTime").val();
|
var EndTime = $("#EndTime").val();
|
var PalletNo = $("#PalletNo").val();
|
|
|
if(yemianid == 0){
|
console.log("总单");
|
refreshTable(SkuNo,LotNo,StartTime,EndTime);
|
}else if(yemianid == 1){
|
quanlotno = '';
|
console.log("明细");
|
refreshTable2(SkuNo,quanlotno,PalletNo,StartTime,EndTime);
|
}
|
|
});
|
//触发行双击事件
|
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.data.LotNo);
|
quanlotno = obj.data.LotNo;
|
refreshTable2("","",obj.data.LotNo,"","","");
|
yemianid=1;
|
});
|
|
//监听Tab切换，以改变地址hash值
|
element.on('tab(docDemoTabBrief)', function(data){
|
console.log(data.index);
|
yemianid = data.index
|
if(yemianid == 0){
|
console.log("总单");
|
refreshTable("","","","","");
|
}else if(yemianid == 1){
|
console.log("明细");
|
refreshTable2("","",quanlotno,"","","");
|
}
|
});
|
|
form.on('submit(daochu)', function () {
|
layer.confirm('确定导出当前数据吗？', function(index) {
|
if(yemianid == 0){
|
console.log("总单");
|
var param = {
|
SkuNo: $("#SkuNo").val(),
|
LotNo: $("#LotNo").val(),
|
PalletNo: $("#PalletNo").val(),
|
};
|
sendData(IP + "/Statistical/GetTotalRecordDaoChu", 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("记录");
|
var param = {
|
SkuNo: $("#SkuNo").val(),
|
LotNo:$("#LotNo").val(),
|
PalletNo:$("#PalletNo").val(),
|
};
|
sendData(IP + "/Statistical/GetDetailedRecordDaoChu", 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 () { });
|
}
|
});
|
}
|
});
|
});
|
|
var doing = true;
|
// ------------------------------------详情---------------------------------------------------
|
table.on('tool(LAY-app-content-list2)', function(obj) {
|
console.log(obj)
|
var data = obj.data;
|
//详情
|
if (obj.event === 'edit') {
|
BoxNo = data.BoxNo;
|
console.log(data)
|
layer.open({
|
type: 2,
|
title: '箱支详情信息',
|
content: 'BoxSupportInfor.html?BoxNo=' + BoxNo,
|
maxmin: true,
|
area: ['80%', '85%'],
|
btn: ['关闭'],
|
yes: function(index, layero) {
|
var iframeWindow = window['layui-layer-iframe' + index],
|
submitID = 'layuiadmin-app-form-edit',
|
submit = layero.find('iframe').contents().find('#' + submitID);
|
if(doing)
|
{
|
doing = false;
|
|
layer.close(index); //关闭弹层
|
refreshTable();
|
doing = true;
|
|
|
}
|
}
|
});
|
}
|
});
|
|
});
|
</script>
|
</body>
|
</html>
|
