devbox
在线问答5
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

基于Python实现校园影院平台系统[源码+LW+部署讲解视频]

作者：在线问答5 | 2024-08-28 14:09:17

赞

踩

基于Python实现校园影院平台系统[源码+LW+部署讲解视频]

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

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

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

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

文末获取源码 

项目编号：BS-Python-070

一，环境介绍

语言环境：Python3.8

数据库：Mysql: mysql5.7

WEB框架：Django

开发工具：IDEA或PyCharm

项目获取地址：基于Python实现校园影院

二，项目简介

随着社会的不断进步与发展，人们对生活质量要求逐步提升。如果开发一款柚子校园影院，可以让管理员和用户在最短的时间里享受到最好的服务；而开发本系统，又能够提高系统整体工作水平，简化工作程序，这对管理员和用户来说都是一件非常乐意的事情。

本论文针对柚子校园影院的特点，以Python为核心，以MySQL为数据库，B/S为系统构架，对柚子校园影院进行设计和开发。通过使用本系统可有效地减少运营成本，提高管理效率。

20世纪，随着科学技术的飞速发展，数字化和信息化成为了一个新的发展趋势，信息化的管理方式成为了各个行业的追求的目标，而信息化的管理方式更是成为了人们追求的目标。目前，我国高等院校工程技术和电子管理学已经将信息化技术作为必修课。

在当今社会，人们的生活节奏逐渐加快，人们对经济的要求逐渐降低，越来越多的人开始追求简单、快捷的方式。随着经济的发展，人民的生活水平也提高了，用户有了更多的时间去消费。然而，柚子校园影院管理模式的改进却是一项比较繁杂的工作，因此，管理人员要充分发挥信息化管理的作用，提高柚子校园影院的整体管理能力和整体素质。

在科技飞速发展的今天，柚子校园影院管理体系已全面更新，管理体系的更新，不但能让用户享受到更为高品质的服务，同时也能提升柚子校园影院管理的工作效率。通过管理上的便利，使管理上也更加有序。然而，当前大多仍采用大规模的人工管理方式，这种管理方式耗费了较多的人力物力，而且很难维持。而本系统要采用一种易于使用、处理速度快、计算准确且适应的服务需求的经营模式。这种新型的经营管理体系将有助于今后的发展，改进当前的经营状况，提升用户的工作效率，同时为柚子校园影院创造更高的效率。

功能模块设计

三，系统展示

前端页面

后台管理员

四，核心代码展示

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

五，相关作品展示

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

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

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

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

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

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

 

 

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/在线问答5/article/detail/1021751
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号