@Override
public Page<AttendRecordDto> listAttendRecordByPage(AttendRecordDto recordDto) {
PageHelper.startPage(recordDto.getPage(), recordDto.getLimit(), "actual_work_time desc");
Example example = new Example(TbAttendRecord.class);
Criteria criteria = example.createCriteria();
criteria.andCondition("work_date>="+recordDto.getStartDate());
criteria.andCondition("work_date<="+recordDto.getEndDate());
if(recordDto.getName() != null && !"".equals(recordDto.getName())){
criteria.andCondition("name like '%"+recordDto.getName()+"%'");
}
if(recordDto.getUserId()!=null && recordDto.getUserId()>0){
criteria.andCondition("user_id="+recordDto.getUserId());
}
if(recordDto.getEmpType() != null){
criteria.andCondition("emp_type="+recordDto.getEmpType());
}
if(recordDto.getDeptId() != null){
criteria.andCondition("dept_id="+recordDto.getDeptId());
}
//设置排序
example.setOrderByClause("work_date desc");
Page<TbAttendRecord> list = (Page<TbAttendRecord>) recordMapper.selectByExample(example);
Page<AttendRecordDto> convertList = BeanUtils.convertPage(list, AttendRecordDto.class);
return convertList;
}
public Page<AttendRecordDto> listAttendRecordByPage(AttendRecordDto recordDto) {
PageHelper.startPage(recordDto.getPage(), recordDto.getLimit(), "actual_work_time desc");
Example example = new Example(TbAttendRecord.class);
Criteria criteria = example.createCriteria();
criteria.andCondition("work_date>="+recordDto.getStartDate());
criteria.andCondition("work_date<="+recordDto.getEndDate());
if(recordDto.getName() != null && !"".equals(recordDto.getName())){
criteria.andCondition("name like '%"+recordDto.getName()+"%'");
}
if(recordDto.getUserId()!=null && recordDto.getUserId()>0){
criteria.andCondition("user_id="+recordDto.getUserId());
}
if(recordDto.getEmpType() != null){
criteria.andCondition("emp_type="+recordDto.getEmpType());
}
if(recordDto.getDeptId() != null){
criteria.andCondition("dept_id="+recordDto.getDeptId());
}
//设置排序
example.setOrderByClause("work_date desc");
Page<TbAttendRecord> list = (Page<TbAttendRecord>) recordMapper.selectByExample(example);
Page<AttendRecordDto> convertList = BeanUtils.convertPage(list, AttendRecordDto.class);
return convertList;
}