django的model中多个分割字段转为tree_json‘name‘‘children

文章描述了一个使用Django框架中的models类来定义的数据库结构,包括字段如CharField和ForeignKey,以及创建了一个自定义方法department_call_back用于构建部门层级树。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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
        

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值