def get(self, match_id):
match = Match.get_or_404(id=match_id)
# 获取赛事分组信息
groups = MatchGroup.select().where(
MatchGroup.match_id == match.id).order_by(
MatchGroup.sort_num.desc())
# 获取报名表自定义选项
custom_options = MatchOption.select().where(
MatchOption.match_id == match.id).order_by(
MatchOption.sort_num.desc())
rounds = MatchRound.select(MatchRound, ).where(
MatchRound.match_id == match.id).order_by(MatchRound.created.asc(),
MatchRound.id.asc())
covers = MatchCover.select().where(
MatchCover.match_id == match.id).order_by(MatchCover.id.desc())
# 获取对阵图
RightMember = MatchMember.alias()
against_query = MatchAgainst.select(
MatchAgainst, MatchMember, RightMember).join(
MatchMember,
on=(MatchAgainst.left_member_id == MatchMember.id
).alias("left_member")).switch(MatchAgainst).join(
RightMember,
join_type=JOIN_LEFT_OUTER,
on=(MatchAgainst.right_member_id == RightMember.id
).alias("right_member")).where(
MatchAgainst.match_id == match_id).order_by(
MatchAgainst.start_time.asc())
againsts = {}
for against in against_query:
if against.round_id not in againsts:
againsts[against.round_id] = []
againsts[against.round_id].append(against)
# 如果已经结束 获取是否已经提交了结算申请
is_application_exist =\
SettlementApplication.is_application_exist(match_id)
self.render("match/detail.html",
match=match,
rounds=rounds,
groups=groups,
custom_options=custom_options,
covers=covers,
againsts=againsts,
is_application_exist=is_application_exist)
def get(self, match_id):
""" 获取赛事轮次列表
"""
match = Match.get_or_404(id=match_id)
query = MatchRound.select().where(
MatchRound.match_id == match.id).order_by(
MatchRound.start_time.asc())
rounds = []
for match_round in query:
rounds.append(match_round.info)
RightMember = MatchMember.alias()
against_query = MatchAgainst.select(
MatchAgainst, MatchMember, RightMember).join(
MatchMember,
on=(MatchAgainst.left_member_id == MatchMember.id
).alias("left_member")).switch(MatchAgainst).join(
RightMember,
join_type=JOIN_LEFT_OUTER,
on=(MatchAgainst.right_member_id == RightMember.id
).alias("right_member")).where(
MatchAgainst.match_id == match_id).order_by(
MatchAgainst.start_time.asc())
againsts = {}
for against in against_query:
if against.round_id not in againsts:
againsts[against.round_id] = []
against_info = against.info
against_info['left_member'] = against.left_member.mini_info
if against.right_member:
against_info['right_member'] = against.right_member.mini_info
againsts[against.round_id].append(against_info)
for i in range(0, len(rounds)):
round_id = rounds[i]['id']
rounds[i]['against_mapping'] = againsts.get(round_id, [])
self.write({"rounds": rounds})