Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 3142 Rev 3143
Line 53... Line 53...
53 
		if(isset($criteres['sql_brut']) && !$autoriser_sql_brut) unset($criteres['sql_brut']);
 53 
		if(isset($criteres['sql_brut']) && !$autoriser_sql_brut) unset($criteres['sql_brut']);
54 
		$sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
 54 
		$sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
Line 55... Line 55...
55
55
56 
		$requete_selection_observations .= $sous_requete_recherche;
 56 
		$requete_selection_observations .= $sous_requete_recherche;
57 
		$requete_selection_observations = rtrim($requete_selection_observations, 'AND ');
 - 
 
58 
		$requete_selection_observations .= $id_utilisateur == null ? ' ORDER BY id_observation ' : ' ORDER BY '.$tri.' '.$tri_dir;
 57 
		$requete_selection_observations = rtrim($requete_selection_observations, 'AND ');
Line 59... Line 58...
59 
		$requete_selection_observations .= ($debut == 0 && $limite == 0) ? '' : ' LIMIT '.$debut.','.$limite ;
 58 
		$requete_selection_observations .= ($debut == 0 && $limite == 0) ? '' : ' LIMIT '.$debut.','.$limite ;
60
59
61 
		$this->requete_selection_observations = $requete_selection_observations;
 60 
		$this->requete_selection_observations = $requete_selection_observations;print_r($requete_selection_observations);exit;
Line 62... Line 61...
62 
		return $this;
 61 
		return $this;
63 
	}
 62 
	}
Line 77... Line 76...
77 
		} else if(count($criteres) > 0) {
 76 
		} else if(count($criteres) > 0) {
78 
			$requete .= 'WHERE ';
 77 
			$requete .= 'WHERE ';
79 
		}
 78 
		}
80 
		$requete .= $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
 79 
		$requete .= $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
81 
		$requete = rtrim($requete, 'AND ');
 80 
		$requete = rtrim($requete, 'AND ');
82 
		$resultat = Cel::db()->requeter($requete);//print_r($requete);exit;
 81 
		$resultat = Cel::db()->requeter($requete);print_r($requete);exit;
83 
		$nb_obs = ($resultat && is_array($resultat) && count($resultat) > 0) ? $resultat[0]['nb_obs'] : '0';
 82 
		$nb_obs = ($resultat && is_array($resultat) && count($resultat) > 0) ? $resultat[0]['nb_obs'] : '0';
84 
		return $nb_obs;
 83 
		return $nb_obs;
85 
	}
 84 
	}
Line 86... Line 85...
86
85