Java Code Examples for com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper#ge()

The following examples show how to use com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper#ge() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: AssembleServiceImpl.java From spring-cloud-shop with MIT License

6 votes

@Override
public Response<List<AssembleActivityResponse>> queryPage(AssemblePageRequest request) {

    LambdaQueryWrapper<AssembleActivity> wrapper = new LambdaQueryWrapper<>();
    if (StringUtils.isNotBlank(request.getActivityName())) {
        wrapper.likeRight(AssembleActivity::getActivityName, request.getActivityName());
    }

    if (CollectionUtils.isNotEmpty(request.getTimeRange())) {
        wrapper.le(AssembleActivity::getBeginTime, request.getTimeRange().get(0));
        wrapper.ge(AssembleActivity::getEndTime, request.getTimeRange().get(1));
    }

    wrapper.orderByDesc(AssembleActivity::getUpdateTime);

    Response<List<AssembleActivity>> response = this.toPage(request.getPage(), request.getPageSize(), wrapper);

    return Response.toResponse(Optional.ofNullable(response.getData()).orElse(Collections.emptyList()).stream()
                    .map(this::convert)
                    .collect(Collectors.toList()),
            response.getTotal());
}

Example 2

Source File: ExchangeServiceImpl.java From spring-cloud-shop with MIT License

6 votes

@Override
public Response<List<ExchangeActivityResponse>> queryPage(ExchangeActivityPageRequest request) {

    LambdaQueryWrapper<ExchangeActivity> qw = new LambdaQueryWrapper<>();

    if (StringUtils.isNotEmpty(request.getActivityName())) {
        qw.likeRight(ExchangeActivity::getActivityName, request.getActivityName());
    }

    if (CollectionUtils.isNotEmpty(request.getTimeRange())) {
        qw.le(ExchangeActivity::getBeginTime, request.getTimeRange().get(0));
        qw.ge(ExchangeActivity::getEndTime, request.getTimeRange().get(1));
    }

    Response<List<ExchangeActivity>> response = this.toPage(request.getPage(), request.getPageSize(), qw);

    return Response.toResponse(Optional.ofNullable(response.getData()).orElse(Collections.emptyList()).stream()
                    .map(this::convert)
                    .collect(Collectors.toList()),
            response.getTotal());
}

Example 3

Source File: DiscountCouponServiceImpl.java From spring-cloud-shop with MIT License

6 votes

@Override
public Response<List<DiscountCouponResponse>> queryPage(DiscountCouponPageRequest request) {

    LambdaQueryWrapper<DiscountCoupon> qw = new LambdaQueryWrapper<>();

    if (StringUtils.isNotEmpty(request.getPhone())) {
        qw.eq(DiscountCoupon::getPhone, request.getPhone());
    }
    if (CollectionUtils.isNotEmpty(request.getTimeRange())) {
        qw.ge(DiscountCoupon::getCreateTime, request.getTimeRange().get(0));
        qw.le(DiscountCoupon::getCreateTime, request.getTimeRange().get(1));
    } else {
        qw.apply("DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= create_time");
    }

    Response<List<DiscountCoupon>> response = this.toPage(request.getPage(), request.getPageSize(), qw);

    return Response.toResponse(Optional.ofNullable(response.getData()).orElse(Collections.emptyList()).stream()
                    .map(this::convert).collect(Collectors.toList()),
            response.getTotal());
}

Example 4

Source File: GoodsBrandServiceImpl.java From spring-cloud-shop with MIT License

6 votes

@Override
public Response<List<GoodsBrandResponse>> queryPage(GoodsBrandPageRequest request) {
    LambdaQueryWrapper<GoodsBrand> wrapper = new LambdaQueryWrapper<>();
    wrapper.eq(GoodsBrand::getDeleteStatus, Boolean.FALSE);

    if (StringUtils.isNotBlank(request.getBrandCode())) {
        wrapper.eq(GoodsBrand::getBrandCode, request.getBrandCode());
    }

    if (StringUtils.isNotBlank(request.getBrandName())) {
        wrapper.likeRight(GoodsBrand::getBrandName, request.getBrandName());
    }

    if (!CollectionUtils.isEmpty(request.getDateTimes())) {
        wrapper.ge(GoodsBrand::getCreateTime, request.getDateTimes().get(0));
        wrapper.le(GoodsBrand::getCreateTime, request.getDateTimes().get(1));
    }

    Response<List<GoodsBrand>> page = this.toPage(request.getPage(), request.getPageSize(), wrapper);

    return Response.toResponse(page.getData().stream().map(this::convert).collect(Collectors.toList()), page.getTotal());
}

Example 5

Source File: GoodsBrandGroupServiceImpl.java From spring-cloud-shop with MIT License

6 votes

@Override
public Response<List<GoodsBrandGroupResponse>> queryPage(GoodsBrandGroupPageRequest request) {

    LambdaQueryWrapper<GoodsBrandGroup> wrapper = new LambdaQueryWrapper<>();
    wrapper.eq(GoodsBrandGroup::getDeleteStatus, Boolean.FALSE);
    if (StringUtils.isNotBlank(request.getBrandGroupName())) {
        wrapper.likeRight(GoodsBrandGroup::getBrandGroupName, request.getBrandGroupName());
    }

    if (CollectionUtils.isNotEmpty(request.getDateTimes())) {
        wrapper.ge(GoodsBrandGroup::getUpdateTime, request.getDateTimes().get(0));
        wrapper.le(GoodsBrandGroup::getUpdateTime, request.getDateTimes().get(1));
    }

    wrapper.orderByDesc(GoodsBrandGroup::getSequence);

    Response<List<GoodsBrandGroup>> response = this.toPage(request.getPage(), request.getPageSize(), wrapper);
    return Response.toResponse(Optional.ofNullable(response.getData()).orElse(Collections.emptyList()).stream()
                    .map(this::convert)
                    .collect(Collectors.toList()),
            response.getTotal());
}

Example 6

Source File: SysAnnouncementController.java From jeecg-cloud with Apache License 2.0

5 votes

/**
 * @功能：补充用户数据，并返回系统消息
 * @return
 */
@RequestMapping(value = "/listByUser", method = RequestMethod.GET)
public Result<Map<String,Object>> listByUser() {
	Result<Map<String,Object>> result = new Result<Map<String,Object>>();
	LoginUser sysUser = (LoginUser)SecurityUtils.getSubject().getPrincipal();
	String userId = sysUser.getId();
	// 1.将系统消息补充到用户通告阅读标记表中
	Collection<String> anntIds = sysAnnouncementSendService.queryByUserId(userId);
	LambdaQueryWrapper<SysAnnouncement> querySaWrapper = new LambdaQueryWrapper<SysAnnouncement>();
	querySaWrapper.eq(SysAnnouncement::getMsgType,CommonConstant.MSG_TYPE_ALL); // 全部人员
	querySaWrapper.eq(SysAnnouncement::getDelFlag,CommonConstant.DEL_FLAG_0.toString());  // 未删除
	querySaWrapper.eq(SysAnnouncement::getSendStatus, CommonConstant.HAS_SEND); //已发布
	querySaWrapper.ge(SysAnnouncement::getEndTime, sysUser.getCreateTime()); //新注册用户不看结束通知
	if(anntIds!=null&&anntIds.size()>0) {
		querySaWrapper.notIn(SysAnnouncement::getId, anntIds);
	}
	List<SysAnnouncement> announcements = sysAnnouncementService.list(querySaWrapper);
	if(announcements.size()>0) {
		for(int i=0;i<announcements.size();i++) {
			SysAnnouncementSend announcementSend = new SysAnnouncementSend();
			announcementSend.setAnntId(announcements.get(i).getId());
			announcementSend.setUserId(userId);
			announcementSend.setReadFlag(CommonConstant.NO_READ_FLAG);
			sysAnnouncementSendService.save(announcementSend);
		}
	}
	// 2.查询用户未读的系统消息
	Page<SysAnnouncement> anntMsgList = new Page<SysAnnouncement>(0,5);
	anntMsgList = sysAnnouncementService.querySysCementPageByUserId(anntMsgList,userId,"1");//通知公告消息
	Page<SysAnnouncement> sysMsgList = new Page<SysAnnouncement>(0,5);
	sysMsgList = sysAnnouncementService.querySysCementPageByUserId(sysMsgList,userId,"2");//系统消息
	Map<String,Object> sysMsgMap = new HashMap<String, Object>();
	sysMsgMap.put("sysMsgList", sysMsgList.getRecords());
	sysMsgMap.put("sysMsgTotal", sysMsgList.getTotal());
	sysMsgMap.put("anntMsgList", anntMsgList.getRecords());
	sysMsgMap.put("anntMsgTotal", anntMsgList.getTotal());
	result.setSuccess(true);
	result.setResult(sysMsgMap);
	return result;
}

Example 7

Source File: SysAnnouncementController.java From jeecg-boot-with-activiti with MIT License

5 votes

/**
 * @功能：补充用户数据，并返回系统消息
 * @param id
 * @return
 */
@RequestMapping(value = "/listByUser", method = RequestMethod.GET)
public Result<Map<String,Object>> listByUser() {
	Result<Map<String,Object>> result = new Result<Map<String,Object>>();
	LoginUser sysUser = (LoginUser)SecurityUtils.getSubject().getPrincipal();
	String userId = sysUser.getId();
	// 1.将系统消息补充到用户通告阅读标记表中
	Collection<String> anntIds = sysAnnouncementSendService.queryByUserId(userId);
	LambdaQueryWrapper<SysAnnouncement> querySaWrapper = new LambdaQueryWrapper<SysAnnouncement>();
	querySaWrapper.eq(SysAnnouncement::getMsgType,CommonConstant.MSG_TYPE_ALL); // 全部人员
	querySaWrapper.eq(SysAnnouncement::getDelFlag,CommonConstant.DEL_FLAG_0.toString());  // 未删除
	querySaWrapper.eq(SysAnnouncement::getSendStatus, CommonConstant.HAS_SEND); //已发布
	querySaWrapper.ge(SysAnnouncement::getEndTime, sysUser.getCreateTime()); //新注册用户不看结束通知
	if(anntIds!=null&&anntIds.size()>0) {
		querySaWrapper.notIn(SysAnnouncement::getId, anntIds);
	}
	List<SysAnnouncement> announcements = sysAnnouncementService.list(querySaWrapper);
	if(announcements.size()>0) {
		for(int i=0;i<announcements.size();i++) {
			SysAnnouncementSend announcementSend = new SysAnnouncementSend();
			announcementSend.setAnntId(announcements.get(i).getId());
			announcementSend.setUserId(userId);
			announcementSend.setReadFlag(CommonConstant.NO_READ_FLAG);
			sysAnnouncementSendService.save(announcementSend);
		}
	}
	// 2.查询用户未读的系统消息
	Page<SysAnnouncement> anntMsgList = new Page<SysAnnouncement>(0,5);
	anntMsgList = sysAnnouncementService.querySysCementPageByUserId(anntMsgList,userId,"1");//通知公告消息
	Page<SysAnnouncement> sysMsgList = new Page<SysAnnouncement>(0,5);
	sysMsgList = sysAnnouncementService.querySysCementPageByUserId(sysMsgList,userId,"2");//系统消息
	Map<String,Object> sysMsgMap = new HashMap<String, Object>();
	sysMsgMap.put("sysMsgList", sysMsgList.getRecords());
	sysMsgMap.put("sysMsgTotal", sysMsgList.getTotal());
	sysMsgMap.put("anntMsgList", anntMsgList.getRecords());
	sysMsgMap.put("anntMsgTotal", anntMsgList.getTotal());
	result.setSuccess(true);
	result.setResult(sysMsgMap);
	return result;
}

Example 8

Source File: SysAnnouncementController.java From teaching with Apache License 2.0

5 votes

/**
 * @功能：补充用户数据，并返回系统消息
 * @param id
 * @return
 */
@RequestMapping(value = "/listByUser", method = RequestMethod.GET)
public Result<Map<String,Object>> listByUser() {
	Result<Map<String,Object>> result = new Result<Map<String,Object>>();
	LoginUser sysUser = (LoginUser)SecurityUtils.getSubject().getPrincipal();
	String userId = sysUser.getId();
	// 1.将系统消息补充到用户通告阅读标记表中
	Collection<String> anntIds = sysAnnouncementSendService.queryByUserId(userId);
	LambdaQueryWrapper<SysAnnouncement> querySaWrapper = new LambdaQueryWrapper<SysAnnouncement>();
	querySaWrapper.eq(SysAnnouncement::getMsgType,CommonConstant.MSG_TYPE_ALL); // 全部人员
	querySaWrapper.eq(SysAnnouncement::getDelFlag,CommonConstant.DEL_FLAG_0.toString());  // 未删除
	querySaWrapper.eq(SysAnnouncement::getSendStatus, CommonConstant.HAS_SEND); //已发布
	querySaWrapper.ge(SysAnnouncement::getEndTime, sysUser.getCreateTime()); //新注册用户不看结束通知
	if(anntIds!=null&&anntIds.size()>0) {
		querySaWrapper.notIn(SysAnnouncement::getId, anntIds);
	}
	List<SysAnnouncement> announcements = sysAnnouncementService.list(querySaWrapper);
	if(announcements.size()>0) {
		for(int i=0;i<announcements.size();i++) {
			SysAnnouncementSend announcementSend = new SysAnnouncementSend();
			announcementSend.setAnntId(announcements.get(i).getId());
			announcementSend.setUserId(userId);
			announcementSend.setReadFlag(CommonConstant.NO_READ_FLAG);
			sysAnnouncementSendService.save(announcementSend);
		}
	}
	// 2.查询用户未读的系统消息
	Page<SysAnnouncement> anntMsgList = new Page<SysAnnouncement>(0,5);
	anntMsgList = sysAnnouncementService.querySysCementPageByUserId(anntMsgList,userId,"1");//通知公告消息
	Page<SysAnnouncement> sysMsgList = new Page<SysAnnouncement>(0,5);
	sysMsgList = sysAnnouncementService.querySysCementPageByUserId(sysMsgList,userId,"2");//系统消息
	Map<String,Object> sysMsgMap = new HashMap<String, Object>();
	sysMsgMap.put("sysMsgList", sysMsgList.getRecords());
	sysMsgMap.put("sysMsgTotal", sysMsgList.getTotal());
	sysMsgMap.put("anntMsgList", anntMsgList.getRecords());
	sysMsgMap.put("anntMsgTotal", anntMsgList.getTotal());
	result.setSuccess(true);
	result.setResult(sysMsgMap);
	return result;
}

Example 9

Source File: SysAnnouncementController.java From jeecg-boot with Apache License 2.0

5 votes

/**
 * @功能：补充用户数据，并返回系统消息
 * @return
 */
@RequestMapping(value = "/listByUser", method = RequestMethod.GET)
public Result<Map<String,Object>> listByUser() {
	Result<Map<String,Object>> result = new Result<Map<String,Object>>();
	LoginUser sysUser = (LoginUser)SecurityUtils.getSubject().getPrincipal();
	String userId = sysUser.getId();
	// 1.将系统消息补充到用户通告阅读标记表中
	Collection<String> anntIds = sysAnnouncementSendService.queryByUserId(userId);
	LambdaQueryWrapper<SysAnnouncement> querySaWrapper = new LambdaQueryWrapper<SysAnnouncement>();
	querySaWrapper.eq(SysAnnouncement::getMsgType,CommonConstant.MSG_TYPE_ALL); // 全部人员
	querySaWrapper.eq(SysAnnouncement::getDelFlag,CommonConstant.DEL_FLAG_0.toString());  // 未删除
	querySaWrapper.eq(SysAnnouncement::getSendStatus, CommonConstant.HAS_SEND); //已发布
	querySaWrapper.ge(SysAnnouncement::getEndTime, sysUser.getCreateTime()); //新注册用户不看结束通知
	if(anntIds!=null&&anntIds.size()>0) {
		querySaWrapper.notIn(SysAnnouncement::getId, anntIds);
	}
	List<SysAnnouncement> announcements = sysAnnouncementService.list(querySaWrapper);
	if(announcements.size()>0) {
		for(int i=0;i<announcements.size();i++) {
			SysAnnouncementSend announcementSend = new SysAnnouncementSend();
			announcementSend.setAnntId(announcements.get(i).getId());
			announcementSend.setUserId(userId);
			announcementSend.setReadFlag(CommonConstant.NO_READ_FLAG);
			sysAnnouncementSendService.save(announcementSend);
		}
	}
	// 2.查询用户未读的系统消息
	Page<SysAnnouncement> anntMsgList = new Page<SysAnnouncement>(0,5);
	anntMsgList = sysAnnouncementService.querySysCementPageByUserId(anntMsgList,userId,"1");//通知公告消息
	Page<SysAnnouncement> sysMsgList = new Page<SysAnnouncement>(0,5);
	sysMsgList = sysAnnouncementService.querySysCementPageByUserId(sysMsgList,userId,"2");//系统消息
	Map<String,Object> sysMsgMap = new HashMap<String, Object>();
	sysMsgMap.put("sysMsgList", sysMsgList.getRecords());
	sysMsgMap.put("sysMsgTotal", sysMsgList.getTotal());
	sysMsgMap.put("anntMsgList", anntMsgList.getRecords());
	sysMsgMap.put("anntMsgTotal", anntMsgList.getTotal());
	result.setSuccess(true);
	result.setResult(sysMsgMap);
	return result;
}