public function detail($banqueId = null)
{
if (is_null($banqueId)) {
// display the hole banque
return view('banque', ['banqueItems' => Banque::all(), 'contexteItems' => Contexte::all(), 'critereItems' => Critere::all(), 'domaineItems' => Domaine::all(), 'systemeItems' => Systeme::all(), 'competenceItems' => Competence::all(), 'enseignantList' => Enseignant::all()]);
} else {
// display specific banque
$banque = $this->gestSession->getBanque($banqueId);
$items = Item::join('TitreGItem', 'TitreGItem.id_TitreGItem', '=', 'Item.id_TitreGItem')->where('Item.id_Banque', '=', $banqueId)->join('Competence', 'Item.id_Competence', '=', 'Competence.id_Competence')->get();
$auteurs = Banque_Enseignant::where('id_Banque', '=', $banqueId)->get();
$files = File::where('id_Banque', '=', $banqueId)->get();
return view("banqueDetail")->with("banque", $banque)->with("items", $items)->with("files", $files)->with("auteurs", $auteurs);
}
}
/**
* Update a model.
*
* @param array $inputs
* @param $id
* @return void
*/
public function update($inputs, $id)
{
$this->model = Competence::find($id);
return $this->save($inputs);
}
public function getCompetences()
{
return Competence::all();
}
public function statCompetence($inputs = null, $filiere = null)
{
$competence = new Competence();
$query = $competence->select('competences.intitule', DB::raw('count(competences.intitule) as nombre'))->join('cvs', 'cvs.id', '=', 'competences.cv_id')->join('etudiants', 'etudiants.id', '=', 'cvs.etudiant_id');
if ($filiere) {
$query->where('etudiants.filiere_id', $filiere);
}
if (isset($inputs['idNiveau'])) {
$query->where('competences.niveau', $inputs['idNiveau']);
}
$query->orderby('nombre', 'desc')->limit(5);
$query->groupBy('competences.intitule');
$data = $query->get();
$sortie = array();
foreach ($data as $value) {
if ($value['niveau'] == 1) {
$value['niveau'] = 'Débutant';
}
if ($value['niveau'] == 2) {
$value['niveau'] = 'Intermediaire';
}
if ($value['niveau'] == 3) {
$value['niveau'] = 'Avancé';
}
if ($value['niveau'] == 4) {
$value['niveau'] = 'Expert';
}
$sortie[] = ['niveau' => $value['niveau'], 'nombre' => $value['nombre']];
}
//var_dump($data) ;
return $data;
}
