src/main/java/com/zy/asrs/controller/MobileController.java

@@ -19,7 +19,9 @@
import com.zy.common.utils.Synchro;
import com.zy.common.web.BaseController;
import com.zy.nc.entity.NccJcQilibcBarcodeflowWms;
import com.zy.nc.entity.NccXsckmxTkWms;
import com.zy.nc.service.NccJcQilibcBarcodeflowWmsService;
import com.zy.nc.service.NccXsckmxTkWmsService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
@@ -72,6 +74,9 @@

    @Autowired
    private OrderDetlPakinService orderDetlPakinService;

    @Autowired
    private NccXsckmxTkWmsService nccXsckmxTkWmsService;

    @RequestMapping("/pda/WarehouseOut/v1")
    @ManagerAuth(memo = "并板途中拣料-参考念初")
@@ -282,6 +287,25 @@
        return R.ok().add(matParam);
    }

    @RequestMapping(value = "/mat/back")
    @ManagerAuth
    public R pdaSearchBack(@RequestParam String matnr) {
        EntityWrapper<NccXsckmxTkWms> wrapper = new EntityWrapper<>();
        wrapper.like("VBATCHCODE", matnr);
        NccXsckmxTkWms nccXsckmxTkWms = nccXsckmxTkWmsService.selectOne(wrapper);
        if (null == nccXsckmxTkWms) {
            return R.error("未找到此条码");
        }
        Mat mat = matService.selectByMatnr(nccXsckmxTkWms.getWlbm());
        MatParam matParam = new MatParam();
        Synchro.Copy(mat, matParam);
        matParam.setBatch(nccXsckmxTkWms.getVbatchcode());
        matParam.setAnfme(0.0D);
        matParam.setAnfme2(0.0D);
        matParam.setTiaoma(matnr);
        return R.ok().add(matParam);
    }

    @RequestMapping("/comb/auth")
    @ManagerAuth(memo = "组托")
    public R comb(@RequestBody CombParam combParam) {

 src/main/java/com/zy/asrs/controller/OutController.java

@@ -97,6 +97,7 @@
                        locDto.setBoxType1(orderDetl.getBoxType1());
                        locDto.setBoxType2(orderDetl.getBoxType2());
                        locDto.setBoxType3(orderDetl.getBoxType3());
                        locDto.setWeight(orderDetl.getWeight());

                        locDto.setStaNos(staNos);
                        locDtos.add(locDto);
@@ -116,6 +117,7 @@
                    locDto.setBoxType1(orderDetl.getBoxType1());
                    locDto.setBoxType2(orderDetl.getBoxType2());
                    locDto.setBoxType3(orderDetl.getBoxType3());
                    locDto.setWeight(orderDetl.getWeight());
                    locDto.setLack(Boolean.TRUE);
                    locDtos.add(locDto);
                }
@@ -145,6 +147,7 @@
                        locDto.setBoxType1(orderDetl.getBoxType1());
                        locDto.setBoxType2(orderDetl.getBoxType2());
                        locDto.setBoxType3(orderDetl.getBoxType3());
                        locDto.setWeight(orderDetl.getWeight());
                        locDtos.add(locDto);
                        exist.add(locDetl.getLocNo());
                        // 剩余待出数量递减
@@ -162,6 +165,7 @@
                    locDto.setBoxType1(orderDetl.getBoxType1());
                    locDto.setBoxType2(orderDetl.getBoxType2());
                    locDto.setBoxType3(orderDetl.getBoxType3());
                    locDto.setWeight(orderDetl.getWeight());
                    locDto.setLack(Boolean.TRUE);
                    locDtos.add(locDto);
                }

 src/main/java/com/zy/asrs/entity/WaitPakin.java

@@ -196,6 +196,13 @@
    @TableField("box_type3")
    private String boxType3 = "";

    /**
     * 退库标记
     */
    @ApiModelProperty(value= "退库标记")
    @TableField("tk_flag")
    private String tkFlag = "";

    public String getBeBatch$(){
        if (null == this.beBatch){ return null; }
        switch (this.beBatch){

 src/main/java/com/zy/asrs/entity/WaitPakinLog.java

@@ -195,6 +195,13 @@
    @TableField("box_type3")
    private String boxType3 = "";

    /**
     * 退库标记
     */
    @ApiModelProperty(value= "退库标记")
    @TableField("tk_flag")
    private String tkFlag = "";

    public String getBeBatch$(){
        if (null == this.beBatch){ return null; }
        switch (this.beBatch){

 src/main/java/com/zy/asrs/entity/param/CombParam.java

@@ -19,6 +19,9 @@
    // 库位编号
    private String locNo;

    //退库组托
    private String tkFlag;


    private List<CombMat> combMats;


 src/main/java/com/zy/asrs/mapper/LocDetlMapper.java

@@ -39,6 +39,11 @@
                    @Param("brand")String brand,@Param("standby1")String standby1,@Param("standby2")String standby2,
                    @Param("standby3")String standby3,@Param("boxType1")String boxType1,@Param("boxType2")String boxType2,@Param("boxType3")String boxType3 );

    int updateWeight(@Param("weight")Double weight, @Param("locNo")String locNo, @Param("matnr")String matnr, @Param("batch")String batch,
                    @Param("brand")String brand,@Param("standby1")String standby1,@Param("standby2")String standby2,
                    @Param("standby3")String standby3,@Param("boxType1")String boxType1,@Param("boxType2")String boxType2,@Param("boxType3")String boxType3 );


    List<LocDetl> getStockOutPage(Map<String, Object> map);

    Integer getStockOutPageCount(Map<String, Object> map);

 src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java

@@ -6,11 +6,14 @@
import com.core.common.R;
import com.zy.asrs.entity.FrozenParam;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.Mat;
import com.zy.asrs.entity.result.LocDetlAll;
import com.zy.asrs.entity.result.LocDetlDTO;
import com.zy.asrs.entity.result.StockVo;
import com.zy.asrs.mapper.LocDetlMapper;
import com.zy.asrs.service.LocDetlService;
import com.zy.asrs.service.MatService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
@@ -20,6 +23,9 @@

@Service("locDetlService")
public class LocDetlServiceImpl extends ServiceImpl<LocDetlMapper, LocDetl> implements LocDetlService {

    @Autowired
    private MatService matService;

    @Override
    public Page<LocDetl> getPage(Page<LocDetl> page) {
@@ -58,7 +64,23 @@
        if (anfme <= 0) {
            return this.baseMapper.deleteItem(locNo, matnr, batch, brand, standby1, standby2, standby3, boxType1, boxType2, boxType3) > 0;
        } else {
            return baseMapper.updateAnfme(anfme, locNo, matnr, batch, brand, standby1, standby2, standby3, boxType1, boxType2, boxType3) > 0;
            boolean result = baseMapper.updateAnfme(anfme, locNo, matnr, batch, brand, standby1, standby2, standby3, boxType1, boxType2, boxType3) > 0;
            if (!result) {
                return false;
            }

            //更新辅料
            Mat mat = matService.selectByMatnr(matnr);
            if (mat == null) {
                return false;
            }

            //转换关系
            String origin = mat.getOrigin();
            String[] split = origin.split("/");
            //辅单位
            Double weight = (anfme / Double.parseDouble(split[1])) / Double.parseDouble(split[0]);
            return this.baseMapper.updateWeight(weight, locNo, matnr, batch, brand, standby1, standby2, standby3, boxType1, boxType2, boxType3) > 0;
        }
    }


 src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java

@@ -629,6 +629,9 @@
                waitPakin.setStandby1(detlDto.getStandby1());
                waitPakin.setStandby2(detlDto.getStandby2());
                waitPakin.setStandby3(detlDto.getStandby3());
                if ("Y".equals(param.getTkFlag())) {
                    waitPakin.setTkFlag(detlDto.getTkFlag());
                }
                if (!waitPakinService.insert(waitPakin)) {
                    throw new CoolException("保存入库通知档失败");
                }

 src/main/java/com/zy/common/model/DetlDto.java

@@ -38,6 +38,8 @@

    private Double weight;

    //退库组托
    private String tkFlag;


    public DetlDto() {

 src/main/java/com/zy/common/model/LocDto.java

@@ -47,6 +47,9 @@

    private Integer staNo;

    private Double weight;


    public LocDto() {
    }


 src/main/java/com/zy/nc/entity/NccXsckmxTkWms.java

New file
@@ -0,0 +1,60 @@
package com.zy.nc.entity;

import com.baomidou.mybatisplus.annotations.TableId;
import com.baomidou.mybatisplus.annotations.TableName;
import lombok.Data;

/**
 * 
 * @TableName ncc_xsckmx_tk_wms
 */
@TableName(value ="ncc_xsckmx_tk_wms")
@Data
public class NccXsckmxTkWms {
    /**
     *
     */
    @TableId
    private String cgeneralbid;

    /**
     * 
     */
    private String vbatchcode;

    /**
     * 
     */
    private String csourcebilldate;

    /**
     * 
     */
    private String vsourcebillcode;

    /**
     * 
     */
    private String khbm;

    /**
     * 
     */
    private String khmc;

    /**
     * 
     */
    private String csourcebillhid;

    /**
     * 
     */
    private String csourcebillbid;

    /**
     * 
     */
    private String wlbm;

}

 src/main/java/com/zy/nc/mapper/NccXsckmxTkWmsMapper.java

New file
@@ -0,0 +1,18 @@
package com.zy.nc.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.nc.entity.NccXsckmxTkWms;

/**
* @author zc857
* @description 针对表【ncc_xsckmx_tk_wms】的数据库操作Mapper
* @createDate 2025-06-04 16:01:00
* @Entity com.zy.nc.entity.NccScPcdaWms
*/
public interface NccXsckmxTkWmsMapper extends BaseMapper<NccXsckmxTkWms> {

}





 src/main/java/com/zy/nc/service/NccXsckmxTkWmsService.java

New file
@@ -0,0 +1,11 @@
package com.zy.nc.service;

import com.baomidou.mybatisplus.service.IService;
import com.zy.nc.entity.NccXsckmxTkWms;

/**
* @description 针对表【ncc_xsckmx_tk_wms】的数据库操作Service
*/
public interface NccXsckmxTkWmsService extends IService<NccXsckmxTkWms> {

}

 src/main/java/com/zy/nc/service/impl/NccXsckmxTkWmsServiceImpl.java

New file
@@ -0,0 +1,25 @@
package com.zy.nc.service.impl;

import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.zy.nc.entity.NccScPcdaWms;
import com.zy.nc.entity.NccXsckmxTkWms;
import com.zy.nc.mapper.NccScPcdaWmsMapper;
import com.zy.nc.mapper.NccXsckmxTkWmsMapper;
import com.zy.nc.service.NccScPcdaWmsService;
import com.zy.nc.service.NccXsckmxTkWmsService;
import org.springframework.stereotype.Service;

/**
* @author zc857
* @description 针对表【ncc_xsckmx_tk_wms】的数据库操作Service实现
* @createDate 2025-06-04 16:01:00
*/
@Service
public class NccXsckmxTkWmsServiceImpl extends ServiceImpl<NccXsckmxTkWmsMapper, NccXsckmxTkWms>
    implements NccXsckmxTkWmsService {

}





 src/main/resources/mapper/asrs/LocDetlMapper.xml

@@ -319,6 +319,16 @@
        <include refid="batchSeqNew"></include>
    </update>

    <update id="updateWeight">
        update asr_loc_detl
        set weight = #{weight}
        , modi_time = getdate()
        where 1=1
        and loc_no = #{locNo}
        and matnr = #{matnr}
        <include refid="batchSeqNew"></include>
    </update>

    <sql id="stockOutCondition">
        <if test="loc_no!=null and loc_no!='' ">
            and a.loc_no like '%' + #{loc_no} + '%'

 src/main/resources/mapper/asrs/WaitPakinLogMapper.xml

@@ -53,6 +53,7 @@
        <result column="box_type1" property="boxType1" />
        <result column="box_type2" property="boxType2" />
        <result column="box_type3" property="boxType3" />
        <result column="tk_flag" property="tkFlag" />
    </resultMap>

</mapper>

 src/main/resources/mapper/asrs/WaitPakinMapper.xml

@@ -53,6 +53,7 @@
        <result column="box_type1" property="boxType1" />
        <result column="box_type2" property="boxType2" />
        <result column="box_type3" property="boxType3" />
        <result column="tk_flag" property="tkFlag" />
    </resultMap>

</mapper>

 src/main/resources/mapper/nc/NccXsckmxTkWmsMapper.xml

New file
@@ -0,0 +1,22 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zy.nc.mapper.NccXsckmxTkWmsMapper">

    <resultMap id="BaseResultMap" type="com.zy.nc.entity.NccXsckmxTkWms">
        <result property="cgeneralbid" column="CGENERALBID" />
        <result property="vbatchcode" column="VBATCHCODE" />
        <result property="csourcebilldate" column="CSOURCEBILLDATE" />
        <result property="vsourcebillcode" column="VSOURCEBILLCODE" />
        <result property="khbm" column="KHBM" />
        <result property="khmc" column="KHMC" />
        <result property="csourcebillhid" column="CSOURCEBILLHID" />
        <result property="csourcebillbid" column="CSOURCEBILLBID" />
        <result property="wlbm" column="WLBM" />
    </resultMap>

    <sql id="Base_Column_List">
        CODE,NAME,SHORTNAME,wms_flag
    </sql>
</mapper>

 src/main/webapp/static/js/orderPakout/out.js

@@ -36,7 +36,7 @@
            ,{field: 'maktx', align: 'center',title: '商品名称', width: 200}
            ,{field: 'batch', align: 'center',title: '批次'}
            ,{field: 'specs', align: 'center',title: '规格'}
            ,{field: 'weight$', align: 'center',title: '辅数量'}
            ,{field: 'weight', align: 'center',title: '辅数量'}
            // ,{field: 'anfme', align: 'center',title: '数量'}
            // ,{field: 'qty', align: 'center',title: '作业数量', style: 'font-weight: bold'}
            ,{field: 'enableQty', align: 'center',title: '待出数量', style: 'font-weight: bold'}