src/main/java/com/zy/asrs/controller/ReportQueryController.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/webapp/static/js/report/locMap.js | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/webapp/views/report/viewLocMap.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/java/com/zy/asrs/controller/ReportQueryController.java
@@ -78,6 +78,11 @@ } //-----------------库存MAP图-------------------------------------- @RequestMapping("/viewLocMapList/rows.action") public R queryViewLocMapRows(){ return R.ok().add(reportQueryMapper.getViewLocRowTotal()); } @RequestMapping("/viewLocMapList.action") public R queryViewLocMapListByPages(@RequestParam(defaultValue = "1")Integer row){ // 获取排级数据 src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java
@@ -24,6 +24,9 @@ public List<ViewStayTimeBean> getViewStayTimeAll(ViewStayTimeBean viewStayTime); // // 库位Map @Select("select distinct row1 from asr_loc_mast order by row1 asc") List<Integer> getViewLocRowTotal(); @Select("select distinct lev1 from asr_loc_mast where row1=#{row1} order by lev1 desc") public List<String> getViewLocLevCount(@Param("row1") int row1); // src/main/webapp/static/js/report/locMap.js
@@ -3,8 +3,31 @@ var layer = layui.layer; var form = layui.form; getLocMapRows(); getLocTable(1); function getLocMapRows() { $.ajax({ url: baseUrl+"/report/viewLocMapList/rows.action", headers: {'token': localStorage.getItem('token')}, method: 'POST', async: false, success: function (res) { if (res.code === 200) { var tpl = $("#locMastRowTemplate").html(); var template = Handlebars.compile(tpl); var html = template(res); $('#rowSelect').append(html); form.render('select'); } else if (res.code === 403) { top.location.href = baseUrl+"/"; } else { layer.msg(res.msg) } } }); } function getLocTable(row){ $.ajax({ url: baseUrl+"/report/viewLocMapList.action", src/main/webapp/views/report/viewLocMap.html
@@ -57,15 +57,15 @@ <div id="search-box" class="layui-form layui-card-header"> <div class="layui-inline" style="margin-left: 10px"> <div class="layui-input-inline"> <select name="row" lay-filter="row"> <option value="1">第1排</option> <option value="2">第2排</option> <option value="3">第3排</option> <option value="4">第4排</option> <option value="5">第5排</option> <option value="6">第6排</option> <option value="7">第7排</option> <option value="8">第8排</option> <select id="rowSelect" name="row" lay-filter="row"> <!-- <option value="1">第1排</option>--> <!-- <option value="2">第2排</option>--> <!-- <option value="3">第3排</option>--> <!-- <option value="4">第4排</option>--> <!-- <option value="5">第5排</option>--> <!-- <option value="6">第6排</option>--> <!-- <option value="7">第7排</option>--> <!-- <option value="8">第8排</option>--> </select> </div> </div> @@ -102,5 +102,10 @@ <script type="text/javascript" src="../../static/js/handlebars/handlebars-v4.5.3.js"></script> <script type="text/javascript" src="../../static/js/report/locMap.js" charset="utf-8"></script> </body> <script type="text/template" id="locMastRowTemplate"> {{#each data}} <option value="{{this}}">{{this}}</option> {{/each}} </script> </html>