<?php require_once('../../inc/confNetisse.php'); $FILTER = ""; $AID = $_REQUEST["aid"] ? intval($_REQUEST["aid"]) : false; $TYPE = $_REQUEST["type"] ? $_REQUEST["type"] : false; $DATA = array(); if($AID){ if($TYPE == "meeting"){ $FILTER .= " AND date_priseencharge IS NOT NULL AND date_priseencharge != '0000-00-00 00:00:00' AND (date_cloture IS NULL OR date_cloture = '0000-00-00 00:00:00') AND cancelled =0"; } $q = "SELECT id_client, ticket, g.numero as 'counter' FROM ca_clients c LEFT JOIN ca_guichets g ON g.id_guichet = c.guichet WHERE DATE(date_arrivee) = DATE(now()) AND id_agence=:id_agence".$FILTER; $values = array(':id_agence' => $AID); $result = excuteQuery($q, $values); $res = $result['stmt']; while($client = $res->fetchObject()){ $DATA[] = $client; } } echo json_encode($DATA);