public function experiences() { $experiences = Experience::select("experience.*", "company.name as company_name")->join("company", "experience.company_id", "=", "company.id")->where("user_id", $this->id)->get(); return $experiences; }
public function statVille($filiere = null) { $experience = new Experience(); $query = $experience->select('experiences.ville', DB::raw('count(experiences.ville) as nombre'))->orderby('nombre', 'desc')->limit(5)->join('cvs', 'cvs.id', '=', 'experiences.cv_id')->join('etudiants', 'etudiants.id', '=', 'cvs.etudiant_id'); if ($filiere) { $query->where('etudiants.filiere_id', $filiere); } $query->groupBy('experiences.ville')->get(); $data = $query->get(); return $data; }