File manager

File manager - Edit - /home/autoph/public_html/connect/home/REPORTS/CL_REPORTD.php

Back
<?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); $comID = $_GET['companyName']; $userID = $_GET['uID']; $ccsDate = $_GET['ccsDate']; $cceDate = $_GET['cceDate']; $compName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$comID'"),0); $FName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$userID'"),0); $LName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$userID'"),0); $title = $compName; ?> <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> <!--#########################################################################--> <script type="text/javascript"> ShowUploadBar(); </script> <?php 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'>".$title."</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='height:100px;width:850px;border:0px solid gray;padding:0px'>"; echo "<b style='font-family:Calibri;font-size:24px;color:black'>OFFICERS SLA COMPLIANCE REPORT<br>Company Level</b>"; echo "<p style='padding:0px;margin:0px;margin-bottom:40px;font-family:Calibri;font-size:14px;'>Period Covered: ".$ccsDate." - ".$cceDate."</p>"; echo "</div>"; echo "<div style='width:850px;border:0px solid red;padding:0px'>"; echo "<table style='border-collapse:collapse'>"; echo "<thead>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:30%'>NAME OF APPROVING OFFICERS</th>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:22%'>COMPANY</th>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:12%'>CLEARANCE SIGNED</th>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:12%'>COMPLIANT</th>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:12%'>NON-COMPLIANT</th>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:12%'>RATINGS</th>"; echo "</thead>"; $getCompany = mysql_query("SELECT * FROM `vts_users` WHERE `approver`= 1 AND `u_status`= 1 AND `company`='$comID' ORDER BY `u_lname` ASC"); while($row = mysql_fetch_array($getCompany)){ $count = $count + 1; $clSigned = 0; $clInSLA = 0; $clOutSLA = 0; $slaRate = 0; $selEmpID=$row['u_id']; $SelFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$selEmpID'"),0); $SelLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$selEmpID'"),0); $selPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$selEmpID'"),0); echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>".strtoupper($SelLName).", ".strtoupper($SelFName)."</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>".strtoupper($selPosition)."</td>"; echo "<td style='text-align:center;font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; $clSigned = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `cl_sla_start` BETWEEN '$ccsDate' AND '$cceDate' AND `cl_approved_by_id`='$selEmpID'"),0); echo $clSigned; echo "</td>"; echo "<td style='text-align:center;font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; $clInSLA = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `cl_sla_start` BETWEEN '$ccsDate' AND '$cceDate' AND `cl_approved_by_id`='$selEmpID' AND `cl_actual_sla` < 4 "),0); echo $clInSLA; echo "</td>"; echo "<td style='text-align:center;font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; $clOutSLA = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `cl_sla_start` BETWEEN '$ccsDate' AND '$cceDate' AND `cl_approved_by_id`='$selEmpID' AND `cl_actual_sla` > 3 "),0); echo $clOutSLA; echo "</td>"; echo "<td style='text-align:left;font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray;padding-left:20px'>"; $slaRate = ($clInSLA / $clSigned) * 100; $slaRateR = number_format($slaRate,2,'.','')." %"; echo $slaRateR; echo "</td>"; echo "</tr>"; } if($count < 1 ){ echo "<tr>"; echo "<td colspan='6' style='font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray;padding:20px;text-align:center'> -- NO RECORD FOUND -- --</td>"; echo "</tr>"; } echo "<table>"; //################################################################################################################################ echo "<div style='width:850px;border:0px solid gray;padding:0px'>"; echo "<table style='width:100%'><tr style='background:white'>"; echo "<td colspan='4' style='text-align:left;background:white;font-family:Calibri;font-size:14px;color:black;padding:25px' >Prepared by: ".$FName." ".$LName."</td>"; echo "</tr></table>"; echo "</div>"; //################################################################################################################################ echo "</div>"; echo "</center>"; ?> <script type="text/javascript"> ShowUploadBar(); </script>

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