14,10 → 14,10 |
* @copyright 1999-2011 Tela Botanica (accueil@tela-botanica.org) |
*/ |
// TODO : Config et Outils sont des classes statiques qui doivent poser des pb pour les tests... |
class Images { |
class Images extends Commun { |
|
private $parametres = array(); |
private $ressources = array(); |
protected $parametres = array(); |
protected $ressources = array(); |
private $Bdd; |
|
const CODE_REFTAX_DEFAUT = 'bdtfx'; |
273,12 → 273,12 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS '. |
' ci.id_image AS id_img, ci.date_creation AS date, '. |
' co.id_observation AS id_obs, '. |
' courriel_utilisateur AS utilisateur_courriel, '. |
' ci.courriel_utilisateur AS utilisateur_courriel, '. |
' nom_sel, nom_sel_nn, '. |
' zone_geo, ce_zone_geo, lieudit, station, milieu '. |
'FROM cel_images AS ci'. |
' LEFT JOIN cel_obs_images AS coi '. |
' ON (coi.id_image = ci.ci_id_image) '. |
' ON (coi.id_image = ci.id_image) '. |
' LEFT JOIN cel_obs AS co '. |
' ON (coi.id_observation = co.id_observation) '. |
'WHERE ci.id_image = '.$this->ressources[0]; |