Subversion Repositories eFlore/Applications.coel

Compare Revisions

Ignore whitespace Rev 1536 → Rev 1537

/trunk/jrest/services/CoelExport.php
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;
}
}