31,7 → 31,7 |
|
// Pré traitement des paramêtres |
$pour_bdd = false; |
$this->parametres = $this->traiterParametresUrl(array('service', 'format', 'projet'), $params, $pour_bdd); |
$this->parametres = $this->traiterParametresUrl(array('service', 'format'), $params, $pour_bdd); |
|
// Chargement du bon type de service demandé |
if (isset($this->parametres['service'])) { |
117,7 → 117,6 |
|
private function getServiceStructureExpertise() { |
$donnees = array(); |
$projet_id = $this->parametres['projet']; |
|
// Construction de la requête |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '. |
128,7 → 127,6 |
' 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) '. |
( is_null($projet_id) ? '' : "WHERE cs_ce_projet = $projet_id "). |
'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."; |
140,7 → 138,6 |
' COUNT(cc_id_collection) AS collection_nbre '. |
'FROM coel_structure '. |
' LEFT JOIN coel_collection ON (cs_id_structure = cc_ce_structure) '. |
( is_null($projet_id) ? '' : "WHERE cs_ce_projet = $projet_id "). |
'GROUP BY cs_id_structure '; |
$message_echec = "La requête comptant le nombre de collection a retourné aucun résultat."; |
$collections_nbre = $this->executerRequete($requete, $message_echec); |
196,7 → 193,6 |
} |
|
private function getServiceCollectionExpertise() { |
$projet_id = $this->parametres['projet']; |
|
// Construction de la requête |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '. |
210,7 → 206,6 |
'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').' '; |
$message_echec = "La requête a retourné aucun résultat."; |
$collections = $this->executerRequete($requete, $message_echec); |