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