| 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.15 2007-03-16 12:40:25 jp_milcent Exp $
|
22 |
// CVS : $Id: bazar.fonct.cal.php,v 1.16 2007-03-22 14:29:27 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.15 $ $Date: 2007-03-16 12:40:25 $
|
32 |
*@version $Revision: 1.16 $ $Date: 2007-03-22 14:29:27 $
|
| 33 |
// +------------------------------------------------------------------------------------------------------+
|
33 |
// +------------------------------------------------------------------------------------------------------+
|
| 34 |
*/
|
34 |
*/
|
| Line 35... |
Line 35... |
| 35 |
|
35 |
|
| 36 |
// +------------------------------------------------------------------------------------------------------+
|
36 |
// +------------------------------------------------------------------------------------------------------+
|
| Line 205... |
Line 205... |
| 205 |
$requete_evenements = "SELECT DISTINCT bf_id_fiche, bf_titre, bf_lieu_evenement, DAY(bf_date_debut_evenement) AS bf_jour_debut_evenement, bf_date_debut_evenement, bf_date_fin_evenement, bf_description ".
|
205 |
$requete_evenements = "SELECT DISTINCT bf_id_fiche, bf_titre, bf_lieu_evenement, DAY(bf_date_debut_evenement) AS bf_jour_debut_evenement, bf_date_debut_evenement, bf_date_fin_evenement, bf_description ".
|
| 206 |
"FROM bazar_fiche, bazar_nature ".
|
206 |
"FROM bazar_fiche, bazar_nature ".
|
| 207 |
"WHERE bf_date_debut_evenement < '".date('Y-m-d', $ts_jour_fin_mois)."' ".
|
207 |
"WHERE bf_date_debut_evenement < '".date('Y-m-d', $ts_jour_fin_mois)."' ".
|
| 208 |
"AND bf_date_fin_evenement >= '".date('Y-m-d', $ts_jour_debut_mois)."' ".
|
208 |
"AND bf_date_fin_evenement >= '".date('Y-m-d', $ts_jour_debut_mois)."' ".
|
| 209 |
"AND bf_ce_nature = bn_id_nature ".
|
209 |
"AND bf_ce_nature = bn_id_nature ".
|
| 210 |
"AND bn_id_nature IN (".BAZ_NUM_ANNONCE_CALENDRIER.")";
|
210 |
"AND bn_id_nature IN (".BAZ_NUM_ANNONCE_CALENDRIER.") ".
|
| - |
|
211 |
"AND bf_statut_fiche = 1";
|
| 211 |
$resultat_evenement = $db->query($requete_evenements);
|
212 |
$resultat_evenement = $db->query($requete_evenements);
|
| 212 |
(DB::isError($resultat_evenement))
|
213 |
(DB::isError($resultat_evenement))
|
| 213 |
? die(BOG_afficherErreurSql(__FILE__, __LINE__, $resultat_evenement->getMessage(), $requete_evenements))
|
214 |
? die(BOG_afficherErreurSql(__FILE__, __LINE__, $resultat_evenement->getMessage(), $requete_evenements))
|
| 214 |
: '';
|
215 |
: '';
|