Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 813 → Rev 814

/trunk/jrest/services/CelSyndicationObservation.php
206,8 → 206,8
private function getServiceParDefaut() {
// Construction de la requête
$requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' * '.
'FROM cel_inventory '.
(($this->etreFluxAdmin()) ? '' : 'WHERE transmission = 1 ').
'FROM cel_inventory WHERE identifiant like "%@%" '.
(($this->etreFluxAdmin()) ? '' : 'AND transmission = 1 ').
'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'date_modification DESC').' '.
"LIMIT $this->start,$this->limit ";
262,8 → 262,7
// Construction de la requête
$requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' * '.
'FROM cel_inventory '.
'WHERE transmission = 1 '.
' AND ';
'WHERE identifiant like "%@%" AND '.(($this->etreFluxAdmin()) ? '' : ' transmission = 1 AND ');
if ($this->estUneRechercheGenerale()) {
$chaine_requete = $_GET['recherche'];
275,7 → 274,7
}
}
$requete = rtrim($requete, 'AND ');
$requete .= 'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby :
$requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby :
'date_modification DESC, location ASC').' '.
"LIMIT $this->start,$this->limit ";