PHP CSql::between 예제들

        }

/*------------------------------------------------------
		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>

예제 #2

파일 보기

파일: gr_rdv.php 프로젝트: rakotobe/Rakotobe

	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>

예제 #3

파일 보기

파일: menu_semaine.php 프로젝트: rakotobe/Rakotobe

	$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&eacute;';
	$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>

예제 #4

파일 보기

파일: gr_user_list_ajax.php 프로젝트: rakotobe/Rakotobe

}
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 ;

예제 #5

파일 보기

파일: reception.php 프로젝트: rakotobe/Rakotobe

	$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&eacute;ception</div>
    </div>
  </div>
  <div id="contentarea">
    <div id="left"><?php include("../nav/menu_g.php"); ?></div>

예제 #6

파일 보기

파일: rdv.php 프로젝트: rakotobe/Rakotobe

	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>