package com.cloudroam.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.cloudroam.bo.ProjectDailyBO;
import com.cloudroam.bo.ProjectStatisticsBO;
import com.cloudroam.dto.meeting.MeetingPageDTO;
import com.cloudroam.dto.projectDaily.QueryProjectDailyDTO;
import com.cloudroam.dto.projectDaily.QueryProjectHourStatisticsDTO;
import com.cloudroam.dto.projectTask.QueryTaskDailyDTO;
import com.cloudroam.model.ProjectDailyDO;
import com.cloudroam.model.UserDO;
import com.cloudroam.vo.projectDaily.ProjectDailyHourVO;
import com.cloudroam.vo.projectDaily.ProjectDailyStatisticsVO;
import org.apache.ibatis.annotations.Param;

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

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author generator@TaoJie
 * @since 2023-08-09
 */
public interface ProjectDailyMapperCustom extends BaseMapper<ProjectDailyDO> {

    IPage<ProjectDailyBO> selectProjectDailyPage(Page<ProjectDailyBO> page,
                                                 @Param("keyword") String keyword,
                                                 @Param("dailyDate") String dailyDate,
                                                 @Param("dailyType") String dailyType,
                                                 @Param("dailyStatus") String dailyStatus,
                                                 @Param("projectId") String projectId,
                                                 @Param("createUserId") String createUserId,
                                                 @Param("isCommit") Integer isCommit,
                                                 @Param("isConfirm") Integer isConfirm);

    List<ProjectDailyBO> selectProjectDailyList(@Param("createUserId") String createUserId,
                                                @Param("dailyDate") String dailyDate,
                                                @Param("projectId") String projectId,
                                                @Param("startDate") String startDate,
                                                @Param("endDate") String endDate
                                                 );

    /**
     * 有前一天未确认的日志
     * @return
     */
    List<ProjectDailyBO> getYesterdayUncommittedProjectDailys(@Param("createUserId") String createUserId);

    List<ProjectDailyBO> getYesterdayUnconfirmedProjectDailys(@Param("createUserId") String createUserId);

    List<UserDO> getTodayNoDailyPeoples();

    List<UserDO> getYesterdayUncommittedProjectDailysPeoples();

    List<UserDO> getYesterdayUncomfirmedProjectDailysPeoples();

    int insertBatch(@Param("list") List<ProjectDailyDO> list);

    List<ProjectStatisticsBO> getActualHoursStatistic(@Param("projectId") String projectId);

    List<UserDO> getToadyUncomfirmedActualHoursProjectDailysPeoples(@Param("dailyDate") String dailyDate);

    List<ProjectDailyBO> getTodayUnConfirmedActualHours(@Param("createUserId") String createUserId, @Param("dailyDate") String todayString);

    List<UserDO> getUnComfirmedPeoples(@Param("dailyDate") String dailyDate);

    List<UserDO> getTodayUncommittedProjectDailysPeoples();

    List<ProjectDailyBO> getTodayUncommittedProjectDailys(@Param("createUserId") String createUserId);

    Double getDailyDatePlanTime(@Param("dailyDate")String dailyDate, @Param("createUserId")String createUserId);

    Double getDailyDateActualTime(@Param("dailyDate")String dailyDate,@Param("createUserId") String createUserId);

    ProjectDailyHourVO existsHoursWithoutIds(@Param("createUserId") String createUserId,@Param("dailyDate") String dailyDate,@Param("idList") List<String> idList);

    void deleteDailysByDateUser(@Param("createUserId") String createUserId,@Param("dailyDate")  Date dailyDate);

    List<ProjectDailyStatisticsVO> getActualHourStatistics(QueryProjectHourStatisticsDTO dto);

    List<ProjectDailyStatisticsVO> getEvaluateiActualHourStatistics(QueryProjectHourStatisticsDTO dto);

    List<ProjectDailyStatisticsVO> getUserActualHourStatistics(QueryProjectHourStatisticsDTO dto);

    List<ProjectDailyStatisticsVO> getRoleHourStatistics(QueryProjectHourStatisticsDTO dto);


    /**
     * 获取每日早会的进度状态
     * @return
     */
    List<ProjectDailyBO> selectProjectDailyProcessList(QueryProjectDailyDTO queryProjectDailyDTO);

    List<ProjectDailyBO> selectProjectDailyProcessWithMeetingIdList(QueryProjectDailyDTO queryProjectDailyDTO);

    List<String> getDailyDateByMeetingId(MeetingPageDTO dto);

    IPage<ProjectDailyBO> selectProjectDailyTaskPage(Page<ProjectDailyBO> page,@Param("dto") QueryProjectDailyDTO dto);

    List<QueryTaskDailyDTO> getProjectDailyTaskInfo(@Param("taskId") String taskId, @Param("userId") String userId);
}