skyouc
2 天以前 3d2e154d70d3976a5f33c9fcef7422992297c19b
库位明细查询接口优化
6个文件已修改
1个文件已添加
86 ■■■■■ 已修改文件
rsf-server/src/main/java/com/vincent/rsf/server/api/controller/ReceiveMsgController.java 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReceiveMsgServiceImpl.java 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/dto/LocStockDto.java 52 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/LocMapper.java 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
rsf-server/src/main/java/com/vincent/rsf/server/manager/service/LocService.java 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/LocServiceImpl.java 14 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
rsf-server/src/main/resources/mapper/manager/LocMapper.xml 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
rsf-server/src/main/java/com/vincent/rsf/server/api/controller/ReceiveMsgController.java
@@ -138,6 +138,4 @@
        return receiveMsgService.syncLocsDetl(pageParam, wrapper);
    }
}
rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReceiveMsgServiceImpl.java
@@ -3,6 +3,7 @@
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.vincent.rsf.framework.common.R;
import com.vincent.rsf.framework.exception.CoolException;
@@ -11,6 +12,7 @@
import com.vincent.rsf.server.api.controller.params.WkOrderDto;
import com.vincent.rsf.server.common.domain.BaseParam;
import com.vincent.rsf.server.common.domain.PageParam;
import com.vincent.rsf.server.manager.controller.dto.LocStockDto;
import com.vincent.rsf.server.manager.entity.*;
import com.vincent.rsf.server.manager.enums.OrderType;
import com.vincent.rsf.server.manager.service.*;
@@ -212,8 +214,7 @@
    public R syncLocsDetl(PageParam<Loc, BaseParam> pageParam, QueryWrapper<Loc> wrapper) {
        Page<Object> page = new Page<>();
        page.setCurrent(pageParam.getCurrent()).setSize(pageParam.getSize());
        IPage<LocStockDto> locStocks =  locService.getLocDetls(page);
        return null;
    }
rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/dto/LocStockDto.java
New file
@@ -0,0 +1,52 @@
package com.vincent.rsf.server.manager.controller.dto;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.experimental.Accessors;
import java.io.Serializable;
import java.util.Date;
@Data
@Accessors(chain = true)
@ApiModel(value = "LocStockDto", description = "库存明细")
public class LocStockDto implements Serializable {
    @ApiModelProperty("识位")
    private String locCode;
    @ApiModelProperty("库位ID")
    private String locId;
    @ApiModelProperty("托盘码")
    private String barcode;
    @ApiModelProperty("物料名称")
    private String maktx;
    @ApiModelProperty("物料编码")
    private String matnr;
    @ApiModelProperty("规格属性")
    private String specs;
    @ApiModelProperty("批次")
    private String batch;
    @ApiModelProperty("数量 ")
    private Double anfme;
    @ApiModelProperty("供应商")
    private String supplier;
    @ApiModelProperty("单位")
    private String unit;
    @ApiModelProperty("修改时间")
    private Date updateTime;
    private static final long serialVersionUID = 1L;
}
rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/LocMapper.java
@@ -1,5 +1,8 @@
package com.vincent.rsf.server.manager.mapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.vincent.rsf.server.manager.controller.dto.LocStockDto;
import com.vincent.rsf.server.manager.controller.dto.LocUsageDto;
import com.vincent.rsf.server.manager.entity.Loc;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
@@ -17,4 +20,6 @@
    boolean deleteAll();
    List<LocUsageDto> getLocPies();
    IPage<LocStockDto> getLocDetls(Page<Object> page);
}
rsf-server/src/main/java/com/vincent/rsf/server/manager/service/LocService.java
@@ -1,7 +1,10 @@
package com.vincent.rsf.server.manager.service;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.IService;
import com.vincent.rsf.framework.common.R;
import com.vincent.rsf.server.manager.controller.dto.LocStockDto;
import com.vincent.rsf.server.manager.controller.params.LocMastInitParam;
import com.vincent.rsf.server.manager.controller.params.LocModifyParams;
import com.vincent.rsf.server.manager.entity.Loc;
@@ -19,4 +22,6 @@
    R batchBindLocs(LocModifyParams locs);
    R getLocPies();
    IPage<LocStockDto> getLocDetls(Page<Object> page);
}
rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/LocServiceImpl.java
@@ -2,9 +2,12 @@
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.vincent.rsf.framework.common.Cools;
import com.vincent.rsf.framework.common.R;
import com.vincent.rsf.framework.exception.CoolException;
import com.vincent.rsf.server.manager.controller.dto.LocStockDto;
import com.vincent.rsf.server.manager.controller.dto.LocUsageDto;
import com.vincent.rsf.server.manager.controller.params.LocMastInitParam;
import com.vincent.rsf.server.manager.controller.params.LocModifyParams;
@@ -230,4 +233,15 @@
        List<LocUsageDto> locPies = this.baseMapper.getLocPies();
        return R.ok().add(locPies);
    }
    /**
     * @author Ryan
     * @date 2025/8/16
     * @description: 获取库位明细
     * @version 1.0
     */
    @Override
    public IPage<LocStockDto> getLocDetls(Page<Object> page) {
        return this.baseMapper.getLocDetls(page);
    }
}
rsf-server/src/main/resources/mapper/manager/LocMapper.xml
@@ -13,4 +13,7 @@
           GROUP BY
                use_status
    </select>
    <select id="getLocDetls" resultType="com.vincent.rsf.server.manager.controller.dto.LocStockDto">
    </select>
</mapper>