package com.newfiber.api.pc.dao.Assessment;

import com.newfiber.api.pc.model.Assessment.Assessment;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;

@Repository
public interface AssessmentDao {
	
	//查询考核集合
	List<Assessment> getAssessmentList(Assessment assessment);
	int countAssessmentList(Assessment assessment);
	
	//查询下级考核集合
	List<Assessment> getSubAssessmentList(@Param("list") List<String> list,
                                          @Param("pageNo") int pageNo,
                                          @Param("pageSize") int pageSize,
                                          @Param("startTime") Date startTime,
                                          @Param("endTime") Date endTime,
                                          @Param("templateNo") String templateNo);

	//查询考核数
	int countAssessment(Assessment assessment);

	//查询考核详情
	Assessment getAssessment(Long serial);

	//新增考核
	int insertAssessment(Assessment assessment);

	//修改考核
	int updateAssessment(Assessment assessment);

	//删除考核
	int deleteAssessmentBySerial(Assessment assessment);

	//根据模板编号查询使用该模板的考核编号
	List<String> getAssessmentNoByTemplateNo(String tenplateNo);

	//根据模板编号删除考核
	int deleteByTemplateNo(String tenplateNo);

	//查询同区域平级用户
	List<String> getMySameLevelRiverChief(String userNo);

	//查询当前用户所有考核
	List<String> getMyAllTemplateNo(Assessment assessment);

	//查询下级的考核模板编号集合
	List<Assessment> getMySubTemplateNo(@Param("list") List<String> list,
                                        @Param("startTime") Date startTime,
                                        @Param("endTime") Date endTime);

	//查询排名
	List<Assessment> getMyRanking(@Param("userNo") String userNo,
                                  @Param("templateNoList") List<String> templateNoList,
                                  @Param("pageNo") Integer pageNo,
                                  @Param("pageSize") Integer pageSize);

	List<Assessment> getSubRanking(@Param("uList") List<String> uList,
								  @Param("templateNoList") List<String> templateNoList,
								  @Param("pageNo") Integer pageNo,
								  @Param("pageSize") Integer pageSize);
}