129,8 → 129,7 |
' LEFT JOIN coel_structure_conservation ON (cs_id_structure = csc_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').' '. |
((!is_null($this->start) && !is_null($this->limit)) ? "LIMIT $this->start,$this->limit " : ''); |
'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cs_nom ASC').' '; |
$message_echec = "La requête a retourné aucun résultat."; |
$structures = $this->executerRequete($requete, $message_echec); |
|
208,8 → 207,7 |
' 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').' '. |
((!is_null($this->start) && !is_null($this->limit)) ? "LIMIT $this->start,$this->limit " : ''); |
'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); |
|