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;
}
