getClientsList.php

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