From dcdb0231034810232f2542f3865666ebf72daf11 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期三, 30 四月 2025 16:45:34 +0800 Subject: [PATCH] sf --- server/service/src/main/java/com/doumee/service/business/impl/BrandServiceImpl.java | 5 ++++- 1 files changed, 4 insertions(+), 1 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/BrandServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/BrandServiceImpl.java index a49825c..9db3591 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/BrandServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/BrandServiceImpl.java @@ -102,7 +102,8 @@ Brand brand1 = brandMapper.selectOne(new QueryWrapper<Brand>() .eq("ISDELETED", Constants.ZERO) - .eq(user.getType().equals(Constants.UserType.SYSTEM.getKey()), "name", brand.getName()) + .and(user.getType().equals(Constants.UserType.SYSTEM.getKey()), wapper->wapper.lambda().eq(Brand::getType,Constants.ONE).eq(Brand::getName,brand.getName())) +// .eq(user.getType().equals(Constants.UserType.SYSTEM.getKey()), "name", brand.getName()) .and(user.getType().equals(Constants.UserType.COMPANY.getKey()), i -> i.apply(" name = '" + brand.getName() + "' and type = 1 ") .or().apply(" name = '" + brand.getName() + "' and COMPANY_ID = '" + user.getCompanyId() + "' and type = 0 ") @@ -160,6 +161,8 @@ if (Constants.equalsInteger(user.getType(), Constants.UserType.SYSTEM.getKey())) { wrapper.lambda().eq(Brand::getType,Constants.ONE); }else { + wrapper.lambda().exists(!Objects.isNull(brand.getCategoryId())," select 1 from goods g where g.brand_id = brand.id and g.category_id = "+brand.getCategoryId()+" and g.COMPANY_ID = "+user.getCompanyId()+" " + + " and g.STATUS = 0 and g.ISDELETED = 0 "); wrapper.lambda().and(i->i.eq(Brand::getCompanyId,user.getCompanyId()) .or().eq(Brand::getType,Constants.ONE) ); -- Gitblit v1.9.3