package com.sinata.shop.modular.mall.service.impl;
|
|
import com.baomidou.mybatisplus.mapper.EntityWrapper;
|
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
|
import com.sinata.shop.modular.mall.dao.MallUserEvaluationMapper;
|
import com.sinata.shop.modular.mall.model.MallUserEvaluation;
|
import com.sinata.shop.modular.mall.service.IMallUserEvaluationService;
|
import org.springframework.stereotype.Service;
|
|
/**
|
* <p>
|
* 用户评价 服务实现类
|
* </p>
|
*
|
* @author frankevil
|
* @since 2023-03-16
|
*/
|
@Service
|
public class MallUserEvaluationServiceImpl extends ServiceImpl<MallUserEvaluationMapper, MallUserEvaluation> implements IMallUserEvaluationService {
|
|
@Override
|
public Double getMerchantScore(Integer merchantId) {
|
return (Double) this.selectObj(new EntityWrapper<MallUserEvaluation>()
|
.setSqlSelect("IFNULL(AVG(score) ,0)")
|
.eq("merchant_id", merchantId)
|
.eq("is_delete", false));
|
}
|
}
|
