format("Y-m-d"); $toTime =Explode(":", date('H:i:s')); $myTime = $toTime[0]; $myMinute = $toTime[1]; $mySecond = $toTime[2]; $currentTime = $myTime . ':' . $myMinute . ':' . $mySecond; //if submit/ save to databasevar if(isset($_POST['done'])){ $recordID = mysql_escape_string($_POST['recordID']); $clearanceTemplatee = mysql_escape_string($_POST['clearanceTemplatee']); $SelEmpIDe = mysql_escape_string($_POST['SelEmpIDe']); $empDateHirede= mysql_escape_string($_POST['empDateHirede']); $empIDe = mysql_escape_string($_POST['empIDe']); $employmentStatuse = mysql_escape_string($_POST['employmentStatuse']); $employeePositione = mysql_escape_string($_POST['employeePositione']); $empDesignatede = mysql_escape_string($_POST['empDesignatede']); $empUnitAssignmente = mysql_escape_string($_POST['empUnitAssignmente']); $empCompanye = mysql_escape_string($_POST['empCompanye']); $empSharedServicese = mysql_escape_string($_POST['empSharedServicese']); $clearanceReasone = mysql_escape_string($_POST['clearanceReasone']); $reasonFrome = mysql_escape_string($_POST['reasonFrome']); $reasonToe = mysql_escape_string($_POST['reasonToe']); $empClearanceNotee = mysql_escape_string($_POST['empClearanceNotee']); $addByUID = mysql_escape_string($_POST['addByUID']); $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$SelEmpIDe'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$SelEmpIDe'"),0); $uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$SelEmpIDe'"),0); $hrAuthID = mysql_result(mysql_query("SELECT `cl_hr_approval_id` FROM `cl_template_name` WHERE `id`='$clearanceTemplate'"),0); $clRank = mysql_result(mysql_query("SELECT `cl_template_rank` FROM `cl_template_name` WHERE `id`='$clearanceTemplatee'"),0); $clRecA = mysql_result(mysql_query("SELECT `cl_recommending_officer_a` FROM `cl_template_name` WHERE `id`='$clearanceTemplatee'"),0); $clRecB = mysql_result(mysql_query("SELECT `cl_recommending_officer_b` FROM `cl_template_name` WHERE `id`='$clearanceTemplatee'"),0); $clApp = mysql_result(mysql_query("SELECT `cl_approving_officer` FROM `cl_template_name` WHERE `id`='$clearanceTemplatee'"),0); //===================================================================================================================================================== //echo ''; mysql_query("UPDATE `cl_clearance_header` SET cl_hr_approval_id='$hrAuthID', search_ref_fname='$uFName',search_ref_lname='$uLName',search_ref_emp_id='$uEMPID',cl_h_template_id='$clearanceTemplatee', cl_h_emp_id='$SelEmpIDe', cl_h_comp_id='$empCompanye', cl_h_reason='$clearanceReasone', cl_h_reason_from='$reasonFrome', cl_h_reason_to='$reasonToe', cl_h_reason_notes='$empClearanceNotee', cl_date_hired='$empDateHirede', cl_emp_position='$employeePositione', cl_emp_designated='$empDesignatede', cl_unit_assignment='$empUnitAssignmente', cl_shared_services='$empSharedServicese', cl_rank='$clRank', cl_recommender_a_id='$clRecA', cl_recommender_b_id='$clRecB',cl_approver_id='$clApp', cl_h_employment_status='$employmentStatuse' WHERE `h_id`='$recordID'"); $getKeyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); //===================================================================================================================================================== mysql_query("UPDATE `cl_clearance_data` SET cl_comp_id='$empCompanye', cl_template_id='$clearanceTemplatee', `cl_hdr_id`='$recordID' WHERE `key_code`='$getKeyCode'"); exit(); } ?>