format("Y-m-d"); if(isset($_POST['done'])){ $recordID = mysql_escape_string($_POST['recordID']); $addCompID = mysql_escape_string($_POST['addCompID']); $empID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $tempateID = mysql_result(mysql_query("SELECT `cl_h_template_id` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clCompID = mysql_result(mysql_query("SELECT `cl_h_comp_id` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clReason = mysql_result(mysql_query("SELECT `cl_h_reason` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clReasonFrom = mysql_result(mysql_query("SELECT `cl_h_reason_from` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clReasonTo = mysql_result(mysql_query("SELECT `cl_h_reason_to` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clReasonNotes = mysql_result(mysql_query("SELECT `cl_h_reason_notes` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clDateHired = mysql_result(mysql_query("SELECT `cl_date_hired` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clEmpPosition = mysql_result(mysql_query("SELECT `cl_emp_position` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clEmpDesignation = mysql_result(mysql_query("SELECT `cl_emp_designated` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clUnitAssignment = mysql_result(mysql_query("SELECT `cl_unit_assignment` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clSharedServices = mysql_result(mysql_query("SELECT `cl_shared_services` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clEmpStat = mysql_result(mysql_query("SELECT `cl_h_employment_status` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); if($clEmpStat === "REG"){ $clEmpStatName = "REGULAR"; } if($clEmpStat === "CON"){ $clEmpStatName = "CONTRACTUAL"; } if($clEmpStat === "PRJ"){ $clEmpStatName = "PROJECT BASED"; } if($clEmpStat === "PRO"){ $clEmpStatName = "PROBATIONARY"; } switch($clReason){ case 'LOAB': $clReasonName = "Leave of Absense"; break; case 'RASS': $clReasonName = "ReAssignment"; break; case 'TRAN': $clReasonName = "Transfer"; break; case 'DETL': $clReasonName = "Detail"; break; case 'SUS': $clReasonName = "Suspension"; break; case 'REMP': $clReasonName = "Leave of Absense"; break; case 'RESA': $clReasonName = "Resignation"; break; case 'IRES': $clReasonName = "Involuntary Resignation"; break; case 'RETR': $clReasonName = "Retirement"; break; } $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$clEmpPosition'"),0); $clCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$clCompID'"),0); } ?>

SELECT EMPLOYEE:

EMPLOYEE ID:

EMPLOYMENT STATUS:

DATE HIRED:

POSITION TITLE:

WORKING TITLE:

CURRENT UNIT ASSIGNMENT:

COMPANY:

SHARED SERVICES:

REASON FOR SECURING CLEARANCE:

FROM:

TO:

CLEARANCE NOTE: