<!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">
|
<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">
|
<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 zhijian">
|
<label class="layui-form-label" style="width: 60px;">物料类型</label>
|
<div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
|
<select name="Type" id="Type" 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">
|
<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 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>
|
<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'], function() {
|
var table = layui.table,
|
form = layui.form,
|
laypage = layui.laypage,
|
layer = layui.layer;
|
|
var $ = layui.$;
|
var h1 = GetTableHeight();
|
|
refreshTable("","","","");
|
var tableIns;
|
|
//获取当前时间
|
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 infoOptions;
|
//#region 原始非自定义列
|
// infoOptions = {
|
// elem: '#LAY-app-content-list',
|
// height: 'full-134',
|
// id: 'LAY-app-content-list',
|
// page: true,
|
// limit: pageCnt,
|
// limits: pageLimits,
|
// cellMinWidth: 60, //全局定义常规单元格的最小宽度，layui 2.2.1 新增
|
// cols: [
|
// [
|
// {
|
// title: '序号',type: 'numbers',fixed: 'left',width:65
|
// },
|
// {
|
// field: 'SkuNo', title: '物料编码', align: 'center',
|
// },
|
// {
|
// field: 'SkuName', title: '物料名称', align: 'center',
|
// },
|
// {
|
// field: 'Type', title: '物料类型', align: 'center', templet: '#SkuType',
|
// },
|
// {
|
// field: 'Standard', title: '物料规格', align: 'center',
|
// },
|
// {
|
// title: '批次', field: 'LotNo', align: 'center'
|
// },
|
// {
|
// field: 'ResidueQty', title: '剩余数量', align: 'center',
|
// },
|
// {
|
// field: 'Qty', title: '库存数量', align: 'center',
|
// },
|
// {
|
// field: 'LockQty', title: '锁定数量', align: 'center',
|
// },
|
// {
|
// field: 'FrozenQty', title: '冻结数量', align: 'center',
|
// },
|
// ]
|
// ],
|
|
// };
|
//#endregion
|
|
//#region 自定义表头
|
var TotalColsArr = [[
|
{field: '',title: '序号',type:'numbers',fixed: 'left', "disabled": true},
|
{field: 'SkuNo', title: '物料编码', align: 'center'},
|
{field: 'SkuName', title: '物料名称', align: 'center'},
|
{field: 'Type', title: '物料类型', align: 'center', templet: '#SkuType'},
|
{field: 'Standard', title: '物料规格', align: 'center'},
|
{title: '批次', field: 'LotNo', align: 'center'},
|
{field: 'ResidueQty', title: '剩余数量', align: 'center'},
|
{field: 'Qty', title: '库存数量', align: 'center'},
|
{field: 'LockQty', title: '锁定数量', align: 'center'},
|
{field: 'FrozenQty', title: '冻结数量', align: 'center'}
|
]];
|
var TotalColsSysArr=encodeURIComponent(encodeURIComponent(JSON.stringify(TotalColsArr)))//将表头数据进行url编码
|
//#endregion
|
function refreshTable(SkuNo,SkuName,LotNo,Type) {
|
//#region 自定义表头
|
var colsJson
|
var param1={
|
Href:'Statistical/GetInventoryWarning'
|
};
|
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',
|
page: true,
|
limit: pageCnt,
|
limits: pageLimits,
|
cellMinWidth: 60, //全局定义常规单元格的最小宽度，layui 2.2.1 新增
|
done: function(){
|
//自定义列宽
|
SetTableColW('LAY-app-content-list','Statistical/GetInventoryWarning',TotalColsSysArr);
|
},
|
cols:colsJson
|
};
|
|
var param = {
|
SkuNo:SkuNo,
|
SkuName:SkuName,
|
LotNo:LotNo,
|
Type:Type
|
};
|
|
sendData(IP + "/Statistical/GetInventoryWarning", 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
|
}
|
// table.reload()
|
|
//监听搜索
|
form.on('submit(LAY-app-contlist-search)', function(data) {
|
var SkuNo = data.field.SkuNo;
|
var SkuName = data.field.SkuName;
|
var LotNo = data.field.LotNo;
|
var Type = data.field.Type;
|
refreshTable(SkuNo,SkuName,LotNo,Type);
|
});
|
|
form.on('submit(daochu)', function () {
|
layer.confirm('确定导出当前数据吗？', function(index) {
|
var param = {
|
SkuNo:$("#SkuNo").val(),
|
SkuName:$("#SkuName").val(),
|
LotNo:$("#LotNo").val(),
|
Type:$("#Type").val(),
|
|
};
|
sendData(IP + "/Statistical/GetInventoryWarning", 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 () { });
|
}
|
});
|
});
|
});
|
|
//#region 自定义表头
|
//自定义表头
|
active = {
|
customCols: function(){
|
layer.open({
|
type: 2,
|
title: '自定义列',
|
content: '../SystemSettings/HeaderSetting.html?Href=Statistical/GetInventoryWarning&ColsSysArr='+TotalColsSysArr,
|
maxmin: false,
|
resize: false,
|
area: ['970px', '650px']
|
});
|
}
|
};
|
$('.layui-btn').on('click', function() {
|
var type = $(this).data('type');
|
active[type] ? active[type].call(this) : '';
|
});
|
//#endregion
|
});
|
</script>
|
</body>
|
</html>
|
