| 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(); |