❖   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'])){ $ClearanceHdrID = mysql_escape_string($_POST['ClearanceDataID']); $addByUID = mysql_escape_string($_POST['addByUID']); //$ActionSlip = mysql_escape_string($_POST['ActionSlip']); $myKeyCode=mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE `h_id`='$ClearanceHdrID'"),0); $empUID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$ClearanceHdrID'"),0); //mysql_query("INSERT INTO cl_action_slip_data(cl_hdr_id, cl_key_code, cl_emp_id, cl_request_by_id, cl_slip_info, cl_slip_date, cl_slip_time) //VALUES('{$ClearanceHdrID}','{$myKeyCode}','{$empUID}','{$addByUID}','{$actionSlipAction}','{$myDate}','{$toTime}')"); //SEND EMAIL AND SMS NOTIFICATION HERE... echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $myCL=mysql_query("SELECT DISTINCT(cl_div_id) FROM `cl_clearance_data` WHERE `key_code`='$myKeyCode' ORDER BY `cl_div_id` ASC"); while($cRow = mysql_fetch_array($myCL)){ $divID = $cRow['cl_div_id']; $divName = mysql_result(mysql_query("SELECT `cl_div_name` FROM `cl_approving_division` WHERE `id`='$divID'"),0); echo ""; echo ""; echo ""; } echo "

ACCOUNTABILITY AREAS	APPROVING OFFICER	STATUS	DATE SIGNED	TIME SIGNED	ACTION SLIP
".$cRow['cl_div_id'].".    ".strtoupper($divName); //echo $myKeyCode. " | ".$divID; $myCLU=mysql_query("SELECT * FROM `cl_clearance_data` WHERE `key_code`='$myKeyCode' AND `cl_div_id`='$divID' ORDER BY `cl_unit_id` ASC"); echo ""; while($uRow=mysql_fetch_array($myCLU)){ $countUnit=$countUnit+1; $unitID = $uRow['cl_unit_id']; $aprID = $uRow['cl_approver_id_a']; $aprByID = $uRow['cl_approved_by_id']; $unitName = mysql_result(mysql_query("SELECT `cl_unit_name` FROM `cl_approving_unit` WHERE `id`='$unitID'"),0); ?>".$divID.".".$countUnit."   ".$unitName.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo " "; if($aprID != '0'){ $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprID'"),0); $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprID'"),0); echo strtoupper($uLName).", ".strtoupper($uFName); }else{ echo "N/A"; } echo " "; if($uRow['cl_approved_date']!=''){ echo "CLEARED"; }else{ if($aprID != '0'){ echo "PENDING"; }else{ echo "N/A"; } } echo" "; if($uRow['cl_approved_date']!=''){ echo $uRow['cl_approved_date']; }else{ echo "--:--:--"; } echo " "; if($uRow['cl_approved_time']!=''){ echo $uRow['cl_approved_time']; }else{ echo "--:--:--"; } echo " "; $withAction = mysql_result(mysql_query("SELECT COUNT(id) FROM `cl_action_slip_data` WHERE `cl_key_code`='$myKeyCode' AND `cl_request_by_id`='$aprID'"),0); if($withAction > 0 ){ echo "ACTION REQUIRED"; }else{ echo "✓"; } echo " ".$uRow['cl_id']." "; $countUnit=0; echo "

"; exit(); } ?>