/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // if (\Auth::user()->super == "Yes") { $sites = \App\Models\Site::whereIn("id", function ($query) { $query->select('sites.id')->from("sites")->where('company_id', \Auth::user()->site->company_id); })->get(); } return view('allSites', ['sites' => $sites]); }
Route::get('countusers', function () { $user = \Auth::user(); if ($user->admin == 'Yes') { $users = \App\Models\User::whereIn("id", function ($query) { $query->select('id')->from("users")->where('site_id', \Auth::user()->site_id); })->count(); } else { $users = \App\Models\User::whereIn("id", function ($query) { $query->select('users.id')->from("users")->join("sites", "site_id", "=", "sites.id")->where('company_id', \Auth::user()->site->company_id); })->count(); } return $users; }); Route::get('countsites', function () { $sites = \App\Models\Site::whereIn("id", function ($query) { $query->select('sites.id')->from("sites")->where('company_id', \Auth::user()->site->company_id); })->count(); return $sites; }); // ===== email routes ===== // ===== login and logout routes ===== Route::get('login', 'LoginController@showLoginForm'); Route::post('login', 'LoginController@processLogin'); Route::get('logout', 'LoginController@logout'); // ===== users routes ===== Route::resource('users', 'UsersController'); // ===== tools routes ===== Route::resource('tools', 'ToolsController'); // ===== sites routes ===== Route::resource('sites', 'SitesController'); // ===== notifications routes =====