package com.skua.modules.assessment.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.skua.modules.assessment.entity.DataAssessmentSocre;
import com.skua.modules.assessment.vo.DataAssessmentSocreVO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * 专家考核评价分数表
 */
public interface DataAssessmentSocreMapper extends BaseMapper<DataAssessmentSocre> {

    List<Map<String, Object>> queryFacListByMonth(@Param("month") String month);

    @Select("select dai.id,asse_depart,asse_positions,sum(data_score) data_score,user_id applicant,depart_id," +
            "das.create_by approver,data_month from data_assessment_info dai \n" +
            "\t\tleft join data_assessment_item di on dai.id = di.type \n" +
            "\t\tleft join data_assessment_socre das on di.field = das.field ${ew.customSqlSegment}\n")
    IPage<DataAssessmentSocreVO> getDataAssessmentSocrePage(Page<DataAssessmentSocreVO> page, @Param(Constants.WRAPPER) QueryWrapper<DataAssessmentSocreVO> dataAssessmentSocreVOQueryWrapper);
}