Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1855 Rev 1871
Line 42... Line 42...
42 
		$this->mappings['commentaires'] = $this->conteneur->getParametreTableau('commentaires.mapping');
 42 
		$this->mappings['commentaires'] = $this->conteneur->getParametreTableau('commentaires.mapping');
43 
	}
 43 
	}
Line 44... Line 44...
44 
 
 44 
 
45 
	public function consulter($ressources, $parametres) {
 45 
	public function consulter($ressources, $parametres) {
- 
 
 46 
		$this->paramsFiltres = $this->filtrage->filtrerUrlParamsAppliObs();
46 
		$this->paramsFiltres = $this->filtrage->filtrerUrlParamsAppliObs();
 47 
		$this->sql->setAppli(Sql::APPLI_OBS);
47 
		$this->sql->setParametres($this->paramsFiltres);
 48 
		$this->sql->setParametres($this->paramsFiltres);
48 
		$this->sql->ajouterContraintes();
 49 
		$this->sql->ajouterContraintes();
49 
		$this->sql->ajouterConstrainteAppliObs();
 50 
		$this->sql->ajouterConstrainteAppliObs();
Line 88... Line 89...
88 
	 * @param req: le tableau représentant les composants de la requete SQL
 89 
	 * @param req: le tableau représentant les composants de la requete SQL
89 
	 * @param db: l'instance de db
 90 
	 * @param db: l'instance de db
90 
	 */
 91 
	 */
91 
	private function getIdObs() {
 92 
	private function getIdObs() {
92 
		$requete = 'SELECT SQL_CALC_FOUND_ROWS id_observation '.
 93 
		$requete = 'SELECT SQL_CALC_FOUND_ROWS id_observation '.
93 
			'FROM v_del_image AS vdi '.
 94 
			'FROM del_observation AS do '.
94 
			$this->sql->getJoin().
 95 
			$this->sql->getJoin().
95 
			'WHERE '.$this->sql->getWhere().
 96 
			'WHERE '.$this->sql->getWhere().
96 
			$this->sql->getGroupBy().
 97 
			$this->sql->getGroupBy().
97 
			$this->sql->getOrderBy().
 98 
			$this->sql->getOrderBy().
98 
			$this->sql->getLimit().
 99 
			$this->sql->getLimit().
99 
			' -- '.__FILE__.':'.__LINE__;
 100 
			' -- '.__FILE__.':'.__LINE__;
100 
 
 - 
 
- 
 
 101 
		//Debug::printr($requete);
101 
		$resultats = $this->bdd->recupererTous($requete);
 102 
		$resultats = $this->bdd->recupererTous($requete);
Line 102... Line 103...
102 
 
 103 
 
103 
		$idObs = array();
 104 
		$idObs = array();
104 
		if ($resultats !== false ) {
 105 
		if ($resultats !== false ) {
Line 116... Line 117...
116 
	private function getInfos($idObs) {
 117 
	private function getInfos($idObs) {
117 
		$idsObsConcat = implode(',', $idObs);
 118 
		$idsObsConcat = implode(',', $idObs);
118 
		$requete = "SELECT id_observation, nom_sel AS `determination.ns`, nt AS `determination.nt`, ".
 119 
		$requete = "SELECT id_observation, nom_sel AS `determination.ns`, nt AS `determination.nt`, ".
119 
			'nom_sel_nn AS `determination.nn`, famille AS `determination.famille`, '.
 120 
			'nom_sel_nn AS `determination.nn`, famille AS `determination.famille`, '.
120 
			'nom_referentiel AS `determination.referentiel`, ce_zone_geo AS id_zone_geo, '.
 121 
			'nom_referentiel AS `determination.referentiel`, ce_zone_geo AS id_zone_geo, '.
121 
			'zone_geo, lieudit, station, milieu, date_observation, mots_cles_texte, '.
 122 
			'zone_geo, lieudit, station, milieu, date_observation, do.mots_cles_texte, '.
122 
			'date_transmission, commentaire, '.
 123 
			'do.date_transmission, do.commentaire, '.
123 
			'ce_utilisateur AS `auteur.id`, prenom_utilisateur AS `auteur.prenom`, '.
 124 
			'do.ce_utilisateur AS `auteur.id`, do.prenom_utilisateur AS `auteur.prenom`, '.
124 
			'nom_utilisateur AS `auteur.nom`, courriel_utilisateur AS `auteur.courriel`, '.
 125 
			'do.nom_utilisateur AS `auteur.nom`, do.courriel_utilisateur AS `auteur.courriel`, '.
125 
			'id_image, date_prise_de_vue AS `date`, hauteur, largeur, nom_original '.
 126 
			'id_image, date_prise_de_vue AS `date`, hauteur, largeur, nom_original '.
126 
			'FROM v_del_image AS vdi '.
 127 
			'FROM del_observation AS do '.
- 
 
 128 
			'	LEFT JOIN del_image AS di ON (do.id_observation = di.ce_observation) '.
127 
			"WHERE id_observation IN ($idsObsConcat) ".
 129 
			"WHERE id_observation IN ($idsObsConcat) ".
128 
			' -- '.__FILE__.':'.__LINE__;
 130 
			' -- '.__FILE__.':'.__LINE__;
129 
		return $this->bdd->recupererTous($requete);
 131 
		return $this->bdd->recupererTous($requete);
130 
	}
 132 
	}
Line 162... Line 164...
162 
	}
 164 
	}
Line 163... Line 165...
163 
 
 165 
 
164 
	private function extraireInfosImage(&$obs) {
 166 
	private function extraireInfosImage(&$obs) {
165 
		$champsImageAffichables = array('id_image', 'date', 'hauteur' , 'largeur', 'nom_original');
 167 
		$champsImageAffichables = array('id_image', 'date', 'hauteur' , 'largeur', 'nom_original');
166 
		$image = array_intersect_key($obs, array_flip($champsImageAffichables));
 - 
 
167 
 
 168 
		$image = array_intersect_key($obs, array_flip($champsImageAffichables));
168 
		$urlImgTpl = $this->conteneur->getParametre('cel_img_url_tpl');
 169 
		$urlImgTpl = $this->conteneur->getParametre('cel_img_url_tpl');
Line 169... Line 170...
169 
		$image['binaire.href'] = sprintf($urlImgTpl, $image['id_image'], 'XL');
 170 
		$image['binaire.href'] = sprintf($urlImgTpl, $image['id_image'], 'XL');
170 
 
 171