com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper#ge

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());
}

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());
}

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());
}

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());
}

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());
}

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;
}

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;
}

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;
}

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;
}

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