自关联 递归

无限极自关联递归就是用自己关联自己的方法 无限极的一直关联下去

1.model:

1
2
3
4
5
6
class WorkOrder(models.Model):
name = models.CharField(max_length=200)
pid = models.ForeignKey('self', models.SET_NULL, null=True, blank=True, verbose_name='自关联')

def __str__(self):
return self.name

2.树:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
def xTree(datas):
lists = [] # 定义空列表
tree = {} # 定义空字典
for i in datas:
item = i
tree[item['id']] = item

for i in datas:
obj = i
if not obj['pid']:
root = tree[obj['id']]
lists.append(root)
else:
parent_id = obj['pid']
if 'children' not in tree[parent_id]:
tree[parent_id]['children'] = []
tree[parent_id]['children'].append(tree[obj['id']])
return lists

3.查询代码:

1
2
3
4
5
def get(self, request):
cai = WorkOrder.objects.all()
ser = WorkOrderSerializer(cai, many=True)
data = xTree(ser.data)
return Response(data)

4.vue用父子组件传参实现渲染:

子页面负责循环:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<template>
<div>
<li>
<a :href="'/cate/?id='+data.id">{{data.name}}</a>
<ul v-if="data.children && data.children.length > 0">
<antwork v-for="child in data.children" :key="child.id" :data='child' />
</ul>
</li>
</div>
</template>

<script>
export default {
name:"antwork",
props:['data'],
}
</script>

<style>
ul{
padding-left: 20px;
list-style: none;
}
</style>

5.父页面负责渲染:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
<template>
<div>
<antwork :data="data" />
<br>
<select v-model="pid">
<option v-model="pid" :value="0">主</option>
<option v-for="i in nr" :value="i.id" :key="i.id">{{i.name}}</option>
</select>
</div>
</template>

<script>
import axios from 'axios'
import antwork from "./antwork"

export default {
data() {
return {
data:{},
nr:[],
pid:'',
}
},
components:{
antwork,
},
created() {
this.get_data()
axios({
url:"http://127.0.0.1:8000/app2/work/"
}).then(res =>{
this.nr = res.data
})
},
methods: {
get_data:function(){
axios.get("http://127.0.0.1:8000/app2/workorder/").then(res=>{
console.log(res.data);
var mytree = {"id":0,name:""};
mytree['children'] = res.data;
this.data = mytree
})
},
},
}
</script>
<style>

</style>