| 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)) |