❖ CLEARANCE INFORMATION:
$compID= $user_data['company']; $myDate = date_create() ->format("Y-m-d"); if(isset($_POST['done'])){ $addCompID = mysql_escape_string($_POST['addCompID']); $addByUID = mysql_escape_string($_POST['addByUID']); $ActiveApproverID = mysql_escape_string($_POST['ActiveApproverID']); $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); $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $keyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); //echo $keyCode ."-"; //echo $uID ."-"; //echo $ClearanceDataID ."-"; //echo $addByUID ."-"; echo "☻ ".$senderName."
"; echo "".$sRow['cl_slip_info']."
".$sRow['cl_slip_date']." | ".$sRow['cl_slip_time']."
☺".$senderName."
"; echo "".$sRow['cl_slip_info']."
☀ ".$sRow['cl_slip_date']." | ".$sRow['cl_slip_time']."