} /*------------------------------------------------------ A FAIRE DANS TOUS LES CAS --------------------------------------------------------*/ $filtre_etat = CSession::get('filtre_etat', 0); $filtre_date_debut = CDate::date_switch(CSession::get('filtre_date_debut')); $filtre_date_fin = CDate::date_switch(CSession::get('filtre_date_fin')); $filtre_sujet = CSession::get('filtre_sujet', '%%'); $filtre_nom_user = CSession::get('filtre_nom_user'); $filtre_prenom_user = CSession::get('filtre_prenom_user'); $_filtre_etat = ($filtre_etat=='%%')?"etat LIKE '%%'":' etat = '.$filtre_etat; //echo $_filtre_etat; $filtre = " expediteur LIKE '" . CTableUser::get_email_admin() . "' AND " . $_filtre_etat . " AND " . CSql::between($filtre_date_debut, $filtre_date_fin) . " AND nom LIKE '" . $filtre_sujet . "' AND destinataire LIKE '%" . CTableUser::get_element($filtre_nom_user, 'email') . "%' AND destinataire LIKE '%" . CTableUser::get_element($filtre_prenom_user, 'email') . "%'"; // AND type = 'default'"; // echo $filtre; $r_email = CTableEmail::select("*", $filtre, $order); ?> <!-- InstanceEndEditable --> <div id="mainwrap"> <div id="header"><?php include("../nav/header.php"); ?></div> <div id="top"><?php include("../nav/menu_h.php"); ?></div> <div id="filet"> <div id="zonetitre"> <div id="signe"></div> <div id="titre"><!-- InstanceBeginEditable name="titre" -->Envoi<!-- InstanceEndEditable --></div> </div> </div>
else if ($_GET['filtre_id_periode']==2){ $filtreDateDebut = $pSemaine; $filtreDateFin = $dSemaine; }else if ($_GET['filtre_id_periode']==3){ $filtreDateDebut = $pMois; $filtreDateFin = $dMois; } } if ($filtreDateDebut != '') { $filtre_date_debut = $filtreDateDebut; $filtre_date_fin = $filtreDateFin; } if ($_GET['recherche'] == '') $filtre = "etat like '" . $filtre_etat . "' AND " . CSql::between($filtre_date_debut, $filtre_date_fin); else $filtre = "nom like '".$_GET['recherche']."%'"; //print_r($filtre); $r_rdv = CTableGrRdv::select("*", $filtre, $order); ?> <!-- InstanceEndEditable --> <div id="mainwrap"> <div id="header"><?php include("../nav/header.php"); ?></div> <div id="top"><?php include("../nav/menu_h.php"); ?></div> <div id="filet"> <div id="zonetitre"> <div id="signe"></div> <div id="titre"><!-- InstanceBeginEditable name="titre" -->Rdv GR<!-- InstanceEndEditable --></div> </div>
$values = array( 'id'=>$id, 'date'=>$date, 'titre'=>CFunction::addslashes($titre), 'etat'=>$etat, 'contenu'=>CFunction::addslashes($contenu), 'prix'=>$prix); $menu_obj = new CTableMenu($values); $menu_obj->update(); $msginfo = 'Menu bien modifié'; $a = 0; break; } $filtre = CSql::between($filtre_date_debut, $filtre_date_fin); /*------------------------------------------------------ A FAIRE DANS TOUS LES CAS --------------------------------------------------------*/ $menu_obj = CTableMenu::select('*', $filtre, $order); ?> <!-- InstanceEndEditable --> <div id="mainwrap"> <div id="header"><?php include("../nav/header.php"); ?></div> <div id="top"><?php include("../nav/menu_h.php"); ?></div> <div id="filet"> <div id="zonetitre"> <div id="signe"></div> <div id="titre"><!-- InstanceBeginEditable name="titre" -->Menu de la semaine<!-- InstanceEndEditable --></div> </div> </div>
} else { $zFiltreEmail = "1"; } //---------- FIN : Lay feeling---// if ($_GET['recherche'] == ''){ if ($_GET['alphaA'] != '') { $filtre = " 1 AND etat_contact like '" . $filtre_etat_contact. "' AND " . CSql::between($filtre_date_debut, $filtre_date_fin) . " " . $filtre_groupe . " AND " . $zFiltreEmail . " AND nom LIKE '" . $filtre_nom . "' AND prenom LIKE '" . $filtre_prenom . "' " . $filtre_opportunite. " AND nom LIKE '" . $_GET['alphaA'] ."%' AND ". CSqlUserContact::between($filtreDateDebut, $filtreDateFin) . ""; if (($_GET['filtre_societe']) && $_GET['filtre_societe'] !='%%') $filtre .= " AND id LIKE '" . $filtre_societe . "'"; }else if ($_SESSION['alphaA'] != ''){ $filtre = " 1 AND etat_contact like '" . $filtre_etat_contact. "' AND " . CSql::between($filtre_date_debut, $filtre_date_fin) . " " . $filtre_groupe . " AND " . $zFiltreEmail . " AND nom LIKE '" . $filtre_nom . "' AND prenom LIKE '" . $filtre_prenom . "' " . $filtre_opportunite. " AND nom LIKE '" . $_SESSION['alphaA'] ."%' AND ". CSqlUserContact::between($filtreDateDebut, $filtreDateFin) .""; if (($_GET['filtre_societe']) && $_GET['filtre_societe'] !='%%') $filtre .= " AND id LIKE '" . $filtre_societe . "'"; } else { $filtre = " 1 AND etat_contact like '" . $filtre_etat_contact. "' AND " . CSql::between($filtre_date_debut, $filtre_date_fin) . " " . $filtre_groupe . " AND " . $zFiltreEmail . " AND nom LIKE '" . $filtre_nom . "' AND prenom LIKE '" . $filtre_prenom . "' " . $filtre_opportunite. " AND ". CSqlUserContact::between($filtreDateDebut, $filtreDateFin) .""; if (($_GET['filtre_societe']) && $_GET['filtre_societe'] !='%%') $filtre .= " AND id LIKE '" . $filtre_societe . "'"; } }else $filtre = " 1 AND nom like '%".$_GET['recherche']."%'"; $zSortField = 'id' ; $zSortDirection = CFunctions::getUserParam('zSortDirection', 'ASC') ; //$zSortField = CFunctions::getUserParam('order', 'id') ; $pagecourant = CFunctions::getUserParam('zSortField', '1') ; $iCurrentPage = CFunctions::getUserParam('iCurrentPage', '1') ; $iMaxPerPage = CConfiguration::get_valeur('MAX_ITEM_PER_PAGE', 10) ; $iStart = $iCurrentPage - 1 ; $zListeGetParam = '' ; $zListeGetParam .= '&filtre_etat_contact=' . $filtre_etat_contact ; $zListeGetParam .= '&filtre_date_debut=' . $filtre_date_debut ;
$message = $publipostage->get_message(); break; case 77 : // Publipostage 2 break; } /*------------------------------------------------------ A FAIRE DANS TOUS LES CAS --------------------------------------------------------*/ $filtre_etat = CSession::get('filtre_etat', $etat); $filtre_date_debut = CDate::date_switch(CSession::get('filtre_date_debut')); $filtre_date_fin = CDate::date_switch(CSession::get('filtre_date_fin')); $filtre_nom_user = CSession::get('filtre_nom_user'); $filtre_prenom_user = CSession::get('filtre_prenom_user'); $filtre = " destinataire LIKE '" . CTableUser::get_email_admin() . "' AND etat like '" . $filtre_etat . "' AND " . CSql::between($filtre_date_debut, $filtre_date_fin) . " AND expediteur LIKE '%" . CTableUser::get_element($filtre_nom_user, 'email') . "%' AND expediteur LIKE '%" . CTableUser::get_element($filtre_prenom_user, 'email') . "%' "; $r_email = CTableEmail::select("*", $filtre, $order); ?> <div id="mainwrap"> <div id="header"><?php include("../nav/header.php"); ?></div> <div id="top"><?php include("../nav/menu_h.php"); ?></div> <div id="filet"> <div id="zonetitre"> <div id="signe"></div> <div id="titre">Réception</div> </div> </div> <div id="contentarea"> <div id="left"><?php include("../nav/menu_g.php"); ?></div>
CFunction::redirection("../src/user.php?a=5&id=" . $id); break; case 6 : // Filtrer CSession::save($_GET); break; } /*------------------------------------------------------ A FAIRE DANS TOUS LES CAS --------------------------------------------------------*/ $filtre_etat = CSession::get('filtre_etat', $etat); $filtre_date_debut = CDate::date_switch(CSession::get('filtre_date_debut')); $filtre_date_fin = CDate::date_switch(CSession::get('filtre_date_fin')); $filtre = " 1 AND etat like '" . $filtre_etat . "' AND " . CSql::between($filtre_date_debut, $filtre_date_fin); $r_rdv = CTableRdv::select("*", $filtre, $order); ?> <!-- InstanceEndEditable --> <div id="mainwrap"> <div id="header"><?php include("../nav/header.php"); ?></div> <div id="top"><?php include("../nav/menu_h.php"); ?></div> <div id="filet"> <div id="zonetitre"> <div id="signe"></div> <div id="titre"><!-- InstanceBeginEditable name="titre" -->Rdv<!-- InstanceEndEditable --></div> </div> </div> <div id="contentarea"> <div id="left"><?php include("../nav/menu_g.php"); ?></div>