def my_activity():
u_id = session.get('u_id')
# u_id = 29
query = models.Query()
my_activity_id = query.get_my_aid(u_id)
print(my_activity_id)
return jsonify(my_activity_id)
def get_activity_data():
# 如果没登录就重定向
u_id = session.get('u_id')
# u_id = 29
if u_id is None or u_id == '':
return redirect(url_for('index'))
data = {'code': 400, 'data': {}}
# 从数据库中查出指定id的活动
a_id = int(request.args.get('a_id'))
# a_id = 1000
print(a_id)
# a_id = 1000
query = models.Query()
activity_data = query.get_activity_data(a_id)
member_count = query.activity_member_count(a_id)
activity_data['member_count'] = member_count
temp = []
for x in query.get_joined_aid(u_id):
temp.append(x[0])
print(temp)
if a_id in temp:
activity_data['is_joined'] = 1
else:
activity_data['is_joined'] = 0
data['code'] = 200
data['data'] = activity_data
return jsonify(data)
def login():
# login = models.Login()
# 实例化login_form类用于获取登录表单信息
# print(session['u_id'])
# try:
# if session['u_id'] is None or session['u_id'] == '':
# return redirect(url_for('static', filename='html/index.html'))
# except Exception:
# return redirect(url_for('static', filename='html/index.html'))
# finally:
# pass
login_form = forms.LoginForm()
form_data = login_form.get_data(request)
print(form_data)
db_select = models.Query()
# 检查数据库中有没有个人信息
# 在数据库中获取u_id
u_id = db_select.get_u_id(form_data['u_xh_id'])
print(u_id)
u_xh_id = form_data['u_xh_id']
u_password = form_data['u_password']
data = {'code': 400, 'data': {}}
if u_id and db_select.get_password(u_password):
# 登录成功，建立对话
session['u_id'] = u_id
session['u_xh_id'] = u_xh_id
session['u_password'] = u_password
# g.u_id = u_id
u_data = db_select.get_login_user(u_id)
data['code'] = 200
data['data'] = u_data
print('login success!')
# print(data)
# 登录成功重定向到首页
return jsonify(data)
# 爬取数据
try:
# 爬取到用户的个人信息
u_data = scraping.crow_date(form_data)
except Exception:
return jsonify(data)
else:
# 爬取成功，插入数据库
db_insert = models.InsertDB()
db_insert.add_user(u_data, u_password)
print("插入成功!")
print(u_data)
# 向teams和team_user插入数据
u_id = db_select.get_u_id(u_xh_id)
db_insert.join_class_team(u_id, u_data)
session['u_id'] = u_id
session['u_xh_id'] = u_xh_id
session['u_password'] = u_password
g.u_id = u_id
u_data = db_select.get_login_user(u_id)
data['code'] = 200
data['data'] = u_data
return jsonify(data)
def show_joined_activities():
data = {'code': 400, 'data': {}}
u_id = session.get('u_id')
# u_id = 29
query = models.Query()
joined_activities_data = query.get_joined_activities(u_id)
data['code'] = 200
data['data'] = joined_activities_data
# print(joined_activities_data)
return jsonify(data)
def show_activities():
data = {
'code': 400,
'current_page': 1,
'pages': 1,
'data': [],
}
try:
# 获取u_id
# u_id = session.get('u_id')
# u_id = 30
# 获取活动的等级
# a_level = 2
a_level = request.args.get('a_level')
print(a_level)
query = models.Query()
# 查出活动总数
db_count = query.get_a_level_length(a_level)
print(db_count)
# 计算活动的页数
pages = db_count//10 + 1
data['pages'] = pages
# 获取活动的页数
current_page = int(request.args.get('current_page'))
# current_page = 1
start_id = (current_page-1)*8
activities_data = query.get_level_activities(a_level, start_id)
# if u_id is None or u_id == '':
# data['code'] = 400
# data['data'] = activities_data
# for x in activities_data:
# x['is_joined'] = 0
# return jsonify(data)
print(activities_data)
# 查出我已参加的活动,是一个tuple
# joined_activities_id = query.get_joined_aid(u_id)
# for x in activities_data:
# # 如果该活动我已参加，则标记True
# if x['a_id'] in joined_activities_id:
# x['is_joined'] = 1
# else:
# x['is_joined'] = 0
#
data['code'] = 200
data['data'] = activities_data
except Exception:
return jsonify(data)
finally:
return jsonify(data)
def my_data():
data = {'code': 400, 'data': {}}
query = models.Query()
u_id = session.get('u_id')
# u_id = 29
print(u_id)
print(request.cookies)
if u_id is None:
return jsonify(request.cookies)
u_data = query.get_user_data(u_id)
data['code'] = 200
data['data'] = u_data
print(data)
# resp = make_response(jsonify(response=data))
# # 跨域设置
# resp.headers['Access-Control-Allow-Origin'] = '*'
# resp.headers['Access-Control-Allow-Credentials'] = 'true'
# resp.headers['Access-Control-Allow-Headers'] = 'x-requested-with,content-type'
# resp.headers['Access-Control-Allow-Methods'] = 'PUT,GET,POST,DELETE'
return jsonify(data)
def upload_team_file():
if request.method == 'GET':
return jsonify("请求错误")
else:
db = models.Query()
last_id = db.get_last_aid()
# print(last_id)
a_id = last_id + 1
try:
file = request.files['file']
if file and allowed_img(file.filename):
file.filename = 'file_' + str(a_id) + '.' + file.filename.rsplit('.')[1]
basepath = r"D:\\Python\\project\\team_plus\\app\\static\\file\\activity_file"
upload_path = os.path.join(basepath, file.filename)
global FILE_PATH
FILE_PATH = upload_path
file.save(upload_path)
return jsonify({'data': 'success'})
except Exception:
return jsonify({'data': '请选择正确格式的图片！'})
def show_user_list():
a_id = request.args.get('a_id')
query = models.Query()
user_list = query.show_user_list(a_id)
print(user_list)
return jsonify(user_list)
