Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 1269 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1269 Rev 1289
Line 229... Line 229...
229 
	private function obtenirIdImageAuHasard() {
 229 
    private function obtenirIdImageAuHasard() {
230 
		$refTax = $this->parametres['referentiel'];
 230 
        $refTax = $this->parametres['referentiel'];
231 
		$numNom = $this->Bdd->proteger($this->ref_tax_demande[$refTax][0]);
 231 
        $numNom = $this->Bdd->proteger($this->ref_tax_demande[$refTax][0]);
Line 232... Line 232...
232 
 
 232
233 
		$requete = 'SELECT  ci.id_image AS id_image '.
 233 
        $requete = 'SELECT  ci.id_image AS id_image '.
234 
			'FROM cel_images AS ci '.
 234 
            'FROM cel_images_export AS ci '.
235 
			'	LEFT JOIN cel_obs AS co '.
 235 
            '	LEFT JOIN cel_export AS co '.
236 
					'ON (ci.ce_observation = co.id_observation) '.
 236 
            'ON (ci.ce_observation = co.id_observation) '.
237 
			'WHERE co.transmission = 1 '.
 237 
            'WHERE '.
238 
			"	AND co.nom_ret_nn IN ($numNom)";
 238 
            "	co.nom_ret_nn IN ($numNom)";
Line 239... Line 239...
239 
			"	AND co.nom_referentiel = ".$this->Bdd->proteger($refTax) . ' -- ' . __FILE__ . ':' . __LINE__;
 239 
        "	AND co.nom_referentiel = ".$this->Bdd->proteger($refTax) . ' -- ' . __FILE__ . ':' . __LINE__;
Line 240... Line 240...
240 
 
 240
Line 252... Line 252...
252 
 
 252
253 
	private function obtenirIdPremiereImage() {
 253 
    private function obtenirIdPremiereImage() {
254 
		$refTax = $this->parametres['referentiel'];
 254 
        $refTax = $this->parametres['referentiel'];
255 
		$numNom = $this->Bdd->proteger($this->ref_tax_demande[$refTax][0]);
 255 
        $numNom = $this->Bdd->proteger($this->ref_tax_demande[$refTax][0]);
256 
		$requete = 	'SELECT ci.id_image AS id_image '.
 256 
        $requete = 	'SELECT ci.id_image AS id_image '.
257 
					'FROM cel_images AS ci'.
 257 
            'FROM cel_images_export AS ci'.
258 
					'	LEFT JOIN cel_obs AS co '.
 258 
            '	LEFT JOIN cel_export AS co '.
259 
					'		ON (ci.ce_observation = co.id_observation) '.
 259 
            '		ON (ci.ce_observation = co.id_observation) '.
260 
					'WHERE co.transmission = 1 '.
 260 
            'WHERE '.
261 
					"	AND co.nom_ret_nn IN ($numNom) ".
 261 
            "	co.nom_ret_nn IN ($numNom) ".
262 
					'	AND ci.date_prise_de_vue != "0000-00-00" '.
 262 
            '	AND ci.date_prise_de_vue != "0000-00-00" '.
263 
					'	AND co.nom_referentiel LIKE '.$this->Bdd->proteger($refTax.'%').' '.
 263 
            '	AND co.nom_referentiel LIKE '.$this->Bdd->proteger($refTax.'%').' '.
264 
					'	ORDER BY ci.date_prise_de_vue ASC '.
 264 
            '	ORDER BY ci.date_prise_de_vue ASC '.
Line 278... Line 278...
278 
 
 278
279 
	private function chargerInfosImage() {
 279 
    private function chargerInfosImage() {
280 
		$requete = 	'SELECT SQL_CALC_FOUND_ROWS '.
 280 
        $requete = 	'SELECT SQL_CALC_FOUND_ROWS '.
281 
				'	ci.id_image AS id_img, co.date_observation AS date, '.
 281 
            '	ci.id_image AS id_img, co.date_observation AS date, '.
282 
				'	co.id_observation AS id_obs, '.
 282 
            '	co.id_observation AS id_obs, '.
283 
				'	ci.courriel_utilisateur AS utilisateur_courriel, '.
 283 
            '	co.courriel_utilisateur AS utilisateur_courriel, '.
284 
				'	nom_sel, nom_sel_nn, '.
 284 
            '	nom_sel, nom_sel_nn, '.
285 
				'	zone_geo, ce_zone_geo, lieudit, station, milieu '.
 285 
            '	zone_geo, ce_zone_geo, lieudit, station, milieu '.
286 
				'FROM cel_images AS ci'.
 286 
            'FROM cel_images_export AS ci'.
287 
				'	LEFT JOIN cel_obs AS co '.
 287 
            '	LEFT JOIN cel_export AS co '.
288 
				'		ON (ci.ce_observation = co.id_observation) '.
 288 
            '		ON (ci.ce_observation = co.id_observation) '.
289 
				'WHERE ci.id_image = '.$this->ressources[0].
 289 
            'WHERE ci.id_image = '.$this->ressources[0].
Line 290... Line 290...
290 
				' AND co.id_observation IS NOT NULL' . ' -- ' . __FILE__ . ':' . __LINE__;
 290 
            ' AND co.id_observation IS NOT NULL' . ' -- ' . __FILE__ . ':' . __LINE__;
Line 303... Line 303...
303 
		$requete = 	'SELECT SQL_CALC_FOUND_ROWS '.
 303 
        $requete = 	'SELECT SQL_CALC_FOUND_ROWS '.
304 
			'	co.id_observation AS id_obs, co.courriel_utilisateur AS utilisateur_courriel, co.zone_geo, co.ce_zone_geo, '.
 304 
        '	co.id_observation AS id_obs, co.courriel_utilisateur AS utilisateur_courriel, co.zone_geo, co.ce_zone_geo, '.
305 
			'	co.nom_sel, co.nom_sel_nn, '.
 305 
        '	co.nom_sel, co.nom_sel_nn, '.
306 
			'	ci.id_image AS id_img, co.date_observation AS date '.
 306 
        '	ci.id_image AS id_img, co.date_observation AS date '.
307 
			(isset($this->parametres['retour.champs']) ? ', '.$this->parametres['retour.champs'] : '').
 307 
        (isset($this->parametres['retour.champs']) ? ', '.$this->parametres['retour.champs'] : '').
308 
			'FROM cel_images AS ci'.
 308 
        'FROM cel_images_export AS ci'.
309 
			'	LEFT JOIN cel_obs AS co '.
 309 
        '	LEFT JOIN cel_export AS co '.
310 
			'		ON (ci.ce_observation = co.id_observation) '.
 310 
        '		ON (ci.ce_observation = co.id_observation) '.
311 
			$this->formerRequeteConditions($numNomListe).' '.
 311 
        $this->formerRequeteConditions($numNomListe).' '.
312 
			'GROUP BY id_img '.
 312 
        'GROUP BY id_img '.
313 
			$this->formerRequeteTri().
 313 
        $this->formerRequeteTri().
314 
			"LIMIT $depart,$limite " . ' -- ' . __FILE__ . ':' . __LINE__;
 314 
        "LIMIT $depart,$limite " . ' -- ' . __FILE__ . ':' . __LINE__;
Line 316... Line 316...
316 
		$this->infosImages = $this->Bdd->recupererTous($requete);
 316 
        $this->infosImages = $this->Bdd->recupererTous($requete);
317 
	}
 317 
    }
Line 318... Line 318...
318 
 
 318
319 
	private function formerRequeteConditions($numNomListe) {
 319 
    private function formerRequeteConditions($numNomListe) {
320 
		$refTax = $this->parametres['referentiel'];
 320 
        $refTax = $this->parametres['referentiel'];
321 
		$where[] = " co.transmission = 1 AND co.nom_ret_nn IN ($numNomListe) ";
 321 
        $where[] = "  co.nom_ret_nn IN ($numNomListe) ";
322 
		// exclusion des noms à déterminer, douteux ou plantnet-mobile
 322 
        // exclusion des noms à déterminer, douteux ou plantnet-mobile
323 
		$where[] = " ((co.mots_cles_texte not like '%aDeterminer%' AND co.mots_cles_texte not like '%plantnet-mobile%') OR co.mots_cles_texte IS null) ";
 - 
 
324 
		$where[] = " (co.certitude not in ('aDeterminer', 'douteux', 'douteuse') OR certitude IS NULL) ";
 323 
        $where[] = " ((co.mots_cles_texte not like '%aDeterminer%' AND co.mots_cles_texte not like '%plantnet-mobile%') OR co.mots_cles_texte IS null) ";
Line 325... Line 324...
325 
		$where[] = " co.nom_referentiel LIKE ".$this->Bdd->proteger($refTax."%").' ';
 324 
        $where[] = " co.nom_referentiel LIKE ".$this->Bdd->proteger($refTax."%").' ';
326
325
Line 551... Line 550...
551 
		$nn = substr($this->parametres['masque.nn'], strpos($this->parametres['masque.nn'], ':') + 1);
 550 
        $nn = substr($this->parametres['masque.nn'], strpos($this->parametres['masque.nn'], ':') + 1);
552 
		$referentiel = isset($this->parametres['masque.referentiel']) ? $this->parametres['masque.referentiel'] : '';
 551 
        $referentiel = isset($this->parametres['masque.referentiel']) ? $this->parametres['masque.referentiel'] : '';
553 
		$and = $referentiel ? ' AND referentiel = ' . $this->Bdd->proteger($referentiel) : '';
 552 
        $and = $referentiel ? ' AND referentiel = ' . $this->Bdd->proteger($referentiel) : '';
Line 554... Line 553...
554 
 
 553
555 
		$requete =  'SELECT referentiel, ce_image as id_img, organe '.
 554 
        $requete =  'SELECT referentiel, ce_image as id_img, organe '.
556 
			'FROM tb_del.del_image_top '.
 555 
            'FROM tb_del_test.del_image_top '.
Line 557... Line 556...
557 
			'WHERE nn = '. $this->Bdd->proteger($nn) . $and . ' -- ' . __FILE__ . ':' . __LINE__;
 556 
            'WHERE nn = '. $this->Bdd->proteger($nn) . $and . ' -- ' . __FILE__ . ':' . __LINE__;
Line 558... Line 557...
558 
 
 557