From b941445f4b77a70d7d9d5b38926c8ac5dbc20f5f Mon Sep 17 00:00:00 2001 From: whycq <10027870+whycq@user.noreply.gitee.com> Date: 星期三, 03 七月 2024 09:28:04 +0800 Subject: [PATCH] # --- src/main/webapp/static/image/logo2.png | 0 src/main/java/com/zy/asrs/entity/param/CombParam.java | 3 + src/main/java/com/zy/asrs/mapper/LocDetlMapper.java | 2 src/main/java/com/zy/asrs/entity/OrderDetl.java | 7 ++ src/main/java/com/zy/asrs/service/LocDetlService.java | 2 src/main/resources/mapper/LocDetlMapper.xml | 91 ++++++++++++++++++++++++++++++ src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java | 5 + src/main/webapp/views/pakStore/locDetlQuery.html | 5 + src/main/resources/mapper/OrderDetlMapper.xml | 1 src/main/webapp/static/js/locDetl/locDetl.js | 1 /dev/null | 0 src/main/java/com/zy/asrs/entity/param/CheckBom.java | 2 src/main/webapp/static/image/logo1.png | 0 src/main/webapp/static/js/order/out.js | 9 +- src/main/webapp/static/js/order/order.js | 18 +++-- src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java | 1 src/main/java/com/zy/asrs/controller/BomMatController.java | 1 src/main/webapp/static/js/common.js | 1 src/main/java/com/zy/asrs/controller/OutController.java | 8 ++ 19 files changed, 143 insertions(+), 14 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/BomMatController.java b/src/main/java/com/zy/asrs/controller/BomMatController.java index a89a53e..59de2ce 100644 --- a/src/main/java/com/zy/asrs/controller/BomMatController.java +++ b/src/main/java/com/zy/asrs/controller/BomMatController.java @@ -94,6 +94,7 @@ if (Cools.isEmpty(bomMat) || null==bomMat.getId()){ return R.error(); } + bomMat.setZpalletAnfme(bomMat.getBomAnfme() * bomMat.getBomCount()); bomMat.setModiUser(getUserId()); bomMat.setModiTime(new Date()); bomMatService.updateById(bomMat); diff --git a/src/main/java/com/zy/asrs/controller/OutController.java b/src/main/java/com/zy/asrs/controller/OutController.java index d0b363b..a7004eb 100644 --- a/src/main/java/com/zy/asrs/controller/OutController.java +++ b/src/main/java/com/zy/asrs/controller/OutController.java @@ -62,9 +62,15 @@ Set<String> exist = new HashSet<>(); for (OrderDetl orderDetl : orderDetls) { + List<LocDetl> locDetls = new ArrayList<>(); double issued = Optional.of(orderDetl.getAnfme() - orderDetl.getWorkQty()).orElse(0.0D); if (issued <= 0.0D) { continue; } - List<LocDetl> locDetls = locDetlService.queryStock(orderDetl.getMatnr(), orderDetl.getBatch(), null, exist); + //if (Cools.isEmpty(orderDetl.getBomCode())) { + // locDetls = locDetlService.queryStock(orderDetl.getMatnr(), orderDetl.getBatch(), null, exist); + //} else { + // locDetls = locDetlService.queryStockByBomcode(orderDetl.getMatnr(), orderDetl.getBatch(), orderDetl.getBomCode(),null, exist); + //} + locDetls = locDetlService.queryStockByBomcode(orderDetl.getMatnr(), orderDetl.getBatch(), orderDetl.getBomCode(),null, exist); for (LocDetl locDetl : locDetls) { if (issued > 0) { LocDto locDto = new LocDto(locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getMaktx(), locDetl.getBatch(), orderDetl.getOrderNo(), diff --git a/src/main/java/com/zy/asrs/entity/OrderDetl.java b/src/main/java/com/zy/asrs/entity/OrderDetl.java index cbfd85f..0fc7fc4 100644 --- a/src/main/java/com/zy/asrs/entity/OrderDetl.java +++ b/src/main/java/com/zy/asrs/entity/OrderDetl.java @@ -296,9 +296,13 @@ @ApiModelProperty(value= "澶囨敞") private String memo; + @ApiModelProperty(value= "bom鍙�") + @TableField("bom_code") + private String bomCode; + public OrderDetl() {} - public OrderDetl(Long orderId, String orderNo, Double anfme, Double qty, String matnr, String maktx, String batch, String specs, String model, String color, String brand, String unit, Double price, String sku, Double units, String barcode, String origin, String manu, String manuDate, String itemNum, Double safeQty, Double weight, Double length, Double volume, String threeCode, String supp, String suppCode, Integer beBatch, String deadTime, Integer deadWarn, Integer source, Integer inspect, Integer danger, Integer status, Long createBy, Date createTime, Long updateBy, Date updateTime, String memo) { + public OrderDetl(Long orderId, String orderNo, Double anfme, Double qty, String matnr, String maktx, String batch, String specs, String model, String color, String brand, String unit, Double price, String sku, Double units, String barcode, String origin, String manu, String manuDate, String itemNum, Double safeQty, Double weight, Double length, Double volume, String threeCode, String supp, String suppCode, Integer beBatch, String deadTime, Integer deadWarn, Integer source, Integer inspect, Integer danger, Integer status, Long createBy, Date createTime, Long updateBy, Date updateTime, String memo, String bomCode) { this.orderId = orderId; this.orderNo = orderNo; this.anfme = anfme; @@ -338,6 +342,7 @@ this.updateBy = updateBy; this.updateTime = updateTime; this.memo = memo; + this.bomCode = bomCode; } public String getOrderId$(){ diff --git a/src/main/java/com/zy/asrs/entity/param/CheckBom.java b/src/main/java/com/zy/asrs/entity/param/CheckBom.java index 853fd9f..ba24b5f 100644 --- a/src/main/java/com/zy/asrs/entity/param/CheckBom.java +++ b/src/main/java/com/zy/asrs/entity/param/CheckBom.java @@ -4,7 +4,7 @@ @Data public class CheckBom { - // bom鍙� + // BOM鍙� private String bomCode; // 鐗╂枡鍙� diff --git a/src/main/java/com/zy/asrs/entity/param/CombParam.java b/src/main/java/com/zy/asrs/entity/param/CombParam.java index 4a1f2da..e8370ef 100644 --- a/src/main/java/com/zy/asrs/entity/param/CombParam.java +++ b/src/main/java/com/zy/asrs/entity/param/CombParam.java @@ -29,6 +29,9 @@ //璁㈠崟缂栧彿 private String orderNo; + // Bom鍙� + private String bomCode; + // 鐗╂枡缂栧彿 private String matnr; diff --git a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java index 350c5de..2df04c5 100644 --- a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java @@ -56,6 +56,8 @@ List<LocDetl> queryStock(@Param("matnr")String matnr, @Param("batch")String batch, @Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos); + List<LocDetl> queryStockByBomcode(@Param("matnr")String matnr, @Param("batch")String batch, @Param("bomCode")String bomCode, @Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos); + Double queryStockAnfme(String matnr, String batch); List<StockVo> queryStockTotal(); diff --git a/src/main/java/com/zy/asrs/service/LocDetlService.java b/src/main/java/com/zy/asrs/service/LocDetlService.java index 1ff1079..61609c3 100644 --- a/src/main/java/com/zy/asrs/service/LocDetlService.java +++ b/src/main/java/com/zy/asrs/service/LocDetlService.java @@ -45,6 +45,8 @@ List<LocDetl> queryStock(String matnr, String batch, String orderNo, Set<String> locNos); + List<LocDetl> queryStockByBomcode(String matnr, String batch, String bomCode,String orderNo, Set<String> locNos); + Double queryStockAnfme(String matnr, String batch); List<StockVo> queryStockTotal(); diff --git a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java index d8374e3..a085f57 100644 --- a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java @@ -82,6 +82,11 @@ } @Override + public List<LocDetl> queryStockByBomcode(String matnr, String batch, String bomCode,String orderNo, Set<String> locNos) { + return this.baseMapper.queryStockByBomcode(matnr, batch, bomCode, orderNo, locNos); + } + + @Override public Double queryStockAnfme(String matnr, String batch) { return this.baseMapper.queryStockAnfme(matnr, batch); } diff --git a/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java index 9248666..18fdaa5 100644 --- a/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java @@ -196,6 +196,7 @@ } WaitPakin waitPakin = new WaitPakin(); waitPakin.sync(mat); + waitPakin.setBomCode(combMat.getBomCode()); waitPakin.setOrderNo(order.getOrderNo()); // 鍗曟嵁缂栧彿 waitPakin.setBatch(combMat.getBatch()); // 搴忓垪鐮� waitPakin.setZpallet(param.getBarcode()); // 鎵樼洏鐮� diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml index e88ab6f..85f6e52 100644 --- a/src/main/resources/mapper/LocDetlMapper.xml +++ b/src/main/resources/mapper/LocDetlMapper.xml @@ -44,6 +44,7 @@ <result column="appe_user" property="appeUser" /> <result column="appe_time" property="appeTime" /> <result column="memo" property="memo" /> + <result column="bom_code" property="bomCode" /> </resultMap> <sql id="batchSeq"> @@ -108,6 +109,9 @@ </if> <if test="zpallet!=null and zpallet!='' "> and a.zpallet like '%' + #{zpallet} + '%' + </if> + <if test="bomCode!=null and bomCode!='' "> + and a.bom_code like '%' + #{bomCode} + '%' </if> </sql> @@ -288,6 +292,93 @@ desc </select> + <select id="queryStockByBomcode" resultMap="BaseResultMap"> + select a.* + from asr_loc_detl a + left join asr_loc_mast b on a.loc_no = b.loc_no + where 1=1 + and b.loc_sts = 'F' + and a.matnr = #{matnr} + <!-- <choose>--> + <!-- <when test="batch != null and batch != ''">--> + <!-- and a.batch = #{batch}--> + <!-- </when>--> + <!-- <otherwise>--> + <!-- and (a.batch IS NULL OR a.batch = '')--> + <!-- </otherwise>--> + <!-- </choose>--> + <if test="batch != null"> + and a.batch = #{batch} + </if> + <if test="orderNo != null and orderNo != ''"> + and a.order_no = #{orderNo} + </if> + + <if test="locNos != null and locNos.size > 0"> + and b.loc_no not in + <foreach item="item" collection="locNos" index="index" separator="," open="(" close=")"> + #{item} + </foreach> + </if> + and a.bom_code = #{bomCode} + order by + DATEPART(yyyy,a.modi_time),DATEPART(mm,a.modi_time),DATEPART(dd,a.modi_time), a.anfme + desc, + NEWID(), + case + when (left(a.loc_no, 2) = '01') then 0 + when (left(a.loc_no, 2) = '02') then 1 + when (left(a.loc_no, 2) = '03') then 1 + when (left(a.loc_no, 2) = '04') then 0 + when (left(a.loc_no, 2) = '05') then 0 + when (left(a.loc_no, 2) = '06') then 1 + when (left(a.loc_no, 2) = '07') then 1 + when (left(a.loc_no, 2) = '08') then 0 + when (left(a.loc_no, 2) = '09') then 0 + when (left(a.loc_no, 2) = '10') then 1 + when (left(a.loc_no, 2) = '11') then 1 + when (left(a.loc_no, 2) = '12') then 0 + when (left(a.loc_no, 2) = '13') then 0 + when (left(a.loc_no, 2) = '14') then 1 + when (left(a.loc_no, 2) = '15') then 1 + when (left(a.loc_no, 2) = '16') then 0 + when (left(a.loc_no, 2) = '17') then 0 + when (left(a.loc_no, 2) = '18') then 1 + when (left(a.loc_no, 2) = '19') then 1 + when (left(a.loc_no, 2) = '20') then 0 + when (left(a.loc_no, 2) = '21') then 0 + when (left(a.loc_no, 2) = '22') then 1 + when (left(a.loc_no, 2) = '23') then 1 + when (left(a.loc_no, 2) = '24') then 0 + when (left(a.loc_no, 2) = '25') then 0 + when (left(a.loc_no, 2) = '26') then 1 + when (left(a.loc_no, 2) = '27') then 1 + when (left(a.loc_no, 2) = '28') then 0 + when (left(a.loc_no, 2) = '29') then 0 + when (left(a.loc_no, 2) = '30') then 1 + when (left(a.loc_no, 2) = '31') then 1 + when (left(a.loc_no, 2) = '32') then 0 + when (left(a.loc_no, 2) = '33') then 0 + when (left(a.loc_no, 2) = '34') then 1 + when (left(a.loc_no, 2) = '35') then 1 + when (left(a.loc_no, 2) = '36') then 0 + when (left(a.loc_no, 2) = '37') then 0 + when (left(a.loc_no, 2) = '38') then 1 + when (left(a.loc_no, 2) = '39') then 1 + when (left(a.loc_no, 2) = '40') then 0 + when (left(a.loc_no, 2) = '41') then 0 + when (left(a.loc_no, 2) = '42') then 1 + when (left(a.loc_no, 2) = '43') then 1 + when (left(a.loc_no, 2) = '44') then 0 + when (left(a.loc_no, 2) = '45') then 0 + when (left(a.loc_no, 2) = '46') then 1 + when (left(a.loc_no, 2) = '47') then 1 + when (left(a.loc_no, 2) = '48') then 0 + else 0 + end + desc + </select> + <select id="queryStockAnfme" resultType="java.lang.Double"> select sum(anfme) as count from man_loc_detl where 1=1 diff --git a/src/main/resources/mapper/OrderDetlMapper.xml b/src/main/resources/mapper/OrderDetlMapper.xml index 3cecff7..089dfa4 100644 --- a/src/main/resources/mapper/OrderDetlMapper.xml +++ b/src/main/resources/mapper/OrderDetlMapper.xml @@ -45,6 +45,7 @@ <result column="update_by" property="updateBy" /> <result column="update_time" property="updateTime" /> <result column="memo" property="memo" /> + <result column="bom_code" property="bomCode" /> </resultMap> diff --git a/src/main/webapp/static/image/logo.png b/src/main/webapp/static/image/logo.png deleted file mode 100644 index 231c97e..0000000 --- a/src/main/webapp/static/image/logo.png +++ /dev/null Binary files differ diff --git a/src/main/webapp/static/image/logo1.png b/src/main/webapp/static/image/logo1.png index 71dd632..c7fcb86 100644 --- a/src/main/webapp/static/image/logo1.png +++ b/src/main/webapp/static/image/logo1.png Binary files differ diff --git a/src/main/webapp/static/image/logo2.png b/src/main/webapp/static/image/logo2.png index 231c97e..965ae27 100644 --- a/src/main/webapp/static/image/logo2.png +++ b/src/main/webapp/static/image/logo2.png Binary files differ diff --git a/src/main/webapp/static/js/common.js b/src/main/webapp/static/js/common.js index 017bce4..bd21907 100644 --- a/src/main/webapp/static/js/common.js +++ b/src/main/webapp/static/js/common.js @@ -233,6 +233,7 @@ ,{field: 'model', align: 'center',title: '浠g爜', hide: false} ,{field: 'color', align: 'center',title: '棰滆壊', hide: true} ,{field: 'brand', align: 'center',title: '绫诲瀷', hide: false} + ,{field: 'bomCode', align: 'center',title: 'BOM鍙�', hide: false} ,{field: 'unit', align: 'center',title: '鍗曚綅', hide: true} ,{field: 'price', align: 'center',title: '鍗曚环', hide: true} ,{field: 'sku', align: 'center',title: 'sku', hide: true} diff --git a/src/main/webapp/static/js/locDetl/locDetl.js b/src/main/webapp/static/js/locDetl/locDetl.js index c43ffcf..80f9f31 100644 --- a/src/main/webapp/static/js/locDetl/locDetl.js +++ b/src/main/webapp/static/js/locDetl/locDetl.js @@ -12,6 +12,7 @@ ,{field: 'model', align: 'center',title: '浠g爜', hide: true} ,{field: 'color', align: 'center',title: '棰滆壊', hide: true} ,{field: 'brand', align: 'center',title: '绫诲瀷', hide: false} + ,{field: 'bomCode', align: 'center',title: 'bom鍙�', hide: false} ,{field: 'unit', align: 'center',title: '鍗曚綅', hide: true} ,{field: 'price', align: 'center',title: '鍗曚环', hide: true} ,{field: 'sku', align: 'center',title: 'sku', hide: true} diff --git a/src/main/webapp/static/js/order/order.js b/src/main/webapp/static/js/order/order.js index 62ab391..2f525b3 100644 --- a/src/main/webapp/static/js/order/order.js +++ b/src/main/webapp/static/js/order/order.js @@ -134,6 +134,7 @@ {type: 'numbers'}, {field: 'matnr', title: '鍟嗗搧缂栫爜', width: 160}, {field: 'maktx', title: '鍟嗗搧鍚嶇О', width: 160}, + {field: 'bomCode', title: 'Bom鍙�'}, {field: 'batch', title: '鎵瑰彿'}, {field: 'anfme', title: '鏁伴噺'}, {field: 'supp', title: '绔嬪簱搴撳瓨', templet: function (item){ @@ -260,6 +261,7 @@ {type: 'numbers', title: '#'}, {field: 'matnr', title: '鍟嗗搧缂栫爜', width: 160}, {field: 'maktx', title: '鍟嗗搧鍚嶇О', width: 200}, + {field: 'bomCode', title: 'Bom鍙�', style: 'color: blue;font-weight: bold', edit: true, minWidth: 110, width: 110}, {field: 'batch', title: '鎵瑰彿', edit: true}, {field: 'specs', title: '瑙勬牸'}, {field: 'anfme', title: '鏁伴噺(淇敼)', style: 'color: blue;font-weight: bold', edit: true, minWidth: 110, width: 110}, @@ -529,9 +531,6 @@ } // 鎵撳嵃 function btnPrint(orderId, orderNo, settle) { - console.log(orderId); - console.log(orderNo); - console.log(settle); printMatCodeNos.push(orderNo) var templateNo = 3; $.ajax({ @@ -543,16 +542,21 @@ success: function (res) { if (res.code === 200){ layer.closeAll(); - console.log(res); for (let i=0;i<res.data.length;i++){ var templateDom = $("#templatePreview"+templateNo); var className = templateDom.attr("class"); if (className === 'template-barcode') { res.data[i]["barcodeUrl"]=baseUrl+"/mac/code/auth?type=1¶m="+res.data[i].orderNo+ - ";"+res.data[i].matnr+";"+res.data[i].batch+";"+res.data[i].anfme; + ";"+res.data[i].matnr+";"+res.data[i].batch+";"+res.data[i].anfme+";"+res.data[i].bomCode; } else { - res.data[i]["barcodeUrl"]=baseUrl+"/mac/code/auth?type=2¶m="+res.data[i].orderNo+ - ";"+res.data[i].matnr+";"+res.data[i].batch+";"+res.data[i].anfme; + if (res.data[i].bomCode) { + res.data[i]["barcodeUrl"]=baseUrl+"/mac/code/auth?type=2¶m="+res.data[i].orderNo+ + ";"+res.data[i].matnr+";"+res.data[i].batch+";"+res.data[i].anfme+";"+res.data[i].bomCode; + } else { + res.data[i]["barcodeUrl"]=baseUrl+"/mac/code/auth?type=2¶m="+res.data[i].orderNo+ + ";"+res.data[i].matnr+";"+res.data[i].batch+";"+res.data[i].anfme; + } + } } var tpl = templateDom.html(); diff --git a/src/main/webapp/static/js/order/out.js b/src/main/webapp/static/js/order/out.js index e0b6b18..515b971 100644 --- a/src/main/webapp/static/js/order/out.js +++ b/src/main/webapp/static/js/order/out.js @@ -32,9 +32,10 @@ cols: [[ {type: 'checkbox'} ,{type: 'numbers', title: '#'} - ,{field: 'orderNo', align: 'center',title: '鍗曟嵁缂栧彿', templet: '#orderNoTpl', width: 160} - ,{field: 'matnr', align: 'center',title: '鍟嗗搧缂栫爜', width: 160} - ,{field: 'maktx', align: 'center',title: '鍟嗗搧鍚嶇О', width: 200} + ,{field: 'orderNo', align: 'center',title: '鍗曟嵁缂栧彿', templet: '#orderNoTpl', width: 140} + ,{field: 'matnr', align: 'center',title: '鍟嗗搧缂栫爜', width: 140} + ,{field: 'maktx', align: 'center',title: '鍟嗗搧鍚嶇О', width: 140} + ,{field: 'bomCode', align: 'center',title: 'bom鍙�', width: 100} ,{field: 'batch', align: 'center',title: '搴忓垪鐮�'} ,{field: 'specs', align: 'center',title: '瑙勬牸'} ,{field: 'anfme', align: 'center',title: '鎬绘暟閲�', style: 'font-weight: bold'} @@ -55,7 +56,7 @@ // ,{field: 'updateBy$', align: 'center',title: '淇敼浜哄憳'} // ,{field: 'updateTime$', align: 'center',title: '淇敼鏃堕棿'} // ,{field: 'memo', align: 'center',title: '澶囨敞'} - ,{fixed: 'right', title:'鎿嶄綔', align: 'center', toolbar: '#operate', width: 160} + ,{fixed: 'right', title:'鎿嶄綔', align: 'center', toolbar: '#operate', width: 100} ]], request: { pageName: 'curr', diff --git a/src/main/webapp/views/pakStore/locDetlQuery.html b/src/main/webapp/views/pakStore/locDetlQuery.html index 9d00cfc..7e45723 100644 --- a/src/main/webapp/views/pakStore/locDetlQuery.html +++ b/src/main/webapp/views/pakStore/locDetlQuery.html @@ -77,6 +77,11 @@ <input class="layui-input" type="text" name="batch" placeholder="鎵瑰彿" autocomplete="off"> </div> </div> + <div class="layui-inline"> + <div class="layui-input-inline"> + <input class="layui-input" type="text" name="bomCode" placeholder="bom鍙�" autocomplete="off"> + </div> + </div> <!-- 鏃ユ湡鑼冨洿 --> <div class="layui-inline" style="width: 300px"> <div class="layui-input-inline"> -- Gitblit v1.9.1