File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF/prf_dataAnalytics.php

Back
<!DOCTYPE HTML> <html> <head> <?php include 'core/init.php'; $dasDate = date_create() ->format("Y-m-d"); $dasTime = date('H:i:s'); $daDate = explode('-',$dasDate); $dasYear = $daDate[0]; //One $dasYearA = $dasYear - 1;//Two $dasYearB = $dasYear - 2;//Three $dasYearC = $dasYear - 3;//Four $dasYearD = $dasYear - 4;//Five $dasYearE = $dasYear - 5;//Six $dasYearF = $dasYear - 6;//Seven $dasYearG = $dasYear - 7;//Eight //echo $dasYear ." - " .$dasYearA." - " .$dasYearB." - " .$dasYearC." - " .$dasYearD." - " .$dasYearE." - " .$dasYearF." - " .$dasYearG; //CurrentYear $YearFirstQStart = $dasYear ."-01-31"; $YearFirstQEnd = $dasYear ."-03-31"; $YearSecondQStart = $dasYear ."-04-01"; $YearSecondQEnd = $dasYear ."-06-30"; $YearThirdQStart = $dasYear ."-07-01"; $YearThirdQEnd = $dasYear ."-09-30"; $YearFourtQStart = $dasYear ."-10-01"; $YearFourtQEnd = $dasYear ."-12-31"; //CurrentYear - 1 $aYearFirstQStart = $dasYearA ."-01-31"; $aYearFirstQEnd = $dasYearA ."-03-31"; $aYearSecondQStart = $dasYearA ."-04-01"; $aYearSecondQEnd = $dasYearA ."-06-30"; $aYearThirdQStart = $dasYearA ."-07-01"; $aYearThirdQEnd = $dasYearA ."-09-30"; $aYearFourtQStart = $dasYearA ."-10-01"; $aYearFourtQEnd = $dasYearA ."-12-31"; //CurrentYear - 2 $bYearFirstQStart = $dasYearB ."-01-31"; $bYearFirstQEnd = $dasYearB ."-03-31"; $bYearSecondQStart = $dasYearB ."-04-01"; $bYearSecondQEnd = $dasYearB ."-06-30"; $bYearThirdQStart = $dasYearB ."-07-01"; $bYearThirdQEnd = $dasYearB ."-09-30"; $bYearFourtQStart = $dasYearB ."-10-01"; $bYearFourtQEnd = $dasYearB ."-12-31"; //CurrentYear - 3 $cYearFirstQStart = $dasYearC ."-01-31"; $cYearFirstQEnd = $dasYearC ."-03-31"; $cYearSecondQStart = $dasYearC ."-04-01"; $cYearSecondQEnd = $dasYearC ."-06-30"; $cYearThirdQStart = $dasYearC ."-07-01"; $cYearThirdQEnd = $dasYearC ."-09-30"; $cYearFourtQStart = $dasYearC ."-10-01"; $cYearFourtQEnd = $dasYearC ."-12-31"; //CurrentYear - 4 $dYearFirstQStart = $dasYearD ."-01-31"; $dYearFirstQEnd = $dasYearD ."-03-31"; $dYearSecondQStart = $dasYearD ."-04-01"; $dYearSecondQEnd = $dasYearD ."-06-30"; $dYearThirdQStart = $dasYearD ."-07-01"; $dYearThirdQEnd = $dasYearD ."-09-30"; $dYearFourtQStart = $dasYearD ."-10-01"; $dYearFourtQEnd = $dasYearD ."-12-31"; //CurrentYear - 5 $eYearFirstQStart = $dasYearE ."-01-31"; $eYearFirstQEnd = $dasYearE ."-03-31"; $eYearSecondQStart = $dasYearE ."-04-01"; $eYearSecondQEnd = $dasYearE ."-06-30"; $eYearThirdQStart = $dasYearE ."-07-01"; $eYearThirdQEnd = $dasYearE ."-09-30"; $eYearFourtQStart = $dasYearE ."-10-01"; $eYearFourtQEnd = $dasYearE ."-12-31"; //CurrentYear - 6 $fYearFirstQStart = $dasYearF ."-01-31"; $fYearFirstQEnd = $dasYearF ."-03-31"; $fYearSecondQStart = $dasYearF ."-04-01"; $fYearSecondQEnd = $dasYearF ."-06-30"; $fYearThirdQStart = $dasYearF ."-07-01"; $fYearThirdQEnd = $dasYearF ."-09-30"; $fYearFourtQStart = $dasYearF ."-10-01"; $fYearFourtQEnd = $dasYearF ."-12-31"; //CurrentYear - 7 $gYearFirstQStart = $dasYearG ."-01-31"; $YearFirstQEnd = $dasYearG ."-03-31"; $gYearSecondQStart = $dasYearG ."-04-01"; $gYearSecondQEnd = $dasYearG ."-06-30"; $gYearThirdQStart = $dasYearG ."-07-01"; $gYearThirdQEnd = $dasYearG ."-09-30"; $gYearFourtQStart = $dasYearG ."-10-01"; $gYearFourtQEnd = $dasYearG ."-12-31"; //CurrentYear Quarterly Count $dataYearOneA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$YearFirstQStart' AND '$YearFirstQEnd'"),0); $dataYearOneB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$YearSecondQStart' AND '$YearSecondQEnd'"),0); $dataYearOneC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$YearThirdQStart' AND '$YearThirdQEnd'"),0); $dataYearOneD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$YearFourtQStart' AND '$YearFourtQEnd'"),0); if($dataYearOneC ==''){$dataYearOneC=0;} if($dataYearOneB ==''){$dataYearOneB=0;} if($dataYearOneD ==''){$dataYearOneD=0;} if($dataYearOneA ==''){$dataYearOneA=0;} $dataYearTwoA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$aYearFirstQStart' AND '$aYearFirstQEnd'"),0); $dataYearTwoB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$aYearSecondQStart' AND '$aYearSecondQEnd'"),0); $dataYearTwoC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$aYearThirdQStart' AND '$aYearThirdQEnd'"),0); $dataYearTwoD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$aYearFourtQStart' AND '$aYearFourtQEnd'"),0); if($dataYearTwoA ==''){$dataYearTwoA=0;} if($dataYearTwoB ==''){$dataYearTwoB=0;} if($dataYearTwoC ==''){$dataYearTwoC=0;} if($dataYearTwoD ==''){$dataYearTwoD=0;} $dataYearThreeA =mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$bYearFirstQStart' AND '$bYearFirstQEnd'"),0); $dataYearThreeB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$bYearSecondQStart' AND '$bYearSecondQEnd'"),0); $dataYearThreeC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$bYearThirdQStart' AND '$bYearThirdQEnd'"),0); $dataYearThreeD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$bYearFourtQStart' AND '$bYearFourtQEnd'"),0); if($dataYearThreeA ==''){$dataYearThreeA=0;} if($dataYearThreeB ==''){$dataYearThreeB=0;} if($dataYearThreeC ==''){$dataYearThreeC=0;} if($dataYearThreeD ==''){$dataYearThreeD=0;} $dataYearFourA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$cYearFirstQStart' AND '$cYearFirstQEnd'"),0); $dataYearFourB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$cYearSecondQStart' AND '$cYearSecondQEnd'"),0); $dataYearFourC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$cYearThirdQStart' AND '$cYearThirdQEnd'"),0); $dataYearFourD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$cYearFourtQStart' AND '$cYearFourtQEnd'"),0); if($dataYearFourA ==''){$dataYearFourA=0;} if($dataYearFourB ==''){$dataYearFourB=0;} if($dataYearFourC ==''){$dataYearFourC=0;} if($dataYearFourD ==''){$dataYearFourD=0;} $dataYearFiveA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$dYearFirstQStart' AND '$dYearFirstQEnd'"),0); $dataYearFiveB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$dYearSecondQStart' AND '$dYearSecondQEnd'"),0); $dataYearFiveC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$dYearThirdQStart' AND '$dYearThirdQEnd'"),0); $dataYearFiveD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$dYearFourtQStart' AND '$dYearFourtQEnd'"),0); if($dataYearFiveA ==''){$dataYearFiveA=0;} if($dataYearFiveB ==''){$dataYearFiveB=0;} if($dataYearFiveC ==''){$dataYearFiveC=0;} if($dataYearFiveD ==''){$dataYearFiveD=0;} $dataYearSixA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$eYearFirstQStart' AND '$eYearFirstQEnd'"),0); $dataYearSixB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$eYearSecondQStart' AND '$eYearSecondQEnd'"),0); $dataYearSixC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$eYearThirdQStart' AND '$eYearThirdQEnd'"),0); $dataYearSixD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$eYearFourtQStart' AND '$eYearFourtQEnd'"),0); if($dataYearSixA ==''){$dataYearSixA=0;} if($dataYearSixB ==''){$dataYearSixB=0;} if($dataYearSixC ==''){$dataYearSixC=0;} if($dataYearSixD ==''){$dataYearSixD=0;} $dataYearSevenA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$gYearFirstQStart' AND '$gYearFirstQEnd'"),0); $dataYearSevenB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$gYearSecondQStart' AND '$gYearSecondQEnd'"),0); $dataYearSevenC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$gYearThirdQStart' AND '$gYearThirdQEnd'"),0); $dataYearSevenD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$gYearFourtQStart' AND '$gYearFourtQEnd'"),0); if($dataYearSevenA ==''){$dataYearSevenA=0;} if($dataYearSevenB ==''){$dataYearSevenB=0;} if($dataYearSevenC ==''){$dataYearSevenC=0;} if($dataYearSevenD ==''){$dataYearSevenD=0;} $dataYearEightA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$fYearFirstQStart' AND '$fYearFirstQEnd'"),0); $dataYearEightB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$fYearSecondQStart' AND '$fYearSecondQEnd'"),0); $dataYearEightC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$fYearThirdQStart' AND '$fYearThirdQEnd'"),0); $dataYearEightD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$fYearFourtQStart' AND '$fYearFourtQEnd'"),0); if($dataYearEightA ==''){$dataYearEightA=0;} if($dataYearEightB ==''){$dataYearEightB=0;} if($dataYearEightC ==''){$dataYearEightC=0;} if($dataYearEightD ==''){$dataYearEightD=0;} $getDataA = mysql_query("SELECT * FROM `prf_expensecategory` WHERE 1"); while($row=mysql_fetch_array($getDataA)){ $catID = $row['id']; $catSum = number_format($countCat,2,'.',','); //echo $row['description'].$catSum; switch($catID){ case '1': $CapexAmount = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='1' AND `po_code`!=''"),0); $CapexCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='1' AND `po_code`!=''"),0); break; case '2': $MarketingAmount = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='2' AND `po_code`!=''"),0); $MarketingCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='2' AND `po_code`!=''"),0); break; case '3': $OfficeSupplies = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='3' AND `po_code`!=''"),0); $OfficeCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='3' AND `po_code`!=''"),0); break; case '4': $vehicleRepair = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='4' AND `po_code`!=''"),0); $vehicleCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='4' AND `po_code`!=''"),0); break; case '5': $RepairMaintenance = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='5' AND `po_code`!=''"),0); $RepairMaintenanceCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='5' AND `po_code`!=''"),0); break; case '6': $Consumables = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='6' AND `po_code`!=''"),0); $ConsumablesCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='6' AND `po_code`!=''"),0); break; case '7': $Constructions = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='7' AND `po_code`!=''"),0); $ConstructionsCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='7' AND `po_code`!=''"),0); break; } } if($CapexAmount==''){ $CapexAmount=0; } if($MarketingAmount==''){ $MarketingAmount=0; } if($OfficeSupplies==''){ $OfficeSupplies=0; } if($vehicleRepair==''){ $vehicleRepair=0; } if($RepairMaintenance==''){ $RepairMaintenance=0; } if($Consumables==''){ $Consumables=0; } if($Constructions==''){ $Constructions=0; } ?> <script> StopLoadGraph(); var idVar = setInterval(() => { LoadGraph(); }, 400); function StopLoadGraph() { clearInterval(idVar); } function LoadGraph() { StopLoadGraph(); var chart = new CanvasJS.Chart("chartContainer", { animationEnabled: true, title:{ text: "AUTOHUB - Consolidated Quarterly Expense", fontFamily: "Yu Gothic Light", fontColor: "#695A42" }, axisX: { interval: 1, intervalType: "year" }, axisY:{ valueFormatString:"Php #", gridColor: "#B6B1A8", tickColor: "#B6B1A8" }, toolTip: { shared: true, content: toolTipContent }, data: [{ type: "stackedColumn", showInLegend: true, color: "#f863d6", name: "Q1", dataPoints: [ { y: <?php echo $dataYearOneA;?>, x: new Date(<?php echo $dasYear;?>,0) }, { y: <?php echo $dataYearTwoA;?>, x: new Date(<?php echo $dasYearA;?>,0) }, { y: <?php echo $dataYearThreeA;?>, x: new Date(<?php echo $dasYearB;?>,0) }, { y: <?php echo $dataYearFourA;?>, x: new Date(<?php echo $dasYearC;?>,0) }, { y: <?php echo $dataYearFiveA;?>, x: new Date(<?php echo $dasYearD;?>,0) }, { y: <?php echo $dataYearSixA;?>, x: new Date(<?php echo $dasYearE;?>,0) }, { y: <?php echo $dataYearSevenA;?>, x: new Date(<?php echo $dasYearF;?>,0) }, { y: <?php echo $dataYearEightA;?>, x: new Date(<?php echo $dasYearG;?>,0) } ] }, { type: "stackedColumn", showInLegend: true, name: "Q2", color: "#39cb07", dataPoints: [ { y: <?php echo $dataYearOneB;?>, x: new Date(<?php echo $dasYear;?>,0) }, { y: <?php echo $dataYearTwoB;?>, x: new Date(<?php echo $dasYearA;?>,0) }, { y: <?php echo $dataYearThreeB;?>, x: new Date(<?php echo $dasYearB;?>,0) }, { y: <?php echo $dataYearFourB;?>, x: new Date(<?php echo $dasYearC;?>,0) }, { y: <?php echo $dataYearFiveB;?>, x: new Date(<?php echo $dasYearD;?>,0) }, { y: <?php echo $dataYearSixB;?>, x: new Date(<?php echo $dasYearE;?>,0) }, { y: <?php echo $dataYearSevenB;?>, x: new Date(<?php echo $dasYearF;?>,0) }, { y: <?php echo $dataYearEightB;?>, x: new Date(<?php echo $dasYearG;?>,0) } ] }, { type: "stackedColumn", showInLegend: true, name: "Q3", color: "#13eeee", dataPoints: [ { y: <?php echo $dataYearOneC;?>, x: new Date(<?php echo $dasYear;?>,0) }, { y: <?php echo $dataYearTwoC;?>, x: new Date(<?php echo $dasYearA;?>,0) }, { y: <?php echo $dataYearThreeC;?>, x: new Date(<?php echo $dasYearB;?>,0) }, { y: <?php echo $dataYearFourC;?>, x: new Date(<?php echo $dasYearC;?>,0) }, { y: <?php echo $dataYearFiveC;?>, x: new Date(<?php echo $dasYearD;?>,0) }, { y: <?php echo $dataYearSixC;?>, x: new Date(<?php echo $dasYearE;?>,0) }, { y: <?php echo $dataYearSevenC;?>, x: new Date(<?php echo $dasYearF;?>,0) }, { y: <?php echo $dataYearEightC;?>, x: new Date(<?php echo $dasYearG;?>,0) } ] }, { type: "stackedColumn", showInLegend: true, name: "Q4", color: "#0bad79", dataPoints: [ { y: <?php echo $dataYearOneD;?>, x: new Date(<?php echo $dasYear;?>,0) }, { y: <?php echo $dataYearTwoD;?>, x: new Date(<?php echo $dasYearA;?>,0) }, { y: <?php echo $dataYearThreeD;?>, x: new Date(<?php echo $dasYearB;?>,0) }, { y: <?php echo $dataYearFourD;?>, x: new Date(<?php echo $dasYearC;?>,0) }, { y: <?php echo $dataYearFiveD;?>, x: new Date(<?php echo $dasYearD;?>,0) }, { y: <?php echo $dataYearSixD;?>, x: new Date(<?php echo $dasYearE;?>,0) }, { y: <?php echo $dataYearSevenD;?>, x: new Date(<?php echo $dasYearF;?>,0) }, { y: <?php echo $dataYearEightD;?>, x: new Date(<?php echo $dasYearG;?>,0) } ] }] }); chart.render(); function toolTipContent(e) { var str = ""; var total = 0; var str2, str3; for (var i = 0; i < e.entries.length; i++){ var str1 = "<span style= \"color:"+e.entries[i].dataSeries.color + "\"> "+e.entries[i].dataSeries.name+"</span>: Php<strong>"+e.entries[i].dataPoint.y+"</strong><br/>"; total = e.entries[i].dataPoint.y + total; str = str.concat(str1); } str2 = "<span style = \"color:DodgerBlue;\"><strong>"+(e.entries[0].dataPoint.x).getFullYear()+"</strong></span><br/>"; total = Math.round(total * 100) / 100; str3 = "<span style = \"color:Tomato\">Total:</span><strong> Php"+total+"</strong><br/>"; return (str2.concat(str)).concat(str3); } //############################################################################################################# var chart = new CanvasJS.Chart("catChartCount", { animationEnabled: true, theme: "light2", // "light1", "light2", "dark1", "dark2" title:{ text: "Request Count By Category", fontFamily: "Yu Gothic Light", fontColor: "#695A42" }, axisY: { title: "Line Item" }, data: [{ type: "column", showInLegend: true, legendMarkerColor: "grey", legendText: "Total Line Items Received by Category", dataPoints: [ { y: <?php echo $CapexCount;?>, label: "CAPEX" }, { y: <?php echo $MarketingCount;?>, label: "MARKETING" }, { y: <?php echo $OfficeCount;?>, label: "OFFICE SUPPLIES" }, { y: <?php echo $RepairMaintenanceCount;?>, label: "REPAIR and MAINTENANCE" }, { y: <?php echo $ConsumablesCount;?>, label: "CONSUMABLES" }, { y: <?php echo $ConstructionsCount;?>, label: "CONSTRUCTION" }, { y: <?php echo $vehicleCount;?>, label: "VEHICLE REPAIR" } ]// }] }); chart.render(); //############################################################################################################# var chart = new CanvasJS.Chart("catChartAmount", { animationEnabled: true, theme: "light1", // "light1", "light2", "dark1", "dark2" title:{ text: "Amount by Category", fontFamily: "Yu Gothic Light", fontColor: "#695A42" }, axisY: { title: "Amount" }, data: [{ type: "column", showInLegend: true, legendMarkerColor: "grey", legendText: "Expense Breakdown By Category", dataPoints: [ { y: <?php echo $CapexAmount;?>, label: "CAPEX" }, { y: <?php echo $MarketingAmount;?>, label: "MARKETING" }, { y: <?php echo $OfficeSupplies;?>, label: "OFFICE SUPPLIES" }, { y: <?php echo $RepairMaintenance;?>, label: "REPAIR and MAINTENANCE" }, { y: <?php echo $Consumables;?>, label: "CONSUMABLES" }, { y: <?php echo $Constructions;?>, label: "CONSTRUCTIONS" }, { y: <?php echo $vehicleRepair;?>, label: "VEHICLE REPAIR" } ] }] }); chart.render(); //############################################################################################################# StopLoadGraph(); } </script> </head> <body> <div id="chartContainer" style="height: 470px; width: 90%;margin:5%"></div> <div id="space" style="height: 30px; width: 95%;margin:0%;float:left;text-align:right;padding-right:100px;font-family:Yu Gothic Light;font-size:14px;color:#5585ca">View More</div> <div id="catChartCount" style="height: 400px; width: 42%;border:0px solid red;float:left;margin:3%"></div> <div id="catChartAmount" style="height: 400px; width: 42%;border:0px solid red;float:right;margin:3%"></div> <div id="space" style="height: 50px; width: 48%;margin:0%;float:left;text-align:right;padding-right:50px;background:white;padding-top:50px;font-family:Yu Gothic Light;font-size:14px;color:#5585ca">View More</div> <div id="space" style="height: 50px; width: 48%;margin:0%;float:left;text-align:right;padding-right:50px;background:white;padding-top:50px;font-family:Yu Gothic Light;font-size:14px;color:#5585ca">View More</div> <script src="https://canvasjs.com/assets/script/canvasjs.min.js"></script> </body> </html>

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