package cn.lihu.jh.module.ecg.dal.mysql.appointment;
|
|
import java.util.*;
|
|
import cn.lihu.jh.framework.common.pojo.PageResult;
|
import cn.lihu.jh.framework.mybatis.core.query.LambdaQueryWrapperX;
|
import cn.lihu.jh.framework.mybatis.core.mapper.BaseMapperX;
|
import cn.lihu.jh.module.ecg.dal.dataobject.appointment.AppointmentDO;
|
import cn.lihu.jh.module.ecg.dal.dataobject.room.RoomDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import cn.lihu.jh.module.ecg.controller.admin.appointment.vo.*;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* 预约 Mapper
|
*
|
* @author 马剑波
|
*/
|
@Mapper
|
public interface AppointmentMapper extends BaseMapperX<AppointmentDO> {
|
|
default PageResult<AppointmentDO> selectPage(AppointmentPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<AppointmentDO>()
|
.eqIfPresent(AppointmentDO::getPatId, reqVO.getPatId())
|
.likeIfPresent(AppointmentDO::getPatName, reqVO.getPatName())
|
.eqIfPresent(AppointmentDO::getPatGender, reqVO.getPatGender())
|
.eqIfPresent(AppointmentDO::getPatBirthday, reqVO.getPatBirthday())
|
.eqIfPresent(AppointmentDO::getPatMobile, reqVO.getPatMobile())
|
.eqIfPresent(AppointmentDO::getPatPhone, reqVO.getPatPhone())
|
.eqIfPresent(AppointmentDO::getPatIdentityId, reqVO.getPatIdentityId())
|
.eqIfPresent(AppointmentDO::getPatAddr, reqVO.getPatAddr())
|
.eqIfPresent(AppointmentDO::getPatDeptCode, reqVO.getPatDeptCode())
|
.eqIfPresent(AppointmentDO::getPatDeptDesc, reqVO.getPatDeptDesc())
|
.eqIfPresent(AppointmentDO::getPatWardCode, reqVO.getPatWardCode())
|
.eqIfPresent(AppointmentDO::getPatWardDesc, reqVO.getPatWardDesc())
|
.eqIfPresent(AppointmentDO::getPatBedNo, reqVO.getPatBedNo())
|
.eqIfPresent(AppointmentDO::getBookId, reqVO.getBookId())
|
.eqIfPresent(AppointmentDO::getBookDate, reqVO.getBookDate())
|
.eqIfPresent(AppointmentDO::getBookTimeslot, reqVO.getBookTimeslot())
|
.betweenIfPresent(AppointmentDO::getBookTime, reqVO.getBookTime())
|
.eqIfPresent(AppointmentDO::getBookCheckType, reqVO.getBookCheckType())
|
.eqIfPresent(AppointmentDO::getBookSrc, reqVO.getBookSrc())
|
.orderByDesc(AppointmentDO::getId));
|
}
|
|
|
@Select("select * from lihu.appointment where pat_id = #{patId} and to_days(book_date) = to_days(Now()) limit 1")
|
AppointmentDO getByPatId(@Param("patId") String patId);
|
|
|
}
|
