Subversion Repositories eFlore/Applications.coel

Compare Revisions

Ignore whitespace Rev 1542 → Rev 1543

/trunk/jrest/services/CoelExport.php
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);