File manager

File manager - Edit - /home/autoph/tmp/public_html/pms_v1/dashboard/salesByBrand.php

Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['dasales'])){ $dateFrom = sanitize($_POST['dateFrom']); $dateTo = sanitize($_POST['dateTo']); $compNameID = sanitize($_POST['compNameID']); $dealerID = sanitize($_POST['dealerID']); } //echo $dateFrom . " - ".$dateTo; ?> <script> var chart = new CanvasJS.Chart("chartContainerA", { animationEnabled: true, theme: "light2", title:{ text: "Target vs Actual by Brand" }, axisX:{ valueFormatString: "DD MMM", crosshair: { enabled: true, snapToDataPoint: true } }, axisY: { title: "No. of Units", includeZero: true, crosshair: { enabled: true } }, toolTip:{ shared:true }, legend:{ cursor:"pointer", verticalAlign: "bottom", horizontalAlign: "left", dockInsidePlotArea: true, itemclick: toogleDataSeries }, data: [{ type: "line", showInLegend: true, name: "Target", markerType: "square", //xValueFormatString: "DD MMM, YYYY", color: "#F08080", indexLabel: "{y}", dataPoints: [ <?php $bName = ''; $count=0; $brandID = 0; $getBrand = "SELECT * FROM `pms_brand` WHERE deleted =0 ORDER BY `brand_name` ASC"; $qBrand = mysqli_query($conn,$getBrand); while($row = mysqli_fetch_array($qBrand)){ $count = $count + 21; $brandTarget=0; //get brand id //get mod $bName = $row['brand_name']; $brandID = $row['id']; $getCount ="SELECT mancom_data.`id`, mancom_data.`year`, mancom_data.`deleted`, mancom_data.`comp_id`, mancom_data.`deal_id`, mancom_data.`date_added`, mancom_data.`retail_target_sales`, mancom_data.`retail_actual_sales`, SUM(mancom_data.`ops_total_target`)AS opsTarget, sum(mancom_data.`ops_total_sales`)AS opsSales, vts_dealerships.`brand`, vts_dealerships.`comp_id`, vts_dealerships.`deal_id`, pms_brand.`brand_name`, pms_brand.`id` FROM `mancom_data` JOIN vts_dealerships ON vts_dealerships.deal_id = mancom_data.deal_id JOIN pms_brand ON pms_brand.id = vts_dealerships.brand WHERE pms_brand.`id` =$brandID AND mancom_data.`deleted`=0 AND mancom_data.`date_added` BETWEEN '$dateFrom' AND '$dateTo' LIMIT 1"; $qCount = mysqli_query($conn,$getCount); while($dRow = mysqli_fetch_array($qCount)){ $brandTarget = $dRow['opsTarget']; } if($brandTarget > 0){ echo "{ label: '".$bName."', y: ".$brandTarget." },"; }else{ echo "{ label: '".$bName."', y: 0 },"; } } //echo "{ label: 'Jan', y: ".$janTotal." },"; ?> ] }, { type: "line", showInLegend: true, name: "Actual", lineDashType: "dash", indexLabel: "{y}", dataPoints: [ <?php $bName = ''; $count=0; $brandIDA = 0; $getBrand = "SELECT * FROM `pms_brand` WHERE deleted =0 ORDER BY `brand_name` ASC"; $qBrand = mysqli_query($conn,$getBrand); while($row = mysqli_fetch_array($qBrand)){ $count = $count + 21; $brandTarget=0; //get brand id //get mod $bName = $row['brand_name']; $brandIDA = $row['id']; $getCountA ="SELECT mancom_data.`id`, mancom_data.`year`, mancom_data.`deleted`, mancom_data.`comp_id`, mancom_data.`deal_id`, mancom_data.`date_added`, mancom_data.`retail_target_sales`, mancom_data.`retail_actual_sales`, SUM(mancom_data.`ops_total_target`)AS opsTarget, sum(mancom_data.`ops_total_sales`)AS opsSales, vts_dealerships.`brand`, vts_dealerships.`comp_id`, vts_dealerships.`deal_id`, pms_brand.`brand_name`, pms_brand.`id` FROM `mancom_data` JOIN vts_dealerships ON vts_dealerships.deal_id = mancom_data.deal_id JOIN pms_brand ON pms_brand.id = vts_dealerships.brand WHERE pms_brand.`id` =$brandIDA AND mancom_data.`deleted`=0 AND mancom_data.`date_added` BETWEEN '$dateFrom' AND '$dateTo'"; $qCountA = mysqli_query($conn,$getCountA); while($dRow = mysqli_fetch_array($qCountA)){ $opsSales = $dRow['opsSales']; } if($opsSales > 0){ echo "{ label: '".$bName."', y: ".$opsSales." },"; }else{ echo "{ label: '".$bName."', y: 0 },"; } } //echo "{ label: 'Jan', y: ".$janTotal." },"; ?> ] }] }); chart.render(); //========================================================================================= var chart = new CanvasJS.Chart("chartContainerB", { animationEnabled: true, theme: "light2", // "light1", "light2", "dark1", "dark2" title:{ text: "Top Selling Brand" }, axisY: { title: "Unit Sold" }, data: [{ type: "column", showInLegend: true, legendMarkerColor: "grey", legendText: "Autohub Brands", indexLabel: "{y}", dataPoints: [ <?php $bName = ''; $count=0; $brandIDA = 0; $getBrand = "SELECT * FROM `pms_brand` WHERE deleted =0 ORDER BY `brand_name` ASC"; $qBrand = mysqli_query($conn,$getBrand); while($row = mysqli_fetch_array($qBrand)){ $count = $count + 21; $brandTarget=0; //get brand id //get mod $bName = $row['brand_name']; $brandIDA = $row['id']; $getCountA ="SELECT mancom_data.`id`, mancom_data.`year`, mancom_data.`deleted`, mancom_data.`comp_id`, mancom_data.`deal_id`, mancom_data.`date_added`, mancom_data.`retail_target_sales`, mancom_data.`retail_actual_sales`, SUM(mancom_data.`ops_total_target`)AS opsTarget, sum(mancom_data.`ops_total_sales`)AS opsSales, vts_dealerships.`brand`, vts_dealerships.`comp_id`, vts_dealerships.`deal_id`, pms_brand.`brand_name`, pms_brand.`id` FROM `mancom_data` JOIN vts_dealerships ON vts_dealerships.deal_id = mancom_data.deal_id JOIN pms_brand ON pms_brand.id = vts_dealerships.brand WHERE pms_brand.`id` =$brandIDA AND mancom_data.`deleted`=0 AND mancom_data.`date_added` BETWEEN '$dateFrom' AND '$dateTo'"; $qCountA = mysqli_query($conn,$getCountA); while($dRow = mysqli_fetch_array($qCountA)){ $opsSales = $dRow['opsSales']; } if($opsSales ==''){ $opsSales =0; } echo "{ label: '".$bName."', y: ".$opsSales." },"; } //echo "{ label: 'Jan', y: ".$janTotal." },"; ?> ] }] }); chart.render(); //========================================================================================== function toogleDataSeries(e){ if (typeof(e.dataSeries.visible) === "undefined" \|\| e.dataSeries.visible) { e.dataSeries.visible = false; } else{ e.dataSeries.visible = true; } chart.render(); } </script> <div id="chartContainerA" style="height: 370px; width: 100%; margin-top:100px"></div> <div id="chartContainerB" style="height: 370px; width: 100%; margin-top:100px;"></div> <script src="https://cdn.canvasjs.com/canvasjs.min.js"></script> <?php $conn->close(); ?>

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