• 基于Python+Django的开药系统【源码+LW+PPT+部署讲解】

    作者主页：编程千纸鹤

    作者简介：Java领域优质创作者、CSDN博客专家 、CSDN内容合伙人、掘金特邀作者、阿里云博客专家、51CTO特邀作者、多年架构师设计经验、多年校企合作经验，被多个学校常年聘为校外企业导师，指导学生毕业设计并参与学生毕业答辩指导，有较为丰富的相关经验。期待与各位高校教师、企业讲师以及同行交流合作

    主要内容：Java项目、Python项目、前端项目、PHP、ASP.NET、人工智能与大数据、单片机开发、物联网设计与开发设计、简历模板、学习资料、面试题库、技术互助、就业指导等

    业务范围：免费功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文编写和辅导、论文降重、长期答辩答疑辅导、腾讯会议一对一专业讲解辅导答辩、模拟答辩演练、和理解代码逻辑思路等。

    收藏点赞不迷路  关注作者有好处

    文末获取源码 

    项目编号：BS-Python-052

    一，环境介绍

    语言环境：Python3.8

    数据库：Mysql: mysql5.7

    WEB框架：Django

    开发工具：IDEA或PyCharm

    二，项目简介

    互联网的兴起从本质上改变了整个社会对信息的管理方式，国内各大市场从上个世纪90年代互联网兴起之时，就产生了通过网络进行系统管理的想法。但是由于在互联网上的信誉难以认证、网络的法规政策不健全等一系列的原因，限制了网上信息管理发展的步伐。进入21世纪以后，随着整个社会的发展、进步，制约网上交流的各个瓶颈问题逐一被击破，比如QQ、微信等各大平台也纷纷的加入到洪潮之中。

    开药系统是在的数据存储主要通过MySQL。用户在使用应用时产生的数据通过Python语言传递给数据库。通过此方式促进开药信息管理和数据传输效率，提供一个内容丰富、功能多样、易于操作的平台。述了数据库的设计，系统的详细设计部分主要论述了几个主要模块的详细设计过程。

    管理员功能用例：

    医生功能用例：

    系统整体E-R图：

    三，系统展示

    四，核心代码展示

    1. #coding:utf-8
    2. __author__ = "ila"
    3. import base64, copy, logging, os, time, xlrd
    4. from django.http import JsonResponse
    5. from django.apps import apps
    6. from django.db.models.aggregates import Count,Sum
    7. from .models import chuyaojilu
    8. from util.codes import *
    9. from util.auth import Auth
    10. from util.common import Common
    11. import util.message as mes
    12. from django.db import connection
    13. import random
    14. from django.core.mail import send_mail
    15. from django.conf import settings
    16. from django.shortcuts import redirect
    17. from django.db.models import Q
    18.  
    19. def chuyaojilu_register(request):
    20.     if request.method in ["POST", "GET"]:
    21.         msg = {'code': normal_code, "msg": mes.normal_code}
    22.         req_dict = request.session.get("req_dict")
    23.         req_dict['mima'] = Common.md5(Common, req_dict.get('mima'))
    24.  
    25.  
    26.         error = chuyaojilu.createbyreq(chuyaojilu, chuyaojilu, req_dict)
    27.         if error != None:
    28.             msg['code'] = crud_error_code
    29.             msg['msg'] = "用户已存在,请勿重复注册!"
    30.         return JsonResponse(msg)
    31.  
    32. def chuyaojilu_login(request):
    33.     if request.method in ["POST", "GET"]:
    34.         msg = {'code': normal_code, "msg": mes.normal_code}
    35.         req_dict = request.session.get("req_dict")
    36.         req_dict['password'] = Common.md5(Common, req_dict.get('password'))
    37.  
    38.         datas = chuyaojilu.getbyparams(chuyaojilu, chuyaojilu, req_dict)
    39.         if not datas:
    40.             msg['code'] = password_error_code
    41.             msg['msg'] = mes.password_error_code
    42.             return JsonResponse(msg)
    43.         try:
    44.             __sfsh__= chuyaojilu.__sfsh__
    45.         except:
    46.             __sfsh__=None
    47.  
    48.         if  __sfsh__=='是':
    49.             if datas[0].get('sfsh')=='否':
    50.                 msg['code']=other_code
    51.                 msg['msg'] = "账号已锁定，请联系管理员审核!"
    52.                 return JsonResponse(msg)
    53.                 
    54.         req_dict['id'] = datas[0].get('id')
    55.         return Auth.authenticate(Auth, chuyaojilu, req_dict)
    56.  
    57.  
    58. def chuyaojilu_logout(request):
    59.     if request.method in ["POST", "GET"]:
    60.         msg = {
    61.             "msg": "登出成功",
    62.             "code": 0
    63.         }
    64.  
    65.         return JsonResponse(msg)
    66.  
    67.  
    68. def chuyaojilu_resetPass(request):
    69.     '''
    70.     '''
    71.     if request.method in ["POST", "GET"]:
    72.         msg = {"code": normal_code, "msg": mes.normal_code}
    73.  
    74.         req_dict = request.session.get("req_dict")
    75.  
    76.         columns=  chuyaojilu.getallcolumn( chuyaojilu, chuyaojilu)
    77.  
    78.         try:
    79.             __loginUserColumn__= chuyaojilu.__loginUserColumn__
    80.         except:
    81.             __loginUserColumn__=None
    82.         username=req_dict.get(list(req_dict.keys())[0])
    83.         if __loginUserColumn__:
    84.             username_str=__loginUserColumn__
    85.         else:
    86.             username_str=username
    87.         if 'mima' in columns:
    88.             password_str='mima'
    89.         else:
    90.             password_str='password'
    91.  
    92.         init_pwd = '123456'
    93.         init_pwd = Common.md5(Common, init_pwd)
    94.         recordsParam = {}
    95.         recordsParam[username_str] = req_dict.get("username")
    96.         records=chuyaojilu.getbyparams(chuyaojilu, chuyaojilu, recordsParam)
    97.         if len(records)<1:
    98.             msg['code'] = 400
    99.             msg['msg'] = '用户不存在'
    100.             return JsonResponse(msg)
    101.  
    102.         eval('''chuyaojilu.objects.filter({}='{}').update({}='{}')'''.format(username_str,username,password_str,init_pwd))
    103.         
    104.         return JsonResponse(msg)
    105.  
    106.  
    107.  
    108. def chuyaojilu_session(request):
    109.     '''
    110.     '''
    111.     if request.method in ["POST", "GET"]:
    112.         msg = {"code": normal_code,"msg": mes.normal_code, "data": {}}
    113.  
    114.         req_dict={"id":request.session.get('params').get("id")}
    115.         msg['data']  = chuyaojilu.getbyparams(chuyaojilu, chuyaojilu, req_dict)[0]
    116.  
    117.         return JsonResponse(msg)
    118.  
    119.  
    120. def chuyaojilu_default(request):
    121.  
    122.     if request.method in ["POST", "GET"]:
    123.         msg = {"code": normal_code,"msg": mes.normal_code, "data": {}}
    124.         req_dict = request.session.get("req_dict")
    125.         req_dict.update({"isdefault":"是"})
    126.         data=chuyaojilu.getbyparams(chuyaojilu, chuyaojilu, req_dict)
    127.         if len(data)>0:
    128.             msg['data']  = data[0]
    129.         else:
    130.             msg['data']  = {}
    131.         return JsonResponse(msg)
    132.  
    133. def chuyaojilu_page(request):
    134.     '''
    135.     '''
    136.     if request.method in ["POST", "GET"]:
    137.         msg = {"code": normal_code, "msg": mes.normal_code,  "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
    138.         req_dict = request.session.get("req_dict")
    139.  
    140.         #获取全部列名
    141.         columns=  chuyaojilu.getallcolumn( chuyaojilu, chuyaojilu)
    142.  
    143.         #当前登录用户所在表
    144.         tablename = request.session.get("tablename")
    145.  
    146.  
    147.             #authColumn=list(__authTables__.keys())[0]
    148.             #authTable=__authTables__.get(authColumn)
    149.  
    150.             # if authTable==tablename:
    151.                 #params = request.session.get("params")
    152.                 #req_dict[authColumn]=params.get(authColumn)
    153.  
    154.         '''__authSeparate__此属性为真，params添加userid，后台只查询个人数据'''
    155.         try:
    156.             __authSeparate__=chuyaojilu.__authSeparate__
    157.         except:
    158.             __authSeparate__=None
    159.  
    160.         if __authSeparate__=="是":
    161.             tablename=request.session.get("tablename")
    162.             if tablename!="users" and 'userid' in columns:
    163.                 try:
    164.                     req_dict['userid']=request.session.get("params").get("id")
    165.                 except:
    166.                     pass
    167.  
    168.         #当项目属性hasMessage为”是”，生成系统自动生成留言板的表messages，同时该表的表属性hasMessage也被设置为”是”,字段包括userid（用户id），username(用户名)，content（留言内容），reply（回复）
    169.         #接口page需要区分权限，普通用户查看自己的留言和回复记录，管理员查看所有的留言和回复记录
    170.         try:
    171.             __hasMessage__=chuyaojilu.__hasMessage__
    172.         except:
    173.             __hasMessage__=None
    174.         if  __hasMessage__=="是":
    175.             tablename=request.session.get("tablename")
    176.             if tablename!="users":
    177.                 req_dict["userid"]=request.session.get("params").get("id")
    178.  
    179.  
    180.  
    181.         # 判断当前表的表属性isAdmin,为真则是管理员表
    182.         # 当表属性isAdmin=”是”,刷出来的用户表也是管理员，即page和list可以查看所有人的考试记录(同时应用于其他表)
    183.         __isAdmin__ = None
    184.  
    185.         allModels = apps.get_app_config('main').get_models()
    186.         for m in allModels:
    187.             if m.__tablename__==tablename:
    188.  
    189.                 try:
    190.                     __isAdmin__ = m.__isAdmin__
    191.                 except:
    192.                     __isAdmin__ = None
    193.                 break
    194.  
    195.         # 当前表也是有管理员权限的表
    196.         if  __isAdmin__ == "是" and 'chuyaojilu' != 'forum':
    197.             if req_dict.get("userid"):
    198.                 del req_dict["userid"]
    199.  
    200.         else:
    201.             #非管理员权限的表,判断当前表字段名是否有userid
    202.             if tablename!="users" and 'chuyaojilu'[:7]!='discuss'and "userid" in chuyaojilu.getallcolumn(chuyaojilu,chuyaojilu):
    203.                 req_dict["userid"] = request.session.get("params").get("id")
    204.  
    205.         #当列属性authTable有值(某个用户表)[该列的列名必须和该用户表的登陆字段名一致]，则对应的表有个隐藏属性authTable为”是”，那么该用户查看该表信息时，只能查看自己的
    206.         try:
    207.             __authTables__=chuyaojilu.__authTables__
    208.         except:
    209.             __authTables__=None
    210.  
    211.         if __authTables__!=None and  __authTables__!={}:
    212.             try:
    213.                 del req_dict['userid']
    214.             except:
    215.                 pass
    216.             for authColumn,authTable in __authTables__.items():
    217.                 if authTable==tablename:
    218.                     params = request.session.get("params")
    219.                     req_dict[authColumn]=params.get(authColumn)
    220.                     username=params.get(authColumn)
    221.                     break
    222.  
    223.         q = Q()
    224.  
    225.         msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
    226.         msg['data']['pageSize']  =chuyaojilu.page(chuyaojilu, chuyaojilu, req_dict, request, q)
    227.  
    228.         return JsonResponse(msg)
    229.  
    230. def chuyaojilu_autoSort(request):
    231.     '''
    232.     ．智能推荐功能(表属性：[intelRecom（是/否）],新增clicktime[前端不显示该字段]字段（调用info/detail接口的时候更新），按clicktime排序查询)
    233. 主要信息列表（如商品列表，新闻列表）中使用，显示最近点击的或最新添加的5条记录就行
    234.     '''
    235.     if request.method in ["POST", "GET"]:
    236.         msg = {"code": normal_code, "msg": mes.normal_code,  "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
    237.         req_dict = request.session.get("req_dict")
    238.         if "clicknum"  in chuyaojilu.getallcolumn(chuyaojilu,chuyaojilu):
    239.             req_dict['sort']='clicknum'
    240.         else:
    241.             req_dict['sort']='clicktime'
    242.         req_dict['order']='desc'
    243.         msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
    244.         msg['data']['pageSize']  = chuyaojilu.page(chuyaojilu,chuyaojilu, req_dict)
    245.  
    246.         return JsonResponse(msg)
    247.  
    248.  
    249. def chuyaojilu_list(request):
    250.     '''
    251.     前台分页
    252.     '''
    253.     if request.method in ["POST", "GET"]:
    254.         msg = {"code": normal_code, "msg": mes.normal_code,  "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
    255.         req_dict = request.session.get("req_dict")
    256.  
    257.         #获取全部列名
    258.         columns=  chuyaojilu.getallcolumn( chuyaojilu, chuyaojilu)
    259.         #表属性[foreEndList]前台list:和后台默认的list列表页相似,只是摆在前台,否:指没有此页,是:表示有此页(不需要登陆即可查看),前要登:表示有此页且需要登陆后才能查看
    260.         try:
    261.             __foreEndList__=chuyaojilu.__foreEndList__
    262.         except:
    263.             __foreEndList__=None
    264.  
    265.         if __foreEndList__=="前要登":
    266.             tablename=request.session.get("tablename")
    267.             if tablename!="users" and 'userid' in columns:
    268.                 try:
    269.                     req_dict['userid']=request.session.get("params").get("id")
    270.                 except:
    271.                     pass
    272.         #forrEndListAuth
    273.         try:
    274.             __foreEndListAuth__=chuyaojilu.__foreEndListAuth__
    275.         except:
    276.             __foreEndListAuth__=None
    277.  
    278.  
    279.         #authSeparate
    280.         try:
    281.             __authSeparate__=chuyaojilu.__authSeparate__
    282.         except:
    283.             __authSeparate__=None
    284.  
    285.         if __foreEndListAuth__ =="是" and __authSeparate__=="是":
    286.             tablename=request.session.get("tablename")
    287.             if tablename!="users":
    288.                 req_dict['userid']=request.session.get("params",{"id":0}).get("id")
    289.  
    290.         tablename = request.session.get("tablename")
    291.         if tablename == "users" and req_dict.get("userid") != None:#判断是否存在userid列名
    292.             del req_dict["userid"]
    293.         else:
    294.             __isAdmin__ = None
    295.  
    296.             allModels = apps.get_app_config('main').get_models()
    297.             for m in allModels:
    298.                 if m.__tablename__==tablename:
    299.  
    300.                     try:
    301.                         __isAdmin__ = m.__isAdmin__
    302.                     except:
    303.                         __isAdmin__ = None
    304.                     break
    305.  
    306.             if __isAdmin__ == "是":
    307.                 if req_dict.get("userid"):
    308.                     del req_dict["userid"]
    309.             else:
    310.                 #非管理员权限的表,判断当前表字段名是否有userid
    311.                 if "userid" in columns:
    312.                     try:
    313.                         pass
    314.                         # 本接口可以匿名访问,所以try判断是否为匿名
    315.                         #req_dict['userid']=request.session.get("params").get("id")
    316.                     except:
    317.                             pass
    318.         #当列属性authTable有值(某个用户表)[该列的列名必须和该用户表的登陆字段名一致]，则对应的表有个隐藏属性authTable为”是”，那么该用户查看该表信息时，只能查看自己的
    319.         try:
    320.             __authTables__=chuyaojilu.__authTables__
    321.         except:
    322.             __authTables__=None
    323.  
    324.         if __authTables__!=None and  __authTables__!={} and __foreEndListAuth__=="是":
    325.             try:
    326.                 del req_dict['userid']
    327.             except:
    328.                 pass
    329.             for authColumn,authTable in __authTables__.items():
    330.                 if authTable==tablename:
    331.                     params = request.session.get("params")
    332.                     req_dict[authColumn]=params.get(authColumn)
    333.                     username=params.get(authColumn)
    334.                     break
    335.         
    336.         if chuyaojilu.__tablename__[:7]=="discuss":
    337.             try:
    338.                 del req_dict['userid']
    339.             except:
    340.                 pass
    341.  
    342.  
    343.         q = Q()
    344.  
    345.         msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
    346.         msg['data']['pageSize']  = chuyaojilu.page(chuyaojilu, chuyaojilu, req_dict, request, q)
    347.  
    348.         return JsonResponse(msg)
    349.  
    350. def chuyaojilu_save(request):
    351.     '''
    352.     后台新增
    353.     '''
    354.     if request.method in ["POST", "GET"]:
    355.         msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
    356.         req_dict = request.session.get("req_dict")
    357.         if 'clicktime' in req_dict.keys():
    358.             del req_dict['clicktime']
    359.         tablename=request.session.get("tablename")
    360.         __isAdmin__ = None
    361.         allModels = apps.get_app_config('main').get_models()
    362.         for m in allModels:
    363.             if m.__tablename__==tablename:
    364.  
    365.                 try:
    366.                     __isAdmin__ = m.__isAdmin__
    367.                 except:
    368.                     __isAdmin__ = None
    369.                 break
    370.  
    371.  
    372.         #获取全部列名
    373.         columns=  chuyaojilu.getallcolumn( chuyaojilu, chuyaojilu)
    374.         if tablename!='users' and req_dict.get("userid")!=None and 'userid' in columns  and __isAdmin__!='是':
    375.             params=request.session.get("params")
    376.             req_dict['userid']=params.get('id')
    377.  
    378.  
    379.         error= chuyaojilu.createbyreq(chuyaojilu,chuyaojilu, req_dict)
    380.         if error!=None:
    381.             msg['code'] = crud_error_code
    382.             msg['msg'] = error
    383.  
    384.         return JsonResponse(msg)
    385.  
    386.  
    387. def chuyaojilu_add(request):
    388.     '''
    389.     前台新增
    390.     '''
    391.     if request.method in ["POST", "GET"]:
    392.         msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
    393.         req_dict = request.session.get("req_dict")
    394.  
    395.         #获取全部列名
    396.         columns=  chuyaojilu.getallcolumn( chuyaojilu, chuyaojilu)
    397.         try:
    398.             __authSeparate__=chuyaojilu.__authSeparate__
    399.         except:
    400.             __authSeparate__=None
    401.  
    402.         if __authSeparate__=="是":
    403.             tablename=request.session.get("tablename")
    404.             if tablename!="users" and 'userid' in columns:
    405.                 try:
    406.                     req_dict['userid']=request.session.get("params").get("id")
    407.                 except:
    408.                     pass
    409.  
    410.         try:
    411.             __foreEndListAuth__=chuyaojilu.__foreEndListAuth__
    412.         except:
    413.             __foreEndListAuth__=None
    414.  
    415.         if __foreEndListAuth__ and __foreEndListAuth__!="否":
    416.             tablename=request.session.get("tablename")
    417.             if tablename!="users":
    418.                 req_dict['userid']=request.session.get("params").get("id")
    419.  
    420.         error= chuyaojilu.createbyreq(chuyaojilu,chuyaojilu, req_dict)
    421.         if error!=None:
    422.             msg['code'] = crud_error_code
    423.             msg['msg'] = error
    424.         return JsonResponse(msg)
    425.  
    426. def chuyaojilu_thumbsup(request,id_):
    427.     '''
    428.      点赞：表属性thumbsUp[是/否]，刷表新增thumbsupnum赞和crazilynum踩字段，
    429.     '''
    430.     if request.method in ["POST", "GET"]:
    431.         msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
    432.         req_dict = request.session.get("req_dict")
    433.         id_=int(id_)
    434.         type_=int(req_dict.get("type",0))
    435.         rets=chuyaojilu.getbyid(chuyaojilu,chuyaojilu,id_)
    436.  
    437.         update_dict={
    438.         "id":id_,
    439.         }
    440.         if type_==1:#赞
    441.             update_dict["thumbsupnum"]=int(rets[0].get('thumbsupnum'))+1
    442.         elif type_==2:#踩
    443.             update_dict["crazilynum"]=int(rets[0].get('crazilynum'))+1
    444.         error = chuyaojilu.updatebyparams(chuyaojilu,chuyaojilu, update_dict)
    445.         if error!=None:
    446.             msg['code'] = crud_error_code
    447.             msg['msg'] = error
    448.         return JsonResponse(msg)
    449.  
    450.  
    451. def chuyaojilu_info(request,id_):
    452.     '''
    453.     '''
    454.     if request.method in ["POST", "GET"]:
    455.         msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
    456.  
    457.         data = chuyaojilu.getbyid(chuyaojilu,chuyaojilu, int(id_))
    458.         if len(data)>0:
    459.             msg['data']=data[0]
    460.         #浏览点击次数
    461.         try:
    462.             __browseClick__= chuyaojilu.__browseClick__
    463.         except:
    464.             __browseClick__=None
    465.  
    466.         if __browseClick__=="是"  and  "clicknum"  in chuyaojilu.getallcolumn(chuyaojilu,chuyaojilu):
    467.             try:
    468.                 clicknum=int(data[0].get("clicknum",0))+1
    469.             except:
    470.                 clicknum=0+1
    471.             click_dict={"id":int(id_),"clicknum":clicknum}
    472.             ret=chuyaojilu.updatebyparams(chuyaojilu,chuyaojilu,click_dict)
    473.             if ret!=None:
    474.                 msg['code'] = crud_error_code
    475.                 msg['msg'] = ret
    476.         return JsonResponse(msg)
    477.  
    478. def chuyaojilu_detail(request,id_):
    479.     '''
    480.     '''
    481.     if request.method in ["POST", "GET"]:
    482.         msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
    483.  
    484.         data =chuyaojilu.getbyid(chuyaojilu,chuyaojilu, int(id_))
    485.         if len(data)>0:
    486.             msg['data']=data[0]
    487.  
    488.         #浏览点击次数
    489.         try:
    490.             __browseClick__= chuyaojilu.__browseClick__
    491.         except:
    492.             __browseClick__=None
    493.  
    494.         if __browseClick__=="是"   and  "clicknum"  in chuyaojilu.getallcolumn(chuyaojilu,chuyaojilu):
    495.             try:
    496.                 clicknum=int(data[0].get("clicknum",0))+1
    497.             except:
    498.                 clicknum=0+1
    499.             click_dict={"id":int(id_),"clicknum":clicknum}
    500.  
    501.             ret=chuyaojilu.updatebyparams(chuyaojilu,chuyaojilu,click_dict)
    502.             if ret!=None:
    503.                 msg['code'] = crud_error_code
    504.                 msg['msg'] = retfo
    505.         return JsonResponse(msg)
    506.  
    507.  
    508. def chuyaojilu_update(request):
    509.     '''
    510.     '''
    511.     if request.method in ["POST", "GET"]:
    512.         msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
    513.         req_dict = request.session.get("req_dict")
    514.         if req_dict.get("mima") and req_dict.get("password"):
    515.             if "mima" not  in chuyaojilu.getallcolumn(chuyaojilu,chuyaojilu) :
    516.                 del req_dict["mima"]
    517.             if  "password" not  in chuyaojilu.getallcolumn(chuyaojilu,chuyaojilu) :
    518.                 del req_dict["password"]
    519.         try:
    520.             del req_dict["clicknum"]
    521.         except:
    522.             pass
    523.  
    524.  
    525.         error = chuyaojilu.updatebyparams(chuyaojilu, chuyaojilu, req_dict)
    526.         if error!=None:
    527.             msg['code'] = crud_error_code
    528.             msg['msg'] = error
    529.  
    530.         return JsonResponse(msg)
    531.  
    532.  
    533. def chuyaojilu_delete(request):
    534.     '''
    535.     批量删除
    536.     '''
    537.     if request.method in ["POST", "GET"]:
    538.         msg = {"code": normal_code, "msg": mes.normal_code, "data": {}}
    539.         req_dict = request.session.get("req_dict")
    540.  
    541.         error=chuyaojilu.deletes(chuyaojilu,
    542.             chuyaojilu,
    543.              req_dict.get("ids")
    544.         )
    545.         if error!=None:
    546.             msg['code'] = crud_error_code
    547.             msg['msg'] = error
    548.         return JsonResponse(msg)
    549.  
    550.  
    551. def chuyaojilu_vote(request,id_):
    552.     '''
    553.     浏览点击次数（表属性[browseClick:是/否]，点击字段（clicknum），调用info/detail接口的时候后端自动+1）、投票功能（表属性[vote:是/否]，投票字段（votenum）,调用vote接口后端votenum+1）
    554. 统计商品或新闻的点击次数；提供新闻的投票功能
    555.     '''
    556.     if request.method in ["POST", "GET"]:
    557.         msg = {"code": normal_code, "msg": mes.normal_code}
    558.  
    559.  
    560.         data= chuyaojilu.getbyid(chuyaojilu, chuyaojilu, int(id_))
    561.         for i in data:
    562.             votenum=i.get('votenum')
    563.             if votenum!=None:
    564.                 params={"id":int(id_),"votenum":votenum+1}
    565.                 error=chuyaojilu.updatebyparams(chuyaojilu,chuyaojilu,params)
    566.                 if error!=None:
    567.                     msg['code'] = crud_error_code
    568.                     msg['msg'] = error
    569.         return JsonResponse(msg)
    570.  
    571. def chuyaojilu_importExcel(request):
    572.     if request.method in ["POST", "GET"]:
    573.         msg = {"code": normal_code, "msg": "成功", "data": {}}
    574.  
    575.         excel_file = request.FILES.get("file", "")
    576.         file_type = excel_file.name.split('.')[1]
    577.         
    578.         if file_type in ['xlsx', 'xls']:
    579.             data = xlrd.open_workbook(filename=None, file_contents=excel_file.read())
    580.             table = data.sheets()[0]
    581.             rows = table.nrows
    582.             
    583.             try:
    584.                 for row in range(1, rows):
    585.                     row_values = table.row_values(row)
    586.                     req_dict = {}
    587.                     chuyaojilu.createbyreq(chuyaojilu, chuyaojilu, req_dict)
    588.                     
    589.             except:
    590.                 pass
    591.                 
    592.         else:
    593.             msg.code = 500
    594.             msg.msg = "文件类型错误"
    595.                 
    596.         return JsonResponse(msg)
    597.  
    598. def chuyaojilu_sendemail(request):
    599.     if request.method in ["POST", "GET"]:
    600.         req_dict = request.session.get("req_dict")
    601.  
    602.         code = random.sample(['0', '1', '2', '3', '4', '5', '6', '7', '8', '9'], 4)
    603.         to = []
    604.         to.append(req_dict['email'])
    605.  
    606.         send_mail('用户注册', '您的注册验证码是【'+''.join(code)+'】，请不要把验证码泄漏给其他人，如非本人请勿操作。', 'yclw9@qq.com', to, fail_silently = False)
    607.  
    608.         cursor = connection.cursor()
    609.         cursor.execute("insert into emailregistercode(email,role,code) values('"+req_dict['email']+"','用户','"+''.join(code)+"')")
    610.  
    611.         msg = {
    612.             "msg": "发送成功",
    613.             "code": 0
    614.         }
    615.  
    616.         return JsonResponse(msg)
    617.  
    618. def chuyaojilu_autoSort2(request):
    619.     
    620.     if request.method in ["POST", "GET"]:
    621.         req_dict = request.session.get("req_dict")
    622.         cursor = connection.cursor()
    623.         leixing = set()
    624.         try:
    625.             cursor.execute("select inteltype from storeup where userid = %d"%(request.session.get("params").get("id"))+" and tablename = 'chuyaojilu' order by addtime desc")
    626.             rows = cursor.fetchall()
    627.             for row in rows:
    628.                 for item in row:
    629.                     if item != None:
    630.                         leixing.add(item)
    631.         except:
    632.             leixing = set()
    633.         
    634.         L = []
    635.         cursor.execute("select * from chuyaojilu where $intelRecomColumn in ('%s"%("','").join(leixing)+"') union all select * from chuyaojilu where $intelRecomColumn not in('%s"%("','").join(leixing)+"')")
    636.         desc = cursor.description
    637.         data_dict = [dict(zip([col[0] for col in desc], row)) for row in cursor.fetchall()] 
    638.         for online_dict in data_dict:
    639.             for key in online_dict:
    640.                 if 'datetime.datetime' in str(type(online_dict[key])):
    641.                     online_dict[key] = online_dict[key].strftime(
    642.                         "%Y-%m-%d %H:%M:%S")
    643.                 else:
    644.                     pass
    645.             L.append(online_dict)
    646.  
    647.  
    648.         return JsonResponse({"code": 0, "msg": '',  "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":5,"list": L[0:6]}})
    649.  
    650. def chuyaojilu_value(request, xColumnName, yColumnName, timeStatType):
    651.     if request.method in ["POST", "GET"]:
    652.         msg = {"code": normal_code, "msg": "成功", "data": {}}
    653.         
    654.         where = ' where 1 = 1 '
    655.         token = request.META.get('HTTP_TOKEN')
    656.         decode_str = eval(base64.b64decode(token).decode("utf8"))
    657.         if decode_str['tablename'] != 'users':
    658.             where = where + " and xingming ='{0}' ".format(decode_str['params']['xingming'])
    659.         sql = ''
    660.         if timeStatType == '日':
    661.             sql = "SELECT DATE_FORMAT({0}, '%Y-%m-%d') {0}, sum({1}) total FROM chuyaojilu {2} GROUP BY DATE_FORMAT({0}, '%Y-%m-%d')".format(xColumnName, yColumnName, where, '%Y-%m-%d')
    662.  
    663.         if timeStatType == '月':
    664.             sql = "SELECT DATE_FORMAT({0}, '%Y-%m') {0}, sum({1}) total FROM chuyaojilu {2} GROUP BY DATE_FORMAT({0}, '%Y-%m')".format(xColumnName, yColumnName, where, '%Y-%m')
    665.  
    666.         if timeStatType == '年':
    667.             sql = "SELECT DATE_FORMAT({0}, '%Y') {0}, sum({1}) total FROM chuyaojilu {2} GROUP BY DATE_FORMAT({0}, '%Y')".format(xColumnName, yColumnName, where, '%Y')
    668.         L = []
    669.         cursor = connection.cursor()
    670.         cursor.execute(sql)
    671.         desc = cursor.description
    672.         data_dict = [dict(zip([col[0] for col in desc], row)) for row in cursor.fetchall()] 
    673.         for online_dict in data_dict:
    674.             for key in online_dict:
    675.                 if 'datetime.datetime' in str(type(online_dict[key])):
    676.                     online_dict[key] = online_dict[key].strftime(
    677.                         "%Y-%m-%d %H:%M:%S")
    678.                 else:
    679.                     pass
    680.             L.append(online_dict)
    681.         msg['data'] = L
    682.  
    683.         return JsonResponse(msg)
    684.  
    685. def chuyaojilu_o_value(request, xColumnName, yColumnName):
    686.     if request.method in ["POST", "GET"]:
    687.         msg = {"code": normal_code, "msg": "成功", "data": {}}
    688.         
    689.         where = ' where 1 = 1 '
    690.         token = request.META.get('HTTP_TOKEN')
    691.         decode_str = eval(base64.b64decode(token).decode("utf8"))
    692.         if decode_str['tablename'] != 'users':
    693.             where = where + " and xingming ='{0}' ".format(decode_str['params']['xingming'])
    694.         
    695.         sql = "SELECT {0}, sum({1}) AS total FROM chuyaojilu {2} GROUP BY {0}".format(xColumnName, yColumnName, where)
    696.         L = []
    697.         cursor = connection.cursor()
    698.         cursor.execute(sql)
    699.         desc = cursor.description
    700.         data_dict = [dict(zip([col[0] for col in desc], row)) for row in cursor.fetchall()] 
    701.         for online_dict in data_dict:
    702.             for key in online_dict:
    703.                 if 'datetime.datetime' in str(type(online_dict[key])):
    704.                     online_dict[key] = online_dict[key].strftime(
    705.                         "%Y-%m-%d %H:%M:%S")
    706.                 else:
    707.                     pass
    708.             L.append(online_dict)
    709.         msg['data'] = L
    710.  
    711.         return JsonResponse(msg)
    712.  
    713.  
    714.  
    715.  
    716.

    五，相关作品展示

    基于Java开发、Python开发、PHP开发、C#开发等相关语言开发的实战项目

    基于Nodejs、Vue等前端技术开发的前端实战项目

    基于微信小程序和安卓APP应用开发的相关作品

    基于51单片机等嵌入式物联网开发应用

    基于各类算法实现的AI智能应用

    基于大数据实现的各类数据管理和推荐系统

     

     

  • 相关阅读:
    python：xml.etree.ElementTree 读 Freeplane.mm文件，生成测试案例.csv文件
    财神爷直播间 不露脸直播间搭建素材和教程
    【数据分享】2023年全国地级市点位数据（免费获取\shp格式\excel格式）
    Go with Protobuf
    目标检测算法——安全帽识别数据集（附下载链接）
    C. Add One--Divide by Zero 2021 and Codeforces Round #714 (Div. 2)
    Nautilus Chain上线主网，为DeFi和流支付的未来构建基础
    纯前端个人主页分享
    CarSim仿真快速入门(十八)-CarSim2021中的混合动力和纯电动系统
    java计算机毕业设计框架的电脑测评系统源码+数据库+lw文档+系统
  • 原文地址：https://blog.csdn.net/BS009/article/details/141086055