动态心电装拆管理系统
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
eight
2024-11-28 d1708b4b2bc6596f9c62354274f1af97be45401c 
 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/appointment/AppointmentMapper.java


@@ -1,13 +1,16 @@


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




import java.time.LocalDate;


import java.util.List;




/**


 * 预约 Mapper


@@ -18,6 +21,7 @@


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())


@@ -33,12 +37,23 @@


                .eqIfPresent(AppointmentDO::getPatWardDesc, reqVO.getPatWardDesc())


                .eqIfPresent(AppointmentDO::getPatBedNo, reqVO.getPatBedNo())


                .eqIfPresent(AppointmentDO::getBookId, reqVO.getBookId())


                .eqIfPresent(AppointmentDO::getBookPeriodStart, reqVO.getBookPeriodStart())


                .eqIfPresent(AppointmentDO::getBookPeriodEnd, reqVO.getBookPeriodEnd())


                .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())")


    List<AppointmentDO> getCurrentPatId(@Param("patId") String patId);


*/




    @Select("select * from lihu.appointment where pat_id = #{patId} and book_check_type = #{checkType} and to_days(book_date) = to_days(Now()) limit 1")


    AppointmentDO getCurrentByPatAndCheckType(@Param("patId") String patId, @Param("checkType") Integer checkType);




    @Select("select * from lihu.appointment where pat_id = #{patId} and book_check_type = #{checkType} and to_days(book_date) = to_days(#{book_date}) limit 1")


    AppointmentDO getByPatAndCheckTypeAndBookDate(@Param("patId") String patId, @Param("checkType") Integer checkType, @Param("book_date") LocalDate book_date);


}