<?php
include '../../cfg/asaconn.php';
$mykey = $_GET['keyID']; 
//=========================================================
if($mykey == 20101088991122){ //SIGN CLEARANCE FORM
$userID= $_REQUEST['empID'];
$clID= $_REQUEST['clID'];
$keyCode= $_REQUEST['keyCode'];
$sla= $_REQUEST['sla'];
$TotalApprover = 0;
$totalSignature = 0;
$Rating = 0;
$status ="";
$sql="UPDATE cl_clearance_data SET cl_approved_by_id = '$userID',cl_approved_date='$curDate',cl_sla_end='$curDate',cl_status='Cleared',cl_actual_sla='$sla',cl_approved_time='$curTime' WHERE cl_id='$clID'";
if ($conn->query($sql) === TRUE) {
        $status ="Clearance has been signed.";  
    } 
    
    
$countApprover = "SELECT COUNT(1) AS TotalApprover FROM cl_clearance_data WHERE cl_approver_id_a != 0 AND `key_code`='$keyCode'";
	$resultA = $conn->query($countApprover);
    if ($resultA->num_rows > 0) {
        while($rowA = $resultA->fetch_assoc()){
            $totalApprover = $rowA['TotalApprover'];
        }
    } 

$countSignature = "SELECT COUNT(1) AS signedClearance  FROM cl_clearance_data WHERE cl_approved_by_id != 0 AND `key_code`='$keyCode'";
	$resultB = $conn->query($countSignature);
    if ($resultB->num_rows > 0) {
        while($rowB = $resultB->fetch_assoc()){
            $totalSignature = $rowB['signedClearance'];
        }
    } 
    if($totalSignature > 100 ){
        $totalSignature = 100;
    }
 $Rating =    ($totalSignature / $totalApprover) * 100;
 $myRating = number_format($Rating,2,'.',',');
echo json_encode(["TotalApprover" => "$totalApprover","totalSignature" => "$totalSignature","status"=>"$status","myRating"=>"$myRating"]);
}
?>