| 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: bazar.fonct.cal.php,v 1.10 2006-09-14 14:15:35 alexandre_tb Exp $
|
22 |
// CVS : $Id: bazar.fonct.cal.php,v 1.11 2007-02-15 14:18:38 jp_milcent Exp $
|
| 23 |
/**
|
23 |
/**
|
| 24 |
*
|
24 |
*
|
| 25 |
* Fonctions calendrier du module bazar
|
25 |
* Fonctions calendrier du module bazar
|
| 26 |
*
|
26 |
*
|
| 27 |
*@package bazar
|
27 |
*@package bazar
|
| 28 |
//Auteur original :
|
28 |
//Auteur original :
|
| 29 |
*@author David Delon <david.delon@clapas.net>
|
29 |
*@author David Delon <david.delon@clapas.net>
|
| 30 |
//Autres auteurs :
|
30 |
//Autres auteurs :
|
| 31 |
*@copyright Tela-Botanica 2000-2004
|
31 |
*@copyright Tela-Botanica 2000-2004
|
| 32 |
*@version $Revision: 1.10 $ $Date: 2006-09-14 14:15:35 $
|
32 |
*@version $Revision: 1.11 $ $Date: 2007-02-15 14:18:38 $
|
| 33 |
// +------------------------------------------------------------------------------------------------------+
|
33 |
// +------------------------------------------------------------------------------------------------------+
|
| 34 |
*/
|
34 |
*/
|
| Line 35... |
Line 35... |
| 35 |
|
35 |
|
| 36 |
// +------------------------------------------------------------------------------------------------------+
|
36 |
// +------------------------------------------------------------------------------------------------------+
|
| Line 131... |
Line 131... |
| 131 |
|
131 |
|
| Line 132... |
Line 132... |
| 132 |
// Recherche evenement de la periode selectionnée
|
132 |
// Recherche evenement de la periode selectionnée
|
| Line 133... |
Line 133... |
| 133 |
|
133 |
|
| - |
|
134 |
// TODO : Selectionner element du mois en cours
|
| - |
|
135 |
|
| 134 |
// TODO : Selectionner element du mois en cours
|
136 |
$requete_evenements = "SELECT DISTINCT bf_id_fiche, bf_titre, bf_lieu_evenement, DAY(bf_date_debut_evenement) AS bf_jour_debut_evenement , bf_date_fin_evenement, bf_description ".
|
| - |
|
137 |
"FROM bazar_fiche, bazar_nature ".
|
| 135 |
|
138 |
"WHERE YEAR(bf_date_debut_evenement) = ".date('Y',$curStamp)." ".
|
| 136 |
$requete_evenements = "SELECT DISTINCT bf_id_fiche, bf_titre, bf_lieu_evenement, day(bf_date_debut_evenement) as bf_jour_debut_evenement , bf_date_fin_evenement, bf_description FROM bazar_fiche, bazar_nature where year(bf_date_debut_evenement) =".
|
- |
|
| 137 |
date('Y',$curStamp)." and month(bf_date_debut_evenement)=".
|
139 |
"AND month(bf_date_debut_evenement) = ".date('m',$curStamp)." ".
|
| 138 |
date('m',$curStamp)." and bf_ce_nature=bn_id_nature and bn_id_nature='".BAZ_NUM_ANNONCE_CALENDRIER."'";
|
140 |
"AND bf_ce_nature = bn_id_nature ".
|
| Line 139... |
Line 141... |
| 139 |
|
141 |
"AND bn_id_nature IN (".BAZ_NUM_ANNONCE_CALENDRIER.")";
|
| 140 |
|
142 |
|
| 141 |
$resultat_evenement = $db->query($requete_evenements);
|
143 |
$resultat_evenement = $db->query($requete_evenements);
|