| | |
| | | import cn.lihu.jh.module.ecg.controller.admin.jobrecord.vo.*; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Select; |
| | | import org.apache.ibatis.annotations.Update; |
| | | |
| | | /** |
| | | * 工作记录 Mapper |
| | |
| | | |
| | | default PageResult<JobRecordDO> selectPage(JobRecordPageReqVO reqVO) { |
| | | return selectPage(reqVO, new LambdaQueryWrapperX<JobRecordDO>() |
| | | .eqIfPresent(JobRecordDO::getJobType, reqVO.getJobType()) |
| | | //.eqIfPresent(JobRecordDO::getJobType, reqVO.getJobType()) |
| | | .inIfPresent(JobRecordDO::getJobType, reqVO.getJobType()) |
| | | .eqIfPresent(JobRecordDO::getDocId, reqVO.getDocId()) |
| | | .likeIfPresent(JobRecordDO::getDocName, reqVO.getDocName()) |
| | | .eqIfPresent(JobRecordDO::getDevId, reqVO.getDevId()) |
| | |
| | | .orderByDesc(JobRecordDO::getId)); |
| | | } |
| | | |
| | | @Select("SELECT * FROM lihu.job_record where rent_id=#{rentId} and job_type=#{jobType} and doc_id=#{docId} limit 1") |
| | | JobRecordDO selectByRentIdJobTypeDocId(@Param("rentId") Long rentId, @Param("jobType") Integer jobType, @Param("docId") Long docId ); |
| | | @Select("SELECT * FROM lihu.job_record where rent_id=#{rentId} and doc_id=#{docId} limit 1") |
| | | JobRecordDO selectByRentIdDocId(@Param("rentId") Long rentId, @Param("docId") Long docId ); |
| | | |
| | | @Select("SELECT count(1) FROM lihu.job_record where pat_id=#{patId} and TO_DAYS(job_time)=TO_DAYS(#{jobTime}) and job_type=#{jobType} ") |
| | | Integer getPatientJobNum(@Param("patId") String patId, @Param("jobTime") LocalDateTime jobTime, @Param("jobType") Integer jobType ); |