| 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]; |