| package com.panzhihua.service_community.dao; | 
|   | 
| import com.baomidou.mybatisplus.core.mapper.BaseMapper; | 
| import com.baomidou.mybatisplus.core.metadata.IPage; | 
| import com.baomidou.mybatisplus.extension.plugins.pagination.Page; | 
| import com.panzhihua.common.model.dtos.shop.PageComShopFlowerEvaluateDTO; | 
| import com.panzhihua.common.model.vos.shop.ComShopFlowerEvaluateVO; | 
| import com.panzhihua.service_community.model.dos.ComShopFlowerEvaluateDO; | 
| import org.apache.ibatis.annotations.Mapper; | 
| import org.apache.ibatis.annotations.Param; | 
|   | 
| import java.math.BigDecimal; | 
| import java.util.List; | 
|   | 
| /** | 
|  * @ClassName: ComShopFlowerEvaluateMapper | 
|  * @Author: yh | 
|  * @Date: 2022/11/9 16:46 | 
|  * @Description: 评价 | 
|  */ | 
| @Mapper | 
| public interface ComShopFlowerEvaluateDAO extends BaseMapper<ComShopFlowerEvaluateDO> { | 
|     /** | 
|      * 分页查询评价 | 
|      * | 
|      * @param page | 
|      * @param pageComShopFlowerEvaluateDTO | 
|      * @return | 
|      */ | 
|     IPage<ComShopFlowerEvaluateVO> pageEvaluate(@Param("page") Page page, @Param("pageComShopFlowerEvaluateDTO") PageComShopFlowerEvaluateDTO pageComShopFlowerEvaluateDTO); | 
|   | 
|   | 
|     List<ComShopFlowerEvaluateVO> selectListLimit(@Param("goodsId") Long goodsId); | 
|   | 
|     /** | 
|      * 根据订单id查询评价 | 
|      * | 
|      * @param orderNo | 
|      * @return | 
|      */ | 
|     ComShopFlowerEvaluateVO selectByOrderNo(@Param("orderNo") String orderNo); | 
|   | 
|   | 
|     /** | 
|      * 统计商家评分 | 
|      * @param storeId | 
|      * @return | 
|      */ | 
|     BigDecimal statisticsScore(@Param("storeId")  Long storeId); | 
|   | 
|     Integer selectCountByGoodsId(@Param("goodsId") Long goodsId); | 
| } |