def edit_dancer(number):
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
wide = int(request.values['wide'])
dancer = db.session.query(Contestant).join(ContestantInfo) \
.filter(ContestantInfo.team == current_user.team, Contestant.contestant_id == number) \
.order_by(Contestant.contestant_id).first_or_404()
possible_partners = TeamPossiblePartners(current_user, dancer=dancer, include_gdpr=True,
partners_only=(dancer.status_info.status == SELECTED or
dancer.status_info.status == CONFIRMED)).possible_partners()
form = EditContestantForm(dancer)
form.first_name.validators = []
form.last_name.validators = []
if request.method == GET:
form.populate(dancer)
if request.method == POST:
form.custom_validate(dancer)
if form.validate_on_submit():
dancer.status_info.feedback_about_information = None
db.session.commit()
flash('{} data has been changed successfully.'.format(submit_contestant(form, contestant=dancer)),
'alert-success')
return redirect(url_for('teamcaptains.edit_dancers', wide=wide))
if dancer.status_info.feedback_about_information is not None:
feedback = dancer.status_info.feedback_about_information
flash(f'{dancer.get_full_name()} sent feedback about his/her submitted information:<br/><br/>'
f'<i>{feedback}</i><br/><br/>You can remove this notification by saving the form on this page.',
'alert-info')
return render_template('teamcaptains/edit_dancer.html', dancer=dancer, form=form, wide=wide,
possible_partners=possible_partners)
def request_respond(req):
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
req = PartnerRequest.query.filter_by(id=req).first()
if not req:
return redirect('errors/404.html')
if req.other.contestant_info.team != current_user.team:
return redirect('errors/404.html')
form = PartnerRespondForm()
if form.validate_on_submit():
accepted = form.accept.data
req.response = form.remark.data
if accepted:
success = True
partner = next((p.partner for p in req.other.dancing_info if p.competition == req.competition), None)
if partner is not None:
success = False
flash('{} already has a dancing partner'.format(req.other.get_full_name(), partner))
partner = next((p.partner for p in req.dancer.dancing_info if p.competition == req.competition), None)
if partner is not None:
success = False
flash('{} already has a dancing partner'.format(req.dancer.get_full_name(), partner))
if success:
req.accept()
flash('Dance partner request accepted')
db.session.commit()
else:
return redirect(url_for('teamcaptains.request_respond', req=req.id))
else:
req.reject()
flash('Dance partner request rejected')
db.session.commit()
return redirect(url_for('teamcaptains.partner_request_list'))
return render_template('teamcaptains/request_respond.html', title="Respond to partner request", form=form, req=req)
def break_up_couple(competition, lead_id, follow_id):
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
lead = DancingInfo.query.filter(DancingInfo.competition == competition, DancingInfo.contestant_id == lead_id,
DancingInfo.partner == follow_id).first()
follow = Contestant.query.filter(Contestant.contestant_id == follow_id).first()
lead_status = Contestant.query.filter(Contestant.contestant_id == lead_id).first()
if lead_status.status_info.status == SELECTED or lead_status.status_info.status == CONFIRMED \
or follow.status_info.status == SELECTED or follow.status_info.status == CONFIRMED:
flash(f"Cannot break up a couple that has been {SELECTED} or {CONFIRMED}.")
else:
lead.set_partner(None)
db.session.commit()
flash(f'{lead.contestant} and {follow} are not a couple anymore in {competition}.')
dancer, old_partner = None, None
if lead_status.contestant_info.team != current_user.team:
dancer, old_partner = lead_status, follow
elif follow.contestant_info.team != current_user.team:
dancer, old_partner = follow, lead_status
if dancer is not None:
other_team_captain = User.query.filter(User.is_active, User.access == ACCESS[TEAM_CAPTAIN],
User.team == dancer.contestant_info.team).first()
text = f"{dancer.get_full_name()} is no longer dancing with {old_partner.get_full_name()} " \
f"({old_partner.contestant_info.team}) in {competition}."
n = Notification(title=f"{dancer.get_full_name()} - no partner in {competition}",
text=text.format(dancer=dancer.get_full_name(), comp=competition), user=other_team_captain)
n.send()
return redirect(url_for('teamcaptains.couples_list'))
def partner_request():
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
dancer_choices = db.session.query(Contestant).join(ContestantInfo).join(DancingInfo).join(StatusInfo)\
.filter(ContestantInfo.team == current_user.team, StatusInfo.status == REGISTERED,
DancingInfo.partner.is_(None),
or_(and_(DancingInfo.level == BREITENSPORT,
or_(DancingInfo.blind_date.is_(False),
DancingInfo.blind_date.is_(not g.sc.breitensport_obliged_blind_date))),
DancingInfo.level == BEGINNERS)).order_by(Contestant.first_name)
if len(dancer_choices.all()) == 0:
flash(f"There are currently no dancers registered in your team that require a partner.", 'alert-warning')
flash(f"Dancers that have not accepted the GDPR yet, cannot be used for a partner request, as this would mean "
f"sharing some of their personal data. Once the GDPR has been accepted, dancers are available for a "
f"partner request")
return redirect(url_for('teamcaptains.partner_request_list'))
other_choices = db.session.query(Contestant).join(ContestantInfo).join(DancingInfo).join(StatusInfo) \
.filter(ContestantInfo.team != current_user.team, StatusInfo.status == REGISTERED,
DancingInfo.partner.is_(None),
or_(and_(DancingInfo.level == BREITENSPORT,
or_(DancingInfo.blind_date.is_(False),
DancingInfo.blind_date.is_(not g.sc.breitensport_obliged_blind_date))),
DancingInfo.level == BEGINNERS)) \
.order_by(ContestantInfo.team_id, Contestant.first_name).all()
if len(other_choices) == 0:
flash(f"There are currently no dancers registered in the other teams that require a partner.", 'alert-warning')
return redirect(url_for('teamcaptains.partner_request_list'))
form = PartnerRequestForm(g.sc, other_choices)
form.dancer.query = dancer_choices
my_dancers = TeamPossiblePartners(current_user).possible_partners()
possible_partners = TeamPossiblePartners(current_user, other_teams=True).possible_partners()
if form.validate_on_submit():
di1 = DancingInfo.query.filter_by(contestant_id=form.dancer.data.contestant_id,
competition=form.competition.data).first()
if len(PartnerRequest.query.filter(PartnerRequest.dancer_id == form.dancer.data.contestant_id,
PartnerRequest.competition == form.competition.data,
PartnerRequest.state == PartnerRequest.STATE['Open']).all()) > 0:
flash(f"There is already an active request out for {di1.contestant} in {form.competition.data}. "
f"Please cancel that request first, before sending out another one.", 'alert-danger')
return redirect(url_for('teamcaptains.partner_request_list'))
di2 = DancingInfo.query.filter_by(contestant_id=form.other.data, competition=form.competition.data).first()
match, errors = di1.valid_match(di2)
if not match:
flash("{} and {} are not a valid couple:"
.format(di1.contestant.get_full_name(), di2.contestant.get_full_name()), 'alert-danger')
for e in errors:
flash(e, 'alert-warning')
return redirect(url_for('teamcaptains.partner_request'))
else:
pr = PartnerRequest(dancer_id=form.dancer.data.contestant_id, other_id=form.other.data,
remark=form.remark.data, competition=form.competition.data, level=form.level.data)
db.session.add(pr)
db.session.commit()
flash('Partner request sent. Please wait until the other teamcaptain has handled the request.')
return redirect(url_for('teamcaptains.partner_request_list'))
return render_template('teamcaptains/partner_request.html', form=form, title='partner_request',
my_dancers=my_dancers, possible_partners=possible_partners)
def set_teamcaptains():
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
form = TeamCaptainForm()
tc_query = Contestant.query.join(ContestantInfo).join(StatusInfo)\
.filter(ContestantInfo.team == current_user.team, StatusInfo.status != CANCELLED)\
.order_by(Contestant.first_name)
form.team_captain_one.query = tc_query
form.team_captain_two.query = tc_query
current_tcs = db.session.query(Contestant).join(ContestantInfo) \
.filter(ContestantInfo.team == current_user.team, ContestantInfo.team_captain.is_(True)).all()
if request.method == 'GET':
if len(current_tcs) > 0:
form.team_captain_one.data = current_tcs[0]
if len(current_tcs) == 2:
form.team_captain_two.data = current_tcs[1]
if form.validate_on_submit():
current_tc_one = None
current_tc_two = None
if current_tcs is not None:
if len(current_tcs) >= 1:
current_tc_one = current_tcs[0]
current_tc_one.contestant_info.team_captain = False
if len(current_tcs) == 2:
current_tc_two = current_tcs[1]
current_tc_two.contestant_info.team_captain = False
db.session.commit()
first_team_captain = None
second_team_captain = None
if form.team_captain_one.data is not None:
first_team_captain = form.team_captain_one.data
first_team_captain.contestant_info.team_captain = True
if form.team_captain_two.data is not None:
second_team_captain = form.team_captain_two.data
second_team_captain.contestant_info.team_captain = True
db.session.commit()
if first_team_captain is not None and second_team_captain is not None:
if first_team_captain in current_tcs and second_team_captain not in current_tcs:
flash(f"Set {second_team_captain.get_full_name()} as teamcaptain.")
if first_team_captain not in current_tcs and second_team_captain in current_tcs:
flash(f"Set {first_team_captain.get_full_name()} as teamcaptain.")
if first_team_captain not in current_tcs and second_team_captain not in current_tcs:
flash(f"Set {first_team_captain.get_full_name()} and {second_team_captain.get_full_name()} as "
f"teamcaptains.")
if first_team_captain is not None and second_team_captain is None:
if first_team_captain not in current_tcs:
flash(f"Set {first_team_captain.get_full_name()} as teamcaptain.")
if current_tc_two is not None:
flash(f"Removed {current_tc_two.get_full_name()} as teamcaptain.")
if first_team_captain is None and second_team_captain is None:
if current_tc_one is not None and current_tc_two is not None:
flash(f"Removed {current_tc_one.get_full_name()} and {current_tc_two.get_full_name()} as "
f"teamcaptains.")
if current_tc_one is not None and current_tc_two is None:
flash(f"Removed {current_tc_one.get_full_name()} as teamcaptain.")
return redirect(url_for('teamcaptains.set_teamcaptains'))
return render_template('teamcaptains/set_teamcaptains.html', form=form, current_tcs=current_tcs)
def partner_cancel(req):
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
req = PartnerRequest.query.filter(PartnerRequest.id == req).first()
req.cancel()
flash(f'Partner request for {req.dancer} with {req.other} in {req.competition} cancelled.')
db.session.commit()
return redirect(url_for('teamcaptains.partner_request_list'))
def partner_request_list():
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
requests = PartnerRequest.query.all()
my_requests = [req for req in requests if req.dancer.contestant_info.team == current_user.team]
other_requests = list(req for req in requests if req.other.contestant_info.team == current_user.team)
return render_template('teamcaptains/partner_list.html', my_requests=my_requests, other_requests=other_requests,
title='partner requests')
def edit_dancers():
if not current_user.has_dancers_registered():
flash("Cannot enter page. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
wide = request.args.get('wide', 0, type=int)
dancers = db.session.query(Contestant).join(ContestantInfo).join(StatusInfo) \
.filter(ContestantInfo.team == current_user.team).order_by(Contestant.first_name).all()
order = [NO_GDPR, CONFIRMED, SELECTED, REGISTERED, CANCELLED]
dancers = sorted(dancers, key=lambda o: order.index(o.status_info.status))
return render_template('teamcaptains/edit_dancers.html', dancers=dancers, wide=wide)
def create_couple():
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
form = CreateCoupleForm(g.sc)
leads = db.session.query(Contestant).join(ContestantInfo).join(DancingInfo).join(StatusInfo)\
.filter(ContestantInfo.team == current_user.team,
or_(StatusInfo.status == REGISTERED, StatusInfo.status == NO_GDPR),
DancingInfo.role == LEAD, DancingInfo.partner.is_(None),
or_(and_(DancingInfo.level == BREITENSPORT,
or_(DancingInfo.blind_date.is_(False),
DancingInfo.blind_date.is_(not g.sc.breitensport_obliged_blind_date))),
DancingInfo.level == BEGINNERS)).order_by(Contestant.first_name)
follows = db.session.query(Contestant).join(ContestantInfo).join(DancingInfo).join(StatusInfo) \
.filter(ContestantInfo.team == current_user.team,
or_(StatusInfo.status == REGISTERED, StatusInfo.status == NO_GDPR),
DancingInfo.role == FOLLOW, DancingInfo.partner.is_(None),
or_(and_(DancingInfo.level == BREITENSPORT,
or_(DancingInfo.blind_date.is_(False),
DancingInfo.blind_date.is_(not g.sc.breitensport_obliged_blind_date))),
DancingInfo.level == BEGINNERS)).order_by(Contestant.first_name)
if len(leads.all()) == 0 or len(follows.all()) == 0:
flash(f"There are currently {len(leads.all())} available Leads and {len(follows.all())} available Follows "
f"registered. Cannot create new couples.", 'alert-warning')
return redirect(url_for('teamcaptains.couples_list'))
possible_partners = TeamPossiblePartners(current_user, include_gdpr=True).possible_partners()
form.lead.query = leads
form.follow.query = follows
if form.validate_on_submit():
lead = DancingInfo.query.filter_by(contestant_id=form.lead.data.contestant_id,
competition=form.competition.data).first()
follow = DancingInfo.query.filter_by(contestant_id=form.follow.data.contestant_id,
competition=form.competition.data).first()
match, errors = lead.valid_match(follow)
if not match:
flash("{} and {} are not a valid couple:"
.format(lead.contestant.get_full_name(), follow.contestant.get_full_name()), 'alert-danger')
for e in errors:
flash(e, 'alert-warning')
else:
lead.set_partner(follow.contestant_id)
db.session.commit()
flash(f'Created a couple with {lead.contestant} and {follow.contestant} in {form.competition.data}.',
'alert-success')
return redirect(url_for('teamcaptains.couples_list'))
return render_template('teamcaptains/create_couple.html', form=form, possible_partners=possible_partners)
def couples_list():
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
dancers = DancingInfo.query.join(ContestantInfo, DancingInfo.contestant_id == ContestantInfo.contestant_id)\
.join(Contestant, DancingInfo.contestant_id == Contestant.contestant_id)\
.filter(ContestantInfo.team == current_user.team, DancingInfo.partner.isnot(None))\
.order_by(DancingInfo.level, Contestant.first_name)
ballroom_leads = dancers.filter(DancingInfo.role == LEAD, DancingInfo.competition == BALLROOM).all()
ballroom_follows = dancers.filter(DancingInfo.role == FOLLOW, DancingInfo.competition == BALLROOM).all()
ballroom_couples = {**{lead: lead.get_partner() for lead in ballroom_leads},
**{follow.get_partner(): follow for follow in ballroom_follows}}
latin_leads = dancers.filter(DancingInfo.role == LEAD, DancingInfo.competition == LATIN).all()
latin_follows = dancers.filter(DancingInfo.role == FOLLOW, DancingInfo.competition == LATIN).all()
latin_couples = {**{lead: lead.get_partner() for lead in latin_leads},
**{follow.get_partner(): follow for follow in latin_follows}}
return render_template('teamcaptains/couples_lists.html', func=func,
ballroom_couples=ballroom_couples, latin_couples=latin_couples)
def name_change_request(contestant):
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
wide = int(request.values['wide'])
contestant = Contestant.query.filter_by(contestant_id=contestant).first()
if not contestant or not contestant.contestant_info.team == current_user.team:
return redirect('errors/404.html')
form = NameChangeRequestForm()
if form.validate_on_submit():
flash('Name change request sent.')
ncr = NameChangeRequest(first_name=form.first_name.data, last_name=form.last_name.data,
prefixes=form.prefixes.data, contestant=contestant)
db.session.add(ncr)
db.session.commit()
return redirect(url_for('teamcaptains.edit_dancer', number=contestant.contestant_id, wide=wide))
form.first_name.data = contestant.first_name
form.prefixes.data = contestant.prefixes
form.last_name.data = contestant.last_name
return render_template('teamcaptains/name_change_request.html', title="Name change request", contestant=contestant,
form=form, wide=wide)
def delete_dancer(number):
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
changed_dancer = db.session.query(Contestant).join(ContestantInfo) \
.filter(ContestantInfo.team == current_user.team, Contestant.contestant_id == number).first()
dancer_account = User.query.filter(User.dancer == changed_dancer).first()
if changed_dancer.status_info.status == NO_GDPR or changed_dancer.status_info.status == CANCELLED:
if dancer_account is not None:
if changed_dancer.deletable():
if changed_dancer.status_info.status == NO_GDPR:
changed_dancer.cancel_registration()
db.session.delete(dancer_account)
db.session.commit()
flash(f"Permanently deleted the registration data of {changed_dancer.get_full_name()}.")
else:
flash(f"Cannot permanently delete the registration data of {changed_dancer.get_full_name()}. "
f"{changed_dancer.first_name} either needs to receive merchandise, needs to pay, "
f"or has a refund pending.")
else:
flash("Can only delete a dancers' account if the dancer has not accepted the GDPR or if the dancers' "
"registration is cancelled.")
return redirect(url_for('teamcaptains.edit_dancers', wide=int(request.values['wide'])))
def register_dancer(number):
if not current_user.has_dancers_registered():
flash("Cannot enter page right now. Register at least one dancer first to access the page.")
return redirect(url_for('main.dashboard'))
register = request.args.get('register', None, type=int)
changed_dancer = db.session.query(Contestant).join(ContestantInfo) \
.filter(ContestantInfo.team == current_user.team, Contestant.contestant_id == number).first()
if register == 0:
status = changed_dancer.status_info.status
changed_dancer.cancel_registration()
db.session.commit()
flash('The registration of {} has been cancelled.'.format(changed_dancer.get_full_name()), 'alert-info')
text = f"{changed_dancer.get_full_name()} from team {changed_dancer.contestant_info.team.name} " \
f"has cancelled his/her registration.\n"
title = f"Cancelled registration, previously {status} " \
f"- {changed_dancer.get_full_name()} ({changed_dancer.contestant_info.team})"
n = Notification(title=title, text=text, user=User.query.filter(User.access == ACCESS[ORGANIZER]).first())
n.send()
elif register == 1:
changed_dancer.status_info.set_status(REGISTERED)
db.session.commit()
flash('{} has been re-registered successfully.'.format(changed_dancer.get_full_name()), 'alert-success')
return redirect(url_for('teamcaptains.edit_dancers', wide=int(request.values['wide'])))