package com.finance.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.finance.system.domain.TbScore;
import com.finance.system.query.CalculateDetailQuery;
import com.finance.system.query.DeptCalculateDetailQuery;
import com.finance.system.query.ScoreCalculateDetailQuery;
import com.finance.system.query.ScoreQuery;
import com.finance.system.vo.DeptCalculateDetailVO;
import com.finance.system.vo.RiskMapVO;
import com.finance.system.vo.RiskRankingVO;
import com.finance.system.vo.ScoreDetailVO;
import com.finance.system.vo.ScoreRankVO;
import com.finance.system.vo.ScoreVO;
import java.util.List;
import org.apache.ibatis.annotations.Param;

/**
 * <p>
 * 得分表 Mapper 接口
 * </p>
 *
 * @author mitao
 * @since 2024-03-13
 */
public interface TbScoreMapper extends BaseMapper<TbScore> {

    Page<ScoreVO> pageScore(@Param("query") ScoreQuery query, @Param("page") Page<ScoreVO> page);

    Page<ScoreDetailVO> scoreCalculateDetail(@Param("query") ScoreCalculateDetailQuery query,
            @Param("page") Page<ScoreDetailVO> page);

    List<ScoreRankVO> queryTotalScoreList();

    List<ScoreRankVO> queryRankAndScoreByAreaCode(@Param("areaCode") String areaCode,
            @Param("previousQuarter") String previousQuarter);

    List<DeptCalculateDetailVO> deptCalculateDetail(@Param("query") DeptCalculateDetailQuery query,
            @Param("nowQuarter") String nowQuarter);

    Page<ScoreDetailVO> fieldsDetail(@Param("query") CalculateDetailQuery query,
            @Param("page") Page<ScoreDetailVO> page, @Param("countyList") List<String> countyList);

    List<RiskMapVO> getCurrentScoreList(@Param("nowQuarter") String nowQuarter,
            @Param("areaCode") String areaCode);

    List<RiskRankingVO> queryRiskRanking(@Param("nowQuarter") String nowQuarter);

    List<RiskMapVO> getScoreByYearType(@Param("areaCode") String areaCode,
            @Param("quarter") String quarter);

    /**
     * 查询市的平均得分
     *
     * @param areaCode
     * @param previousQuarter
     * @return
     */
    Double getCityAverageScore(@Param("areaCode") String areaCode,
            @Param("previousQuarter") String previousQuarter);

    /**
     * 根据区划代码前四位查询区县得分列表
     *
     * @param areaCode
     * @param previousQuarter
     * @return
     */
    List<Double> getCountyScoreList(@Param("areaCode") String areaCode,
            @Param("previousQuarter") String previousQuarter);
}