Line 17... |
Line 17... |
17 |
// | |
|
17 |
// | |
|
18 |
// | You should have received a copy of the GNU General Public |
|
18 |
// | You should have received a copy of the GNU General Public |
|
19 |
// | License along with this library; if not, write to the Free Software |
|
19 |
// | License along with this library; if not, write to the Free Software |
|
20 |
// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
|
20 |
// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
|
21 |
// +------------------------------------------------------------------------------------------------------+
|
21 |
// +------------------------------------------------------------------------------------------------------+
|
22 |
// CVS : $Id: tela_ergo.php,v 1.1 2008-08-25 15:00:28 alexandre_tb Exp $
|
22 |
// CVS : $Id: tela_ergo.php,v 1.2 2008-09-01 14:37:15 alexandre_tb Exp $
|
23 |
/**
|
23 |
/**
|
24 |
* Application projet
|
24 |
* Application projet
|
25 |
*
|
25 |
*
|
26 |
* Fichier de presentation de la liste des projets pour Tela Botanica nouvelle version
|
26 |
* Fichier de presentation de la liste des projets pour Tela Botanica nouvelle version
|
27 |
*
|
27 |
*
|
Line 29... |
Line 29... |
29 |
//Auteur original :
|
29 |
//Auteur original :
|
30 |
*@author Alexandre Granier <alexandre@tela-botanica.org>
|
30 |
*@author Alexandre Granier <alexandre@tela-botanica.org>
|
31 |
//Autres auteurs :
|
31 |
//Autres auteurs :
|
32 |
*@author Aucun
|
32 |
*@author Aucun
|
33 |
*@copyright Tela-Botanica 2000-2004
|
33 |
*@copyright Tela-Botanica 2000-2004
|
34 |
*@version $Revision: 1.1 $
|
34 |
*@version $Revision: 1.2 $
|
35 |
// +------------------------------------------------------------------------------------------------------+
|
35 |
// +------------------------------------------------------------------------------------------------------+
|
36 |
*/
|
36 |
*/
|
Line 37... |
Line 37... |
37 |
|
37 |
|
38 |
// +------------------------------------------------------------------------------------------------------+
|
38 |
// +------------------------------------------------------------------------------------------------------+
|
Line 75... |
Line 75... |
75 |
if (isset($_GET[PROJET_VARIABLE_ORDRE_TRI]) && $_GET[PROJET_VARIABLE_ORDRE_TRI] != ''
|
75 |
if (isset($_GET[PROJET_VARIABLE_ORDRE_TRI]) && $_GET[PROJET_VARIABLE_ORDRE_TRI] != ''
|
76 |
&& in_array ($_GET[PROJET_VARIABLE_ORDRE_TRI], $valeur_acceptable_ordre_tri)) {
|
76 |
&& in_array ($_GET[PROJET_VARIABLE_ORDRE_TRI], $valeur_acceptable_ordre_tri)) {
|
77 |
$ordre_tri = $_GET[PROJET_VARIABLE_ORDRE_TRI];
|
77 |
$ordre_tri = $_GET[PROJET_VARIABLE_ORDRE_TRI];
|
Line 78... |
Line 78... |
78 |
|
78 |
|
79 |
} else {
|
79 |
} else {
|
80 |
$ordre_tri = 'asc';
|
80 |
$ordre_tri = '';
|
Line 81... |
Line 81... |
81 |
}
|
81 |
}
|
82 |
|
82 |
|
83 |
// variable de session pour se rappeler des choix du visiteur
|
83 |
// variable de session pour se rappeler des choix du visiteur
|
Line 206... |
Line 206... |
206 |
' left join projet_statistiques on p_id=ps_ce_projet and ps_dernier=1'.
|
206 |
' left join projet_statistiques on p_id=ps_ce_projet and ps_dernier=1'.
|
207 |
$from_recherche.
|
207 |
$from_recherche.
|
208 |
$where_recherche.
|
208 |
$where_recherche.
|
209 |
' group by p_id order by '.$tri.' '.$ordre_tri ;
|
209 |
' group by p_id order by '.$tri.' '.$ordre_tri ;
|
Line -... |
Line 210... |
- |
|
210 |
|
- |
|
211 |
if ($ordre_tri == '') $ordre_tri = 'desc';
|
210 |
|
212 |
|
211 |
$resultat = $this->_db->query($requete) ;
|
213 |
$resultat = $this->_db->query($requete) ;
|
212 |
if (DB::isError($resultat)) {
|
214 |
if (DB::isError($resultat)) {
|
213 |
return ("Echec de la requete<br />".$resultat->getMessage()."<br />".$resultat->getDebugInfo()) ;
|
215 |
return ("Echec de la requete<br />".$resultat->getMessage()."<br />".$resultat->getDebugInfo()) ;
|
Line 465... |
Line 467... |
465 |
return $res ;
|
467 |
return $res ;
|
Line 466... |
Line 468... |
466 |
|
468 |
|
467 |
/* +--Fin du code ----------------------------------------------------------------------------------------+
|
469 |
/* +--Fin du code ----------------------------------------------------------------------------------------+
|
468 |
*
|
470 |
*
|
- |
|
471 |
* $Log: not supported by cvs2svn $
|
- |
|
472 |
* Revision 1.1 2008-08-25 15:00:28 alexandre_tb
|
- |
|
473 |
* version initiale
|
469 |
* $Log: not supported by cvs2svn $
|
474 |
*
|
470 |
* +-- Fin du code ----------------------------------------------------------------------------------------+
|
475 |
* +-- Fin du code ----------------------------------------------------------------------------------------+
|
Line 471... |
Line 476... |
471 |
*/
|
476 |
*/
|