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

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: FormServiceImpl.java From spring-cloud-shop with MIT License

6 votes

@Override
public Response<List<FormResponse>> queryPage(FormPageRequest request) {

    LambdaQueryWrapper<Form> wrapper = new LambdaQueryWrapper<Form>()
            .eq(Form::getDeleteStatus, Boolean.FALSE);

    if (Objects.nonNull(request.getId())) {
        wrapper.eq(Form::getId, request.getId());
    }

    if (StringUtils.isNotBlank(request.getBizType())) {
        wrapper.eq(Form::getBizType, request.getBizType());
    }

    if (StringUtils.isNotBlank(request.getName())) {
        wrapper.likeRight(Form::getName, request.getName());
    }

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

    return Response.toResponse(page.getData().stream().map(this::convert).collect(Collectors.toList()),
            page.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: GoodsPropertyServiceImpl.java From spring-cloud-shop with MIT License

6 votes

@Override
public Response<List<GoodsPropertyResponse>> queryPage(GoodsPropertyPageRequest request) {

    LambdaQueryWrapper<GoodsProperty> wrapper = new LambdaQueryWrapper<>();
    wrapper.eq(GoodsProperty::getDeleteStatus, Boolean.FALSE);

    if (StringUtils.isNotBlank(request.getPropertyName())) {
        wrapper.likeRight(GoodsProperty::getPropertyName, request.getPropertyName());
    }

    if (Objects.nonNull(request.getPropertyGroupId())) {
        wrapper.eq(GoodsProperty::getPropertyGroupId, request.getPropertyGroupId());
    }

    wrapper.orderByDesc(GoodsProperty::getUpdateTime);

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

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

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

6 votes

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

    if (StringUtils.isNotBlank(request.getClassName())) {
        wrapper.likeRight(GoodsClass::getClassName, request.getClassName());
    }

    Response<List<GoodsClass>> 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<ExchangeActivityRecordResponse>> record(ExchangeActivityRecordPageRequest request) {
    LambdaQueryWrapper<ExchangeActivityMember> wrapper = new LambdaQueryWrapper<>();
    wrapper.eq(ExchangeActivityMember::getDeleteStatus, Boolean.FALSE);
    wrapper.eq(ExchangeActivityMember::getActivityId, request.getActivityId());

    if (StringUtils.isNotBlank(request.getPhone())) {
        wrapper.likeRight(ExchangeActivityMember::getPhone, request.getPhone());
    }

    if (Objects.isNull(request.getRuleId())) {
        wrapper.eq(ExchangeActivityMember::getRuleId, request.getRuleId());
    }

    List<ExchangeActivityRecordResponse> responseList = Collections.emptyList();
    int count = exchangeActivityMembersMapper.selectCount(wrapper);
    if (0 < count) {
        Page<ExchangeActivityMember> page = new Page<>(request.getPage(), request.getPageSize());
        List<ExchangeActivityMember> records = exchangeActivityMembersMapper.selectPage(page, wrapper).getRecords();
        responseList = records.stream().map(this::convert).collect(Collectors.toList());
    }
    return Response.toResponse(responseList, count);
}

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

6 votes

/**
 * [列表页面]加载分类字典数据 用于值的替换
 * @param code
 * @return
 */
@RequestMapping(value = "/loadAllData", method = RequestMethod.GET)
public Result<List<DictModel>> loadAllData(@RequestParam(name="code",required = true) String code) {
 Result<List<DictModel>> result = new Result<List<DictModel>>();
 LambdaQueryWrapper<SysCategory> query = new LambdaQueryWrapper<SysCategory>();
 if(oConvertUtils.isNotEmpty(code) && !"0".equals(code)){
	 query.likeRight(SysCategory::getCode,code);
 }
 List<SysCategory> list = this.sysCategoryService.list(query);
 if(list==null || list.size()==0) {
	 result.setMessage("无数据,参数有误.[code]");
	 result.setSuccess(false);
	 return result;
 }
 List<DictModel> rdList = new ArrayList<DictModel>();
 for (SysCategory c : list) {
	 rdList.add(new DictModel(c.getId(),c.getName()));
 }
 result.setSuccess(true);
 result.setResult(rdList);
 return result;
}

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: CouponTemplateServiceImpl.java From spring-cloud-shop with MIT License

6 votes

@Override
public Response<List<DiscountCouponTemplate>> queryPage(DiscountCouponTemplatePageRequest request) {

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

    if (!StringUtils.isEmpty(request.getTemplateName())) {
        qw.likeRight(DiscountCouponTemplate::getTemplateName, request.getTemplateName());
    }

    if (null != request.getTemplateType()) {
        qw.eq(DiscountCouponTemplate::getTemplateType, request.getTemplateType());
    }

    qw.orderByDesc(DiscountCouponTemplate::getUpdateTime);

    return this.toPage(request.getPage(), request.getPageSize(), qw);
}

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

6 votes

private LambdaQueryWrapper<Banner> toQuery(String title, String bannerType, Boolean bannerStatus) {
    LambdaQueryWrapper<Banner> wrapper = new LambdaQueryWrapper<>();

    if (StringUtils.isNotEmpty(title)) {
        wrapper.likeRight(Banner::getTitle, title);
    }
    if (!StringUtils.isEmpty(bannerType)) {
        wrapper.eq(Banner::getBannerType, bannerType);
    }

    if (Objects.nonNull(bannerStatus)) {
        wrapper.eq(Banner::getBannerStatus, bannerStatus);
    }

    wrapper.orderByDesc(Banner::getUpdateTime);

    return wrapper;
}

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

6 votes

@Override
public Response<List<SystemConfigDetailResponse>> queryList(SystemConfigDetailOtherRequest request) {
    LambdaQueryWrapper<SystemConfigDetail> wrapper = new LambdaQueryWrapper<>();

    wrapper.eq(SystemConfigDetail::getDeleteStatus, Boolean.FALSE);

    if (StringUtils.isNotBlank(request.getConfigName())) {
        wrapper.likeRight(SystemConfigDetail::getConfigName, request.getConfigName());
    }
    if (StringUtils.isNotBlank(request.getConfigType())) {
        wrapper.eq(SystemConfigDetail::getConfigType, request.getConfigType());
    }
    if (StringUtils.isNotBlank(request.getConfigKey())) {
        wrapper.eq(SystemConfigDetail::getConfigKey, request.getConfigKey());
    }

    return new Response<>(this.baseMapper.selectList(wrapper).stream().map(this::convert).collect(Collectors.toList()));
}

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

6 votes

/**
 * [列表页面]加载分类字典数据 用于值的替换
 * @param code
 * @return
 */
@RequestMapping(value = "/loadAllData", method = RequestMethod.GET)
public Result<List<DictModel>> loadAllData(@RequestParam(name="code",required = true) String code) {
 Result<List<DictModel>> result = new Result<List<DictModel>>();
 LambdaQueryWrapper<SysCategory> query = new LambdaQueryWrapper<SysCategory>();
 if(oConvertUtils.isNotEmpty(code) && !"0".equals(code)){
	 query.likeRight(SysCategory::getCode,code);
 }
 List<SysCategory> list = this.sysCategoryService.list(query);
 if(list==null || list.size()==0) {
	 result.setMessage("无数据,参数有误.[code]");
	 result.setSuccess(false);
	 return result;
 }
 List<DictModel> rdList = new ArrayList<DictModel>();
 for (SysCategory c : list) {
	 rdList.add(new DictModel(c.getId(),c.getName()));
 }
 result.setSuccess(true);
 result.setResult(rdList);
 return result;
}

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

5 votes

/**
 * 根据部门code，查询当前部门和下级部门的 用户信息
 */
@Override
public List<SysUser> queryUserByDepCode(String depCode,String realname) {
	LambdaQueryWrapper<SysDepart> queryByDepCode = new LambdaQueryWrapper<SysDepart>();
	queryByDepCode.likeRight(SysDepart::getOrgCode,depCode);
	List<SysDepart> sysDepartList = sysDepartService.list(queryByDepCode);
	List<String> depIds = sysDepartList.stream().map(SysDepart::getId).collect(Collectors.toList());

	LambdaQueryWrapper<SysUserDepart> queryUDep = new LambdaQueryWrapper<SysUserDepart>();
	queryUDep.in(SysUserDepart::getDepId, depIds);
	List<String> userIdList = new ArrayList<>();
	List<SysUserDepart> uDepList = this.list(queryUDep);
	if(uDepList != null && uDepList.size() > 0) {
		for(SysUserDepart uDep : uDepList) {
			userIdList.add(uDep.getUserId());
		}
		LambdaQueryWrapper<SysUser> queryUser = new LambdaQueryWrapper<SysUser>();
		queryUser.in(SysUser::getId,userIdList);
		if(oConvertUtils.isNotEmpty(realname)){
			queryUser.like(SysUser::getRealname,realname.trim());
		}
		List<SysUser> userList = (List<SysUser>) sysUserService.list(queryUser);
		//update-begin-author:taoyan date:201905047 for:接口调用查询返回结果不能返回密码相关信息
		for (SysUser sysUser : userList) {
			sysUser.setSalt("");
			sysUser.setPassword("");
		}
		//update-end-author:taoyan date:201905047 for:接口调用查询返回结果不能返回密码相关信息
		return userList;
	}
	return new ArrayList<SysUser>();
}

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

5 votes

@Override
public Response<List<MenuResponse>> queryList(MenuOtherParam param) {

    LambdaQueryWrapper<Menu> wrapper = new LambdaQueryWrapper<>();
    wrapper.eq(Menu::getDeleteStatus, Boolean.FALSE);
    if (StringUtils.isNotBlank(param.getName())) {
        wrapper.likeRight(Menu::getName, param.getName());
    }
    if (Objects.nonNull(param.getMenuType())) {
        wrapper.eq(Menu::getMenuType, param.getMenuType());
    }
    wrapper.orderByAsc(Menu::getSequence);
    List<Menu> menus = this.baseMapper.selectList(wrapper);
    List<MenuResponse> parentResp = Optional.ofNullable(menus).orElse(Collections.emptyList()).stream()
            .filter(item -> Objects.isNull(item.getParentId()))
            .map(this::conv)
            .collect(Collectors.toList());
    Map<Long, List<MenuResponse>> childrenMap = Optional.ofNullable(menus).orElse(Collections.emptyList()).stream()
            .filter(item -> Objects.nonNull(item.getParentId()))
            .map(this::conv)
            .collect(Collectors.groupingBy(MenuResponse::getParentId, Collectors.toList()));

    // 数据转换
    toTree(parentResp, childrenMap);

    return Response.toResponse(parentResp, 0L);
}

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

5 votes

@Override
public Response<List<GoodsSkuResponse>> queryPage(GoodsSkuPageRequest request) {
    LambdaQueryWrapper<GoodsSku> qw = new LambdaQueryWrapper<>();
    qw.eq(GoodsSku::getDeleteStatus, Boolean.FALSE);

    if (StringUtils.isNotBlank(request.getSkuName())) {
        qw.likeRight(GoodsSku::getSkuName, request.getSkuName());
    }

    if (StringUtils.isNotBlank(request.getSkuCode())) {
        qw.eq(GoodsSku::getSkuCode, request.getSkuCode());
    }

    if (Objects.nonNull(request.getInventory())) {
        qw.eq(GoodsSku::getInventory, request.getInventory());
    }

    if (Objects.nonNull(request.getDefaultSku())) {
        qw.eq(GoodsSku::getDefaultSku, request.getDefaultSku());
    }

    qw.orderByDesc(GoodsSku::getUpdateTime);

    Response<List<GoodsSku>> page = this.toPage(request.getPage(), request.getPageSize(), qw);
    return Response.toResponse(page.getData().stream().map(this::convert).collect(Collectors.toList())
            , page.getTotal());
}

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

5 votes

@Override
public Response<List<RoleResponse>> queryPage(RolePageParam param) {
    LambdaQueryWrapper<Role> wrapper = new LambdaQueryWrapper<>();
    wrapper.eq(Role::getDeleteStatus, Boolean.FALSE);

    if (StringUtils.isNotBlank(param.getRoleName())) {
        wrapper.likeRight(Role::getRoleName, param.getRoleName());
    }

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

    return Response.toResponse(Optional.ofNullable(response.getData()).orElse(Collections.emptyList()).stream()
                    .map(item -> BeanCopier.create(item, new RoleResponse()).copy()).collect(Collectors.toList())
            , response.getTotal());
}

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

5 votes

/**
 * 组织查询
 *
 * @param configName 配置项名称
 * @param configType 配置类型
 */
private LambdaQueryWrapper<SystemConfig> toQueryWrapper(String configName, String configType) {
    LambdaQueryWrapper<SystemConfig> wrapper = new LambdaQueryWrapper<>();
    wrapper.eq(SystemConfig::getDeleteStatus, Boolean.FALSE);

    if (StringUtils.isNotBlank(configName)) {
        wrapper.likeRight(SystemConfig::getConfigName, configName);
    }
    if (StringUtils.isNotBlank(configType)) {
        wrapper.eq(SystemConfig::getConfigType, configType);
    }
    return wrapper;
}

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

5 votes

/**
 * 根据部门code，查询当前部门和下级部门的 用户信息
 */
@Override
public List<SysUser> queryUserByDepCode(String depCode,String realname) {
	LambdaQueryWrapper<SysDepart> queryByDepCode = new LambdaQueryWrapper<SysDepart>();
	queryByDepCode.likeRight(SysDepart::getOrgCode,depCode);
	List<SysDepart> sysDepartList = sysDepartService.list(queryByDepCode);
	List<String> depIds = sysDepartList.stream().map(SysDepart::getId).collect(Collectors.toList());

	LambdaQueryWrapper<SysUserDepart> queryUDep = new LambdaQueryWrapper<SysUserDepart>();
	queryUDep.in(SysUserDepart::getDepId, depIds);
	List<String> userIdList = new ArrayList<>();
	List<SysUserDepart> uDepList = this.list(queryUDep);
	if(uDepList != null && uDepList.size() > 0) {
		for(SysUserDepart uDep : uDepList) {
			userIdList.add(uDep.getUserId());
		}
		LambdaQueryWrapper<SysUser> queryUser = new LambdaQueryWrapper<SysUser>();
		queryUser.in(SysUser::getId,userIdList);
		if(oConvertUtils.isNotEmpty(realname)){
			queryUser.like(SysUser::getRealname,realname.trim());
		}
		List<SysUser> userList = (List<SysUser>) sysUserService.list(queryUser);
		//update-begin-author:taoyan date:201905047 for:接口调用查询返回结果不能返回密码相关信息
		for (SysUser sysUser : userList) {
			sysUser.setSalt("");
			sysUser.setPassword("");
		}
		//update-end-author:taoyan date:201905047 for:接口调用查询返回结果不能返回密码相关信息
		return userList;
	}
	return new ArrayList<SysUser>();
}

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

4 votes

@Override
public Response<List<GoodsPropertyGroupResponse>> queryPage(GoodsPropertyGroupPageRequest request) {

    LambdaQueryWrapper<GoodsPropertyGroup> wrapper = new LambdaQueryWrapper<>();
    wrapper.eq(GoodsPropertyGroup::getDeleteStatus, Boolean.FALSE);

    if (StringUtils.isNotBlank(request.getPropertyGroupName())) {
        wrapper.likeRight(GoodsPropertyGroup::getPropertyGroupName, request.getPropertyGroupName());
    }

    wrapper.orderByDesc(GoodsPropertyGroup::getUpdateTime);

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

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

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

4 votes

@Override
public Response<List<GoodsPropertyGroupResponse>> queryList(GoodsPropertyGroupOtherRequest request) {

    LambdaQueryWrapper<GoodsPropertyGroup> wrapper = new LambdaQueryWrapper<>();
    wrapper.eq(GoodsPropertyGroup::getDeleteStatus, Boolean.FALSE);

    if (StringUtils.isNotBlank(request.getPropertyGroupName())) {
        wrapper.likeRight(GoodsPropertyGroup::getPropertyGroupName, request.getPropertyGroupName());
    }

    wrapper.orderByDesc(GoodsPropertyGroup::getUpdateTime);

    List<GoodsPropertyGroup> goodsPropertyGroups = this.baseMapper.selectList(wrapper);

    return Response.toResponse(goodsPropertyGroups.stream().map(this::convert).collect(Collectors.toList()), 0L);
}

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