pileMotifsList.php 882 Bytes
Newer Older
Hamza Arfaoui's avatar
Hamza Arfaoui committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
<?php
require_once('../../inc/confNetisse.php');
$result = array("status"=>false, "motifs" => array());

$agence = $_REQUEST["IDAGENCE"] ?? null;
$client = $_REQUEST["IDCLIENT"] ?? null;

if($agence && $client){
    $q = "SELECT m.id_motif, m.titre, m.code, IF(cm.id, 1 , 0) checked FROM ca_motifs m 
    LEFT JOIN ca_motif_agence ma ON m.id_motif = ma.id_motif
    LEFT OUTER JOIN ca_client_motifs cm ON cm.id_motif = m.id_motif AND cm.id_client = :id_client
    WHERE ma.id_agence = :id_agence AND m.enabled=1";
    $values = array("id_agence"=>$agence, "id_client"=>$client);
    $r = excuteQuery($q, $values);
    if ($r['status']){
        $motifs = array();
        $res = $r["stmt"];
        $motifs = $res->fetchAll(\PDO::FETCH_ASSOC);
        $result = array("status"=>true, "motifs" => $motifs);
    }
}
header('Content-type: application/json');
echo json_encode($result);