110,7 → 110,7 |
} |
$requete .= $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres); |
$requete = rtrim($requete, 'AND '); |
$resultat = Cel::db()->requeter($requete); |
$resultat = Cel::db()->requeter($requete); |
$nb_obs = ($resultat && is_array($resultat) && count($resultat) > 0) ? $resultat[0]['nb_obs'] : '0'; |
return $nb_obs; |
} |
203,6 → 203,7 |
} |
|
switch ($nom) { |
case "programme"; |
case "mots_cles"; |
$sous_requete .= $this->creerSousRequeteMotsCles($valeur); |
$sous_requete .= ' AND '; |
298,6 → 299,10 |
$sous_requete .= $valeur; |
$sous_requete .= ' AND '; |
break; |
case 'validation_identiplante': |
$sous_requete .= "`id_observation` in (SELECT distinct `ce_observation` FROM tb_del.`del_commentaire` WHERE `proposition_retenue` = 1 )"; |
$sous_requete .= ' AND '; |
break; |
default: |
if(!preg_match('/^[a-zA-Z0-9_-]+$/', $nom)) break; |
$valeur = rtrim($valeur); |