| 64,7 → 64,7 |
|---|
| $requete_location=""; |
| } |
| else { |
| $requete_location=" AND location= ".$this->proteger($uid[1])." "; |
| $requete_location=" AND location= ".Cel::db()->proteger($uid[1])." "; |
| } |
| |
| if (!isset($uid[2]) || $uid[2]=="" || $uid[2]=="all") { |
| 72,7 → 72,7 |
|---|
| $requete_date=""; |
| } |
| else { |
| $requete_date=" AND date_observation= ".$this->proteger($uid[2])." "; |
| $requete_date=" AND date_observation= ".Cel::db()->proteger($uid[2])." "; |
| } |
| |
| if (!isset($uid[3]) || $uid[3]=="" || $uid[3]=="all") { |
| 80,10 → 80,10 |
|---|
| $requete_libre=""; |
| } |
| else { |
| $requete_libre=" AND (nom_sel LIKE ".$this->proteger('%'.$uid[3].'%'). |
| " OR nom_ret LIKE ".$this->proteger('%'.$uid[3].'%'). |
| " OR station LIKE ".$this->proteger('%'.$uid[3].'%'). |
| " OR commentaire LIKE ".$this->proteger('%'.$uid[3].'%'); |
| $requete_libre=" AND (nom_sel LIKE ".Cel::db()->proteger('%'.$uid[3].'%'). |
| " OR nom_ret LIKE ".Cel::db()->proteger('%'.$uid[3].'%'). |
| " OR station LIKE ".Cel::db()->proteger('%'.$uid[3].'%'). |
| " OR commentaire LIKE ".Cel::db()->proteger('%'.$uid[3].'%'); |
| } |
| |
| if (!isset($uid[4]) || $uid[4]=="" || $uid[4]=="all") { |
| 91,13 → 91,13 |
|---|
| $requete_station=""; |
| } |
| else { |
| $requete_station=" AND station= ".$this->proteger($uid[4])." "; |
| $requete_station=" AND station= ".Cel::db()->proteger($uid[4])." "; |
| } |
| |
| $value=array(); |
| |
| $requete="SELECT ce_utilisateur, ordre, nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, nt, famille, zone_geo, date_observation," . |
| " station, commentaire, transmission FROM cel_obs WHERE ce_utilisateur = ".$this->proteger($uid[0])." " . |
| " station, commentaire, transmission FROM cel_obs WHERE ce_utilisateur = ".Cel::db()->proteger($uid[0])." " . |
| $requete_location. |
| $requete_date. |
| $requete_libre. |
| 104,7 → 104,7 |
|---|
| $requete_station. |
| " ORDER BY ordre "; |
| |
| $resultat_requete = $this->requeter($requete); |
| $resultat_requete = Cel::db()->requeter($requete); |
| |
| $observations = array();; |
| if(is_array($resultat_requete)) { |