| Line 710... |
Line 710... |
| 710 |
if ($categorie_nature!='') {
|
710 |
if ($categorie_nature!='') {
|
| 711 |
if ($req_where==1) {$requete .= ' AND ';}
|
711 |
if ($req_where==1) {$requete .= ' AND ';}
|
| 712 |
$requete .= 'bn_ce_id_menu IN ('.$categorie_nature.') and bf_ce_nature=bn_id_nature ';
|
712 |
$requete .= 'bn_ce_id_menu IN ('.$categorie_nature.') and bf_ce_nature=bn_id_nature ';
|
| 713 |
$req_where=1;
|
713 |
$req_where=1;
|
| 714 |
}
|
714 |
}
|
| - |
|
715 |
|
| - |
|
716 |
if (isset($_REQUEST['departement'])) {
|
| - |
|
717 |
if ($req_where==1) {$requete .= ' AND ';}
|
| - |
|
718 |
$requete .= ' bf_cp_lieu_evenement LIKE "'.$_REQUEST['departement'].'%" ';
|
| - |
|
719 |
}
|
| Line 715... |
Line 720... |
| 715 |
|
720 |
|
| 716 |
$requete .= ' ORDER BY bf_date_creation_fiche DESC, bf_date_fin_validite_fiche DESC, bf_date_maj_fiche DESC';
|
721 |
$requete .= ' ORDER BY bf_date_creation_fiche DESC, bf_date_fin_validite_fiche DESC, bf_date_maj_fiche DESC';
|
| 717 |
if ($nbitem!='') {$requete .= ' LIMIT 0,'.$nbitem;}
|
722 |
if ($nbitem!='') {$requete .= ' LIMIT 0,'.$nbitem;}
|
| Line 1200... |
Line 1205... |
| 1200 |
else {$valides=1;}
|
1205 |
else {$valides=1;}
|
| 1201 |
//generation de la liste de flux a afficher
|
1206 |
//generation de la liste de flux a afficher
|
| 1202 |
if (!isset($_REQUEST['personnes'])) {
|
1207 |
if (!isset($_REQUEST['personnes'])) {
|
| 1203 |
$_REQUEST['personnes']='tous';
|
1208 |
$_REQUEST['personnes']='tous';
|
| 1204 |
}
|
1209 |
}
|
| 1205 |
|
1210 |
|
| 1206 |
if ((isset($_REQUEST['date_debut']) && $_REQUEST['date_debut'] != '') || (isset($_REQUEST['date_fin']) && $_REQUEST['date_fin'] != '')) {
|
1211 |
if ((isset($_REQUEST['date_debut']) && $_REQUEST['date_debut'] != '') || (isset($_REQUEST['date_fin']) && $_REQUEST['date_fin'] != '')) {
|
| Line 1207... |
Line 1212... |
| 1207 |
|
1212 |
|
| 1208 |
if (isset($_REQUEST['date_debut']) && $_REQUEST['date_debut'] != '' && isset($_REQUEST['date_fin']) && $_REQUEST['date_fin'] != '') {
|
1213 |
if (isset($_REQUEST['date_debut']) && $_REQUEST['date_debut'] != '' && isset($_REQUEST['date_fin']) && $_REQUEST['date_fin'] != '') {
|
| 1209 |
$requeteWhere .= ' (bf_date_debut_evenement >="'.date('Y-m-d', strtotime($_REQUEST['date_debut'])).'"
|
1214 |
$requeteWhere .= ' (bf_date_debut_evenement >="'.date('Y-m-d', strtotime($_REQUEST['date_debut'])).'"
|