商品詳情

@GetMapping("/{skuId}.html")
public String skuItem(@PathVariable("skuId") Long skuId, Model model) throws ExecutionException,
        InterruptedException {
    System.out.println("準備查詢" + skuId + "詳情");


    SkuItemVo vos = skuInfoService.item(skuId);
    model.addAttribute("item", vos);
    return "item";
}

//1、sku基本信息的獲取  pms_sku_info
private SkuInfoEntity info;

private boolean hasStock = true;

//2、sku的圖片信息    pms_sku_images
private List<SkuImagesEntity> images;

//3、獲取spu的銷售屬性組合【一個vo是一個銷售屬性】
private List<SkuItemSaleAttrVo> saleAttr;

//4、獲取spu的介紹
private SpuInfoDescEntity desc;

//5、獲取spu的規格參數信息【以組為單位】
private List<SpuItemAttrGroupVo> groupAttrs;

// 商品詳情
@Override
public SkuItemVo item(Long skuId) throws ExecutionException, InterruptedException {

    SkuItemVo skuItemVo = new SkuItemVo();

    CompletableFuture<SkuInfoEntity> infoFuture = CompletableFuture.supplyAsync(() -> {
        // 1、sku基本信息的獲取  pms_sku_info
        SkuInfoEntity info = this.getById(skuId);
        skuItemVo.setInfo(info);
        return info;
    }, executor);

    CompletableFuture<Void> saleAttrFuture = infoFuture.thenAcceptAsync((res) -> {
        // 3、獲取spu的銷售屬性組合
        List<SkuItemSaleAttrVo> saleAttrVos = skuSaleAttrValueService.getSaleAttrBySpuId(res.getSpuId());
        skuItemVo.setSaleAttr(saleAttrVos);
    }, executor);

    CompletableFuture<Void> descFuture = infoFuture.thenAcceptAsync((res) -> {
        // 4、獲取spu的介紹    pms_spu_info_desc
        SpuInfoDescEntity spuInfoDescEntity = spuInfoDescService.getById(res.getSpuId());
        skuItemVo.setDesc(spuInfoDescEntity);
    }, executor);

    CompletableFuture<Void> baseAttrFuture = infoFuture.thenAcceptAsync((res) -> {
        // 5、獲取spu的規格參數信息
        List<SpuItemAttrGroupVo> attrGroupVos = attrGroupService.getAttrGroupWithAttrsBySpuId(res.getSpuId(),
                res.getCatalogId());
        skuItemVo.setGroupAttrs(attrGroupVos);
    }, executor);

    // 2、sku的圖片信息    pms_sku_images
    CompletableFuture<Void> imageFuture = CompletableFuture.runAsync(() -> {
        List<SkuImagesEntity> imagesEntities = skuImagesService.getImagesBySkuId(skuId);
        if (ArrayUtil.isNotEmpty(imagesEntities)) {
            skuItemVo.setImages(imagesEntities);
        }
    }, executor);

    // 等到所有任務都完成
    CompletableFuture.allOf(saleAttrFuture, descFuture, baseAttrFuture, imageFuture).get();

    return skuItemVo;
}

<!--只要有嵌套屬性就要封裝自定義結果集-->
<resultMap id="spuAttrGroup" type="yozi.mall.product.vo.SpuItemAttrGroupVo">
    <result property="groupName" column="attr_group_name"/>
    <collection property="attrs" ofType="yozi.mall.product.vo.Attr">
        <result property="attrId" column="attr_id"></result>
        <result property="attrName" column="attr_name"></result>
        <result property="attrValue" column="attr_value"></result>
    </collection>
</resultMap>
<select id="getAttrGroupWithAttrsBySpuId" resultMap="spuAttrGroup">
    SELECT pav.spu_id,
           pag.attr_group_id,
           pag.attr_group_name,
           pav.attr_id,
           pav.attr_name,
           pav.attr_value
    FROM pms_product_attr_value pav
             LEFT JOIN pms_attr_attrgroup_relation pagr ON pav.attr_id = pagr.attr_id
             LEFT JOIN pms_attr_group pag ON pagr.attr_group_id = pag.attr_group_id
    WHERE pav.spu_id = #{spuId}
      AND pag.catalog_id = #{catalogId}
</select>

<resultMap id="skuItemSaleAttrVo" type="yozi.mall.product.vo.SkuItemSaleAttrVo">
    <result column="attr_id" property="attrId"></result>
    <result column="attr_name" property="attrName"></result>
    <collection property="attrValues" ofType="yozi.mall.product.vo.AttrValueWithSkuIdVo">
        <result column="attr_value" property="attrValue"></result>
        <result column="sku_ids" property="skuIds"></result>
    </collection>
</resultMap>

<select id="getSaleAttrBySpuId" resultMap="skuItemSaleAttrVo">
    SELECT ssav.attr_id                        attr_id,
           ssav.attr_name                      attr_name,
           ssav.attr_value,
           group_concat(DISTINCT info.sku_id ) sku_ids
    FROM pms_sku_info info
             LEFT JOIN pms_sku_sale_attr_value ssav ON ssav.sku_id = info.sku_id
    WHERE info.spu_id = #{spuId}
    GROUP BY ssav.attr_id,
             ssav.attr_name,
             ssav.attr_value
</select>

@Configuration
public class CustomThreadConfig {
    
    @Bean
    public ThreadPoolExecutor threadPoolExecutor(ThreadPoolConfigProperties properties) {
        return new ThreadPoolExecutor(
                properties.getCoreSize(),
                properties.getMaxSize(),
                properties.getKeepAliveTime(),
                TimeUnit.SECONDS,
                new LinkedBlockingDeque<>(10000),
                Executors.defaultThreadFactory(),
                new ThreadPoolExecutor.AbortPolicy()
        );
    }
}