06点餐项目实战之员工信息管理

• 本页面完成项目后台管理的员工模块操作（增删改查）

(1). 员工信息数据表：user

(2). 定义模型Model类

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

(4).编辑视图文件

(5). 编写模板文件

=======================================================================

• 1.在数据库 osdb 中创建user表，若此表已存在请跳过

-- 员工信息表
CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '员工账号id',
  `username` varchar(50) DEFAULT NULL COMMENT '员工账号',
  `nickname` varchar(50) DEFAULT NULL COMMENT '昵称',
  `password_hash` varchar(100) DEFAULT NULL COMMENT '密码',
  `password_salt` varchar(50) DEFAULT NULL COMMENT '密码干扰值',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态:1正常/2禁用/9删除',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

(2). 定义模型Model类，按照表结构定义

• 进入myadmin应用目录中编辑：myobject/myadmin/models.py 模型文件

from django.db import models
from datetime import datetime

#员工账号信息模型
class User(models.Model):
    username = models.CharField(max_length=50)    #员工账号
    nickname = models.CharField(max_length=50)    #昵称
    password_hash = models.CharField(max_length=100)#密码
    password_salt = models.CharField(max_length=50)    #密码干扰值
    status = models.IntegerField(default=1)    #状态:1正常/2禁用/9删除
    create_at = models.DateTimeField(default=datetime.now)    #创建时间
    update_at = models.DateTimeField(default=datetime.now)    #修改时间

    def toDict(self):
        return {'id':self.id,'username':self.username,'nickname':self.nickname,'password_hash':self.password_hash,'password_salt':self.password_salt,'status':self.status,'create_at':self.create_at.strftime('%Y-%m-%d %H:%M:%S'),'update_at':self.update_at.strftime('%Y-%m-%d %H:%M:%S')}

    class Meta:
        db_table = "user"  # 更改表名

(3). 先编辑视图文件，在去写url路由文件

• 创建：myobject/myadmin/views/user.py 视图文件，并进行编辑（主要就是增删改查，然后还有两个加载页面）

from django.shortcuts import render
from django.http import HttpResponse
from django.http import JsonResponse
from django.db.models import Q
from django.core.paginator import Paginator
from datetime import datetime
import random

from myadmin.models import User

def index(request,pIndex=1):
    '''浏览信息'''
    umod = User.objects
    mywhere=[]
    list = umod.filter(status__lt=9)

    # 获取、判断并封装关keyword键搜索
    kw = request.GET.get("keyword",None)
    if kw:
        # 查询员工账号或昵称中只要含有关键字的都可以
        list = list.filter(Q(username__contains=kw) | Q(nickname__contains=kw))
        mywhere.append("keyword="+kw)

    # 获取、判断并封装状态status搜索条件
    status = request.GET.get('status','')
    if status != '':
        list = list.filter(status=status)
        mywhere.append("status="+status)

    #执行分页处理
    pIndex = int(pIndex)
    page = Paginator(list,5) #以5条每页创建分页对象
    maxpages = page.num_pages #最大页数
    #判断页数是否越界
    if pIndex > maxpages:
        pIndex = maxpages
    if pIndex < 1:
        pIndex = 1
    list2 = page.page(pIndex) #当前页数据
    plist = page.page_range   #页码数列表

    #list2 = User.objects.all() #获取所有信息
    #封装信息加载模板输出
    context = {"userlist":list2,'plist':plist,'pIndex':pIndex,'maxpages':maxpages,'mywhere':mywhere}
    return render(request,"myadmin/user/index.html",context)

def add(request):
    '''加载添加页面'''
    return render(request,"myadmin/user/add.html")

def insert(request):
    '''执行添加'''
    try:
        ob = User()
        ob.username = request.POST['username']
        ob.nickname = request.POST['nickname']
        #获取密码并md5
        import hashlib
        md5 = hashlib.md5()
        n = random.randint(100000, 999999)
        s = request.POST['password']+str(n) 
        md5.update(s.encode('utf-8'))
        ob.password_hash = md5.hexdigest()
        ob.password_salt = n
        ob.status = 1
        ob.create_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
        ob.update_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
        ob.save()
        context={"info":"添加成功！"}
    except Exception as err:
        print(err)
        context={"info":"添加失败"}
    return render(request,"myadmin/info.html",context)

def delete(request,uid):
    '''删除信息'''
    try:
        ob = User.objects.get(id=uid)
        ob.status = 9
        ob.update_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
        ob.save()
        context={"info":"删除成功！"}
    except Exception as err:
        print(err)
        context={"info":"删除失败"}

    return JsonResponse(context)
    #return render(request,"myadmin/info.html",context)


def edit(request,uid):
    '''加载编辑信息页面'''
    try:
        ob = User.objects.get(id=uid)
        context={"user":ob}
        return render(request,"myadmin/user/edit.html",context)
    except Exception as err:
        context={"info":"没有找到要修改的信息！"}
        return render(request,"myadmin/info.html",context)

def update(request,uid):
    '''执行编辑信息'''
    try:
        ob = User.objects.get(id=uid)
        ob.nickname = request.POST['nickname']
        ob.status = request.POST['status']
        ob.update_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
        ob.save()
        context={"info":"修改成功！"}
    except Exception as err:
        print(err)
        context={"info":"修改失败"}
    return render(request,"myadmin/info.html",context)

"""
def resetpass(request,uid):
    '''加载重置会员密码信息页面'''
    try:
        ob = User.objects.get(id=uid)
        context={"user":ob}
        return render(request,"myadmin/user/resetpass.html",context)
    except Exception as err:
        context={"info":"没有找到要修改的信息！"}
        return render(request,"myadmin/info.html",context)

def doresetpass(request,uid):
    '''执行编辑信息'''
    try:
        ob = User.objects.get(id=uid)
        #获取密码并md5
        import hashlib
        md5 = hashlib.md5()
        n = random.randint(100000, 999999)
        s = request.POST['password']+str(n) 
        md5.update(s.encode('utf-8'))
        ob.password_hash = md5.hexdigest()
        ob.password_salt = n
        ob.save()
        context={"info":"密码重置成功！"}
    except Exception as err:
        print(err)
        context={"info":"密码重置失败"}
    return render(request,"myadmin/info.html",context)
"""

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

• 打开根路由文件：myobject/myadmin/urls.py路由文件，编辑路由配置信息

  from django.urls import path
  from myadmin.views import index
  from myadmin.views import user
  
  urlpatterns = [
      # 后台首页
      path('', index.index, name="myadmin_index"),
  
      #员工账号信息管理
      path('user/<int:pIndex>', user.index, name="myadmin_user_index"),#浏览信息
      path('user/add', user.add, name="myadmin_user_add"),             #加载添加表单
      path('user/insert', user.insert, name="myadmin_user_insert"),     #执行信息添加
      path('user/del/<int:uid>', user.delete, name="myadmin_user_del"),#删除信息
      path('user/edit/<int:uid>', user.edit, name="myadmin_user_edit"),#准备信息编辑
      path('user/update/<int:uid>', user.update, name="myadmin_user_update"),#执行信息编辑
      #重置员工密码
      #path('user/resetpass/<int:uid>', user.resetpass, name="myadmin_user_resetpass"), 
      #path('user/doresetpass/<int:uid>', user.doresetpass, name="myadmin_user_doresetpass"),
  ]

  (5). 编写模板文件

• 

• 5.1. 后台用户信息浏览模板：/templates/myadmin/user/index.html

• {% extends "myadmin/base.html" %}
  
  {% block main_body %}
      <!-- Content Header (Page header) -->
      <section class="content-header">
        <h1>
          账号管理
          <small>订餐系统后台管理</small>
        </h1>
        <ol class="breadcrumb">
          <li><a href="#"><i class="fa fa-dashboard"></i> 首页</a></li>
          <li class="active">员工账号信息管理</li>
        </ol>
      </section>
  
      <!-- Main content -->
      <section class="content container-fluid">
  
        <div class="row">
          <div class="col-xs-12">
            <div class="box">
              <div class="box-header">
                <h4 class="box-title"><i class="fa fa-calendar"></i> 员工账号信息表</h4>
  
                <div class="box-tools">
                  <form action="{% url 'myadmin_user_index' 1 %}" method="get">
                  <div class="input-group input-group-sm" style="width:150px;">
                    <input type="text" name="keyword" class="form-control pull-right" placeholder="账号/昵称">
  
                    <div class="input-group-btn">
                      <button type="submit" class="btn btn-default"><i class="fa fa-search"></i></button>
                    </div>
                  </div>
                  </form>
                </div>
              </div>
              <!-- /.box-header -->
              <div class="box-body table-responsive no-padding">
                <table class="table table-hover">
                  <tr>
                    <th>ID</th>
                    <th>员工账号</th>
                    <th>昵称</th>
                    <th>当前状态</th>
                    <th>添加时间</th>
                    <th>修改时间</th>
                    <th>操作</th>
                  </tr>
                  {% for vo in userlist %}
                  <tr>
                    <td>{{ vo.id }}</td>
                    <td>{{ vo.username }}</td>
                    <td>{{ vo.nickname }}</td>
                    <td>
                      {% if vo.status == 1 %}
                        <span style="color:green">正常</span>
                      {% elif vo.status == 2 %}
                        <span style="color:red">禁停</span>
                      {% elif vo.status == 6 %}
                        <span style="color:red">管理员</span>
                      {% elif vo.status == 9 %}
                        <span style="color:red">已删除</span>
                      {% else %}
                        <span style="color:red">未知状态</span>
                      {% endif %}
                    </td>
                    <td width="15%">{{ vo.create_at|date:'Y-m-d H:i:s' }}</td>
                    <td width="15%">{{ vo.update_at|date:'Y-m-d H:i:s' }}</td>
                    <td width="22%">
                      <a href="{% url 'myadmin_user_edit' vo.id %}" class="btn btn-success btn-xs">
                        <span class="glyphicon glyphicon-edit" aria-hidden="true"></span> 编辑</a>
                      <button type="button" onclick="doDelete('{% url 'myadmin_user_del' vo.id %}')" class="btn btn-danger btn-xs">
                        <span class="glyphicon glyphicon-trash" aria-hidden="true"></span> 删除</button>
                      <a type="button" class="btn btn-warning btn-xs">
                        <span class="glyphicon glyphicon-search" aria-hidden="true"></span> 分配店铺</a>
                    </td>
                  </tr>
                  {% endfor %}
                </table>
              </div>
              <!-- /.box-body -->
              <div class="box-footer clearfix">
                <a role="button" href="{% url 'myadmin_user_add' %}" class="btn btn-primary btn-xs">
                        <span class="glyphicon glyphicon-plus" aria-hidden="true"></span> 添加会员</a>
                <ul class="pagination pagination-sm no-margin pull-right">
                  <li><a href="{% url 'myadmin_user_index' pIndex|add:-1 %}">&laquo;</a></li>
                  {% for p in plist %}
                    <li {% if p == pIndex %}class="active"{% endif %}><a href="{% url 'myadmin_user_index' p %}">{{p}}</a></li>
                  {% endfor %}
                  <li><a href="{% url 'myadmin_user_index' pIndex|add:1 %}">&raquo;</a></li>
                </ul>
              </div>
            </div>
            <!-- /.box -->
          </div>
        </div>
  
      </section>
      <!-- /.content -->
  {% endblock %}
  

• 5.3. 后台用户信息添加模板：/templates/myadmin/user/add.html

• 

  {% extends "myadmin/base.html" %}
  
  {% block main_body %}
      <!-- Content Header (Page header) -->
      <section class="content-header">
        <h1>
          账号管理
          <small>订餐系统后台管理</small>
        </h1>
        <ol class="breadcrumb">
          <li><a href="#"><i class="fa fa-dashboard"></i> 首页</a></li>
          <li class="active">员工账号信息管理</li>
        </ol>
      </section>
  
      <!-- Main content -->
      <section class="content container-fluid">
  
        <div class="row">
          <div class="col-xs-12">
            <div class="box">
              <div class="box-header">
                  <h2 class="box-title"><span class="glyphicon glyphicon-calendar" aria-hidden="true">添加员工账号信息</h2>
              </div>
              <!-- /.box-header -->
              <!-- form start -->
              <form class="form-horizontal" action="{% url 'myadmin_user_insert' %}" method="post">
                  {% csrf_token %}
                <div class="box-body">
                  <div class="form-group">
                    <label for="inputEmail3" class="col-sm-2 control-label">员工账号：</label>
  
                    <div class="col-sm-4">
                      <input type="text" name="username" class="form-control" id="inputText1" placeholder="员工账号" />
                    </div>
                  </div>
                  <div class="form-group">
                    <label for="inputEmail3" class="col-sm-2 control-label">昵称：</label>
  
                    <div class="col-sm-4">
                      <input type="text" name="nickname" class="form-control" id="inputText2" placeholder="昵称" />
                    </div>
                  </div>
                  <div class="form-group">
                    <label for="inputEmail3"  class="col-sm-2 control-label">密码：</label>
  
                    <div class="col-sm-4">
                      <input type="password" name="password" class="form-control" id="inputPassword1" />
                    </div>
                  </div>
                  <div class="form-group">
                    <label for="inputEmail3" class="col-sm-2 control-label">重复密码：</label>
  
                    <div class="col-sm-4">
                      <input type="password" name="repassword" class="form-control" id="inputPassword2" />
                    </div>
                  </div>
                </div>
                <!-- /.box-body -->
                <div class="box-footer">
                  <div class="col-sm-offset-2 col-sm-10">
                    <button type="submit" class="btn btn-primary">提交</button> &nbsp; 
                    <button type="reset" class="btn btn-default">重置</button>
                  <div class="col-sm-offset-2 col-sm-10">
                </div>
                <!-- /.box-footer -->
              </form>
            </div>
            <!-- /.box -->
          </div>
        </div>
  
      </section>
      <!-- /.content -->
  {% endblock %}
  

• 信息提示页：/templates/myadmin/info.html

• {% extends "myadmin/base.html" %}
  
  {% block main_body %}                
      <!-- Content Header (Page header) -->
      <section class="content-header">
        <h4>
          信息提示:
        </h4>
      </section>
  
      <div class="pad margin no-print">
        <div class="callout callout-info" style="margin-bottom: 0!important;padding-left: 50px">
          <h3><i class="fa fa-exclamation-triangle"></i>  &nbsp; {{ info }}</h3>
        </div>
      </div>
  {% endblock %}
  

• 5.4. 后台用户信息编辑模板：/templates/myadmin/users/edit.html

• 

  {% extends "myadmin/base.html" %}
  
  {% block main_body %}
      <!-- Content Header (Page header) -->
      <section class="content-header">
        <h1>
          账号管理
          <small>订餐系统后台管理</small>
        </h1>
        <ol class="breadcrumb">
          <li><a href="#"><i class="fa fa-dashboard"></i> 首页</a></li>
          <li class="active">员工账号信息管理</li>
        </ol>
      </section>
  
      <!-- Main content -->
      <section class="content container-fluid">
  
        <div class="row">
          <div class="col-xs-12">
            <div class="box">
              <div class="box-header">
                  <h2 class="box-title"><span class="glyphicon glyphicon-calendar" aria-hidden="true">员工信息修改</h2>
              </div>
              <!-- /.box-header -->
              <!-- form start -->
              <form class="form-horizontal" action="{% url 'myadmin_user_update' user.id %}" method="post">
                  {% csrf_token %}
                <div class="box-body">
                  <div class="form-group">
                    <label for="inputEmail3" class="col-sm-2 control-label">员工账号：</label>
  
                    <div class="col-sm-4">
                      <input type="text" name="username" value="{{user.username}}" class="form-control" disabled readonly id="inputText1" placeholder="员工账号" />
                    </div>
                  </div>
                  <div class="form-group">
                    <label for="inputEmail3" class="col-sm-2 control-label">昵称：</label>
  
                    <div class="col-sm-4">
                      <input type="text" name="nickname" value="{{user.nickname}}" class="form-control" id="inputText2" placeholder="昵称" />
                    </div>
                  </div>
                  <div class="form-group">
                    <label for="inputEmail3"  class="col-sm-2 control-label">添加时间：</label>
  
                    <div class="col-sm-4">
                      {{ user.create_at|date:'Y-m-d H:i:s' }}
                    </div>
                  </div>
                  <div class="form-group">
                    <label for="inputEmail3" class="col-sm-2 control-label">修改时间：</label>
  
                    <div class="col-sm-4">
                      {{ user.update_at|date:'Y-m-d H:i:s' }}
                    </div>
                  </div>
                  <div class="form-group">
                    <label class="col-sm-2 control-label">当前状态：</label>
                    <div class="controls">
                      &nbsp; &nbsp;
                      <input type="radio" name="status" class="input-xlarge" value="1" 
                      {% if user.status == 1 %}checked{% endif %} /> 正常
                       &nbsp; &nbsp; 
                      <input type="radio" name="status" class="input-xlarge" value="2" 
                      {% if user.status == 2 %}checked{% endif %} /> 禁用
                       &nbsp; &nbsp; 
                      <input type="radio" name="status" class="input-xlarge" value="6" 
                      {% if user.status == 6 %}checked{% endif %} /> 管理员
                    </div>
                  </div>
                </div>
                <!-- /.box-body -->
                <div class="box-footer">
                  <div class="col-sm-offset-2 col-sm-10">
                    <button type="submit" class="btn btn-primary">保存</button> &nbsp; 
                    <button type="reset" class="btn btn-default">重置</button>
                  <div class="col-sm-offset-2 col-sm-10">
                </div>
                <!-- /.box-footer -->
              </form>
            </div>
            <!-- /.box -->
          </div>
        </div>
  
      </section>
      <!-- /.content -->
  {% endblock %}