Example #1
0
 /**
  * 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]);
 }