/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // $users = User::select('id')->get(); $products = Product::select('id')->get(); $categories = Category::select('id')->get(); $areas = Area::select('id')->get(); $orders = Order::select('id')->get(); return view('admin.dashboard', compact('users', 'products', 'categories', 'areas', 'orders')); }
public function getAll() { return Area::select('id', 'nombre')->orderBy('nombre', 'asc')->get(); }
public static function getAreasWithWaitingIssues() { $waitingStatus = intval(Issue::WAITING_STATE); $countIssue = "(SELECT COUNT(`issues`.`ID`) FROM issues WHERE `issues`.`areaID` = `areas`.`ID` AND `issues`.`state` = {$waitingStatus})"; return Area::select(DB::raw("areas.*,{$countIssue} as `issuesCount`"))->get(); }