/** * Fonction permettant d'afficher les images d'un utilisateur, * fonction de debug * * @param array $params Paramètres * * @return string * */ public function afficheImagesFromUtilisateurDebug($params = array()) { $html = ""; $f = new fileObject(); $sqlLimit = 10; if (isset($this->variablesGet['limit']) && $this->variablesGet['limit'] != '') { $sqlLimit = $this->variablesGet['limit']; } $sqlDateDebut = ""; if (isset($this->variablesGet['dateDebut']) && $this->variablesGet['dateDebut'] != '') { $sqlDateDebut = "AND h1.dateUpload>='" . $this->variablesGet['dateDebut'] . "' "; } $sqlIdUtilisateur = ""; if (isset($this->variablesGet['idUtilisateur']) && $this->variablesGet['idUtilisateur'] != '') { $sqlIdUtilisateur = "AND h1.idUtilisateur = '" . $this->variablesGet['idUtilisateur'] . "'"; } $reqImages = "\n SELECT h1.dateUpload as dateUpload, h1.idImage as idImage, h1.idHistoriqueImage as idHistoriqueImage, h1.idUtilisateur as idUtilisateur\n FROM historiqueImage h2, historiqueImage h1\n WHERE 1=1\n {$sqlIdUtilisateur}\n AND h2.idImage = h1.idImage\n {$sqlDateDebut}\n GROUP BY h1.idImage, h1.idHistoriqueImage\n HAVING h1.idHistoriqueImage = max(h2.idHistoriqueImage)\n ORDER BY h1.dateUpload DESC\n LIMIT {$sqlLimit}\n "; $resImages = $this->connexionBdd->requete($reqImages); while ($fetchImages = mysql_fetch_assoc($resImages)) { $html .= "<img src='" . $this->getUrlImage("originaux") . $fetchImages['dateUpload'] . "/" . $fetchImages['idHistoriqueImage'] . ".jpg' alt=''><br><a href='" . $this->creerUrl('', 'imageDetail', array('archiIdImage' => $fetchImages['idImage'])) . "'>" . $fetchImages['idUtilisateur'] . " " . $fetchImages['dateUpload'] . "</a> "; $html .= $f->fileSize($this->getCheminPhysiqueImage("originaux") . $fetchImages['dateUpload'] . "/" . $fetchImages['idHistoriqueImage'] . ".jpg"); $html .= "<br>"; } return $html; }