94,7 → 94,7 |
private function getIdsObsImg() { |
$date_debut = "'{$this->parametres['date']}'"; |
$limite = @min(intval($this->parametres['navigation.limite']), 1000); |
$limite = $limite ? $limite : 10; // 0 => 10 |
$limite = $limite ? $limite : 100; // 0 => 10 |
$depart = intval(@$this->parametres['navigation.depart']); |
$ordre = $this->parametres['ordre']; |
|
102,39 → 102,25 |
'SELECT SQL_CALC_FOUND_ROWS p.id_observation, p.id_image, '. |
'GROUP_CONCAT(iv.valeur) AS votes, '. |
'GROUP_CONCAT(DISTINCT tag) AS tags, '. |
'GREATEST('. |
' IFNULL(p.date_creation, \''.$this->date_defaut.'\'), '. |
' IFNULL(p.date_modification, \''.$this->date_defaut.'\'), '. |
' IFNULL(MAX(it.date), \''.$this->date_defaut.'\'), '. |
' IFNULL(MAX(it.date_modification), \''.$this->date_defaut.'\'), '. |
' IFNULL(MAX(iv.date), \''.$this->date_defaut.'\'), '. |
' IFNULL(MAX(c.date), \''.$this->date_defaut.'\'), '. |
' IFNULL(MAX(cv.date), \''.$this->date_defaut.'\')) AS modif_date '. |
'modif_date '. |
|
'FROM del_plantnet AS p '. |
' JOIN del_observation_modif_date '. |
' ON (p.id_observation = del_observation_modif_date.id_observation '. |
' AND modif_date >= '.$date_debut.') '. |
' LEFT JOIN del_image_vote AS iv '. |
' ON (id_image = iv.ce_image AND iv.ce_protocole = 3) '. |
' LEFT JOIN del_image_tag AS it '. |
' ON (id_image = it.ce_image AND it.actif = 1) '. |
' LEFT JOIN del_commentaire AS c '. |
' ON (id_observation = c.ce_observation) '. |
' ON (p.id_observation = c.ce_observation) '. |
' LEFT JOIN del_commentaire_vote AS cv '. |
' ON (c.id_commentaire = cv.ce_proposition) '. |
'GROUP BY id_image, id_observation '. |
'HAVING MAX(p.date_creation) >= '.$date_debut.' '. |
' OR MAX(p.date_modification) >= '.$date_debut.' '. |
' OR MAX(it.date) >= '.$date_debut.' '. |
' OR MAX(it.date_modification) >= '.$date_debut.' '. |
' OR MAX(iv.date) >= '.$date_debut.' '. |
' OR MAX(c.date) >= '.$date_debut.' '. |
' OR MAX(cv.date) >= '.$date_debut.' '. |
'GROUP BY id_image, p.id_observation '. |
'ORDER BY modif_date ' . $ordre . ' '. |
'LIMIT '.$depart.', '.$limite. |
' -- '.__FILE__.':'.__LINE__; |
//echo $requete; exit; |
// GROUP BY (très couteux) car multiples observations associées à une image |
// charlie est ici :-) |
// eg: 16150,16185,16245,16246,118995,129989 |
|
return $this->bdd->recupererTous($requete); |
} |
|