64,7 → 64,7 |
$requete_location=""; |
} |
else { |
$requete_location=" AND location= ".Cel::db()->proteger($uid[1])." "; |
$requete_location=" AND location= ".$this->proteger($uid[1])." "; |
} |
|
if (!isset($uid[2]) || $uid[2]=="" || $uid[2]=="all") { |
72,7 → 72,7 |
$requete_date=""; |
} |
else { |
$requete_date=" AND date_observation= ".Cel::db()->proteger($uid[2])." "; |
$requete_date=" AND date_observation= ".$this->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 ".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].'%'); |
$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].'%'); |
} |
|
if (!isset($uid[4]) || $uid[4]=="" || $uid[4]=="all") { |
91,13 → 91,13 |
$requete_station=""; |
} |
else { |
$requete_station=" AND station= ".Cel::db()->proteger($uid[4])." "; |
$requete_station=" AND station= ".$this->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 = ".Cel::db()->proteger($uid[0])." " . |
" station, commentaire, transmission FROM cel_obs WHERE ce_utilisateur = ".$this->proteger($uid[0])." " . |
$requete_location. |
$requete_date. |
$requete_libre. |
104,7 → 104,7 |
$requete_station. |
" ORDER BY ordre "; |
|
$resultat_requete = Cel::db()->requeter($requete); |
$resultat_requete = $this->requeter($requete); |
|
$observations = array();; |
if(is_array($resultat_requete)) { |