public function index()
 {
     $usersData = [];
     $usersData['count'] = User::all()->count();
     $usersData['incompleteCount'] = User::where('status', 0)->count();
     $picsData = [];
     $picsData['count'] = Pic::all()->count();
     $clubsData = [];
     $clubsData['count'] = Club::all()->count();
     $badgesData = [];
     $badgesData['count'] = Badge::all()->count();
     $fixtures = Fixture::all();
     $fixturesData = [];
     $fixturesData['count'] = $fixtures->count();
     $fixturesData['overCount'] = $fixtures->filter(function ($fxt) {
         return $fxt->isOver();
     })->count();
     $fixturesData['closedNotOverCount'] = $fixtures->filter(function ($fxt) {
         return $fxt->isClosed() and !$fxt->isOver();
     })->count();
     $gameweeks = Gameweek::all();
     $gameweeksData = [];
     $gameweeksData['count'] = $gameweeks->count();
     $gameweeksData['completeCount'] = Gameweek::complete()->get()->count();
     $gameweeksData['pendingCount'] = Gameweek::incomplete()->get()->filter(function ($gw) {
         return $gw->hasCompletedFixture();
     })->count();
     $adminsData = [];
     $adminsData['count'] = Admin::all()->count();
     return view('admin.dashboard.index', compact('usersData', 'picsData', 'clubsData', 'badgesData', 'fixturesData', 'gameweeksData', 'adminsData'));
 }
 public function deletePic(Request $request)
 {
     $pic = Pic::find($request->id);
     // DELETE THE IMAGES ON SERVER ALSO!!!
     $rootPath = getcwd() . '/images/';
     $rootURI = url('/') . '/images/';
     $filename = substr($pic->url, strlen($rootURI));
     $image_path = getcwd() . '/images/' . $filename;
     if (!unlink($image_path)) {
         echo "Error deleting {$file}";
     }
     $pic->delete();
     $pic = Pic::where('id', '>', $request->id)->orderBy('id', 'asc')->get()->first();
     if ($pic) {
         return view('viewPic', ['url' => $pic->url, 'id' => $pic->id, 'created_at' => $pic->created_at]);
     } else {
         return view('viewPic', ['url' => url('/') . '/images/outofpics.png', 'id' => $request->id + 1, 'created_at' => "not found"]);
     }
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     $pic = Pic::findOrFail($id);
     $pic->delete();
     return redirect('/admin/pic');
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($id)
 {
     $club = Club::findOrFail($id);
     $pics = Pic::lists('path', 'id')->toArray();
     return view('admin.club.edit', compact('club', 'pics'));
 }