❖ CLEARANCE INFORMATION:
$compID= $user_data['company'];
$myDate = date_create() ->format("Y-m-d");
$toTime =date('H:i:s');
$dateTime = $myDate . " ".$toTime;
if(isset($_POST['done'])){
$recordID = mysql_escape_string($_POST['recordID']);
$uID=mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0);
$clDate=mysql_result(mysql_query("SELECT `cl_h_date_created` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0);
$ceDate=mysql_result(mysql_query("SELECT `cl_effectivity_date` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0);
$uFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uComp = mysql_result(mysql_query("SELECT `company` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uDeal = mysql_result(mysql_query("SELECT `dealer` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$uComp'"),0);
$uDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$uDeal'"),0);
$uPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$uID'"),0);
?>