| Line 32... |
Line 32... |
| 32 |
}
|
32 |
}
|
| Line 33... |
Line 33... |
| 33 |
|
33 |
|
| 34 |
// Recherche de toutes les observations transmises du taxon pour lesquelles une photo est associee.
|
34 |
// Recherche de toutes les observations transmises du taxon pour lesquelles une photo est associee.
|
| 35 |
$requete_obs_publiques_images_taxon = 'SELECT * FROM cel_obs, cel_obs_images, cel_images '.
|
35 |
$requete_obs_publiques_images_taxon = 'SELECT * FROM cel_obs, cel_obs_images, cel_images '.
|
| 36 |
' WHERE cel_obs.nom_sel_nn = '.$this->proteger($uid[0]).
|
- |
|
| 37 |
' AND cel_obs_images.id_utilisateur = cel_obs.ce_utilisateur '.
|
36 |
' WHERE cel_obs.nom_sel_nn = '.$this->proteger($uid[0]).
|
| 38 |
' AND cel_obs_images.id_observation = cel_obs.id_observation '.
|
37 |
' AND cel_obs_images.id_observation = cel_obs.id_observation '.
|
| 39 |
' AND cel_obs.transmission = 1 '.
|
- |
|
| 40 |
' AND cel_images.ce_utilisateur = cel_obs_images.id_utilisateur '.
|
38 |
' AND cel_obs.transmission = 1 '.
|
| Line 41... |
Line 39... |
| 41 |
' AND cel_images.id_image = cel_obs_images.id_image';
|
39 |
' AND cel_images.id_image = cel_obs_images.id_image';
|
| 42 |
|
40 |
|
| Line 43... |
Line 41... |
| 43 |
$resultat_requete_obs_images_taxon = $this->requeter($requete_obs_publiques_images_taxon);
|
41 |
$resultat_requete_obs_images_taxon = $this->requeter($requete_obs_publiques_images_taxon);
|
| 44 |
$picture_path = $this->config['cel_db']['url_images'];
|
42 |
$picture_path = $this->config['cel']['url_images'];
|
| 45 |
|
43 |
|
| 46 |
// Formatage du xml
|
44 |
// Formatage du xml
|
| Line 77... |
Line 75... |
| 77 |
$xml .= ' dc:title="'.$picture['nom_sel'].'"'."\n";
|
75 |
$xml .= ' dc:title="'.$picture['nom_sel'].'"'."\n";
|
| 78 |
$xml .= ' dc:description="'.$picture['nom_sel']." - [fichier_origine:".$picture['nom_original'].'][image_identifiant:'.$picture['id_image'].']';
|
76 |
$xml .= ' dc:description="'.$picture['nom_sel']." - [fichier_origine:".$picture['nom_original'].'][image_identifiant:'.$picture['id_image'].']';
|
| 79 |
$xml .= '[image_ordre:'.$picture['ordre'].']';
|
77 |
$xml .= '[image_ordre:'.$picture['ordre'].']';
|
| 80 |
$xml .= '[observation_identifiant:'.$picture['id_observation'].']';
|
78 |
$xml .= '[observation_identifiant:'.$picture['id_observation'].']';
|
| 81 |
$xml .= '[observation_ordre:'.$picture['ordre'].']'.'"'."\n";
|
79 |
$xml .= '[observation_ordre:'.$picture['ordre'].']'.'"'."\n";
|
| 82 |
$xml .= ' dc:creator="'.$picture['ce_utilisateur'].'"'."\n";
|
80 |
$xml .= ' dc:creator="'.$picture['courriel_utilisateur'].'"'."\n";
|
| 83 |
$xml .= ' dc:publisher="CEL"'."\n";
|
81 |
$xml .= ' dc:publisher="CEL"'."\n";
|
| 84 |
$xml .= ' dcterms:spatial="'.utf8_decode($picture['zone_geo'])." (".$picture['ce_zone_geo'].")".'"'."\n";
|
82 |
$xml .= ' dcterms:spatial="'.utf8_decode($picture['zone_geo'])." (".$picture['ce_zone_geo'].")".'"'."\n";
|
| Line 85... |
Line 83... |
| 85 |
|
83 |
|
| 86 |
if ($picture['date_observation'] != '0000-00-00 00:00:00') {
|
84 |
if ($picture['date_observation'] != '0000-00-00 00:00:00') {
|