def players_statistics_search():
form = SearchForm(request.form)
form.handle.choices = [
(player.id, player.handle)
for player in Player.query.filter_by(account_id=current_user.id).all()
]
if request.method == "GET":
return render_template(
"players/statisticsSearch.html",
form=form,
player_ranking=Player.player_ranking(id=current_user.id))
if request.method == "POST":
if not form.handle.data:
return render_template(
"players/statisticsSearch.html",
form=form,
player_ranking=Player.player_ranking(id=current_user.id),
error="Go create some stats first!")
if not form.handle.choices:
return render_template(
"players/statisticsSearch.html",
form=form,
player_ranking=Player.player_ranking(id=current_user.id),
error="Go create some stats first!")
player = Player.query.filter_by(id=form.handle.data).first()
return redirect(url_for("players_statisticsone", id=player.id))
return render_template(
"players/statisticsSearch.html",
form=form,
player_ranking=Player.player_ranking(id=current_user.id))
def players_create():
players = Player.query.filter_by(account_id=current_user.id).all()
form = PlayerForm(request.form)
form.firstTrack.choices = [(track.id, track.name)
for track in Track.query.all()]
form.secondTrack.choices = [(track.id, track.name)
for track in Track.query.all()]
form.character.choices = [(character.id, character.name)
for character in Character.query.all()]
if request.method == "GET":
return render_template("players/listplayers.html",
players=players,
form=form)
if request.method == "POST":
if not form.character.data or not form.firstTrack.data or not form.secondTrack.data or not form.handle.data:
return render_template("players/listplayers.html",
players=players,
form=form,
error="All fields must be filled out")
firstTrack = Track.query.filter_by(id=form.firstTrack.data).first()
character = Character.query.filter_by(id=form.character.data).first()
secondTrack = Track.query.filter_by(id=form.secondTrack.data).first()
handle = Player.query.filter_by(handle=form.handle.data,
account_id=current_user.id).first()
if len(form.handle.data) < 3 or len(form.handle.data) > 100 or handle:
return render_template(
"players/listplayers.html",
players=players,
form=form,
error="Name must be unique and between 3-100 characters")
player = Player(handle=form.handle.data, character_id=character.id)
player.account_id = current_user.id
db.session().add(player)
db.session().commit()
firstTrack.favoritetracks.append(player)
db.session().commit()
secondTrack.favoritetracks.append(player)
db.session().commit()
return render_template(
"players/listplayers.html",
players=Player.query.filter_by(account_id=current_user.id).all(),
form=form,
error="New player added!")
return redirect(url_for("players_create"))
def players_create(team_id):
form = PlayerForm(request.form)
p = Player(form.name.data, form.number.data)
p.team_id = team_id
db.session().add(p)
db.session().commit()
return redirect(url_for("players_index"))
def players_create():
error = None
form = PlayerForm(team_id=current_user.team_id)
if form.validate_on_submit():
try:
p = Player(number=form.number.data, name=form.name.data)
p.team_id = current_user.team_id
db.session.add(p)
db.session.commit()
flash("Player added")
except Exception as e:
error = e
return redirect(url_for("players_index"))
return render_template("/players/new.html", form=form, error=error)
def penalties_add_penalty(match_id, team_id):
form = PenaltyForm(team_id, request.form)
if not form.validate():
return render_template("penalties/new.html", form=form)
start_time = form.start_time.data
length = form.length.data
end_time = "20:00"
sel_reciever_name = str(
dict(form.reciever_name.choices).get(form.reciever_name.data))
reciever_id = Player.find_player_id(sel_reciever_name)
sel_penalty_desc_code = str(
dict(form.penaltycode.choices).get(form.penaltycode.data))
sel_penaltycode = (sel_penalty_desc_code[-4:])[:3]
penalty_id = PenaltyCode.find_penaltycode_id(sel_penaltycode)
p = Penalty(match_id, team_id, start_time, length, end_time,
reciever_id[0], penalty_id[0])
db.session().add(p)
db.session().commit()
return redirect(url_for("matches_index"))
def register_player():
form = PlayerForm(request.form)
if form.validate_on_submit():
player = Player(form.name.data, form.gender.data, form.dob.data,
form.pob.data, current_user)
db.session().add(player)
db.session().commit()
flash(u'Onnistuneesti lisätty pelaaja: %s' % player.name)
return redirect(url_for('index'))
return render_template('players/register_player.html', form=form)
def players_statisticsone(id):
return render_template(
"players/playerstatistics.html",
players=Player.query.filter_by(account_id=current_user.id).all(),
basic_stats=Player.player_basic_stats(id),
races_won=Player.player_races_won(id),
characters_played=Player.player_characters_played(id),
characters_won=Player.player_characters_won(id),
favorite_tracks=Player.player_find_favoriteTracks(id),
tracks_played=Player.player_tracks_played(id),
tracks_won=Player.player_tracks_won(id),
race_stats=Player.player_all_race_stats(id))
def index():
lists = RankingList.query.all()
for l in lists:
l.populate_players()
tournaments = Tournament.query.filter_by(is_published=True).all()
for t in tournaments:
t.num_players = t.get_num_players()
player_data = Player.get_aggregate_summary()
return render_template('index.html',
player_data=player_data,
rankings=lists,
tournaments=tournaments)
def races_index():
races = Race.query.filter_by(account_id=current_user.id).all()
for race in races:
character = Character.query.filter_by(id=race.character_id).first()
race.character = character.name
track = Track.query.filter_by(id=race.track_id).first()
race.track = track.name
player = Player.query.filter_by(id=race.player_id).first()
race.player = player.handle
return render_template(
"races/listraces.html",
races=races,
player_ranking=Player.player_ranking(id=current_user.id))
def goals_add_goal(match_id, team_id):
form = GoalForm(team_id, request.form)
if not form.validate():
return render_template("goals/new.html", form=form)
time = form.time.data
sel_scorer_name = str(
dict(form.scorer_name.choices).get(form.scorer_name.data))
scorer_id = Player.find_player_id(sel_scorer_name)
sel_assistant_1_name = str(
dict(form.assistant_1_name.choices).get(form.assistant_1_name.data))
assistant_1_id = Player.find_player_id(sel_assistant_1_name)
sel_assistant_2_name = str(
dict(form.assistant_2_name.choices).get(form.assistant_2_name.data))
assistant_2_id = Player.find_player_id(sel_assistant_2_name)
g = Goal(match_id, team_id, time, scorer_id[0], assistant_1_id[0],
assistant_2_id[0])
db.session().add(g)
db.session().commit()
m = Match.query.get(match_id)
if str(m.home_team_id) == str(team_id):
m.home_team_score = m.home_team_score + 1
else:
m.away_team_score = m.away_team_score + 1
db.session().commit()
return redirect(url_for("matches_index"))
def players_create():
form = PlayerForm(request.form)
if not form.validate():
return render_template("players/new.html", form=form)
pl = Player(form.player_tag.data)
pl.account_id = current_user.id
pl.top = form.top.data
pl.jgl = form.jgl.data
pl.mid = form.mid.data
pl.adc = form.adc.data
pl.sup = form.sup.data
db.session().add(pl)
db.session().commit()
return redirect(url_for("players_index"))
def players_create():
form = PlayerForm(request.form)
if not form.validate():
return render_template("players/new.html", form=form)
sel_team_name = str(dict(form.team_name.choices).get(form.team_name.data))
team_id = Team.find_team_id(sel_team_name)
p = Player(form.name.data, form.number.data, form.position.data,
team_id[0])
db.session().add(p)
db.session().commit()
return redirect(url_for("players_index"))
def stats_add(game_id):
error = None
form = StatForm(game_id=game_id)
game = Game.query.filter_by(id=game_id).first_or_404()
players = Player.list_all(current_user.team_id)
players_list = [(p['id'], p['name']) for p in players]
form.player_id.choices = players_list
if form.validate_on_submit():
try:
s = Stat(game_id=form.game_id.data,
player_id=form.player_id.data,
goals=form.goals.data,
assists=form.assists.data,
penalties=form.penalties.data)
db.session.add(s)
db.session.commit()
flash("statistic added")
except Exception as e:
error = e
return render_template("/stats/add.html", form=form, error=error)
def players_delete(player_id):
print("player ID:" + str(player_id))
Player.delete_player(player_id)
return redirect(url_for("players_index"))
def players_statistics():
return render_template("players/statistics.html",
goals=Player.player_goals(),
totalpoints=Player.player_total_points(),
totalassists=Player.player_assists(),
totalminutes=Player.player_penalties())
def players_index():
return render_template("players/list.html", players=Player.all_players())
def __init__(self, team_id, *args, **kwargs):
FlaskForm.__init__(self, *args, **kwargs)
self.team_id = team_id
self.scorer_name.choices = Player.team_players(team_id)
self.assistant_1_name.choices = Player.team_players(team_id)
self.assistant_2_name.choices = Player.team_players(team_id)
def index():
return render_template("index.html",
num_of_forwards=Player.num_of_forwards())
def __init__(self, team_id, *args, **kwargs):
FlaskForm.__init__(self, *args, **kwargs)
self.team_id = team_id
self.reciever_name.choices = Player.team_players(team_id)
self.penaltycode.choices = PenaltyCode.all_penaltycode_data()
def teamless_players():
return render_template("players/teamless.html",
noteamplayers=Player.get_players_noteam())
