| /trunk/jrest/lib/NameParser.php |
|---|
| New file |
| 0,0 → 1,375 |
| <?php |
| /** |
| * Taxamatch-Webservice PHP v1.0.0 |
| * @author Michael Giddens |
| * @link http://www.silverbiology.com |
| */ |
| /* Adapation par David Delon Decembre 2010 : gestion sous espece |
| */ |
| /** |
| * Class NameParser |
| * Used to convert a string to a standarized format. |
| */ |
| class NameParser { |
| /** |
| * Whether to debug or nor |
| * @var bool|integer |
| */ |
| public $debug_flag; |
| /** |
| * Constructor |
| */ |
| public function __construct( ) { |
| } |
| /** |
| * Sets value to the method property |
| * @param mixed $name class property name |
| * @param mixed $value class property value |
| */ |
| public function set($name,$value) { |
| $this->$name = $value; |
| } |
| /** |
| * Reduce Spaces |
| * This will reduce the string to only allow once space between characters |
| * @param string $str : string to reduce space |
| * @return string : string with only once space between characters |
| */ |
| private function reduce_spaces( $str ) { |
| $str = preg_replace("/ {2,}/", ' ', $str ); |
| $str = trim( $str ); |
| return( $str ); |
| } |
| /** |
| * Function: parse_auth |
| * Purpose: Produce a parsed version of authority of a taxon name |
| * @author Tony Rees (Tony.Rees@csiro.au) |
| * Date created: March 2008 |
| * Inputs: authority string as str |
| * Remarks: |
| * (1) Performs authority expension of known abbreviated authornames using |
| * table "auth_abbrev_test1" (must be available and populated with relevant content) |
| * (2) Recognises "and", "et", "&" as equivalents (special case for "et al.") - all parsed to ampersand |
| * (3) Recognises (e.g.) "Smith 1980" and "Smith, 1980" as equivalents - comma is removed in these cases |
| * (4) Recognises (e.g.) "F. J. R. Taylor, 1980" and "F.J.R. Taylor, 1980" as equivalents - |
| * extra space after full stops is ignored in these cases |
| * (5) Returns uppercase string, diacritical marks intact |
| * |
| * @param string $str : authority string |
| * @param integer $upcase : convert to uppercase if $upcase = 1 |
| * @return string : parsed author string |
| */ |
| public function parse_auth( $str, $upcase=1 ) { |
| $this->debug['parse_auth'][] = "1"; |
| $temp = $str = trim($str); |
| if ( ($str == NULL) || ($str == '') ) { |
| $this->debug['parse_auth'][] = "1a"; |
| return ''; |
| } |
| if ( ( $temp == null ) || ( $temp == '') ) { |
| $this->debug['parse_auth'][] = "2a"; |
| return(''); |
| } else { |
| $this->debug['parse_auth'][] = "2b"; |
| // add space after full stops, except at end (NB, will also add spece before some close brackets) |
| $temp = rtrim( str_replace('.', '. ', $temp) ); |
| $this->debug['parse_auth'][] = "4 (temp:$temp)"; |
| //normalise "et", "and" to ampersand (et al. is a special case) |
| // if ( $temp like '% et al%' ) { |
| if ( ereg(' et al', $temp) ) { |
| $temp = str_replace(' et al','zzzzz', $temp); |
| $this->debug['parse_auth'][] = "4a (temp:$temp)"; |
| } |
| // $temp = str_replace(temp,' et ',' '||'&'||' '); |
| // $temp = replace(temp,' and ',' '||'&'||' '); |
| $temp = str_replace(' et ',' & ', $temp ); |
| $temp = str_replace(' and ',' & ', $temp ); |
| // if ( $temp like '%zzzzz%' ) { |
| // if ( ereg('zzzzz', $temp) ) { |
| $temp = str_replace('zzzzz',' et al', $temp); |
| // } |
| $this->debug['parse_auth'][] = "5 (temp:$temp)"; |
| //remove commas before dates (only) |
| // like '%, 17%' |
| if ( ereg(', 17', $temp) ) { |
| $temp = str_replace(', 17',' 17', $temp); |
| $this->debug['parse_auth'][] = "5a (temp:$temp)"; |
| } |
| // like '%, 18%' |
| if ( ereg(', 18', $temp) ) { |
| $temp = str_replace(', 18',' 18', $temp); |
| $this->debug['parse_auth'][] = "5b (temp:$temp)"; |
| } |
| // like '%, 19%' |
| if ( ereg(', 19', $temp) ) { |
| $temp = str_replace(', 19',' 19', $temp); |
| $this->debug['parse_auth'][] = "5c (temp:$temp)"; |
| } |
| // like '%, 20%' |
| if ( ereg(', 20', $temp) ) { |
| $temp = str_replace(', 20',' 20', $temp); |
| $this->debug['parse_auth'][] = "5d (temp:$temp)"; |
| } |
| // reduce multiple internal spaces to single space |
| $temp = $this->reduce_spaces( $temp ); |
| // like '% -%' |
| $temp = str_replace(' -', '-', $temp); |
| $this->debug['parse_auth'][] = "6 (temp:$temp)"; |
| foreach( explode(' ', $temp) as $this_word ) { |
| $this->debug['parse_auth'][] = "7 (this_word:$this_word)"; |
| // like '(%' |
| if ( ereg('^\(', $this_word) ) { |
| $elapsed_chars .= '('; |
| $this_word = substr( $this_word, 1 ); |
| $this->debug['parse_auth'][] = "7a (this_word:$this_word) (elapsed_chars:$elapsed_chars)"; |
| } |
| // Add back the word to the final translation |
| $elapsed_chars .= $this_word . ' '; |
| $this->debug['parse_auth'][] = "7c (this_word:$this_word) (elapsed_chars:$elapsed_chars)"; |
| } |
| $elapsed_chars = $this->reduce_spaces( str_replace(' )', ')', $elapsed_chars) ); |
| return trim( $elapsed_chars ) ; |
| } |
| } |
| /** |
| * Function: parse |
| * Purpose: Produces parsed version of an input string (scientific name components) |
| * @author Tony Rees (Tony.Rees@csiro.au) |
| * Date created: June 2007-November 2008 |
| * Inputs: input string as str (this version presumes genus, genus+species, or |
| * genus+species+authority) |
| * Outputs: parsed version of input string, for match purposes |
| * Remarks: |
| * (1) Removes known text elements e.g. |
| * 'aff.', 'cf.', 'subsp.', subgenera if enclosed in brackets, etc. as desired |
| * (2) Removes accented and non A-Z characters other than full stops |
| * (in scientific name portions) |
| * (3) Returns uppercase scientific name (genus + species only) |
| * plus unaltered (presumed) authority |
| * examples; |
| * Anabaena cf. flos-aquae Ralfs ex Born. et Flah. => ANABAENA FLOSAQUAE Ralfs |
| * ex Born. et Flah. |
| * Abisara lemÈe-pauli => ABISARA LEMEEPAULI |
| * Fuc/us Vesiculos2us => FUCUS VESICULOSUS |
| * Buffo ignicolor LacÈpËde, 1788 => BUFFO IGNICOLOR LacÈpËde, 1788 |
| * Barbatia (Mesocibota) bistrigata (Dunker, 1866) => BARBATIA BISTRIGATA (Dunker, 1866) |
| * (4) Thus version does not handle genus+author, or genus+species+infraspecies |
| * (second" good" term is presumed to be species epithet, anything after is |
| * considered to be start of the authority), however could be adapted further as required |
| * and actually it was done in this version for Tela Botanica |
| * (5) There is a separate function "parse_auth" for normalizing authorities when required |
| * (e.g. for authority comparisons) |
| * |
| * @param string $str : input string ( genus, genus+species, or genus+species+authority ) |
| * @return string : parsed string |
| */ |
| public function parse( $str = NULL ) { |
| unset($this->debug['parse']); |
| $temp = ''; |
| $first_str_part = NULL; |
| $second_str_part = NULL; |
| $temp_genus = ''; |
| $temp_species = ''; |
| $temp_genus_species = ''; |
| $temp_authority = ''; |
| $temp_infra = ''; |
| $this->debug['parse'][] = "1"; |
| if ( ($str == NULL) || ( trim($str) == '') ) { |
| $this->debug[] = "N1a<br>"; |
| return ''; |
| } else { |
| // trim any leading, trailing spaces or line feeds |
| $temp = trim( $str ); |
| $this->debug['parse'][] = "1b"; |
| } |
| if ( $temp == NULL || $temp == '') { |
| $this->debug['parse'][] = "2a"; |
| return ''; |
| } else { |
| $this->debug['parse'][] = "2b"; |
| // replace any HTML ampersands |
| $set = array('%', '&', 'amp;%', 'AMP;%'); |
| $temp = str_replace( $set, '&', $temp ); |
| $this->debug['parse'][] = "2b1 (temp:$temp)"; |
| // remove any content in angle brackets (e.g. html tags - <i>, </i>, etc.) |
| $html_pattern = "(\<(/?[^\>]+)\>)"; |
| //? This should not just handle html tags but all <*> |
| $temp = preg_replace( $html_pattern, '', $temp); |
| $this->debug['parse'][] = "2b2 (temp:$temp)"; |
| // if second term (only) is in round brackets, presume it is a subgenus or a comment and remove it |
| // examples: Barbatia (Mesocibota) bistrigata (Dunker, 1866) => Barbatia bistrigata (Dunker, 1866) |
| // Barbatia (?) bistrigata (Dunker, 1866) => Barbatia bistrigata (Dunker, 1866) |
| // (obviously this will not suit genus + author alone, where first part of authorname is in brackets, |
| // however this is very rare?? and in any case we are not supporting genus+authority in this version) |
| //if ( $temp like '% (%)%' |
| $temp = preg_replace( "/ \(\w*\W*\)/", '', $temp, 1 ); |
| //? Not sure if this will catch if |
| $this->debug['parse'][] = "2b3 (temp:$temp)"; |
| // if second term (only) is in square brackets, presume it is a comment and remove it |
| // example: Aphis [?] ficus Theobald, [1918] => Aphis ficus Theobald, [1918] |
| //if ( $temp like '% [%]%' |
| $temp = preg_replace( "/ \[\w*\W*\]/", '', $temp, 1 ); |
| //? Not sure if this will catch if |
| $this->debug['parse'][] = "2b4 (temp:$temp)"; |
| // drop indicators of questionable id's - presume all are lowercase for now (could extend as needed) |
| $temp = preg_replace( "/ cf /", " ", $temp ); |
| $temp = preg_replace( "/ cf\. /", " ", $temp ); |
| $temp = preg_replace( "/ near /", " ", $temp ); |
| $temp = preg_replace( "/ aff\. /", " ", $temp ); |
| $temp = preg_replace( "/ sp\. /", " ", $temp ); |
| $temp = preg_replace( "/ spp\. /", " ", $temp ); |
| $temp = preg_replace( "/ spp /", " ", $temp ); |
| $this->debug['parse'][] = "2b5 (temp:$temp)"; |
| // eliminate or close up any stray spaces introduced by the above |
| $temp = $this->reduce_spaces( $temp ); |
| $this->debug['parse'][] = "2b6 (temp:$temp)"; |
| // now presume first element is genus, second (if present) is species, remainder |
| // (if present) is authority |
| // look for genus name |
| $ar = explode( " ", $temp, 2); |
| if ( count( $ar ) ) { |
| $temp_genus = $ar[0]; |
| $temp = @$ar[1]; |
| } else { |
| $temp_genus = $temp; |
| $temp = ''; |
| } |
| $this->debug['parse'][] = "2b7 (temp_genus:$temp_genus) (temp:$temp)"; |
| // look for species epithet and authority |
| $ar = explode( " ", $temp, 2); |
| if ( count( $ar ) ) { |
| $temp_species = $ar[0]; |
| $temp_authority = @$ar[1]; |
| } else { |
| $temp_species = $temp; |
| $temp_authority = ''; |
| } |
| // look for subspecies |
| $infras =array('subsp.','var.'); |
| $temp_authority = preg_replace( "/ssp./", "subsp.", $temp_authority); |
| $temp_authority = preg_replace( "/ssp /", "subsp.", $temp_authority); |
| $temp_authority = preg_replace( "/subsp /", "subsp.", $temp_authority); |
| $temp_authority = preg_replace( "/var /", "var.", $temp_authority); |
| foreach ($infras as $infra) { |
| $pos = strpos($temp_authority, $infra); |
| if ($pos === false) { |
| continue; |
| } |
| else { |
| $temp_infra=substr($temp_authority,$pos+strlen($infra)); |
| $temp_authority=substr($temp_authority,0,$pos); |
| $temp_infra=trim($temp_infra); |
| $temp_infra_type=$infra; |
| // look for infra epithet and authority |
| $ar = explode(" ", $temp_infra, 2); |
| if ( count( $ar ) ) { |
| $temp_infra = $ar[0]; |
| $temp_infra_authority = @$ar[1]; |
| } |
| break; // on s'arrete au premier trouve |
| } |
| } |
| $this->debug['parse'][] = "2b8 (temp_genus:$temp_genus) (temp_species:$temp_species) (temp_authority:$temp_authority) (temp_infra:$temp_infra) (temp_infra_authority:$temp_infra_authority) (temp:$temp)"; |
| // replace selected ligatures here (Genus names can contain Æ, OE ligature) |
| $temp_genus = str_replace( 'Æ', 'AE', $temp_genus); |
| $temp_species = str_replace( 'Æ', 'AE', $temp_species); |
| $temp_infra = str_replace( 'Æ', 'AE', $temp_infra ); |
| $this->debug['parse'][] = "2b9 (temp_genus:$temp_genus) (temp_species:$temp_species) (temp_authority:$temp_authority) (temp_infra:$temp_infra) (temp_infra_authority:$temp_infra_authority) (temp:$temp)"; |
| $temp_genus= trim($temp_genus); |
| $temp_species= trim($temp_species); |
| $temp_infra= trim($temp_infra ); |
| // reduce any new multiple internal spaces to single space, if present |
| $temp_genus= $this->reduce_spaces( $temp_genus ); |
| $temp_species= $this->reduce_spaces( $temp_species ); |
| $temp_infra= $this->reduce_spaces( $temp_infra ); |
| $this->debug['parse'][] = "2b10 (temp_genus:$temp_genus) (temp_species:$temp_species) (temp_authority:$temp_authority) (temp_infra:$temp_infra) (temp_infra_authority:$temp_infra_authority) (temp:$temp)"; |
| if (isset($temp_authority) && ($temp_authority!='') ) { |
| $temp_authority=$this->parse_auth($temp_authority); |
| } |
| if (isset($temp_infra_authority) && ($temp_infra_authority!='') ) { |
| $temp_infra_authority=$this->parse_auth($temp_infra_authority); |
| } |
| $this->debug['parse'][] = "2b11 (temp_genus:$temp_genus) (temp_species:$temp_species) (temp_authority:$temp_authority) (temp_infra:$temp_infra) (temp_infra_authority:$temp_infra_authority) (temp:$temp)"; |
| return array("genus"=>$temp_genus, "species"=>$temp_species, "authority"=>$temp_authority, "infra"=>$temp_infra, "infra_authority"=>$temp_infra_authority, "infra_type"=>$temp_infra_type); |
| } |
| } // End NameParser |
| } // End Class |
| ?> |
| /trunk/jrest/lib/RechercheInfosTaxon.php |
|---|
| New file |
| 0,0 → 1,198 |
| <?php |
| /* |
| * Created on 24 août 2011 |
| * |
| * To change the template for this generated file go to |
| * Window - Preferences - PHPeclipse - PHP - Code Templates |
| */ |
| class RechercheInfosTaxon extends Cel { |
| function rechercherInformationsComplementaires($numNom) { |
| $DB=$this->connectDB($this->config); |
| $query = "SELECT DISTINCT en_nom_genre, en_epithete_espece, en_nom_supra_generique, en_epithete_infra_generique,". |
| " auteur_bex.enaia_intitule_abrege AS abreviation_auteur_basio_ex ". |
| " , auteur_b.enaia_intitule_abrege AS abreviation_auteur_basio ". |
| " , auteur_mex.enaia_intitule_abrege AS abreviation_auteur_modif_ex ". |
| " , auteur_m.enaia_intitule_abrege AS abreviation_auteur_modif ". |
| " , en_epithete_espece, en_epithete_infra_specifique, enrg_abreviation_rang, b.esn_id_taxon, b.esn_id_nom" . |
| " FROM eflore_nom, eflore_nom_rang," . |
| " eflore_naturaliste_intitule_abreviation AS auteur_bex ". |
| " , eflore_naturaliste_intitule_abreviation AS auteur_b ". |
| " , eflore_naturaliste_intitule_abreviation AS auteur_mex ". |
| " , eflore_naturaliste_intitule_abreviation AS auteur_m ". |
| " ,eflore_selection_nom a, eflore_selection_nom b". |
| " WHERE a.esn_id_nom= ".$numNom. |
| " AND a.esn_id_version_projet_taxon = 25 ". |
| " AND a.esn_id_taxon=b.esn_id_taxon ". |
| " AND b.esn_ce_statut=3 ". |
| " AND a.esn_id_version_projet_taxon=b.esn_id_version_projet_taxon" . |
| " AND en_ce_rang = enrg_id_rang" . |
| " AND en_id_nom = b.esn_id_nom" . |
| " AND en_ce_auteur_basio_ex = auteur_bex.enaia_id_intitule_naturaliste_abrege ". |
| " AND en_ce_auteur_basio = auteur_b.enaia_id_intitule_naturaliste_abrege ". |
| " AND en_ce_auteur_modif_ex = auteur_mex.enaia_id_intitule_naturaliste_abrege ". |
| " AND en_ce_auteur_modif = auteur_m.enaia_id_intitule_naturaliste_abrege ". |
| " AND a.esn_id_version_projet_taxon=en_id_version_projet_nom "; |
| $res =& $DB->query($query); |
| if (DB::isError($res)) { |
| die($res->getMessage()); |
| } |
| // Nom retenu, Num Nomen nom retenu, Num Taxon, |
| // Famille |
| $value=array('Nom_Retenu'=>"",'Num_Nom_Retenu'=>"0",'Num_Taxon'=>"0",'Famille'=>""); |
| while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) { |
| $fam=$this->rechercherFamille($row['esn_id_taxon'],$DB); |
| while (($fam['en_ce_rang']!='fin') && ($fam['en_ce_rang'] !=120)) { |
| $fam=$this->rechercherFamille($fam['etr_id_taxon_2'],$DB); |
| } |
| if ($fam['en_ce_rang']==120) { |
| $famille=$fam['en_nom_supra_generique']; |
| } |
| else { |
| $famille="Famille inconnue"; |
| } |
| $value=array('Nom_Retenu'=>$this->formaterNom($row),'Num_Nom_Retenu'=>$row['esn_id_nom'],'Num_Taxon'=>$row['esn_id_taxon'],'Famille'=>$famille); |
| } |
| return $value; |
| } |
| function rechercherInformationsComplementairesSurNom($nom_saisi) { |
| $DB=$this->connectDB($this->config); |
| $value = array(); |
| if($nom_saisi != null && $nom_saisi != "") { |
| $query = 'SELECT * FROM eflore_nom_intitule '. |
| 'WHERE eni_id_categorie_format = 3 AND '. |
| 'eni_id_version_projet_nom = 25 AND '. |
| '(eni_id_valeur_format = 3 OR eni_id_valeur_format = 4) AND '. |
| 'eni_intitule_nom LIKE "'.$nom_saisi.'%" '. |
| 'ORDER BY LENGTH(eni_intitule_nom)'; |
| $res =& $DB->query($query); |
| if (DB::isError($res)) { |
| die($res->getMessage()); |
| } |
| while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) { |
| $value[]=array($row['eni_id_nom'], $row['eni_intitule_nom']); |
| } |
| } |
| return $value; |
| } |
| function formaterNom($rawnom) { |
| // Constitution du nom: |
| $nom = ''; |
| if ($rawnom['en_nom_supra_generique'] != '') { |
| $nom .= $rawnom['en_nom_supra_generique']; |
| } else if ($rawnom['en_epithete_infra_generique'] != '') { |
| $nom .= $rawnom['en_epithete_infra_generique']; |
| } else { |
| if ($rawnom['en_nom_genre'] != '') { |
| $nom .= $rawnom['en_nom_genre']; |
| } |
| if ($rawnom['en_epithete_espece']!= '') { |
| $nom .= ' '.$rawnom['en_epithete_espece']; |
| } |
| if ($rawnom['en_epithete_infra_specifique'] != '') { |
| if (!empty($rawnom['enrg_abreviation_rang'])) { |
| $nom .= ' '.$rawnom['enrg_abreviation_rang'].''; |
| } |
| $nom .= ' '.$rawnom['en_epithete_infra_specifique']; |
| } |
| } |
| return $nom .$this->retournerAuteur($rawnom) ; |
| } |
| function rechercherFamille($taxon,&$DB) { |
| $row=array(); |
| $query="SELECT DISTINCT en_ce_rang, etr_id_taxon_2, en_id_nom, en_nom_supra_generique ". |
| " FROM eflore_taxon_relation, eflore_selection_nom, eflore_nom ". |
| " WHERE etr_id_taxon_1 = ".$taxon. |
| " AND etr_id_version_projet_taxon_1 = 25 ". |
| " AND etr_id_categorie_taxon = 3 ". |
| " AND etr_id_valeur_taxon = 3 ". |
| " AND esn_id_taxon = etr_id_taxon_2 ". |
| " AND esn_ce_statut = 3 ". |
| " AND esn_id_version_projet_taxon = etr_id_version_projet_taxon_1 ". |
| " AND en_id_nom = esn_id_nom ". |
| " AND esn_id_version_projet_taxon=en_id_version_projet_nom "; |
| $res =& $DB->query($query); |
| if (DB::isError($res)) { |
| die($res->getMessage()); |
| } |
| if ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) { |
| return $row; |
| } |
| else { |
| $row['en_ce_rang']='fin'; |
| return $row; |
| } |
| } |
| function retournerAuteur($rawnom) { |
| $auteurs = ''; |
| $auteur_basio = ''; |
| $auteur_modif = ''; |
| if (!empty($rawnom['abreviation_auteur_basio_ex']) && $rawnom['abreviation_auteur_basio_ex']!='-' ) { |
| $auteur_basio .= $rawnom['abreviation_auteur_basio_ex']; |
| if (!empty($rawnom['abreviation_auteur_basio']) && $rawnom['abreviation_auteur_basio']!='-') { |
| $auteur_basio .= ' ex '.$rawnom['abreviation_auteur_basio']; |
| } |
| } else if (!empty($rawnom['abreviation_auteur_basio']) && $rawnom['abreviation_auteur_basio']!='-') { |
| $auteur_basio .= $rawnom['abreviation_auteur_basio']; |
| } |
| if (!empty($rawnom['abreviation_auteur_modif_ex']) && $rawnom['abreviation_auteur_modif_ex']!='-') { |
| $auteur_modif .= $rawnom['abreviation_auteur_modif_ex']; |
| if (!empty($rawnom['abreviation_auteur_modif']) && $rawnom['abreviation_auteur_modif']!='-') { |
| $auteur_modif .= ' ex '.$rawnom['abreviation_auteur_modif']; |
| } |
| } else if (!empty($rawnom['abreviation_auteur_modif']) && $rawnom['abreviation_auteur_modif']!='-') { |
| $auteur_modif .= $rawnom['abreviation_auteur_modif']; |
| } |
| if (!empty($auteur_modif)) { |
| $auteurs = ' ('.$auteur_basio.') '.$auteur_modif; |
| } elseif (!empty($auteur_basio)) { |
| $auteurs = ' '.$auteur_basio; |
| } |
| return $auteurs ; |
| } |
| } |
| ?> |
| /trunk/jrest/lib/RechercheObservation.php |
|---|
| New file |
| 0,0 → 1,152 |
| <?php |
| /* |
| * Created on 24 août 2011 |
| * |
| * To change the template for this generated file go to |
| * Window - Preferences - PHPeclipse - PHP - Code Templates |
| */ |
| /** |
| * librairie recherche d'observations a partir de divers critères |
| * Encodage en entrée : utf8 |
| * Encodage en sortie : utf8 |
| * |
| * @author Aurélien PERONNET <aurelien@tela-botanica.org> |
| * @license GPL v3 <http://www.gnu.org/licenses/gpl.txt> |
| * @license CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt> |
| * @version $Id$ |
| */ |
| class RechercheObservation extends Cel { |
| public function rechercherObservations($id_utilisateur, $criteres, $numero_page = 0, $taille_page = 50) { |
| $requete_selection_observations = "SELECT * FROM cel_obs WHERE ce_utilisateur ='".$id_utilisateur."'"; |
| $sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres); |
| $requete_selection_observations .= $sous_requete_recherche; |
| $debut = $taille_page*$numero_page ; |
| $requete_selection_observations .= ' ORDER BY ordre LIMIT '.$debut.','.$taille_page ; |
| $resultats_observations = array(); |
| $resultats_observations = $this->requeter($requete_selection_observations); |
| return $resultats_observations; |
| } |
| public function compterObservations($id_utilisateur, $criteres) { |
| $requete_selection_observations = "SELECT COUNT(*) as nb_obs FROM cel_obs WHERE ce_utilisateur ='".$id_utilisateur."'"; |
| $sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres); |
| $requete_selection_observations .= $sous_requete_recherche; |
| $nb_obs = 0; |
| $resultat_requete_nombre_observations = $this->requeter($requete_selection_observations); |
| if($resultat_requete_nombre_observations && is_array($resultat_requete_nombre_observations) && count($resultat_requete_nombre_observations) > 0) { |
| $nb_obs = $resultat_requete_nombre_observations[0]['nb_obs']; |
| } |
| return $nb_obs; |
| } |
| // TODO: fonction temporaire |
| public function parserRequeteCriteres($chaine_criteres) { |
| $criteres_parses = array(); |
| $criteres = explode("&", $chaine_criteres) ; |
| foreach ($criteres as &$critere) { |
| $criteres_parses[] = explode("=",$critere) ; |
| } |
| return $criteres_parses; |
| } |
| private function fabriquerSousRequeteRecherche($id_utilisateur, $criteres) { |
| $sous_requete = ' AND '; |
| foreach ($criteres as $nom_valeur) |
| { |
| if (count($nom_valeur) == 0) |
| { |
| continue; |
| } |
| switch ($nom_valeur[0]) { |
| case 'annee': |
| $sous_requete .= "year(date_observation) = ".$this->proteger($nom_valeur[1]) ; |
| $sous_requete .= ' AND ' ; |
| break; |
| case 'mois': |
| $sous_requete .= "month(date_observation) = ".$this->proteger($nom_valeur[1]) ; |
| $sous_requete .= ' AND ' ; |
| break; |
| case 'jour': |
| $sous_requete .= "day(date_observation) = ".$this->proteger($nom_valeur[1]) ; |
| $sous_requete .= ' AND ' ; |
| break; |
| // TODO: adapter la structure aux nouveaux mots clés |
| case 'mots_cles': |
| $liste_mc = explode(";",$nom_valeur[1]); |
| $sous_requete .= '(' ; |
| foreach($liste_mc as $mot) { |
| if(trim($mot) != '') |
| { |
| $sous_requete .= "mots_cles LIKE '%".$this->proteger($mot)."%' OR " ; |
| } |
| } |
| $sous_requete = rtrim($sous_requete,' OR '); |
| $sous_requete .= ') AND ' ; |
| break; |
| //TODO: choisir un meilleur nom |
| case 'nom_taxon': |
| $nom_valeur[1] = str_replace("*","%",$nom_valeur[1]); |
| $sous_requete .= "(nom_sel LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR courriel_utilisateur LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR prenom_utilisateur LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR nom_utilisateur LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR nom_sel LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR nom_sel_nn LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR nom_ret LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR nom_ret_nn LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR nt LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR famille LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR zone_geo LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR ce_zone_geo LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR date_observation LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR lieudit LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR station LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR milieu LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR commentaire LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR transmission LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR latitude LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| " OR longitude LIKE ".$this->proteger('%'.$nom_valeur[1].'%'). |
| ")"; |
| break; |
| default: |
| if(trim($nom_valeur[0]) != '') |
| { |
| $sous_requete .= $nom_valeur[0]." = '".$this->proteger($nom_valeur[1])."'" ; |
| $sous_requete .= ' AND ' ; |
| } |
| break; |
| } |
| } |
| $sous_requete = rtrim($sous_requete,' AND '); |
| return $sous_requete; |
| } |
| } |
| ?> |
| /trunk/jrest/lib/RechercheImage.php |
|---|
| New file |
| 0,0 → 1,213 |
| <?php |
| /** |
| * librairie recherche d'images a partir de divers critères |
| * Encodage en entrée : utf8 |
| * Encodage en sortie : utf8 |
| * |
| * @author Aurélien PERONNET <aurelien@tela-botanica.org> |
| * @license GPL v3 <http://www.gnu.org/licenses/gpl.txt> |
| * @license CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt> |
| * @version $Id$ |
| */ |
| class RechercheImage extends Cel { |
| function rechercherImagesEtObservationAssociees($id_utilisateur, $criteres, $numero_page, $taille_page) |
| { |
| $images_trouvees = $this->rechercherImages($id_utilisateur, $criteres, $numero_page, $taille_page); |
| $retour = array(); |
| foreach($images_trouvees as $image) |
| { |
| $image['id_observation'] = $this->obtenirInformationsObservationsAssociees($id_utilisateur,$image['id_image']); |
| $retour[] = $image ; |
| } |
| return $retour; |
| } |
| // TODO: fonction temporaire |
| public function parserRequeteCriteres($chaine_criteres) { |
| $criteres_parses = array(); |
| $criteres = explode("&", $chaine_criteres) ; |
| foreach($criteres as &$critere) { |
| $criteres_parses[] = explode("=",$critere) ; |
| } |
| return $criteres_parses; |
| } |
| // TODO: fonction temporaire |
| private function formaterDateSqlVersDateAvecSlash($date_sql) { |
| $date_formatee = ''; |
| $date = split("-",$date_sql) ; |
| if(count($date) > 2) |
| { |
| $image['date_prise_de_vue'] = $date[2].'/'.$date[1].'/'.$date[0] ; |
| } |
| return $date_formatee; |
| } |
| public function rechercherImages($id_utilisateur, $criteres, $numero_page = 0 , $taille_page = 50) { |
| $requete_recherche_images = 'SELECT * FROM cel_images WHERE ce_utilisateur = "'.$id_utilisateur.'"' ; |
| $sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres); |
| $requete_recherche_images .= $sous_requete_recherche; |
| $debut = $taille_page*$numero_page ; |
| $requete_recherche_image .= ' ORDER BY ordre LIMIT '.$debut.','.$taille_page ; |
| $resultats_images = array(); |
| $resultats_images = $this->requeter($requete_recherche_images); |
| return $resultats_images; |
| } |
| public function compterImages($id_utilisateur, $criteres) { |
| $requete_recherche_images = 'SELECT COUNT(*) as nb_images FROM cel_images WHERE ce_utilisateur = "'.$id_utilisateur.'"' ; |
| $sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres); |
| $requete_recherche_images .= $sous_requete_recherche; |
| $nb_images = 0; |
| $resultat_requete_nombre_images = $this->requeter($requete_recherche_images); |
| if($resultat_requete_nombre_images && is_array($resultat_requete_nombre_images) && count($resultat_requete_nombre_images) > 0) { |
| $nb_images = $resultat_requete_nombre_images[0]['nb_images']; |
| } |
| return $nb_images; |
| } |
| public function obtenirInformationsObservationsAssociees($id_utilisateur, $id_image) { |
| $requete_table_liaison = 'SELECT id_observation FROM cel_obs_images WHERE id_image = '.$id_image.' AND id_utilisateur ="'.$id_utilisateur.'"'; |
| $resultats_liaisons_images = $this->requeter($requete_table_liaison); |
| $ids_obs = ''; |
| foreach($resultats_liaisons_images as $liaison) { |
| $ids_obs .= $liaison['id_observation'].","; |
| } |
| $ids_obs = rtrim($ids_obs,','); |
| $infos_obs = ''; |
| if(trim($ids_obs) != '') { |
| $requete_obs_liees = 'SELECT * FROM cel_obs WHERE id_observation IN ('.$ids_obs.') AND ce_utilisateur ="'.$id_utilisateur.'"'; |
| $resultat_obs_liees = $this->requeter($requete_obs_liees); |
| foreach($resultat_obs_liees as $obs_liee) |
| { |
| $infos_obs .= $obs_liee['ordre'].'#'.$obs_liee['nom_sel'].'#'.$obs_liee['transmission'].';;' ; |
| } |
| } |
| return $infos_obs; |
| } |
| private function fabriquerSousRequeteRecherche($id_utilisateur, $criteres) { |
| $sous_requete = ' AND '; |
| foreach($criteres as $nom_valeur) |
| { |
| if(count($nom_valeur) == 0) { |
| continue; |
| } |
| switch($nom_valeur[0]) { |
| case "mots_cles"; |
| $mots_cles = rtrim($nom_valeur[1], ',') ; |
| $mots_cles_liste = explode("," , $mots_cles) ; |
| foreach($mots_cles_liste as $mot_cle) |
| { |
| $sous_requete .= $nom_valeur[0].' LIKE "%'.$this->proteger($mot_cle).'%"' ; |
| $sous_requete .= ' AND ' ; |
| } |
| break; |
| case "commentaire": |
| $mots_comment_liste = explode(" " , $nom_valeur[1]) ; |
| foreach($mots_comment_liste as $mot_comment) |
| { |
| $mot_comment = trim($mot_comment) ; |
| $sous_requete .= $nom_valeur[0].' LIKE "%'.$this->proteger($mot_comment).'%"' ; |
| $sous_requete .= ' AND ' ; |
| } |
| break; |
| case "annee": |
| case "mois": |
| case "jour": |
| $sous_requete .= $this->fabriquerSousRequeteRechercheDate($nom_valeur[0], $nom_valeur[1]) ; |
| $sous_requete .= ' AND ' ; |
| break; |
| case "tampon": |
| $ids_tampon = rtrim($nom_valeur[1], ',') ; |
| $sous_requete .= 'id_images IN ( '.$this->proteger($ids_tampon).')' ; |
| break; |
| case "recherche_generale": |
| $sous_requete .= $this->fabriquerSousRequeteRechercheGenerale($id_utilisateur, $nom_valeur[1]); |
| $sous_requete .= ' AND '; |
| break; |
| default: |
| $sous_requete .= $nom_valeur[0].' = "'.$this->proteger($nom_valeur[1]) ; |
| $sous_requete .= '" AND ' ; |
| break; |
| } |
| } |
| $sous_requete = rtrim($sous_requete,' AND '); |
| return $sous_requete; |
| } |
| private function fabriquerSousRequeteRechercheGenerale($id_utilisateur, $chaine_recherche) { |
| $requete_recherche_taxon .= 'SELECT id_image |
| FROM cel_obs_images |
| WHERE id_observation IN ' . |
| '(SELECT id_observation ' . |
| 'FROM cel_obs '. |
| 'WHERE ce_utilisateur ="'.$id_utilisateur.'" '. |
| 'AND nom_sel LIKE "'.$chaine_recherche.'%" '. |
| ')'; |
| $requete_recherche_comm = ' commentaire LIKE "%'.$chaine_recherche.'%" '; |
| $requete_recherche_generale = '(id_image IN ( '.($requete_recherche_taxon).') OR ('.$requete_recherche_comm.'))' ; |
| return $requete_recherche_generale; |
| } |
| private function fabriquerSousRequeteRechercheDate($intervalle, $valeur) { |
| $correspondance_champ = array('annee' => 'YEAR','mois' => 'MONTH','jour' => 'DAY'); |
| $requete_recherche_date = ''; |
| if(is_numeric($valeur) && $valeur != "00") { |
| $requete_recherche_date = $correspondance_champ[$intervalle].'(ci_meta_date) = "'.$valeur.'" '; |
| } else { |
| $requete_recherche_date = '(date_prise_de_vue IS NULL OR date_prise_de_vue = "0000-00-00")'; |
| } |
| return $requete_recherche_date; |
| } |
| } |
| ?> |