作者简介:Java、前端、Python开发多年,做过高程,项目经理,架构师
主要内容:Java项目开发、Python项目开发、大学数据和AI项目开发、单片机项目设计、面试技术整理、最新技术分享
收藏点赞不迷路 关注作者有好处
文末获得源码
项目编号:BS-Python-063
一,环境介绍
语言环境:Python3.8
数据库:Mysql: mysql5.7
WEB框架:Django
爬虫框架:Scrapy
开发工具:IDEA或PyCharm
项目获取地址:旅游景点推荐系统
直接访问地址:
https://gf.bilibili.com/item/detail/1105853061
二,项目简介
通过对旅游景点推荐内容的学习研究,进而设计并实现一个旅游景点推荐系统。系统能实现的主要功能应包括景点信息、景区门票的一些操作。还有可以正确的为用户服务,准确显示当前信息。
在旅游景点推荐系统的前期,即需求分析阶段,我们对旅游景点推荐的需求进行了详细的描述,并且在需求规范中有详细的描述和阐明。根据系统需求的分析,对旅游景点推荐的管理进行了整体的设计。着重对软件模块的设计进行了详细的分析,以达到对系统的需求。重点阐述了系统的划分、接口的确定、各模块间的数据传输、数据结构与模块结构的设计。在下面的概要设计中,将会详细地描述这个阶段中的系统。
管理员用例:
用户用例:
系统功能架构图如下所示:
三,系统展示
前端页面实现
后端管理员功能展示
四,核心代码展示
# coding:utf-8
__author__ = "ila"
import logging, os, xlrd, json
from flask import request, jsonify,session
from sqlalchemy.sql import func,and_,or_
from api.models.brush_model import *
from . import main_bp
from utils.codes import *
from utils.jwt_auth import Auth
from configs import configs
from utils.helper import *
import random
import smtplib
from email.mime.text import MIMEText
from email.header import Header
from utils.baidubce_api import BaiDuBce
from api.models.config_model import config
# 注册接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/register", methods=['POST'])
def python1s2c1_discussjingdianxinxi_register():
if request.method == 'POST':
msg = {'code': normal_code, 'message': 'success', 'data': [{}]}
req_dict = session.get("req_dict")
error = discussjingdianxinxi.createbyreq(discussjingdianxinxi, discussjingdianxinxi, req_dict)
if error!=None:
msg['code'] = crud_error_code
msg['msg'] = "注册用户已存在"
return jsonify(msg)
# 登录接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/login", methods=['GET','POST'])
def python1s2c1_discussjingdianxinxi_login():
if request.method == 'GET' or request.method == 'POST':
msg = {"code": normal_code, "msg": "success", "data": {}}
req_dict = session.get("req_dict")
req_model = session.get("req_dict")
try:
del req_model['role']
except:
pass
datas = discussjingdianxinxi.getbyparams(discussjingdianxinxi, discussjingdianxinxi, req_model)
if not datas:
msg['code'] = password_error_code
msg['msg']='密码错误或用户不存在'
return jsonify(msg)
req_dict['id'] = datas[0].get('id')
return Auth.authenticate(Auth, discussjingdianxinxi, req_dict)
# 登出接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/logout", methods=['POST'])
def python1s2c1_discussjingdianxinxi_logout():
if request.method == 'POST':
msg = {
"msg": "退出成功",
"code": 0
}
req_dict = session.get("req_dict")
return jsonify(msg)
# 重置密码接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/resetPass", methods=['POST'])
def python1s2c1_discussjingdianxinxi_resetpass():
'''
'''
if request.method == 'POST':
msg = {"code": normal_code, "msg": "success"}
req_dict = session.get("req_dict")
if req_dict.get('mima') != None:
req_dict['mima'] = '123456'
error = discussjingdianxinxi.updatebyparams(discussjingdianxinxi, discussjingdianxinxi, req_dict)
if error != None:
msg['code'] = crud_error_code
msg['msg'] = error
else:
msg['msg'] = '密码已重置为:123456'
return jsonify(msg)
# 获取会话信息接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/session", methods=['GET'])
def python1s2c1_discussjingdianxinxi_session():
'''
'''
if request.method == 'GET':
msg = {"code": normal_code, "data": {}}
req_dict={"id":session.get('params').get("id")}
msg['data'] = discussjingdianxinxi.getbyparams(discussjingdianxinxi, discussjingdianxinxi, req_dict)[0]
return jsonify(msg)
# 分类接口(后端)
@main_bp.route("/python1s2c1/discussjingdianxinxi/page", methods=['GET'])
def python1s2c1_discussjingdianxinxi_page():
'''
'''
if request.method == 'GET':
msg = {"code": normal_code, "msg": "success", "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
req_dict = session.get("req_dict")
userinfo = session.get("params")
try:
__hasMessage__=discussjingdianxinxi.__hasMessage__
except:
__hasMessage__=None
if __hasMessage__ and __hasMessage__!="否":
tablename=session.get("tablename")
if tablename!="users" and session.get("params")!=None and discussjingdianxinxi!='chat':
req_dict["userid"]=session.get("params").get("id")
tablename=session.get("tablename")
if tablename=="users" :
try:
pass
except:
pass
else:
mapping_str_to_object = {}
for model in Base_model._decl_class_registry.values():
if hasattr(model, '__tablename__'):
mapping_str_to_object[model.__tablename__] = model
try:
__isAdmin__=mapping_str_to_object[tablename].__isAdmin__
except:
__isAdmin__=None
if __isAdmin__!="是" and session.get("params")!=None:
req_dict["userid"]=session.get("params").get("id")
else:
try:
del req_dict["userid"]
except:
pass
clause_args = []
or_clauses = or_(*clause_args)
msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
msg['data']['pageSize'] = discussjingdianxinxi.page(discussjingdianxinxi, discussjingdianxinxi, req_dict, or_clauses)
return jsonify(msg)
# 排序接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/autoSort", methods=['GET'])
def python1s2c1_discussjingdianxinxi_autosort():
'''
'''
if request.method == 'GET':
msg = {"code": normal_code, "msg": "success", "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
req_dict = session.get("req_dict")
req_dict['sort']='clicktime'
req_dict['order']='desc'
try:
__browseClick__= discussjingdianxinxi.__browseClick__
except:
__browseClick__=None
if __browseClick__ =='是':
req_dict['sort']='clicknum'
elif __browseClick__ =='时长':
req_dict['sort']='browseduration'
else:
req_dict['sort']='clicktime'
msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
msg['data']['pageSize'] = discussjingdianxinxi.page(discussjingdianxinxi, discussjingdianxinxi, req_dict)
return jsonify(msg)
# 分页接口(前端)
@main_bp.route("/python1s2c1/discussjingdianxinxi/list", methods=['GET'])
def python1s2c1_discussjingdianxinxi_list():
'''
'''
if request.method == 'GET':
msg = {"code": normal_code, "msg": "success", "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
req_dict = session.get("req_dict")
if req_dict.__contains__('vipread'):
del req_dict['vipread']
userinfo = session.get("params")
try:
__foreEndList__=discussjingdianxinxi.__foreEndList__
except:
__foreEndList__=None
if __foreEndList__ and __foreEndList__!="否":
tablename=session.get("tablename")
if tablename!="users" and session.get("params")!=None:
req_dict['userid']=session.get("params").get("id")
try:
__foreEndListAuth__=discussjingdianxinxi.__foreEndListAuth__
except:
__foreEndListAuth__=None
if __foreEndListAuth__ and __foreEndListAuth__!="否":
tablename=session.get("tablename")
if tablename!="users" and session.get("params")!=None:
req_dict['userid']=session.get("params").get("id")
tablename=session.get("tablename")
if tablename=="users" :
try:
del req_dict["userid"]
except:
pass
else:
mapping_str_to_object = {}
for model in Base_model._decl_class_registry.values():
if hasattr(model, '__tablename__'):
mapping_str_to_object[model.__tablename__] = model
try:
__isAdmin__=mapping_str_to_object[tablename].__isAdmin__
except:
__isAdmin__=None
if __isAdmin__!="是" and session.get("params")!=None:
req_dict["userid"]=session.get("params").get("id")
else:
try:
del req_dict["userid"]
except:
pass
if 'luntan' in 'discussjingdianxinxi':
if 'userid' in req_dict.keys():
del req_dict["userid"]
if 'discuss' in 'discussjingdianxinxi':
if 'userid' in req_dict.keys():
del req_dict["userid"]
msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
msg['data']['pageSize'] = discussjingdianxinxi.page(discussjingdianxinxi, discussjingdianxinxi, req_dict)
return jsonify(msg)
# 保存接口(后端)
@main_bp.route("/python1s2c1/discussjingdianxinxi/save", methods=['POST'])
def python1s2c1_discussjingdianxinxi_save():
'''
'''
if request.method == 'POST':
msg = {"code": normal_code, "msg": "success", "data": {}}
req_dict = session.get("req_dict")
for key in req_dict:
if req_dict[key] == '':
req_dict[key] = None
error= discussjingdianxinxi.createbyreq(discussjingdianxinxi, discussjingdianxinxi, req_dict)
if error!=None:
msg['code'] = crud_error_code
msg['msg'] = error
return jsonify(msg)
# 添加接口(前端)
@main_bp.route("/python1s2c1/discussjingdianxinxi/add", methods=['POST'])
def python1s2c1_discussjingdianxinxi_add():
'''
'''
if request.method == 'POST':
msg = {"code": normal_code, "msg": "success", "data": {}}
req_dict = session.get("req_dict")
try:
__foreEndListAuth__=discussjingdianxinxi.__foreEndListAuth__
except:
__foreEndListAuth__=None
if __foreEndListAuth__ and __foreEndListAuth__!="否":
tablename=session.get("tablename")
if tablename!="users":
req_dict['userid']=session.get("params").get("id")
error= discussjingdianxinxi.createbyreq(discussjingdianxinxi, discussjingdianxinxi, req_dict)
if error!=None:
msg['code'] = crud_error_code
msg['msg'] = error
return jsonify(msg)
# 踩、赞接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/thumbsup/<id_>", methods=['GET'])
def python1s2c1_discussjingdianxinxi_thumbsup(id_):
'''
'''
if request.method == 'GET':
msg = {"code": normal_code, "msg": "success", "data": {}}
req_dict = session.get("req_dict")
id_=int(id_)
type_=int(req_dict.get("type",0))
rets=discussjingdianxinxi.getbyid(discussjingdianxinxi, discussjingdianxinxi,id_)
update_dict={
"id":id_,
}
if type_==1:#赞
update_dict["thumbsupnum"]=int(rets[0].get('thumbsupnum'))+1
elif type_==2:#踩
update_dict["crazilynum"]=int(rets[0].get('crazilynum'))+1
error = discussjingdianxinxi.updatebyparams(discussjingdianxinxi, discussjingdianxinxi, update_dict)
if error!=None:
msg['code'] = crud_error_code
msg['msg'] = error
return jsonify(msg)
# 获取详情信息(后端)
@main_bp.route("/python1s2c1/discussjingdianxinxi/info/<id_>", methods=['GET'])
def python1s2c1_discussjingdianxinxi_info(id_):
'''
'''
if request.method == 'GET':
msg = {"code": normal_code, "msg": "success", "data": {}}
data = discussjingdianxinxi.getbyid(discussjingdianxinxi, discussjingdianxinxi, int(id_))
if len(data)>0:
msg['data']=data[0]
#浏览点击次数
try:
__browseClick__= discussjingdianxinxi.__browseClick__
except:
__browseClick__=None
if __browseClick__ and "clicknum" in discussjingdianxinxi.__table__.columns:
click_dict={"id":int(id_),"clicknum":str(int(data[0].get("clicknum") or 0)+1)}
ret=discussjingdianxinxi.updatebyparams(discussjingdianxinxi,discussjingdianxinxi,click_dict)
if ret!=None:
msg['code'] = crud_error_code
msg['msg'] = ret
return jsonify(msg)
# 获取详情信息(前端)
@main_bp.route("/python1s2c1/discussjingdianxinxi/detail/<id_>", methods=['GET'])
def python1s2c1_discussjingdianxinxi_detail(id_):
'''
'''
if request.method == 'GET':
msg = {"code": normal_code, "msg": "success", "data": {}}
data = discussjingdianxinxi.getbyid(discussjingdianxinxi, discussjingdianxinxi, int(id_))
if len(data)>0:
msg['data']=data[0]
#浏览点击次数
try:
__browseClick__= discussjingdianxinxi.__browseClick__
except:
__browseClick__=None
if __browseClick__ and "clicknum" in discussjingdianxinxi.__table__.columns:
click_dict={"id":int(id_),"clicknum":str(int(data[0].get("clicknum") or 0)+1)}
ret=discussjingdianxinxi.updatebyparams(discussjingdianxinxi,discussjingdianxinxi,click_dict)
if ret!=None:
msg['code'] = crud_error_code
msg['msg'] = ret
return jsonify(msg)
# 更新接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/update", methods=['POST'])
def python1s2c1_discussjingdianxinxi_update():
'''
'''
if request.method == 'POST':
msg = {"code": normal_code, "msg": "success", "data": {}}
req_dict = session.get("req_dict")
if req_dict.get("mima") and "mima" not in discussjingdianxinxi.__table__.columns :
del req_dict["mima"]
if req_dict.get("password") and "password" not in discussjingdianxinxi.__table__.columns :
del req_dict["password"]
try:
del req_dict["clicknum"]
except:
pass
error = discussjingdianxinxi.updatebyparams(discussjingdianxinxi, discussjingdianxinxi, req_dict)
if error!=None:
msg['code'] = crud_error_code
msg['msg'] = error
return jsonify(msg)
# 删除接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/delete", methods=['POST'])
def python1s2c1_discussjingdianxinxi_delete():
'''
'''
if request.method == 'POST':
msg = {"code": normal_code, "msg": "success", "data": {}}
req_dict = session.get("req_dict")
error=discussjingdianxinxi.delete(
discussjingdianxinxi,
req_dict
)
if error!=None:
msg['code'] = crud_error_code
msg['msg'] = error
return jsonify(msg)
# 投票接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/vote/<int:id_>", methods=['POST'])
def python1s2c1_discussjingdianxinxi_vote(id_):
'''
'''
if request.method == 'POST':
msg = {"code": normal_code, "msg": "success"}
data= discussjingdianxinxi.getbyid(discussjingdianxinxi, discussjingdianxinxi, int(id_))
for i in data:
votenum=i.get('votenum')
if votenum!=None:
params={"id":int(id_),"votenum":votenum+1}
error=discussjingdianxinxi.updatebyparams(discussjingdianxinxi,discussjingdianxinxi,params)
if error!=None:
msg['code'] = crud_error_code
msg['msg'] = error
return jsonify(msg)
# 分组统计接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/group/<columnName>", methods=['GET'])
def python1s2c1_discussjingdianxinxi_group(columnName):
'''
分组统计接口
'''
if request.method == 'GET':
msg = {"code": normal_code, "msg": "success", "data": {}}
req_dict = session.get("req_dict")
userinfo = session.get("params")
msg['data'] = discussjingdianxinxi.groupbycolumnname(discussjingdianxinxi,discussjingdianxinxi,columnName,req_dict)
msg['data'] = msg['data'][:10]
return jsonify(msg)
# 按值统计接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/value/<xColumnName>/<yColumnName>", methods=['GET'])
def python1s2c1_discussjingdianxinxi_value(xColumnName, yColumnName):
'''
按值统计接口,
{
"code": 0,
"data": [
{
"total": 10.0,
"shangpinleibie": "aa"
},
{
"total": 20.0,
"shangpinleibie": "bb"
},
{
"total": 15.0,
"shangpinleibie": "cc"
}
]
}
'''
if request.method == 'GET':
msg = {"code": normal_code, "msg": "success", "data": {}}
req_dict = session.get("req_dict")
userinfo = session.get("params")
msg['data'] = discussjingdianxinxi.getvaluebyxycolumnname(discussjingdianxinxi,discussjingdianxinxi,xColumnName,yColumnName,req_dict)
msg['data'] = msg['data'][:10]
return jsonify(msg)
# 按日期统计接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/value/<xColumnName>/<yColumnName>/<timeStatType>", methods=['GET'])
def python1s2c1_discussjingdianxinxi_value_riqi(xColumnName, yColumnName, timeStatType):
'''
按日期统计接口
'''
if request.method == 'GET':
msg = {"code": normal_code, "msg": "success", "data": {}}
where = ' where 1 = 1 '
sql = ''
if timeStatType == '日':
sql = "SELECT DATE_FORMAT({0}, '%Y-%m-%d') {0}, sum({1}) total FROM discussjingdianxinxi {2} GROUP BY DATE_FORMAT({0}, '%Y-%m-%d')".format(xColumnName, yColumnName, where, '%Y-%m-%d')
if timeStatType == '月':
sql = "SELECT DATE_FORMAT({0}, '%Y-%m') {0}, sum({1}) total FROM discussjingdianxinxi {2} GROUP BY DATE_FORMAT({0}, '%Y-%m')".format(xColumnName, yColumnName, where, '%Y-%m')
if timeStatType == '年':
sql = "SELECT DATE_FORMAT({0}, '%Y') {0}, sum({1}) total FROM discussjingdianxinxi {2} GROUP BY DATE_FORMAT({0}, '%Y')".format(xColumnName, yColumnName, where, '%Y')
data = db.session.execute(sql)
data = data.fetchall()
results = []
for i in range(len(data)):
result = {
xColumnName: decimalEncoder(data[i][0]),
'total': decimalEncoder(data[i][1])
}
results.append(result)
msg['data'] = results
return jsonify(msg)
# 推荐算法接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/autoSort2", methods=['GET'])
def python1s2c1_discussjingdianxinxi_autoSort2():
if request.method == 'GET':
leixing = set()
req_dict = session.get("req_dict")
userinfo = session.get("params")
sql = "select inteltype from storeup where userid = "+userinfo.get("id")+" and tablename = 'discussjingdianxinxi' order by addtime desc"
try:
data = db.session.execute(sql)
rows = data.fetchall()
for row in rows:
for item in row:
if item != None:
leixing.add(item)
except:
leixing = set()
L = []
sql ="select * from discussjingdianxinxi where $intelRecomColumn in ('%s"%("','").join(leixing)+"') union all select * from discussjingdianxinxi where $intelRecomColumn not in('%s"%("','").join(leixing)+"')"
data = db.session.execute(sql)
data_dict = [dict(zip(result.keys(), result)) for result in data.fetchall()]
for online_dict in data_dict:
for key in online_dict:
if 'datetime.datetime' in str(type(online_dict[key])):
online_dict[key] = online_dict[key].strftime(
"%Y-%m-%d %H:%M:%S")
else:
pass
L.append(online_dict)
return jsonify({"code": 0, "msg": '', "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":5,"list": L[0:int(req_dict['limit'])]}})
# 统计接口
@main_bp.route("/python1s2c1/discussjingdianxinxi/remind/<columnName>/<type>", methods=['GET']) #
def python1s2c1_discussjingdianxinxi_remind(columnName,type):
'''
'''
if request.method == 'GET':
msg = {"code": normal_code, 'count': 0}
# 组合查询参数
params = session.get("req_dict")
if int(type)==1:#数字
if params.get('remindstart') == None and params.get('remindend') != None:
remindstart = 0
remindend = int(params['remindend'])
elif params.get('remindstart') != None and params.get('remindend') == None:
remindstart = int(params['remindstart'])
remindend = 999999
elif params.get('remindstart') == None and params.get('remindend') == None:
remindstart = 0
remindend = 999999
elif int(type)==2:#日期
current_time=int(time.time())
if params.get('remindstart') == None and params.get('remindend') != None:
starttime=current_time-60*60*24*365*2
params['remindstart'] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(starttime))
endtime=current_time+60*60*24*params.get('remindend')
params['remindend'] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(endtime))
elif params.get('remindstart') != None and params.get('remindend') == None:
starttime= current_time - 60 * 60 * 24 * params.get('remindstart')
params['remindstart']=time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(starttime))
endtime=current_time+60*60*24*365*2
params['remindend'] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(endtime))
elif params.get('remindstart') == None and params.get('remindend') == None:
starttime = current_time - 60 * 60 * 24 * 365 * 2
params['remindstart'] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(starttime))
endtime = current_time + 60 * 60 * 24 * 365 * 2
params['remindend'] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(endtime))
data = discussjingdianxinxi.getbetweenparams(
discussjingdianxinxi,
discussjingdianxinxi,
columnName,
{
"remindStart": remindstart,
"remindEnd": remindend
}
)
msg['count'] = len(data)
return jsonify(msg)
五,相关作品展示
基于Java开发、Python开发、PHP开发、C#开发等相关语言开发的实战项目
基于Nodejs、Vue等前端技术开发的前端实战项目
基于微信小程序和安卓APP应用开发的相关作品
基于51单片机等嵌入式物联网开发应用
基于各类算法实现的AI智能应用
基于大数据实现的各类数据管理和推荐系统