Line 46... |
Line 46... |
46 |
unset($criteres['tri']);
|
46 |
unset($criteres['tri']);
|
47 |
$direction = (isset($criteres['dir']) && $criteres['dir']) ? $criteres['dir'] : 'ASC';
|
47 |
$direction = (isset($criteres['dir']) && $criteres['dir']) ? $criteres['dir'] : 'ASC';
|
48 |
unset($criteres['dir']);
|
48 |
unset($criteres['dir']);
|
Line 49... |
Line 49... |
49 |
|
49 |
|
50 |
$debut = ($debut < 0) ? 0 : $debut;
|
50 |
$debut = ($debut < 0) ? 0 : $debut;
|
- |
|
51 |
$requete_recherche_images = 'SELECT ci.`id_image` as id_photo, co.guid,
|
- |
|
52 |
`id_observation` as id_obs, `nom_sel`, `nom_sel_nn`, `zone_geo` as localisation, `latitude`, `longitude`,
|
- |
|
53 |
`date_observation` as date_obs, `commentaire`, `certitude`, `grade` as fiabilite, programme as projet,
|
- |
|
54 |
`score_identiplante` as score_ip, `url_identiplante` as url_ip, `validation_identiplante` as est_ip_valide,
|
- |
|
55 |
co.mots_cles_texte as tags_obs, `nom_ret`, `nom_ret_nn`, `famille`,`nom_referentiel`, `pays`,
|
- |
|
56 |
`ce_zone_geo` as code_insee, `dept`, `lieudit`, `station`, `milieu`, `altitude`, `localisation_precision`,
|
- |
|
57 |
`localisation_floutage`, `localisation_coherence`, `abondance`, `phenologie`, `spontaneite`,
|
- |
|
58 |
`type_donnees`, `biblio`, `source`, `herbier`, `determinateur`, `observateur`, `observateur_structure`,
|
- |
|
59 |
`ce_utilisateur` as id_utilisateur, `courriel_utilisateur` as mail_utilisateur, `pseudo_utilisateur` as nom_utilisateur,
|
- |
|
60 |
ci.`nom_original`, ci.`date_prise_de_vue` as date_photo, "Creative Commons BY-SA (2.0)" as licence,
|
- |
|
61 |
concat(`nom_sel`, " par ", `pseudo_utilisateur`, " [CC BY-SA 2.0 FR], via Tela Botanica") as attribution,
|
Line 51... |
Line 62... |
51 |
$requete_recherche_images = 'SELECT ci.*, co.* ';
|
62 |
concat("https://api.tela-botanica.org/img:", lpad(ci.id_image, 9, "0"), "O,") as url_photo, ci.`mots_cles_texte` as tags_photo';
|
52 |
|
63 |
|