| 1,21 → 1,28 |
|---|
| <?php |
| // ATTENTION ! Classe compatible uniquement avec nouveau format de bdd du cel // |
| |
| /** |
| * PHP Version 5 |
| * |
| * @category PHP |
| * @package papyrus_bp |
| * @author aurelien <aurelien@tela-botanica.org> |
| * @copyright 2010 Tela-Botanica |
| * @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL |
| * @version SVN: <svn_id> |
| * @link /doc/ |
| */ |
| |
| Class InventoryContributionList extends DBAccessor { |
| /** |
| * Classe renvoyant une liste très succinte des contributions de l'utilisateur |
| * |
| */ |
| class InventoryContributionList extends Cel { |
| |
| |
| protected $config; |
| |
| function InventoryContributionList($config) { |
| |
| $this->config=$config; |
| } |
| |
| function getRessource() { |
| echo ''; |
| } |
| |
| |
| function getElement($uid){ |
| |
| if(!isset($uid[0])) { |
| 22,47 → 29,38 |
|---|
| echo ''; |
| } |
| |
| $DB=$this->connectDB($this->config,'database_cel'); |
| |
| $query="SELECT * FROM cel_inventory ". |
| "WHERE identifiant = '".$DB->escapeSimple($uid[0])."' ". |
| $requete_contributions = "SELECT * FROM cel_obs ". |
| "WHERE ce_utilisateur = ".$this->proteger($uid[0])." ". |
| "ORDER BY date_modification DESC LIMIT 0,5"; |
| |
| $res =& $DB->query($query); |
| $resultat_contributions = $this->requeter($requete_contributions); |
| |
| $resume = ''; |
| |
| if (DB::isError($res)) { |
| die($res->getMessage()); |
| } |
| if (is_array($resultat_contributions)) { |
| |
| $resume = ""; |
| |
| |
| while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) { |
| $row['nom_sel'] = htmlspecialchars($row['nom_sel']); |
| $row['identifiant'] = htmlspecialchars($row['identifiant']); |
| $row['location'] = htmlspecialchars($row['location']); |
| $row['id_location'] = htmlspecialchars($row['id_location']); |
| $row['station'] = htmlspecialchars($row['station']); |
| $row['milieu'] = htmlspecialchars($row['milieu']); |
| $row['commentaire'] = htmlspecialchars($row['commentaire']); |
| $row['transmission'] = htmlspecialchars($row['transmission']); |
| |
| |
| $resume.= '<p>'.$row['nom_sel'] ." (".$row['num_nom_sel'].") ". |
| 'Location : '. $row['location'].",". $row['station'] . "," . $row['milieu'] . "," . $row['commentaire'] . "," . $row['transmission'] . |
| '</p>'; |
| |
| foreach ($resultat_contributions as $ligne) { |
| $ligne['nom_sel'] = htmlspecialchars($ligne['nom_sel']); |
| $ligne['ce_utilisateur'] = htmlspecialchars($ligne['ce_utilisateur']); |
| $ligne['zone_geo'] = htmlspecialchars($ligne['location']); |
| $ligne['id_zone_geo'] = htmlspecialchars($ligne['id_zone_geo']); |
| $ligne['station'] = htmlspecialchars($ligne['station']); |
| $ligne['milieu'] = htmlspecialchars($ligne['milieu']); |
| $ligne['commentaire'] = htmlspecialchars($ligne['commentaire']); |
| $ligne['transmission'] = htmlspecialchars($ligne['transmission']); |
| |
| $resume.= '<p>'.$ligne['nom_sel'] ." (".$ligne['nom_sel_nn'].") ". |
| 'Location : '. $ligne['location'].",". $ligne['station'] . "," . |
| $ligne['milieu'] . "," . $ligne['commentaire'] . "," . $ligne['transmission'] . |
| '</p>'; |
| } |
| } |
| |
| |
| header("Content-Type: text/html; charset=ISO-8859-1"); |
| print $resume; |
| exit; |
| } |
| |
| } |
| |
| |
| /* +--Fin du code ---------------------------------------------------------------------------------------+ |
| * $Log$ |
| * Revision 1.5 2008-11-13 11:29:12 ddelon |
| 77,5 → 75,4 |
|---|
| * |
| * |
| */ |
| |
| ?> |