def edit_competition(): id = request.args.get('id') competition = dbCompetition.get_by_id(id) competition_form = form.CompetitionForm() competition_form.title.data = competition.title competition_form.year.data = competition.year competition_form.event_date.data = competition.event_date return render_template('edit_competition.html', title = u'修改校赛', competition = competition, competition_form = competition_form)
def get_players(): if not current_user.is_admin and not current_user.is_coach: return redirect(url_for('main.index')) page = request.args.get('page', 1, type=int) search = request.args.get('search', None) competition_id = request.args.get('competition', 1, type=int) per_page = COMPETITION_MANAGE_PER_PAGE competition = dbCompetition.get_by_id(competition_id) pagination = dbCompetition.get_players_pageable(competition, page, per_page, search=search) page_list = list(pagination.iter_pages(left_current=1, right_current=2)) return jsonify(items=[get_player_list_item(p) for p in pagination.items], prev_num=pagination.prev_num, next_num=pagination.next_num, page_list=page_list, page=pagination.page, pages=pagination.pages)
def export_players(cid): competition = dbCompetition.get_by_id(cid) players = dbCompetition.get_players(competition) title = competition.title + u'报名表' headers = [u'姓名', u'学号', u'性别', u'衣服大小', u'手机号码', u'邮箱', u'学院', u'专业', u'班级', u'报名时间'] ret = [headers] for player in players: cur = [ player.name, player.stu_id, u'男' if player.gender else u'女', player.shirt_size, player.phone, player.email, SCHOOL_COLLEGE_MAP[player.college], player.major, player.grade, player.time ] ret.append(cur) return make_response_from_array(ret, 'xls', file_name=title.decode('latin1'))
def manage_player(cid): competition = dbCompetition.get_by_id(cid) return render_template('manage_player.html', title = competition.title + u' - 报名学生管理', competition = competition)