| New file |
|---|
| 0,0 → 1,1117 |
|---|
| <?php |
| |
| class MigrationImages extends Cel { |
| |
| const bdd_cel_migration = 'cel'; |
| const bdd_utilisateurs = 'cel_old'; |
| |
| const separateur_champs_metadonnees = ';'; |
| const separateur_valeurs_metadonnees = ':'; |
| |
| private $id_cle_metadonnees = array(); |
| |
| /** Tableau associatif permettant de stocker l'avancement dans une boucle. |
| * La clé est un md5 du message à afficher au démarrage de la boucle. |
| * @var array |
| */ |
| private static $avancement = array(); |
| |
| const dry_run = true; |
| |
| private $tableau_utilisateurs = array(); |
| private $tableau_observations = array(); |
| private $tableau_mots_cles = array(); |
| |
| private $tableau_nouveau_ancien = array( |
| 'id_image' => 'ci_id_image', |
| 'ordre' =>'ci_ordre', |
| 'ce_utilisateur' => 'traiterIdentifiantUtilisateur', |
| 'prenom_utilisateur' => 'traiterPrenomUtilisateur', |
| 'nom_utilisateur' => 'traiterNomUtilisateur', |
| 'courriel_utilisateur' => 'ci_ce_utilisateur', |
| 'hauteur' => 'ci_meta_height', |
| 'largeur' => 'ci_meta_width', |
| 'appareil_fabriquant' => 'ci_meta_make', |
| 'appareil_modele' => 'ci_meta_model', |
| 'date_prise_de_vue' => 'ci_meta_date_time', |
| 'note_qualite' => 'ci_note_image', |
| 'mots_cles_texte' => 'traiterMotsClesTexte', |
| 'commentaire' => 'ci_meta_comment', |
| 'nom_original' => 'ci_nom_original', |
| 'md5' => 'ci_md5', |
| 'meta_exif' => 'traiterExif', |
| 'meta_iptc' => 'traiterIptc', |
| 'meta_xmp' => 'traiterXmp', |
| 'meta_makernote' => 'traiterMakernote', |
| 'date_modification' => 'ci_meta_date', |
| 'date_creation' => 'ci_meta_date_ajout' |
| ); |
| |
| private $champs_exifs_non_gardes = array( |
| 'ci_meta_x_resolution', |
| 'ci_meta_y_resolution', |
| 'ci_meta_gps', |
| 'ci_meta_user_comment', |
| 'ci_meta_exif_exposure_time', |
| 'ci_meta_exif_f_number', |
| 'ci_meta_exif_exif_version', |
| 'ci_meta_exif_compressed_bits_per_pixel', |
| 'ci_meta_exif_shutter_speed_value', |
| 'ci_meta_exif_aperture_value', |
| 'ci_meta_exif_exposure_bias_value', |
| 'ci_meta_exif_max_aperture_value', |
| 'ci_meta_exif_metering_mode', |
| 'ci_meta_exif_light_source', |
| 'ci_meta_exif_flash', |
| 'ci_meta_exif_focal_length', |
| 'ci_meta_exif_flash_pix_version', |
| 'ci_meta_exif_color_space', |
| 'ci_meta_exif_interoperability_offset', |
| 'ci_meta_exif_focal_plane_x_resolution', |
| 'ci_meta_exif_focal_plane_y_resolution', |
| 'ci_meta_exif_focal_plane_resolution_unit', |
| 'ci_meta_exif_sensing_method', |
| 'ci_meta_exif_file_source', |
| 'ci_meta_exif_custom_rendered', |
| 'ci_meta_exif_exposure_mode', |
| 'ci_meta_exif_white_balance', |
| 'ci_meta_exif_digital_zoom_ratio', |
| 'ci_meta_exif_scene_capture_type', |
| 'ci_meta_exif_gain_control', |
| 'ci_meta_exif_contrast', |
| 'ci_meta_exif_saturation', |
| 'ci_meta_exif_sharpness', |
| 'ci_meta_exif_subject_distance_range' |
| ); |
| |
| private $champs_iptc_non_gardes = array( |
| 'ci_meta_iptc_category', |
| 'ci_meta_iptc_by_line', |
| 'ci_meta_iptc_by_line_title', |
| 'ci_meta_iptc_city', |
| 'ci_meta_iptc_sub_location', |
| 'ci_meta_iptc_province_state', |
| 'ci_meta_iptc_country_primary_location_code', |
| 'ci_meta_iptc_country_name', |
| 'ci_meta_iptc_headline', |
| 'ci_meta_iptc_credit', |
| 'ci_meta_iptc_copyright_notice', |
| 'ci_meta_iptc_contact' |
| ); |
| |
| private $champs_divers_non_gardes = array( |
| 'ci_publiable_eflore', |
| 'ci_meta_mots_cles' |
| ); |
| |
| /** |
| * Utiliser cette méthode dans une boucle pour afficher un message suivi du nombre de tour de boucle effectué. |
| * Vous devrez vous même gérer le retour à la ligne à la sortie de la boucle. |
| * |
| * @param string le message d'information. |
| * @param int le nombre de départ à afficher. |
| * @return void le message est affiché dans la console. |
| */ |
| protected function afficherAvancement($message, $depart = 0) { |
| if (! isset(self::$avancement[$message])) { |
| self::$avancement[$message] = $depart; |
| echo "$message : "; |
| |
| $actuel =& self::$avancement[$message]; |
| echo $actuel++; |
| } else { |
| $actuel =& self::$avancement[$message]; |
| |
| // Cas du passage de 99 (= 2 caractères) à 100 (= 3 caractères) |
| $passage = 0; |
| if (strlen((string) ($actuel - 1)) < strlen((string) ($actuel))) { |
| $passage = 1; |
| } |
| |
| echo str_repeat(chr(8), (strlen((string) $actuel) - $passage)); |
| echo $actuel++; |
| } |
| } |
| |
| /** |
| * Méthode appelée avec une requête de type GET. |
| */ |
| public function getElement($params) { |
| |
| $this->id_cle_metadonnees = array_merge($this->tableau_ids_tags_exif, $this->tableau_ids_tags_iptc); |
| |
| $this->getUtilisateurs(); |
| $this->getMotsCles(); |
| $this->getObservations(); |
| |
| echo '|| Migration des images ||'."\n"; |
| //$this->migrerImages(); |
| echo "\n"."\n"."\n"; |
| |
| echo '|| Migration des liaisons obs images ||'."\n"; |
| $this->migrerLiaisonsObsImages(); |
| echo "\n"."\n"."\n"; |
| } |
| |
| private function getUtilisateurs() { |
| |
| $requete_selection_utilisateurs = 'SELECT U_ID as id, U_MAIL as mail, U_NAME as nom, U_SURNAME as prenom FROM '.self::bdd_utilisateurs.'.annuaire_tela'; |
| $tableau_utilisateurs = $this->executerRequete($requete_selection_utilisateurs); |
| |
| foreach( $tableau_utilisateurs as &$utilisateur) { |
| $this->tableau_utilisateurs[$utilisateur['mail']] = $utilisateur; |
| } |
| |
| } |
| |
| private function getMotsCles() { |
| |
| $requete_selection_mots_cles = 'SELECT cmc_id_proprietaire as id_utilisateur, cmc_id_mot_cle_utilisateur as id_mot_cle, cmc_mot_cle as mot_cle FROM cel_mots_cles_images'; |
| $tableau_mots_cles = $this->executerRequete($requete_selection_mots_cles); |
| |
| foreach($tableau_mots_cles as &$mot_cle) { |
| $this->tableau_mots_cles[$mot_cle['id_utilisateur']][$mot_cle['id_mot_cle']] = $mot_cle; |
| } |
| } |
| |
| private function getObservations() { |
| $pas = 5000; |
| |
| $nObs = "SELECT COUNT(*) AS nb FROM cel_inventory"; |
| $resultatNbObs = $this->executerRequete($nObs); |
| $nbObs = $resultatNbObs[0]['nb']; |
| |
| for ($i = 0; $i < 230000; $i += $pas ) { |
| $requete_selection_observations = 'SELECT id, ordre, identifiant FROM cel_inventory LIMIT '.$i.", $pas"; |
| $tableau_observations = $this->executerRequete($requete_selection_observations); |
| foreach($tableau_observations as &$obs) { |
| $this->tableau_observations[$obs['identifiant']][$obs['ordre']] = $obs['id']; |
| } |
| |
| //$this->afficherAvancement('Selection des observations (par '.$pas.' )', $i); |
| echo "\n obs : ".$i; |
| } |
| |
| |
| |
| } |
| |
| public function executerRequeteSimple($requete) { |
| // Fonction de commodité pour afficher les requetes au lieu de les executer |
| if (self::dry_run) { |
| echo str_replace('),','),'."\n", $requete)."\n"; |
| return true; |
| } else { |
| return parent::executerRequeteSimple($requete); |
| } |
| } |
| |
| private function migrerImages() { |
| |
| $debut = 0; |
| $pas = 200; |
| $fin = 150000; |
| |
| for ($i = $debut; $i <= $fin ; $i += $pas) { |
| $requete_selection_images = 'SELECT * FROM cel_images '. |
| 'ORDER BY ci_id_image ASC LIMIT '.$i.','.$pas; |
| |
| $images = $this->requeter($requete_selection_images); |
| |
| $requete_insertion_images = 'INSERT INTO '.self::bdd_cel_migration.'.cel_images ('; |
| foreach ($this->tableau_nouveau_ancien as $nouveau_champ => $ancien_champ) { |
| $requete_insertion_images .= $nouveau_champ.','; |
| } |
| $requete_insertion_images = rtrim($requete_insertion_images, ','); |
| |
| $requete_insertion_images = $requete_insertion_images.') VALUES '; |
| |
| if (is_array($images)) { |
| |
| $nb_images_a_traiter = count($images); |
| |
| foreach($images as $image) { |
| |
| $nouvelle_image = $this->traiterLigneImage($image); |
| |
| $nouvelle_image = array_map(array($this,'proteger'),$nouvelle_image); |
| $requete_insertion_images .= '('.join(',',array_values($nouvelle_image)).'),'; |
| } |
| |
| $requete_insertion_images = rtrim($requete_insertion_images, ','); |
| $migration_images = $this->executer($requete_insertion_images); |
| |
| if (!$migration_images) { |
| echo 'la migration des images '.$i.' à '.($i+$nb_images_a_traiter).' a échoué '."\n"; |
| } else { |
| echo 'migration des images '.$i.' à '.($i+$nb_images_a_traiter).' effectuée '."\n"; |
| } |
| } |
| |
| if(count($images) < $pas) { |
| echo 'Fin de la migration des images '."\n"; |
| return; |
| } |
| } |
| } |
| |
| private function migrerLiaisonsObsImages() { |
| $debut = 0; |
| $pas = 200; |
| $fin = 50000; |
| |
| for ($i = $debut; $i <= $fin ; $i += $pas) { |
| $requete_selection_liaisons = 'SELECT * FROM cel_obs_images LIMIT '.$i.','.$pas; |
| $tableau_liaisons = $this->executerRequete($requete_selection_liaisons); |
| |
| $requete_migration_liaison = 'INSERT INTO '.self::bdd_cel_migration.'.cel_obs_images '. |
| '(ce_image, ce_utilisateur, ce_observation, date_liaison) '. |
| 'VALUES '; |
| |
| $sous_requete_insertion = ''; |
| |
| foreach($tableau_liaisons as &$liaison) { |
| |
| $mail_utilisateur = $liaison['coi_ce_utilisateur']; |
| $utilisateur = $mail_utilisateur; |
| |
| if (isset($this->tableau_utilisateurs[$mail_utilisateur])) { |
| $utilisateur = $this->tableau_utilisateurs[$mail_utilisateur]['id']; |
| } |
| |
| $id_obs = $liaison['coi_ce_observation']; |
| |
| if (isset($this->tableau_observations[$mail_utilisateur][$id_obs])) { |
| $id_obs = $this->tableau_observations[$mail_utilisateur][$id_obs]; |
| |
| $sous_requete_insertion .= '('.$this->proteger($liaison['coi_ce_image']).','. |
| $this->proteger($utilisateur).','. |
| $this->proteger($id_obs).','. |
| $this->proteger($liaison['coi_date_liaison']). |
| '),'; |
| } else { |
| echo 'l\'obs '.$id_obs.' n\'existe pas pour l\'utilisateur '.$mail_utilisateur."\n"; |
| } |
| } |
| |
| $sous_requete_insertion = rtrim($sous_requete_insertion,','); |
| $requete_migration_liaison = $requete_migration_liaison.$sous_requete_insertion; |
| |
| $migration_liaison = $this->executerRequeteSimple($requete_migration_liaison); |
| |
| if (!$migration_liaison) { |
| echo 'la migration des liaisons obs images a échoué ! '; |
| } else { |
| echo 'migration des liaisons obs images réussie '; |
| } |
| } |
| } |
| |
| private function traiterLigneImage($image) { |
| |
| $nouvelle_image = array(); |
| |
| foreach ($this->tableau_nouveau_ancien as $nouveau_champ_image => $ancien_champ_image) { |
| |
| if ($this->estUnChampATraiter($ancien_champ_image)) { |
| if (method_exists($this,$ancien_champ_image)) { |
| $nouvelle_image[$nouveau_champ_image] = $this->$ancien_champ_image($image); |
| } else { |
| echo 'methode manquante : '.$ancien_champ_image."\n"; |
| $nouvelle_image[$nouveau_champ_image] = ''; |
| } |
| |
| } else { |
| $nouvelle_image[$nouveau_champ_image] = $image[$ancien_champ_image]; |
| } |
| } |
| |
| return $nouvelle_image; |
| } |
| |
| private function estUnChampATraiter($champ) { |
| |
| return strpos($champ, 'traiter') !== false; |
| } |
| |
| private function traiterMotsClesTexte($ligne_image) { |
| |
| $mail_image = $ligne_image['ci_ce_utilisateur']; |
| $retour = $ligne_image['ci_meta_mots_cles']; |
| |
| if (isset($this->tableau_mots_cles[$mail_image])) { |
| |
| $mots_cles_tableau = $this->parserMotsCles($mail_image, $ligne_image['ci_meta_mots_cles'], ','); |
| $retour = join(';',$mots_cles_tableau); |
| $retour = ltrim($retour,';;') ; |
| } |
| |
| return $retour; |
| } |
| |
| private function parserMotsCles($utilisateur, $mot_cles, $separateur = ',') { |
| |
| $tableau_mots_cles = explode($separateur,$mot_cles); |
| $tableau_mots_cles_formates = array(); |
| |
| foreach($tableau_mots_cles as $mot_cle) { |
| |
| $mot_cle = str_replace($separateur.$separateur,'',$mot_cle); |
| $mot_cle = str_replace('null','',$mot_cle); |
| |
| if ($this->estUnIdentifiantMotCle($mot_cle)) { |
| |
| // certains mots clés mal formatés contiennent des virgules |
| if (strpos($mot_cle,',') !== false) { |
| $tab_mot_cle_mal_formate = explode(',',$mot_cle); |
| |
| foreach ($tab_mot_cle_mal_formate as $mot_cle_mal_formate) { |
| if ($this->estUnIdentifiantMotCle($mot_cle_mal_formate)) { |
| $tableau_mots_cles_formates[$mot_cle_mal_formate] = $this->tableau_mots_cles[$utilisateur][$mot_cle_mal_formate]['mot_cle']; |
| } |
| } |
| } else { |
| // on met le mot clé dans sa propre case afin d'éviter |
| // facilement les doublons provoqués par de mauvais formatages |
| $tableau_mots_cles_formates[$mot_cle] = $this->tableau_mots_cles[$utilisateur][$mot_cle]['mot_cle']; |
| } |
| |
| } |
| } |
| |
| return $tableau_mots_cles_formates; |
| } |
| |
| private function estUnIdentifiantMotCle($chaine) { |
| return trim($chaine) != '' && preg_match('/[0-9A-Z]+\.[0-9A-Z]+/i', $chaine) ; |
| } |
| |
| private function traiterIdentifiantUtilisateur($ligne_image) { |
| |
| $mail_image = $ligne_image['ci_ce_utilisateur']; |
| $retour = $mail_image; |
| |
| if (isset($this->tableau_utilisateurs[$mail_image])) { |
| $retour = $this->tableau_utilisateurs[$mail_image]['id']; |
| } |
| |
| return $retour; |
| } |
| |
| private function traiterPrenomUtilisateur($ligne_image) { |
| |
| $mail_image = $ligne_image['ci_ce_utilisateur']; |
| $retour = $mail_image; |
| |
| if (isset($this->tableau_utilisateurs[$mail_image])) { |
| $retour = $this->tableau_utilisateurs[$mail_image]['prenom']; |
| } |
| |
| return $retour; |
| } |
| |
| private function traiterNomUtilisateur($ligne_image) { |
| |
| $mail_image = $ligne_image['ci_ce_utilisateur']; |
| $retour = $mail_image; |
| |
| if (isset($this->tableau_utilisateurs[$mail_image])) { |
| $retour = $this->tableau_utilisateurs[$mail_image]['nom']; |
| } |
| |
| return $retour; |
| } |
| |
| private function decoderTableauMetaDonnees($chaine) { |
| |
| $tableau_valeurs_decodees = array(); |
| |
| if (trim($chaine) != '') { |
| $tableau_meta = explode(self::separateur_champs_metadonnees,$chaine); |
| foreach ($tableau_meta as &$chaine_meta) { |
| |
| $cle_valeur = explode(self::separateur_valeurs_metadonnees, $chaine_meta); |
| if (is_array($cle_valeur) && count($cle_valeur) == 2) { |
| $cle = ltrim($cle_valeur[0],' '); |
| $tableau_valeurs_decodees[$cle] = $cle_valeur[1]; |
| } |
| } |
| } |
| |
| return $tableau_valeurs_decodees; |
| } |
| |
| private function convertirTableauMetadonneesEnXml($tableau) { |
| |
| $xml = ''; |
| |
| /*foreach($tableau as $cle => $valeur) { |
| |
| $cle = str_replace('ci_meta_exif_','',$cle); |
| $cle = str_replace('ci_meta_iptc_','',$cle); |
| $cle = str_replace('ci_meta_','',$cle); |
| $cle = str_replace('_',' ',$cle); |
| $cle = str_replace(' ','',ucwords($cle)); |
| $valeur = str_replace("\0",'',$valeur); |
| $xml .= '<'.$cle.' id="'.$this->id_cle_metadonnees[$cle].'">'.$valeur.'</'.$cle.'>'."\n"; |
| }*/ |
| |
| return $xml; |
| } |
| |
| private function peutUtiliserExifTool() { |
| return file_exists('/usr/bin/exiftool') && is_executable('/usr/bin/exiftool'); |
| } |
| |
| private function decoderMetadonnees($chemin_image) { |
| |
| $res = ''; |
| |
| if($this->peutUtiliserExifTool()) { |
| $res = $this->decoderMetadonneesExifTool($chemin_image); |
| |
| $xml_meta = '<?xml version="1.0" encoding="UTF-8" ?>'; |
| $xml_meta .= '<exif>'; |
| |
| foreach($res['EXIF'] as $prop => $valeur) { |
| $xml_meta .= ' <'.$prop.' id="'.$valeur['id'].'">'.$valeur['valeur'].'</'.$prop.'>'."\n"; |
| } |
| $xml_meta .= '</exif>'."\n"; |
| |
| $xml_meta .= '<iptc>'; |
| foreach($res['IPTC'] as $prop => $valeur) { |
| $xml_meta .= ' <'.$prop.' id="'.$valeur['id'].'">'.$valeur['valeur'].'</'.$prop.'>'."\n"; |
| } |
| $xml_meta .= '</iptc>'."\n"; |
| |
| $xml_meta .= '<xmp>'; |
| foreach($res['XMP'] as $prop => $valeur) { |
| $xml_meta .= ' <'.$prop.' id="'.$valeur['id'].'">'.$valeur['valeur'].'</'.$prop.'>'."\n"; |
| } |
| $xml_meta .= '</xmp>'."\n"; |
| } else { |
| |
| } |
| |
| return $xml_meta; |
| } |
| |
| private function decoderMetadonneesExifTool($chemin_image) { |
| $metadata = array(); |
| $res = exec('/usr/bin/exiftool -g -D '.$chemin_image, $metadata); |
| |
| $metadata_decodees = array(); |
| |
| $categorie = ''; |
| foreach($metadata as &$data) { |
| if($this->estUnSeparateurCategorieExifTool($data)) { |
| $categorie = trim(str_replace('----','',$data)); |
| } else { |
| $data_decodee = $this->parserValeurMetadonneeExifTool($data); |
| $cle_metadonnee = str_replace(' ', '', $data_decodee['cle']); |
| $metadata_decodees[$categorie][$cle_metadonnee] = $data_decodee; |
| $this->id_cle_metadonnees[$cle_metadonnee] = $data_decodee['id']; |
| } |
| } |
| |
| return $metadata_decodees; |
| } |
| |
| private function estUnSeparateurCategorieExifTool($data) { |
| return preg_match('^---- (.)* ----^',$data); |
| } |
| |
| private function parserValeurMetadonneeExifTool($data) { |
| $cle_valeur = explode(':',$data); |
| |
| $valeur = ''; |
| if(count($cle_valeur) == 2) { |
| $valeur = trim($cle_valeur[1]); |
| } |
| |
| $id_cle = explode(' ',trim($cle_valeur[0]),2); |
| |
| $id_cle[1] = str_replace(array('-','/'),'',$id_cle[1]); |
| |
| $cle_id_valeur = array('cle' => $id_cle[1], 'id' => str_replace('-','',$id_cle[0]), 'valeur' => $valeur); |
| return $cle_id_valeur; |
| } |
| |
| private function traiterExif($ligne_image) { |
| |
| $metadonnees_autres = $this->decoderTableauMetaDonnees($ligne_image['ci_meta_exif_autres']); |
| $metadonnees = array_intersect_key($ligne_image, array_flip($this->champs_exifs_non_gardes))+$metadonnees_autres; |
| |
| $xml_meta = '<?xml version="1.0" encoding="UTF-8" ?>'; |
| $xml_meta .= '<exif>'; |
| $xml_meta .= $this->convertirTableauMetadonneesEnXml($metadonnees); |
| $xml_meta .= '</exif>'; |
| |
| return $xml_meta; |
| } |
| |
| private function traiterIptc($ligne_image) { |
| |
| $metadonnees_autres = $this->decoderTableauMetaDonnees($ligne_image['ci_meta_iptc_autres']); |
| $metadonnees = array_intersect_key($ligne_image, array_flip($this->champs_iptc_non_gardes))+$metadonnees_autres; |
| |
| $xml_meta = '<?xml version="1.0" encoding="UTF-8" ?>'; |
| $xml_meta .= '<iptc>'; |
| $xml_meta .= $this->convertirTableauMetadonneesEnXml($metadonnees); |
| $xml_meta .= '</iptc>'; |
| |
| return $xml_meta; |
| } |
| |
| private function traiterXmp($ligne_image) { |
| |
| $chemin = $this->obtenirCheminImageOriginale($ligne_image['ci_id_image']); |
| //$res = $this->decoderMetadonneesExifTool($chemin); |
| $xml = '<?xml version="1.0" encoding="UTF-8" ?>'; |
| $xml .= '<xmp>'; |
| if (isset($res['XMP'])) { |
| foreach ($res['XMP'] as $prop => $valeur) { |
| $xml .= ' <'.$prop.' id="'.$valeur['id'].'">'.$valeur['valeur'].'</'.$prop.'>'."\n"; |
| } |
| } |
| $xml .= '</xmp>'; |
| |
| return $xml; |
| } |
| |
| private function traiterMakernote($ligne_image) { |
| |
| $chemin = $this->obtenirCheminImageOriginale($ligne_image['ci_id_image']); |
| //$res = $this->decoderMetadonneesExifTool($chemin); |
| $xml = '<?xml version="1.0" encoding="UTF-8" ?>'; |
| $xml .= '<makernote>'; |
| if (isset($res['MAKERNOTE'])) { |
| foreach ($res['MAKERNOTE'] as $prop => $valeur) { |
| $xml .= ' <'.$prop.' id="'.$valeur['id'].'">'.$valeur['valeur'].'</'.$prop.'>'."\n"; |
| } |
| } |
| $xml .= '</makernote>'; |
| |
| return ''; |
| } |
| |
| public function obtenirCheminImageOriginale($id_image) { |
| $nom = $this->convertirIdBddVersNomFichier($id_image, 'O'); |
| $dossier = $this->obtenirDossierPourFormat($id_image,'O'); |
| |
| return $dossier.'/'.$nom; |
| } |
| |
| public function convertirIdBddVersNomFichier($id, $format, $extension = 'jpg') { |
| // creation du format original |
| $id_avec_zeros = sprintf('%09s', $id) ; |
| $id_avec_zeros_underscores = wordwrap($id_avec_zeros, 3 , '_', true) ; |
| |
| $nom_fichier = $id_avec_zeros_underscores.'_'.$format.'.'.$extension; |
| |
| return $nom_fichier; |
| } |
| |
| public function obtenirDossierPourFormat($id, $format) { |
| $chemin_base = $this->config['cel']['chemin_images']; |
| |
| $chemin_sur_serveur = $chemin_base; |
| |
| $id = sprintf('%09s', $id); |
| $id = wordwrap($id, 3 , '_', true); |
| |
| list($dossierNiveau1, $dossierNiveau2) = explode('_', $id); |
| |
| $chemin_sur_serveur_final = $chemin_sur_serveur.'/'.$dossierNiveau1.'/'.$dossierNiveau2.'/'.$format; |
| |
| return $chemin_sur_serveur_final; |
| } |
| |
| private $tableau_ids_tags_exif = array('InteropIndex' => '1', |
| 'InteropVersion' => '2', |
| 'ProcessingSoftware' => '11', |
| 'SubfileType' => '254', |
| 'OldSubfileType' => '255', |
| 'ImageWidth' => '256', |
| 'ImageHeight' => '257', |
| 'BitsPerSample' => '258', |
| 'Compression' => '259', |
| 'PhotometricInterpretation' => '262', |
| 'Thresholding' => '263', |
| 'CellWidth' => '264', |
| 'CellLength' => '265', |
| 'FillOrder' => '266', |
| 'DocumentName' => '269', |
| 'ImageDescription' => '270', |
| 'Make' => '271', |
| 'Model' => '272', |
| 'StripOffsets' => '273', |
| 'Orientation' => '274', |
| 'SamplesPerPixel' => '277', |
| 'RowsPerStrip' => '278', |
| 'StripByteCounts' => '279', |
| 'MinSampleValue' => '280', |
| 'MaxSampleValue' => '281', |
| 'XResolution' => '282', |
| 'YResolution' => '283', |
| 'PlanarConfiguration' => '284', |
| 'PageName' => '285', |
| 'XPosition' => '286', |
| 'YPosition' => '287', |
| 'FreeOffsets' => '288', |
| 'FreeByteCounts' => '289', |
| 'GrayResponseUnit' => '290', |
| 'GrayResponseCurve' => '291', |
| 'T4Options' => '292', |
| 'T6Options' => '293', |
| 'ResolutionUnit' => '296', |
| 'PageNumber' => '297', |
| 'ColorResponseUnit' => '300', |
| 'TransferFunction' => '301', |
| 'Software' => '305', |
| 'ModifyDate' => '306', |
| 'Artist' => '315', |
| 'HostComputer' => '316', |
| 'Predictor' => '317', |
| 'WhitePoint' => '318', |
| 'PrimaryChromaticities' => '319', |
| 'ColorMap' => '320', |
| 'HalftoneHints' => '321', |
| 'TileWidth' => '322', |
| 'TileLength' => '323', |
| 'TileOffsets' => '324', |
| 'TileByteCounts' => '325', |
| 'BadFaxLines' => '326', |
| 'CleanFaxData' => '327', |
| 'ConsecutiveBadFaxLines' => '328', |
| 'SubIFD' => '330', |
| 'InkSet' => '332', |
| 'InkNames' => '333', |
| 'NumberofInks' => '334', |
| 'DotRange' => '336', |
| 'TargetPrinter' => '337', |
| 'ExtraSamples' => '338', |
| 'SampleFormat' => '339', |
| 'SMinSampleValue' => '340', |
| 'SMaxSampleValue' => '341', |
| 'TransferRange' => '342', |
| 'ClipPath' => '343', |
| 'XClipPathUnits' => '344', |
| 'YClipPathUnits' => '345', |
| 'Indexed' => '346', |
| 'JPEGTables' => '347', |
| 'OPIProxy' => '351', |
| 'GlobalParametersIFD' => '400', |
| 'ProfileType' => '401', |
| 'FaxProfile' => '402', |
| 'CodingMethods' => '403', |
| 'VersionYear' => '404', |
| 'ModeNumber' => '405', |
| 'Decode' => '433', |
| 'DefaultImageColor' => '434', |
| 'T82Options' => '435', |
| 'JPEGTables' => '437', |
| 'JPEGProc' => '512', |
| 'ThumbnailOffset' => '513', |
| 'ThumbnailLength' => '514', |
| 'JPEGRestartInterval' => '515', |
| 'JPEGLosslessPredictors' => '517', |
| 'JPEGPointTransforms' => '518', |
| 'JPEGQTables' => '519', |
| 'JPEGDCTables' => '520', |
| 'JPEGACTables' => '521', |
| 'YCbCrCoefficients' => '529', |
| 'YCbCrSubSampling' => '530', |
| 'YCbCrPositioning' => '531', |
| 'ReferenceBlackWhite' => '532', |
| 'StripRowCounts' => '559', |
| 'ApplicationNotes' => '700', |
| 'USPTOMiscellaneous' => '999', |
| 'RelatedImageFileFormat' => '4096', |
| 'RelatedImageWidth' => '4097', |
| 'RelatedImageHeight' => '4098', |
| 'Rating' => '18246', |
| 'XP_DIP_XML' => '18247', |
| 'StitchInfo' => '18248', |
| 'RatingPercent' => '18249', |
| 'ImageID' => '32781', |
| 'WangTag1' => '32931', |
| 'WangAnnotation' => '32932', |
| 'WangTag3' => '32933', |
| 'WangTag4' => '32934', |
| 'Matteing' => '32995', |
| 'DataType' => '32996', |
| 'ImageDepth' => '32997', |
| 'TileDepth' => '32998', |
| 'Model2' => '33405', |
| 'CFARepeatPatternDim' => '33421', |
| 'CFAPattern2' => '33422', |
| 'BatteryLevel' => '33423', |
| 'KodakIFD' => '33424', |
| 'Copyright' => '33432', |
| 'ExposureTime' => '33434', |
| 'FNumber' => '33437', |
| 'MDFileTag' => '33445', |
| 'MDScalePixel' => '33446', |
| 'MDColorTable' => '33447', |
| 'MDLabName' => '33448', |
| 'MDSampleInfo' => '33449', |
| 'MDPrepDate' => '33450', |
| 'MDPrepTime' => '33451', |
| 'MDFileUnits' => '33452', |
| 'PixelScale' => '33550', |
| 'AdventScale' => '33589', |
| 'AdventRevision' => '33590', |
| 'UIC1Tag' => '33628', |
| 'UIC2Tag' => '33629', |
| 'UIC3Tag' => '33630', |
| 'UIC4Tag' => '33631', |
| 'IPTC-NAA' => '33723', |
| 'IntergraphPacketData' => '33918', |
| 'IntergraphFlagRegisters' => '33919', |
| 'IntergraphMatrix' => '33920', |
| 'INGRReserved' => '33921', |
| 'ModelTiePoint' => '33922', |
| 'Site' => '34016', |
| 'ColorSequence' => '34017', |
| 'IT8Header' => '34018', |
| 'RasterPadding' => '34019', |
| 'BitsPerRunLength' => '34020', |
| 'BitsPerExtendedRunLength' => '34021', |
| 'ColorTable' => '34022', |
| 'ImageColorIndicator' => '34023', |
| 'BackgroundColorIndicator' => '34024', |
| 'ImageColorValue' => '34025', |
| 'BackgroundColorValue' => '34026', |
| 'PixelIntensityRange' => '34027', |
| 'TransparencyIndicator' => '34028', |
| 'ColorCharacterization' => '34029', |
| 'HCUsage' => '34030', |
| 'TrapIndicator' => '34031', |
| 'CMYKEquivalent' => '34032', |
| 'SEMInfo' => '34118', |
| 'AFCP_IPTC' => '34152', |
| 'PixelMagicJBIGOptions' => '34232', |
| 'ModelTransform' => '34264', |
| 'WB_GRGBLevels' => '34306', |
| 'LeafData' => '34310', |
| 'PhotoshopSettings' => '34377', |
| 'ExifOffset' => '34665', |
| 'ICC_Profile' => '34675', |
| 'TIFF_FXExtensions' => '34687', |
| 'MultiProfiles' => '34688', |
| 'SharedData' => '34689', |
| 'T88Options' => '34690', |
| 'ImageLayer' => '34732', |
| 'GeoTiffDirectory' => '34735', |
| 'GeoTiffDoubleParams' => '34736', |
| 'GeoTiffAsciiParams' => '34737', |
| 'ExposureProgram' => '34850', |
| 'SpectralSensitivity' => '34852', |
| 'GPSInfo' => '34853', |
| 'ISO' => '34855', |
| 'Opto-ElectricConvFactor' => '34856', |
| 'Interlace' => '34857', |
| 'TimeZoneOffset' => '34858', |
| 'SelfTimerMode' => '34859', |
| 'SensitivityType' => '34864', |
| 'StandardOutputSensitivity' => '34865', |
| 'RecommendedExposureIndex' => '34866', |
| 'ISOSpeed' => '34867', |
| 'ISOSpeedLatitudeyyy' => '34868', |
| 'ISOSpeedLatitudezzz' => '34869', |
| 'FaxRecvParams' => '34908', |
| 'FaxSubAddress' => '34909', |
| 'FaxRecvTime' => '34910', |
| 'LeafSubIFD' => '34954', |
| 'ExifVersion' => '36864', |
| 'DateTimeOriginal' => '36867', |
| 'CreateDate' => '36868', |
| 'ComponentsConfiguration' => '37121', |
| 'CompressedBitsPerPixel' => '37122', |
| 'ShutterSpeedValue' => '37377', |
| 'ApertureValue' => '37378', |
| 'BrightnessValue' => '37379', |
| 'ExposureCompensation' => '37380', |
| 'MaxApertureValue' => '37381', |
| 'SubjectDistance' => '37382', |
| 'MeteringMode' => '37383', |
| 'LightSource' => '37384', |
| 'Flash' => '37385', |
| 'FocalLength' => '37386', |
| 'FlashEnergy' => '37387', |
| 'SpatialFrequencyResponse' => '37388', |
| 'Noise' => '37389', |
| 'FocalPlaneXResolution' => '37390', |
| 'FocalPlaneYResolution' => '37391', |
| 'FocalPlaneResolutionUnit' => '37392', |
| 'ImageNumber' => '37393', |
| 'SecurityClassification' => '37394', |
| 'ImageHistory' => '37395', |
| 'SubjectArea' => '37396', |
| 'ExposureIndex' => '37397', |
| 'TIFF-EPStandardID' => '37398', |
| 'SensingMethod' => '37399', |
| 'CIP3DataFile' => '37434', |
| 'CIP3Sheet' => '37435', |
| 'CIP3Side' => '37436', |
| 'StoNits' => '37439', |
| 'MakerNoteCanon' => '37500', |
| 'UserComment' => '37510', |
| 'SubSecTime' => '37520', |
| 'SubSecTimeOriginal' => '37521', |
| 'SubSecTimeDigitized' => '37522', |
| 'MSDocumentText' => '37679', |
| 'MSPropertySetStorage' => '37680', |
| 'MSDocumentTextPosition' => '37681', |
| 'ImageSourceData' => '37724', |
| 'XPTitle' => '40091', |
| 'XPComment' => '40092', |
| 'XPAuthor' => '40093', |
| 'XPKeywords' => '40094', |
| 'XPSubject' => '40095', |
| 'FlashpixVersion' => '40960', |
| 'ColorSpace' => '40961', |
| 'ExifImageWidth' => '40962', |
| 'ExifImageHeight' => '40963', |
| 'RelatedSoundFile' => '40964', |
| 'InteropOffset' => '40965', |
| 'FlashEnergy' => '41483', |
| 'SpatialFrequencyResponse' => '41484', |
| 'Noise' => '41485', |
| 'FocalPlaneXResolution' => '41486', |
| 'FocalPlaneYResolution' => '41487', |
| 'FocalPlaneResolutionUnit' => '41488', |
| 'ImageNumber' => '41489', |
| 'SecurityClassification' => '41490', |
| 'ImageHistory' => '41491', |
| 'SubjectLocation' => '41492', |
| 'ExposureIndex' => '41493', |
| 'TIFF-EPStandardID' => '41494', |
| 'SensingMethod' => '41495', |
| 'FileSource' => '41728', |
| 'SceneType' => '41729', |
| 'CFAPattern' => '41730', |
| 'CustomRendered' => '41985', |
| 'ExposureMode' => '41986', |
| 'WhiteBalance' => '41987', |
| 'DigitalZoomRatio' => '41988', |
| 'FocalLengthIn35mmFormat' => '41989', |
| 'SceneCaptureType' => '41990', |
| 'GainControl' => '41991', |
| 'Contrast' => '41992', |
| 'Saturation' => '41993', |
| 'Sharpness' => '41994', |
| 'DeviceSettingDescription' => '41995', |
| 'SubjectDistanceRange' => '41996', |
| 'ImageUniqueID' => '42016', |
| 'OwnerName' => '42032', |
| 'SerialNumber' => '42033', |
| 'LensInfo' => '42034', |
| 'LensMake' => '42035', |
| 'LensModel' => '42036', |
| 'LensSerialNumber' => '42037', |
| 'GDALMetadata' => '42112', |
| 'GDALNoData' => '42113', |
| 'Gamma' => '42240', |
| 'ExpandSoftware' => '44992', |
| 'ExpandLens' => '44993', |
| 'ExpandFilm' => '44994', |
| 'ExpandFilterLens' => '44995', |
| 'ExpandScanner' => '44996', |
| 'ExpandFlashLamp' => '44997', |
| 'PixelFormat' => '48129', |
| 'Transformation' => '48130', |
| 'Uncompressed' => '48131', |
| 'ImageType' => '48132', |
| 'ImageWidth' => '48256', |
| 'ImageHeight' => '48257', |
| 'WidthResolution' => '48258', |
| 'HeightResolution' => '48259', |
| 'ImageOffset' => '48320', |
| 'ImageByteCount' => '48321', |
| 'AlphaOffset' => '48322', |
| 'AlphaByteCount' => '48323', |
| 'ImageDataDiscard' => '48324', |
| 'AlphaDataDiscard' => '48325', |
| 'OceScanjobDesc' => '50215', |
| 'OceApplicationSelector' => '50216', |
| 'OceIDNumber' => '50217', |
| 'OceImageLogic' => '50218', |
| 'Annotations' => '50255', |
| 'PrintIM' => '50341', |
| 'USPTOOriginalContentType' => '50560', |
| 'DNGVersion' => '50706', |
| 'DNGBackwardVersion' => '50707', |
| 'UniqueCameraModel' => '50708', |
| 'LocalizedCameraModel' => '50709', |
| 'CFAPlaneColor' => '50710', |
| 'CFALayout' => '50711', |
| 'LinearizationTable' => '50712', |
| 'BlackLevelRepeatDim' => '50713', |
| 'BlackLevel' => '50714', |
| 'BlackLevelDeltaH' => '50715', |
| 'BlackLevelDeltaV' => '50716', |
| 'WhiteLevel' => '50717', |
| 'DefaultScale' => '50718', |
| 'DefaultCropOrigin' => '50719', |
| 'DefaultCropSize' => '50720', |
| 'ColorMatrix1' => '50721', |
| 'ColorMatrix2' => '50722', |
| 'CameraCalibration1' => '50723', |
| 'CameraCalibration2' => '50724', |
| 'ReductionMatrix1' => '50725', |
| 'ReductionMatrix2' => '50726', |
| 'AnalogBalance' => '50727', |
| 'AsShotNeutral' => '50728', |
| 'AsShotWhiteXY' => '50729', |
| 'BaselineExposure' => '50730', |
| 'BaselineNoise' => '50731', |
| 'BaselineSharpness' => '50732', |
| 'BayerGreenSplit' => '50733', |
| 'LinearResponseLimit' => '50734', |
| 'CameraSerialNumber' => '50735', |
| 'DNGLensInfo' => '50736', |
| 'ChromaBlurRadius' => '50737', |
| 'AntiAliasStrength' => '50738', |
| 'ShadowScale' => '50739', |
| 'SR2Private' => '50740', |
| 'MakerNoteSafety' => '50741', |
| 'RawImageSegmentation' => '50752', |
| 'CalibrationIlluminant1' => '50778', |
| 'CalibrationIlluminant2' => '50779', |
| 'BestQualityScale' => '50780', |
| 'RawDataUniqueID' => '50781', |
| 'AliasLayerMetadata' => '50784', |
| 'OriginalRawFileName' => '50827', |
| 'OriginalRawFileData' => '50828', |
| 'ActiveArea' => '50829', |
| 'MaskedAreas' => '50830', |
| 'AsShotICCProfile' => '50831', |
| 'AsShotPreProfileMatrix' => '50832', |
| 'CurrentICCProfile' => '50833', |
| 'CurrentPreProfileMatrix' => '50834', |
| 'ColorimetricReference' => '50879', |
| 'PanasonicTitle' => '50898', |
| 'PanasonicTitle2' => '50899', |
| 'CameraCalibrationSig' => '50931', |
| 'ProfileCalibrationSig' => '50932', |
| 'ProfileIFD' => '50933', |
| 'AsShotProfileName' => '50934', |
| 'NoiseReductionApplied' => '50935', |
| 'ProfileName' => '50936', |
| 'ProfileHueSatMapDims' => '50937', |
| 'ProfileHueSatMapData1' => '50938', |
| 'ProfileHueSatMapData2' => '50939', |
| 'ProfileToneCurve' => '50940', |
| 'ProfileEmbedPolicy' => '50941', |
| 'ProfileCopyright' => '50942', |
| 'ForwardMatrix1' => '50964', |
| 'ForwardMatrix2' => '50965', |
| 'PreviewApplicationName' => '50966', |
| 'PreviewApplicationVersion' => '50967', |
| 'PreviewSettingsName' => '50968', |
| 'PreviewSettingsDigest' => '50969', |
| 'PreviewColorSpace' => '50970', |
| 'PreviewDateTime' => '50971', |
| 'RawImageDigest' => '50972', |
| 'OriginalRawFileDigest' => '50973', |
| 'SubTileBlockSize' => '50974', |
| 'RowInterleaveFactor' => '50975', |
| 'ProfileLookTableDims' => '50981', |
| 'ProfileLookTableData' => '50982', |
| 'OpcodeList1' => '51008', |
| 'OpcodeList2' => '51009', |
| 'OpcodeList3' => '51022', |
| 'NoiseProfile' => '51041', |
| 'Padding' => '59932', |
| 'OffsetSchema' => '59933', |
| 'OwnerName' => '65000', |
| 'SerialNumber' => '65001', |
| 'Lens' => '65002', |
| 'KDC_IFD' => '65024', |
| 'RawFile' => '65100', |
| 'Converter' => '65101', |
| 'WhiteBalance' => '65102', |
| 'Exposure' => '65105', |
| 'Shadows' => '65106', |
| 'Brightness' => '65107', |
| 'Contrast' => '65108', |
| 'Saturation' => '65109', |
| 'Sharpness' => '65110', |
| 'Smoothness' => '65111', |
| 'MoireFilter' => '65112', |
| ); |
| |
| private $tableau_ids_tags_iptc = array('ApplicationRecordVersion' => '0', |
| 'ObjectTypeReference' => '3', |
| 'ObjectAttributeReference' => '4', |
| 'ObjectName' => '5', |
| 'EditStatus' => '7', |
| 'EditorialUpdate' => '8', |
| 'Urgency' => '16', |
| 'SubjectReference' => '18', |
| 'Category' => '21', |
| 'SupplementalCategories' => '32', |
| 'FixtureIdentifier' => '34', |
| 'Keywords' => '37', |
| 'ContentLocationCode' => '38', |
| 'ContentLocationName' => '39', |
| 'ReleaseDate' => '48', |
| 'ReleaseTime' => '53', |
| 'ExpirationDate' => '55', |
| 'ExpirationTime' => '56', |
| 'SpecialInstructions' => '64', |
| 'ActionAdvised' => '66', |
| 'ReferenceService' => '69', |
| 'ReferenceDate' => '71', |
| 'ReferenceNumber' => '80', |
| 'DateCreated' => '85', |
| 'TimeCreated' => '96', |
| 'DigitalCreationDate' => '98', |
| 'DigitalCreationTime' => '99', |
| 'OriginatingProgram' => '101', |
| 'ProgramVersion' => '112', |
| 'ObjectCycle' => '117', |
| 'By-line' => '128', |
| 'By-lineTitle' => '133', |
| 'City' => '144', |
| 'Sub-location' => '146', |
| 'Province-State' => '149', |
| 'Country-PrimaryLocationCode' => '256', |
| 'Country-PrimaryLocationName' => '257', |
| 'OriginalTransmissionReference' => '259', |
| 'Headline' => '261', |
| 'Credit' => '272', |
| 'Source' => '277', |
| 'CopyrightNotice' => '278', |
| 'Contact' => '280', |
| 'Caption-Abstract' => '288', |
| 'LocalCaption' => '289', |
| 'Writer-Editor' => '290', |
| 'RasterizedCaption' => '293', |
| 'ImageType' => '304', |
| 'ImageOrientation' => '305', |
| 'LanguageIdentifier' => '309', |
| 'AudioType' => '336', |
| 'AudioSamplingRate' => '337', |
| 'AudioSamplingResolution' => '338', |
| 'AudioDuration' => '339', |
| 'AudioOutcue' => '340', |
| 'JobID' => '388', |
| 'MasterDocumentID' => '389', |
| 'ShortDocumentID' => '390', |
| 'UniqueDocumentID' => '391', |
| 'OwnerID' => '392', |
| 'ObjectPreviewFileFormat' => '512', |
| 'ObjectPreviewFileVersion' => '513', |
| 'ObjectPreviewData' => '514', |
| 'Prefs' => '545', |
| 'ClassifyState' => '549', |
| 'SimilarityIndex' => '552', |
| 'DocumentNotes' => '560', |
| 'DocumentHistory' => '561', |
| 'ExifCameraInfo' => '562', |
| 'CatalogSets' => '597', |
| ); |
| } |