26,6 → 26,7 |
|
private $parametres = array(); |
private $ressources = array(); |
private $date_defaut = '1900-01-01'; |
private $ordre_defaut = 'asc'; |
private $idsObsImg = array(); |
private $infosObsImg = array(); |
53,14 → 54,10 |
$this->ressources = $ressources; |
$this->parametres = $parametres; |
|
if (!isset($parametres['date.debut'])) { |
$this->parametres['date.debut'] = '1900-01-01'; |
if (!isset($parametres['date'])) { |
$this->parametres['date'] = $this->date_defaut; |
} |
|
if (!isset($parametres['date.fin'])) { |
$this->parametres['date.fin'] = date('Y-m-d'); |
} |
|
if (! isset($parametres['ordre'])) { |
$this->parametres['ordre'] = $this->ordre_defaut; |
} else { |
95,8 → 92,7 |
--------------------------------------------------------------------------------*/ |
|
private function getIdsObsImg() { |
$date_debut = "'{$this->parametres['date.debut']}'"; |
$date_fin = "'{$this->parametres['date.fin']}'"; |
$date_debut = "'{$this->parametres['date']}'"; |
$limite = @min(intval($this->parametres['navigation.limite']), 1000); |
$limite = $limite ? $limite : 100; // 0 => 10 |
$depart = intval(@$this->parametres['navigation.depart']); |
111,8 → 107,7 |
'FROM del_plantnet AS p '. |
' JOIN del_observation_modif_date '. |
' ON (p.id_observation = del_observation_modif_date.id_observation '. |
' AND modif_date >= '.date('U', strtotime($date_debut)).') '. |
' AND modif_date <= '.date('U', strtotime($date_fin)).') '. |
' 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 '. |