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