File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_REPORTA.PHP

Back
<html> <head> <style> .tBalls{ font-familyly:Arial; font-size:12px; font-weight:bold; padding:5px border:0px solid gray; background:lightgray; } </style> </head> <script type="text/javascript"> function ShowUploadBar() { var div = document.getElementById("loadBaraData"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none' } } </script> <!--#########################################################################--> <div id="loadBaraData" style="display:none;position:absolute;top:50%;left:35%;width:30%;padding:5px;padding-left:2px;padding-right:2px;height:80px;background:transparent;z-index:9999;border:0px solid gray;z-index:999999999999999999"> <div id="uploadBar" style="font-familyly:Calibri;font-size:14px;color:red;text-align:center;margin-top:0px;background:white;display:block;width:100%;height:50px;border:0px solid red;position:relative;left:5px;padding:5px;z-index:999999999999999999;border:0px solid orange"> <img src='../images/ajaxLoader.gif' width="100%" height="20px" /><br><center>Loading Data...<center></div> </div> <!--#########################################################################--> <?php date_default_timezone_set('Asia/Singapore'); //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee10244') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); $connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; mysql_connect('localhost','autoph_arnel','Hke@2001') or die ($connect_error); mysql_select_db('autoph_connect') or die($connect_error); error_reporting(0); $getID = $_POST['id']; $myDate = date_create() ->format("m/d/YYYY"); //echo "Active ID :".$activeID; ?> <script type="text/javascript"> ShowUploadBar(); </script> <?php $getEMPID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $keyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $hdrTemplate = mysql_result(mysql_query("SELECT `cl_h_template_id` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $compID = mysql_result(mysql_query("SELECT `company` FROM `vts_users` WHERE `u_id`='$getEMPID'"),0); $compName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$compID'"),0); $FName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getEMPID'"),0); $LName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getEMPID'"),0); $DealerID = mysql_result(mysql_query("SELECT `company` FROM `vts_users` WHERE `u_id`='$getEMPID'"),0); $DealerName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$DealerID'"),0); $emailAdd = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$getEMPID'"),0); $uPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$getEMPID'"),0); $MobileNo = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$getEMPID'"),0); $clReasonX = mysql_result(mysql_query("SELECT `cl_h_reason` FROM `cl_clearance_header` WHERE `key_code`='$keyCode'"),0); $dateCreated = mysql_result(mysql_query("SELECT `cl_h_date_created` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $empStatus = mysql_result(mysql_query("SELECT `cl_h_employment_status` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $empNo = mysql_result(mysql_query("SELECT `search_ref_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $EmpDateHired = mysql_result(mysql_query("SELECT `cl_date_hired` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $empTitle = mysql_result(mysql_query("SELECT `cl_emp_position` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $empWorkingTitle = mysql_result(mysql_query("SELECT `cl_emp_designated` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $empUnitAssignment = mysql_result(mysql_query("SELECT `cl_unit_assignment` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $empSharedServices = mysql_result(mysql_query("SELECT `cl_shared_services` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); //$empWorkingTitle = mysql_result(mysql_query("SELECT `company` FROM `cl_clearance_header` WHERE `u_id`='$getID'"),0); $EffectivityDate = mysql_result(mysql_query("SELECT `cl_effectivity_date` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $clFrom = mysql_result(mysql_query("SELECT `cl_h_reason_from` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $clTo = mysql_result(mysql_query("SELECT `cl_h_reason_to` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); switch($empStatus){ case 'REG': $clPosition = 'Regular'; break; case 'PRO': $clPosition = 'Probationary'; break; case 'CTR': $clPosition = 'Contractual'; break; case 'PRJ': $clPosition = 'Project Based'; break; case 'CON': $clPosition = 'CONSULTANT'; break; } echo "<center>"; echo "<div style='width:850px;height:120px;border-bottom:0px solid gray;background:white;text-align:left'>"; echo "<div style='float:left;width:50%;height:130px;border-bottom:0px solid gray;background:white;text-align:left'>"; echo "<img src='../images/autohub_logo_2016.png' border='0px solid blue' style='margin:5%'></img>"; echo "</div>"; echo "<div style='float:left;width:50%;height:130px;border:0px solid gray;background:white;text-align:right;'>"; echo "<p style='font-familyly:Arial;font-size:20px;font-weight:bold;padding:5%;padding-bottom:0px;border:0px solid red;margin-bottom:5px;'>EMPLOYEE CLEARANCE FORM</p> <b style='font-familyly:Arial;font-size:16px;font-weight:normal;padding:5%;padding-top:0px;padding-bottom:0px;margin-top:0px;border:0px solid red'>".$compName."</b>"; echo " <b style='font-familyly:Arial;font-size:14px;font-weight:normal;padding-right:5%;padding-top:0px;padding-bottom:0px;margin-top:10px;border:0px solid red'> <br>Date: ".date("m/d/Y")."</b>"; echo "</div>"; echo "</div>"; //############################################################################################### echo "<div style='min-height:200px;width:850px;border:0px solid gray;padding:0px'>"; echo "<table style='width:100%;border-collapse:collapse'>"; echo "<tr style='background:white'>"; echo "<td colspan='7' style='height:20px;border:0px solid white;border-top:1px solid gray;'></td>"; echo "</tr>"; echo "<tr style='background:white'>"; echo "<td colspan='2' style='background:white;border:0px;width:20%;font-family:Yu Gothic Light;font-size:12px;text-align:right'>NAME OF EMPLOYEE:</td>"; echo "<td style='background:white;border:0px;width:35%;border-bottom:0px solid gray;font-family:Calibri;font-size:12px;font-weight:bold;text-align:left;padding-left:10px;padding-bottom:0px;'>".strtoupper($FName ." ".$LName)."</td>"; echo "<td style='background:white;border:0px;width:10%;font-family:Yu Gothic Light;font-size:12px;text-align:left;padding-left:10px;'>EMP. ID NO:</td>"; echo "<td style='background:white;border:0px;width:12%;border-bottom:0px solid gray;font-family:Calibri;font-size:12px;font-weight:bold;text-align:left;padding-left:10px;padding-bottom:0px;'>".$empNo ."</td>"; echo "<td style='background:white;border:0px;width:10%;font-family:Yu Gothic Light;font-size:12px;text-align:right'>DATE HIRED:</td>"; echo "<td style='background:white;border:0px;width:12%;border-bottom:1px solid gray;font-family:Calibri;font-size:12px;font-weight:bold;text-align:left;padding-left:10px;padding-bottom:0px;'>".$EmpDateHired."</td>"; echo "</tr>"; echo "<tr style='background:white'>"; echo "<td colspan='2' style='padding:5px;background:white;border:0px solid red;font-family:Yu Gothic Light;font-size:12px;text-align:right'>POSITION TITLE:</td>"; echo "<td style='padding:5px;background:white;border:0px solid red;border-bottom:1px solid gray;font-family:Calibri;font-size:12px;font-weight:bold;text-align:left;padding-left:10px;padding-bottom:0px;'>".strtoupper($uPosition)."</td>"; echo "<td colspan='2' style='padding:5px;background:white;border:0px solid red;font-family:Yu Gothic Light;font-size:12px;text-align:left;padding-left:10px;'>EMP. STATUS:</td>"; echo "<td colspan='3' style='padding:5px;background:white;border:0px solid red;border-bottom:1px solid gray;font-family:Calibri;font-size:12px;font-weight:bold;text-align:left;padding-left:10px;padding-bottom:0px;'>".strtoupper($clPosition)."</td>"; echo "</tr>"; echo "<tr style='background:white'>"; echo "<td colspan='2' style='padding:5px;background:white;border:0px solid red;font-family:Yu Gothic Light;font-size:12px;text-align:right'>COMPANY NAME:</td>"; echo "<td style='padding:5px;background:white;border:0px solid red;border-bottom:1px solid gray;font-family:Calibri;font-size:12px;font-weight:bold;text-align:left;padding-left:10px;padding-bottom:0px;'>".strtoupper($compName)."</td>"; echo "<td colspan='2' style='padding:5px;background:white;border:0px solid red;font-family:Yu Gothic Light;font-size:12px;text-align:left;padding-left:10px;'>DESIGNATION:</td>"; echo "<td colspan='3' style='padding:5px;background:white;border:0px solid red;border-bottom:1px solid gray;font-family:Calibri;font-size:12px;font-weight:bold;text-align:left;padding-left:10px;padding-bottom:0px;'>".strtoupper($empWorkingTitle)."</td>"; echo "</tr>"; echo "<tr style='background:white'>"; echo "<td colspan='2' style='padding:5px;background:white;border:0px solid red;font-family:Yu Gothic Light;font-size:12px;text-align:right'>UNIT ASSIGNMENT:</td>"; echo "<td style='padding:5px;background:white;border:0px solid red;border-bottom:1px solid gray;font-family:Calibri;font-size:12px;font-weight:bold;text-align:left;padding-left:10px;padding-bottom:0px;'>".strtoupper($empUnitAssignment)."</td>"; echo "<td colspan='2' style='padding:5px;background:white;border:0px solid red;font-family:Yu Gothic Light;font-size:12px;text-align:left;padding-left:10px;'>SHARED SERVICES:</td>"; echo "<td colspan='3' style='padding:5px;background:white;border:0px solid red;border-bottom:1px solid gray;font-fami:Calibri;font-size:12px;font-weight:bold;text-align:left;padding-left:10px;padding-bottom:0px;'>".strtoupper($empSharedServices)."</td>"; echo "</tr>"; echo "<tr style='background:white'>"; echo "<td colspan='2' style='padding:5px;background:white;border:0px solid red;font-family:Yu Gothic Light;font-size:12px;text-align:right'>REASON :</td>"; echo "<td style='padding:5px;background:white;border:0px solid red;border-bottom:1px solid gray;font-family:Calibri;font-size:12px;font-weight:bold;text-align:left;padding-left:10px;padding-bottom:0px;'> ". $clReasonX ."</td>"; echo "<td colspan='2' style='padding:5px;background:white;border:0px solid red;font-family:Yu Gothic Light;font-size:12px;text-align:left;padding-left:10px;'>EFFECTIVITY DATE:</td>"; echo "<td colspan='3' style='padding:5px;background:white;border:0px solid red;border-bottom:1px solid gray;font-fami:Calibri;font-size:12px;font-weight:bold;text-align:left;padding-left:10px;padding-bottom:0px;'>".strtoupper($EffectivityDate)."</td>"; echo "</tr>"; echo "<tr style='background:white'>"; echo "<td colspan=7>xxx</td>"; echo "</tr>"; echo "</table>"; echo "</div>"; echo "<div style='min-height:700px;width:850px;border:1px solid gray;padding:0px'>"; echo "<table style='width:100%;border-collapse:collapse'>"; echo "<thead style='background:white'>"; echo "<th colspan='6' style='background:black;font-family:Calibri;font-size:14px;color:white;padding:5px'>ORGANIZATIONAL UNIT/DEALERSHIP/COMPANY CLEARANCE</th>"; echo "</thead>"; echo "<tr>"; echo "<td rowspan='2' style='text-align:center;font-family:Yu Gothic Light;font-size:12px;width:23%;padding:2px;border:1px solid gray;background:lightgray'>ACCOUNTABILITY AREAS</td>"; echo "<td colspan='2' style='text-align:center;font-family:Yu Gothic Light;font-size:12px;width:35%;padding:2px;border:1px solid gray;background:lightgray'>CLEARANCE OFFICERS</td>"; echo "<td colspan='2' style='text-align:center;font-family:Yu Gothic Light;font-size:12px;width:24%;padding:2px;border:1px solid gray;background:lightgray'>DATE</td>"; echo "<td rowspan='2' style='text-align:center;font-family:Yu Gothic Light;font-size:12px;width:18%;padding:2px;border:1px solid gray;background:lightgray'>REMARKS</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='text-align:center;font-family:Yu Gothic Light;font-size:12px;width:23%;padding:2px;border:1px solid gray;background:lightgray'>OFFICER NAME</td>"; echo "<td style='text-align:center;font-family:Yu Gothic Light;font-size:12px;width:12%;padding:2px;border:1px solid gray;background:lightgray'> STATUS</td>"; echo "<td style='text-align:center;font-family:Yu Gothic Light;font-size:12px;width:12%;padding:2px;border:1px solid gray;background:lightgray'>RECEIVED DATE</td>"; echo "<td style='text-align:center;font-family:Yu Gothic Light;font-size:12px;width:12%;padding:2px;border:1px solid gray;background:lightgray'>DATE SIGNED</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='6' style='width:100%;background:white;'>"; $aprDiv = mysql_query("SELECT * FROM `cl_approving_division` WHERE `cl_div_status` = 1 ORDER BY `id` ASC"); echo "<table style='width:100%;border-collapse:collapse'>"; while($dRow = mysql_fetch_array($aprDiv)){ $uCount = 0; $padding ='5px'; $divID = $dRow['id']; $counter = $counter + 1; //$getID echo "<tr> <td style='background:#fdfaf9;magin:0px;padding:0px;border:0px solid gray;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'>   ".$counter."   ".$dRow['cl_div_name']; //========================================================= //========================================================= $getUnitData = mysql_query("SELECT * FROM `cl_approving_unit` WHERE `cl_div_id`='$divID' ORDER BY `cl_order` ASC"); echo "<table style='width:100%;border-collapse:collapse;margin:0px;padding:0px'>"; while($uRow = mysql_fetch_array($getUnitData)){ $unitID = $uRow['id']; $uCount = $uCount + 1; echo "<tr>"; echo"<td style='width:23%;background: #ffffff ;magin:0px;padding:0px;padding-left:$padding;border:1px solid gray;font-family:Yu Gothic Light;font-size:12px;font-weight:normal'>"; echo $counter .".".$uCount."   ".$uRow['cl_unit_name']; echo "</td>"; echo"<td style='width:23%;background: #ffffff ;magin:0px;padding:0px;padding-left:$padding;border:1px solid gray;font-family:Yu Gothic Light;font-size:10px;font-weight:normal'>"; $getSignatory = mysql_result(mysql_query("SELECT `cl_approver_id_a` FROM `cl_clearance_data` WHERE `key_code`='$keyCode' AND `cl_template_id`='$hdrTemplate' AND `cl_div_id`='$divID' AND `cl_unit_id`='$unitID'"),0); $getSignatoryFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getSignatory'"),0); $getSignatoryLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getSignatory'"),0); echo strtoupper($getSignatoryLName.', '.$getSignatoryFName); echo "</td>"; echo"<td style='width:12%;background: #ffffff ;magin:0px;padding:0px;padding-left:$padding;border:1px solid gray;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:center'>"; $getDateSigned = mysql_result(mysql_query("SELECT `cl_approved_date` FROM `cl_clearance_data` WHERE `key_code`='$keyCode' AND `cl_template_id`='$hdrTemplate' AND `cl_div_id`='$divID' AND `cl_unit_id`='$unitID'"),0); $getTimeSigned = mysql_result(mysql_query("SELECT `cl_approved_time` FROM `cl_clearance_data` WHERE `key_code`='$keyCode' AND `cl_template_id`='$hdrTemplate' AND `cl_div_id`='$divID' AND `cl_unit_id`='$unitID'"),0); if($getDateSigned !='' AND $getTimeSigned !=''){ echo "Signed & Cleared"; }else{ echo "-"; } echo "</td>"; echo"<td style='width:12%;background: #ffffff ;magin:0px;padding:0px;padding-left:$padding;border:1px solid gray;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:center'>"; $getReceived = mysql_result(mysql_query("SELECT `cl_sla_start` FROM `cl_clearance_data` WHERE `key_code`='$keyCode' AND `cl_template_id`='$hdrTemplate' AND `cl_div_id`='$divID' AND `cl_unit_id`='$unitID'"),0); echo $getReceived; echo "</td>"; echo"<td style='width:12%;background: #ffffff ;magin:0px;padding:0px;padding-left:$padding;border:1px solid gray;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:center'>"; $getDateSigned = mysql_result(mysql_query("SELECT `cl_approved_date` FROM `cl_clearance_data` WHERE `key_code`='$keyCode' AND `cl_template_id`='$hdrTemplate' AND `cl_div_id`='$divID' AND `cl_unit_id`='$unitID'"),0); echo $getDateSigned; echo "</td>"; echo"<td style='width:18%;background: #ffffff ;magin:0px;padding:0px;padding-left:$padding;border:1px solid gray;font-family:Yu Gothic Light;font-size:11px;font-weight:normal'>"; echo "</td>"; echo "</tr>"; } //========================================================= //========================================================= echo "</td></tr>"; echo "</table>"; } echo "</table>"; echo "</td>"; echo "</tr>"; echo "</table>"; //################################################################################################################################ //################################################################################################################################ $aprEndorserA = mysql_result(mysql_query("SELECT `cl_recommender_a_id` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $endorserAFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprEndorserA'"),0); $endorserALName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprEndorserA'"),0); $endorserAPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$aprEndorserA'"),0); $dateEndorsedA = mysql_result(mysql_query("SELECT `cl_recommender_a_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $aprEndorserB = mysql_result(mysql_query("SELECT `cl_recommender_b_id` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $endorserBFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprEndorserB'"),0); $endorserBLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprEndorserB'"),0); $endorserBPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$aprEndorserB'"),0); $dateEndorsedB = mysql_result(mysql_query("SELECT `cl_recommender_b_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $aprApprover = mysql_result(mysql_query("SELECT `cl_approver_id` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $aprApproverFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprApprover'"),0); $aprApproverLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprApprover'"),0); $aprApproverPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$aprApprover'"),0); $dateApproved = mysql_result(mysql_query("SELECT `cl_approver_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $aprApproverB = mysql_result(mysql_query("SELECT `cl_approver_id_b` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); $aprApproverBFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprApproverB'"),0); $aprApproverBLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprApproverB'"),0); $aprApproverBPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$aprApproverB'"),0); $dateApprovedB = mysql_result(mysql_query("SELECT `cl_approver_id_b_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0); echo "<div style='min-height:200px;width:850px;border:0px solid gray;padding:0px'>"; echo "<table style='width:100%;border-collapse:collapse'>"; echo "<thead style='background:white'>"; echo "<th colspan='4' style='background:black;font-family:Calibri;font-size:14px;color:white;padding:5px'>RECOMMENDED FOR CLEARANCE</th>"; echo "</thead>"; echo "<tr style='background:white'>"; echo "<td colspan='4' style='background:white;font-family:Calibri;font-size:14px;color:black;padding:25px' >This is to recommend the approval of clearance of <b>   ".strtoupper($FName.' ' .$LName)."    </b> having complied with all clearance requirements. </td>"; echo "</tr>"; echo "<tr style='background:white'>"; echo "<td colspan='4' style='background:white;font-family:Calibri;font-size:13px;color:black;padding:10px'>"; echo "<div style='width:25%;float:left;padding:10px;margin:5px;text-align:center'> <input type='text' readonly value='".strtoupper($endorserAFName." " .$endorserALName)."' style='text-align:center;width:100%;background:white;border:1px solid white;border-bottom:1px solid gray'> <br>".$endorserAPosition."</div>"; echo "<div style='width:15%;float:left;padding:10px;margin:5px;text-align:center'> <input type='text' readonly value='".$dateEndorsedA."' style='text-align:center;width:100%;background:white;border:1px solid white;border-bottom:1px solid gray;font-family:Calibri;font-size:12px'> <br>DATE ENDORSED</div>"; echo "<div style='width:25%;float:left;padding:10px;margin:5px;text-align:center'> <input type='text' readonly value='".strtoupper($endorserBFName." " .$endorserBLName)."' style='text-align:center;width:100%;background:white;border:1px solid white;border-bottom:1px solid gray'> <br>".$endorserBPosition."</div>"; echo "<div style='width:15%;float:left;padding:10px;margin:5px;text-align:center'> <input type='text' readonly value='".$dateEndorsedB."' style='text-align:center;width:100%;background:white;border:1px solid white;border-bottom:1px solid gray;font-family:Calibri;font-size:12px'> <br>DATE ENDORSED</div>"; echo "</td>"; echo "</tr>"; echo "<thead style='background:white'>"; echo "<th colspan='4' style='background:black;font-family:Calibri;font-size:14px;color:white;padding:5px'>APPROVED FOR CLEARANCE</th>"; echo "</thead>"; echo "<tr style='background:white'>"; echo "<td colspan='4' style='background:white;font-family:Calibri;font-size:14px;color:black;padding:25px' >This is to certify that <b>   ".strtoupper($FName.' ' .$LName)."    </b> is cleared of all accountabilities with __________________ under the AUTOHUB Group</td>"; echo "</tr>"; echo "<tr style='background:white'>"; echo "<td colspan='4' style='background:white;font-family:Calibri;font-size:13px;color:black;padding:10px'>"; echo "<div style='width:25%;float:left;padding:10px;margin:5px;text-align:center'> <input type='text' readonly value='".strtoupper($aprApproverFName." " .$aprApproverLName)."' style='text-align:center;width:100%;background:white;border:1px solid white;border-bottom:1px solid gray'> <br>".$aprApproverPosition."</div>"; echo "<div style='width:15%;float:left;padding:10px;margin:5px;text-align:center'> <input type='text' readonly value='".$dateApproved."' style='text-align:center;width:100%;background:white;border:1px solid white;border-bottom:1px solid gray;font-family:Calibri;font-size:12px'> <br>DATE APPROVED</div>"; echo "<div style='width:25%;float:left;padding:10px;margin:5px;text-align:center'> <input type='text' readonly value='".strtoupper($aprApproverBFName." " .$aprApproverLFName)."' style='text-align:center;width:100%;background:white;border:1px solid white;border-bottom:1px solid gray'> <br>".$aprApproverBPosition."</div>"; echo "<div style='width:15%;float:left;padding:10px;margin:5px;text-align:center'> <input type='text' readonly value='".$dateApprovedB."' style='text-align:center;width:100%;background:white;border:1px solid white;border-bottom:1px solid gray;font-family:Calibri;font-size:12px'> <br>DATE APPROVED</div>"; echo "</td>"; echo "</tr>"; echo "</table>"; echo "</div>"; //################################################################################################################################ //################################################################################################################################ echo "</div>"; echo "<table><tr style='background:white'>"; echo "<td colspan='4' style='background:white;font-family:Calibri;font-size:14px;color:black;padding:25px' >This is a system generated report from Autohub Connect, signature might not be required.</td>"; echo "</tr></table>"; echo "</center>"; ?> <script type="text/javascript"> ShowUploadBar(); </script>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings