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);
}