<?php
include '../../cfg/asaconn.php';
$mykey = $_GET['ApiKey']; 
//=========================================================
if($mykey == 10101080000000000028991100){
$keyCode = $_REQUEST['keyCode'];
$userID= $_REQUEST['userID'];
$count =0;   
$rows = Array();
$count = 0;
$sql = "SELECT vts_users.u_fname,
vts_users.u_lname,
vts_users.u_lname,
vts_users.u_position,
cl_action_slip_data.*
FROM cl_action_slip_data 
join vts_users ON cl_action_slip_data.cl_request_by_id = vts_users.u_id 
WHERE cl_action_slip_data.cl_key_code = '$keyCode'";
	
 		$resultA = $conn->query($sql);
        if ($resultA->num_rows > 0) {
             while($row = $resultA->fetch_assoc()){
               $count = $count + 1;
               $from =$row['cl_request_by_id'];
               if($from==$userID){
                   $class = "msgBoxRight";
               }else{
                   $class = "msgBoxLeft";
               }
                $rows[] = [$row,"Count" =>"$sql","class"=>"$class"];
            }
        } 
   
    
}
 $json = json_encode($rows);
echo $json;
 
 
?>