WebSVN – eFlore/Applications.cel – Diff – /trunk/jrest/services/CelStatistiqueTxt.php

 		$info = (int) Cel::db()->requeterValeurUnique($requete);
 		return $info;
+	}
 	private function getNbImagesPubliques() {
-		$requete = $this->construireRequeteNbreImgLiees();
+		$requete = $this->construireRequeteNbreImgLiees(true);
-		$info =(int) Cel::db()->requeterValeurUnique($requete);
+		$info = (int) Cel::db()->requeterValeurUnique($requete);
 		return $info;
+	}
 		$requete = $select.$from.$where;
 		return $requete;
 	}
-	private function construireRequeteNbreImgLiees() {
+	private function construireRequeteNbreImgLiees($publiquesSeulement=false) {
 		$select = 'SELECT COUNT(DISTINCT ci.id_image) AS nbre ';
 		$from = 'FROM cel_images ci ';
 				$filtres[] = "nt = $num_taxon ";
+			}
 			if (isset($taxon)) {
 				$filtres[] = "nom_ret LIKE $taxon ";
+			}
+			if ($publiquesSeulement === true) {
+				$filtres[] = "ci.transmission = 1";
+			}
 			if (isset($num_taxon) || isset($taxon)) {
 				$from .= 'LEFT JOIN cel_obs ON (ci.ce_observation = co.id_observation) ';

Subversion Repositories eFlore/Applications.cel