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