Line 127... |
Line 127... |
127 |
'FROM coel_structure '.
|
127 |
'FROM coel_structure '.
|
128 |
' LEFT JOIN coel_structure_a_personne ON (cs_id_structure = csap_id_structure) '.
|
128 |
' LEFT JOIN coel_structure_a_personne ON (cs_id_structure = csap_id_structure) '.
|
129 |
' LEFT JOIN coel_structure_conservation ON (cs_id_structure = csc_id_structure) '.
|
129 |
' LEFT JOIN coel_structure_conservation ON (cs_id_structure = csc_id_structure) '.
|
130 |
( is_null($projet_id) ? '' : "WHERE cs_ce_projet = $projet_id ").
|
130 |
( is_null($projet_id) ? '' : "WHERE cs_ce_projet = $projet_id ").
|
131 |
'GROUP BY cs_id_structure '.
|
131 |
'GROUP BY cs_id_structure '.
|
132 |
'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cs_nom ASC').' '.
|
132 |
'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cs_nom ASC').' ';
|
133 |
((!is_null($this->start) && !is_null($this->limit)) ? "LIMIT $this->start,$this->limit " : '');
|
- |
|
134 |
$message_echec = "La requête a retourné aucun résultat.";
|
133 |
$message_echec = "La requête a retourné aucun résultat.";
|
135 |
$structures = $this->executerRequete($requete, $message_echec);
|
134 |
$structures = $this->executerRequete($requete, $message_echec);
|
Line 136... |
Line 135... |
136 |
|
135 |
|
137 |
// Construction de la requête
|
136 |
// Construction de la requête
|
Line 206... |
Line 205... |
206 |
' ccb_ce_classement_etat, ccb_ce_inventaire '.
|
205 |
' ccb_ce_classement_etat, ccb_ce_inventaire '.
|
207 |
'FROM coel_collection '.
|
206 |
'FROM coel_collection '.
|
208 |
' LEFT JOIN coel_collection_botanique ON (cc_id_collection = ccb_id_collection) '.
|
207 |
' LEFT JOIN coel_collection_botanique ON (cc_id_collection = ccb_id_collection) '.
|
209 |
' LEFT JOIN coel_structure ON (cs_id_structure = cc_ce_structure) '.
|
208 |
' LEFT JOIN coel_structure ON (cs_id_structure = cc_ce_structure) '.
|
210 |
( is_null($projet_id) ? '' : "WHERE cc_ce_projet = $projet_id ").
|
209 |
( is_null($projet_id) ? '' : "WHERE cc_ce_projet = $projet_id ").
|
211 |
'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cc_nom ASC').' '.
|
210 |
'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cc_nom ASC').' ';
|
212 |
((!is_null($this->start) && !is_null($this->limit)) ? "LIMIT $this->start,$this->limit " : '');
|
- |
|
213 |
$message_echec = "La requête a retourné aucun résultat.";
|
211 |
$message_echec = "La requête a retourné aucun résultat.";
|
214 |
$collections = $this->executerRequete($requete, $message_echec);
|
212 |
$collections = $this->executerRequete($requete, $message_echec);
|
Line 215... |
Line 213... |
215 |
|
213 |
|
216 |
// Récupération des métadonnées nécessaires
|
214 |
// Récupération des métadonnées nécessaires
|