From 0bf174be571c53b8af796eca4b51fcd3edec1657 Mon Sep 17 00:00:00 2001
From: DESKTOP-71BH0QO\L、ming <172680469@qq.com>
Date: 星期日, 25 四月 2021 21:55:43 +0800
Subject: [PATCH] no

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComCvtServeServiceImpl.java |   46 +++++++++++++++++++++++++++++++++++++---------
 1 files changed, 37 insertions(+), 9 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComCvtServeServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComCvtServeServiceImpl.java
index a1b87e3..fa04c48 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComCvtServeServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComCvtServeServiceImpl.java
@@ -1,5 +1,6 @@
 package com.panzhihua.service_community.service.impl;
 
+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;
@@ -24,10 +25,7 @@
 import org.springframework.util.ObjectUtils;
 
 import javax.annotation.Resource;
-import java.util.ArrayList;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
 import java.util.stream.Collectors;
 
 /**
@@ -69,6 +67,9 @@
     public R addComCvtServe(ComCvtServeDTO comCvtServeDTO) {
         ComCvtServeDO comCvtServeDO = new ComCvtServeDO();
         BeanUtils.copyProperties(comCvtServeDTO, comCvtServeDO);
+        if(checkRepeat(comCvtServeDO)){
+            return R.fail("服务已存在");
+        }
         int insert = comCvtServeDAO.insert(comCvtServeDO);
         if (insert > 0) {
             return R.ok();
@@ -82,8 +83,12 @@
         if (null == comCvtServeDO) {
             return R.fail("该服务不存在");
         }
-        BeanUtils.copyProperties(comCvtServeDTO, comCvtServeDO);
-        int update = comCvtServeDAO.updateById(comCvtServeDO);
+        ComCvtServeDO comCvtServeDO2 = new ComCvtServeDO();
+        BeanUtils.copyProperties(comCvtServeDTO, comCvtServeDO2);
+        if(!comCvtServeDO.equals(comCvtServeDO2) && checkRepeat(comCvtServeDO2)){
+            return R.fail("该服务与其他服务重复");
+        }
+        int update = comCvtServeDAO.updateById(comCvtServeDO2);
         if (update > 0) {
             return R.ok();
         }
@@ -166,7 +171,7 @@
         if (null != communityId && communityId != 0) {
             comCvtBusinessDOS = comCvtBusinessDAO.selectList(new QueryWrapper<ComCvtBusinessDO>().lambda().eq(ComCvtBusinessDO::getCommunityId, communityId));
         } else {
-            comCvtBusinessDOS = comCvtBusinessDAO.selectList(null);
+            comCvtBusinessDOS = comCvtBusinessDAO.selectList(new LambdaQueryWrapper<>());
         }
         Map<String, Long> businessMap = getBusinessMap(comCvtBusinessDOS);
         list.forEach(comCvtServeExcelVO -> {
@@ -175,13 +180,19 @@
                 BeanUtils.copyProperties(comCvtServeExcelVO, comCvtServeDO);
                 comCvtServeDO.setCategoryId(categoryMap.get(comCvtServeExcelVO.getCategoryName()));
                 comCvtServeDO.setBusinessId(businessMap.get(comCvtServeExcelVO.getBusinessName()));
-                comCvtServeDOS.add(comCvtServeDO);
+                //检查商家是否已有某服务
+                if(!checkRepeat(comCvtServeDO)){
+                    comCvtServeDOS.add(comCvtServeDO);
+                }else{
+                    log.error(String.format("导入失败:商家【%s】下已有服务【%s】",comCvtServeExcelVO.getBusinessName(),comCvtServeExcelVO.getServiceName()));
+                }
             }
         });
         this.saveBatch(comCvtServeDOS);
-        return R.ok();
+        return R.ok("共计导入服务数量:"+comCvtServeDOS.size());
     }
 
+    //获取分类集合
     private Map<String, Long> getCategoryMap(List<ComCvtCategoryDO> categoryDOS) {
         Map<String, Long> categoryMap = new HashMap<>();
         if (!ObjectUtils.isEmpty(categoryDOS)) {
@@ -192,6 +203,7 @@
         return categoryMap;
     }
 
+    //获取商家集合
     private Map<String, Long> getBusinessMap(List<ComCvtBusinessDO> comCvtBusinessDOS) {
         Map<String, Long> businessMap = new HashMap<>();
         if (!ObjectUtils.isEmpty(comCvtBusinessDOS)) {
@@ -201,4 +213,20 @@
         }
         return businessMap;
     }
+
+    /**
+     * 检查服务是否重复 商家名称、分类名称,服务名称、服务价格、服务描述不能同时重复
+     * @param comCvtServeDO
+     * @return
+     */
+    private boolean checkRepeat(ComCvtServeDO comCvtServeDO){
+        Integer count = comCvtServeDAO.selectCount(new QueryWrapper<ComCvtServeDO>().lambda()
+                .eq(ComCvtServeDO::getBusinessId,comCvtServeDO.getBusinessId())
+                .and(wrapper->wrapper.eq(ComCvtServeDO::getCategoryId,comCvtServeDO.getCategoryId()))
+                .and(wrapper->wrapper.eq(ComCvtServeDO::getServiceName,comCvtServeDO.getServiceName()))
+                .and(wrapper->wrapper.eq(ComCvtServeDO::getServicePrice,comCvtServeDO.getServicePrice()))
+                .and(wrapper->wrapper.eq(ComCvtServeDO::getServiceDesc,comCvtServeDO.getServiceDesc()))
+        );
+        return count>0 ? true : false;
+    }
 }

--
Gitblit v1.7.1