14,7 → 14,8 |
class CoelExport extends Coel { |
|
const META_LISTE_STOCK_PARAMS = 1020;// Liste des paramètres de contrôle environnemental d'un local |
const META_LISTES_EXPERTISE_COLLECTION = '';// Liste des métadonnées pour les informations des des collections |
const META_LISTES_EXPERTISE_COLLECTION = '1040,1041,1043,1045,1046,1049,1050,1053,1057,1081';// Liste des métadonnées pour les informations des des collections |
|
private $format = null; |
private $service = null; |
private $squelette = null; |
119,7 → 120,7 |
$projet_id = $this->parametres['projet']; |
|
// Construction de la requête |
$requete = 'SELECT '.(($this->distinct) ? 'SELECT DISTINCT' : '').' '. |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '. |
' cs_id_structure, '. |
' SUM(csap_bota_travail_hebdo_tps) AS personnel_heure_nbre, '. |
' cs_nom, csc_truk_stockage_parametre '. |
134,7 → 135,7 |
$structures = $this->executerRequete($requete, $message_echec); |
|
// Construction de la requête |
$requete = 'SELECT '.(($this->distinct) ? 'SELECT DISTINCT' : '').' '. |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '. |
' cs_id_structure, '. |
' COUNT(cc_id_collection) AS collection_nbre '. |
'FROM coel_structure '. |
168,15 → 169,6 |
|
// Traitement final des données concernant les structures |
foreach ($structures as $structure) { |
// Traitement des paramêtres de stockage |
$truk_stockage_parametres = explode(';;', trim($structure['csc_truk_stockage_parametre'], ' ;')); |
$export_stockage_parametres = array(); |
foreach ($truk_stockage_parametres as $param_code) { |
$param_code = preg_replace('/^AUTRE##/', '', trim($param_code)); |
$param_txt = preg_match('/^[0-9]+$/', $param_code) ? $parametres[$param_code]['nom'] : $param_code; |
$export_stockage_parametres[] = addcslashes($param_txt, '"'); |
} |
|
$id_structure = $structure['cs_id_structure']; |
$nom = addcslashes($structure['cs_nom'], '"'); |
$stockage_params = implode(' ; ', $export_stockage_parametres); |
200,11 → 192,10 |
} |
|
private function getServiceCollectionExpertise() { |
$donnees = array(); |
$projet_id = $this->parametres['projet']; |
|
|
// Construction de la requête |
$requete = 'SELECT '.(($this->distinct) ? 'SELECT DISTINCT' : '').' '. |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '. |
' cc_id_collection, '. |
' cc_nom, cs_nom, cc_ce_specimen_type, cc_description, cc_truk_periode_constitution, '. |
' cc_truk_couverture_lieu, ccb_truk_etiquette_renseignement, ccb_truk_nature, '. |
218,7 → 209,7 |
'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cc_nom ASC').' '. |
((!is_null($this->start) && !is_null($this->limit)) ? "LIMIT $this->start,$this->limit " : ''); |
$message_echec = "La requête a retourné aucun résultat."; |
$structures = $this->executerRequete($requete, $message_echec); |
$collections = $this->executerRequete($requete, $message_echec); |
|
// Récupération des métadonnées nécessaires |
$requete = 'SELECT cmlv_id_valeur, cmlv_ce_parent, cmlv_nom, cmlv_abreviation '. |
228,42 → 219,36 |
$metadonnees = $this->executerRequete($requete, $message_echec); |
|
// Traitement des données |
if ($structures !== false) { |
// Traitement des métadonnées |
$parametres = array(0 => array('nom' => 'Non renseigné', 'abr' => 'NR')); |
foreach ($metadonnees as $meta) { |
$parametres[$meta['cmlv_id_valeur']] = array('nom' => $meta['cmlv_nom'], 'abr' => $meta['cmlv_abreviation']); |
} |
$donnees = array(); |
if ($collections !== false) { |
// Instanciation des objets nécessaires aux traitements |
$ontologie = new Ontologie($metadonnees); |
$utilTruck = new UtilTruck($ontologie); |
|
// Traitement du nombre de collection par structure |
$collections_par_structure = array(); |
foreach ($collections_nbre as $collection) { |
$nbre = (empty($collection['collection_nbre'])) ? 0 : $collection['collection_nbre']; |
$collections_par_structure[$collection['cs_id_structure']] = $nbre; |
} |
|
// Traitement final des données concernant les structures |
foreach ($structures as $structure) { |
$truk_stockage_parametres = explode(';;', trim($structure['csc_truk_stockage_parametre'], ' ;')); |
$export_stockage_parametres = array(); |
foreach ($truk_stockage_parametres as $param_code) { |
$param_code = preg_replace('/^AUTRE##/', '', trim($param_code)); |
$param_txt = preg_match('/^[0-9]+$/', $param_code) ? $parametres[$param_code]['nom'] : $param_code; |
$export_stockage_parametres[] = addcslashes($param_txt, '"'); |
} |
foreach ($collections as $collection) { |
$id_collection = $collection['cc_id_collection']; |
$nom = self::nettoyerGuillemets($collection['cc_nom']); |
$nom_structure = self::nettoyerGuillemets($collection['cs_nom']); |
$specimen_type = $utilTruck->construireTxtListeOntologie($collection['cc_ce_specimen_type']); |
$description = self::nettoyerGuillemets($collection['cc_description']); |
$periode_constitution = $utilTruck->construireTxtListeOntologie($collection['cc_truk_periode_constitution']); |
$couverture_lieu = $utilTruck->construireTxtListeOntologie($collection['cc_truk_couverture_lieu']); |
$etiquette_renseignement = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_etiquette_renseignement']); |
$nature = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_nature']); |
$parts_total = $collection['ccb_truk_unite_base']; |
|
$id_structure = $structure['cs_id_structure']; |
$nom = addcslashes($structure['cs_nom'], '"'); |
$stockage_params = implode(' ; ', $export_stockage_parametres); |
$collection_nbre = $collections_par_structure[$structure['cs_id_structure']]; |
$collection_nbre = empty($collection_nbre) ? 0 : $collection_nbre; |
$personnel_heure_nbre = empty($structure['personnel_heure_nbre']) ? 0 : $structure['personnel_heure_nbre']; |
|
$donnees['structures'][$id_structure] = array( |
'nom' => $nom, |
'stockage_params' => $stockage_params, |
'collection_nbre' => $collection_nbre, |
'personnel_heure_nbre' => $personnel_heure_nbre); |
$donnees['collections'][$id_collection] = array( |
'nom' => $nom, |
'nom_structure' => $nom_structure, |
'specimen_type' => $specimen_type, |
'description' => $description, |
'periode_constitution' => $periode_constitution, |
'couverture_lieu' => $couverture_lieu, |
'etiquette_renseignement' => $etiquette_renseignement, |
'nature' => $nature, |
'parts_total' => $parts_total |
); |
} |
} |
|
279,7 → 264,7 |
$this->messages[] = $message_echec; |
} |
} catch (PDOException $e) { |
$this->messages[] = sprintf($this->getTxt('sql_erreur'), $e->getFile(), $e->getLine(), $e->getMessage()); |
$this->messages[] = sprintf($this->getTxt('sql_erreur_requete'), $e->getFile(), $e->getLine(), $e->getMessage(), $requete); |
} |
return $infos; |
} |
289,4 → 274,9 |
$contenu = Coel::traiterSquelettePhp($this->squelette, $donnees); |
return $contenu; |
} |
|
private static function nettoyerGuillemets($txt) { |
$txt = preg_replace('/"/', '""', $txt); |
return $txt; |
} |
} |