/**
* 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 =====
