Subversion Repositories eFlore/Projets.eflore-projets

<?php
class TaxonDao extends Bdd {
        // tableau de la forme $taxons[num][flore][id]
        // $taxons[num][flore][nom]
        protected $taxons = array();
        private $id = 0;
        private $flores = array('syntri', 'ciff', 'codefr94', 'bdnff', 'bryo', 'floeur', 'algues', 'characees', 'lichen', 'fournier');
        private $table_flores = array('bdnff', 'fournier', 'ciff', 'syntri', 'codefr94',  'bryo', 'floeur');
        
        public function __construct() {
                Bdd::__construct();
                $this->id = $this->chargerId() + 1;
                $this->taxons = $this->chargerTaxon();
        }
        
        // recherche si un taxon existe sinon le crée et renvoie son id
        public function getId($num_taxon, $flore = 'ind', $nom = null, $flore_supp = null, $num_supp = null, $remarques = '') {
        
                $idTaxon = null; $nom_supp = $nom;
                if ($nom == null && $remarques != '') {
                        $nom = "rem:".$flore_supp.$num_supp.'/'.$remarques;
                }

                if (isset($this->taxons['ind'][$nom]['id'])) {
                        $idTaxon = $this->taxons['ind'][$nom]['id'];
                } elseif (isset($this->taxons[$flore][$num_taxon]['id']) && $nom == null) {
                        $idTaxon = $this->taxons[$flore][$num_taxon]['id'];
                } else {
                        $idTaxon = $this->ajouterTaxon($num_taxon, $flore, $nom_supp, $flore_supp, $num_supp, $remarques);
                }
                return $idTaxon;
        }

        // renvoie un nom d'apres son id
        public function getNom($id) {
                foreach ($this->taxons['ind'] as $nom=>$param) {
                        if ($param['id'] === $id) {
                                if (preg_match('/rem:[a-z]+\d+\/(.*)/', $nom, $match)) {
                                        $nom = $match[1];
                                }
                                return $nom;
                        } 
                }
                return '';
        }
        
        // Ajoute taxon avec pour clé le numéro taxon, le nom ou la remarque
        public function ajouterTaxon($num_taxon, $flore, $nom, $flore_supp, $num_supp, $remarques) {
                if ($nom != null) { 
                        $cle = 'ind';
                        $num = $nom;
                } elseif ($remarques != '') {
                        $cle = 'ind';
                        $num = "rem:".$flore_supp.$num_supp.'/'.$remarques;
                } else {
                        $cle = $flore;
                        $num = $num_taxon;
                }
                $this->taxons[$cle][$num]['id'] = $this->id;
                foreach ($this->flores as $nom_flore) {
                        if ($nom_flore == $flore) {
                                $this->taxons[$cle][$num][$nom_flore] = $num_taxon; 
                        } elseif ($nom_flore == $flore_supp) {
                                $this->taxons[$cle][$num][$nom_flore] = $num_supp;
                        } else {
                                $this->taxons[$cle][$num][$nom_flore] = 'NULL';
                        }
                }
                $this->taxons[$cle][$num]['nom'] = $this->ajouterNomTaxon($num_taxon, $flore, $nom, $flore_supp, $num_supp);
                $this->taxons[$cle][$num]['remarques'] = $remarques;
                $this->id++;
                return $this->taxons[$cle][$num]['id'];
        }
        
        public function ajouterNomTaxon($num_taxon, $flore, $nom_supp, $flore_supp, $num_supp) {
                $nom = '';
                $nomCherche = false;
                foreach ($this->table_flores as $nom_flore) {
                        if ($nomCherche == false) {
                                if ($nom_flore == $flore) {
                                        $nom = $this->rechercherNomTaxon($nom_flore, $num_taxon);
                                        if ($nom != false) {
                                                $nomCherche = true;
                                        }       
                                } elseif ($nom_flore == $flore_supp) {
                                        $nom = $this->rechercherNomTaxon($nom_flore, $num_supp);
                                        if ($nom != false) {
                                                $nomCherche = true;
                                        }
                                }
                        }
                }
                if ($nom == false && $nom_supp != null) {
                        $nom = $nom_supp;
                } elseif ($nom == '' && $nom_supp != null) {
                        $nom = $nom_supp;
                }
                return $nom;
        }
        
        public function rechercherNomTaxon($nom_flore, $num_taxon) {
                $requete2 = null;
                switch ($nom_flore) {
                        case 'bdnff' :
                                $requete = "SELECT sb_nom_complet AS nom FROM sophy_bdnff 
                                        WHERE sb_num_tax = {$num_taxon} AND sb_id_num_bdnff = sb_num_nom_retenu; ";
                                break;
                        case 'fournier' :
                                $requete = "SELECT sb_nom_complet AS nom FROM sophy_bdnff, sophy_fournier_bdnff 
                                        WHERE sfb_id_num_fournier = {$num_taxon} AND sb_num_tax = sfb_id_num_bdnff AND sb_id_num_bdnff = sb_num_nom_retenu;";
                                $requete2 = "SELECT sf_nom_fournier AS nom FROM sophy_fournier WHERE sf_id_num_fournier = {$num_taxon};";
                                break;  
                        case 'ciff' :   
                                $requete = "SELECT sb_nom_complet AS nom 
                                        FROM sophy_bdnff, sophy_ciff_bdnff
                                        WHERE scb_id_num_ciff = {$num_taxon} AND scb_id_num_bdnff = sb_id_num_bdnff;";
                                $requete2 = "SELECT sci_nom_ciff AS nom FROM sophy_ciff WHERE sci_id_num_ciff = {$num_taxon};";
                                break;
                        case 'syntri' :
                                $requete = "SELECT sb_nom_complet AS nom 
                                        FROM sophy_bdnff, sophy_syntri_fournier, sophy_fournier_bdnff
                                        WHERE ssf_id_num_syntri = {$num_taxon} AND ssf_id_num_fournier = sfb_id_num_fournier
                                        AND sb_num_tax = sfb_id_num_bdnff AND sb_id_num_bdnff = sb_num_nom_retenu;";
                                $requete2 = "SELECT ssyn_nom_supp AS nom FROM sophy_syntri WHERE ssyn_id_num_supp = {$num_taxon};";
                                break;  
                        case 'codefr94' :
                                $requete = "SELECT sc_nom_codefr AS nom FROM sophy_codefr94 WHERE sc_id_num_codefr = {$num_taxon};";
                                break;
                        case 'bryo' :
                                $requete = "SELECT sbr_nom_bryo AS nom FROM sophy_bryophyte WHERE sbr_id_num_bryo = {$num_taxon};";
                                break;  
                        case 'floeur' :
                                $requete = "SELECT sfe_nom_floeur AS nom FROM sophy_flora_europea WHERE sfe_id_num_floeur = {$num_taxon};";
                                break;  
                }
                $resultat_requete = $this->recuperer($requete);
                if ($resultat_requete['nom'] == false && $requete2 != null) {
                        $resultat_requete = $this->recuperer($requete2);
                }
                return $resultat_requete['nom'];
        }
        // recherche le dernier id de la base
        public function chargerId() {
                $id = 0;
                $requete_select_id = "SELECT MAX(st_id_taxon) AS idMax FROM sophy_taxon;";
                $resultat_requete_id = $this->recuperer($requete_select_id);
                if ($resultat_requete_id['idMax'] != false) {
                        $id = $resultat_requete_id['idMax'];
                }
                return $id;
        }
        
        // Regarde si il y a des taxons dans la base, retourne le tableau de valeur et vide la base
        public function chargerTaxon() {
                $resultat = null;
                $retour = null;
                $requete_select = "SELECT * FROM sophy_taxon;";
                $resultat = $this->recupererTous($requete_select);
                if ($resultat != false) {
                        foreach ($resultat as $result) {
                                if ($result['st_nom_supp'] != null) {
                                        $retour['ind'][$result['st_nom_supp']]['id'] = $result['st_id_taxon'];
                                        foreach ($this->flores as $nom_flore) {
                                                $retour['ind'][$result['st_nom_supp']][$nom_flore] = $result["st_ce_num_".$nom_flore];
                                        }                                       
                                        $retour['ind'][$result['st_nom_supp']]['remarques'] = $result['st_nom_supp'];
                                } elseif ($result['st_remarques'] != null) { 
                                        $nom = $result['st_remarques'];
                                        $retour['ind'][$nom]['id'] = $result['st_id_taxon'];
                                        foreach ($this->flores as $nom_flore) {
                                                $retour['ind'][$result['st_nom_supp']][$nom_flore] = $result["st_ce_num_".$nom_flore];
                                        }
                                        $retour['ind'][$nom]['remarques'] = $result['st_nom_supp'];
                                } elseif ($result['st_ce_num_syntri'] != null) {
                                        $retour['syntri'][$result['st_ce_num_syntri']]['id'] = $result['st_id_taxon'];
                                        $retour['syntri'][$result['st_ce_num_syntri']]['num_supp'] = $result['st_num_supp'];
                                } elseif ($result['st_ce_num_floeur'] != null) {
                                        $retour['floeur'][$result['st_ce_num_floeur']]['id'] = $result['st_id_taxon'];
                                } elseif ($result['st_ce_num_bdnff'] != null) {
                                        $retour['bdnff'][$result['st_ce_num_bdnff']]['id'] = $result['st_id_taxon'];
                                } elseif ($result['st_ce_num_codefr94'] != null) {
                                        $retour['codefr94'][$result['st_ce_num_codefr94']]['id'] = $result['st_id_taxon'];              
                                } elseif ($result['st_ce_num_bryo'] != null) {
                                        $retour['bryo'][$result['st_ce_num_bryo']]['id'] = $result['st_id_taxon'];
                                } elseif ($result['st_ce_num_ciff'] != null) {
                                        $retour['ciff'][$result['st_ce_num_ciff']]['id'] = $result['st_id_taxon'];
                                }  elseif ($result['st_ce_num_fournier'] != null) {
                                        $retour['fournier'][$result['st_ce_num_fournier']]['id'] = $result['st_id_taxon'];
                                }
                        }       
                }
                $requete = "TRUNCATE TABLE `sophy_taxon`; ";
                $res = $this->requeter($requete);
                return $retour;
        }
// +-------------------------------------------------------------------------------------------------------------------+
// Requête sur table sophy_taxon et toutes les tables flore de sophy  
        public function integrerTaxons() {
                foreach ($this->taxons as $flore=>$taxons) {
                        switch ($flore) {
                                case 'ind' : 
                                        // insertion par 1000 pour éviter que la requête soit trop lourde
                                        $i = 0; $j = 1000;
                                        $requete = "INSERT INTO `sophy_taxon` (`st_id_taxon`, `st_nom`, `st_nom_supp`,";
                                        foreach ($this->flores as $nom_flore) {
                                                $requete .= "st_ce_num_{$nom_flore}, ";
                                        }
                                        $requete .= " st_remarques) VALUES ";
                                        foreach ($taxons as $taxon=>$valeur) {
                                                if (!isset($valeur['remarques'])){
                                                        $valeur['remarques'] = 'NULL';
                                                        $taxon = $this->proteger($taxon);
                                                } elseif (substr_compare($taxon, 'rem:', 0, 4) == 0){
                                                        $valeur['remarques'] = $this->proteger($taxon);
                                                        $taxon = 'NULL';
                                                } else {
                                                        $taxon = $this->proteger($taxon);
                                                        $valeur['remarques'] = $this->proteger($valeur['remarques']);
                                                }
                                                
                                                if ($i < $j) {
                                                        $requete .= " (".$valeur['id'].", ".$this->proteger($valeur['nom']).", ".$taxon.", ";
                                                        foreach ($this->flores as $nom_flore) {
                                                                $requete .= $valeur[$nom_flore].", ";
                                                        }
                                                        $requete .= " ".$valeur['remarques']."),";
                                                } elseif ($i == $j) {$j += 1000;
                                                        $requete = substr($requete,0,-1).";";
                                                        $resultat = $this->requeter($requete);
                                                        if ($resultat == false) {
                                                                echo $flore.' : '.$i;
                                                        }
                                                        $requete = "INSERT INTO `sophy_taxon` (`st_id_taxon`, `st_nom`, `st_nom_supp`,";
                                                        foreach ($this->flores as $nom_flore) {
                                                                $requete .= "st_ce_num_{$nom_flore}, ";
                                                        }
                                                        $requete .= " st_remarques) VALUES (".$valeur['id'].", ".$this->proteger($valeur['nom']).
                                                                ", ".$taxon.", ";
                                                        foreach ($this->flores as $nom_flore) {
                                                                $requete .= $valeur[$nom_flore].", ";
                                                        }
                                                        $requete .= " ".$valeur['remarques']."),";
                                                }
                                                $i++;
                                        }
                                        $requete = substr($requete,0,-1).";";
                                        break;
                                case 'syntri' :
                                        $i = 0;
                                        $requete = "INSERT INTO `sophy_taxon` (`st_id_taxon`, ";
                                        foreach ($this->flores as $nom_flore) {
                                                $requete .= "st_ce_num_{$nom_flore}, ";
                                        }
                                        $requete .= "`st_nom`) VALUES ";
                                        foreach ($taxons as $taxon=>$valeur) {
                                                $requete .= " (".$valeur['id'].", ";
                                                foreach ($this->flores as $nom_flore) {
                                                                $requete .= $valeur[$nom_flore].", ";
                                                }
                                                $requete .= $this->proteger($valeur['nom'])."), ";
                                        }
                                        $requete = substr($requete,0,-2).";"; 
                                        break;
                                default: 
                                        $requete = "INSERT INTO `sophy_taxon` (`st_id_taxon`, `st_nom`, st_ce_num_{$flore}) VALUES ";
                                        foreach ($taxons as $numTaxon=>$valeur) {
                                                $requete .= " (".$valeur['id'].", ".$this->proteger($valeur['nom']).", ".$numTaxon."),"; 
                                        }
                                        $requete = substr($requete,0,-1).";";
                                        break;
                        }
                        $resultat = $this->requeter($requete);
                        if ($resultat == false) {
                                echo " - flore : ".$flore;
                        }
                }
        }
}
?>