<?php
include '../../cfg/asaconn.php';
$mykey = $_GET['keyID']; 
//=========================================================
if($mykey == 10101088991100){ //SIGN CLEARANCE FORM
$userID= $_REQUEST['empID'];
$hID= $_REQUEST['hID'];
$keyCode= $_REQUEST['keyCode'];
 
$TotalApprover = 0;
$totalSignature = 0;
$Rating = 0;
$status ="";
$sql="UPDATE cl_clearance_header SET cl_h_hr_approval = 'POSTED',cl_sla_start='$curDate',hdr_status='1',cl_hr_approval_timestamp='$myTimeStamp' WHERE h_id='$hID'";
    if ($conn->query($sql) === TRUE) {
        $headerUpdate ="Clearance has been Routed.";  
    } 

$sqlD="UPDATE cl_clearance_data SET hdr_status = '1',cl_sla_start='$curDate' WHERE key_code='$keyCode'";
    if ($conn->query($sqlD) === TRUE) {
        $dataUpdate ="Clearance has been Posted.";  
    } 
      
echo json_encode(["dataUpdate" => "$dataUpdate","headerUpdate" => "$headerUpdate"]);
}
?>