152,12 → 152,15 |
return $observateur; |
} |
|
|
|
/** |
* Retrouver les derniers votes image |
* */ |
private function getDerniersVotesImage() { |
$clauseWhere = $this->chargerClauseWhere(); |
$requete = 'SELECT DISTINCT id_vote, ce_image, valeur, divo.date AS date_vote, '. |
$idsVotes = $this->getIdsDerniersVotesImage(); |
$idsVotesConcat = implode(', ', $idsVotes); |
$requete = 'SELECT id_vote, ce_image, valeur, divo.date AS date_vote, '. |
' duo.prenom AS observateur_prenom, duo.nom AS observateur_nom, '. |
' duv.prenom AS votant_prenom, duv.nom AS votant_nom, '. |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, dip.intitule '. |
173,15 → 176,36 |
' LEFT JOIN del_utilisateur AS duv '. |
' ON if((CHAR_LENGTH(divo.ce_utilisateur) <> 32),CAST(divo.ce_utilisateur AS unsigned),0) '. |
' = duv.id_utilisateur '. |
($clauseWhere != '' ? "WHERE $clauseWhere " : ''). |
"WHERE id_vote IN ($idsVotesConcat) ". |
'ORDER BY divo.date DESC '. |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite(). |
' -- '.__FILE__.' : '.__LINE__; |
|
$elements = $this->bdd->recupererTous($requete); |
return $elements; |
} |
|
/** |
* Retrouver les ids des derniers votes image |
* */ |
private function getIdsDerniersVotesImage() { |
$clauseWhere = $this->chargerClauseWhere(); |
$requete = 'SELECT DISTINCT id_vote '. |
'FROM del_image_vote '. |
($clauseWhere != '' ? "WHERE $clauseWhere " : ''). |
'ORDER BY date DESC '. |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite(). |
' -- '.__FILE__.' : '.__LINE__; |
$resultats = $this->bdd->recupererTous($requete); |
|
$idsVotes = array(); |
if ($resultats != false && is_array($idsVotes)) { |
foreach ($resultats as $infos) { |
$idsVotes[] = $infos['id_vote']; |
} |
} |
return $idsVotes; |
} |
|
private function chargerClauseWhere() { |
$where = array(); |
$filtres = $this->navigation->getFiltre(); |