<?php
include '../../cfg/asaconn.php';
$mykey = $_GET['keyID']; 
//=========================================================
if($mykey == 10101088991100){
$userID= $_REQUEST['empID']; // Expect LoginName, LoginPassword*
$count =0;   
$rows = Array();
 
$sql = "SELECT vts_users.u_fname,
vts_users.u_lname,
vts_users.u_lname,
vts_users.u_position,
vts_company.comp_code,
cl_clearance_header.h_id,
cl_clearance_header.cl_h_emp_id,
cl_clearance_header.cl_effectivity_date,
cl_clearance_header.cl_h_reason,
cl_clearance_header.cl_h_date_created,
cl_clearance_header.key_code,
cl_clearance_header.cl_hr_approval_id
FROM cl_clearance_header 
join vts_users ON cl_clearance_header.cl_h_emp_id = vts_users.u_id 
join vts_company ON vts_company.comp_id = cl_clearance_header.cl_h_comp_id
WHERE cl_clearance_header.cl_hr_approval_id = $userID AND cl_clearance_header.cl_h_hr_approval ='FOR HR APPROVAL' ORDER BY cl_clearance_header.h_id DESC";
	
 		$resultA = $conn->query($sql);
        if ($resultA->num_rows > 0) {
             while($row = $resultA->fetch_assoc()){
                 $count = $count + 1;
                $rows[] = [$row, "Count" =>"$count"];
            }
        
        } 
    $json = json_encode($rows);
    
}
echo $json;
 
 
?>