Subversion Repositories eFlore/Projets.eflore-projets

<?php
//declare(encoding='UTF-8');
/**
 * Classe permettant de :
 *  - convertir la latitude et longitude en degre, et rajouter l'objet point centroide de la commune.
 *  - charger la bdd
 * Exemple de lancement du script : :
 * /opt/lampp/bin/php cli.php lion1906 -a chargerTous
 *
 * @category    php 5.2
 * @package             eFlore/Scripts
 * @author              Mohcen BENMOUNAH <mohcen@tela-botanica.org>
 * @author              Jean-Pascal MILCENT <jpm@tela-botanica.org>
 * @copyright   Copyright (c) 2011, Tela Botanica (accueil@tela-botanica.org)
 * @license             http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
 * @license             http://www.gnu.org/licenses/gpl.html Licence GNU-GPL
 * @version             $Id$
 */
class Lion1906 extends EfloreScript {

        public function executer() {
                try {
                        $this->initialiserProjet('lion1906');

                        // Lancement de l'action demandée
                        $cmd = $this->getParametre('a');
                        switch ($cmd) {
                                case 'chargerTous' :
                                        $this->chargerStructureSql();
                                        $this->chargerMetaDonnees();
                                        $this->chargerLion1906();
                                        $this->preparerTable();
                                        $this->convertirRadianEnDegre();
                                        break;
                                case 'convertir' :
                                        $this->preparerTable();
                                        $this->convertirRadianEnDegre();
                                        break;
                                case 'supprimerTous' :
                                        $this->supprimerTous();
                                        break;
                                default :
                                        throw new Exception("Erreur : la commande '$cmd' n'existe pas!");
                        }
                } catch (Exception $e) {
                        $this->traiterErreur($e->getMessage());
                }
        }

        protected function chargerMetaDonnees() {
                $contenuSql = $this->recupererContenu(Config::get('chemins.lion1906Meta'));
                $this->executerScripSql($contenuSql);
        }

        private function chargerLion1906() {
                $chemin = Config::get('chemins.lion1906');
                $table = Config::get('tables.lion1906');
                $requete = "LOAD DATA INFILE '$chemin' ".
                                        "REPLACE INTO TABLE $table ".
                                        'CHARACTER SET latin1 '.
                                        'FIELDS '.
                                        "       TERMINATED BY ';' ".
                                        "       ENCLOSED BY '' ".
                                        "       ESCAPED BY '\\\' ".
                                        'IGNORE 1 LINES';
                $this->getBdd()->requeter($requete);
        }

        private function convertirRadianEnDegre() {
                $table = Config::get('tables.lion1906');
                $requete =      'SELECT insee, latitude_radian, longitude_radian '.
                                        "FROM $table ";
                $LatLons = $this->getBdd()->recupererTous($requete);

                foreach ($LatLons as $LatLon) {
                        $insee = $LatLon['insee'] ;
                        $latitude_degre = $LatLon['latitude_radian'] * 180 / pi();
                        $longitude_degre = $LatLon['longitude_radian'] * 180 / pi();
                        $latitude_degre = str_replace(',', '.', $latitude_degre);
                        $longitude_degre = str_replace(',', '.', $longitude_degre);
                        $this->formerPointCentre($latitude_degre, $longitude_degre, $insee);
                        $this->afficherAvancement('Analyse des communes Lion1906');
                }
        }

        private function preparerTable() {
                $table = Config::get('tables.lion1906');
                $requete =      "ALTER TABLE $table ".
                                        'DROP latitude_degre, '.
                                        'DROP longitude_degre, '.
                                        'DROP centroide, '.
                                        'DROP INDEX insee ';
                $this->getBdd()->requeter($requete);

                $requete =      "ALTER TABLE $table ".
                                        '       ADD latitude_degre double NOT NULL , '.
                                        '       ADD longitude_degre double NOT NULL , '.
                                        '       ADD centroide point NOT NULL ';
                $this->getBdd()->requeter($requete);

                $requete =      "ALTER TABLE $table ".
                                        'ADD INDEX insee (insee, latitude_degre, longitude_degre, centroide) ';
                $this->getBdd()->requeter($requete);
        }

        private function formerPointCentre($latitude_degre, $longitude_degre, $insee) {
                $centre = "$latitude_degre $longitude_degre" ;
                $table = Config::get('tables.lion1906');
                $requete = "UPDATE $table ".
                                        "SET latitude_degre = '$latitude_degre', longitude_degre = '$longitude_degre', ".
                                        "       centroide = POINTFROMTEXT('POINT($centre)') ".
                                        "WHERE insee = '$insee' ";
                $this->getBdd()->requeter($requete);
        }

        private function supprimerTous() {
                $requete = "DROP TABLE IF EXISTS lion1906_meta, lion1906_communes_v2008";
                $this->getBdd()->requeter($requete);
        }

}
?>