zy-asrs.git - Gitblit

			@@ -7,11 +7,11 @@
			<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
			<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
			<link rel="stylesheet" href="../../static/layui/css/layui.css" media="all">
			<script type="text/javascript" src="../../static/js/common.js"></script>
			<script type="text/javascript" src="../../static/layui/layui.js"></script>
			<script type="text/javascript" src="../../static/js/jquery/jquery-3.3.1.min.js"></script>
			<script type="text/javascript" src="../../static/js/echarts/echarts.min.js"></script>
			<script type="text/javascript" src="../../static/js/echarts/highcharts.js"></script>
			<script type="text/javascript" src="../../static/js/common.js?v=100"></script>
			<script type="text/javascript" src="../../static/layui/layui.js?v=100"></script>
			<script type="text/javascript" src="../../static/js/jquery/jquery-3.3.1.min.js?v=100"></script>
			<script type="text/javascript" src="../../static/js/echarts/echarts.min.js?v=100"></script>
			<script type="text/javascript" src="../../static/js/echarts/highcharts.js?v=100"></script>
			<style>
			body {
			background-color: #f1f1f1;
			@@ -85,6 +85,12 @@
			.layui-form.layui-border-box.layui-table-view {
			border-top: 1px solid rgba(0,0,0,.1);
			}
			#search-box {
			margin-left: 10px;
			z-index: 999;
			position: relative;
			padding: 0 30px 10px 30px;
			}
			</style>
			</head>
			<body>
			@@ -103,6 +109,29 @@
			<div class="home-elem loc-retention">
			<div class="layui-form">
			<div id="form-header">库存滞留时间统计表</div>
			<div class="layui-card" style="padding: 0 20px 1px 20px;">
			<fieldset class="layui-elem-field site-demo-button" style="margin: 20px;">
			<legend>搜索栏</legend>
			<div id="search-box" class="layui-form layui-card-header">
			<div class="layui-inline">
			<div class="layui-input-inline">
			<input class="layui-input" type="text" name="matnr" placeholder="商品编号" autocomplete="off">
			</div>
			</div>
			<div class="layui-inline">
			<div class="layui-input-inline">
			<input class="layui-input" type="text" name="specs" placeholder="规格" autocomplete="off">
			</div>
			</div>
			<!-- 待添加 -->
			<div id="data-search-btn" class="layui-btn-container layui-form-item" style="display: inline-block">
			<button id="search" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="search">搜索</button>
			<button id="reset" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="reset">重置</button>
			</div>
			</div>
			</fieldset>

			</div>
			<table class="layui-hide" id="stayTime" lay-filter="stayTime"></table>
			</div>
			</div>
			@@ -235,17 +264,24 @@
			var pageCurr;
			function getCol() {
			var cols = [
			{field: 'appeTime$', title: '入库时间', align: 'center', width: 200}
			,{field: 'stay_time', align: 'center',title: '滞留天数'}
			//{field: 'appeTime$', title: '入库时间', align: 'center', width: 165}
			{field: 'stay_time', align: 'center',title: '滞留天数',width: 90}
			//,{field: 'store_max_date', align: 'center',title: '库龄上限',width: 90}
			//,{field: 'store_min', title: '库存下限', align: 'center'}
			,{field: 'sum_qty', title: '库存总数', align: 'center'}
			//,{field: 'store_max', title: '库存上限', align: 'center'}
			,{field: 'loc_no', align: 'center',title: '库位号'}

			];
			cols.push.apply(cols, detlCols);
			//cols.push({field: 'sum_qty', title: '库存总数', align: 'center'})
			return cols;
			}
			layui.use(['table','laydate', 'form'], function() {
			var table = layui.table;
			var $ = layui.jquery;
			var layer = layui.layer;
			var form = layui.form;

			// 数据渲染
			tableIns = table.render({
			@@ -275,6 +311,37 @@
			statusCode: 200
			},
			done: function(res, curr, count) {
			var that = this.elem.next();
			res.data.forEach(function (item, index) {
			var tr = that.find(".layui-table-box tbody tr[data-index='" + index + "']");
			if (item.store_max_date != null) {
			if (item.stay_time > item.store_max_date) {
			tr.css("background-color", "#ff6f00");
			tr.css("color", "white");
			tr.children()[1].style.backgroundColor="#ff0000"
			}
			}
			//低于下限
			if (item.sum_qty < item.store_min) {
			tr.css("background-color", "#ff6f00");
			tr.css("color", "white");
			tr.children()[2].style.backgroundColor="rgb(255,0,0)"
			tr.children()[2].style.color="white"
			tr.children()[3].style.backgroundColor="#ff0000"
			tr.children()[3].style.color="white"
			}
			//高于上限
			if(item.store_max != null) {
			if (item.sum_qty > item.store_max) {
			tr.css("background-color", "#ff6f00");
			tr.css("color", "white");
			tr.children()[3].style.backgroundColor="#009c04"
			tr.children()[3].style.color="white"
			tr.children()[4].style.backgroundColor="#3da83f"
			tr.children()[4].style.color="white"
			}
			}
			});
			if (res.code === 403) {
			top.location.href = baseUrl+"/";
			}
			@@ -296,6 +363,16 @@
			curr: 1
			},
			done: function (res, curr, count) {
			var that = this.elem.next();
			res.data.forEach(function (item, index) {
			if (item.store_max_date != null) {
			if (item.stay_time > item.store_max_date) {
			var tr = that.find(".layui-table-box tbody tr[data-index='" + index + "']");
			tr.css("background-color", "#FF5722");
			tr.css("color", "white");
			}
			}
			});
			if (res.code === 403) {
			top.location.href = baseUrl+"/";
			}
			@@ -303,6 +380,36 @@
			}
			});
			});

			// 搜索栏搜索事件
			form.on('submit(search)', function (data) {
			tableReload();
			});
			// 搜索栏搜索事件
			form.on('submit(reset)', function (data) {
			$(':input', $('#search-box'))
			.val('')
			.removeAttr('checked')
			.removeAttr('selected');
			var searchData = {};
			$.each($('#search-box [name]').serializeArray(), function() {
			searchData[this.name] = this.value;
			});
			tableIns.reload({
			where: searchData
			});

			});

			function tableReload() {
			var searchData = {};
			$.each($('#search-box [name]').serializeArray(), function() {
			searchData[this.name] = this.value;
			});
			tableIns.reload({
			where: searchData
			});
			}
			});


			@@ -330,4 +437,4 @@
			return fmt;
			}
			</script>
			</html>
			</html>