Subversion Repositories eFlore/Applications.del

Rev

Rev 858 | Rev 923 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 858 Rev 863
Line 51... Line 51...
51 
		// Lancement du service
 51 
		// Lancement du service
52 
		$commentaires = $this->chargerCommentaires();
 52 
		$commentaires = $this->chargerCommentaires();
53 
		$commentaires = $this->formaterCommentaires($commentaires);
 53 
		$commentaires = $this->formaterCommentaires($commentaires);
54 
		$total = $this->compterCommentaires();
 54 
		$total = $this->compterCommentaires();
55 
		$this->navigation->setTotal($total);
 55 
		$this->navigation->setTotal($total);
56 
		/*$images = $this->chargerImage($liaisons);
 - 
 
57 
		$images = $this->chargerVotes($images);
 - 
 
58
56 
 
59 
		// Mettre en forme le résultat et l'envoyer pour affichage*/
 - 
 
60 
		$resultat = new ResultatService();
 57 
		$resultat = new ResultatService();
Line 61... Line 58...
61
58
62 
		$resultat->corps = array('entete' => $this->conteneur->getEntete(), 'resultats' => $commentaires);
 59 
		$resultat->corps = array('entete' => $this->conteneur->getEntete(), 'resultats' => $commentaires);
63 
		return $resultat;
 60 
		return $resultat;
Line 140... Line 137...
140 
						$where[] = ' '.$this->mappingFiltre[$idMasque].' = '.$this->proteger($valeurMasque);
 137 
						$where[] = ' '.$this->mappingFiltre[$idMasque].' = '.$this->proteger($valeurMasque);
141 
					break;
 138 
					break;
142 
				}
 139 
				}
143 
			}
140 
			}
144 
		}
 141 
		}
145
- 
 
146 
		if (!empty($where)) {
 142 
		if (!empty($where)) {
147 
			return ' WHERE '.implode('AND', $where);
 143 
			return ' WHERE '.implode('AND', $where);
148 
		} else {
 144 
		} else {
149 
			return;
 145 
			return;
150 
		}
 146 
		}
Line 158... Line 154...
158 
	* */
 154 
	* */
159 
	private function chargerCommentaires() {
 155 
	private function chargerCommentaires() {
Line 160... Line 156...
160
156
161 
		$requeteLiaisons = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS * '.
 157 
		$requeteLiaisons = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS * '.
- 
 
 158 
						   'FROM '.$this->gestionBdd->formaterTable('del_commentaire', 'dc');
162 
						   'FROM '.$this->gestionBdd->formaterTable('del_commentaire', 'dc');
 159 
		$requeteLiaisons .= $this->chargerClauseWhere();
163 
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
 160 
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
164 
		return $this->bdd->recupererTous($requeteLiaisons);
 161 
		return $this->bdd->recupererTous($requeteLiaisons);
Line 165... Line 162...
165 
	}
 162 
	}