| Line 207... |
Line 207... |
| 207 |
private function chargerLiaisons() {
|
207 |
private function chargerLiaisons() {
|
| Line 208... |
Line 208... |
| 208 |
|
208 |
|
| 209 |
$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS * '.
|
209 |
$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS * '.
|
| 210 |
'FROM '.$this->gestionBdd->formaterTable('del_obs_images', 'doi').
|
210 |
'FROM '.$this->gestionBdd->formaterTable('del_obs_images', 'doi').
|
| 211 |
'INNER JOIN del_image di '.
|
211 |
'INNER JOIN del_image di '.
|
| 212 |
'ON doi.ce_image = di.id_image '.
|
212 |
'ON doi.id_image = di.id_image '.
|
| 213 |
'INNER JOIN del_observation dob '.
|
213 |
'INNER JOIN del_observation dob '.
|
| 214 |
'ON doi.ce_observation = dob.id_observation '.
|
214 |
'ON doi.id_observation = dob.id_observation '.
|
| 215 |
'INNER JOIN del_utilisateur du '.
|
215 |
'INNER JOIN del_utilisateur du '.
|
| 216 |
'ON du.id_utilisateur = doi.ce_utilisateur';
|
216 |
'ON du.id_utilisateur = doi.id_utilisateur';
|
| - |
|
217 |
$requeteLiaisons .= $this->chargerClauseWhere();
|
| 217 |
$requeteLiaisons .= $this->chargerClauseWhere();
|
218 |
$requeteLiaisons .= ' ORDER BY date_transmission DESC';
|
| - |
|
219 |
$requeteLiaisons .= $this->gestionBdd->getLimitSql();
|
| 218 |
$requeteLiaisons .= $this->gestionBdd->getLimitSql();
|
220 |
|
| 219 |
return $this->bdd->recupererTous($requeteLiaisons);
|
221 |
return $this->bdd->recupererTous($requeteLiaisons);
|
| Line 220... |
Line 222... |
| 220 |
}
|
222 |
}
|
| 221 |
|
223 |
|
| Line 234... |
Line 236... |
| 234 |
* */
|
236 |
* */
|
| 235 |
private function chargerImage($liaisons) {
|
237 |
private function chargerImage($liaisons) {
|
| Line 236... |
Line 238... |
| 236 |
|
238 |
|
| 237 |
$images = array();
|
239 |
$images = array();
|
| 238 |
foreach ($liaisons as $liaison) {
|
240 |
foreach ($liaisons as $liaison) {
|
| Line 239... |
Line 241... |
| 239 |
$idImage = $liaison['ce_image'];
|
241 |
$idImage = $liaison['id_image'];
|
| 240 |
|
242 |
|
| 241 |
// On enregistre l'ID de l'image pour n'effectuer qu'une seule requête par la suite
|
- |
|
| 242 |
$this->imageIds[] = $idImage;
|
243 |
// On enregistre l'ID de l'image pour n'effectuer qu'une seule requête par la suite
|
| 243 |
|
244 |
$this->imageIds[] = $idImage;
|
| 244 |
$images[$idImage] = array('id_image' => $idImage, 'date' => $liaison['date_prise_de_vue'], 'binaire.href' => $this->formaterLienImage($idImage),
|
245 |
$images[$idImage] = array('id_image' => $idImage, 'date' => $liaison['date_prise_de_vue'], 'binaire.href' => $this->formaterLienImage($idImage),
|
| 245 |
'hauteur' => $liaison['hauteur'], 'largeur' => $liaison['largeur'], 'votes' => array(), 'observation' => $this->formaterObservation($liaison));
|
246 |
'hauteur' => $liaison['hauteur'], 'largeur' => $liaison['largeur'], 'votes' => array(), 'observation' => $this->formaterObservation($liaison));
|
| 246 |
}
|
247 |
}
|
| Line 254... |
Line 255... |
| 254 |
|
255 |
|
| 255 |
if (sizeof($this->imageIds) > 0) {
|
256 |
if (sizeof($this->imageIds) > 0) {
|
| Line 256... |
Line 257... |
| 256 |
$chaineImageIds = implode(',', $this->imageIds);
|
257 |
$chaineImageIds = implode(',', $this->imageIds);
|
| 257 |
|
258 |
|
| 258 |
$requeteVotes = 'SELECT * FROM '.
|
259 |
$requeteVotes = 'SELECT * FROM '.
|
| 259 |
$this->gestionBdd->formaterTable('del_vote_image ').
|
260 |
$this->gestionBdd->formaterTable('del_image_vote').
|
| Line 260... |
Line 261... |
| 260 |
'WHERE ce_image IN ('.$chaineImageIds.')';
|
261 |
'WHERE ce_image IN ('.$chaineImageIds.')';
|