/** * Display a listing of the resource. * * @return Response */ public function index() { Session::forget('UniversityHistory'); Session::forget('CareerHistory'); $this->convertScript(); $people = People::whereNull("Deleted")->get()->sortBy("First_Name"); return view("admin.employee.index", compact("people")); }
/** * Get statistic data. * * @return Response */ public function monthStatistic($month, $year, Request $request) { $statistics = new \stdClass(); $StatisticEndDate = Carbon::create($year, $month, 1, 0, 0, 0)->addMonth(1); $StatisticStartDate = Carbon::create($year, $month, 1, 0, 0, 0); $statistics->companies = [Companies::whereNull("Deleted")->where("Date_Created", "<", $StatisticEndDate)->where("Date_Created", ">", $StatisticStartDate)->get()->count(), Companies::whereNull("Deleted")->get()->count()]; $statistics->products = [Products::whereNull("Deleted")->where("Date_Created", "<", $StatisticEndDate)->where("Date_Created", ">", $StatisticStartDate)->get()->count(), Products::whereNull("Deleted")->get()->count()]; $statistics->news = [News::whereNull("Deleted")->where("Date_Created", "<", $StatisticEndDate)->where("Date_Created", ">", $StatisticStartDate)->get()->count(), News::whereNull("Deleted")->get()->count()]; $statistics->people = [People::whereNull("Deleted")->where("Date_Created", "<", $StatisticEndDate)->where("Date_Created", ">", $StatisticStartDate)->get()->count(), People::whereNull("Deleted")->get()->count()]; return json_encode($statistics); }
public function getTagsList($category) { switch ($category) { case 'Companies': return Companies::whereNull("Deleted")->orderBy('Company_Full_Name', 'asc')->get(['id_Company as id', 'Company_Full_Name as description'])->toJson(); case 'People': return People::whereNull("Deleted")->orderBy('First_Name', 'asc')->get(['id_People as id', 'First_Name as description'])->toJson(); case 'Vertical': return Vertical::all(['id_Vertical as id', 'Main_Description as description'])->toJson(); case 'Products': return Products::whereNull("Deleted")->orderBy('Product_Title', 'asc')->get(['id_Product as id', 'Product_Title as description'])->toArray(); case 'Events': return Event::all(['id_Event as id', 'Event_Title as description'])->toJson(); } }