File manager

File manager - Edit - /home/autoph/public_html/voc/home/dashboard_comp_inventory.php

Back
<!DOCTYPE HTML> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <script src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script> <script src="https://canvasjs.com/assets/script/jquery.canvasjs.min.js"></script> <?php include 'core/database/connect.php'; error_reporting(0); $toDate = date_create() ->format("Y/m/d"); $brandName =TRIM($_GET['comp']); $userID=$user_data['u_id']; $userFName = $user_data['u_fname']; $userLName = $user_data['u_lname']; //echo "My Lastname is:" .$userLName; $getData = mysql_query("SELECT * FROM `db_vehicle_inventory` WHERE `sold`='0' AND `returned`='0' AND `incoming_unit` = '0' AND `company`='$brandName'"); while($row=mysql_fetch_array($getData)){ $olddate = $row['date_received']; $now = time(); // or your date as well' $your_date = strtotime($olddate); $datediff = $now - $your_date; $totalCount= round($datediff / (60 * 60 * 24)); if($totalCount < 91){ $lessNinety = $lessNinety + 1; $lessNinetyAmount = $lessNinetyAmount + $row['price']; } if ($totalCount > 90 && $totalCount < 181){ $betweenNinetyOneEighty = $betweenNinetyOneEighty + 1; $betweenNinetyOneEightyAmount = $betweenNinetyOneEightyAmount + $row['price']; } if ($totalCount > 180 ){ $oldestUnit = $oldestUnit + 1; $oldestUnitAmount = $oldestUnitAmount + $row['price']; } $total = $oldestUnit + $lessNinety + $betweenNinetyOneEighty; $totalB = $lessNinetyAmount + $betweenNinetyOneEightyAmount + $oldestUnitAmount; } $EarlyCount = number_format(($lessNinety / $total * 100),2,'.',','); $MidCount = number_format(($betweenNinetyOneEighty / $total * 100),2,'.',','); $LateCount = number_format(($oldestUnit / $total * 100),2,'.',','); $EarlyCountB = number_format(($lessNinetyAmount / $totalB * 100),2,'.',','); $MidCountB = number_format(($betweenNinetyOneEightyAmount / $totalB * 100),2,'.',','); $LateCountB = number_format(($oldestUnitAmount / $totalB * 100),2,'.',','); ?> <script> window.onload = function () { //Better to construct options first and then pass it as a parameter var options = { title: { text: "Column Chart in jQuery CanvasJS" }, data: [ { // Change type to "doughnut", "line", "splineArea", etc. type: "column", dataPoints: [ <?php $getData = mysql_query("SELECT DISTINCT(`brand_code`) FROM `db_vehicle_inventory` WHERE `company`='$brandName' ORDER BY `brand_code` ASC"); while($row=mysql_fetch_array($getData)){ $aBrand = $row['brand_code']; $countBrand = mysql_result(mysql_query("SELECT COUNT(id) FROM `db_vehicle_inventory` WHERE `sold`=0 AND `returned`=0 AND `brand_code`='$aBrand' "),0); echo "{ label: \"".$aBrand."\", y: ".$countBrand."},"; } ?> //<?php echo "{ label: \"apple\", y: 10 },";?> //{ label: "orange", y: 15 }, //{ label: "banana", y: 25 }, //{ label: "mango", y: 30 }, //{ label: "grape", y: 28 } ] } ] }; $("#chartContainer").CanvasJSChart(options); } </script> </head> <body> <?php //echo "Count:". $lessNinetyAmount; //echo "<br>Count:". $betweenNinetyOneEightyAmount; //echo "<br>Count:". $oldestUnitAmount; ?> <div style="display:none;width:100%;position:relative;height:40px;background:yellow;padding:8px;" id="AccountActive">Account has been activated</div> <p style="text-align:left;font-weight:Bahnschrift Light;font-size:18px;font-weight:normal;padding:3px;margin:0px;">Welcome, <?php echo strtoupper($userFName). " " . strtoupper($userLName) . "!";?></p><br> <div style='border:0px solid red;width:99%;height:815px;min-height:600px;float:left;margin:5px;min-width:600px;background:white'> <div style='vertical-align:top;height:55px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;color:red;font-size:30px;text-align:center'> <?php echo "UNIT AGING ANALYSIS - ".strtoupper($brandName);?><br><br> <div style='float:right;font-family:Verdana;font-size:15px;'> <a href=' ' class='hideClick hidden' > ♲ </a><!--REFRESH/RELOAD WINDOW--> <a href=' ' class='hideClick hidden' > ✉ </a> <!--EXTRACT LIST OF COMPANY AND EXPORT TO EXCEL--> <a href='autohub.php?id=x&d=x' class='hideClick hidden' style='font-weight:bold'> ✕ </a> </div> </div> <div id="chartContainer" style="height: 370px; width: 40%;margin:5px;border:0px solid gray;float:left;border-bottom:1px solid gray"></div> <div id="chartByPesovalue" style="height: 370px; width: 40%;margin:5px;border:0px solid gray;float:right;border-bottom:1px solid gray"></div> </div> </body> </html>

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