Search in sources :

Example 11 with IPage

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);
}
Also used : ResultVO(shu.java.csky.vo.ResultVO) QueryWrapper(com.baomidou.mybatisplus.core.conditions.query.QueryWrapper) SchoolPageVo(shu.java.csky.vo.page.SchoolPageVo) ArrayList(java.util.ArrayList) Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) IPage(com.baomidou.mybatisplus.core.metadata.IPage) School(shu.java.csky.entity.School) Search(shu.java.csky.entity.Search) SchoolVo(shu.java.csky.vo.SchoolVo)

Example 12 with IPage

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);
}
Also used : ResultVO(shu.java.csky.vo.ResultVO) TeacherPageParam(shu.java.csky.vo.param.TeacherPageParam) QueryWrapper(com.baomidou.mybatisplus.core.conditions.query.QueryWrapper) TeacherVo(shu.java.csky.vo.TeacherVo) SearchMapper(shu.java.csky.dao.SearchMapper) Resource(javax.annotation.Resource) ResultVO(shu.java.csky.vo.ResultVO) TeacherService(shu.java.csky.TeacherService) Search(shu.java.csky.entity.Search) TeachersMapper(shu.java.csky.dao.TeachersMapper) ArrayList(java.util.ArrayList) Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) Teachers(shu.java.csky.entity.Teachers) ResStatus(shu.java.csky.vo.ResStatus) List(java.util.List) TeacherPageVo(shu.java.csky.vo.page.TeacherPageVo) Service(org.springframework.stereotype.Service) IPage(com.baomidou.mybatisplus.core.metadata.IPage) BeanUtils(org.springframework.beans.BeanUtils) QueryWrapper(com.baomidou.mybatisplus.core.conditions.query.QueryWrapper) ArrayList(java.util.ArrayList) Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) IPage(com.baomidou.mybatisplus.core.metadata.IPage) Teachers(shu.java.csky.entity.Teachers) Search(shu.java.csky.entity.Search) TeacherVo(shu.java.csky.vo.TeacherVo) TeacherPageVo(shu.java.csky.vo.page.TeacherPageVo)

Example 13 with IPage

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;
}
Also used : LoadTask(com.baidu.hugegraph.entity.load.LoadTask) JobStatus(com.baidu.hugegraph.entity.enums.JobStatus) Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) IPage(com.baomidou.mybatisplus.core.metadata.IPage) JobManager(com.baidu.hugegraph.entity.load.JobManager) Date(java.util.Date)

Example 14 with IPage

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));
}
Also used : TenantInfo(cn.hippo4j.config.model.TenantInfo) Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) IPage(com.baomidou.mybatisplus.core.metadata.IPage) TenantRespDTO(cn.hippo4j.config.model.biz.tenant.TenantRespDTO)

Example 15 with IPage

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));
}
Also used : QueryWrapper(com.baomidou.mybatisplus.core.conditions.query.QueryWrapper) Validated(org.springframework.validation.annotation.Validated) BeanUtils(org.apache.commons.beanutils.BeanUtils) Date(java.util.Date) R(com.wayn.common.util.R) Autowired(org.springframework.beans.factory.annotation.Autowired) IColumnService(com.wayn.common.core.service.shop.IColumnService) Collectors(java.util.stream.Collectors) Column(com.wayn.common.core.domain.shop.Column) Goods(com.wayn.common.core.domain.shop.Goods) CollectionUtils(org.apache.commons.collections4.CollectionUtils) InvocationTargetException(java.lang.reflect.InvocationTargetException) BaseController(com.wayn.common.base.controller.BaseController) ColumnVO(com.wayn.common.core.domain.vo.ColumnVO) Page(com.baomidou.mybatisplus.extension.plugins.pagination.Page) Slf4j(lombok.extern.slf4j.Slf4j) List(java.util.List) ColumnGoodsRelation(com.wayn.common.core.domain.shop.ColumnGoodsRelation) IColumnGoodsRelationService(com.wayn.common.core.service.shop.IColumnGoodsRelationService) org.springframework.web.bind.annotation(org.springframework.web.bind.annotation) IGoodsService(com.wayn.common.core.service.shop.IGoodsService) IPage(com.baomidou.mybatisplus.core.metadata.IPage) Column(com.wayn.common.core.domain.shop.Column) ColumnVO(com.wayn.common.core.domain.vo.ColumnVO)

Aggregations

IPage (com.baomidou.mybatisplus.core.metadata.IPage)197 Page (com.baomidou.mybatisplus.extension.plugins.pagination.Page)152 QueryWrapper (com.baomidou.mybatisplus.core.conditions.query.QueryWrapper)73 ApiOperation (io.swagger.annotations.ApiOperation)28 ArrayList (java.util.ArrayList)21 Test (org.junit.Test)20 PageDTO (com.baomidou.mybatisplus.extension.plugins.pagination.PageDTO)19 SpringBootTest (org.springframework.boot.test.context.SpringBootTest)18 LoginUser (org.jeecg.common.system.vo.LoginUser)16 JSONObject (com.alibaba.fastjson.JSONObject)15 RequiresPermissions (org.apache.shiro.authz.annotation.RequiresPermissions)15 PageInfo (org.apache.dolphinscheduler.api.utils.PageInfo)13 LambdaQueryWrapper (com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper)11 Result (org.jeecg.common.api.vo.Result)10 List (java.util.List)9 User (org.apache.dolphinscheduler.dao.entity.User)9 Field (java.lang.reflect.Field)8 Date (java.util.Date)8 Collectors (java.util.stream.Collectors)7 UserRolesVo (top.hcode.hoj.pojo.vo.UserRolesVo)7