208、商城业务-商品详情-销售属性渲染

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

    </resultMap>
    
    <select id="getSaleAttrsBySpuId" resultMap="SkuItemSaleAttrVo">

        SELECT
pssav.attr_id as attr_id,
pssav.attr_name as attr_name,
pssav.attr_value as attr_value,
GROUP_CONCAT(DISTINCT pki.sku_id) as sku_ids
        FROM pms_sku_info pki
        LEFT JOIN pms_sku_sale_attr_value pssav ON pki.sku_id = pssav.sku_id
        WHERE pki.spu_id=#{spuId}
        GROUP BY pssav.attr_id,pssav.attr_name, pssav.attr_value
    </select>

<dl>
									<dt>选择[[${attr.attrName}]]</dt>
<!--									<dd th:each="val:${#strings.listSplit(attr.attrValues, ,)}">-->
<!--										<a href="/static/item/#">-->
<!--											[[${val}]]-->
<!--&lt;!&ndash;											<img src="/static/item/img/59ddfcb1Nc3edb8f1.jpg" /> 摩卡金&ndash;&gt;-->
<!--										</a>-->
<!--									</dd>-->
									<dd th:each="vals:${attr.attrValues}">
										<a href="/static/item/#" th:attr="skus=${vals.skuIds}">
											[[${vals.attrValue}]]
										</a>
									</dd>

								</dl>

item.html