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, |