基础字段

k94314517

2023-09-20 0ef725513d9542363278236b9ad319c30873b183

基础字段

 server/service/src/main/java/com/doumee/dao/business/model/Brand.java

@@ -77,4 +77,7 @@
    @TableField(exist = false)
    private String imgfullurl;

    @ApiModelProperty(value = "分类主键")
    @TableField(exist = false)
    private Integer categoryId;
}

 server/service/src/main/java/com/doumee/service/business/impl/BrandServiceImpl.java

@@ -161,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)
            );