def create_season():
#load users to reset when new cycle created
users = model.session.query(model.User).all()
# load form to create new season_cycle (form)
form = SeasonCycleForm()
# create new cycle
if form.validate_on_submit():
cycle = model.session.\
add(model.SeasonCycle(admin_id= current_user.id,
leaguename= form.leaguename.data,
cyclename= form.cyclename.data,
num_of_teams= form.num_of_teams.data,
home_region= form.home_region.data,
fee_resident= form.fee_resident.data,
fee_nonresident= form.fee_nonresident.data,
reg_start= form.reg_start.data,
reg_end= form.reg_end.data,
active= True))
#print form.errors
model.session.commit()
# reset all users to false
for user in users:
user.user_registered = False
model.session.commit()
flash("Cycle created")
return redirect('seasons')
return render_template('season_create.html',
title='SeasonCreate',
form=form)
def edit_season():
current_cycle = model.session.query(model.SeasonCycle).\
filter(model.SeasonCycle.active ==True).\
first()
message = ""
form = SeasonCycleForm()
# if registration for the last season is closed
if current_cycle == None:
message = "Registration is closed. You can no longer edit."
current_cycle = model.session.query(model.SeasonCycle).\
order_by(model.SeasonCycle.id.desc()).\
first()
#Check which submit button is clicked
if request.form.get(
"current_season") == 'edit' and form.validate_on_submit():
# edit current season if status is active
current_cycle.leaguename = form.leaguename.data
current_cycle.cyclename = form.cyclename.data
current_cycle.num_of_teams = form.num_of_teams.data
current_cycle.home_region = form.home_region.data
current_cycle.fee_resident = form.fee_resident.data
current_cycle.fee_nonresident = form.fee_nonresident.data
current_cycle.reg_start = form.reg_start.data
current_cycle.reg_end = form.reg_end.data
model.session.add(current_cycle)
model.session.commit()
flash('Your changes have been saved!')
else:
#renders the fields with data from database
form.leaguename.data = current_cycle.leaguename
form.cyclename.data = current_cycle.cyclename
form.num_of_teams.data = current_cycle.num_of_teams
form.home_region.data = current_cycle.home_region
form.fee_resident.data = current_cycle.fee_resident
form.fee_nonresident.data = current_cycle.fee_nonresident
form.reg_start.data = current_cycle.reg_start
form.reg_end.data = current_cycle.reg_end
if request.form.get("current_season") == 'close':
current_cycle.active = False
model.session.commit()
return redirect('seasons_edit')
return render_template("season_edit.html",
title='SeasonEdit',
form=form,
current_cycle=current_cycle,
message=message)
def review_season():
# generate list for Past Cycle Dropdown
all_cycles = model.session.query(model.SeasonCycle).\
order_by(model.SeasonCycle.id.desc()).all()
past_cycle = None
# load form to create new season_cycle (form)
form = SeasonCycleForm()
# From user input retrieve selected cycle
cycle_id = request.args.get("cycle_history")
if cycle_id != None:
past_cycle = model.session.query(model.SeasonCycle).\
get(int(cycle_id))
form.leaguename.data = past_cycle.leaguename
form.cyclename.data = past_cycle.cyclename
form.num_of_teams.data = past_cycle.num_of_teams
form.home_region.data = past_cycle.home_region
form.fee_resident.data = past_cycle.fee_resident
form.fee_nonresident.data = past_cycle.fee_nonresident
form.reg_start.data = past_cycle.reg_start
form.reg_end.data = past_cycle.reg_end
return render_template('season_view.html',
title='SeasonView',
form=form,
all_cycles=all_cycles,
past_cycle=past_cycle)
def create_season():
#load users to reset when new cycle created
users= model.session.query(model.User).all()
# load form to create new season_cycle (form)
form = SeasonCycleForm()
# create new cycle
if form.validate_on_submit():
cycle = model.session.\
add(model.SeasonCycle(admin_id= current_user.id,
leaguename= form.leaguename.data,
cyclename= form.cyclename.data,
num_of_teams= form.num_of_teams.data,
home_region= form.home_region.data,
fee_resident= form.fee_resident.data,
fee_nonresident= form.fee_nonresident.data,
reg_start= form.reg_start.data,
reg_end= form.reg_end.data,
active= True))
#print form.errors
model.session.commit()
# reset all users to false
for user in users:
user.user_registered = False
model.session.commit()
flash("Cycle created")
return redirect('seasons')
return render_template('season_create.html',
title='SeasonCreate',
form=form)
def edit_season():
current_cycle = model.session.query(model.SeasonCycle).\
filter(model.SeasonCycle.active ==True).\
first()
message = ""
form = SeasonCycleForm()
# if registration for the last season is closed
if current_cycle == None:
message = "Registration is closed. You can no longer edit."
current_cycle = model.session.query(model.SeasonCycle).\
order_by(model.SeasonCycle.id.desc()).\
first()
#Check which submit button is clicked
if request.form.get("current_season") == 'edit' and form.validate_on_submit() :
# edit current season if status is active
current_cycle.leaguename= form.leaguename.data
current_cycle.cyclename= form.cyclename.data
current_cycle.num_of_teams= form.num_of_teams.data
current_cycle.home_region= form.home_region.data
current_cycle.fee_resident= form.fee_resident.data
current_cycle.fee_nonresident= form.fee_nonresident.data
current_cycle.reg_start= form.reg_start.data
current_cycle.reg_end= form.reg_end.data
model.session.add(current_cycle)
model.session.commit()
flash('Your changes have been saved!')
else:
#renders the fields with data from database
form.leaguename.data= current_cycle.leaguename
form.cyclename.data= current_cycle.cyclename
form.num_of_teams.data= current_cycle.num_of_teams
form.home_region.data= current_cycle.home_region
form.fee_resident.data= current_cycle.fee_resident
form.fee_nonresident.data= current_cycle.fee_nonresident
form.reg_start.data= current_cycle.reg_start
form.reg_end.data= current_cycle.reg_end
if request.form.get("current_season") == 'close':
current_cycle.active = False
model.session.commit()
return redirect('seasons_edit')
return render_template("season_edit.html",
title= 'SeasonEdit',
form=form,
current_cycle= current_cycle,
message=message)
