def get_teams(request, additional_filters=None, paginate=False):
request_query_dict = request.GET.copy()
set_currency(request)
current_user = get_current_user(request)
fifa_edition = get_fifa_edition(request)
career_user = get_career_user(request, current_user=current_user)
# Apply filters
if additional_filters:
for k, v in additional_filters.items():
request_query_dict[k] = str(v)
teams_filter = DataUsersTeamsFilter(request_query_dict,
for_user=current_user)
# Paginate results if needed
if paginate:
max_per_page = int(request.GET.get('max_per_page', 50))
if not 25 <= max_per_page <= 100:
max_per_page = 50
paginator = MyPaginator(teams_filter.qs.count(),
request=request_query_dict,
max_per_page=max_per_page)
data = list(teams_filter.qs[paginator.results_bottom:paginator.
results_top].iterator())
else:
paginator = None
data = list(teams_filter.qs.iterator())
if len(data) <= 0:
raise NoResultsError(_('No results found. Try to change your filters'))
dict_cached_queries = dict()
dict_cached_queries['q_league_team_links'] = list(
DataUsersLeagueteamlinks.objects.for_user(current_user).iterator())
dict_cached_queries['q_leagues'] = list(
DataUsersLeagues.objects.for_user(current_user).iterator())
context = {
'teams': data,
'paginator': paginator,
'request_query_dict': request_query_dict,
'dict_cached_queries': dict_cached_queries,
'career_user': career_user,
'fifa_edition': fifa_edition,
}
return context
def ajax_teams(request):
if request.user.is_authenticated:
current_user = get_current_user(request)
else:
current_user = "******"
selected = request.GET.get('selected', None)
if selected:
selected = list(selected.split(","))
teams = list(
DataUsersTeams.objects.for_user(current_user).all().filter(
Q(teamid__in=selected)).values())
else:
teams = list(
DataUsersTeams.objects.for_user(current_user).all().values())
data = {'teams': teams}
return JsonResponse(data)
def get_transfers(request,
additional_filters=None,
paginate=False,
fifa_edition=None):
request_query_dict = request.GET.copy()
set_currency(request)
current_user = get_current_user(request)
if not fifa_edition:
fifa_edition = get_fifa_edition(request)
if additional_filters:
for k, v in additional_filters.items():
request_query_dict[k] = str(v)
if fifa_edition == 19:
transfer_offer_filter = DataUsersCareerCompdataClubNegotiationsFilter(
request_query_dict, for_user=current_user)
else:
transfer_offer_filter = DataUsersCareerTransferOfferFilter(
request_query_dict, for_user=current_user)
# Paginate results if needed
if paginate:
max_per_page = int(request.GET.get('max_per_page', 50))
if not 25 <= max_per_page <= 100:
max_per_page = 50
paginator = MyPaginator(transfer_offer_filter.qs.count(),
request=request_query_dict,
max_per_page=max_per_page)
data = list(
transfer_offer_filter.qs[paginator.results_bottom:paginator.
results_top].iterator())
else:
paginator = None
data = list(transfer_offer_filter.qs.iterator())
if len(data) <= 0:
raise NoResultsError(_('No results found. Try to change your filters'))
playerids = ",".join(str(transfer.playerid) for transfer in data)
additional_filters = {
'playerid': playerids,
}
try:
context_data = get_fifaplayers(request,
additional_filters=additional_filters,
paginate=False,
sort=False)
except (NoResultsError):
context_data = dict()
context_data['players'] = None
if context_data['players']:
# keep order from 'transfer_offer_filter'
players_original_order = list()
copy_context_data_players = deepcopy(context_data['players'])
for playerid in playerids.split(','):
for cp in copy_context_data_players:
p = copy(cp)
if int(playerid) == int(p.player.playerid):
t_info = transfer_info(playerid, data, fifa_edition)
if t_info:
setattr(p, 'transfer_info', t_info)
players_original_order.append(p)
context_data['players'] = players_original_order
context_data['paginator'] = paginator
return context_data
def get_fifaplayers(request,
additional_filters=None,
paginate=False,
sort=True):
request_query_dict = request.GET.copy()
set_currency(request)
current_user = get_current_user(request)
fifa_edition = get_fifa_edition(request)
# Current date according to in-game calendar
try:
current_date = DataUsersCareerCalendar.objects.for_user(
current_user)[0].currdate
except IndexError:
messages.error(
request,
_("Your career file hasn't been processed yet. Displaying default FIFA database data."
))
current_user = "******"
current_date = DataUsersCareerCalendar.objects.for_user(
current_user)[0].currdate
# Apply filters
if additional_filters:
for k, v in additional_filters.items():
request_query_dict[k] = str(v)
player_filter = DataUsersPlayersFilter(request_query_dict,
for_user=current_user,
current_date=current_date,
sort=sort,
fifa_edition=fifa_edition)
# Paginate results if needed
if paginate:
try:
max_per_page = int(request.GET.get('max_per_page', 50))
except ValueError:
max_per_page = 50
if not 25 <= max_per_page <= 100:
max_per_page = 50
paginator = MyPaginator(player_filter.qs.count(),
request=request_query_dict,
max_per_page=max_per_page)
data = list(player_filter.qs[paginator.results_bottom:paginator.
results_top].iterator())
else:
paginator = None
data = list(player_filter.qs.iterator())
if len(data) <= 0:
raise NoResultsError(_('No results found. Try to change your filters'))
dict_cached_queries = dict()
dict_cached_queries['q_leagues'] = list(
DataUsersLeagues.objects.for_user(current_user).all().iterator())
dict_cached_queries['q_dcplayernames'] = list(
DataUsersDcplayernames.objects.for_user(current_user).all().iterator())
f_playerid = reduce(lambda x, y: x | y,
[Q(playerid=player.playerid) for player in data])
dict_cached_queries['q_team_player_links'] = list(
DataUsersTeamplayerlinks.objects.for_user(current_user).filter(
f_playerid).iterator())
dict_cached_queries['q_player_loans'] = list(
DataUsersPlayerloans.objects.for_user(current_user).filter(
f_playerid).iterator())
dict_cached_queries['q_edited_player_names'] = list(
DataUsersEditedplayernames.objects.for_user(current_user).filter(
f_playerid).iterator())
dict_cached_queries['q_release_clauses'] = list(
DataUsersCareerRestReleaseClauses.objects.for_user(
current_user).filter(f_playerid).iterator())
dict_cached_queries['q_players_stats'] = list(
DataUsersCareerCompdataPlayerStats.objects.for_user(
current_user).filter(f_playerid).iterator())
f_teamid = Q()
for team in dict_cached_queries['q_team_player_links']:
f_teamid.add(Q(teamid=team.teamid), Q.OR)
if len(dict_cached_queries['q_player_loans']) > 0:
for team in dict_cached_queries['q_player_loans']:
f_teamid.add(Q(teamid=team.teamidloanedfrom), Q.OR)
dict_cached_queries['q_teams'] = list(
DataUsersTeams.objects.for_user(current_user).filter(
f_teamid).iterator())
dict_cached_queries['q_league_team_links'] = list(
DataUsersLeagueteamlinks.objects.for_user(current_user).filter(
f_teamid).iterator())
players_list = list()
currency = int(request.session['currency'])
for player in data:
fp = FifaPlayer(player, current_user, current_date,
dict_cached_queries, currency, fifa_edition)
players_list.append(fp)
context = {
'players': players_list,
'paginator': paginator,
'request_query_dict': request_query_dict,
'dict_cached_queries': dict_cached_queries,
'fifa_edition': fifa_edition,
}
return context
def get_team(request, teamid=0, additional_filters=None):
request_query_dict = request.GET.copy()
set_currency(request)
current_user = get_current_user(request)
fifa_edition = get_fifa_edition(request)
additional_filters = {
'teamid': teamid,
'teamidloanedfrom': teamid,
}
try:
context_data = get_fifaplayers(request,
additional_filters=additional_filters,
paginate=False)
except (NoResultsError):
context_data = dict()
context_data['dict_cached_queries'] = dict()
context_data['players'] = None
context_data['dict_cached_queries']['q_teams'] = list(
DataUsersTeams.objects.for_user(current_user).filter(
teamid=teamid).iterator())
context_data['dict_cached_queries']['q_league_team_links'] = list(
DataUsersLeagueteamlinks.objects.for_user(current_user).filter(
teamid=teamid).iterator())
context_data['dict_cached_queries']['q_leagues'] = list(
DataUsersLeagues.objects.for_user(current_user).all().iterator())
if context_data['players']:
players = context_data['players'][:]
else:
players = None
if not context_data['dict_cached_queries']['q_teams']:
raise NoResultsError(_('No results found. Try to change your filters'))
# get valid team
valid_team = None
for team in context_data['dict_cached_queries']['q_teams']:
if int(team.teamid) == int(teamid):
valid_team = team
break
if not valid_team:
raise NoResultsError(_('No results found. Try to change your filters'))
# get valid leagueteamlink
valid_ltlink = None
for ltlink in context_data['dict_cached_queries']['q_league_team_links']:
if int(ltlink.teamid) == int(teamid):
valid_ltlink = ltlink
break
# get valid league
valid_league = None
if valid_ltlink:
for league in context_data['dict_cached_queries']['q_leagues']:
if int(league.leagueid) == int(valid_ltlink.leagueid):
valid_league = league
break
# manager
try:
manager = list(
DataUsersManager.objects.for_user(current_user).filter(
teamid=teamid).iterator())[0]
if manager.firstname is None and manager.surname is None:
manager.firstname = valid_team.teamname
manager.surname = "Manager"
elif manager.firstname is None:
manager.firstname = ""
elif manager.surname is None:
manager.surname = ""
except IndexError:
manager = {
'firstname': valid_team.teamname,
'surname': "Manager",
'headid': "None",
}
# group players
is_club_team = True
is_national_team = False
if players:
try:
if int(players[0].player_teams['national_team']['team']
['teamid']) == int(teamid):
is_national_team = True
is_club_team = False
except KeyError:
pass
grouped_players = dict()
grouped_players['GK'] = list()
grouped_players['DEF'] = list()
grouped_players['MID'] = list()
grouped_players['ATT'] = list()
grouped_players['LOANED_OUT'] = list()
grouped_players['total_players'] = len(players)
grouped_players['value_GK'] = 0
grouped_players['value_DEF'] = 0
grouped_players['value_MID'] = 0
grouped_players['value_ATT'] = 0
grouped_players['value_LOANED_OUT'] = 0
grouped_players['total_team_value'] = 0
for p in players:
grouped_players['total_team_value'] += p.player_value.value
if is_club_team:
if int(p.player_contract['isloanedout']) == 1 and int(
p.player_contract['loanedto_clubid']) != int(teamid):
grouped_players['value_LOANED_OUT'] += p.player_value.value
grouped_players['LOANED_OUT'].append(p)
p_index = context_data['players'].index(p)
del context_data['players'][p_index]
continue
if p.player.preferredposition1 == 0:
grouped_players['value_GK'] += p.player_value.value
grouped_players['GK'].append(p)
elif 1 <= p.player.preferredposition1 <= 8:
grouped_players['value_DEF'] += p.player_value.value
grouped_players['DEF'].append(p)
elif 9 <= p.player.preferredposition1 <= 19:
grouped_players['value_MID'] += p.player_value.value
grouped_players['MID'].append(p)
elif 20 <= p.player.preferredposition1 <= 27:
grouped_players['value_ATT'] += p.player_value.value
grouped_players['ATT'].append(p)
grouped_players['total_GK'] = len(grouped_players['GK'])
grouped_players['total_DEF'] = len(grouped_players['DEF'])
grouped_players['total_MID'] = len(grouped_players['MID'])
grouped_players['total_ATT'] = len(grouped_players['ATT'])
else:
grouped_players = None
# print("Queries: {}".format(len(connection.queries)))
total_careers = len(
list(DataUsersCareerUsers.objects.all().filter(
Q(clubteamid=teamid) | Q(nationalteamid=teamid)).iterator()))
context = {
'team': valid_team,
'leagueteamlink': valid_ltlink,
'league': valid_league,
'players': context_data['players'],
'grouped_players': grouped_players,
'manager': manager,
'is_club_team': is_club_team,
'is_national_team': is_national_team,
'total_careers': total_careers,
'fifa_edition': fifa_edition,
}
return context
def ajax_players_by_name(request):
if request.user.is_authenticated:
current_user = get_current_user(request)
fifa_edition = get_fifa_edition(request)
else:
current_user = "******"
fifa_edition = DEFAULT_FIFA_EDITION
players_found = list()
playername = request.GET.get('playername', None)
if playername and len(playername) > 1:
playername = playername.split() # split space
dict_cached_queries = dict()
valid_nameids = list()
query = reduce(
lambda x, y: x | y,
[Q(name__unaccent__istartswith=name) for name in playername])
if fifa_edition == 18:
table_playernames = list(
DataPlayernames.objects.all().filter(query).iterator())
else:
playernames_model = ContentType.objects.get(
model='dataplayernames{}'.format(fifa_edition)).model_class()
table_playernames = list(
playernames_model.objects.all().filter(query).iterator())
for player in table_playernames:
if player.nameid in valid_nameids:
continue
valid_nameids.append(player.nameid)
dict_cached_queries['q_dcplayernames'] = list(
DataUsersDcplayernames.objects.for_user(current_user).all().filter(
query).iterator())
for player in dict_cached_queries['q_dcplayernames']:
if player.nameid in valid_nameids:
continue
valid_nameids.append(player.nameid)
dict_cached_queries['q_dcplayernames'] = list(
DataUsersDcplayernames.objects.for_user(
current_user).all().iterator())
valid_playerids = list()
query_fn = Q()
query_sn = Q()
query_cn = Q()
for name in playername:
query_fn.add(Q(firstname__unaccent__istartswith=name), Q.OR)
query_sn.add(Q(surname__unaccent__istartswith=name), Q.OR)
query_cn.add(Q(commonname__unaccent__istartswith=name), Q.OR)
dict_cached_queries['q_edited_player_names'] = list(
DataUsersEditedplayernames.objects.for_user(
current_user).all().filter(query_fn | query_sn
| query_cn).iterator())
for player in dict_cached_queries['q_edited_player_names']:
if player.playerid in valid_playerids:
continue
valid_playerids.append(player.playerid)
if fifa_edition == 18:
players = list(
DataUsersPlayers.objects.for_user(current_user).select_related(
'firstname',
'lastname',
'playerjerseyname',
'commonname',
).filter(
Q(playerid__in=valid_playerids)
| Q(firstname_id__in=valid_nameids)
| Q(lastname_id__in=valid_nameids)
| Q(commonname_id__in=valid_nameids)).all().order_by(
'-overallrating')[:12].iterator())
else:
players_model = ContentType.objects.get(
model='datausersplayers{}'.format(fifa_edition)).model_class()
players = list(
players_model.objects.for_user(current_user).select_related(
'firstname',
'lastname',
'playerjerseyname',
'commonname',
).filter(
Q(playerid__in=valid_playerids)
| Q(firstname_id__in=valid_nameids)
| Q(lastname_id__in=valid_nameids)
| Q(commonname_id__in=valid_nameids)).all().order_by(
'-overallrating')[:12].iterator())
available_positions = ('GK', 'SW', 'RWB', 'RB', 'RCB', 'CB', 'LCB',
'LB', 'LWB', 'RDM', 'CDM', 'LDM', 'RM', 'RCM',
'CM', 'LCM', 'LM', 'RAM', 'CAM', 'LAM', 'RF',
'CF', 'LF', 'RW', 'RS', 'ST', 'LS', 'LW')
for player in players:
p = dict()
p['playerid'] = player.playerid
p['overallrating'] = player.overallrating
p['position'] = available_positions[player.preferredposition1]
p['playername'] = PlayerName(
player, dict_cached_queries).playername['knownas']
players_found.append(p)
data = {
'players': players_found,
}
return JsonResponse(data)