基于物流数据的智能仓库管理系统设计与实现后端

import json import random import datetime from django.http import HttpResponse from app.models import * from tools.emailcode_send import send from tools.get_now_time import get_now_time from tools.get_all import * from tools.updateInformation import * from tools.addInformation import * from tools.deleteinformation import * from tools.log import log # 生成报表 import xlwt import os from pathlib import Path from openpyxl.styles import Alignment # 设置单元格文字对齐方式、自动换行 from django.utils.encoding import escape_uri_path from tools.sendfile import sendfile pass_salt = "username_salt" def login(request): """ 键值名称：result 返回值： "密码错误！"： 0 "登录成功！"： 1 "未查找到账号！"： 2 "数据库访问发生错误！"： 3 """ if request.method == "POST": # 接受用户登录的账号和密码 req = json.loads(request.body) account = req.get('account', None) password = req.get('password', None) # 创建返回字典 context = dict() # 处理请求（登录验证） try: # 调用函数实现按照员工账号ID进行查询检索 obj = User.objects.get(email=account) # 判断密码是否正确 if obj.password != password: # 密码错误 context['result'] = 0 else: # 登录成功 context['result'] = 1 res = HttpResponse(json.dumps(context)) res.set_signed_cookie("account", account, pass_salt) right_level = int(obj.right_level) if (right_level != 0 and right_level != 1): res.set_cookie('right_level',2) else: res.set_cookie('right_level',right_level) #写入log日志 type = "登录" time = get_now_time() affair = account+"登录了系统" log(type, time, affair) return res except User.DoesNotExist: # 未查找到账号 context['result'] = 2 except: context['result'] = 3 return HttpResponse(json.dumps(context)) else: return HttpResponse("error") def login_veri(request): """ 验证码登录 """ if request.method == "POST": req = json.loads(request.body) account = req.get('account', None) confirm_code = req.get('confirm_code', None) # 通过数据库检测该账号是否已经存在 try: # 用户已存在 obj = User.objects.get(email=account) # 创建返回字典 context = dict() # 处理请求 （判断验证码是否正确） obj1 = code.objects.get(account=account) # 验证码正确 if confirm_code == obj1.confirm_code: context['result'] = 1 res = HttpResponse(json.dumps(context)) res.set_signed_cookie("account", account, pass_salt) right_level = int(obj.right_level) if (right_level != 0 and right_level != 1): res.set_cookie('right_level',2) else: res.set_cookie('right_level',right_level) #写入log日志 type = "登录" time = get_now_time() affair = account+"登录了系统" log(type, time, affair) # 验证码错误 else: context['result'] = 0 res = HttpResponse(json.dumps(context)) return res except User.DoesNotExist: return HttpResponse(json.dumps({'result': 2})) except: context['result'] = 0 return HttpResponse(json.dumps(context)) # 注册成功，保存注册账号和密码 def register(request): """ 键值名称：result 返回值： "注册账号成功！"：0 "注册账号失败！"：1 """ if request.method == "POST": # 接受用户注册的账号和密码 req = json.loads(request.body) account = req.get('account', None) password = req.get('password', None) # 创建返回字典 context = dict() # 处理请求（注册信息存入数据库） try: # 将用户账号信息存入数据库中 User.objects.create(email=account, password=password, position="员工", right_level=2) #写入log日志 type = "注册" time = get_now_time() affair = account+"注册成功" log(type, time, affair) context['result'] = 0 except: # 数据库访问发生错误 context['result'] = 1 return HttpResponse(json.dumps(context)) else: return HttpResponse("error") # 注册界面点击下一步，判断验证码是否正确 def register_email(request): """ 前端发送account,confirm_code（验证码） 后端返回： result： 0：验证码错误 1：验证码正确，进行下一步 2：用户已存在 """ if request.method == "POST": # 接受用户注册的账号和接收到的验证码 req = json.loads(request.body) account = req.get('account', None) confirm_code = req.get('confirm_code', None) # 通过数据库检测该账号是否已经存在 try: # 用户已存在 obj = User.objects.get(email=account) # 删除验证码信息 code.objects.filter(account=account).delete() return HttpResponse(json.dumps({'result': 2})) except User.DoesNotExist: # 创建返回字典 context = dict() # 处理请求 （判断验证码是否正确） obj = code.objects.get(account=account) code.objects.filter(account=account).delete() # 验证码正确 if confirm_code == obj.confirm_code: context['result'] = 1 # 验证码错误 else: context['result'] = 0 response = HttpResponse(json.dumps(context)) return response else: return HttpResponse("error") # 向邮箱发送验证码 def get_confirm_code(request): # 用户点击发送验证码获取请求后 if request.method == "POST": # 接收该用户账号（邮件） req = json.loads(request.body) user_email = req.get('account', None) # user_email = request.data['account'] # 创建结果返回字典 context = dict() try: email_content = '%06d' % random.randint(0, 999999) email_title = "验证码获取" # 将验证码存入code数据库当中 code.objects.filter(account=user_email).delete() code.objects.create(account=user_email, confirm_code=email_content) send(user_email, email_title, email_content) # 发送成功 context['result'] = 1 # 其他情况 except: context['result'] = 0 return HttpResponse(json.dumps(context)) else: return HttpResponse("error") # 实现查询全部用户信息的业务处理 def get_all(request): # 判断请求方式（POST） if request.method == "POST": # 获取参数flag，判定请求需要 req = json.loads(request.body) flag = req.get('table_type',None) context = dict() # 根据参数，执行相应函数 if flag == "RoleManage": # 查询角色全部信息 context = get_role_all(request) elif flag == "EmployeeMana