实现这样一个效果,左边点击三级分类右边表格内查询出该三级分类关联的属性分组
1.controller层代码
@RequestMapping("/list/{catelogId}")
public R list(@RequestParam Map<String, Object> params,@PathVariable("catelogId") Long catelogId){
// PageUtils page = attrGroupService.queryPage(params);
PageUtils page = attrGroupService.queryPage(params,catelogId);
return R.ok().put("page", page);
}
2.service层代码
@Override
public PageUtils queryPage(Map<String, Object> params, Long catelogId) {
if(catelogId == 0){
String key = (String) params.get("key");
QueryWrapper<AttrGroupEntity> queryWrapper = new QueryWrapper<AttrGroupEntity>();
if(StringUtils.isNotEmpty(key)){
queryWrapper.and((obj) ->{
obj.eq("attr_group_id",key).or().like("attr_group_name",key);
});
}
IPage<AttrGroupEntity> page = this.page(
new Query<AttrGroupEntity>().getPage(params),
queryWrapper
);
return new PageUtils(page);
}else{
String key = (String) params.get("key");
QueryWrapper<AttrGroupEntity> queryWrapper = new QueryWrapper<AttrGroupEntity>().eq("catelog_id", catelogId);
if(StringUtils.isNotEmpty(key)){
queryWrapper.and((obj) ->{
obj.eq("attr_group_id",key).or().like("attr_group_name",key);
});
}
IPage<AttrGroupEntity> page = this.page(
new Query<AttrGroupEntity>().getPage(params),queryWrapper
);
return new PageUtils(page);
}
}
3.前端代码