查询在库时长

pang.jiabao

2024-09-02 0671b22545b660cae46568ba7f6a14f52cad8ad8

查询在库时长

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

@@ -95,6 +95,15 @@
        return openService.zwmsOutLocWork(param);
    }

    @PostMapping("/cxzk")
    @AppAuth(memo = "根据包装组号查询在库时间-MES调用")
    public synchronized R queryInLocTime(@RequestHeader(required = false) String appkey,
                                         @RequestBody List<String> param,
                                         HttpServletRequest request) {
        auth(appkey, param, request);
        return openService.queryInLocTime(param);
    }

    @PostMapping("/ckjgsb")
    @AppAuth(memo = "货物到达出库口以后，上报出库结果")
    public synchronized R outLocResultReport(@RequestHeader(required = false) String appkey,

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

New file
@@ -0,0 +1,20 @@
package com.zy.asrs.entity;

import lombok.Data;

/**
 * @author pang.jiabao
 * @description 查询包装组号在库时间反参
 * @createDate 2024/9/2 15:58
 */
@Data
public class InLocTimeDto {
    /**
     * 包装组号
     */
    private String packageGroupNo;
    /**
     * 相差天数
     */
    private int diffDay;
}

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

@@ -1,6 +1,7 @@
package com.zy.asrs.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.asrs.entity.InLocTimeDto;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.result.StockVo;
import org.apache.ibatis.annotations.Mapper;
@@ -80,4 +81,9 @@
     * 批量插入库存明细
     */
    int batchDetls(@Param("locDetls") List<LocDetl> locDetls);

    /**
     * 查询包装组号在库时间
     */
    List<InLocTimeDto> queryInLocTime(@Param("param") List<String> param);
}

 src/main/java/com/zy/asrs/service/OpenService.java

@@ -51,6 +51,11 @@
    R zwmsOutLocWork(ZwmsOutLocWorkDto param);

    /**
     * 根据包装组号查询在库时间-MES调用
     */
    R queryInLocTime(List<String> param);

    /**
     * 货物到达出库口以后，上报出库结果
     */
    String outLocResultReport(GhjtApiParam param);

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

@@ -13,6 +13,7 @@
import com.zy.asrs.entity.result.StockVo;
import com.zy.asrs.entity.result.ZphjcdgzVo;
import com.zy.asrs.entity.result.ZphjcdwcVo;
import com.zy.asrs.mapper.LocDetlMapper;
import com.zy.asrs.mapper.MatMapper;
import com.zy.asrs.mapper.TagMapper;
import com.zy.asrs.service.*;
@@ -96,6 +97,9 @@

    @Resource
    private MatMapper matMapper;

    @Resource
    private LocDetlMapper locDetlMapper;

    @Override
    @Transactional
@@ -1421,6 +1425,17 @@
    }

    @Override
    public R queryInLocTime(List<String> param) {
        if (Cools.isEmpty(param)) {
            return R.parse("参数不能为空");
        }

        List<InLocTimeDto> inLocTimeDtos = locDetlMapper.queryInLocTime(param);

        return R.ok(inLocTimeDtos);
    }

    @Override
    @Transactional
    public String outLocResultReport(GhjtApiParam param) {


 src/main/resources/mapper/LocDetlMapper.xml

@@ -374,6 +374,20 @@
        from asr_loc_detl
        where loc_no=#{locNo}
    </select>
    <select id="queryInLocTime" resultType="com.zy.asrs.entity.InLocTimeDto">
        select
            brand packageGroupNo,
            DATEDIFF(day, appe_time , getdate()) diffDay
        from
            asr_loc_detl
        where brand in
        <foreach collection="param" index="index" item="item" separator="," open="(" close=")">
            #{item}
        </foreach>
        group by
            brand,
            appe_time
    </select>

    <update id="updateMatTurn">
        UPDATE a