package cn.iocoder.yudao.module.hrm.dal.mysql.attendance; import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.hrm.dal.dataobject.attendance.HrmEmployeeScheduleDO; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Update; import java.time.LocalDate; import java.util.Collection; import java.util.List; /** * 员工排班明细 Mapper * * @author 超级管理员 */ @Mapper public interface HrmEmployeeScheduleMapper extends BaseMapperX { default HrmEmployeeScheduleDO selectByEmployeeIdAndDate(Long employeeId, LocalDate date) { return selectOne(new LambdaQueryWrapperX() .eq(HrmEmployeeScheduleDO::getEmployeeId, employeeId) .eq(HrmEmployeeScheduleDO::getDate, date)); } default List selectListByPeriod(LocalDate startDate, LocalDate endDate) { return selectList(new LambdaQueryWrapperX() .between(HrmEmployeeScheduleDO::getDate, startDate, endDate) .orderByAsc(HrmEmployeeScheduleDO::getDate)); } default List selectListByEmployeeIdsAndPeriod(Collection employeeIds, LocalDate startDate, LocalDate endDate) { return selectList(new LambdaQueryWrapperX() .in(HrmEmployeeScheduleDO::getEmployeeId, employeeIds) .between(HrmEmployeeScheduleDO::getDate, startDate, endDate) .orderByAsc(HrmEmployeeScheduleDO::getDate)); } default List selectListByEmployeeIdAndPeriod(Long employeeId, LocalDate startDate, LocalDate endDate) { return selectList(new LambdaQueryWrapperX() .eq(HrmEmployeeScheduleDO::getEmployeeId, employeeId) .between(HrmEmployeeScheduleDO::getDate, startDate, endDate) .orderByAsc(HrmEmployeeScheduleDO::getDate)); } default Long selectCountByShiftId(Long shiftId) { return selectCount(new LambdaQueryWrapperX() .eq(HrmEmployeeScheduleDO::getShiftId, shiftId)); } /** * 复活一条已被逻辑删除的排班(唯一索引 uk_employee_date 不含 deleted, * 逻辑删除后再插入同员工同日期会撞唯一键,这里改为把旧行改回有效) * * @return 更新行数,0 表示不存在已删除的同员工同日期记录 */ @Update("UPDATE hrm_employee_schedule SET deleted = 0, shift_id = #{shiftId}, remark = #{remark}, " + "update_time = NOW() WHERE employee_id = #{employeeId} AND date = #{date} AND deleted = 1") int reviveDeletedSchedule(@Param("employeeId") Long employeeId, @Param("date") LocalDate date, @Param("shiftId") Long shiftId, @Param("remark") String remark); }