django将多字段model转json的tree

已于 2023-12-04 17:37:24 修改
阅读量646 收藏 6
点赞数 8
文章标签： django json 数据库
于 2023-12-04 17:35:55 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/shaohl2103/article/details/134789880
版权

django的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='河南营销2.0',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='备注')

djangoviews

import json
from django.shortcuts import render
from .. import models

def department_call_back(result_queryset,result_dict={'name':''}):
    # 遍历对象集
    for obj in result_queryset:
        # children 为 y ,children中的列表位置为x
        # p_0 = 0
        # p_1 = 0
        # p_2 = 0
        # p_3 = 0
        # p_4 = 0
        # result_dict = {'name':'河南'}
        if (len(obj.name_1)>0 and len(obj.name_2)>0)  and 'children' not in list(result_dict.keys()):
            result_dict['children'] = [{'name':obj.name_1}]
            p_1 = 0
            # result_dict = {'name':'河南营销'，'children':[{'name':name_1}]}
        elif (len(obj.name_1)>0 and len(obj.name_2)>0) and 'children' in list(result_dict.keys()) and obj.name_1 not in [f['name'] for f in result_dict['children']]:
            result_dict['children'].append({'name':obj.name_1})
            p_1 = len(result_dict['children'])-1
        elif len(obj.name_1)>0 and len(obj.name_2) == 0 and 'children' not in list(result_dict.keys()):
            result_dict['children'] = [{'name':obj.name_1}]
            p_1 = len(result_dict['children'])-1
            continue
        elif len(obj.name_1)>0 and len(obj.name_2) == 0 and 'children' in list(result_dict.keys()):
            result_dict['children'].append({'name':obj.name_1})
            p_1 = len(result_dict['children'])-1
            continue

        if (len(obj.name_2)>0 and len(obj.name_3)>0) and 'children' not in list(result_dict['children'][p_1].keys()):
            result_dict['children'][p_1]['children'] = [{'name':obj.name_2}]
            p_2 = 0
            # result_dict = {'name':'河南营销'，'children':[{'name':name_1,'children':[{'name':'name_2'}]}]}
        elif (len(obj.name_2)>0 and len(obj.name_3)>0) and 'children' in list(result_dict['children'][p_1].keys())  and obj.name_2 not in [f['name'] for f in result_dict['children'][p_1]['children']]:
            result_dict['children'][p_1]['children'].append({'name':obj.name_2})
            p_2 = len(result_dict['children'][p_1]['children'])-1
        elif (len(obj.name_2)>0 and len(obj.name_3)==0) and 'children' not in list(result_dict['children'][p_1].keys()) :
            result_dict['children'][p_1]['children'] = [{'name':obj.name_2}]
            p_2 = len(result_dict['children'][p_1]['children'])-1
            continue
        elif (len(obj.name_2)>0 and len(obj.name_3)==0) and 'children' in list(result_dict['children'][p_1].keys()) :
            result_dict['children'][p_1]['children'].append({'name':obj.name_2})
            p_2 = len(result_dict['children'][p_1]['children'])-1
            continue

        if (len(obj.name_3)>0 and len(obj.name_4)>0)  and 'children' not in list(result_dict['children'][p_1]['children'][p_2].keys()):
            result_dict['children'][p_1]['children'][p_2]['children'] = [{'name':obj.name_3}]
            p_3 = 0
            # result_dict = {'name':'河南营销'，'children':[{'name':name_1,'children':[{'name':'name_2','children':[{'name':'name_3'}]}]}]}
        elif (len(obj.name_3)>0 and len(obj.name_4)>0)  and 'children' in list(result_dict['children'][p_1]['children'][p_2].keys()) and obj.name_3 not in [f['name'] for f in result_dict['children'][p_1]['children'][p_2]['children']]:
            result_dict['children'][p_1]['children'][p_2]['children'].append({'name':obj.name_3})
            p_3 = len(result_dict['children'][p_1]['children'][p_2]['children'])-1
        elif (len(obj.name_3)>0 and len(obj.name_4)==0) and 'children' not in list(result_dict['children'][p_1]['children'][p_2].keys()):
            result_dict['children'][p_1]['children'][p_2]['children'] = [{'name':obj.name_3}]
            p_3 = len(result_dict['children'][p_1]['children'][p_2]['children'])-1
            continue
        elif (len(obj.name_3)>0 and len(obj.name_4)==0) and 'children' in list(result_dict['children'][p_1]['children'][p_2].keys()):
            result_dict['children'][p_1]['children'][p_2]['children'].append({'name':obj.name_3})
            p_3 = len(result_dict['children'][p_1]['children'][p_2]['children'])-1
            continue

        if  (len(obj.name_4)>0 and len(obj.name_5)>0) and 'children' not in list(result_dict['children'][p_1]['children'][p_2]['children'][p_3].keys()):
            result_dict['children'][p_1]['children'][p_2]['children'][p_3]['children']  = [{'name':obj.name_4}]
            p_4 = 0
            # result_dict = {'name':'河南营销'，'children':[{'name':name_1,'children':[{'name':'name_2','children':[{'name':'name_3','children':[{'name':'name_4'}}]}]}]}
        elif  (len(obj.name_4)>0 and len(obj.name_5)>0) and 'children' in list(result_dict['children'][p_1]['children'][p_2]['children'][p_3].keys())  and obj.name_4 not in [f['name'] for f in result_dict['children'][p_1]['children'][p_2]['children'][p_3]['children']]:
            result_dict['children'][p_1]['children'][p_2]['children'][p_3]['children'].append({'name':obj.name_4})
            p_4 = len(result_dict['children'][p_1]['children'][p_2]['children'][p_3]['children'])-1
        elif  (len(obj.name_4)>0 and len(obj.name_5)==0) and 'children' not in list(result_dict['children'][p_1]['children'][p_2]['children'][p_3].keys())  :
            result_dict['children'][p_1]['children'][p_2]['children'][p_3]['children']  = [{'name':obj.name_4}]
            p_4 = len(result_dict['children'][p_1]['children'][p_2]['children'][p_3]['children'])-1
        elif  (len(obj.name_4)>0 and len(obj.name_5)==0) and 'children' in list(result_dict['children'][p_1]['children'][p_2]['children'][p_3].keys())  :
            result_dict['children'][p_1]['children'][p_2]['children'][p_3]['children'].append({'name':obj.name_4})
            p_4 = len(result_dict['children'][p_1]['children'][p_2]['children'][p_3]['children'])-1
    return result_dict

def department(request):
    result_queryset = models.Department.objects.exclude(name__contains='离').order_by('name')[0:30]
    result_dict_first={'name':'河南'}
    name_i_first=0
    result_dict = department_call_back(result_queryset,result_dict_first)
    result_json = json.dumps(result_dict,ensure_ascii=False)
    return render(request,'safeguard/echarts/department.html',locals())

简不变
关注
在django3.1的admin中加入jQuery单选下拉树dropdown Combo tree Select widget
流窜疯的专栏
06-05 680
需求中有一个字段要从近两千行分层数据中选择底级数据，在主界面用React+（Antd TreeSelect）+Django-Rest的组合解决非常简单，支持的特性也很丰富。 https://ant.design/components/tree-select-cn/ 唯一不足的是不支持XP下chrome最高的49.0.2623.112版本。于是想只在django3.1的admin中也提供一个修改入口，但是在网上搜来搜去，居然没找到一篇文章讲django admin中如何支持下拉树型组件。 网上高手们提
Django后台admin使用SimpleUi
weixin_41560737的博客
09-28 2160
Django后台前端框架SimpleUi
Django中模型Model添加JSON类型字段的方法
09-21
主要介绍了Django中模型Model添加JSON类型字段的方法,实例分析了Python的Django框架模型使用技巧,需要的朋友可以参考下
Django框架中models对象转换为json的方法
艺术编程
05-30 1660
在django框架中输出api接口时一般都是输出json数据但是通过orm获取的数据库数据一般都是object所以需要转换成json数据，一般有一下3种情况。# 通过objects这个模型管理器的all()获得所有数据行，相当于SQL中的SELECT * FROM。obj_list = list(obj) #需要转换为列表，否则会报错。data = Test.objects.get(id=值)1.models对象使用“all()”时。
**发掘Django Tree Menus的无限潜力**
gitblog_00041的博客
06-21 363
发掘Django Tree Menus的无限潜力 django-treemenusA simple django app to manage navigation menus via the django admin项目地址:https://gitcode.com/gh_mirrors/dj/django-treemenus 项目介绍 在构建复杂网页结构时，一个高效且直观的菜单系统是不可或缺的。...
django - model to json
chenghao7604的博客
01-12 306
classAnalysisInput(models.Model): input_user=models.CharField(max_length=45) input_title=models.CharField(max_length=45) input_dat...
Django models存储json格式的数据
不写代码的博客
01-19 5110
JSONField 官网介绍 用于存储JSON格式数据的字段。在Python中，数据以其Python本机格式表示：字典，列表，字符串，数字，布尔值和None。 一个可选的JSON格式类序列化的数据类型不是由标准JSON序列（支持的datetime，uuid等）。例如，您可以使用 DjangoJSONEncoder该类或任何其他json.JSONEncoder子类。 JSONField使用 ...
Django Admin实现三级联动的示例代码(省市区)
09-20
Django是Python语言编写的一个开源的web框架，它采用MTV的框架模式，即Model（模型）、Template（模板）、View（视图）。Django Admin则是Django框架自带的一个后台管理系统，它提供了一个方便的管理界面给开发者...
Django+zTree构建组织架构树的方法
09-18
具体来说，在Django中设计树形结构的model时，我们会创建一个Department模型，其中包含一个CharField字段name用于存储部门名称，并且设置为唯一（unique=True），以便在数据库中保证每个部门名称的唯一性。...
十四、Django框架使用
mChenys的博客
10-19 934
Django是劳伦斯出版集团的开发人员为开发新闻内容网站而设计出来的一个软件，它遵循MVC思想，但是有自己的一个名词，叫做MVT。Django遵循快速开发和DRY原则。Do not repeat yourself.不要自己去重复一些工作。它提供了许多有用的工具和功能，使开发者能够轻松地构建高度可拓展、安全、高性能的 Web 应用。强大的路由系统：Django 提供了易于配置和管理 URL 路由的功能，使开发者能够定义页面和应用程序的 URL 映射。
django实现将后台model对象转换成json对象并传递给前端jquery
12-20
1、django的model转json对象。 1.1、单个modle转换，返回json对象： sqlOrder = get_object_or_404(SqlOrder,id=request.GET.get("id")) objJson = serialize('json',[sqlOrder])[1:-1] {"model": "sqlapply.sqlorder", "pk": 2, "fields": {"work_id": "{now}{_ran}", "username": "admin", "status": 3, "type": 0, "backup": 0}} 注意：objJ
Django model序列化为json的方法示例
09-20
主要介绍了Django model序列化为json的方法示例，小编觉得挺不错的，现在分享给大家，也给大家做个参考。一起跟随小编过来看看吧
xadmin ajax jquery,django实现将后台model对象转换成json对象并传递给前端jquery
weixin_42191480的博客
08-05 383
1、django的model转json对象。1.1、单个modle转换，返回json对象：sqlOrder = get_object_or_404(SqlOrder,id=request.GET.get("id"))objJson = serialize('json',[sqlOrder])[1:-1]{"model": "sqlapply.sqlorder", "pk": 2, "fields"...
为Django中的模型Model添加JSON类型字段
weixin_43145520的博客
04-11 3676
Django里面让Model用于JSON字段，添加一个JSONField自动类型如下： class JSONField(models.TextField): metaclass = models.SubfieldBase description = “Json” def to_python(self, value): v = models.TextField.to_python(self, val...
django将后台model对象转换成json对象并传递给前端jquery
huoyuanshen的博客
12-22 4211
1、django的model转json对象。 1.1、单个modle转换，返回json对象： sqlOrder = get_object_or_404(SqlOrder,id=request.GET.get("id")) objJson = serialize('json',[sqlOrder])[1:-1] {"model": "sqlapply.sqlorder", "pk": 2, "fi...
django 内置 JSON 字段 使用场景
u010674101的专栏
06-05 917
Django 内置的 JSON 字段（JSONField）是在 Django 3.1 版本中引入的，用于处理 JSON 格式的数据。JSONField允许在数据库表中存储和查询 JSON 数据，并且在与 Python 代码交互时自动转换为合适的 Python 数据类型。
关于Django model 与json序列的转换
u010271717的专栏
03-21 4191
点击打开链接 class MyUser(models.Model): name = models.CharField(max_length=30,verbose_name='用户名称') password = models.CharField(max_length=30,verbose_name='用户密码') email = models.EmailField(
基于python+django+vue的农业管理系统
最新发布
计算机学姐的博客
09-13 1267
【2025最新】基于python+django+vue+MySQL的农业管理系统，前后端分离。
django将数据库数据转换成json文件
05-25
你可以使用Django提供的序列化器（Serializer）将数据库数据转换为JSON格式文件。 首先，你需要在Django中定义一个模型，并将其注册到admin.py中。例如，我们有一个名为Book的模型： ```python from django.db import models class Book(models.Model): title = models.CharField(max_length=200) author = models.CharField(max_length=200) publication_date = models.DateField() def __str__(self): return self.title ``` 然后，在admin.py中注册该模型： ```python from django.contrib import admin from .models import Book @admin.register(Book) class BookAdmin(admin.ModelAdmin): list_display = ('title', 'author', 'publication_date') ``` 接下来，我们可以使用Django提供的序列化器（Serializer）将该模型的数据转换为JSON格式文件。在views.py中，我们可以编写以下代码： ```python from django.core import serializers from django.http import HttpResponse def export_books_to_json(request): books = Book.objects.all() data = serializers.serialize('json', books) response = HttpResponse(data, content_type='application/json') response['Content-Disposition'] = 'attachment; filename="books.json"' return response ``` 在上述代码中，我们首先从数据库中获取所有的书籍数据，然后使用Django提供的序列化器将数据转换为JSON格式字符串。最后，我们将JSON字符串作为HttpResponse返回，并设置Content-Disposition标头以将其作为文件下载。 你可以在urls.py中添加以下代码以创建一个URL，该URL将触发export_books_to_json视图： ```python from django.urls import path from .views import export_books_to_json urlpatterns = [ path('export/', export_books_to_json, name='export_books_to_json'), ] ``` 当你访问该URL时，将自动下载books.json文件，其中包含所有书籍数据的JSON格式。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值