14,7 → 14,7 |
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 |
private $format = null; |
private $service = null; |
private $squelette = null; |
168,6 → 168,7 |
|
// 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) { |
179,6 → 180,7 |
$id_structure = $structure['cs_id_structure']; |
$nom = addcslashes($structure['cs_nom'], '"'); |
$stockage_params = implode(' ; ', $export_stockage_parametres); |
$stockage_params_nbre = count($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']; |
186,6 → 188,7 |
$donnees['structures'][$id_structure] = array( |
'nom' => $nom, |
'stockage_params' => $stockage_params, |
'stockage_params_nbre' => $stockage_params_nbre, |
'collection_nbre' => $collection_nbre, |
'personnel_heure_nbre' => $personnel_heure_nbre); |
} |
196,6 → 199,79 |
return $contenu; |
} |
|
private function getServiceCollectionExpertise() { |
$donnees = array(); |
$projet_id = $this->parametres['projet']; |
|
// Construction de la requête |
$requete = 'SELECT '.(($this->distinct) ? 'SELECT 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, '. |
' ccb_truk_unite_base, ccb_ce_etat_general, ccb_truk_etiquette_fixation_support, '. |
' ccb_truk_etiquette_fixation_specimen, ccb_truk_degradation_presentation, '. |
' ccb_ce_classement_etat, ccb_ce_inventaire '. |
'FROM coel_collection '. |
' LEFT JOIN coel_collection_botanique ON (cc_id_collection = ccb_id_collection) '. |
' LEFT JOIN coel_structure ON (cs_id_structure = cc_ce_structure) '. |
( is_null($projet_id) ? '' : "WHERE cc_ce_projet = $projet_id "). |
'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); |
|
// Récupération des métadonnées nécessaires |
$requete = 'SELECT cmlv_id_valeur, cmlv_ce_parent, cmlv_nom, cmlv_abreviation '. |
'FROM coel_meta_liste_valeur '. |
'WHERE cmlv_ce_parent IN ('.self::META_LISTES_EXPERTISE_COLLECTION.') '; |
$message_echec = "La requête de recherche des métadonnées a retourné aucun résultat."; |
$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']); |
} |
|
// 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, '"'); |
} |
|
$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); |
} |
} |
|
// Création du contenu |
$contenu = $this->executerService($donnees); |
return $contenu; |
} |
|
private function executerRequete($requete, $message_echec) { |
try { |
$infos = $this->bdd->query($requete)->fetchAll(PDO::FETCH_ASSOC); |