From 4304744cfb33afe68934cd63029f4f01a6b34b18 Mon Sep 17 00:00:00 2001
From: skyouc <creaycat@gmail.com>
Date: 星期一, 19 一月 2026 19:49:22 +0800
Subject: [PATCH] 查询库存功能优化
---
src/main/java/com/zy/api/entity/dto/LocDetlDto.java | 36 ++++++++++++++++++
src/main/java/com/zy/api/service/impl/KopenApiServiceImpl.java | 27 +++++++++++++
2 files changed, 62 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/api/entity/dto/LocDetlDto.java b/src/main/java/com/zy/api/entity/dto/LocDetlDto.java
new file mode 100644
index 0000000..e3c5ba2
--- /dev/null
+++ b/src/main/java/com/zy/api/entity/dto/LocDetlDto.java
@@ -0,0 +1,36 @@
+package com.zy.api.entity.dto;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.experimental.Accessors;
+import java.io.Serializable;
+import lombok.Data;
+
+
+@Data
+@Accessors(chain = true)
+@ApiModel(value = "LocDetlDto", description = "搴撲綅鏄庣粏杩斿洖鍊�")
+public class LocDetlDto implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ @ApiModelProperty("鐗╂枡缂栫爜")
+ private String pro_komcode;
+
+ @ApiModelProperty("渚涘簲鍟�")
+ private String pro_id;
+
+ @ApiModelProperty("鍙敤搴撳瓨")
+ private Integer stock_qty;
+
+ @ApiModelProperty("闅旂搴撳瓨")
+ private Integer lock_qty;
+
+ @ApiModelProperty("鐩爣鎵樼洏")
+ private String location_no;
+
+ @ApiModelProperty("搴撳尯")
+ private String target_location;
+
+
+}
diff --git a/src/main/java/com/zy/api/service/impl/KopenApiServiceImpl.java b/src/main/java/com/zy/api/service/impl/KopenApiServiceImpl.java
index 14eb485..c75f761 100644
--- a/src/main/java/com/zy/api/service/impl/KopenApiServiceImpl.java
+++ b/src/main/java/com/zy/api/service/impl/KopenApiServiceImpl.java
@@ -15,6 +15,7 @@
import com.zy.api.entity.StockAdjustParams;
import com.zy.api.entity.StockUpOrderParams;
import com.zy.api.entity.SyncMatParmas;
+import com.zy.api.entity.dto.LocDetlDto;
import com.zy.api.entity.dto.XSR;
import com.zy.api.enums.MatLocType;
import com.zy.api.enums.OrderType;
@@ -573,7 +574,31 @@
List<LocDetl> detls = locDetlService.selectList(wrapper);
- return XSR.ok(detls);
+ if (detls == null || detls.isEmpty()) {
+ return XSR.ok();
+ }
+ List<LocDetlDto> dtos = new ArrayList<>();
+ detls.forEach(item -> {
+ LocDetlDto locDetlDto = new LocDetlDto();
+ if (item.getDiffQty().compareTo(BigDecimal.ZERO) == 0) {
+ locDetlDto.setLock_qty(0);
+ } else {
+ locDetlDto.setLock_qty(Integer.parseInt(item.getDiffQty().toString()));
+ }
+
+ if (item.getBookQty().compareTo(BigDecimal.ZERO) == 0) {
+ locDetlDto.setStock_qty(0);
+ } else {
+ locDetlDto.setStock_qty(Integer.parseInt(item.getBookQty().toString()));
+ }
+ locDetlDto
+ .setPro_komcode(item.getMatnr())
+ .setPro_id(item.getStandby1())
+ .setLocation_no(item.getZpallet())
+ .setTarget_location("");
+ dtos.add(locDetlDto);
+ });
+ return XSR.ok(dtos);
}
/**
--
Gitblit v1.9.1