Subversion Repositories eFlore/Applications.cel

Compare Revisions

No changes between revisions

Ignore whitespace Rev 2501 → Rev 2504

/trunk/jrest/services/CelStatistiqueTxt.php
213,8 → 213,8
}
 
private function getNbImagesPubliques() {
$requete = $this->construireRequeteNbreImgLiees();
$info =(int) Cel::db()->requeterValeurUnique($requete);
$requete = $this->construireRequeteNbreImgLiees(true);
$info = (int) Cel::db()->requeterValeurUnique($requete);
return $info;
}
 
325,7 → 325,7
return $requete;
}
 
private function construireRequeteNbreImgLiees() {
private function construireRequeteNbreImgLiees($publiquesSeulement=false) {
$select = 'SELECT COUNT(DISTINCT ci.id_image) AS nbre ';
$from = 'FROM cel_images ci ';
 
343,6 → 343,9
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) ';
/trunk/jrest/services
Property changes:
Modified: svn:mergeinfo
Merged /branches/v2.8-houe/jrest/services:r2502-2503
/trunk/jrest
Property changes:
Modified: svn:mergeinfo
Merged /branches/v2.8-houe/jrest:r2502-2503
/trunk/doc/bdd/2014-09_migration_optimisation/maj_optimisation.sql
30,6 → 30,8
 
-- Ajout index sur ce_observation
CREATE INDEX ce_observation ON cel_images (ce_observation);
-- Ajout index sur transmission
CREATE INDEX transmission ON cel_images(transmission);
 
-- Mise à jour du champ «transmission» de la table «cel_images» à partir des données de «cel_obs»
START TRANSACTION;
/trunk/.
Property changes:
Modified: svn:mergeinfo
Merged /branches/v2.8-houe:r2502-2503