/**
 * Copyright (c) 2018-2099, Chill Zhuang 庄骞 (bladejava@qq.com).
 * <p>
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * <p>
 * http://www.apache.org/licenses/LICENSE-2.0
 * <p>
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.xiaoniu.subsystem.business.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.xiaoniu.common.core.vo.LabelAndValueVO;
import com.xiaoniu.common.mybatis.mapper.BaseMapperPlus;
import com.xiaoniu.subsystem.business.domain.Project;
import com.xiaoniu.subsystem.business.domain.vo.ProjectVO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 培训计划管理表 Mapper 接口
 *
 * @author sst
 * @since 2024-11-26
 */
public interface ProjectMapper extends BaseMapperPlus<ProjectMapper,Project,Project> {

    /**
     * 自定义分页
     *
     * @param page
     * @param project
     * @return
     */
    List<ProjectVO> selectProjectPage(IPage page, ProjectVO project);

    /**
     * 获取计划参训人数
     *
     * @param unitIdList 部门id
     * @return 数量
     */
    Integer getPlanParticipateNum(@Param("unitIdList") List<Long> unitIdList, @Param("yearList") List<String> yearList,@Param("flightId") Long flightId);

    /**
     * 获取计划参训人员
     *
     * @param unitIdList 部门id
     * @return List<LabelAndValueVO>
     */
    List<LabelAndValueVO> overYearsParticipants(@Param("unitIdList") List<Long> unitIdList, @Param("yearList") List<String> yearList);

    /**
     * 班次统计-培训班数量
     *
     * @param unitIdList 单位id
     * @param yearList   年份集合
     * @return List<LabelAndValueVO>
     */
    List<LabelAndValueVO> flightTrainingCourseNum(@Param("unitIdList") List<Long> unitIdList, @Param("yearList") List<String> yearList);

    /**
     * 班次统计-各承训开设班次数量占比
     *
     * @param unitIdList 单位id
     * @param yearList   年份
     * @return List<LabelAndValueVO>
     */
    List<LabelAndValueVO> flightNumProportion(@Param("unitIdList") List<Long> unitIdList, @Param("yearList") List<String> yearList);
}
