File manager

File manager - Edit - /home/autoph/public_html/voc/home/REPORTS/RPT_REPORTE.php

Back
<html> <head> <style> .tBalls{ font-family:Arial; font-size:12px; font-weight:bold; padding:5px border:1px solid gray; background:lightgray; } </style> </head> <?php date_default_timezone_set('Asia/Singapore'); $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); session_start(); $activeID = ($_SESSION[ActiveID]); //echo "Active ID :".$activeID; $brand=$_GET['agingBrandList']; $filCompany=$_GET['paraModelE']; $range =$_GET['ageRange']; switch($range){ case 'A': $ageRange="List of units below 90 Days"; break; case 'B': $ageRange="List of units between 91 to 180 Days"; break; case 'C': $ageRange="List of units above 180 Days"; break; } // $brandName = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='$brand'"),0); echo "<center><div style='width:950px;min-height:1000px;border:0px solid gray;background:white;padding:10px'>"; echo "<div style='width:850px;height:150px;border-bottom:0px solid gray;background:white;text-align:left'>"; echo "<div style='float:left;width:50%;height:150px;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:150px;border:0px solid gray;background:white;text-align:right;'>"; echo "<p style='font-family:Arial;font-size:20px;font-weight:bold;padding:5%;padding-bottom:0px;border:0px solid red;margin-bottom:5px;'>VEHICLE INVENTORY REPORT</p> <b style='font-family:Arial;font-size:16px;font-weight:normal;padding:5%;padding-top:0px;padding-bottom:0px;margin-top:0px;border:0px solid red'>UNIT AGING SUMMARY LIST </b>"; echo "<br><b style='font-family: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><p style='font-family:Arial;font-size:20;font-weight:bold'>".$brand."</p>"; echo "<p style='font-family:Arial;font-size:18px;color:blue;text-align:left;margin:5px;font-weight:bold'>".$ageRange."</p> <table style='border-collapse:collapse;width:100%'>"; echo "<thead>"; echo "<th class='tBalls' style='font-family:Arial;font-size:12px;font-weight:bold;padding:5px;border:1px solid gray;width:20%'>VEHICLE MODEL/VARIANT</th>"; echo "<th class='tBalls' style='font-family:Arial;font-size:12px;font-weight:bold;padding:5px;border:1px solid gray;width:30%'>UNIT DESCRIPTION</th>"; echo "<th class='tBalls' style='font-family:Arial;font-size:12px;font-weight:bold;padding:5px;border:1px solid gray;width:10%'>DATE RECEIVED</th>"; echo "<th class='tBalls' style='font-family:Arial;font-size:12px;font-weight:bold;padding:5px;border:1px solid gray;width:20%'>COLOR</th>"; echo "<th class='tBalls' style='font-family:Arial;font-size:12px;font-weight:bold;padding:5px;border:1px solid gray;width:10%'>CS NUMBER</th>"; echo "<th class='tBalls' style='font-family:Arial;font-size:12px;font-weight:bold;padding:5px;border:1px solid gray;width:10%'>AGING</th>"; echo "</thead>"; $myLineModel = mysql_query("SELECT * FROM `db_vehicle_inventory` WHERE `sold`='0' AND `returned`='0' AND `company`='$filCompany' AND `brand`='$brand' ORDER BY `brand_code` ASC"); while($xRow=mysql_fetch_array($myLineModel)){ $totalItemCount = $totalItemCount + 1; $olddate = TRIM($xRow['date_received']); $now = time(); // or your date as well' $your_date = strtotime($olddate); $datediff = $now - $your_date; $totalCount=round($datediff / (60 * 60 * 24)); if($range ==='A'){ if($totalCount < 91){ $GrnTotalItemCount = $GrnTotalItemCount + 1; $GrnlessNinety = $GrnlessNinety + $lessNinety; $GrnbetweenNinetyOneEighty = $GrnbetweenNinetyOneEighty + $betweenNinetyOneEighty; $GrnoldestUnit = $GrnoldestUnit + $oldestUnit; $GrnNewUnit = $GrnNewUnit + $NewUnit ; echo "<tr>"; echo "<td style='padding:5px;border:1px solid gray;text-align:left;background:white;font-family:Arial;font-size:12px'>".$xRow['brand_code']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:left;background:white;font-family:Arial;font-size:12px'>".$xRow['description']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:center;background:white;font-family:Arial;font-size:12px'>".$xRow['date_received']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:left;background:white;font-family:Arial;font-size:12px'>".$xRow['color']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:center;background:white;font-family:Arial;font-size:12px'>".$xRow['cs_number']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:center;background:white;font-family:Arial;font-size:12px'>".$totalCount."</td>"; echo "</tr>"; } } if($range ==='B'){ if ($totalCount > 90 && $totalCount < 181){ $GrnTotalItemCount = $GrnTotalItemCount + 1; $GrnlessNinety = $GrnlessNinety + $lessNinety; $GrnbetweenNinetyOneEighty = $GrnbetweenNinetyOneEighty + $betweenNinetyOneEighty; $GrnoldestUnit = $GrnoldestUnit + $oldestUnit; $GrnNewUnit = $GrnNewUnit + $NewUnit ; echo "<tr>"; echo "<td style='padding:5px;border:1px solid gray;text-align:left;background:white;font-family:Arial;font-size:12px'>".$xRow['brand_code']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:left;background:white;font-family:Arial;font-size:12px'>".$xRow['description']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:center;background:white;font-family:Arial;font-size:12px'>".$xRow['date_received']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:left;background:white;font-family:Arial;font-size:12px'>".$xRow['color']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:center;background:white;font-family:Arial;font-size:12px'>".$xRow['cs_number']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:center;background:white;font-family:Arial;font-size:12px'>".$totalCount."</td>"; echo "</tr>"; } } if($range ==='C'){ if ($totalCount > 180 ){ $GrnTotalItemCount = $GrnTotalItemCount + 1; $GrnlessNinety = $GrnlessNinety + $lessNinety; $GrnbetweenNinetyOneEighty = $GrnbetweenNinetyOneEighty + $betweenNinetyOneEighty; $GrnoldestUnit = $GrnoldestUnit + $oldestUnit; $GrnNewUnit = $GrnNewUnit + $NewUnit ; echo "<tr>"; echo "<td style='padding:5px;border:1px solid gray;text-align:left;background:white;font-family:Arial;font-size:12px'>".$xRow['brand_code']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:left;background:white;font-family:Arial;font-size:12px'>".$xRow['description']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:center;background:white;font-family:Arial;font-size:12px'>".$xRow['date_received']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:left;background:white;font-family:Arial;font-size:12px'>".$xRow['color']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:center;background:white;font-family:Arial;font-size:12px'>".$xRow['cs_number']."</td>"; echo "<td style='padding:5px;border:1px solid gray;text-align:center;background:white;font-family:Arial;font-size:12px'>".$totalCount."</td>"; echo "</tr>"; } } } echo "<tr>"; echo "<td colspan='4' style='padding:5px;border:1px solid gray;text-align:right;background:lightgray'> TOTAL</td>"; echo "<td colspan='3' style='padding:5px;border:1px solid gray;text-align:center;background:lightgray'>".$GrnTotalItemCount."</td>"; echo "</tr>"; echo "</table>"; echo "<br><br><br> <div style='width:100%;float:left;text-align:left'>Prepared by:_______________________</div>"; echo "<br><br><p style='float:left;text-align:left'>Date Prepared: ".date("m/d/Y")." ".date('h:i a')."</p>"; echo "</div></center>"; ?>

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