From ea327cdeca992d02acc2b2744e09ef449c0ee3cb Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期五, 12 五月 2023 14:27:51 +0800
Subject: [PATCH] 库临、库存上下限

---
 src/main/webapp/views/home/console.html |  115 +++++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 111 insertions(+), 4 deletions(-)

diff --git a/src/main/webapp/views/home/console.html b/src/main/webapp/views/home/console.html
index ce1ed60..aff7c04 100644
--- a/src/main/webapp/views/home/console.html
+++ b/src/main/webapp/views/home/console.html
@@ -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: 'loc_no', 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: '搴撲綅鍙�',width: 90}
+
         ];
         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>
\ No newline at end of file

--
Gitblit v1.9.1