From d02d3b681da14c2f342f2247457dc60b426ff299 Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期二, 07 一月 2025 17:50:16 +0800
Subject: [PATCH] bug修改

---
 manage/src/main/java/com/jilongda/manage/vo/TInventoryInfoVO.java                   |    2 
 manage/src/main/resources/mapping/TOrderMapper.xml                                  |    9 ++++
 manage/src/main/java/com/jilongda/manage/controller/TInventoryController.java       |   24 +++++++----
 manage/src/main/java/com/jilongda/manage/model/TInventoryLensDetail.java            |    3 +
 manage/src/main/java/com/jilongda/manage/query/TOptometryQuery.java                 |    1 
 manage/src/main/resources/mapping/TFrameWarehousingDetailMapper.xml                 |    2 
 manage/src/main/java/com/jilongda/manage/controller/TOrderController.java           |    2 
 manage/src/main/java/com/jilongda/manage/service/impl/TWarehousingServiceImpl.java  |    1 
 manage/src/main/resources/mapping/TOptometristMapper.xml                            |    7 ++-
 manage/src/main/java/com/jilongda/manage/controller/TOptometristController.java     |    8 ++++
 manage/src/main/java/com/jilongda/manage/query/TOrderQuery.java                     |    2 +
 manage/src/main/java/com/jilongda/manage/controller/TOrderAftersalesController.java |    5 ++
 12 files changed, 50 insertions(+), 16 deletions(-)

diff --git a/manage/src/main/java/com/jilongda/manage/controller/TInventoryController.java b/manage/src/main/java/com/jilongda/manage/controller/TInventoryController.java
index 1a34c04..fac1b2e 100644
--- a/manage/src/main/java/com/jilongda/manage/controller/TInventoryController.java
+++ b/manage/src/main/java/com/jilongda/manage/controller/TInventoryController.java
@@ -17,6 +17,7 @@
 import com.jilongda.manage.vo.TInventoryVO;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
+import io.swagger.annotations.ApiParam;
 import io.swagger.models.auth.In;
 import org.springframework.beans.BeanUtils;
 import org.springframework.context.annotation.Bean;
@@ -93,12 +94,14 @@
     }
 
     @ApiOperation(value = "镜架-根据品牌id查询对应库存")
-    @PostMapping(value = "/getCountByBrandId")
-    public ApiResult getCountByBrandId(Integer id) {
+    @GetMapping(value = "/getCountByBrandId")
+    public ApiResult getCountByBrandId(Integer id,Integer storeId) {
         List<Integer> collect = modelService.lambdaQuery().eq(TModel::getBrandId, id)
                 .list().stream().map(TModel::getId).distinct().collect(Collectors.toList());
         if (collect.isEmpty())collect.add(-1);
-        List<TFrameGoods> list = frameGoodsService.lambdaQuery().in(TFrameGoods::getModelId, collect).list();
+        List<TFrameGoods> list = frameGoodsService.lambdaQuery().in(TFrameGoods::getModelId, collect)
+                .eq(TFrameGoods::getStoreId,storeId)
+                .list();
         if (list.isEmpty())return ApiResult.success("0");
         int i = 0;
         for (TFrameGoods tFrameGoods : list) {
@@ -107,12 +110,13 @@
         return ApiResult.success(i);
     }
     @ApiOperation(value = "镜架-根据材质id查询对应库存")
-    @PostMapping(value = "/getCountByMaterialId")
-    public ApiResult getCountByMaterialId(Integer id) {
+    @GetMapping(value = "/getCountByMaterialId")
+    public ApiResult getCountByMaterialId(Integer id,Integer storeId) {
         List<Integer> collect = modelService.lambdaQuery().eq(TModel::getMaterialId, id)
                 .list().stream().map(TModel::getId).distinct().collect(Collectors.toList());
         if (collect.isEmpty())collect.add(-1);
-        List<TFrameGoods> list = frameGoodsService.lambdaQuery().in(TFrameGoods::getModelId, collect).list();
+        List<TFrameGoods> list = frameGoodsService.lambdaQuery().in(TFrameGoods::getModelId, collect).
+        eq(TFrameGoods::getStoreId,storeId).list();
         if (list.isEmpty())return ApiResult.success("0");
         int i = 0;
         for (TFrameGoods tFrameGoods : list) {
@@ -131,6 +135,7 @@
                 .list().stream().map(TModel::getId).collect(Collectors.toList());
         if (collect.isEmpty())collect.add(-1);
         TFrameGoods one = frameGoodsService.lambdaQuery().in(TFrameGoods::getModelId, collect)
+                .eq(TFrameGoods::getStoreId,getCurrentByParam.getStoreId())
                 .eq(TFrameGoods::getColor, getCurrentByParam.getColor()).one();
         if (one!=null){
             return ApiResult.success(one.getTotal());
@@ -143,9 +148,10 @@
     public ApiResult<Integer> getCurrentByParamLens(@RequestBody GetCurrentByParamLens dto) {
         TLensGoods one = lensGoodsService.lambdaQuery().in(TLensGoods::getSeriesId, dto.getSeriesId())
                 .eq(dto.getLensType()!=null,TLensGoods::getLensType, dto.getLensType())
-                .eq(dto.getRefractiveIndex()!=null,TLensGoods::getRefractiveIndex, dto.getRefractiveIndex())
-                .eq(dto.getBallMirror()!=null,TLensGoods::getBallMirror, dto.getBallMirror())
-                .eq(dto.getColumnMirror()!=null,TLensGoods::getColumnMirror, dto.getColumnMirror())
+                .eq(StringUtils.hasLength(dto.getRefractiveIndex()),TLensGoods::getRefractiveIndex, dto.getRefractiveIndex())
+                .eq(StringUtils.hasLength(dto.getBallMirror()),TLensGoods::getBallMirror, dto.getBallMirror())
+                .eq(StringUtils.hasLength(dto.getColumnMirror()),TLensGoods::getColumnMirror, dto.getColumnMirror())
+                .eq(dto.getStoreId()!=null,TLensGoods::getStoreId, dto.getStoreId())
                 .one();
         if (one!=null){
             return ApiResult.success(one.getTotal());
diff --git a/manage/src/main/java/com/jilongda/manage/controller/TOptometristController.java b/manage/src/main/java/com/jilongda/manage/controller/TOptometristController.java
index db686e7..0c71e55 100644
--- a/manage/src/main/java/com/jilongda/manage/controller/TOptometristController.java
+++ b/manage/src/main/java/com/jilongda/manage/controller/TOptometristController.java
@@ -4,6 +4,8 @@
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.jilongda.common.basic.ApiResult;
 import com.jilongda.common.basic.PageInfo;
+import com.jilongda.manage.authority.model.SecUser;
+import com.jilongda.manage.authority.service.SecUserService;
 import com.jilongda.manage.model.TOptometrist;
 import com.jilongda.manage.query.TOptometristQuery;
 import com.jilongda.manage.query.TicketQuery;
@@ -31,6 +33,8 @@
 public class TOptometristController {
     @Autowired
     private TOptometristService optometristService;
+    @Autowired
+    private SecUserService secUserService;
 
     @ApiOperation(value = "验光师列表")
     @PostMapping(value = "/pageList")
@@ -62,6 +66,8 @@
         if (one!=null){
             return ApiResult.failed("当前号码已存在");
         }
+        List<SecUser> list = secUserService.lambdaQuery().eq(SecUser::getPhone, dto.getPhone()).list();
+        if (!list.isEmpty())return ApiResult.failed("当前号码在员工管理已存在");
         optometristService.save(dto);
         return ApiResult.success();
     }
@@ -79,6 +85,8 @@
         if (one!=null){
             return ApiResult.failed("当前号码已存在");
         }
+        List<SecUser> list = secUserService.lambdaQuery().eq(SecUser::getPhone, dto.getPhone()).list();
+        if (!list.isEmpty())return ApiResult.failed("当前号码在员工管理已存在");
         optometristService.updateById(dto);
         return ApiResult.success();
     }
diff --git a/manage/src/main/java/com/jilongda/manage/controller/TOrderAftersalesController.java b/manage/src/main/java/com/jilongda/manage/controller/TOrderAftersalesController.java
index 5da3b88..d169bb7 100644
--- a/manage/src/main/java/com/jilongda/manage/controller/TOrderAftersalesController.java
+++ b/manage/src/main/java/com/jilongda/manage/controller/TOrderAftersalesController.java
@@ -69,6 +69,11 @@
     @ApiOperation(value = "订单售后添加")
     @PostMapping(value = "/add")
     public ApiResult<String> add(@RequestBody TOrderAftersales dto) {
+        List<TOrderAftersales> list = orderAftersalesService.lambdaQuery()
+                .eq(TOrderAftersales::getOrderId, dto.getOrderId()).list();
+        if (!list.isEmpty()){
+            return ApiResult.failed("该订单已售后,不可再次操作!");
+        }
         dto.setCode(WarehousingConstant.ASTER_SALES+ CodeGenerateUtils.generateVolumeSn());
         orderAftersalesService.save(dto);
         return ApiResult.success();
diff --git a/manage/src/main/java/com/jilongda/manage/controller/TOrderController.java b/manage/src/main/java/com/jilongda/manage/controller/TOrderController.java
index 6314de8..5770045 100644
--- a/manage/src/main/java/com/jilongda/manage/controller/TOrderController.java
+++ b/manage/src/main/java/com/jilongda/manage/controller/TOrderController.java
@@ -104,7 +104,7 @@
         List<Integer> collect1 = orderGoodsService.lambdaQuery()
                 .eq(StringUtils.hasLength(query.getBrandLens()), TOrderGoods::getBrandName, query.getBrandLens())
                 .eq(StringUtils.hasLength(query.getSeries()), TOrderGoods::getSeriesName, query.getSeries())
-                .eq((query.getType() != null), TOrderGoods::getType, query.getType())
+                .eq(query.getType() != null, TOrderGoods::getType, query.getType())
                 .eq(StringUtils.hasLength(query.getRefractiveIndex()), TOrderGoods::getRefractiveIndex, query.getRefractiveIndex()).list()
                 .stream().map(TOrderGoods::getOrderId).collect(Collectors.toList());
         if (StringUtils.hasLength(query.getBrandLens())||StringUtils.hasLength(query.getSeries())||query.getType() != null||
diff --git a/manage/src/main/java/com/jilongda/manage/model/TInventoryLensDetail.java b/manage/src/main/java/com/jilongda/manage/model/TInventoryLensDetail.java
index 2b60b81..db146a3 100644
--- a/manage/src/main/java/com/jilongda/manage/model/TInventoryLensDetail.java
+++ b/manage/src/main/java/com/jilongda/manage/model/TInventoryLensDetail.java
@@ -40,6 +40,9 @@
     @ApiModelProperty(value = "系列")
     @TableField("series")
     private String series;
+    @ApiModelProperty(value = "品牌")
+    @TableField("brand")
+    private String brand;
 
     @ApiModelProperty(value = "1球面 2非球面 3双非")
     @TableField("type")
diff --git a/manage/src/main/java/com/jilongda/manage/query/TOptometryQuery.java b/manage/src/main/java/com/jilongda/manage/query/TOptometryQuery.java
index f230833..4cc7b0f 100644
--- a/manage/src/main/java/com/jilongda/manage/query/TOptometryQuery.java
+++ b/manage/src/main/java/com/jilongda/manage/query/TOptometryQuery.java
@@ -24,7 +24,6 @@
     @ApiModelProperty(value = "验光师id")
     private Integer optometristId;
     @ApiModelProperty(value = "用户id")
-    @NotNull(message = "用户id不能为空")
     private Integer userId;
     @ApiModelProperty(value = "开始时间 前端忽略")
     private String startTime;
diff --git a/manage/src/main/java/com/jilongda/manage/query/TOrderQuery.java b/manage/src/main/java/com/jilongda/manage/query/TOrderQuery.java
index ed897db..8f9074d 100644
--- a/manage/src/main/java/com/jilongda/manage/query/TOrderQuery.java
+++ b/manage/src/main/java/com/jilongda/manage/query/TOrderQuery.java
@@ -49,4 +49,6 @@
     private List<Integer> userIds;
     @ApiModelProperty(value = "订单ids 前端忽略")
     private List<Integer> orderIds;
+    @ApiModelProperty(value = "用户id")
+    private Integer userId;
 }
diff --git a/manage/src/main/java/com/jilongda/manage/service/impl/TWarehousingServiceImpl.java b/manage/src/main/java/com/jilongda/manage/service/impl/TWarehousingServiceImpl.java
index 3e10b96..fe8dfbe 100644
--- a/manage/src/main/java/com/jilongda/manage/service/impl/TWarehousingServiceImpl.java
+++ b/manage/src/main/java/com/jilongda/manage/service/impl/TWarehousingServiceImpl.java
@@ -60,6 +60,7 @@
                     tFrameWarehousingDetailVO.setStoreName(store.getName());
                 }
             }
+//            tFrameWarehousingDetailVO.setStatus();
         }
         pageInfo.setRecords(list);
         return pageInfo;
diff --git a/manage/src/main/java/com/jilongda/manage/vo/TInventoryInfoVO.java b/manage/src/main/java/com/jilongda/manage/vo/TInventoryInfoVO.java
index 30e5424..edc1930 100644
--- a/manage/src/main/java/com/jilongda/manage/vo/TInventoryInfoVO.java
+++ b/manage/src/main/java/com/jilongda/manage/vo/TInventoryInfoVO.java
@@ -16,6 +16,6 @@
     private String store;
     @ApiModelProperty(value = "镜片盘点明细")
     private List<TInventoryLensDetail> lensList;
-    @ApiModelProperty(value = "镜片盘点明细")
+    @ApiModelProperty(value = "镜架盘点明细")
     private List<TInventoryFrameDetail> frameList;
 }
diff --git a/manage/src/main/resources/mapping/TFrameWarehousingDetailMapper.xml b/manage/src/main/resources/mapping/TFrameWarehousingDetailMapper.xml
index 75970c0..08639fe 100644
--- a/manage/src/main/resources/mapping/TFrameWarehousingDetailMapper.xml
+++ b/manage/src/main/resources/mapping/TFrameWarehousingDetailMapper.xml
@@ -27,7 +27,7 @@
     </sql>
     <select id="pageList" resultType="com.jilongda.manage.vo.TFrameWarehousingDetailVO">
         select tfwd.id, tfwd.warehousingId, tfwd.brand, tfwd.supplier, tfwd.material, tfwd.total, tfwd.color, tfwd.model, tfwd.code, tfwd.createTime,
-               tfwd.updateTime, tfwd.createBy, tfwd.updateBy, tfwd.isDelete, tfwd.modelId,tw.storeId
+               tfwd.updateTime, tfwd.createBy, tfwd.updateBy, tfwd.isDelete, tfwd.modelId,tw.storeId,tw.status
         from t_frame_warehousing_detail tfwd
         left join t_warehousing tw on tfwd.warehousingId = tw.id
         <where>
diff --git a/manage/src/main/resources/mapping/TOptometristMapper.xml b/manage/src/main/resources/mapping/TOptometristMapper.xml
index 5ba7db0..3005ab6 100644
--- a/manage/src/main/resources/mapping/TOptometristMapper.xml
+++ b/manage/src/main/resources/mapping/TOptometristMapper.xml
@@ -46,12 +46,15 @@
             <if test="query.phone != null and query.phone != ''">
                 and t1.phone like  concat('%',#{query.phone},'%')
             </if>
-            <if test="query.storeId != null and query.storeId != ''">
+            <if test="query.storeId != null ">
                 and t1.storeId =  #{query.storeId}
             </if>
-            <if test="query.optometristId != null and query.optometristId != ''">
+            <if test="query.optometristId != null ">
                 and t1.optometristId =  #{query.optometristId}
             </if>
+            <if test="query.userId != null ">
+                and t1.userId =  #{query.userId}
+            </if>
             <if test="query.startTime != null and query.startTime!=''">
                 and (t1.createTime between #{query.startTime} and #{query.endTime})
             </if>
diff --git a/manage/src/main/resources/mapping/TOrderMapper.xml b/manage/src/main/resources/mapping/TOrderMapper.xml
index 3c6903d..b0b423f 100644
--- a/manage/src/main/resources/mapping/TOrderMapper.xml
+++ b/manage/src/main/resources/mapping/TOrderMapper.xml
@@ -71,13 +71,19 @@
             and orderMoney between #{query.startMoney} and #{query.endMoney}
         </if>
         <if test="query.realName != null and query.realName != ''">
-            and `name` like concat('%',#{query.realName},'%')
+            and realName like concat('%',#{query.realName},'%')
+        </if>
+          <if test="query.phone != null and query.phone != ''">
+            and phone like concat('%',#{query.phone},'%')
         </if>
         <if test="query.storeId != null">
             and storeId = #{query.storeId}
         </if>
         <if test="query.sysId != null">
             and sysId = #{query.sysId}
+        </if>
+          <if test="query.userId != null">
+            and userId = #{query.userId}
         </if>
         <if test="query.userIds != null and query.userIds.size()>0">
             AND userId IN
@@ -91,5 +97,6 @@
                 #{id}
             </foreach>
         </if>
+        order by createTime desc
     </select>
 </mapper>

--
Gitblit v1.7.1