public function index(Request $request)
{
$credits = $request->user()->credits;
$userPlayers = $request->user()->userContractsPlayers;
$players = new Players();
$club = new Club();
$match = $request->user()->userPlayers;
if ($request->club == null && $request->position == null || $request->club == "all" && $request->position == "all") {
$paginate = $players->paginate(10);
} elseif ($request->position != "all" && $request->position != null && ($request->club == null || $request->club == "all")) {
$paginate = $players->where('position', $request->position)->paginate(10);
} elseif ($request->club != "all" && $request->club != null && ($request->position == "all" || $request->position == null)) {
$paginate = $players->join('fantasy_contracts', 'fantasy_players.player_id', '=', 'fantasy_contracts.player_id')->join('fantasy_club', 'fantasy_contracts.club_id', '=', 'fantasy_club.club_id')->where('club_short_name', $request->club)->paginate(15);
} else {
$paginate = $players->join('fantasy_contracts', 'fantasy_players.player_id', '=', 'fantasy_contracts.player_id')->join('fantasy_club', 'fantasy_contracts.club_id', '=', 'fantasy_club.club_id')->where('club_short_name', $request->club)->where('position', $request->position)->paginate(10);
}
$testas = $players->join('fantasy_contracts', 'fantasy_players.player_id', '=', 'fantasy_contracts.player_id')->join('fantasy_club', 'fantasy_contracts.club_id', '=', 'fantasy_club.club_id')->where('club_short_name', 'SIA');
return view('front.add_player_in_team')->with('userCredits', $credits)->with('teamPoints', $request->user()->team->team_points)->with('userPlayers', $userPlayers)->with('players', $players)->with('contracts', new Contracts())->with('playersList', $paginate)->with('club', $club)->with('i', $i = 1)->with('match', $match)->with('filterClub', $request->club)->with('filterPosition', $request->position)->with('testas', $testas->get());
}
