#

luxiaotao1123

2021-03-06 8e13b1cf8fd11809837fa2c958d608a1c38732db

#

 src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java

@@ -95,11 +95,29 @@
                pakoutList.get(i).put("wrkStsName", wrkSts.getStsName());
            }
        }

        // 安全库存警告
        List<Map<String, Object>> safeQuaList = jdbcTemplate.queryForList("select \n" +
                "top 10\n" +
                "mp.node_id,\n" +
                "mp.node_name,\n" +
                "mp.matnr,\n" +
                "mp.maktx,\n" +
                "mp.safe_qua,\n" +
                "mld.anfme,\n" +
                "(mp.safe_qua - mld.anfme) as dValue\n" +
                "from man_prior mp\n" +
                "left join \n" +
                "(select SUM(anfme) as anfme, node_id from man_loc_detl where 1=1 group by node_id) mld on mp.node_id = mld.node_id\n" +
                "where 1=1 \n" +
                "order by (mp.safe_qua - mld.anfme) desc");
        for (int i=0;i<safeQuaList.size();i++) {
            safeQuaList.get(i).put("no", i+1);
        }

        return R.ok().add(Cools
                .add("combList", combList) // 组托最新动态
                .add("pakoutList", pakoutList) // 最新拣货单
                .add("safeQuaList", safeQuaList) // 安全库存警告
        );
    }


 src/main/webapp/views/home/console.html

@@ -40,7 +40,7 @@
        /** 小组成员 */
        .console-user-group {
            position: relative;
            padding: 10px 0 10px 60px;
            padding: 10px 0 10px 40px;
        }

        .console-user-group .console-user-group-head {
@@ -49,8 +49,10 @@
            position: absolute;
            top: 50%;
            left: 12px;
            margin-top: -16px;
            margin-top: -10px;
            border-radius: 50%;
            font-size: 18px;
            font-weight: bolder;
        }

        .console-user-group .layui-badge {
@@ -406,27 +408,26 @@
                            <col>
                        </colgroup>
                        <tbody>
                        <script type="text/html" ew-tpl>
                            <tr>
                                <td>当前版本</td>
                                <td>v{{layui.admin.version}} &emsp; <a href="https://easyweb.vip/doc/" target="_blank">更新日志</a>
                                </td>
                            </tr>
                            <tr>
                                <td>基于框架</td>
                                <td>layui-v{{layui.v}}</td>
                            </tr>
                        </script>
<!--                        <script type="text/html" ew-tpl>-->
<!--                            <tr>-->
<!--                                <td>当前版本</td>-->
<!--                                <td>v{{layui.admin.version}} &emsp; <a href="https://easyweb.vip/doc/" target="_blank">更新日志</a>-->
<!--                                </td>-->
<!--                            </tr>-->
<!--                            <tr>-->
<!--                                <td>基于框架</td>-->
<!--                                <td>layui-v{{layui.v}}</td>-->
<!--                            </tr>-->
<!--                        </script>-->
                        <tr>
                            <td>主要特色</td>
                            <td>单页面 / 响应式 / 简约 / 易上手</td>
                            <td>版本号</td>
                            <td>Version 1.0.0</td>
                        </tr>
                        <tr>
                            <td>获取渠道</td>
                            <td>立库入口</td>
                            <td>
                                <a href="http://easyweb.vip" class="layui-btn layui-btn-sm layui-btn-danger"
                                   target="_blank">获取授权</a>
                                <a href="http://easyweb.vip/user/order" target="_blank" class="layui-btn layui-btn-sm">立即下载</a>
                                <a href="http://localhost:8080/wms" class="layui-btn layui-btn-sm layui-btn-danger" target="_blank">A-WMS</a>
                                <a href="http://localhost:8080/wcs" target="_blank" class="layui-btn layui-btn-sm">WCS</a>
                            </td>
                        </tr>
                        </tbody>
@@ -434,32 +435,8 @@
                </div>
            </div>
            <div class="layui-card">
                <div class="layui-card-header">小组成员</div>
                <div class="layui-card-body">
                    <div class="console-user-group">
                        <img src="../../assets/images/head.jpg" class="console-user-group-head" alt=""/>
                        <div class="console-user-group-name">周星星</div>
                        <div class="console-user-group-desc">产品负责人</div>
                        <span class="layui-badge layui-badge-green">在线</span>
                    </div>
                    <div class="console-user-group">
                        <img src="../../assets/images/head.jpg" class="console-user-group-head" alt=""/>
                        <div class="console-user-group-name">周星星</div>
                        <div class="console-user-group-desc">项目负责人</div>
                        <span class="layui-badge layui-badge-green">在线</span>
                    </div>
                    <div class="console-user-group">
                        <img src="../../assets/images/head.jpg" class="console-user-group-head" alt=""/>
                        <div class="console-user-group-name">周星星</div>
                        <div class="console-user-group-desc">产品负责人</div>
                        <span class="layui-badge layui-badge-red">离线</span>
                    </div>
                    <div class="console-user-group">
                        <img src="../../assets/images/head.jpg" class="console-user-group-head" alt=""/>
                        <div class="console-user-group-name">周星星</div>
                        <div class="console-user-group-desc">测试负责人</div>
                        <span class="layui-badge layui-badge-red">离线</span>
                    </div>
                <div class="layui-card-header">安全库存警告</div>
                <div class="layui-card-body" id="safeQuaList">
                </div>
            </div>
            <div class="layui-card">
@@ -568,6 +545,11 @@
                        var template2 = Handlebars.compile(tpl2);
                        var html2 = template2(res.data);
                        $('#pakoutList').append(html2);
                        // 安全库存
                        var tpl3 = $('#safeQuaTpl').html();
                        var template3 = Handlebars.compile(tpl3);
                        var html3 = template3(res.data);
                        $('#safeQuaList').append(html3);
                    } else if (res.code === 403) {
                        top.location.href = baseUrl + "/";
                    } else {
@@ -605,5 +587,15 @@
        </tr>
    {{/each}}
</script>
<script type="text/template" id="safeQuaTpl">
    {{#each safeQuaList}}
        <div class="console-user-group">
            <div class="console-user-group-head">{{no}}</div>
            <div class="console-user-group-name">{{node_name}}</div>
            <div class="console-user-group-desc">{{maktx}}</div>
            <span class="layui-badge layui-badge-red" style="letter-spacing: 1px">需入库：{{dValue}}</span>
        </div>
    {{/each}}
</script>
</body>
</html>