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)
