/**
* 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;
}
