| 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); |