| 167,8 → 167,9 |
|---|
| * Retrouver les derniers votes image |
| * */ |
| private function getDerniersVotesImage() { |
| $clauseWhere = $this->chargerClauseWhere(); |
| $requete = 'SELECT DISTINCT id_tag, tag, date, '. |
| $idsTags = $this->getIdsDerniersVotesImage(); |
| $idsTagsConcat = implode(', ', $idsTags); |
| $requete = 'SELECT id_tag, tag, date, '. |
| ' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, di.id_image, '. |
| ' duo.prenom AS auteur_prenom, duo.nom AS auteur_nom, duo.courriel AS auteur_courriel, '. |
| ' du.prenom AS tagueur_prenom, du.nom AS tagueur_nom, du.courriel AS tagueur_courriel '. |
| 183,7 → 184,7 |
|---|
| ' ON if((CHAR_LENGTH(dit.ce_utilisateur) <> 32),CAST(dit.ce_utilisateur AS unsigned),0) '. |
| ' = du.id_utilisateur '. |
| 'WHERE actif = 1 '. |
| ($clauseWhere != '' ? "AND $clauseWhere " : ''). |
| " AND id_tag IN ($idsTagsConcat) ". |
| 'ORDER BY date DESC '. |
| 'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '. |
| ' -- '.__FILE__.' : '.__LINE__; |
| 191,20 → 192,18 |
|---|
| return $elements; |
| } |
| |
| private function chargerClauseWhere() { |
| $where = array(); |
| $filtres = $this->navigation->getFiltre(); |
| if (!empty($filtres)) { |
| $filtrePossibles = $this->conteneur->getParametreTableau('syndication.tag_filtres'); |
| foreach ($filtres as $cleFiltre => $valeur) { |
| if (in_array($cleFiltre, $filtrePossibles)) { |
| $champ = $this->mapping[$cleFiltre]; |
| $valeurP = $this->bdd->proteger($valeur); |
| $where[] = " $champ = $valeurP "; |
| } |
| } |
| } |
| |
| return (!empty($where)) ? implode('AND', $where) : ''; |
| /** |
| * Retrouver les ids des derniers votes image |
| * */ |
| private function getIdsDerniersVotesImage() { |
| $requete = 'SELECT DISTINCT id_tag '. |
| 'FROM del_image_tag '. |
| 'WHERE actif = 1 '. |
| // Pas de filtre pour ce service. Utiliser le principe des autres ws de syndication si on devait en rajouter. |
| 'ORDER BY date DESC '. |
| 'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '. |
| ' -- '.__FILE__.' : '.__LINE__; |
| $elements = $this->bdd->recupererTous($requete); |
| return $elements; |
| } |
| } |