use of com.baomidou.mybatisplus.core.metadata.IPage in project CSKY by SHU-Silence.
the class SchoolServiceImpl method fuzzyQuerySchool.
@Override
public ResultVO fuzzyQuerySchool(QueryPageParam queryPageParam) {
String text = queryPageParam.getText();
Integer uid = queryPageParam.getUid();
// 若text为空,直接返回
if (text == null)
return new ResultVO(ResStatus.OK, "text为空", null);
QueryWrapper<School> wrapper = new QueryWrapper<>();
wrapper.like("sname", text).or().like("introduction", text).or().like("short_introduction", text).or().like("official_Site", text).orderByAsc("sid");
IPage<School> schoolPage = new Page<>();
BeanUtils.copyProperties(queryPageParam, schoolPage);
schoolMapper.selectPage(schoolPage, wrapper);
SchoolPageVo schoolPageVo = new SchoolPageVo();
BeanUtils.copyProperties(schoolPage, schoolPageVo);
ArrayList<SchoolVo> schoolVos = new ArrayList<>();
for (School record : schoolPage.getRecords()) {
SchoolVo schoolVo = new SchoolVo();
BeanUtils.copyProperties(record, schoolVo);
schoolVos.add(schoolVo);
}
// 若查到数据,插入search表
if (!schoolVos.isEmpty() && (uid != null))
searchMapper.insert(new Search(0, uid, text));
schoolPageVo.setSchoolVoList(schoolVos);
return new ResultVO(ResStatus.OK, "学校模糊查询分页信息返回成功", schoolPageVo);
}
use of com.baomidou.mybatisplus.core.metadata.IPage in project CSKY by SHU-Silence.
the class TeacherServiceImpl method fuzzyQueryTeacher.
@Override
public ResultVO fuzzyQueryTeacher(TeacherPageParam teacherPageParam) {
String text = teacherPageParam.getText();
Integer uid = teacherPageParam.getUid();
if (text == null)
return new ResultVO(ResStatus.OK, "text为空", null);
QueryWrapper<Teachers> wrapper = new QueryWrapper<>();
wrapper.eq("schoolId", teacherPageParam.getSid()).and(wr -> {
wr.like("tname", text).or().like("studydir", text).or().like("eduresume", text).or().like("proresume", text).or().like("tURL", text);
}).orderByAsc("id");
IPage<Teachers> teachersPage = new Page<>();
BeanUtils.copyProperties(teacherPageParam, teachersPage);
teachersMapper.selectPage(teachersPage, wrapper);
TeacherPageVo teacherPageVo = new TeacherPageVo();
BeanUtils.copyProperties(teachersPage, teacherPageVo);
ArrayList<TeacherVo> teacherVos = new ArrayList<>();
for (Teachers record : teachersPage.getRecords()) {
TeacherVo teacherVo = new TeacherVo();
BeanUtils.copyProperties(record, teacherVo);
teacherVos.add(teacherVo);
}
// 若查到数据,插入search表
if (!teacherVos.isEmpty() && (uid != null))
searchMapper.insert(new Search(0, uid, text));
teacherPageVo.setTeacherVoList(teacherVos);
return new ResultVO(ResStatus.OK, "教师模糊查询分页信息返回成功", teacherPageVo);
}
use of com.baomidou.mybatisplus.core.metadata.IPage in project incubator-hugegraph-toolchain by apache.
the class JobManagerService method list.
public IPage<JobManager> list(int connId, int pageNo, int pageSize, String content) {
QueryWrapper<JobManager> query = Wrappers.query();
query.eq("conn_id", connId);
if (!content.isEmpty()) {
query.like("job_name", content);
}
query.orderByDesc("create_time");
Page<JobManager> page = new Page<>(pageNo, pageSize);
IPage<JobManager> list = this.mapper.selectPage(page, query);
list.getRecords().forEach(task -> {
if (task.getJobStatus() == JobStatus.LOADING) {
List<LoadTask> tasks = this.taskService.taskListByJob(task.getId());
JobStatus status = JobStatus.SUCCESS;
for (LoadTask loadTask : tasks) {
if (loadTask.getStatus().inRunning() || loadTask.getStatus() == LoadStatus.PAUSED || loadTask.getStatus() == LoadStatus.STOPPED) {
status = JobStatus.LOADING;
break;
}
if (loadTask.getStatus() == LoadStatus.FAILED) {
status = JobStatus.FAILED;
break;
}
}
if (status == JobStatus.SUCCESS || status == JobStatus.FAILED) {
task.setJobStatus(status);
this.update(task);
}
}
Date endDate = task.getJobStatus() == JobStatus.FAILED || task.getJobStatus() == JobStatus.SUCCESS ? task.getUpdateTime() : HubbleUtil.nowDate();
task.setJobDuration(endDate.getTime() - task.getCreateTime().getTime());
});
return list;
}
use of com.baomidou.mybatisplus.core.metadata.IPage in project hippo4j by longtai-cn.
the class TenantServiceImpl method queryTenantPage.
@Override
public IPage<TenantRespDTO> queryTenantPage(TenantQueryReqDTO reqDTO) {
LambdaQueryWrapper<TenantInfo> wrapper = Wrappers.lambdaQuery(TenantInfo.class).eq(!StringUtils.isEmpty(reqDTO.getTenantId()), TenantInfo::getTenantId, reqDTO.getTenantId()).eq(!StringUtils.isEmpty(reqDTO.getTenantName()), TenantInfo::getTenantName, reqDTO.getTenantName()).eq(!StringUtils.isEmpty(reqDTO.getOwner()), TenantInfo::getOwner, reqDTO.getOwner());
Page resultPage = tenantInfoMapper.selectPage(reqDTO, wrapper);
return resultPage.convert(each -> BeanUtil.convert(each, TenantRespDTO.class));
}
use of com.baomidou.mybatisplus.core.metadata.IPage in project waynboot-mall by wayn111.
the class ColumnController method list.
@GetMapping("/list")
public R list(Column column) {
Page<Column> page = getPage();
IPage<Column> columnIPage = iColumnService.listPage(page, column);
List<ColumnVO> columnVOS = columnIPage.getRecords().stream().map(item -> {
ColumnVO columnVO = new ColumnVO();
try {
BeanUtils.copyProperties(columnVO, item);
} catch (IllegalAccessException | InvocationTargetException e) {
log.error(e.getMessage(), e);
}
Integer count = iColumnGoodsRelationService.getGoodsNum(item.getId());
columnVO.setGoodsNum(count);
return columnVO;
}).collect(Collectors.toList());
return R.success().add("page", formatPage(columnIPage, columnVOS));
}
Aggregations