一、前端实现

1、参考 views/tree/index.vue

2、创建api

api/edu/subject.js

  1. import request from '@/utils/request'
  2. const api_name = '/admin/edu/subject'
  3. export default {
  4. getNestedTreeList() {
  5. return request({
  6. url: `${api_name}`,
  7. method: 'get'
  8. })
  9. }
  10. }

3、list.vue

  1. <template>
  2. <div class="app-container">
  3. <el-input v-model="filterText" placeholder="Filter keyword" style="margin-bottom:30px;" />
  4. <el-tree
  5. ref="subjectTree"
  6. :data="subjectList"
  7. :props="defaultProps"
  8. :filter-node-method="filterNode"
  9. class="filter-tree"
  10. default-expand-all
  11. />
  12. </div>
  13. </template>
  14. <script>
  15. import subject from '@/api/edu/subject'
  16. export default {
  17. data() {
  18. return {
  19. filterText: '',
  20. subjectList: [],
  21. defaultProps: {
  22. children: 'children',
  23. label: 'title'
  24. }
  25. }
  26. },
  27. watch: {
  28. filterText(val) {
  29. this.$refs.subjectTree.filter(val)
  30. }
  31. },
  32. created() {
  33. this.fetchNodeList()
  34. },
  35. methods: {
  36. fetchNodeList() {
  37. subject.getNestedTreeList().then(response => {
  38. if (response.success === true) {
  39. this.subjectList = response.data.items
  40. }
  41. })
  42. },
  43. filterNode(value, data) {
  44. if (!value) return true
  45. return data.title.indexOf(value) !== -1
  46. }
  47. }
  48. }
  49. </script>

二、后端实现

1、创建vo

  1. package com.guli.edu.vo;
  2. @Data
  3. public class SubjectVo {
  4. private String id;
  5. private String title;
  6. }
  1. package com.guli.edu.vo;
  2. @Data
  3. public class SubjectNestedVo {
  4. private String id;
  5. private String title;
  6. private List<SubjectVo> children = new ArrayList<>();
  7. }

2、创建controller

  1. @ApiOperation(value = "嵌套数据列表")
  2. @GetMapping("")
  3. public R nestedList(){
  4. List<SubjectNestedVo> subjectNestedVoList = subjectService.nestedList();
  5. return R.ok().data("items", subjectNestedVoList);
  6. }

3、创建service

接口

  1. List<SubjectNestedVo> nestedList();

实现Final

  1. @Override
  2. public List<SubjectNestedVo> nestedList() {
  3. //最终要的到的数据列表
  4. ArrayList<SubjectNestedVo> subjectNestedVoArrayList = new ArrayList<>();
  5. //获取一级分类数据记录
  6. QueryWrapper<Subject> queryWrapper = new QueryWrapper<>();
  7. queryWrapper.eq("parent_id", 0);
  8. queryWrapper.orderByAsc("sort", "id");
  9. List<Subject> subjects = baseMapper.selectList(queryWrapper);
  10. //获取二级分类数据记录
  11. QueryWrapper<Subject> queryWrapper2 = new QueryWrapper<>();
  12. queryWrapper2.ne("parent_id", 0);
  13. queryWrapper2.orderByAsc("sort", "id");
  14. List<Subject> subSubjects = baseMapper.selectList(queryWrapper2);
  15. //填充一级分类vo数据
  16. int count = subjects.size();
  17. for (int i = 0; i < count; i++) {
  18. Subject subject = subjects.get(i);
  19. //创建一级类别vo对象
  20. SubjectNestedVo subjectNestedVo = new SubjectNestedVo();
  21. BeanUtils.copyProperties(subject, subjectNestedVo);
  22. subjectNestedVoArrayList.add(subjectNestedVo);
  23. //填充二级分类vo数据
  24. ArrayList<SubjectVo> subjectVoArrayList = new ArrayList<>();
  25. int count2 = subSubjects.size();
  26. for (int j = 0; j < count2; j++) {
  27. Subject subSubject = subSubjects.get(j);
  28. if(subject.getId().equals(subSubject.getParentId())){
  29. //创建二级类别vo对象
  30. SubjectVo subjectVo = new SubjectVo();
  31. BeanUtils.copyProperties(subSubject, subjectVo);
  32. subjectVoArrayList.add(subjectVo);
  33. }
  34. }
  35. subjectNestedVo.setChildren(subjectVoArrayList);
  36. }
  37. return subjectNestedVoArrayList;
  38. }

三、优化前端过滤功能

  1. filterNode(value, data) {
  2. if (!value) return true
  3. return data.title.toLowerCase().indexOf(value.toLowerCase()) !== -1
  4. }