<?phprequire_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');echojson_encode($result);