1
@Override
2
@CsmallCache(prefix = "skuInfo:")
3
public SkuInfoDTO getSkuInfo(Long skuId) {
4
    SkuInfo skuInfo = skuInfoMapper.selectById(skuId);
5

6
    LambdaQueryWrapper<SkuImage> queryWrapper =
7
            new LambdaQueryWrapper<>();
8
    queryWrapper.eq(SkuImage::getSkuId, skuId);
9
    List<SkuImage> skuImageList =
10
            skuImageMapper.selectList(queryWrapper);
11

12
    skuImageList.forEach(skuImage -> {
13
        SpuImage spuImage =
14
                spuImageMapper.selectById(skuImage.getSpuImgId());
15
        skuImage.setImgName(spuImage.getImgName());
16
        skuImage.setImgUrl(spuImage.getImgUrl());
17
    });
18

19
    skuInfo.setSkuImageList(skuImageList);
20
    return skuInfoConverter.skuInfoPO2DTO(skuInfo);
21
}

1
<select id="selectCategoryHierarchyDTOById"
2
        resultType="com.cskaoyan.mall.product.model.CategoryHierarchy">
3
    select
4
        flc.id AS firstLevelCategoryId,
5
        flc.name AS firstLevelCategoryName,
6
        slc.id AS secondLevelCategoryId,
7
        slc.name AS secondLevelCategoryName,
8
        tlc.id AS thirdLevelCategoryId,
9
        tlc.name AS thirdLevelCategoryName
10
    from third_level_category tlc
11
    inner join second_level_category slc
12
        on tlc.second_level_category_id = slc.id
13
    inner join first_level_category flc
14
        on slc.first_level_category_id = flc.id
15
    where tlc.id = #{thirdLevelCategoryId}
16
      and tlc.is_deleted = 0
17
      and slc.is_deleted = 0
18
      and flc.is_deleted = 0
19
</select>

1
<select id="selectSpuSaleAttrListCheckedBySku"
2
        resultMap="spuSaleAttrMap">
3
    select a.id,
4
           a.spu_id,
5
           a.sale_attr_id,
6
           a.sale_attr_name,
7
           b.id as bid,
8
           b.spu_sale_attr_value_name,
9
           IF(c.id is NULL, 0, 1) as is_checked
10
    from spu_sale_attr_info a
11
    inner join spu_sale_attr_value b
12
        on a.id = b.spu_sale_attr_id
13
    left join sku_sale_attr_value c
14
        on b.id = c.spu_sale_attr_value_id
15
       and c.sku_id = #{skuId}
16
    where a.spu_id = #{spuId}
17
    order by a.sale_attr_id, b.id
18
</select>

1
<select id="selectSaleAttrValuesBySpu"
2
        resultType="com.cskaoyan.mall.product.model.SkuSaleAttributeValuePermutation">
3
    select a.sku_id as skuId,
4
           group_concat(
5
               a.spu_sale_attr_value_id
6
               order by c.sale_attr_id separator '|'
7
           ) as SkuSaleAttrValuePermutation
8
    from sku_sale_attr_value a
9
    inner join spu_sale_attr_value b
10
        on b.id = a.spu_sale_attr_value_id
11
       and a.is_deleted = 0
12
       and b.is_deleted = 0
13
    inner join spu_sale_attr_info c
14
        on c.id = b.spu_sale_attr_id
15
       and c.is_deleted = 0
16
    inner join sku_info d
17
        on d.id = a.sku_id
18
       and d.is_sale = 1
19
       and d.is_deleted = 0
20
    where a.spu_id = #{spuId}
21
    group by a.sku_id
22
</select>