/** * Team page * * @return $this */ public function team() { $data = ['parentPage' => 'Company', 'page' => 'Team', 'title' => 'Teleaus | Team Page', 'members' => Management::orderBy('created_at', 'asc')->get()]; return view('team')->with($data); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $gerencias = Management::orderBy('managements.name', 'asc')->leftjoin('projects', 'projects.management_id', '=', 'managements.id')->groupBy('managements.id')->get(['managements.*', DB::raw("GROUP_CONCAT(projects.name SEPARATOR ',') AS name_project")]); return response()->json(['gerencias' => $gerencias]); }