def player_averages(request, player_id):
player = get_object_or_404(Player, id=player_id)
try:
day_range = int(request.GET["day_range"])
except KeyError:
day_range = 20
try:
season = request.GET["season"]
except KeyError:
season = Game.objects.latest("endDateTime").season
teamstrength = "even"
scoresituation = "all"
period = "all"
currentSeason = Game.objects.latest("endDateTime").season
form = GameFilterForm()
startDate = None
endDate = None
venues = []
teams = []
if request.method == 'GET':
form = GameFilterForm(request.GET)
if form.is_valid():
cd = form.cleaned_data
teamstrength = cd["teamstrengths"]
scoresituation = cd["scoresituation"]
period = cd["period"]
startDate = cd["startDate"]
endDate = cd["endDate"]
venues = cd["venues"]
teams = cd["teams"]
gameids = Game.objects.values_list(
"gamePk", flat=True).filter(gameState__in=[5, 6, 7])
if startDate is not None:
gameids = gameids.filter(dateTime__date__gte=startDate)
if endDate is not None:
gameids = gameids.filter(dateTime__date__lte=endDate)
if len(venues) > 0:
gameids = gameids.filter(venue__in=venues)
if len(teams) > 0:
gameids = gameids.filter(
Q(homeTeam__in=cd['teams']) | Q(awayTeam__in=cd['teams']))
gameids = [x for x in gameids]
pgs = PlayerGameFilterStats.objects.raw(
playerqueries.playeravgquery,
[gameids, season, scoresituation, teamstrength, period, player.id])
stats = {}
first = True
drange = int(day_range / 2)
ld = None
valid_days = set([x.dateTime.strftime("%Y-%m-%d") for x in pgs])
raw_stats = {}
for row in pgs:
row = row.__dict__
row.pop("_state", None)
d = row["dateTime"].date()
if not first:
days = xrange(-drange, drange + 1)
else:
days = xrange(0, drange + 1)
first = False
for i in days:
dt = (d + timedelta(days=i)).strftime("%Y-%m-%d")
if dt in valid_days:
if dt not in stats:
stats[dt] = {"games": 0, "dateString": dt}
for key, value in row.items():
if key not in {
"season", "abbreviation", "teamName", "shortName",
"displayName", "fullName", "player_id", "team_id",
"game_id", "id", "dateTime", "games"
}:
if key not in stats[dt]:
stats[dt][key] = 0
stats[dt][key] += value
stats[dt]["games"] += 1
ld = d.strftime("%Y-%m-%d")
raw_stats[ld] = {"games": 1, "dateString": ld}
for key, value in row.items():
if key not in {
"season", "abbreviation", "teamName", "shortName",
"displayName", "fullName", "player_id", "team_id",
"game_id", "id", "dateTime", "games"
}:
if key not in raw_stats[ld]:
raw_stats[ld][key] = 0
raw_stats[ld][key] += value
#[stats.pop(x) for x in stats.keys() if x > ld] # removes dates > last game
for dt in stats:
row = stats[dt]
for key, value in row.items():
if type(value) != str and key not in {
"season", "abbreviation", "teamName", "shortName",
"displayName", "fullName", "player_id", "team_id",
"game_id", "id", "dateTime", "games"
}:
stats[dt][key] = stats[dt][key] / stats[dt]["games"]
toiSeconds = row["toi"]
row["toi"] = toi.format_minutes(row["toi"] / row["games"])
row["toiSeconds"] = toiSeconds
row["fo"] = '%.1f' % corsi.corsi_percent(row["fo_w"], row["fo_l"])
row["sf"] = '%.1f' % corsi.corsi_percent(row["shotsFor"],
row["shotsAgainst"])
row["msf"] = '%.1f' % corsi.corsi_percent(row["missedShotsFor"],
row["missedShotsAgainst"])
row["bsf"] = '%.1f' % corsi.corsi_percent(row["blockedShotsFor"],
row["blockedShotsAgainst"])
row["gf"] = '%.1f' % corsi.corsi_percent(row["goalsFor"],
row["goalsAgainst"])
row["cf"] = '%.1f' % corsi.corsi_percent(row["corsiFor"],
row["corsiAgainst"])
row["ff"] = '%.1f' % corsi.corsi_percent(row["fenwickFor"],
row["fenwickAgainst"])
row["hit"] = '%.1f' % corsi.corsi_percent(row["hitFor"],
row["hitAgainst"])
row["pn"] = '%.1f' % corsi.corsi_percent(row["penaltyFor"],
row["penaltyAgainst"])
row["scf"] = '%.1f' % corsi.corsi_percent(row["scoringChancesFor"],
row["scoringChancesAgainst"])
row["hscf"] = '%.1f' % corsi.corsi_percent(
row["highDangerScoringChancesFor"],
row["highDangerScoringChancesAgainst"])
row['gf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["goalsFor"]) * 60)
row['a60'] = '%.1f' % (corsi.corsi_for_60(
toiSeconds, row["assists1"] + row["assists2"]) * 60)
row['assists'] = row["assists1"] + row["assists2"]
row['a160'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["assists1"]) * 60)
row['a260'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["assists2"]) * 60)
row['p60'] = '%.1f' % (corsi.corsi_for_60(toiSeconds, row["points"]) *
60)
row['scf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["scoringChancesFor"]) * 60)
row['cf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["corsiFor"]) * 60)
row['ca60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["corsiAgainst"]) * 60)
row['ff60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["fenwickFor"]) * 60)
row['fa60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["fenwickAgainst"]) * 60)
row['hscf60'] = '%.1f' % (corsi.corsi_for_60(
toiSeconds, row["highDangerScoringChancesFor"]) * 60)
row['csh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['corsiFor'])
row['csa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['corsiAgainst']))
row['fsh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['fenwickFor'])
row['fsa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['fenwickAgainst']))
if row["neutralZoneStarts"] is not None:
row["zso"] = '%.1f' % corsi.corsi_percent(
row["offensiveZoneStarts"], row["defensiveZoneStarts"])
else:
row["zso"] = 0
for dt in raw_stats:
row = raw_stats[dt]
toiSeconds = row["toi"]
row["toi"] = toi.format_minutes(row["toi"] / row["games"])
row["toiSeconds"] = toiSeconds
row["fo"] = '%.1f' % corsi.corsi_percent(row["fo_w"], row["fo_l"])
row["sf"] = '%.1f' % corsi.corsi_percent(row["shotsFor"],
row["shotsAgainst"])
row["msf"] = '%.1f' % corsi.corsi_percent(row["missedShotsFor"],
row["missedShotsAgainst"])
row["bsf"] = '%.1f' % corsi.corsi_percent(row["blockedShotsFor"],
row["blockedShotsAgainst"])
row["gf"] = '%.1f' % corsi.corsi_percent(row["goalsFor"],
row["goalsAgainst"])
row["cf"] = '%.1f' % corsi.corsi_percent(row["corsiFor"],
row["corsiAgainst"])
row["ff"] = '%.1f' % corsi.corsi_percent(row["fenwickFor"],
row["fenwickAgainst"])
row["hit"] = '%.1f' % corsi.corsi_percent(row["hitFor"],
row["hitAgainst"])
row["pn"] = '%.1f' % corsi.corsi_percent(row["penaltyFor"],
row["penaltyAgainst"])
row["scf"] = '%.1f' % corsi.corsi_percent(row["scoringChancesFor"],
row["scoringChancesAgainst"])
row["hscf"] = '%.1f' % corsi.corsi_percent(
row["highDangerScoringChancesFor"],
row["highDangerScoringChancesAgainst"])
row['gf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["goalsFor"]) * 60)
row['a60'] = '%.1f' % (corsi.corsi_for_60(
toiSeconds, row["assists1"] + row["assists2"]) * 60)
row['a160'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["assists1"]) * 60)
row['p60'] = '%.1f' % (corsi.corsi_for_60(toiSeconds, row["points"]) *
60)
row['scf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["scoringChancesFor"]) * 60)
row['cf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["corsiFor"]) * 60)
row['ca60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["corsiAgainst"]) * 60)
row['ff60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["fenwickFor"]) * 60)
row['fa60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["fenwickAgainst"]) * 60)
row['hscf60'] = '%.1f' % (corsi.corsi_for_60(
toiSeconds, row["highDangerScoringChancesFor"]) * 60)
row['csh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['corsiFor'])
row['csa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['corsiAgainst']))
row['fsh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['fenwickFor'])
row['fsa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['fenwickAgainst']))
if row["neutralZoneStarts"] is not None:
row["zso"] = '%.1f' % corsi.corsi_percent(
row["offensiveZoneStarts"], row["defensiveZoneStarts"])
else:
row["zso"] = 0
return JsonResponse({
"days":
sorted(stats.values(), key=lambda d: d["dateString"]),
"raw_data":
sorted(raw_stats.values(), key=lambda d: d["dateString"])
})
def player_page(request, player_id):
player = get_object_or_404(Player, id=player_id)
player.age = int((arrow.now() - arrow.get(player.birthDate)).days / 365.25)
teamstrength = "even"
scoresituation = "all"
period = "all"
currentSeason = Game.objects.latest("endDateTime").season
form = GameFilterForm()
startDate = None
endDate = None
venues = []
teams = []
if request.method == 'GET':
form = GameFilterForm(request.GET)
if form.is_valid():
cd = form.cleaned_data
teamstrength = cd["teamstrengths"]
scoresituation = cd["scoresituation"]
period = cd["period"]
startDate = cd["startDate"]
endDate = cd["endDate"]
venues = cd["venues"]
teams = cd["teams"]
gameids = Game.objects.values_list(
"gamePk", flat=True).filter(gameState__in=[5, 6, 7])
if startDate is not None:
gameids = gameids.filter(dateTime__date__gte=startDate)
if endDate is not None:
gameids = gameids.filter(dateTime__date__lte=endDate)
if len(venues) > 0:
gameids = gameids.filter(venue__in=venues)
if len(teams) > 0:
gameids = gameids.filter(
Q(homeTeam__in=cd['teams']) | Q(awayTeam__in=cd['teams']))
gameids = [x for x in gameids]
pgs = PlayerGameFilterStats.objects.raw(
playerqueries.playerquery,
[gameids, scoresituation, teamstrength, period, player.id])
stats = {}
currTeam = None
for row in pgs:
season = row.season
playerid = player.id
if playerid not in stats:
stats[playerid] = {}
if season not in stats[playerid]:
stats[playerid][season] = row.__dict__
stats[playerid][season]["games"] = 1
stats[playerid][season]['game_ids'] = [
row.__dict__['game_id'],
]
stats[playerid][season].pop("_state", None)
stats[playerid][season].pop("game_id", None)
stats[playerid][season].pop("period", None)
stats[playerid][season].pop("teamstrength", None)
stats[playerid][season].pop("scoresituation", None)
stats[playerid][season].pop("player_id", None)
else:
stats[playerid][season]["games"] += 1
stats[playerid][season]['game_ids'].append(row.__dict__['game_id'])
for key in stats[playerid][season]:
if key not in [
"season", "abbreviation", "teamName", "shortName",
"displayName", "fullName"
]:
try:
stats[playerid][season][key] += row.__dict__[key]
except:
pass
elif key == "abbreviation":
if stats[playerid][season][key] != row.__dict__[key]:
stats[playerid][season][key] += u", {}".format(
row.__dict__[key])
elif key == "teamName":
if stats[playerid][season][key] != row.__dict__[key]:
stats[playerid][season][key] += u", {}".format(
row.__dict__[key])
elif key == "shortName":
if stats[playerid][season][key] != row.__dict__[key]:
stats[playerid][season][key] += u", {}".format(
row.__dict__[key])
currTeam = {
"name": row.teamName,
"shortName": row.shortName,
"abbreviation": row.abbreviation
}
for playerid in stats:
for season in stats[playerid]:
row = stats[playerid][season]
toiSeconds = row["toi"]
row["toi"] = toi.format_minutes(row["toi"] / row["games"])
row["fo"] = '%.1f' % corsi.corsi_percent(row["fo_w"], row["fo_l"])
row["sf"] = '%.1f' % corsi.corsi_percent(row["shotsFor"],
row["shotsAgainst"])
row["msf"] = '%.1f' % corsi.corsi_percent(
row["missedShotsFor"], row["missedShotsAgainst"])
row["bsf"] = '%.1f' % corsi.corsi_percent(
row["blockedShotsFor"], row["blockedShotsAgainst"])
row["gf"] = '%.1f' % corsi.corsi_percent(row["goalsFor"],
row["goalsAgainst"])
row["cf"] = '%.1f' % corsi.corsi_percent(row["corsiFor"],
row["corsiAgainst"])
row["ff"] = '%.1f' % corsi.corsi_percent(row["fenwickFor"],
row["fenwickAgainst"])
row["hit"] = '%.1f' % corsi.corsi_percent(row["hitFor"],
row["hitAgainst"])
row["pn"] = '%.1f' % corsi.corsi_percent(row["penaltyFor"],
row["penaltyAgainst"])
row["scf"] = '%.1f' % corsi.corsi_percent(
row["scoringChancesFor"], row["scoringChancesAgainst"])
row["hscf"] = '%.1f' % corsi.corsi_percent(
row["highDangerScoringChancesFor"],
row["highDangerScoringChancesAgainst"])
row['gf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["goalsFor"]) * 60)
row['a60'] = '%.1f' % (corsi.corsi_for_60(
toiSeconds, row["assists1"] + row["assists2"]) * 60)
row['a160'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["assists1"]) * 60)
row['p60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["points"]) * 60)
row['scf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["scoringChancesFor"]) * 60)
row['cf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["corsiFor"]) * 60)
row['ca60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["corsiAgainst"]) * 60)
row['ff60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["fenwickFor"]) * 60)
row['fa60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["fenwickAgainst"]) * 60)
row['hscf60'] = '%.1f' % (corsi.corsi_for_60(
toiSeconds, row["highDangerScoringChancesFor"]) * 60)
row['csh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['corsiFor'])
row['csa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['corsiAgainst']))
row['fsh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['fenwickFor'])
row['fsa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['fenwickAgainst']))
if row["neutralZoneStarts"] is not None:
row["zso"] = '%.1f' % corsi.corsi_percent(
row["offensiveZoneStarts"], row["defensiveZoneStarts"])
else:
row["zso"] = 0
context = {}
context["player"] = player
context["stats"] = stats
context["team"] = currTeam
if request.method == "GET" and "format" in request.GET and request.GET[
"format"] == "json":
context["player"] = context["player"].__dict__
context["player"].pop("_state", None)
return JsonResponse(context)
context["form"] = form
context["statsJson"] = json.dumps(stats, cls=DjangoJSONEncoder)
context["player_id"] = player_id
return render(request, 'players/player_page.html', context)
def goalie_page(request, player_id):
player = get_object_or_404(Player, id=player_id)
player.age = int((arrow.now() - arrow.get(player.birthDate)).days / 365.25)
teamstrength = "even"
scoresituation = "all"
period = "all"
currentSeason = Game.objects.latest("endDateTime").season
form = GameFilterForm()
startDate = None
endDate = None
venues = []
teams = []
if request.method == 'GET':
form = GameFilterForm(request.GET)
if form.is_valid():
cd = form.cleaned_data
teamstrength = cd["teamstrengths"]
scoresituation = cd["scoresituation"]
period = cd["period"]
startDate = cd["startDate"]
endDate = cd["endDate"]
venues = cd["venues"]
teams = cd["teams"]
gameids = Game.objects.values_list(
"gamePk", flat=True).filter(gameState__in=[5, 6, 7])
if startDate is not None:
gameids = gameids.filter(dateTime__date__gte=startDate)
if endDate is not None:
gameids = gameids.filter(dateTime__date__lte=endDate)
if len(venues) > 0:
gameids = gameids.filter(venue__in=venues)
if len(teams) > 0:
gameids = gameids.filter(
Q(homeTeam__in=cd['teams']) | Q(awayTeam__in=cd['teams']))
gameids = [x for x in gameids]
pgs = GoalieGameFilterStats.objects.raw(
playerqueries.goaliequery,
[gameids, scoresituation, teamstrength, period, player.id])
sdata = GoalieGameFilterStats.objects.raw(
playerqueries.goalieshotsquery,
[gameids, scoresituation, teamstrength, period])
low_shots = 0
medium_shots = 0
high_shots = 0
for s in sdata:
low_shots += s.savesLow + s.goalsLow
medium_shots += s.savesMedium + s.goalsMedium
high_shots += s.savesHigh + s.goalsHigh
stats = {}
for row in pgs:
season = row.season
playerid = player.id
if playerid not in stats:
stats[playerid] = {}
if season not in stats[playerid]:
stats[playerid][season] = row.__dict__
stats[playerid][season]["games"] = 1
stats[playerid][season]['game_ids'] = [
row.__dict__['game_id'],
]
stats[playerid][season].pop("_state", None)
stats[playerid][season].pop("game_id", None)
stats[playerid][season].pop("period", None)
stats[playerid][season].pop("teamstrength", None)
stats[playerid][season].pop("scoresituation", None)
stats[playerid][season].pop("player_id", None)
else:
stats[playerid][season]["games"] += 1
stats[playerid][season]['game_ids'].append(row.__dict__['game_id'])
for key in stats[playerid][season]:
if key not in [
"abbreviation", "teamName", "shortName", "displayName",
"fullName", "season"
]:
try:
stats[playerid][season][key] += row.__dict__[key]
except:
pass
elif key == "abbreviation":
if stats[playerid][season][key] != row.__dict__[key]:
stats[playerid][season][key] += u", {}".format(
row.__dict__[key])
elif key == "teamName":
if stats[playerid][season][key] != row.__dict__[key]:
stats[playerid][season][key] += u", {}".format(
row.__dict__[key])
elif key == "shortName":
if stats[playerid][season][key] != row.__dict__[key]:
stats[playerid][season][key] += u", {}".format(
row.__dict__[key])
for playerid in stats:
for season in stats[playerid]:
goalie = stats[playerid][season]
goalie["toiSeconds"] = goalie["toi"] / goalie["games"]
goalie["toi"] = toi.format_minutes(goalie["toi"] / goalie["games"])
goalie['saves'] = goalie['savesLow'] + goalie[
'savesMedium'] + goalie['savesHigh'] + goalie['savesUnknown']
goalie['goals'] = goalie['goalsLow'] + goalie[
'goalsMedium'] + goalie['goalsHigh'] + goalie['goalsUnknown']
goalie['save_percent'] = '%.1f' % corsi.corsi_percent(
goalie['saves'], goalie['goals'])
goalie['low_save_percent'] = '%.1f' % corsi.corsi_percent(
goalie['savesLow'], goalie['goalsLow'])
goalie['medium_save_percent'] = '%.1f' % corsi.corsi_percent(
goalie['savesMedium'], goalie['goalsMedium'])
goalie['high_save_percent'] = '%.1f' % corsi.corsi_percent(
goalie['savesHigh'], goalie['goalsHigh'])
goalie['unknown_save_percent'] = '%.1f' % corsi.corsi_percent(
goalie['savesUnknown'], goalie['goalsUnknown'])
goalie['adj_save_percent'] = adj_save_percent(
goalie['savesLow'], goalie['savesMedium'], goalie['savesHigh'],
goalie['goalsLow'], goalie['goalsMedium'], goalie['goalsHigh'],
low_shots, medium_shots, high_shots)
context = {}
context["player"] = player
context["stats"] = stats
if request.method == "GET" and "format" in request.GET and request.GET[
"format"] == "json":
context["player"] = context["player"].__dict__
context["player"].pop("_state", None)
return JsonResponse(context)
context["form"] = form
context["statsJson"] = json.dumps(stats, cls=DjangoJSONEncoder)
return render(request, 'players/goalie_page.html', context)
def goalies(request):
teamstrength = "even"
scoresituation = "all"
period = "all"
currentSeason = Game.objects.latest("endDateTime").season
seasons = [
currentSeason,
]
form = PlayerFilterForm()
startDate = None
endDate = None
venues = []
teams = []
min_toi = None
max_toi = None
min_games = None
gameTypes = None
if request.method == 'GET':
form = PlayerFilterForm(request.GET)
if form.is_valid():
cd = form.cleaned_data
teamstrength = cd["teamstrengths"]
scoresituation = cd["scoresituation"]
period = cd["period"]
startDate = cd["startDate"]
endDate = cd["endDate"]
venues = cd["venues"]
teams = cd["teams"]
seasons = [
cd["season"],
]
min_toi = cd["min_toi"]
max_toi = cd["max_toi"]
min_games = cd["games_played"]
gameTypes = request.GET.get('gameTypes', None)
if len(seasons) == 0:
seasons = [
currentSeason,
]
gameids = Game.objects.values_list(
"gamePk", flat=True).filter(gameState__in=[5, 6, 7])
if startDate is not None:
gameids = gameids.filter(dateTime__date__gte=startDate)
if endDate is not None:
gameids = gameids.filter(dateTime__date__lte=endDate)
if len(venues) > 0:
gameids = gameids.filter(venue__in=venues)
if len(teams) > 0:
gameids = gameids.filter(
Q(homeTeam__in=cd['teams']) | Q(awayTeam__in=cd['teams']))
if gameTypes:
gameids = gameids.filter(gameType__in=gameTypes)
gameids = [x for x in gameids]
teamnames = {}
teamstemp = Team.objects.all()
for team in teamstemp:
teamnames[team.id] = team.abbreviation
numTeams = len(teamnames)
stats = {}
goalies = GoalieGameFilterStats.objects.raw(
playerqueries.goaliesquery,
[seasons, gameids, scoresituation, teamstrength, period])
goalies = [g for g in goalies]
low_shots = 0
medium_shots = 0
high_shots = 0
for goalie in goalies:
row = goalie.__dict__
row.pop('_state')
low_shots += row['savesLow'] + row['goalsLow']
medium_shots += row['savesMedium'] + row['goalsMedium']
high_shots += row['savesHigh'] + row['goalsHigh']
if "team" not in row:
row["team"] = teamnames[row["team_id"]]
if row['player_id'] not in stats:
stats[row['player_id']] = row
stats[row['player_id']]['games'] = 1
stats[row['player_id']]['game_ids'] = [
row['game_id'],
]
else:
player_id = row['player_id']
stats[player_id]['games'] += 1
stats[player_id]['game_ids'].append(row['game_id'])
for key in row:
if key not in [
'player_id', 'game_id', 'team_id', 'season',
'fullName', 'team'
]:
val = row[key]
stats[player_id][key] += val
remove = set()
for pid in stats:
goalie = stats[pid]
if min_toi:
if goalie["toi"] < min_toi * 60 * goalie['games']:
remove.add(pid)
continue
if max_toi:
if goalie['toi'] >= max_toi * 60 * goalie['games']:
remove.add(pid)
continue
if min_games:
if goalie['games'] < min_games:
remove.add(pid)
continue
goalie["toiSeconds"] = goalie["toi"]
goalie["toi"] = toi.format_minutes(goalie["toi"] / goalie["games"])
goalie['saves'] = goalie['savesLow'] + goalie['savesMedium'] + goalie[
'savesHigh'] + goalie['savesUnknown']
goalie['goals'] = goalie['goalsLow'] + goalie['goalsMedium'] + goalie[
'goalsHigh'] + goalie['goalsUnknown']
goalie['save_percent'] = '%.1f' % corsi.corsi_percent(
goalie['saves'], goalie['goals'])
goalie['low_save_percent'] = '%.1f' % corsi.corsi_percent(
goalie['savesLow'], goalie['goalsLow'])
goalie['medium_save_percent'] = '%.1f' % corsi.corsi_percent(
goalie['savesMedium'], goalie['goalsMedium'])
goalie['high_save_percent'] = '%.1f' % corsi.corsi_percent(
goalie['savesHigh'], goalie['goalsHigh'])
goalie['unknown_save_percent'] = '%.1f' % corsi.corsi_percent(
goalie['savesUnknown'], goalie['goalsUnknown'])
goalie['adj_save_percent'] = adj_save_percent(
goalie['savesLow'], goalie['savesMedium'], goalie['savesHigh'],
goalie['goalsLow'], goalie['goalsMedium'], goalie['goalsHigh'],
low_shots, medium_shots, high_shots)
for r in remove:
del stats[r]
context = {}
context['stats'] = stats.values()
if request.method == "GET" and "format" in request.GET and request.GET[
"format"] == "json":
return JsonResponse(context)
context['form'] = form
context["statsJson"] = json.dumps(stats.values(), cls=DjangoJSONEncoder)
return render(request, 'players/goalies.html', context)
def players(request):
teamstrength = "even"
scoresituation = "all"
period = "all"
currentSeason = Game.objects.latest("endDateTime").season
seasons = [
currentSeason,
]
form = PlayerFilterForm()
startDate = None
endDate = None
venues = []
teams = []
min_toi = None
max_toi = None
min_games = None
gameTypes = None
if request.method == 'GET':
form = PlayerFilterForm(request.GET)
if form.is_valid():
cd = form.cleaned_data
teamstrength = cd["teamstrengths"]
scoresituation = cd["scoresituation"]
period = cd["period"]
startDate = cd["startDate"]
endDate = cd["endDate"]
venues = cd["venues"]
teams = cd["teams"]
seasons = [
cd["season"],
]
min_toi = cd["min_toi"]
max_toi = cd["max_toi"]
min_games = cd['games_played']
gameTypes = cd['gameTypes']
if len(seasons) == 0:
seasons = [
currentSeason,
]
gameids = Game.objects.values_list(
"gamePk", flat=True).filter(gameState__in=[5, 6, 7])
if startDate is not None:
gameids = gameids.filter(dateTime__date__gte=startDate)
if endDate is None:
endDate = arrow.utcnow().datetime
if endDate is not None:
gameids = gameids.filter(dateTime__date__lte=endDate)
if len(venues) > 0:
gameids = gameids.filter(venue__in=venues)
if len(teams) > 0:
gameids = gameids.filter(
Q(homeTeam__in=cd['teams']) | Q(awayTeam__in=cd['teams']))
if gameTypes:
gameids = gameids.filter(gameType__in=gameTypes)
gameids = [x for x in gameids]
teamnames = {}
teamstemp = Team.objects.all()
for team in teamstemp:
teamnames[team.id] = team.abbreviation
numTeams = len(teamnames)
if not teams:
teams = Team.objects.all()
stats = []
if (not startDate and not endDate and (not teams or len(teams) == numTeams)
and not venues
and not (gameTypes is not None and len(gameTypes) != 2)):
players = PlayersPrecalc.objects.raw(
playerqueries.precalc_players,
[seasons, scoresituation, teamstrength, period])
players = [p for p in players]
for p in players:
row = p.__dict__
row.pop("_state")
toiSeconds = row["toi"]
row["toiSeconds"] = toiSeconds
row["toi"] = toi.format_minutes(row["toi"] / row["games"])
row["player_id"] = row["player"]
row['ca60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["corsiAgainst"]) * 60)
row['fa60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["fenwickAgainst"]) * 60)
row['csh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['corsiFor'])
row['csa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['corsiAgainst']))
row['fsh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['fenwickFor'])
row['fsa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['fenwickAgainst']))
stats.append(row)
elif (startDate is not None and endDate is not None
and (gameTypes is not None and len(gameTypes) != 2)):
players = PlayerGameFilterStats.objects.raw(
playerqueries.playersquery_historical_daterange,
[startDate, endDate, scoresituation, teamstrength, period])
players = [p for p in players]
for playerid in players:
row = playerid.__dict__
row.pop("_state")
toiSeconds = row["toi"]
row["team"] = teamnames[row["team_id"]]
row["toi"] = toi.format_minutes(row["toi"] / row["games"])
row["toiSeconds"] = toiSeconds
row["fo"] = '%.1f' % corsi.corsi_percent(row["fo_w"], row["fo_l"])
row["sf"] = '%.1f' % corsi.corsi_percent(row["shotsFor"],
row["shotsAgainst"])
row["msf"] = '%.1f' % corsi.corsi_percent(
row["missedShotsFor"], row["missedShotsAgainst"])
row["bsf"] = '%.1f' % corsi.corsi_percent(
row["blockedShotsFor"], row["blockedShotsAgainst"])
row["gf"] = '%.1f' % corsi.corsi_percent(row["goalsFor"],
row["goalsAgainst"])
row["cf"] = '%.1f' % corsi.corsi_percent(row["corsiFor"],
row["corsiAgainst"])
row["ff"] = '%.1f' % corsi.corsi_percent(row["fenwickFor"],
row["fenwickAgainst"])
row["hit"] = '%.1f' % corsi.corsi_percent(row["hitFor"],
row["hitAgainst"])
row["pn"] = '%.1f' % corsi.corsi_percent(row["penaltyFor"],
row["penaltyAgainst"])
row["scf"] = '%.1f' % corsi.corsi_percent(
row["scoringChancesFor"], row["scoringChancesAgainst"])
row["hscf"] = '%.1f' % corsi.corsi_percent(
row["highDangerScoringChancesFor"],
row["highDangerScoringChancesAgainst"])
row['gf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["goalsFor"]) * 60)
row['a60'] = '%.1f' % (corsi.corsi_for_60(
toiSeconds, row["assists1"] + row["assists2"]) * 60)
row['a160'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["assists1"]) * 60)
row['p60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["points"]) * 60)
row['scf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["scoringChancesFor"]) * 60)
row['cf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["corsiFor"]) * 60)
row['ca60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["corsiAgainst"]) * 60)
row['ff60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["fenwickFor"]) * 60)
row['fa60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["fenwickAgainst"]) * 60)
row['hscf60'] = '%.1f' % (corsi.corsi_for_60(
toiSeconds, row["highDangerScoringChancesFor"]) * 60)
row['csh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['corsiFor'])
row['csa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['corsiAgainst']))
row['fsh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['fenwickFor'])
row['fsa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['fenwickAgainst']))
if row["neutralZoneStarts"] is not None:
row["zso"] = '%.1f' % corsi.corsi_percent(
row["offensiveZoneStarts"],
row["neutralZoneStarts"] + row["defensiveZoneStarts"])
else:
row["zso"] = "0.0"
stats.append(row)
else:
playergames = PlayerGameFilterStats.objects.raw(
playerqueries.playersquery, [
seasons, gameids, scoresituation, teamstrength, period,
[x.id for x in teams]
])
players = {}
print playergames.query
for player in playergames:
player = player.__dict__
if player["player_id"] not in players:
player.pop("_state")
players[player["player_id"]] = player
players[player["player_id"]]["games"] = 1
else:
for key in player:
if key not in [
"_state", "id", "player_id", "game_id", "team_id",
"season", "abbreviation", "shortName", "teamName",
"fullName"
]:
players[player["player_id"]][key] += player[key]
players[player["player_id"]]["games"] += 1
for playerid in players:
row = players[playerid]
toiSeconds = row["toi"]
row["team"] = teamnames[row["team_id"]]
row["toiSeconds"] = toiSeconds
row["toi"] = toi.format_minutes(row["toi"] / row["games"])
row["fo"] = '%.1f' % corsi.corsi_percent(row["fo_w"], row["fo_l"])
row["sf"] = '%.1f' % corsi.corsi_percent(row["shotsFor"],
row["shotsAgainst"])
row["msf"] = '%.1f' % corsi.corsi_percent(
row["missedShotsFor"], row["missedShotsAgainst"])
row["bsf"] = '%.1f' % corsi.corsi_percent(
row["blockedShotsFor"], row["blockedShotsAgainst"])
row["gf"] = '%.1f' % corsi.corsi_percent(row["goalsFor"],
row["goalsAgainst"])
row["cf"] = '%.1f' % corsi.corsi_percent(row["corsiFor"],
row["corsiAgainst"])
row["ff"] = '%.1f' % corsi.corsi_percent(row["fenwickFor"],
row["fenwickAgainst"])
row["hit"] = '%.1f' % corsi.corsi_percent(row["hitFor"],
row["hitAgainst"])
row["pn"] = '%.1f' % corsi.corsi_percent(row["penaltyFor"],
row["penaltyAgainst"])
row["scf"] = '%.1f' % corsi.corsi_percent(
row["scoringChancesFor"], row["scoringChancesAgainst"])
row["hscf"] = '%.1f' % corsi.corsi_percent(
row["highDangerScoringChancesFor"],
row["highDangerScoringChancesAgainst"])
row['gf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["goalsFor"]) * 60)
row['a60'] = '%.1f' % (corsi.corsi_for_60(
toiSeconds, row["assists1"] + row["assists2"]) * 60)
row['a160'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["assists1"]) * 60)
row['p60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["points"]) * 60)
row['scf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["scoringChancesFor"]) * 60)
row['cf60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["corsiFor"]) * 60)
row['ca60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["corsiAgainst"]) * 60)
row['ff60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["fenwickFor"]) * 60)
row['fa60'] = '%.1f' % (
corsi.corsi_for_60(toiSeconds, row["fenwickAgainst"]) * 60)
row['hscf60'] = '%.1f' % (corsi.corsi_for_60(
toiSeconds, row["highDangerScoringChancesFor"]) * 60)
row['csh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['corsiFor'])
row['csa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['corsiAgainst']))
row['fsh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'],
row['fenwickFor'])
row['fsa'] = '%.1f' % (100 - corsi.corsi_percent(
row['goalsAgainst'], row['fenwickAgainst']))
if row["neutralZoneStarts"] is not None:
row["zso"] = '%.1f' % corsi.corsi_percent(
row["offensiveZoneStarts"],
row["neutralZoneStarts"] + row["defensiveZoneStarts"])
else:
row["zso"] = "0.0"
stats.append(row)
remove = []
if min_toi or max_toi or min_games:
for pid in xrange(len(stats)):
row = stats[pid]
if min_toi:
if row["toiSeconds"] < min_toi * 60 * row['games']:
remove.append(pid)
continue
if max_toi:
if row['toiSeconds'] > max_toi * 60 * row['games']:
remove.append(pid)
continue
if min_games:
if row['games'] < min_games:
remove.append(pid)
for r in reversed(remove):
del stats[r]
context = {}
context["stats"] = stats
if request.method == "GET" and "format" in request.GET and request.GET[
"format"] == "json":
pgidlist = PlayerGameFilterStats.objects.raw(
playerqueries.playeridquery,
[gameids, scoresituation, teamstrength, period])
pgids = {}
for pgid in pgidlist:
if pgid.player_id not in pgids:
pgids[pgid.player_id] = {}
season = int(
str(pgid.game_id)[:4] + str(int(str(pgid.game_id)[:4]) + 1))
if season not in pgids[pgid.player_id]:
pgids[pgid.player_id][season] = []
pgids[pgid.player_id][season].append(pgid.game_id)
for player in stats:
season = player['season']
playerid = player['player_id']
if playerid in pgids and season in pgids[playerid]:
player['game_ids'] = pgids[playerid][season]
else:
player['game_ids'] = []
return JsonResponse(context)
context["form"] = form
context["statsJson"] = json.dumps(stats, cls=DjangoJSONEncoder)
return render(request, 'players/players.html', context)
def teams(request):
teams = Team.objects.filter(active=1)
context = {
"teams" : teams
}
teamstrength = "even"
scoresituation = "all"
period = "all"
currentSeason = Game.objects.latest("endDateTime").season
seasons = [currentSeason, ]
form = GameFilterForm()
startDate = None
endDate = None
venues = []
teams = []
gameTypes = None
if request.method == 'GET':
form = GameFilterForm(request.GET)
if form.is_valid():
cd = form.cleaned_data
teamstrength = cd["teamstrengths"]
scoresituation = cd["scoresituation"]
period = cd["period"]
startDate = cd["startDate"]
endDate = cd["endDate"]
venues = cd["venues"]
teams = cd["teams"]
gameTypes = request.GET.get('gameTypes', None)
seasons = [cd["season"], ]
if len(seasons) == 0:
seasons = [currentSeason, ]
gameids = Game.objects.values_list("gamePk", flat=True).filter(gameState__in=[5, 6, 7], gameType__in=["P", "R"])
if startDate is not None:
gameids = gameids.filter(dateTime__date__gte=startDate)
if endDate is not None:
gameids = gameids.filter(dateTime__date__lte=endDate)
if len(venues) > 0:
gameids = gameids.filter(venue__in=venues)
if len(teams) > 0:
gameids = gameids.filter(Q(homeTeam__in=cd['teams']) | Q(awayTeam__in=cd['teams']))
if gameTypes:
gameids = gameids.filter(gameType__in=gameTypes)
gameids = [x for x in gameids]
# print [team.id for team in teams]
tgs = TeamGameStats.objects.raw(teamqueries.teamsquery, [gameids, scoresituation, teamstrength, period, seasons])
stats = {}
start = datetime.now()
for row in tgs:
season = row.season
teamid = row.team_id
# print teamid
if teamid not in stats:
stats[teamid] = {}
if season not in stats[teamid]:
stats[teamid][season] = row.__dict__
stats[teamid][season]['game_ids'] = [row.game_id, ]
stats[teamid][season]["games"] = 1
stats[teamid][season].pop("_state", None)
stats[teamid][season].pop("game_id", None)
stats[teamid][season].pop("period", None)
stats[teamid][season].pop("teamstrength", None)
stats[teamid][season].pop("scoresituation", None)
stats[teamid][season].pop("team_id", None)
else:
stats[teamid][season]["games"] += 1
stats[teamid][season]['game_ids'].append(row.game_id)
for key in stats[teamid][season]:
if key not in ["abbreviation", "shortName", "teamName"]:
try:
stats[teamid][season][key] += row.__dict__[key]
except:
pass
# print datetime.now() - start
for teamid in stats:
for season in stats[teamid]:
row = stats[teamid][season]
row["toiSeconds"] = row["toi"] / row["games"]
row["toi"] = toi.format_minutes(row["toi"] / row["games"])
row["sc"] = '%.1f' % corsi.corsi_percent(row["scoringChancesFor"],
row["scoringChancesAgainst"])
row["hsc"] = '%.1f' % corsi.corsi_percent(row["highDangerScoringChancesFor"],
row["highDangerScoringChancesAgainst"])
row["zso"] = '%.1f' % corsi.corsi_percent(row["offensiveZoneStartsFor"],
row["offensiveZoneStartsAgainst"])
row["fo_w"] = '%.1f' % corsi.corsi_percent(row["faceoffWins"], row["faceoffLosses"])
row["sf"] = '%.1f' % corsi.corsi_percent(row["shotsFor"], row["shotsAgainst"])
row["msf"] = '%.1f' % corsi.corsi_percent(row["missedShotsFor"],
row["missedShotsAgainst"])
row["bsf"] = '%.1f' % corsi.corsi_percent(row["blockedShotsFor"],
row["blockedShotsAgainst"])
row["gf"] = '%.1f' % corsi.corsi_percent(row["goalsFor"], row["goalsAgainst"])
row["pn"] = '%.1f' % corsi.corsi_percent(row["penaltyFor"], row["penaltyAgainst"])
row["cf"] = '%.1f' % corsi.corsi_percent(row["corsiFor"], row["corsiAgainst"])
row['cf60'] = '%.1f' % corsi.corsi_for_60(row['toiSeconds'], row['corsiFor'])
row['ca60'] = '%.1f' % corsi.corsi_against_60(row['toiSeconds'], row['corsiAgainst'])
row["hit"] = '%.1f' % corsi.corsi_percent(row["hitsFor"], row["hitsAgainst"])
row['fenwickFor'] = row['missedShotsFor'] + row['shotsFor']
row['fenwickAgainst'] = row['missedShotsAgainst'] + row['shotsAgainst']
row['ff'] = '%.1f' % corsi.corsi_percent(row['fenwickFor'], row['fenwickAgainst'])
row['ff60'] = '%.1f' % corsi.corsi_for_60(row['toiSeconds'], row['fenwickFor'])
row['fa60'] = '%.1f' % corsi.corsi_against_60(row['toiSeconds'], row['fenwickAgainst'])
save_percent = corsi.corsi_percent(row['shotsAgainst'], row['goalsAgainst'])
shot_percent = corsi.corsi_percent(row['goalsFor'], row['shotsFor'])
row['pdo'] = '%.1f' % (save_percent + shot_percent)
row['save_percent'] = '%.1f' % save_percent
row['shot_percent'] = '%.1f' % shot_percent
row['csh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'], row['corsiFor'])
row['csa'] = '%.1f' % (100 - corsi.corsi_percent(row['goalsAgainst'], row['corsiAgainst']))
row['fsh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'], row['fenwickFor'])
row['fsa'] = '%.1f' % (100 - corsi.corsi_percent(row['goalsAgainst'], row['fenwickAgainst']))
# print datetime.now() - start
context["stats"] = stats
context["form"] = form
if request.method == "GET" and "format" in request.GET and request.GET["format"] == "json":
context.pop("form")
context.pop("teams")
return JsonResponse(context)
else:
context["statsJson"] = json.dumps(stats, cls=DjangoJSONEncoder)
return render(request, 'team/teams.html', context)
def team_page(request, team_name):
try:
form = GameForm()
teamstrength = "even"
scoresituation = "all"
period = "all"
if request.method == "GET":
form = GameForm(request.GET)
if form.is_valid():
cd = form.cleaned_data
teamstrength = cd["teamstrengths"]
scoresituation = cd["scoresituation"]
period = cd["period"]
team_name = team_name.replace("-", " ")
team = Team.objects.get(shortName=team_name, active=1)
players = Player.objects.filter(currentTeam__exact=team, ).order_by('lastName')
# get player's current age
for player in players:
today = date.today()
player.age = today.year - player.birthDate.year - (
(today.month, today.day) < (player.birthDate.month, player.birthDate.day))
if team.conference == 'E':
team.conference = 'Eastern'
elif team.conference == 'W':
team.conference = 'Western'
if team.division == 'M':
team.division = "Metropolitan"
elif team.division == 'A':
team.division = 'Atlantic'
elif team.division == 'P':
team.division = 'Pacific'
elif team.division == 'C':
team.division = 'Central'
tgs = TeamGameStats.objects.raw(teamqueries.teamquery, [scoresituation, teamstrength, period, team.id])
stats = {}
start = datetime.now()
for row in tgs:
season = row.season
teamid = team.id
if team.id not in stats:
stats[teamid] = {}
if season not in stats[teamid]:
stats[teamid][season] = row.__dict__
stats[teamid][season]["games"] = 1
stats[teamid][season]['game_ids'] = [row.game_id, ]
stats[teamid][season].pop("_state", None)
stats[teamid][season].pop("game_id", None)
stats[teamid][season].pop("period", None)
stats[teamid][season].pop("teamstrength", None)
stats[teamid][season].pop("scoresituation", None)
stats[teamid][season].pop("team_id", None)
else:
stats[teamid][season]["games"] += 1
stats[teamid][season]['game_ids'].append(row.game_id)
for key in stats[teamid][season]:
try:
stats[teamid][season][key] += row.__dict__[key]
except:
pass
for teamid in stats:
for season in stats[teamid]:
row = stats[teamid][season]
row["abbreviation"] = team.abbreviation
row["toiSeconds"] = row["toi"] / row["games"]
row["toi"] = toi.format_minutes(row["toi"] / row["games"])
row["sc"] = '%.1f' % corsi.corsi_percent(row["scoringChancesFor"],
row["scoringChancesAgainst"])
row["hsc"] = '%.1f' % corsi.corsi_percent(row["highDangerScoringChancesFor"],
row["highDangerScoringChancesAgainst"])
row["zso"] = '%.1f' % corsi.corsi_percent(row["offensiveZoneStartsFor"],
row["offensiveZoneStartsAgainst"])
row["fo_w"] = '%.1f' % corsi.corsi_percent(row["faceoffWins"], row["faceoffLosses"])
row["sf"] = '%.1f' % corsi.corsi_percent(row["shotsFor"], row["shotsAgainst"])
row["msf"] = '%.1f' % corsi.corsi_percent(row["missedShotsFor"],
row["missedShotsAgainst"])
row["bsf"] = '%.1f' % corsi.corsi_percent(row["blockedShotsFor"],
row["blockedShotsAgainst"])
row["gf"] = '%.1f' % corsi.corsi_percent(row["goalsFor"], row["goalsAgainst"])
row["pn"] = '%.1f' % corsi.corsi_percent(row["penaltyFor"], row["penaltyAgainst"])
row["cf"] = '%.1f' % corsi.corsi_percent(row["corsiFor"], row["corsiAgainst"])
row['cf60'] = '%.1f' % corsi.corsi_for_60(row['toiSeconds'], row['corsiFor'])
row['ca60'] = '%.1f' % corsi.corsi_against_60(row['toiSeconds'], row['corsiAgainst'])
row["hit"] = '%.1f' % corsi.corsi_percent(row["hitsFor"], row["hitsAgainst"])
row['fenwickFor'] = row['missedShotsFor'] + row['shotsFor']
row['fenwickAgainst'] = row['missedShotsAgainst'] + row['shotsAgainst']
row['ff'] = '%.1f' % corsi.corsi_percent(row['fenwickFor'], row['fenwickAgainst'])
row['ff60'] = '%.1f' % corsi.corsi_for_60(row['toiSeconds'], row['fenwickFor'])
row['fa60'] = '%.1f' % corsi.corsi_against_60(row['toiSeconds'], row['fenwickAgainst'])
save_percent = corsi.corsi_percent(row['shotsAgainst'], row['goalsAgainst'])
shot_percent = corsi.corsi_percent(row['goalsFor'], row['shotsAgainst'])
row['pdo'] = '%.1f' % (save_percent + shot_percent)
row['save_percent'] = '%.1f' % save_percent
row['shot_percent'] = '%.1f' % shot_percent
row['csh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'], row['corsiFor'])
row['csa'] = '%.1f' % (100 - corsi.corsi_percent(row['goalsAgainst'], row['corsiAgainst']))
row['fsh'] = '%.1f' % corsi.corsi_percent(row['goalsFor'], row['fenwickFor'])
row['fsa'] = '%.1f' % (100 - corsi.corsi_percent(row['goalsAgainst'], row['fenwickAgainst']))
context = {
'team': team,
'players': players,
'stats': stats,
'statsJson': stats,
'form': form,
}
if request.method == "GET" and "format" in request.GET and request.GET["format"] == "json":
context['players'] = [x.__dict__ for x in context["players"]]
[x.pop("_state", None) for x in context["players"]]
context["team"] = context["team"].__dict__
context["team"].pop("_state", None)
context.pop("form")
return JsonResponse(context)
else:
context["statsJson"] = json.dumps(stats, cls=DjangoJSONEncoder)
except Team.DoesNotExist:
raise Http404("Team does not exist!")
return render(request, 'team/team_page.html', context)