• Django后台项目实战之后台菜品类别信息管理

    后台菜品类别信息管理

    本页面完成项目后台管理的菜品类别信息模块操作

    (1). 菜品类别信息数据表：category

    • 在数据库 osdb 中创建 category 表，若此表已存在请跳过
    1.  
    2. CREATE TABLE `category` (
    3.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜品分类id',
    4.   `shop_id` int(11) DEFAULT NULL COMMENT '店铺id',
    5.   `name` varchar(50) DEFAULT NULL COMMENT '分类名称',
    6.   `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1正常 9删除',
    7.   `create_at` datetime DEFAULT NULL COMMENT '添加时间',
    8.   `update_at` datetime DEFAULT NULL COMMENT '修改时间',
    9.   PRIMARY KEY (`id`)
    10. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

    (2). 定义模型Model类

    • 进入myadmin应用目录中编辑：myobject/myadmin/models.py 模型文件
    1. from django.db import models
    2.  
    3. #菜品分类信息模型
    4. class Category(models.Model):
    5.     shop_id = models.IntegerField()        #店铺id
    6.     name = models.CharField(max_length=50)#分类名称
    7.     status = models.IntegerField(default=1)        #状态:1正常/9删除
    8.     create_at = models.DateTimeField(default=datetime.now)    #创建时间
    9.     update_at = models.DateTimeField(default=datetime.now)    #修改时间
    10.  
    11.     class Meta:
    12.         db_table = "category"  # 更改表名

    (3). 项目urls路由信息配置

    • 打开根路由文件：myobject/myadmin/urls.py路由文件，编辑路由配置信息
    1. from django.urls import path
    2. ...
    3. from myadmin.views import category
    4.  
    5. urlpatterns = [
    6.     ...
    7.  
    8.     #菜品分类信息管理
    9.     path('category/', category.index, name="myadmin_category_index"),
    10.     path('category/load/', category.loadCategory, name="myadmin_category_load"),
    11.     path('category/add', category.add, name="myadmin_category_add"),
    12.     path('category/insert', category.insert, name="myadmin_category_insert"),
    13.     path('category/del/', category.delete, name="myadmin_category_del"),
    14.     path('category/edit/', category.edit, name="myadmin_category_edit"),
    15.     path('category/update/', category.update, name="myadmin_category_update"),
    16. ]

    (4). 编辑视图文件

    • 新建视图文件：myobject/myadmin/views/category.py 视图文件，并进行编辑
    1. from django.shortcuts import render
    2. from django.http import HttpResponse
    3. from django.http import JsonResponse
    4. from django.core.paginator import Paginator
    5. from datetime import datetime
    6.  
    7. from myadmin.models import Category,Shop
    8.  
    9. # 菜品分类信息
    10.  
    11. def index(request,pIndex=1):
    12.     '''浏览信息'''
    13.     smod = Category.objects
    14.     mywhere=[]
    15.     list = smod.filter(status__lt=9)
    16.  
    17.     # 获取、判断并封装关keyword键搜索
    18.     kw = request.GET.get("keyword",None)
    19.     if kw:
    20.         # 查询店铺名称中只要含有关键字就可以
    21.         list = list.filter(name__contains=kw)
    22.         mywhere.append("keyword="+kw)
    23.  
    24.     # 获取、判断并封装状态status搜索条件
    25.     status = request.GET.get('status','')
    26.     if status != '':
    27.         list = list.filter(status=status)
    28.         mywhere.append("status="+status)
    29.  
    30.     #执行分页处理
    31.     pIndex = int(pIndex)
    32.     page = Paginator(list,10) #以10条每页创建分页对象
    33.     maxpages = page.num_pages #最大页数
    34.     #判断页数是否越界
    35.     if pIndex > maxpages:
    36.         pIndex = maxpages
    37.     if pIndex < 1:
    38.         pIndex = 1
    39.     list2 = page.page(pIndex) #当前页数据
    40.     plist = page.page_range   #页码数列表
    41.  
    42.     #遍历信息，并获取对应的商铺名称，以shopname名封装
    43.     for vo in list2:
    44.         sob = Shop.objects.get(id=vo.shop_id)
    45.         vo.shopname = sob.name
    46.     #封装信息加载模板输出
    47.     context = {"categorylist":list2,'plist':plist,'pIndex':pIndex,'maxpages':maxpages,'mywhere':mywhere}
    48.     return render(request,"myadmin/category/index.html",context)
    49.  
    50. def loadCategory(request,sid):
    51.     clist = Category.objects.filter(status__lt=9,shop_id=sid).values("id","name")
    52.     #返回QuerySet对象，使用list强转成对应的菜品分类列表信息
    53.     return JsonResponse({'data':list(clist)})
    54.  
    55. def add(request):
    56.     '''加载添加页面'''
    57.     slist = Shop.objects.values("id","name")
    58.     context={"shoplist":slist}
    59.     return render(request,"myadmin/category/add.html",context)
    60.  
    61. def insert(request):
    62.     '''执行添加'''
    63.     try:
    64.         ob = Category()
    65.         ob.shop_id = request.POST['shop_id']
    66.         ob.name = request.POST['name']
    67.         ob.status = 1
    68.         ob.create_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
    69.         ob.update_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
    70.         ob.save()
    71.         context={"info":"添加成功！"}
    72.     except Exception as err:
    73.         print(err)
    74.         context={"info":"添加失败"}
    75.     return render(request,"myadmin/info.html",context)
    76.  
    77. def delete(request,cid):
    78.     '''删除信息'''
    79.     try:
    80.         ob = Category.objects.get(id=cid)
    81.         ob.status = 9
    82.         ob.update_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
    83.         ob.save()
    84.         context={"info":"删除成功！"}
    85.     except Exception as err:
    86.         print(err)
    87.         context={"info":"删除失败"}
    88.  
    89.     return JsonResponse(context)
    90.     #return render(request,"myadmin/info.html",context)
    91.  
    92.  
    93. def edit(request,cid):
    94.     '''加载编辑信息页面'''
    95.     try:
    96.         ob = Category.objects.get(id=cid)
    97.         slist = Shop.objects.values("id","name")
    98.         context={"category":ob,"shoplist":slist}
    99.         return render(request,"myadmin/category/edit.html",context)
    100.     except Exception as err:
    101.         context={"info":"没有找到要修改的信息！"}
    102.         return render(request,"myadmin/info.html",context)
    103.  
    104. def update(request,cid):
    105.     '''执行编辑信息'''
    106.     try:
    107.         ob = Category.objects.get(id=cid)
    108.         ob.shop_id = request.POST['shop_id']
    109.         ob.name = request.POST['name']
    110.         #ob.status = request.POST['status']
    111.         ob.update_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
    112.         ob.save()
    113.         context={"info":"修改成功！"}
    114.     except Exception as err:
    115.         print(err)
    116.         context={"info":"修改失败"}
    117.     return render(request,"myadmin/info.html",context)

    (5). 编写模板文件

    • 5.1. 打开父类模板：/templates/myadmin/base.html ，编辑导航栏代码
    1.     ...
    2.     <li class="treeview">
    3.       <a href="category.html"><i class="fa fa-cutlery"></i> <span>菜品管理</span>
    4.         <span class="pull-right-container">
    5.           <i class="fa fa-angle-left pull-right"></i>
    6.         </span>
    7.       </a>
    8.       <ul class="treeview-menu">
    9.         <li><a href="{% url 'myadmin_category_index' 1 %}"> <i class="fa fa-circle-o"></i> 菜品分类</a></li>
    10.         <li><a href="{% url 'myadmin_product_index' 1 %}"> <i class="fa fa-circle-o"></i> 菜品信息</a></li>
    11.       </ul>
    12.     </li>
    13.     ...
    • 5.2. 后台商品类别信息浏览页模板：/templates/myadmin/category/index.html

     

    1. {% extends "myadmin/base.html" %}
    2.  
    3. {% block main_body %}
    4.     <!-- Content Header (Page header) -->
    5.     <section class="content-header">
    6.       <h1>
    7.         菜品类别管理
    8.         <small>订餐系统后台管理</small>
    9.       </h1>
    10.       <ol class="breadcrumb">
    11.         <li><a href="#"><i class="fa fa-dashboard"></i> 首页</a></li>
    12.         <li class="active">菜品分类信息管理</li>
    13.       </ol>
    14.     </section>
    15.  
    16.     <!-- Main content -->
    17.     <section class="content container-fluid">
    18.  
    19.       <div class="row">
    20.         <div class="col-xs-12">
    21.           <div class="box">
    22.             <div class="box-header">
    23.               <h3 class="box-title"><i class="fa fa-calendar"></i> 菜品分类信息表</h3>
    24.  
    25.               <div class="box-tools">
    26.                 <div class="input-group input-group-sm" style="width: 150px;">
    27.                   <input type="text" name="table_search" class="form-control pull-right" placeholder="Search">
    28.  
    29.                   <div class="input-group-btn">
    30.                     <button type="submit" class="btn btn-default"><i class="fa fa-search"></i></button>
    31.                   </div>
    32.                 </div>
    33.               </div>
    34.             </div>
    35.             <!-- /.box-header -->
    36.             <div class="box-body table-responsive no-padding">
    37.               <table class="table table-hover">
    38.                 <tr>
    39.                   <th>ID</th>
    40.                   <th>店铺名称</th>
    41.                   <th>类别名称</th>
    42.                   <th>当前状态</th>
    43.                   <th>添加时间</th>
    44.                   <th>修改时间</th>
    45.                   <th>操作</th>
    46.                 </tr>
    47.                 {% for vo in categorylist %}
    48.                 <tr>
    49.                   <td>{{ vo.id }}</td>
    50.                   <td>{{ vo.shopname }}</td>
    51.                   <td>{{ vo.name }}</td>
    52.                   <td>
    53.                     {% if vo.status == 1 %}
    54.                       <span style="color:green">正常</span>
    55.                     {% elif vo.status == 9 %}
    56.                       <span style="color:red">已删除</span>
    57.                     {% else %}
    58.                       <span style="color:red">未知状态</span>
    59.                     {% endif %}
    60.                   </td>
    61.                   <td width="12%">{{ vo.create_at|date:'Y-m-d' }}</td>
    62.                   <td width="12%">{{ vo.update_at|date:'Y-m-d' }}</td>
    63.                   <td width="25%">
    64.                     <a href="{% url 'myadmin_category_edit' vo.id %}" class="btn btn-success btn-xs">
    65.                       <span class="glyphicon glyphicon-edit" aria-hidden="true"></span> 编辑</a>
    66.                     <button type="button" onclick="doDelete('{% url 'myadmin_category_del' vo.id %}')" class="btn btn-danger btn-xs">
    67.                       <span class="glyphicon glyphicon-trash" aria-hidden="true"></span> 删除</button>
    68.                     <a href="#" class="btn btn-warning btn-xs">
    69.                       <span class="glyphicon glyphicon-search" aria-hidden="true"></span> 查看菜品</a>
    70.                   </td>
    71.                 </tr>
    72.                 {% endfor %}
    73.               </table>
    74.             </div>
    75.             <!-- /.box-body -->
    76.             <div class="box-footer clearfix">
    77.               <a role="button" href="{% url 'myadmin_category_add' %}" class="btn btn-primary">
    78.                 <span class="glyphicon glyphicon-plus" aria-hidden="true"></span> 添加菜品分类</a>
    79.                 <ul class="pagination pagination-sm no-margin pull-right">
    80.                     <li><a href="{% url 'myadmin_category_index' pIndex|add:-1 %}?{{mywhere|join:'&'}}">&laquo;</a></li>
    81.                     {% for p in plist %}
    82.                     <li {% if p == pIndex %}class="active"{% endif %}><a href="{% url 'myadmin_category_index' p %}?{{mywhere|join:'&'}}">{{p}}</a></li>
    83.                     {% endfor %}
    84.                     <li><a href="{% url 'myadmin_category_index' pIndex|add:1 %}?{{mywhere|join:'&'}}">&raquo;</a></li>
    85.                 </ul>
    86.             </div>
    87.           </div>
    88.           <!-- /.box -->
    89.         </div>
    90.       </div>
    91.  
    92.     </section>
    93.     <!-- /.content -->
    94. {% endblock %}
    • 5.3. 后台商品类别信息添加表单页模板：/templates/myadmin/category/add.html

     

    1. {% extends "myadmin/base.html" %}
    2.  
    3.  
    4. {% block main_body %}
    5.     <!-- Content Header (Page header) -->
    6.     <section class="content-header">
    7.       <h1>
    8.         菜品分类管理
    9.         <small>订餐系统后台管理</small>
    10.       </h1>
    11.       <ol class="breadcrumb">
    12.         <li><a href="#"><i class="fa fa-dashboard"></i> 首页</a></li>
    13.         <li class="active">菜品分类信息管理</li>
    14.       </ol>
    15.     </section>
    16.  
    17.     <!-- Main content -->
    18.     <section class="content container-fluid">
    19.  
    20.       <div class="row">
    21.         <div class="col-xs-12">
    22.           <div class="box">
    23.             <div class="box-header">
    24.                 <h2 class="box-title"><span class="glyphicon glyphicon-calendar" aria-hidden="true">添加菜品分类信息</h2>
    25.             </div>
    26.             <!-- /.box-header -->
    27.             <!-- form start -->
    28.             <form class="form-horizontal" action="{% url 'myadmin_category_insert' %}" method="post">
    29.                 {% csrf_token %}
    30.               <div class="box-body">
    31.                 <div class="form-group">
    32.                   <label for="inputEmail3" class="col-sm-2 control-label">店铺名称：</label>
    33.  
    34.                   <div class="col-sm-4">
    35.                     <select name="shop_id" class="form-control select2" style="width: 100%;">
    36.                       {% for svo in shoplist %}
    37.                         <option value="{{ svo.id }}">{{ svo.name }}</option>
    38.                       {% endfor %}
    39.                     </select>
    40.                   </div>
    41.                 </div>
    42.                 <div class="form-group">
    43.                   <label for="inputEmail3" class="col-sm-2 control-label">类别名称：</label>
    44.  
    45.                   <div class="col-sm-4">
    46.                     <input type="text" name="name" class="form-control" id="inputText2" placeholder="类别名称" />
    47.                   </div>
    48.                 </div>
    49.               </div>
    50.               <!-- /.box-body -->
    51.               <div class="box-footer">
    52.                 <div class="col-sm-offset-2 col-sm-10">
    53.                   <button type="submit" class="btn btn-primary">提交</button> &nbsp; 
    54.                   <button type="reset" class="btn btn-default">重置</button>
    55.                 <div class="col-sm-offset-2 col-sm-10">
    56.               </div>
    57.               <!-- /.box-footer -->
    58.             </form>
    59.           </div>
    60.           <!-- /.box -->
    61.         </div>
    62.       </div>
    63.  
    64.     </section>
    65.     <!-- /.content -->
    66. {% endblock %}
    • 5.4. 后台商品信息编辑模板：/templates/myadmin/category/edit.html

     

    1. {% extends "myadmin/base.html" %}
    2.  
    3.  
    4. {% block main_body %}
    5.     <!-- Content Header (Page header) -->
    6.     <section class="content-header">
    7.       <h1>
    8.         菜品分类管理
    9.         <small>订餐系统后台管理</small>
    10.       </h1>
    11.       <ol class="breadcrumb">
    12.         <li><a href="#"><i class="fa fa-dashboard"></i> 首页</a></li>
    13.         <li class="active">菜品分类信息管理</li>
    14.       </ol>
    15.     </section>
    16.  
    17.     <!-- Main content -->
    18.     <section class="content container-fluid">
    19.  
    20.       <div class="row">
    21.         <div class="col-xs-12">
    22.           <div class="box">
    23.             <div class="box-header">
    24.                 <h2 class="box-title"><span class="glyphicon glyphicon-calendar" aria-hidden="true">编辑菜品分类信息</h2>
    25.             </div>
    26.             <!-- /.box-header -->
    27.             <!-- form start -->
    28.             <form class="form-horizontal" action="{% url 'myadmin_category_update' category.id  %}" method="post">
    29.                 {% csrf_token %}
    30.               <div class="box-body">
    31.                 <div class="form-group">
    32.                   <label for="inputEmail3" class="col-sm-2 control-label">店铺名称：</label>
    33.  
    34.                   <div class="col-sm-4">
    35.                     <select name="shop_id" class="form-control select2" style="width: 100%;">
    36.                       {% for svo in shoplist %}
    37.                         <option value="{{ svo.id }}" {% if category.shop_id == svo.id %}selected{% endif %} >{{ svo.name }}</option>
    38.                       {% endfor %}
    39.                     </select>
    40.                   </div>
    41.                 </div>
    42.                 <div class="form-group">
    43.                   <label for="inputEmail3" class="col-sm-2 control-label">类别名称：</label>
    44.  
    45.                   <div class="col-sm-4">
    46.                     <input type="text" name="name" value="{{ category.name }}" class="form-control" id="inputText2" placeholder="类别名称" />
    47.                   </div>
    48.                 </div>
    49.               </div>
    50.               <!-- /.box-body -->
    51.               <div class="box-footer">
    52.                 <div class="col-sm-offset-2 col-sm-10">
    53.                   <button type="submit" class="btn btn-primary">保存</button> &nbsp; 
    54.                   <button type="reset" class="btn btn-default">重置</button>
    55.                 <div class="col-sm-offset-2 col-sm-10">
    56.               </div>
    57.               <!-- /.box-footer -->
    58.             </form>
    59.           </div>
    60.           <!-- /.box -->
    61.         </div>
    62.       </div>
    63.  
    64.     </section>
    65.     <!-- /.content -->
    66. {% endblock %}

    6 运行测试

    1. [root@localhost myobject]# pwd
    2. /python/myobject
    3. [root@localhost myobject]# ls
    4. manage.py  myadmin  myobject  myweb  static  templates
    5. [root@localhost myobject]# python3 manage.py runserver
    6. Performing system checks...
    7.  
    8. System check identified no issues (0 silenced).
    9.  
    10. April 07, 2020 - 16:29:36
    11. Django version 1.11, using settings 'myobject.settings'
    12. Starting development server at http://127.0.0.1:8000/
    13. Quit the server with CONTROL-C.
    14. ^C[root@localhost myobject]#
  • 相关阅读:
    超详细的hadoop完全分布式安装及xsync等各个脚本
    前端 基础知识
    【4】字符设备的read/write
    Linux修改认证加密方式为sha512
    SpringBoot启动源码-初了解
    聊聊设计模式——命令模式
    Vue3 computed根据返回的字段显示颜色
    MPJ: MyBatis-Plus-Join连表查询
    BL808:【M1s DOCK开发板】与LVGL 使用体验
    初识javaweb2 tomcat
  • 原文地址：https://blog.csdn.net/xyh2004/article/details/139288736