19,7 → 19,7 |
// | License along with this library; if not, write to the Free Software | |
// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA | |
// +------------------------------------------------------------------------------------------------------+ |
// CVS : $Id: bazar.fonct.cal.php,v 1.10 2006-09-14 14:15:35 alexandre_tb Exp $ |
// CVS : $Id: bazar.fonct.cal.php,v 1.11 2007-02-15 14:18:38 jp_milcent Exp $ |
/** |
* |
* Fonctions calendrier du module bazar |
29,7 → 29,7 |
*@author David Delon <david.delon@clapas.net> |
//Autres auteurs : |
*@copyright Tela-Botanica 2000-2004 |
*@version $Revision: 1.10 $ $Date: 2006-09-14 14:15:35 $ |
*@version $Revision: 1.11 $ $Date: 2007-02-15 14:18:38 $ |
// +------------------------------------------------------------------------------------------------------+ |
*/ |
|
133,11 → 133,13 |
|
// TODO : Selectionner element du mois en cours |
|
$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) =". |
date('Y',$curStamp)." and month(bf_date_debut_evenement)=". |
date('m',$curStamp)." and bf_ce_nature=bn_id_nature and bn_id_nature='".BAZ_NUM_ANNONCE_CALENDRIER."'"; |
|
|
$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) = ".date('Y',$curStamp)." ". |
"AND month(bf_date_debut_evenement) = ".date('m',$curStamp)." ". |
"AND bf_ce_nature = bn_id_nature ". |
"AND bn_id_nature IN (".BAZ_NUM_ANNONCE_CALENDRIER.")"; |
|
$resultat_evenement = $db->query($requete_evenements); |
|
(DB::isError($resultat_evenement)) |