<?php
include '../../cfg/asaconn.php';
$mykey = $_GET['ApiKey']; 
//=========================================================
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.cl_h_emp_id,
cl_clearance_header.h_id,
cl_clearance_header.cl_effectivity_date,
cl_clearance_header.cl_h_reason,
cl_clearance_header.cl_h_date_created,
cl_clearance_data.cl_approver_id_a,
cl_clearance_data.cl_approver_id_b,
cl_clearance_data.cl_id,
cl_clearance_data.deleted,
cl_clearance_data.cl_sla_start,
cl_clearance_data.cl_unit_id,
cl_clearance_data.time_stamp,
cl_clearance_data.key_code,
cl_clearance_header.key_code,
cl_approving_unit.id,

cl_approving_unit.cl_unit_name
FROM cl_clearance_header 
join vts_users ON cl_clearance_header.cl_h_emp_id = vts_users.u_id 
join cl_clearance_data ON cl_clearance_header.key_code = cl_clearance_data.key_code 
join cl_approving_unit ON cl_clearance_data.cl_unit_id = cl_approving_unit.id
join vts_company ON cl_clearance_header.cl_h_comp_id = vts_company.comp_id
WHERE cl_clearance_data.cl_approver_id_a = $userID AND cl_clearance_header.cl_h_hr_approval = 'POSTED' AND cl_clearance_data.cl_approved_by_id = 0 AND cl_clearance_data.`cl_approved_date` ='' AND cl_clearance_data.`cl_status`='Pending' ORDER BY cl_clearance_header.cl_h_date_created DESC";
	
 		$resultA = $conn->query($sql);
        if ($resultA->num_rows > 0) {
             while($row = $resultA->fetch_assoc()){
                $count = $count + 1;
                    $date1 = new DateTime($row['cl_sla_start']);
                    $date2 = new DateTime($curDate);
                    
                    $interval = $date1->diff($date2);
                    if($interval->days > 1){
                        $withS = 's';
                    }else{
                        $withS = '';
                    }
                    $intervalDates = $interval->days;
                $rows[] = [$row,"days"=>"$intervalDates", "Count" =>"$count"];
            }
        
        } 
     
	if($count > 0){
	    $visible="";
	}else{
	    $visible="true";
	}
    $json = json_encode($rows);
    
}
echo $json;
 
 
?>