springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/shop/ComShopFlowerGoodsVO.java
@@ -137,6 +137,12 @@ */ private Integer viewNum; /** * 浏览量 */ private Integer evaluateNum; /** * 商品规格列表 */ @@ -147,3 +153,5 @@ @NotEmpty(groups = {AddGroup.class}, message = "商品分类不能为空") private List<Long> categoryIds; }
@@ -47,4 +47,6 @@ * @return */ BigDecimal statisticsScore(@Param("storeId") Long storeId); Integer selectCountByGoodsId(@Param("goodsId") Long goodsId); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComShopFlowerGoodsServiceImpl.java
@@ -222,6 +222,8 @@ shopGoods.setOrderNum(orderNum); List<ComShopFlowerEvaluateVO> comShopFlowerEvaluateVOList = comShopFlowerEvaluateDAO.selectListLimit(goodsId); shopGoods.setShopFlowerEvaluateVOList(comShopFlowerEvaluateVOList); Integer evaluateNum = comShopFlowerEvaluateDAO.selectCountByGoodsId(goodsId); shopGoods.setEvaluateNum(evaluateNum); List<Long> categoryIds = convenientGoodsCategoryDAO.selectCategoryIdsForGoods(goodsId); shopGoods.setCategoryIds(categoryIds); springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComShopFlowerEvaluateDAO.xml
@@ -44,6 +44,8 @@ <select id="statisticsScore" resultType="java.math.BigDecimal"> SELECT (sum(e.evaluate_type)/count(1)) AS pf FROM `com_shop_flower_evaluate` e LEFT JOIN com_shop_flower_goods g ON e.goods_id = g.id WHERE g.store_id = #{storeId} GROUP BY g.store_id </select> <select id="selectCountByGoodsId" resultType="java.lang.Integer"> SELECT count(1) FROM com_shop_flower_evaluate e WHERE e.goods_id = #{goodsId} </select> </mapper>
