Subversion Repositories eFlore/Applications.del

							' INNER JOIN del_image di ON doi.id_image = di.id_image '.

							' INNER JOIN del_image di ON doi.id_image = di.id_image '.

							' ORDER BY date_observation '.$ordre.', dob.id_observation '.$ordre;

							' ORDER BY date_observation '.$ordre.', dob.id_observation '.$ordre;

			$requeteIdObs .= $this->gestionBdd->getLimitSql();

			$requeteIdObs .= $this->gestionBdd->getLimitSql();

			$observations = $this->bdd->recupererTous($requeteIdObs);

			$observations = $this->bdd->recupererTous($requeteIdObs . ' -- ' . __FILE__ . ':' . __LINE__);

			$idsImages = array();

			$idsImages = array();

			foreach ($observations as $observation) {

			foreach ($observations as $observation) {

			$requeteImages .= ' GROUP BY doi.id_image, doi.id_observation ';

			$requeteImages .= ' GROUP BY doi.id_image, doi.id_observation ';

			$requeteImages .= ' ORDER BY doi.id_observation DESC';

			$requeteImages .= ' ORDER BY doi.id_observation DESC';

			$requeteImages .= $this->gestionBdd->getLimitSql();

			$requeteImages .= $this->gestionBdd->getLimitSql();

		}

		}

		$liaisons = $this->bdd->recupererTous($requeteImages);

		$liaisons = $this->bdd->recupererTous($requeteImages . ' -- ' . __FILE__ . ':' . __LINE__);

		// Ce n'est pas la peine de continuer s'il n'y a pas eu de résultats dans la table del_obs_images

		// Ce n'est pas la peine de continuer s'il n'y a pas eu de résultats dans la table del_obs_images

			$requeteObservations = ' SELECT * '.

			$requeteObservations = ' SELECT * '.

								   ' FROM del_observation dob '.

								   ' FROM del_observation dob '.

								   ' LEFT JOIN del_utilisateur du ON dob.ce_utilisateur = du.id_utilisateur '.

								   ' LEFT JOIN del_utilisateur du ON dob.ce_utilisateur = du.id_utilisateur '.

								   ' WHERE id_observation IN ('.$chaineIdObs.')';

								   ' WHERE id_observation IN ('.$chaineIdObs.')';

			$resultatsObservations = $this->bdd->recupererTous($requeteObservations);

			$resultatsObservations = $this->bdd->recupererTous($requeteObservations . ' -- ' . __FILE__ . ':' . __LINE__);

			// FIXME : Ca ne doit pas arriver, mais que se passe-t-il s'il n'y a pas d'observation pour l'image ?! 

			// FIXME : Ca ne doit pas arriver, mais que se passe-t-il s'il n'y a pas d'observation pour l'image ?! 

			$requeteNbImages = 'SELECT SUM(t.nb) as nb FROM (SELECT count(DISTINCT doi.id_image) as nb '.

			$requeteNbImages = 'SELECT SUM(t.nb) as nb FROM (SELECT count(DISTINCT doi.id_image) as nb '.

							   'FROM del_obs_image doi '.

							   'FROM del_obs_image doi '.

							   'INNER JOIN del_image di '.

							   'INNER JOIN del_image di '.

							   'ON di.id_image = doi.id_image '.

							   'ON di.id_image = doi.id_image '.

							   'GROUP BY doi.id_image, doi.id_observation) t ';

							   'GROUP BY doi.id_image, doi.id_observation) t ';

			$total = (int) $resultatNbImages[0]['nb'];

			$total = (int) $resultatNbImages[0]['nb'];

			$this->navigation->setTotal($total);

			$this->navigation->setTotal($total);

			$tri = ' ORDER BY '.$this->parametres['tri'].' '.$ordre.', doi.id_observation '.$ordre.' ';

			$tri = ' ORDER BY '.$this->parametres['tri'].' '.$ordre.', doi.id_observation '.$ordre.' ';

			$requeteObs .= $tri;

			$requeteObs .= $tri;

		}

		}

		$observations = $this->bdd->recupererTous($requeteObs);

		$observations = $this->bdd->recupererTous($requeteObs . ' -- ' . __FILE__ . ':' . __LINE__);

		$total = $this->getFoundRows();

		$total = $this->getFoundRows();

				$requeteVotes .= ' GROUP BY doi.id_image, doi.id_observation '.

				$requeteVotes .= ' GROUP BY doi.id_image, doi.id_observation '.

								 ' ORDER by total_votes '.$this->directionTri .', doi.id_observation '.$this->directionTri.' '.

								 ' ORDER by total_votes '.$this->directionTri .', doi.id_observation '.$this->directionTri.' '.

						$this->gestionBdd->getLimitSql();

						$this->gestionBdd->getLimitSql();

				$resultatsVotes = $this->bdd->recupererTous($requeteVotes);

				$resultatsVotes = $this->bdd->recupererTous($requeteVotes . ' -- ' . __FILE__ . ':' . __LINE__);

				$tabVotes = array();

				$tabVotes = array();

				foreach ($resultatsVotes as $vote) {

				foreach ($resultatsVotes as $vote) {

				$requetetags .= ' GROUP BY doi.id_image, doi.id_observation '.

				$requetetags .= ' GROUP BY doi.id_image, doi.id_observation '.

						' ORDER by total_tags '.$this->directionTri.', doi.id_observation '.$this->directionTri.

						' ORDER by total_tags '.$this->directionTri.', doi.id_observation '.$this->directionTri.

				$resultatstags = $this->bdd->recupererTous($requetetags);

				$resultatstags = $this->bdd->recupererTous($requetetags . ' -- ' . __FILE__ . ':' . __LINE__);

				$tabtags = array();

				$tabtags = array();

				foreach ($resultatstags as $tag) {

				foreach ($resultatstags as $tag) {

					$tabtags[] = $tag['id_image'];

					$tabtags[] = $tag['id_image'];

		} else {

		} else {

			$requeteImages .= ' GROUP BY doi.id_image, doi.id_observation'; // des fois, on a plusieurs observations pour la même image ...

			$requeteImages .= ' GROUP BY doi.id_image, doi.id_observation'; // des fois, on a plusieurs observations pour la même image ...

			$requeteImages .= $this->gestionBdd->getLimitSql();

			$requeteImages .= $this->gestionBdd->getLimitSql();

		}

		}

		$retour  = $this->bdd->recupererTous($requeteImages);

		$retour  = $this->bdd->recupererTous($requeteImages . ' -- ' . __FILE__ . ':' . __LINE__);

		$total = $this->getFoundRows();

		$total = $this->getFoundRows();

		$this->navigation->setTotal($total);

		$this->navigation->setTotal($total);

										);

										);

				$requeteLiaisons .= $this->chargerClauseWhere();

				$requeteLiaisons .= $this->chargerClauseWhere();

				$requeteLiaisons .= $this->getTri();

				$requeteLiaisons .= $this->getTri();

				$requeteLiaisons .= $this->gestionBdd->getLimitSql();

				$requeteLiaisons .= $this->gestionBdd->getLimitSql();

				$retour = $this->bdd->recupererTous($requeteLiaisons);

				$retour = $this->bdd->recupererTous($requeteLiaisons . ' -- ' . __FILE__ . ':' . __LINE__);

				$total = $this->getFoundRows();

				$total = $this->getFoundRows();

				$this->navigation->setTotal($total);

				$this->navigation->setTotal($total);

				return $retour;

				return $retour;

		$requeteVotes = 'SELECT v.*, p.* FROM '.

		$requeteVotes = 'SELECT v.*, p.* FROM '.

				$this->gestionBdd->formaterTable('del_image_vote', 'v').

				$this->gestionBdd->formaterTable('del_image_vote', 'v').

				' INNER JOIN del_image_protocole p '.

				' INNER JOIN del_image_protocole p '.

				'ON v.ce_protocole = p.id_protocole '.

				'ON v.ce_protocole = p.id_protocole '.

				$this->chargerClauseWhereVotes();

				$this->chargerClauseWhereVotes();