| 44,7 → 44,7 |
|---|
| unset($criteres['dir']); |
| |
| $debut = ($debut < 0) ? 0 : $debut; |
| $requete_recherche_images = 'SELECT * '; |
| $requete_recherche_images = 'SELECT ci.* '; |
| |
| if ($this->doitJoindreTableObs($criteres)) { |
| $requete_recherche_images .= $this->fabriquerRequeteJointureObs(); |
| 105,12 → 105,12 |
|---|
| |
| private function fabriquerRequeteJointureObs() { |
| |
| $requete_jointure_observations = 'FROM cel_obs_images coi '. |
| 'INNER JOIN cel_obs co '. |
| $requete_jointure_observations = 'FROM cel_images ci '. |
| 'LEFT JOIN cel_obs_images coi '. |
| 'ON coi.id_image = ci.id_image '. |
| 'LEFT JOIN cel_obs co '. |
| 'ON coi.id_observation = co.id_observation '. |
| 'INNER JOIN cel_images ci '. |
| 'ON coi.id_image = ci.id_image '. |
| 'WHERE co.ce_utilisateur = ci.ce_utilisateur '; |
| 'WHERE 1 '; |
| |
| return $requete_jointure_observations; |
| } |