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