Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 2010 Rev 2143
Line 120... Line 120...
120 
					$this->construireWhereProjet().
 120 
					$this->construireWhereProjet().
121 
					$this->construireWhereTag().
 121 
					$this->construireWhereTag().
122 
					$this->construireWhereNombreDeJours().
 122 
					$this->construireWhereNombreDeJours().
123 
					' GROUP BY id_coord';
 123 
					' GROUP BY id_coord';
Line 124... Line 124...
124
124 
 
125 
		$resultats_emplacements = Cel::db()->executerRequete($requete);
 125 
		$resultats_emplacements = Cel::db()->requeter($requete);
126 
		$emplacements = $this->traiterEmplacements($resultats_emplacements, $this->compterObservations($params));
 126 
		$emplacements = $this->traiterEmplacements($resultats_emplacements, $this->compterObservations($params));
127 
		return $emplacements;
 127 
		return $emplacements;
Line 128... Line 128...
128 
	}
 128 
	}
Line 156... Line 156...
156 
					$this->construireWherePhotosSeulement().
 156 
					$this->construireWherePhotosSeulement().
157 
					$this->construireWhereProjet().
 157 
					$this->construireWhereProjet().
158 
					$this->construireWhereTag().
 158 
					$this->construireWhereTag().
159 
					$this->construireWhereNombreDeJours();
 159 
					$this->construireWhereNombreDeJours();
Line 160... Line 160...
160 
 
 160 
 
161 
		$resultats_nb_obs = Cel::db()->executerRequete($requete);
 161 
		$resultats_nb_obs = Cel::db()->requeter($requete);
162 
		return $resultats_nb_obs[0]['nb'];
 162 
		return $resultats_nb_obs[0]['nb'];
Line 163... Line 163...
163 
	}
 163 
	}
164 
 
 164 
 
Line 752... Line 752...
752 
			$this->construireWhereProjet().
 752 
			$this->construireWhereProjet().
753 
			$this->construireWhereTag().
 753 
			$this->construireWhereTag().
754 
			'ORDER BY utilisateur ASC, ordre ASC';
 754 
			'ORDER BY utilisateur ASC, ordre ASC';
755 
		//$this->debug[] = $requete;
 755 
		//$this->debug[] = $requete;
756 
		//die($requete);
 756 
		//die($requete);
757 
		$resultats = Cel::db()->executerRequete($requete);
 757 
		$resultats = Cel::db()->requeter($requete);
Line 758... Line 758...
758 
 
 758 
 
759 
		$observations = null;
 759 
		$observations = null;
760 
		if ($resultats != false) {
 760 
		if ($resultats != false) {
761 
			$observations = array();
 761 
			$observations = array();
Line 1061... Line 1061...
1061 
						$this->construireWhereProjet().
 1061 
						$this->construireWhereProjet().
1062 
						(!$this->etreNull($tag_sql) ? "AND ($tag_sql) " : '').
 1062 
						(!$this->etreNull($tag_sql) ? "AND ($tag_sql) " : '').
1063 
						'ORDER BY utilisateur ASC, ci.ordre ASC';
 1063 
						'ORDER BY utilisateur ASC, ci.ordre ASC';
1064 
			//$this->debug[] = $requete;
 1064 
			//$this->debug[] = $requete;
1065 
			//die($requete);
 1065 
			//die($requete);
1066 
			$elements_tag = Cel::db()->executerRequete($requete);
 1066 
			$elements_tag = Cel::db()->requeter($requete);
Line 1067... Line 1067...
1067
1067 
 
1068 
			$requete_tag = array();
 1068 
			$requete_tag = array();
Line 1069... Line 1069...
1069 
			if ($elements_tag != false && count($elements_tag) > 0) {
 1069 
			if ($elements_tag != false && count($elements_tag) > 0) {