src/main/java/com/zy/asrs/controller/LocDetlController.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/java/com/zy/asrs/entity/WrkMast.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/java/com/zy/asrs/utils/Utils.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/resources/mapper/LocDetlMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/webapp/static/js/locDetl/locDetl.js | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/webapp/views/locOwner/locOwner.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/java/com/zy/asrs/controller/LocDetlController.java
@@ -241,6 +241,31 @@ } return R.ok(exportSupport(result, fields)); } @RequestMapping(value = "/locDetl/export/auth/v2") @ManagerAuth(memo = "库位明细导出") public synchronized R exportV2(@RequestBody JSONObject param) { List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class); EntityWrapper<LocDetl> wrapper = new EntityWrapper<>(); Map<String, Object> map = excludeTrash(param.getJSONObject("locDetl")); String row = ""; if (map.get("row") != null) { String chooseRow = (String) map.get("row"); if (chooseRow.length() == 1) { row = "0" + chooseRow; map.remove("row"); } else { row = chooseRow; map.remove("row"); } } convert(map, wrapper); if (!row.equals("")) { wrapper.and() .where("loc_no like '" + row + "%'"); } List<LocDetl> list = locDetlService.selectList(wrapper); return R.ok(exportSupport(list, fields)); } @RequestMapping(value = "/locDetlQuery/auth") @ManagerAuth @@ -419,14 +444,15 @@ if (!Cools.isEmpty(mat.getStoreMaxDate())) { if (Cools.isEmpty(locDetl.getBatch())) { continue; } else if (locDetl.getBatch().length() != 8) { continue; } // if (Cools.isEmpty(locDetl.getBatch())) { // continue; // } else if (locDetl.getBatch().length() != 8) { // continue; // } try { SimpleDateFormat simple = new SimpleDateFormat("yyyyMMdd"); Date maxDate = simple.parse(locDetl.getBatch()); // SimpleDateFormat simple = new SimpleDateFormat("yyyyMMdd"); // Date maxDate = simple.parse(locDetl.getBatch()); Date maxDate = locDetl.getModiTime(); Calendar calendar = new GregorianCalendar(); calendar.setTime(maxDate); // 把日期往后增加一天,整数 往后推,负数往前移动 @@ -443,7 +469,7 @@ abnormalLocDetlParam.setSpecs(mat.getSpecs()); abnormalLocDetlParam.setBatch(locDetl.getBatch()); if (now.compareTo(maxDate) > 0) { long difference = (now.getTime() - maxDate.getTime()) / (24 * 60 * 60 * 1000); long difference = (now.getTime() - locDetl.getModiTime().getTime()) / (24 * 60 * 60 * 1000); abnormalLocDetlParam.setNowTime(Integer.parseInt(String.valueOf(difference))); result.add(abnormalLocDetlParam); } src/main/java/com/zy/asrs/entity/WrkMast.java
@@ -431,10 +431,14 @@ if (wrkDetls.get(0).getOrderNo() != null) { for (WrkDetl wrkDetl : wrkDetls) { String orderNo$ = ""; if(!wrkDetl.getOrderNo().startsWith("[") || !wrkDetl.getOrderNo().endsWith("]")) { return wrkDetl.getOrderNo(); } else { JSON.parseArray(wrkDetl.getOrderNo(), DetlDto.class).forEach(detlDto -> { resultRecords.add(detlDto.getOrderNo()); }); } } } int size = resultRecords.size(); src/main/java/com/zy/asrs/utils/Utils.java
@@ -488,8 +488,8 @@ add(zerofill(String.valueOf(3), 2) + locNo.substring(2)); }}; case 3: return new ArrayList<>(); case 4: return new ArrayList<>(); case 5: return new ArrayList<String>() {{ add(zerofill(String.valueOf(4), 2) + locNo.substring(2)); @@ -521,8 +521,8 @@ add(zerofill(String.valueOf(11), 2) + locNo.substring(2)); }}; case 11: return new ArrayList<>(); case 12: return new ArrayList<>(); case 13: return new ArrayList<String>() {{ add(zerofill(String.valueOf(12), 2) + locNo.substring(2)); @@ -548,8 +548,8 @@ add(zerofill(String.valueOf(18), 2) + locNo.substring(2)); }}; case 18: return new ArrayList<>(); case 19: return new ArrayList<>(); case 20: return new ArrayList<String>() {{ add(zerofill(String.valueOf(19), 2) + locNo.substring(2)); src/main/resources/mapper/LocDetlMapper.xml
@@ -201,11 +201,11 @@ , a.loc_no as locNo , a.batch , a.anfme , a.modi_time as modiTime from asr_loc_detl a where 1=1 and batch!='' and batch is not null <include refid="stockOutCondition"></include> group by a.matnr,a.batch,a.anfme, a.loc_no group by a.matnr,a.batch,a.anfme, a.loc_no, a.modi_time ) t where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize}) </select> src/main/webapp/static/js/locDetl/locDetl.js
@@ -199,7 +199,7 @@ }; var loadIndex = layer.msg('正在导出...', {icon: 16, shade: 0.01, time: false}); $.ajax({ url: baseUrl+"/locDetl/export/auth", url: baseUrl+"/locDetl/export/auth/v2", headers: {'token': localStorage.getItem('token')}, data: JSON.stringify(param), dataType:'json', src/main/webapp/views/locOwner/locOwner.html
@@ -29,7 +29,7 @@ <!-- </div>--> <div class="layui-inline"> <div class="layui-input-inline"> <input class="layui-input" type="text" name="condition" placeholder="请输入" autocomplete="off"> <input class="layui-input" type="text" name="owner" placeholder="请输入" autocomplete="off"> </div> </div> <div class="layui-inline">  @@ -73,7 +73,7 @@ <div class="layui-row"> <div class="layui-col-md12"> <div class="layui-form-item"> <label class="layui-form-label layui-form-required">: </label> <label class="layui-form-label layui-form-required">客户信息: </label> <div class="layui-input-block"> <input class="layui-input" name="owner" placeholder="请输入" lay-vertype="tips" lay-verify="required"> </div>