<!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>
|
.layui-card-header .layui-icon {
|
position: static;
|
margin-top: 0px;
|
}
|
</style>
|
</head>
|
|
<body>
|
<div class="layui-fluid" style="padding-bottom: 0;">
|
<div class="layui-card">
|
<div class="layui-form layui-card-header layuiadmin-card-header-auto">
|
<div class="layui-form-item">
|
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 60px;">物品编码</label>
|
<div class="layui-input-inline">
|
<input type="text" id="GoodId" name="GoodId" 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">
|
<input type="text" id="GoodsName" name="GoodsName" 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">
|
<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">
|
<input type="text" class="layui-input" id="StartTime" name="StartTime" autocomplete="off"
|
placeholder="">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 60px;">结束日期</label>
|
<div class="layui-input-inline">
|
<input type="text" class="layui-input" id="EndTime" name="EndTime" autocomplete="off"
|
placeholder="">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<!-- <label class="layui-form-label">单选框</label> -->
|
<div class="layui-input-block" style="margin-left: 20px;">
|
<input type="radio" name="statement" lay-filter="statement" value="日报" title="日报"
|
checked="">
|
<input type="radio" name="statement" lay-filter="statement" value="月报" title="月报">
|
<input type="radio" name="statement" lay-filter="statement" value="年报" title="年报">
|
</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 class="layui-card-body">
|
<table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table>
|
<script type="text/html" id="table-toolbar1"></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', 'laydate'], function () {
|
var table = layui.table,
|
form = layui.form,
|
laypage = layui.laypage,
|
layer = layui.layer;
|
var $ = layui.$;
|
var d = new Date();
|
var yy = d.getFullYear();
|
var mm = d.getMonth() + 1;
|
if (mm < 10)
|
mm = "0" + mm;
|
var dd = d.getDate();
|
if (dd < 10)
|
dd = "0" + dd;
|
//var date1 = dd + "-" + mm + "-" + yy;
|
var date1 = yy + "-" + mm + "-" + dd;
|
var tableIns;
|
var laydate = layui.laydate;
|
//常规用法
|
laydate.render({
|
elem: '#StartTime',
|
value: date1,
|
format: 'yyyy-MM-dd' //可任意组合
|
});
|
laydate.render({
|
elem: '#EndTime',
|
value: date1,
|
format: 'yyyy-MM-dd' //可任意组合
|
});
|
|
// 补零函数
|
function doHandleZero(zero) {
|
var date = zero;
|
if (zero.toString().length == 1) {
|
date = "0" + zero;
|
}
|
return date;
|
}
|
// 获取每个月一号
|
function getDate() {
|
var myDate = new Date();
|
var tYear = myDate.getFullYear()
|
var tMonth = myDate.getMonth()
|
tMonth = doHandleZero(tMonth + 1)
|
|
return tYear + "-" + tMonth + "-01"
|
}
|
|
// 获取当前年-月-日
|
function getDateNow() {
|
var myDate = new Date();
|
var tYear = myDate.getFullYear()
|
var tMonth = myDate.getMonth()
|
var tDay = myDate.getDate()
|
tMonth = doHandleZero(tMonth + 1)
|
tDay = doHandleZero(tDay)
|
|
return tYear + "-" + tMonth + "-" + tDay
|
}
|
//获取几年前，默认一年前的今天
|
function getLastYear(yearNum = 1) {
|
let today = new Date() //当天
|
today.setFullYear(today.getFullYear() - yearNum)
|
|
var tYear = today.getFullYear()
|
var tMonth = today.getMonth()
|
var tDay = today.getDate()
|
tMonth = doHandleZero(tMonth + 1)
|
tDay = doHandleZero(tDay)
|
|
return tYear + "-" + tMonth + "-" + tDay
|
}
|
//当年第一天
|
function getFirstDayOfYear() {
|
var date = new Date();
|
date.setDate(1);
|
date.setMonth(0);
|
|
var tYear = date.getFullYear()
|
var tMonth = date.getMonth()
|
var tDay = date.getDate()
|
tMonth = doHandleZero(tMonth + 1)
|
tDay = doHandleZero(tDay)
|
|
return tYear + "-" + tMonth + "-" + tDay
|
}
|
|
form.on('radio(statement)', function (data) {
|
//alert(data.value);
|
if (data.value == "日报") {
|
laydate.render({
|
elem: '#StartTime',
|
value: getDateNow(),
|
format: 'yyyy-MM-dd' //可任意组合
|
});
|
//console.log(getDateNow());
|
}
|
else if (data.value == "月报") {
|
laydate.render({
|
elem: '#StartTime',
|
value: getDate(),
|
format: 'yyyy-MM-dd' //可任意组合
|
});
|
//console.log(getDate());
|
}
|
else if (data.value == "年报") {
|
laydate.render({
|
elem: '#StartTime',
|
value: getFirstDayOfYear(),
|
format: 'yyyy-MM-dd' //可任意组合
|
});
|
//console.log(getLastYear());
|
//console.log(getFirstDayOfYear());
|
}
|
})
|
//获取当前时间
|
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;
|
};
|
|
function refreshTable(GoodId, StartTime, EndTime, GoodsName, LotNo) {
|
var startdata = StartTime.substring(6, 10) + "-" + StartTime.substring(3, 5) + "-" + StartTime.substring(0, 2);
|
console.log(startdata);
|
var param = {
|
GoodId: GoodId,
|
StartTime: StartTime,
|
EndTime: EndTime,
|
GoodsName: GoodsName,
|
LotNo: LotNo,
|
Type: 1
|
};
|
sendData(IP + "/ReportMonth/GetReportDayList", param, 'post', function (res) {
|
console.log(res);
|
if (res.code == 1) { //成功
|
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 param = {
|
GoodId: $("#GoodId").val(),
|
StartTime: date1,
|
EndTime: date1,
|
GoodsName: $("#GoodsName").val(),
|
LotNo: $("#LotNo").val(),
|
};
|
var url = IP + "/ReportMonth/GetReportDayList";
|
// 表单需要的变量
|
var tableIns = table.render({
|
// title:"库存信息"+getNowTime(),
|
elem: '#LAY-app-content-list',
|
height: 'full-95',
|
id: 'LAY-app-content-list',
|
url: url,
|
method: 'POST',
|
page: true,
|
where: param,
|
contentType: 'application/json',
|
limit: pageCnt,
|
limits: pageLimits,
|
response:{
|
statusCode:1
|
},
|
cellMinWidth: 60, //全局定义常规单元格的最小宽度，layui 2.2.1 新增
|
cols: [
|
[
|
// {
|
// field: 'WarehouseName',
|
// title: '所属库房',
|
// align: 'center',
|
// width: 150,
|
// fixed: 'left'
|
// },
|
{
|
field: 'GoodId',
|
title: '物品编码',
|
align: 'center',
|
|
|
}, {
|
field: 'GoodsName',
|
title: '物品名称',
|
align: 'center',
|
|
}
|
// , {
|
// field: 'GoodsStandard',
|
// title: '物品规格',
|
// align: 'center',
|
|
// }
|
, {
|
field: 'LotNo',
|
title: '批次',
|
align: 'center',
|
width: 100,
|
}
|
// , {
|
// field: 'UnitName',
|
// title: '计量单位',
|
// align: 'center',
|
|
// }
|
// {
|
// field: 'StockQuantityOld',
|
// title: '期初库存',
|
// align: 'center',
|
// width: 100,
|
// },
|
, {
|
field: 'ImportQuantity',
|
title: '入库数量',
|
align: 'center',
|
|
}, {
|
field: 'ExportQuantity',
|
title: '出库数量',
|
align: 'center',
|
|
}
|
//, {
|
// field: 'StockQuantityNow',
|
// title: '当期库存',
|
// align: 'center',
|
// width: 100,
|
// },
|
// {
|
// field: 'ReportDateStringEx',
|
// title: '统计周期',
|
// align: 'center',
|
// }, {
|
// field: 'ReportDate',
|
// title: '统计时间',
|
// align: 'center',
|
// fixed: 'right',
|
// width: 180,
|
// },
|
]
|
],
|
});
|
|
form.on('submit(LAY-app-contlist-search)', function (data) {
|
tableIns.reload({
|
where: { //设定异步数据接口的额外参数，任意设
|
GoodId: $("#GoodId").val(),
|
StartTime: $("#StartTime").val(),
|
EndTime: $("#EndTime").val(),
|
GoodsName: $("#GoodsName").val(),
|
LotNo: $("#LotNo").val(),
|
},
|
page: {
|
curr: 1 //重新从第 1 页开始
|
}
|
});
|
});
|
//--------------------------------------------
|
form.on('submit(daochu)', function (data) {
|
layer.confirm('确定导出当前数据吗？', function(index) {
|
var values = $('input[name = "statement"]:checked').val()
|
|
var param = {
|
GoodId: $("#GoodId").val(),
|
StartTime: $("#StartTime").val(),
|
EndTime: $("#EndTime").val(),
|
GoodsName: $("#GoodsName").val(),
|
LotNo: $("#LotNo").val(),
|
};
|
var list;
|
synData(IP + "/Stock/GetStockSlotListDaoChu", param, 'post', function (res) {
|
console.log(res);
|
if (res.code == 1) { //成功
|
list = res.data;
|
|
} else { //不成功
|
layer.msg('获取信息失败！', {
|
icon: 2,
|
time: 2000 //2秒关闭（如果不配置，默认是3秒）
|
}, function () { });
|
}
|
});
|
if(values == "日报"){
|
table.exportFile(tableIns.config.id, list,'xls',"日报"+getNowTime()); //data 为该实例中的任意数量的数据
|
layer.msg('导出成功！', {
|
icon: 1,
|
time: 2000 //2秒关闭（如果不配置，默认是3秒）
|
}, function () {});
|
}else if(values == "月报"){
|
table.exportFile(tableIns.config.id, list,'xls',"月报"+getNowTime()); //data 为该实例中的任意数量的数据
|
layer.msg('导出成功！', {
|
icon: 1,
|
time: 2000 //2秒关闭（如果不配置，默认是3秒）
|
}, function () {});
|
}else if(values == "年报"){
|
table.exportFile(tableIns.config.id, list,'xls',"年报"+getNowTime()); //data 为该实例中的任意数量的数据
|
layer.msg('导出成功！', {
|
icon: 1,
|
time: 2000 //2秒关闭（如果不配置，默认是3秒）
|
}, function () {});
|
}
|
});
|
});
|
});
|
</script>
|
</body>
|
|
</html>
|
