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