Subversion Repositories eFlore/Applications.coel

Compare Revisions

No changes between revisions

Ignore whitespace Rev 1836 → Rev 1837

/trunk/jrest/services/CoelExport.php
120,16 → 120,18
 
// Construction de la requête
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
' cs_id_structure, '.
' cs_id_structure, cs_nom, cs_description, cs_adresse_01, cs_code_postal, cs_ville, cs_courriel, '.
' cs_truk_telephone, cs_truk_url,'.
' SUM(csap_bota_travail_hebdo_tps) AS personnel_heure_nbre, '.
' cs_nom, csc_truk_stockage_parametre, csv_mark_visite_avec_motif '.
' csc_truk_stockage_parametre, cmlv_nom, csv_mark_visite_avec_motif '.
'FROM coel_structure '.
' LEFT JOIN coel_structure_a_personne ON (cs_id_structure = csap_id_structure) '.
' LEFT JOIN coel_structure_conservation ON (cs_id_structure = csc_id_structure) '.
' LEFT JOIN coel_structure_valorisation ON (cs_id_structure = csv_id_structure) '.
' LEFT JOIN coel_meta_liste_valeur on `cmlv_id_valeur` =`cs_ce_truk_type_public`'.
'GROUP BY cs_id_structure '.
'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cs_nom ASC').' ';
$message_echec = "La requête a retourné aucun résultat.";
$message_echec = "La requête n'a retourné aucun résultat.";
$structures = $this->executerRequete($requete, $message_echec);
 
// Construction de la requête
139,7 → 141,7
'FROM coel_structure '.
' LEFT JOIN coel_collection ON (cs_id_structure = cc_ce_structure) '.
'GROUP BY cs_id_structure ';
$message_echec = "La requête comptant le nombre de collection a retourné aucun résultat.";
$message_echec = "La requête comptant le nombre de collections n'a retourné aucun résultat.";
$collections_nbre = $this->executerRequete($requete, $message_echec);
 
// Récupération des métadonnées nécessaires
166,6 → 168,14
foreach ($structures as $structure) {
$id_structure = $structure['cs_id_structure'];
$nom = $structure['cs_nom'];
$description = $structure['cs_description'];
$adresse_01 = $structure['cs_adresse_01'];
$code_postal = $structure['cs_code_postal'];
$ville = $structure['cs_ville'];
$telephone = $utilTruck->construireTxtListeOntologie($structure['cs_truk_telephone']);
$courriel = $structure['cs_courriel'];
$type = $structure['cmlv_nom'];
$url = $utilTruck->construireTxtListeOntologie($structure['cs_truk_url']);
$stockage_params = $utilTruck->construireTxtListeOntologie($structure['csc_truk_stockage_parametre']);
$stockage_params_nbre = $utilTruck->getNbreValeur($structure['csc_truk_stockage_parametre']);
$stockage_params_nbre = empty($stockage_params_nbre) ? 0 : $stockage_params_nbre;
176,6 → 186,14
 
$structure_affichage = array(
'nom' => $nom,
'description' => $description,
'adresse' => $adresse_01,
'code_postal' => $code_postal,
'ville' => $ville,
'telephone' => $telephone,
'courriel' => $courriel,
'url' => $url,
'type' => $type,
'stockage_params' => $stockage_params,
'stockage_params_nbre' => $stockage_params_nbre,
'collection_nbre' => $collection_nbre,
/trunk/jrest/services/squelettes/export_structure_expertise.tpl.csv
1,4 → 1,4
"id","nom","stockage_parametres","stockage_parametres_nbre","collection_nbre","personnel_nbre_heure_cumulees","visite_avec_motif_science"
"id","nom","description","adresse","code_postal","ville","telephone","courriel","url","type","stockage_parametres","stockage_parametres_nbre","collection_nbre","personnel_nbre_heure_cumulees","visite_avec_motif_science"
<?php foreach ($structures as $id => $structure) : ?>
"<?=$id?>","<?=$structure['nom']?>","<?=$structure['stockage_params']?>","<?=$structure['stockage_params_nbre']?>","<?=$structure['collection_nbre']?>","<?=$structure['personnel_heure_nbre']?>","<?=$structure['visite_avec_motif_science']?>"
"<?=$id?>","<?=$structure['nom']?>","<?=$structure['description']?>","<?=$structure['adresse']?>","<?=$structure['code_postal']?>","<?=$structure['ville']?>","<?=$structure['telephone']?>","<?=$structure['courriel']?>","<?=$structure['url']?>","<?=$structure['type']?>","<?=$structure['stockage_params']?>","<?=$structure['stockage_params_nbre']?>","<?=$structure['collection_nbre']?>","<?=$structure['personnel_heure_nbre']?>","<?=$structure['visite_avec_motif_science']?>"
<?php endforeach; ?>
/trunk/.
Property changes:
Modified: svn:mergeinfo
Merged /branches/v1.6-muscardin:r1836