models
class Department(models.Model):
serial_number = models.CharField(max_length=100,blank=True,null=True, verbose_name="序号")
name = models.CharField(max_length=100,blank=True,null=True, verbose_name="名称",unique=True)
name_0 = models.CharField(max_length=100,blank=True,null=True, default='河南营',verbose_name="名称_0")
name_1 = models.CharField(max_length=100,blank=True,null=True,default='',verbose_name="名称_1")
name_2 = models.CharField(max_length=100,blank=True,null=True,default='',verbose_name="名称_2")
name_3 = models.CharField(max_length=100,blank=True,null=True,default='',verbose_name="名称_3")
name_4 = models.CharField(max_length=100,blank=True,null=True,default='',verbose_name="名称_4")
name_5 = models.CharField(max_length=100,blank=True,null=True,default='',verbose_name="名称_5")
name_6 = models.CharField(max_length=100,blank=True,null=True,default='',verbose_name="名称_6")
name_7 = models.CharField(max_length=100,blank=True,null=True,default='',verbose_name="名称_7")
short_name = models.CharField(max_length=100,blank=True,null=True, verbose_name="简称")
content = models.CharField(max_length=1000,blank=True,null=True, verbose_name="职责")
remember = models.CharField(max_length=1000,blank=True,null=True, verbose_name="成员")
parent_name = models.CharField(max_length=100,blank=True,null=True, verbose_name="上级名称")
main_position_num = models.CharField(max_length=100,blank=True,null=True, verbose_name="正职职数")
deputy_position_num = models.CharField(max_length=100,blank=True,null=True, verbose_name="副职职数")
member_position_num = models.SmallIntegerField(default=0,blank=True,null=True, verbose_name="岗位职数")
file_company = models.CharField(max_length=100,blank=True,null=True, verbose_name="发文单位")
priority = models.CharField(max_length=20,blank=True,null=True,verbose_name='优先级')
remark = models.TextField(max_length=1000,blank=True,null=True,default="",verbose_name='备注')
parent = models.ForeignKey(to='self',blank=True,null=True,db_constraint=False,on_delete=models.SET_NULL,verbose_name='上级')
leaf = models.SmallIntegerField(default=1,verbose_name='叶子')
views
def department_call_back():
objs = models.Department.objects.exclude(name__contains='相关')[0:]
root = {'name':'河南','id':170,'children':[]}
for obj_1 in objs:
index_1 = 0
if len(obj_1.name_1)>0 and obj_1.id != 170:
children_1_name_list = [f['name'] for f in root['children']]
if obj_1.name_1 not in children_1_name_list:
root['children'].append({'name':obj_1.name_1,'id':obj_1.id,'children':[]})
children_1_name_list = [f['name'] for f in root['children']]
for obj_2 in objs:
if len(obj_2.name_2)>0:
index_1 = children_1_name_list.index(obj_2.name_1)
children_2_name_list = [f['name'] for f in root['children'][index_1]['children']]
if obj_2.name_2 not in children_2_name_list:
root['children'][index_1]['children'].append({'name':obj_2.name_2,'id':obj_2.id,'children':[]})
children_2_name_list = [f['name'] for f in root['children'][index_1]['children']]
for obj_3 in objs:
if len(obj_3.name_3)>0 and obj_3.name_2 == obj_2.name_2 and obj_3.name_1 == obj_2.name_1:
index_2 = children_2_name_list.index(obj_3.name_2)
children_3_name_list = [f['name'] for f in root['children'][index_1]['children'][index_2]['children']]
if len(obj_3.name_3)>0 and (obj_3.name_3 not in children_3_name_list):
root['children'][index_1]['children'][index_2]['children'].append({'name':obj_3.name_3,'id':obj_3.id,'children':[]})
children_3_name_list = [f['name'] for f in root['children'][index_1]['children'][index_2]['children']]
for obj_4 in objs:
if len(obj_4.name_3)>0 and obj_4.name_3 == obj_3.name_3 and obj_4.name_2 == obj_3.name_2 and obj_4.name_1 == obj_3.name_1:
index_3 = children_3_name_list.index(obj_4.name_3)
children_4_name_list = [f['name'] for f in root['children'][index_1]['children'][index_2]['children'][index_3]['children']]
if len(obj_4.name_4)>0 and (obj_4.name_4 not in children_4_name_list):
root['children'][index_1]['children'][index_2]['children'][index_3]['children'].append({'name':obj_4.name_4,'id':obj_4.id,'children':[]})
children_4_name_list = [f['name'] for f in root['children'][index_1]['children'][index_2]['children'][index_3]['children']]
for obj_5 in objs:
if len(obj_5.name_4)>0 and obj_5.name_4 == obj_4.name_4 and obj_5.name_3 == obj_4.name_3 and obj_5.name_2 == obj_4.name_2 and obj_5.name_1 == obj_4.name_1:
index_4 = children_4_name_list.index(obj_5.name_4)
children_5_name_list = [f['name'] for f in root['children'][index_1]['children'][index_2]['children'][index_3]['children'][index_4]['children']]
if len(obj_5.name_5)>0 and (obj_5.name_5 not in children_5_name_list):
root['children'][index_1]['children'][index_2]['children'][index_3]['children'][index_4]['children'].append({'name':obj_5.name_5,'id':obj_5.id,'children':[]})
children_5_name_list = [f['name'] for f in root['children'][index_1]['children'][index_2]['children'][index_3]['children'][index_4]['children']]
for obj_6 in objs:
if len(obj_6.name_5)>0 and obj_6.name_5 == obj_5.name_5 and obj_6.name_4 == obj_5.name_4 and obj_6.name_3 == obj_5.name_3 and obj_6.name_2 == obj_5.name_2 and obj_6.name_1 == obj_5.name_1:
index_5 = children_5_name_list.index(obj_6.name_5)
children_6_name_list = [f['name'] for f in root['children'][index_1]['children'][index_2]['children'][index_3]['children'][index_4]['children'][index_5]['children']]
if len(obj_6.name_6)>0 and (obj_6.name_6 not in children_6_name_list):
root['children'][index_1]['children'][index_2]['children'][index_3]['children'][index_4]['children'][index_5]['children'].append({'name':obj_6.name_6,'id':obj_6.id,'children':[]})
return root