302,13 → 302,30 |
' ON (coi.coi_ce_image = ci.ci_id_image) '. |
' LEFT JOIN cel_inventory AS co '. |
' ON (coi.coi_ce_observation = co.ordre AND coi.coi_ce_utilisateur = co.identifiant) '. |
'WHERE co.transmission = 1 '. |
" AND co.num_nom_ret IN ($numNomListe) ". |
'GROUP BY id_img '. |
$this->formerRequeteConditions($numNomListe). |
' GROUP BY id_img '. |
$this->formerRequeteOrdre(). |
"LIMIT $depart,$limite "; |
|
$this->infosImages = $this->Bdd->recupererTous($requete); |
} |
|
private function formerRequeteConditions($numNomListe) { |
$where[] = " co.transmission = 1 AND co.num_nom_ret IN ($numNomListe) "; |
if (isset($this->parametres['retour.tri']) && $this->parametres['retour.tri'] == 'date') { |
$where[] = ' ci.ci_meta_date != "0000-00-00"'; |
} |
return ' WHERE '.implode(' AND ', $where); |
} |
|
private function formerRequeteOrdre() { |
$order = ""; |
if (isset($this->parametres['retour.tri']) && $this->parametres['retour.tri'] == 'date') { |
$order = ' ORDER BY ci.ci_meta_date ASC '; |
} |
return $order; |
} |
|
|
private function chargerNbreImagesTotal() { |
$requete = 'SELECT FOUND_ROWS() AS nbre '; |