| New file |
|---|
| 0,0 → 1,199 |
|---|
| <?php |
| |
| |
| // In : utf8 |
| // Out : utf8 |
| |
| Class InventoryItemList extends DBAccessor { |
| |
| |
| var $config; |
| |
| function InventoryItemList($config) { |
| |
| $this->config=$config; |
| } |
| |
| |
| function getElement($uid){ |
| |
| // Controle detournement utilisateur |
| session_start(); |
| $this->controleUtilisateur($uid[0]); |
| |
| // uid[0] : utilisateur obligatoire |
| // uid[1] : si absent : valeur 'all' (departement) |
| // uid[2] : si absent : valeur 'all' (commune) |
| // uid[3] : si absent : valeur 'all' (annee) |
| // uid[4] : si absent : valeur 'all' (mois) |
| // uid[5] : si absent : valeur 'all' (jour) |
| // uid[6] : si absent : valeur 'all' (recherche libre) |
| // uid[7] : si absent : valeur 'all' (lieudit) |
| // uid[8] et uid[9] : selection intervalle |
| |
| $DB=$this->connectDB($this->config,'database_cel'); |
| |
| |
| if (!isset($uid[1]) || $uid[1]=="" || $uid[1]=="all" ) { |
| $uid[1]="all"; |
| $query_id_location=""; |
| } |
| else { |
| $query_id_location=" AND id_location='".$DB->escapeSimple($uid[1])."' "; |
| } |
| |
| |
| if (!isset($uid[2]) || $uid[2]=="" || $uid[2]=="all" ) { |
| $uid[2]="all"; |
| $query_location=""; |
| } |
| else { |
| $query_location=" AND location='".$DB->escapeSimple($uid[2])."' "; |
| } |
| |
| if (!isset($uid[3]) || $uid[3]=="" || $uid[3]=="all") { |
| $uid[3]="all"; |
| $query_year=""; |
| } |
| else { |
| $query_year=" AND year(date_observation)='".$DB->escapeSimple($uid[3])."' "; |
| } |
| |
| |
| if (!isset($uid[4]) || $uid[4]=="" || $uid[4]=="all") { |
| $uid[4]="all"; |
| $query_month=""; |
| } |
| else { |
| $query_month=" AND month(date_observation)='".$DB->escapeSimple($uid[4])."' "; |
| } |
| |
| if (!isset($uid[5]) || $uid[5]=="" || $uid[5]=="all") { |
| $uid[5]="all"; |
| $query_day=""; |
| } |
| else { |
| $query_day=" AND day(date_observation)='".$DB->escapeSimple($uid[5])."' "; |
| } |
| |
| |
| if (!isset($uid[6]) || $uid[6]=="" || $uid[6]=="all") { |
| $uid[6]="all"; |
| $query_libre=""; |
| } |
| else { |
| $query_libre=" AND (nom_sel like '%".$DB->escapeSimple($uid[6])."%' OR nom_ret like '%".$DB->escapeSimple($uid[6])."%' OR station like '%".$DB->escapeSimple($uid[6])."%' OR milieu like '%".$DB->escapeSimple($uid[6])."%' OR commentaire like '%".$DB->escapeSimple($uid[6])."%') "; |
| } |
| |
| if (!isset($uid[7]) || $uid[7]=="" || $uid[7]=="all") { |
| $uid[7]="all"; |
| $query_lieudit=""; |
| } |
| else { |
| $query_lieudit=" AND lieudit='".$DB->escapeSimple($uid[7])."' "; |
| } |
| |
| |
| $value=array(); |
| |
| |
| if (isset($uid[8]) && isset($uid[9])) { |
| $query="SELECT identifiant, ordre, nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille, location, date_observation," . |
| " lieudit, station, milieu, commentaire, transmission FROM cel_inventory WHERE identifiant='".$DB->escapeSimple($uid[0])."' " . |
| $query_id_location. |
| $query_location. |
| $query_year. |
| $query_month. |
| $query_day. |
| $query_libre. |
| $query_lieudit. |
| " ORDER BY ordre LIMIT ".$uid[8].",".$uid[9]; |
| } |
| |
| else { |
| if (isset($uid[8])) { |
| // les n derniers |
| $query="SELECT identifiant, ordre, nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille, location, date_observation," . |
| " lieudit, station, milieu, commentaire, transmission FROM cel_inventory WHERE identifiant='".$DB->escapeSimple($uid[0])."' " . |
| $query_id_location. |
| $query_location. |
| $query_year. |
| $query_month. |
| $query_day. |
| $query_libre. |
| $query_lieudit. |
| " ORDER BY ordre LIMIT ".$uid[8].",18446744073709551615"; |
| } |
| else { |
| $query="SELECT count(*) as count FROM cel_inventory WHERE identifiant='".$DB->escapeSimple($uid[0])."'" . |
| $query_id_location. |
| $query_location. |
| $query_year. |
| $query_month. |
| $query_day. |
| $query_libre. |
| $query_lieudit; |
| |
| $res =& $DB->query($query); |
| |
| |
| if (DB::isError($res)) { |
| die($res->getMessage()); |
| } |
| while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) { |
| $value=$row['count']; |
| } |
| |
| $output = json_encode((integer)$value); |
| print($output); |
| |
| return true; |
| |
| } |
| } |
| |
| |
| $res =& $DB->query($query); |
| |
| if (DB::isError($res)) { |
| die($res->getMessage()); |
| } |
| while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) { |
| if ($row['date_observation']!="0000-00-00 00:00:00") { |
| list($year,$month,$day)= split ('-',$row['date_observation']); |
| list($day)= split (' ',$day); |
| $row['date_observation']=$day."/".$month."/".$year; |
| } |
| $value[]=array($row['nom_sel'], $row['num_nom_sel'],$row['nom_ret'],$row['num_nom_ret'],$row['num_taxon'],$row['famille'], $row['location'], $row['ordre'], $row['date_observation'], $row['lieudit'], $row['station'], $row['milieu'], $row['commentaire'], $row['transmission']); |
| |
| } |
| |
| $output = json_encode($value); |
| print($output); |
| |
| return true; |
| |
| |
| } |
| |
| |
| |
| } |
| |
| /* +--Fin du code ---------------------------------------------------------------------------------------+ |
| * $Log$ |
| * Revision 1.7 2008-11-13 11:29:12 ddelon |
| * Reecriture gwt-ext |
| * |
| * Revision 1.6 2008-01-30 08:57:28 ddelon |
| * fin mise en place mygwt |
| * |
| * Revision 1.5 2007-05-22 12:54:08 ddelon |
| * Securisation acces utilisateur |
| * |
| * |
| * |
| */ |
| |
| |
| ?> |