Subversion Repositories eFlore/Applications.cel

<?php
// declare(encoding='UTF-8');
/**
 * Script d'extration des métadonnées des images pour intégration dans la BDD v2.
 * Utilisation : /opt/lampp/bin/php cli.php ExtracteurMeta
 *
 * @category    php 5.2
 * @package             Cel/Scripts
 * @author              Aurelien PERONNET <aurelien@tela-botanica.org>
 * @author              Jean-Pascal MILCENT <jpm@tela-botanica.org>
 * @copyright   Copyright (c) 2012, 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 ExtracteurMeta {

        const DROIT = 0705;

        private $chemin_images = '';
        private $bdd = null;
        private $script = null;

        private $idImg = null;
        private $metaComplet = null;
        private $exif = null;
        private $iptc = null;
        private $xmp = null;
        private $makerNotes = null;
        private $metaAutres = null;


        public function __construct(Conteneur $conteneur) {
                $this->chemin_images = $conteneur->getParametre('cel.chemin_images');
                $this->bdd = $conteneur->getBdd();
                $this->script = $conteneur->getScript();
        }

        public function executer($arguments) {
                echo "EXTRACTION des MÉTADONNÉES\n";
                echo "Vérification config : ".$this->verifierConfig()."\n";

                $images = $this->obtenirImagesEnBdd();
                foreach ($images as $img) {
                        $this->idImg = $img['id_image'];

                        $cheminImage = $this->obtenirCheminImageOriginale($this->idImg);
                        if (file_exists($cheminImage)) {clear
                                $cmd = "exiftool -X -file:comment $cheminImage";
                                $metaFile = $this->executerCommandeSysteme($cmd);

                                if ($this->neccessiterRemplacement($metaFile) === true) {
                                        //print "Remplacement : {$this->idImg} \n";

                                        $cmd = "exiftool -X -D -U -b -c '%.6f' -d '%Y-%m-%d %H:%M:%S' -All $cheminImage";
                                        $this->metaComplet = $this->executerCommandeSysteme($cmd);

                                        $cmd = "exiftool -X -D -c '%.6f' -d '%Y-%m-%d %H:%M:%S' -exif:all $cheminImage";
                                        $this->exif = $this->executerCommandeSysteme($cmd);

                                        $cmd = "exiftool -X -D -c '%.6f' -d '%Y-%m-%d %H:%M:%S' -iptc:all $cheminImage";
                                        $this->iptc = $this->executerCommandeSysteme($cmd);

                                        $cmd = "exiftool -X -D -c '%.6f' -d '%Y-%m-%d %H:%M:%S' -xmp:all $cheminImage";
                                        $this->xmp = $this->executerCommandeSysteme($cmd);

                                        $cmd = "exiftool -X -D -c '%.6f' -d '%Y-%m-%d %H:%M:%S' -makernotes:all $cheminImage";
                                        $this->makerNotes = $this->executerCommandeSysteme($cmd);

                                        $cmd = "exiftool -X -D -c '%.6f' -d '%Y-%m-%d %H:%M:%S' --exif:all --iptc:all --xmp:all --makernotes:all $cheminImage";
                                        $this->metaAutres = $this->executerCommandeSysteme($cmd);

                                        $this->ecrireFichierRdf();
                                        $this->mettreAJourBdd();
                                }
                        } else {
                                //print "Fichier image '{$this->idImg}' introuvable\n";
                        }
                        $this->script->afficherAvancement("Analyse des images");
                }
                print "\n";
        }

        private function verifierConfig() {
                if (empty($this->chemin_images)) {
                        $message = "Vous devez indiquer le dossier contenant la hiérarchie des images dans le paramètre : ".
                                        "[cel] chemin_images";
                        $code = (string) E_USER_ERROR;
                        throw new Exception($message);
                }
                return 'OK';
        }

        private function obtenirImagesEnBdd() {
                $requete = 'SELECT id_image FROM cel_images ';
                $images = $this->bdd->requeter($requete);
                return $images;
        }

        private function executerCommandeSysteme($commande) {
                $handle = popen($commande, 'r');
                $metaXml = '';
                while (!feof($handle)) {
                        $metaXml .= fread($handle, 8192);
                }
                fclose($handle);
                return $metaXml;
        }

        private function obtenirCheminImageRDF() {
                return $this->obtenirCheminImage('RDF', 'xml');
        }

        private function obtenirCheminImageOriginale() {
                return $this->obtenirCheminImage('O');
        }

        private function obtenirCheminImage($format, $extension = 'jpg') {
                $nom = $this->convertirIdBddVersNomFichier($format, $extension);
                $cheminDossier = $this->obtenirDossierPourFormat($format);
                if (file_exists($cheminDossier) === false) {
                        $this->creerDossier($cheminDossier);
                }
                return $cheminDossier.'/'.$nom;
        }

        private function convertirIdBddVersNomFichier($format, $extension) {
                $id_avec_zeros = sprintf('%09s', $this->idImg) ;
                $id_avec_zeros_underscores = wordwrap($id_avec_zeros, 3 , '_', true) ;
                $nom_fichier = $id_avec_zeros_underscores.'_'.$format.'.'.$extension;
                return $nom_fichier;
        }

        private function obtenirDossierPourFormat($format) {
                $id = sprintf('%09s', $this->idImg);
                $id = wordwrap($id, 3 , '_', true);
                list($dossierNiveau1, $dossierNiveau2) = explode('_', $id);

                $chemin_sur_serveur_final = $this->chemin_images.'/'.$dossierNiveau1.'/'.$dossierNiveau2.'/'.$format;
                return $chemin_sur_serveur_final;
        }

        private function creerDossier($cheminDossier) {
                umask(0);
                if (mkdir($cheminDossier, self::DROIT, true) === false) {
                        $message = "Problème durant la création du dossier '$cheminDossier'.";
                        throw new Exception($message);
                }
        }

        private function neccessiterRemplacement($metaXml) {
                $meta = new SimpleXMLElement($metaXml);
                $rdf = $meta->children('http://www.w3.org/1999/02/22-rdf-syntax-ns#');
                $file = $rdf->children('http://ns.exiftool.ca/File/1.0/');
                return strpos($file->Comment, "CREATOR: gd-jpeg") === false ? true : false;
        }

        private function ecrireFichierRdf() {
                $cheminRdf = $this->obtenirCheminImageRDF($this->idImg);
                file_put_contents($cheminRdf, $this->metaComplet);
        }

        private function mettreAJourBdd() {
                $idImg = $this->bdd->proteger($this->idImg);
                $exif = $this->bdd->proteger($this->exif);
                $iptc = $this->bdd->proteger($this->iptc);
                $xmp = $this->bdd->proteger($this->xmp);
                $makerNotes = $this->bdd->proteger($this->makerNotes);
                $autres = $this->bdd->proteger($this->metaAutres);

                $requete = 'UPDATE cel_images SET '.
                        "       meta_exif = $exif, ".
                        "       meta_iptc = $iptc, ".
                        "       meta_xmp = $xmp, ".
                        "       meta_makernote = $makerNotes, ".
                        "       meta_autres = $autres ".
                        "WHERE id_image = $idImg ";
                $resultat = $this->bdd->executer($requete);

                echo "Mise à jour image '{$this->idImg}' : $resultat\n";
        }
}
?>