Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 3634 Rev 3743
Line 39... Line 39...
39 
		'date' => 'c.date_prise_de_vue',
 39 
        'date' => 'c.date_prise_de_vue',
40 
		'tag' => 'tag',
 40 
        'tag' => 'tag',
41 
		'motcle' => 'tag',
 41 
        'motcle' => 'tag',
42 
		'projet' => 'projet',
 42 
        'projet' => 'projet',
43 
		'referentiel' => 'referentiel',
 43 
        'referentiel' => 'referentiel',
44 
		'groupe_zones_geo' => 'groupe_zones_geo',
 44 
        'groupe_zones_geo' => 'groupe_zones_geo'
45 
	    'standard' => 'donnees_standard'
 - 
 
46 
	);
 45 
    );
Line 47... Line 46...
47 
 
 46
48 
	/**
 47 
    /**
49 
	 * Méthode appelée avec une requête de type GET.
 48 
     * Méthode appelée avec une requête de type GET.
Line 340... Line 339...
340 
 
 339
341 
		// Construction de la requête
 340 
        // Construction de la requête
342 
		$requete = 	(isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' co.*, '.
 341 
        $requete = 	(isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' co.*, '.
343 
			' ci.id_image, co.ce_utilisateur, nom_original, ci.date_creation, ci.mots_cles_texte AS mots_cles_texte_images, '.
 342 
            ' ci.id_image, co.ce_utilisateur, nom_original, ci.date_creation, ci.mots_cles_texte AS mots_cles_texte_images, '.
344 
			' co.mots_cles_texte AS mots_cles_texte_images_obs, "" as commentaire, "" as note_qualite, nom_referentiel '.
 343 
            ' co.mots_cles_texte AS mots_cles_texte_images_obs, "" as commentaire, "" as note_qualite, nom_referentiel '.
345 
			'FROM cel_export_total AS co LEFT JOIN cel_images_export AS ci ON (co.id_observation = ci.ce_observation) '.
 344 
            'FROM cel_export_total AS co JOIN cel_images_export AS ci ON (co.id_observation = ci.ce_observation) '.
346 
			'WHERE co.transmission = 1 '.
 345 
            'WHERE co.transmission = 1 '.
347 
			'	AND co.ce_utilisateur = ci.ce_utilisateur '.
 346 
            '	AND co.ce_utilisateur = ci.ce_utilisateur '.
348 
			'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'ci.date_creation DESC').' '.
 347 
            'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'ci.date_creation DESC').' '.
Line 381... Line 380...
381 
		$requete = 	(isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' co.*, '.
 380 
        $requete = 	(isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' co.*, '.
382 
			'	ci.id_image, co.ce_utilisateur, nom_original, ci.date_creation, ci.mots_cles_texte AS mots_cles_texte_images, '.
 381 
            '	ci.id_image, co.ce_utilisateur, nom_original, ci.date_creation, ci.mots_cles_texte AS mots_cles_texte_images, '.
383 
			'	co.mots_cles_texte AS mots_cles_texte_obs, ci.commentaire AS commentaire_img, note_qualite, nom_referentiel, '.
 382 
            '	co.mots_cles_texte AS mots_cles_texte_obs, ci.commentaire AS commentaire_img, note_qualite, nom_referentiel, '.
384 
			'	co.commentaire AS commentaire_obs '.
 383 
            '	co.commentaire AS commentaire_obs '.
385 
			'FROM cel_images_export AS ci '.
 384 
            'FROM cel_images_export AS ci '.
386 
			'	LEFT JOIN cel_export_total AS co '.
 385 
            '	JOIN cel_export AS co '.
387 
			'		ON (ci.ce_observation = co.id_observation) '.
 386 
            '		ON (ci.ce_observation = co.id_observation) '.
388 
			(($this->etreFluxAdmin()) ? '' : 'WHERE co.transmission = 1 ').
 387 
            (($this->etreFluxAdmin()) ? '' : 'WHERE co.transmission = 1 ').
389 
			'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'ci.date_creation DESC').' '.
 388 
            'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'ci.date_creation DESC').' '.
390 
			"LIMIT $this->start, $this->limit ";
 389 
            "LIMIT $this->start, $this->limit ";
391 
		//echo $requete;
 390 
            //echo $requete;
Line 436... Line 435...
436 
	private function creerRequeteSansParametres() {
 435 
    private function creerRequeteSansParametres() {
437 
		// Construction de la requête
 436 
        // Construction de la requête
438 
		$requete = 'SELECT *, b.mots_cles_texte AS mots_cles_texte_obs, c.mots_cles_texte AS mots_cles_texte_images, '.
 437 
        $requete = 'SELECT *, b.mots_cles_texte AS mots_cles_texte_obs, c.mots_cles_texte AS mots_cles_texte_images, '.
439 
			' b.commentaire AS commentaire_obs, "" AS commentaire_img, nom_referentiel '.
 438 
            ' b.commentaire AS commentaire_obs, "" AS commentaire_img, nom_referentiel '.
440 
			'FROM cel_images_export c '.
 439 
            'FROM cel_images_export c '.
441 
			'	left JOIN cel_export AS b '.
 440 
            '	JOIN cel_export AS b '.
442 
			'		ON (c.ce_observation = b.id_observation) ';
 441 
            '		ON (c.ce_observation = b.id_observation) ';
443 
		$requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'c.date_creation DESC').' '.
 442 
        $requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'c.date_creation DESC').' '.
444 
				"LIMIT $this->start,$this->limit ";
 443 
            "LIMIT $this->start,$this->limit ";
445 
		//echo $requete;
 444 
        //echo $requete;
446 
		return $requete;
 445 
        return $requete;
Line 449... Line 448...
449 
	private function creerRequeteAvecParametres() {
 448 
    private function creerRequeteAvecParametres() {
450 
		// Construction de la requête
 449 
        // Construction de la requête
451 
		$requete = 'SELECT *, b.mots_cles_texte as mots_cles_texte_obs, c.mots_cles_texte as mots_cles_texte_images, '.
 450 
        $requete = 'SELECT *, b.mots_cles_texte as mots_cles_texte_obs, c.mots_cles_texte as mots_cles_texte_images, '.
452 
		    ' b.commentaire as commentaire_obs, "" as commentaire_img, nom_referentiel '.
 451 
            ' b.commentaire as commentaire_obs, "" as commentaire_img, nom_referentiel '.
453 
			'FROM cel_images_export AS c '.
 452 
            'FROM cel_images_export AS c '.
454 
			'	INNER JOIN cel_export_total AS b '.
 453 
            '	JOIN cel_export_total AS b '.
455 
			'		ON (c.ce_observation = b.id_observation) '.
 454 
            '		ON (c.ce_observation = b.id_observation) '.
456 
			'WHERE donnees_standard = 1'.
 455 
            'WHERE '.
457 
			(($this->etreFluxAdmin()) ? '' : ' AND b.transmission = 1 ').
 456 
            (($this->etreFluxAdmin()) ? '' : ' b.transmission = 1 ').
458 
			'	AND ';
 457 
            '	AND ';
Line 459... Line 458...
459 
 
 458
460 
		if ($this->estUneRechercheGenerale()) {
 459 
            if ($this->estUneRechercheGenerale()) {
461 
			$chaine_requete = $_GET['recherche'];
 460 
                $chaine_requete = $_GET['recherche'];
462 
			$requete .= $this->creerSousRequeteRechercheGenerale($chaine_requete);
 461 
                $requete .= "donnees_standard =  1 AND ".$this->creerSousRequeteRechercheGenerale($chaine_requete);
463 
		} else {
 462 
            } else {
- 
 
 463 
                $criteres = $this->traiterCriteresMultiples($_GET) ;
- 
 
 464 
                if (!isset($_GET["standard"])) {
- 
 
 465 
                    $requete .= "donnees_standard =  1 AND ";
- 
 
 466 
                } elseif ($_GET["standard"] = 1) {
- 
 
 467 
                    $requete .= "donnees_standard =  1 AND ";
464 
			$criteres = $this->traiterCriteresMultiples($_GET) ;
 468 
                }
465 
			if (!empty($criteres)) {
 469 
                if (!empty($criteres)) {
466 
				$requete .= $this->creerSousRequeteRechercheParCriteres($criteres);
 470 
                    $requete .= $this->creerSousRequeteRechercheParCriteres($criteres);
467 
			}
 471 
                }
468 
		}
 472 
            }