Subversion Repositories Applications.papyrus

Rev

Rev 383 | Rev 448 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 383 Rev 385
Line 17... Line 17...
17 
// |                                                                                                      |
 17 
// |                                                                                                      |
18 
// | You should have received a copy of the GNU Lesser General Public                                     |
 18 
// | You should have received a copy of the GNU Lesser 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: menu.php,v 1.19 2005-05-27 10:23:00 jpm Exp $
 22 
// CVS : $Id: menu.php,v 1.20 2005-05-27 14:56:51 alex Exp $
23 
/**
 23 
/**
24 
* Applette : menu
 24 
* Applette : menu
25 
*
 25 
*
26 
* Génère une liste de listes comportant tous les niveaux des menus "classiques" d'un site.
 26 
* Génère une liste de listes comportant tous les niveaux des menus "classiques" d'un site.
27 
* Nécessite :
 27 
* Nécessite :
Line 36... Line 36...
36 
//Auteur original :
 36 
//Auteur original :
37 
*@author        Jean-Pascal MILCENT <jpm@tela-botanica.org>
 37 
*@author        Jean-Pascal MILCENT <jpm@tela-botanica.org>
38 
//Autres auteurs :
 38 
//Autres auteurs :
39 
*@author        Aucun
 39 
*@author        Aucun
40 
*@copyright     Tela-Botanica 2000-2004
 40 
*@copyright     Tela-Botanica 2000-2004
41 
*@version       $Revision: 1.19 $ $Date: 2005-05-27 10:23:00 $
 41 
*@version       $Revision: 1.20 $ $Date: 2005-05-27 14:56:51 $
42 
// +------------------------------------------------------------------------------------------------------+
 42 
// +------------------------------------------------------------------------------------------------------+
43 
*/
 43 
*/
Line 44... Line 44...
44 
 
 44 
 
45 
// +------------------------------------------------------------------------------------------------------+
 45 
// +------------------------------------------------------------------------------------------------------+
Line 285... Line 285...
285 
                            'FROM gen_menu, gen_menu_relation AS GMR01, gen_menu_relation AS GMR02 '.
 285 
                            'FROM gen_menu, gen_menu_relation AS GMR01, gen_menu_relation AS GMR02 '.
286 
                            'WHERE GMR01.gmr_id_menu_02 = '.$ligne->gm_id_menu.' '.
 286 
                            'WHERE GMR01.gmr_id_menu_02 = '.$ligne->gm_id_menu.' '.
287 
                            'AND GMR01.gmr_id_menu_01 = gm_id_menu '.
 287 
                            'AND GMR01.gmr_id_menu_01 = gm_id_menu '.
288 
                            'AND GMR01.gmr_id_valeur = 1 '.// 1 = "avoir père"
 288 
                            'AND GMR01.gmr_id_valeur = 1 '.// 1 = "avoir père"
289 
                            'AND GMR02.gmr_id_menu_02 = gm_id_menu '.
 289 
                            'AND GMR02.gmr_id_menu_02 = gm_id_menu '.
290 
                            'AND GMR02.gmr_id_menu_01 = GMR02.gmr_id_menu_02 '.
 290 
                            'AND GMR02.gmr_id_menu_01 = GMR02.gmr_id_menu_02 ' ;
- 
 
 291 
            if ($menu_type == 'classique') {
291 
                            'AND GMR02.gmr_id_valeur = 100 '.// 100 = type "menu classique"
 292 
                $requete_fils .='AND GMR02.gmr_id_valeur = 100 ' ;// 100 = type "menu classique"
- 
 
 293 
            }
- 
 
 294 
            if ($menu_type == 'commun') {
292 
                            'ORDER BY GMR01.gmr_ordre ASC '.
 295 
                $requete_fils .='AND GMR02.gmr_id_valeur = 102 '; // 102 = type "menu commun"
- 
 
 296 
            }
293 
                            'LIMIT 0,1';
 297 
            $requete_fils .= 'ORDER BY GMR01.gmr_ordre ASC LIMIT 0,1';
Line 294... Line 298...
294
298
295 
            $resultat_fils = $objet_pear_db->query($requete_fils);
 299 
            $resultat_fils = $objet_pear_db->query($requete_fils);
296 
            (DB::isError($resultat_fils))
 300 
            (DB::isError($resultat_fils))
297 
                ? die(BOG_afficherErreurSql(__FILE__, __LINE__, $resultat_fils->getMessage(), $requete_fils))
 301 
                ? die(BOG_afficherErreurSql(__FILE__, __LINE__, $resultat_fils->getMessage(), $requete_fils))
Line 382... Line 386...
382 
 
 386 
 
383 
 
 387 
 
384 
/* +--Fin du code ----------------------------------------------------------------------------------------+
 388 
/* +--Fin du code ----------------------------------------------------------------------------------------+
- 
 
 389 
*
- 
 
 390 
* $Log: not supported by cvs2svn $
- 
 
 391 
* Revision 1.19  2005/05/27 10:23:00  jpm
385 
*
 392 
* Modification du style des raccourcis.
386 
* $Log: not supported by cvs2svn $
 393 
*
387 
* Revision 1.18  2005/05/03 08:39:32  jpm
 394 
* Revision 1.18  2005/05/03 08:39:32  jpm
388 
* Ajout d'un test sur la date.
 395 
* Ajout d'un test sur la date.
389 
*
 396 
*