def get(self, match_id):
keyword = self.get_argument("kw", "")
match = Match.get_or_404(id=match_id)
query = MatchMember.query_all_members(match_id)
group_query = MatchGroup.select() \
.where(MatchGroup.match_id == match_id)
self.logger.debug(group_query.sql())
groups = []
for group in group_query:
groups.append({"name": group.name})
group_name = self.get_argument("group_name", "")
if group_name:
query = query.where(MatchGroup.name == group_name)
if keyword:
if is_mobile(keyword):
query = query.where(MatchMember.mobile == keyword)
else:
query = query.where(MatchMember.name.contains(keyword))
members = self.paginate_query(query)
sum_fee = MatchMember.select(
fn.SUM(MatchMember.total_fee).alias("sum")).where(
MatchMember.match_id == match_id).scalar()
self.render("match/match_members_list.html",
sum_fee=sum_fee,
match=match,
groups=groups,
members=members,
pagination=members.pagination)
def get(self, match_id, state):
match = Match.get_or_404(id=match_id)
if state == "normal":
# 查询正常参赛成员
members = MatchMember\
.query_all_members(match_id)\
.where(MatchMember.state == MatchMember.MatchMemberState.normal)
else:
members = MatchMember.query_all_members(match_id)
# 排除文件和图片项
option_info_list = [
option_info for option_info in match.option_info_list
if not (option_info.is_photo() or option_info.is_file() or
option_info.is_avatar() or option_info.is_idcard_photo())
]
option_name_list = [
option_info.option_name for option_info in option_info_list
]
option_name_list.extend(["报名时间", "状态"])
file_name = "{match_name}成员列表.xlsx"\
.format(match_name=match.title)
# temp_file_name = str(uuid.uuid4())
o = io.BytesIO()
with Workbook(o) as workbook:
worksheet = workbook.add_worksheet()
row, col = 0, 0
worksheet.write_row(row, col, option_name_list)
for member in members:
row, col = row + 1, 0
assert isinstance(member, MatchMember)
for option_info in option_info_list:
option_value = option_info.get_option_value(member)
# 处理布尔值显示
if option_info.is_leader_check() or option_info.is_boolean(
):
option_value = "是" if option_value else "否"
if option_info.is_gender():
option_value = member.display_gender()
worksheet.write(row, col, option_value)
col += 1
worksheet.write(row, col, member.created.strftime('%Y.%m.%d'))
worksheet.write(row, col + 1, member.state_name)
data = o.getvalue()
o.close()
self.set_header("Content-Type", "application/octet-stream")
self.set_header("Content-Disposition",
"attachment; filename={0}".format(file_name))
self.add_header("Content-Length", len(data))
self.set_header("Content-Transfer-Encoding", "binary")
self.write(data)