File manager

File manager - Edit - /home/autoph/public_html/connect/home/REPORTS/CL_REPORTG.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']; $gsDate = $_GET['gsDate']; $geDate = $_GET['geDate']; $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'>LIST OF DEFERRED CLEARANCE FORM</b>"; echo "<p style='padding:0px;margin:0px;margin-bottom:40px;font-family:Calibri;font-size:14px;'>Period Covered: ".$gsDate." - ".$geDate."</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:10%'>DATE CREATED</th>"; echo "<th style='text-align:left;font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:23%'>NAME OF EMPLOYEE</th>"; echo "<th style='text-align:left;font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:20%'>DEALERSHIP</th>"; echo "<th style='text-align:left;font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:15%'>POSITION</th>"; echo "<th style='text-align:left;font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:12%'>REASON</th>"; echo "<th style='text-align:left;font-family:Calibri;font-size:12px;color:white;background:black;padding:3px;width:13%'>STATUS</th>"; echo "</thead>"; $getCompany = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$gsDate' AND '$geDate' AND `cl_status`= 1 AND `cl_h_comp_id`='$comID' AND `cl_h_hr_approval`!='CLOSED' AND `cl_second_wave`='DEFERRED' ORDER BY `cl_h_date_created` ASC"); while($row = mysql_fetch_array($getCompany)){ $count = $count + 1; $selEmpID=$row['cl_h_emp_id']; $KeyCode=$row['key_code']; $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); $dealershipID = mysql_result(mysql_query("SELECT `dealer` FROM `vts_users` WHERE `u_id`='$selEmpID'"),0); $dealershipName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$dealershipID'"),0); $clApproverCount = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `key_code` ='$KeyCode' AND `cl_approver_id_a`!=0"),0); $clInSLA = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `key_code` ='$KeyCode' AND `cl_approver_id_a`!=0 AND `cl_approved_by_id`!= 0 AND `cl_actual_sla` < 4 AND `cl_actual_sla` != 0"),0); $clSigned = mysql_result(mysql_query("SELECT COUNT(`cl_id`) FROM `cl_clearance_data` WHERE `key_code` ='$KeyCode' AND `cl_approver_id_a`!=0 AND `cl_approved_by_id`!= 0 AND `cl_actual_sla` > 3 AND `cl_actual_sla` != 0"),0); echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>".strtoupper($row['cl_lastpay_released_date'])."</td>"; 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($dealershipName)."</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>".strtoupper($selPosition)."</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>".strtoupper($row['cl_h_reason'])."</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:3px;border:1px solid gray'>".strtoupper($row['cl_second_wave'])."</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 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings