File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_REPORTB.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['cID']; $userID = $_GET['uID']; $sDate = $_GET['sDate']; $eDate = $_GET['eDate']; $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); if($_GET['AutohubWide']==='No'){ $title = $compName; }else{ $title = "AUTOHUB WIDE"; } ?> <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:80px;width:850px;border:0px solid gray;padding:0px'>"; echo "<b style='font-family:Calibri;font-size:24px;color:black'>EXECUTIVE SUMMARY REPORT</b>"; echo "<p style='padding:0px;margin:0px;margin-bottom:40px;font-family:Calibri;font-size:14px;'>Period Covered: ".$sDate." - ".$eDate."</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:34%'>COMPANY NAME</th>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:11%'>CLEARANCE CREATED</th>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:11%'>CLEARANCE RELEASED</th>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:11%'>ON-GOING</th>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:11%'>DEFERRED</th>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:11%'>READY FOR RELEASE</th>"; echo "<th style='font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:11%'>SLA COMPLIANCE</th>"; echo "</thead>"; $gTotal = 0; $gReleased = 0; $gOnGoing = 0; $gDeferred = 0; $gReady = 0; $slagRate = 0; $slagOK = 0; $getCompany = mysql_query("SELECT * FROM `vts_company` WHERE `comp_status`=1 ORDER BY `comp_name` ASC"); while($row = mysql_fetch_array($getCompany)){ $clCreated=0; $clReleased = 0; $clTotal = 0; $clOngoing = 0; $clDeferred=0; $clReady=0; $selCompID=$row['comp_id']; $counter = $counter + 1; echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>".strtoupper($row['comp_name'])."</td>"; echo "<td style='text-align:center;font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; $clCreated = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID'"),0); echo $clCreated; $gTotal = $gTotal + $clCreated; echo "</td>"; echo "<td style='text-align:center;font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; $clTotal = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_h_hr_approval`='CLOSED'"),0); echo $clTotal; $gReleased = $gReleased + $clTotal; echo "</td>"; echo "<td style='text-align:center;font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; $clOngoing = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_h_hr_approval`!='CLOSED'"),0); echo $clOngoing; $gOnGoing = $gOnGoing + $clOngoing; echo "</td>"; echo "<td style='text-align:center;font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; $clDeferred = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_second_wave` = 'DEFERRED'"),0); echo $clDeferred; $gDeferred = $gDeferred + $clDeferred; echo "</td>"; echo "<td style='text-align:center;font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; $clReady= mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_h_hr_approval` = 'READY FOR RELEASE'"),0); echo $clReady; $gReady = $gReady + $clReady; echo "</td>"; echo "<td style='padding:3px;text-align:left;padding-left:20px;font-family:Calibri;font-size:12px;color:black;border:1px solid gray'>"; $slaOK = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_consumed_days` < 31"),0); $slaIsNot = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_consumed_days` > 30"),0); $slaRatings= ($slaOK / $clCreated) * 100; $slaRate = number_format($slaRatings,2,'.','')." %"; echo $slaRate; $slagOK = $slagOK + $slaOK; echo "</td>"; echo "</tr>"; } echo "<tr>"; echo "<td style='background:lightgray;font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'></td>"; echo "<td style='background:lightgray;text-align:center;font-family:Calibri;font-weight:bold;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; echo $gTotal; echo "</td>"; echo "<td style='background:lightgray;text-align:center;font-family:Calibri;font-weight:bold;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; echo $gReleased; echo "</td>"; echo "<td style='background:lightgray;text-align:center;font-family:Calibri;font-weight:bold;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; echo $gOnGoing ; echo "</td>"; echo "<td style='background:lightgray;text-align:center;font-family:Calibri;font-weight:bold;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; $clDeferred = mysql_result(mysql_query("SELECT COUNT(`h_id`) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$sDate' AND '$eDate' AND `cl_h_comp_id`='$selCompID' AND `cl_second_wave` = 'DEFERRED'"),0); echo $clDeferred; $gDeferred = $gDeferred + 1; echo "</td>"; echo "<td style='background:lightgray;text-align:center;font-family:Calibri;font-weight:bold;font-size:12px;color:black;padding:3px;border:1px solid gray'>"; echo $gReady; echo "</td>"; echo "<td style='background:lightgray;padding:3px;text-align:left;padding-left:20px;font-family:Calibri;font-weight:bold;font-size:12px;color:black;border:1px solid gray'>"; $mySLA = number_format((($slagOK / $gTotal) * 100),2, '.','') . " %"; echo $mySLA; echo "</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 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings