/**
* 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();
}
