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)