public function buildDashboard()
{
$chart = new ChartComponent("chart1");
$chart->setCaption("Country wide sales");
$chart->setLabels(["Country A", "Country B", "Country C"]);
$chart->setDimensions(6, 6);
$chart->addSeries("sales", "Sales", [10, 7, 11]);
$chart->addDrillStep("drill_states", $this);
$chart->addDrillStep("drill_countries", $this);
$this->addComponent($chart);
}
public function buildDashboard()
{
$chart = new ChartComponent("my_first_chart");
$chart->setCaption("Expenses incurred on Food Consumption by Year");
$chart->setDimensions(4, 4);
$chart->setLabels(["2009", "2010", "2011"]);
$chart->addSeries("beverages", "Beverages", [1355, 1916, 1150]);
$chart->addSeries("packaged_foods", "Packaged Foods", [1513, 976, 1321]);
$chart->addDrillStep("firstDrill", $this);
$chart->addDrillStep("secondDrill", $this);
$this->addComponent($chart);
}
public function buildDashboard()
{
$chart = new ChartComponent('chart');
$chart->setDimensions(8, 6);
$chart->setCaption('Annual Sales Summary (2010 - 2013');
$chart->setLabels(['2010', '2011', '2012', '2013']);
$chart->addSeries('sales', 'Sales', [1160000, 1040000, 1020000, 1160000]);
$chart->setYAxis('', array('numberPrefix' => '$', 'numberHumanize' => true));
$selectedYear;
$chart->addDrillStep('firstDrill', $this);
$chart->addDrillStep('secondDrill', $this);
$this->addComponent($chart);
}
public function buildDashboard()
{
$yearwise = new ChartComponent('yearly_sales');
$yearwise->setCaption("Yearly Sales");
$yearwise->setDimensions(6, 6);
$yearData = $this->get_year();
$yearwise->setLabels(ArrayUtils::pluck($yearData, 'payment_year'));
$yearwise->setYAxis("Sales", array("numberHumanize" => true, 'numberPrefix' => "\$"));
$totalSalesArr = ArrayUtils::pluck($yearData, "total_amount");
$yearwise->addSeries("sales", "Sales", $totalSalesArr, array('numberPrefix' => "\$"));
$yearwise->addDrillStep("get_monthwise", $this);
$yearwise->addDrillStep("get_daywise", $this);
$totalSales = 0;
foreach ($totalSalesArr as $key => $value) {
$totalSales += $value;
}
$yearwise->addComponentKPI("sales", array("caption" => "Total Sales", "value" => $totalSales, "numberPrefix" => "\$", "numberHumanize" => true));
$yearwise->addComponentKPI("second", array("caption" => "Revenue", "value" => $totalSales, "numberPrefix" => "\$", "numberHumanize" => true));
$this->setDashboardTitle("Sales Dashboard");
$this->addComponent($yearwise);
$category = new ChartComponent('category');
$category->setCaption("Category wise Sales");
$category->setDimensions(6, 6);
$categoryData = $this->get_category();
$category->setLabels(ArrayUtils::pluck($categoryData, 'CategoryName'));
$category->setYAxis("Sales", array("numberHumanize" => true, 'numberPrefix' => "\$"));
$totalSalesArr = ArrayUtils::pluck($categoryData, "total_amount");
$category->addSeries("sales", "Sales", $totalSalesArr, array('numberPrefix' => "\$"));
$this->addComponent($category);
$table = new TableComponent('table');
$table->setCaption("Average Shipping Time");
$table->setDimensions(6, 4);
$ship = $this->get_shipping();
$table->addColumn('country', 'Country');
$table->addColumn('avg_time', 'Average Time');
$table->addMultipleRows($this->PolulateData($ship));
$this->addComponent($table);
$goods = new ChartComponent('goods_sold');
$goods->setCaption("Cost of Goods Sold");
$goods->setDimensions(12, 6);
$yearArr = $this->get_yearName();
$goods->setLabels(ArrayUtils::pluck($yearArr, 'payment_year'));
$goods->setYAxis("Sales", array("numberHumanize" => true, 'numberPrefix' => "\$"));
$goodsSoldData = $this->get_goodsSold();
foreach ($goodsSoldData as $key => $value) {
$goods->addSeries($key, $key, ArrayUtils::pluck($value, "total_amount"), array('numberPrefix' => "\$", 'seriesStacked' => true));
}
$this->addComponent($goods);
}
public function buildDashboard()
{
$chart = new ChartComponent('sales1');
$chart->setCaption("Sales by Region");
$chart->setDimensions(12, 6);
$countryData = $this->get_country();
$chart->setLabels(ArrayUtils::pluck($countryData, 'country'));
$chart->addSeries("sales", "Sales", ArrayUtils::pluck($countryData, "total_amount"), array('numberPrefix' => "\$"));
$chart->addDrillStep("get_states", $this);
$chart->addDrillStep("get_cities", $this);
$this->addComponent($chart);
$yearwise = new ChartComponent('year');
$yearwise->setCaption("Sales by Time");
$yearwise->setDimensions(12, 6);
$yearData = $this->get_year();
$yearwise->setLabels(ArrayUtils::pluck($yearData, 'payment_year'));
$yearwise->addSeries("sales", "Sales", ArrayUtils::pluck($yearData, "total_amount"), array('numberPrefix' => "\$"));
$yearwise->addDrillStep("get_monthwise", $this);
$yearwise->addDrillStep("get_daywise", $this);
$this->addComponent($yearwise);
}
public function buildDashboard()
{
$chart = new ChartComponent('dataChart');
$chart->setCaption("Compare data chart");
$monthList = array();
for ($m = 1; $m <= 12; $m++) {
$monthList[] = date('M', mktime(0, 0, 0, $m, 1));
}
$chart->setLabels($monthList);
$chart->setDimensions(12, 6);
$chart->addSeries("data_2013", "Data 2013", [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]);
$chart->addSeries("data_2014", "Data 2014", [2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13]);
$chart->addDrillStep("drill_Data", $this);
$this->addComponent($chart);
}
public function buildDashboard()
{
$quarterlySales = new ChartComponent('quarterlySales');
$quarterlySales->setDimensions(6, 6);
$quarterlySales->setCaption("Quarterly Sales");
$quarterlySales->setLabels(array("Q1", "Q2", "Q3", "Q4"));
$quarterlySales->addYAxis('quantity', "Quantity");
$quarterlySales->addSeries('sales', "Sales", array(13122, 41312, 46132, 51135), array('numberPrefix' => "\$"));
$quarterlySales->addSeries('quantity', "Quantity", array(121, 392, 420, 489), array('yAxis' => 'quantity'));
$quarterlySales->addComponentKPI('beverage', array('caption' => 'Beverages', 'value' => 22900, 'numberPrefix' => ' $', 'numberHumanize' => true));
$quarterlySales->addComponentKPI('vegetable', array('caption' => 'Vegetables', 'value' => 10401, 'numberPrefix' => ' $', 'numberHumanize' => true));
$quarterlySales->addComponentKPI('dairy', array('caption' => 'Dairy', 'value' => 27700, 'numberPrefix' => ' $', 'numberHumanize' => true));
$quarterlySales->addDrillStep('drillIntoMonths', $this);
$this->addComponent($quarterlySales);
$numTickets = new KPIComponent('numTickets');
$numTickets->setDimensions(3, 3);
$numTickets->setCaption("Open Support Tickets");
$numTickets->setValue(42);
$this->addComponent($numTickets);
$satisfactionGauge = new GaugeComponent('satisfactionGauge');
$satisfactionGauge->setDimensions(3, 3);
$satisfactionGauge->setCaption('Customer Satisfaction');
$satisfactionGauge->setValue(8);
$satisfactionGauge->setLimits(0, 10);
$this->addComponent($satisfactionGauge);
$ticketPriorities = new KPIGroupComponent('ticketPriorities');
$ticketPriorities->setDimensions(6, 3);
$ticketPriorities->setCaption('Ticket Priorities');
$ticketPriorities->addKPI('high', array('caption' => 'High Priority', 'value' => 6));
$ticketPriorities->addKPI('normal', array('caption' => 'Normal Priority', 'value' => 36));
$this->addComponent($ticketPriorities);
$productsTable = new TableComponent('productsTable');
$productsTable->setDimensions(6, 6);
$productsTable->setCaption('Products');
$productsTable->addColumn('name', 'Name');
$productsTable->addColumn('category', 'Category');
$productsTable->addColumn('price', 'Price', array('dataType' => "number", 'numberPrefix' => "\$", 'textAlign' => "right", 'numberForceDecimals' => true));
$productsTable->addMultipleRows($this->tableData);
$this->addComponent($productsTable);
$productFilterForm = new FormComponent('productFilterForm');
$productFilterForm->setDimensions(6, 6);
$productFilterForm->setCaption('Filter Products');
$productFilterForm->addMultiSelectField('category', 'Select Category', array('Vegetables', 'Dairy', 'Beverages'));
$productFilterForm->addTextField('name', 'Product Name Contains');
$productFilterForm->addNumericRangeField('price', 'Price', array(5, 20));
$this->addComponent($productFilterForm);
$productFilterForm->onApplyClick(array($productsTable), 'handleApplyClick', $this);
}
public function buildDashboard()
{
$this->setDashboardTitle("Sales Dashboard");
$this->setActionPath("/static/transfer/build/tour/motherboard_action.php");
// $yearwise = new ChartComponent ('yearly_sales');
// $yearwise->setCaption ("Yearly Sales");
// $yearwise->setDimensions (6, 6);
// $yearData = $this->get_year();
// $yearwise->setLabels(ArrayUtils::pluck($yearData, 'payment_year'));
// $yearwise->setYAxis("Sales", array(
// "numberHumanize" => true,
// 'numberPrefix' => "$"
// ));
// $totalSalesArr = ArrayUtils::pluck($yearData, "total_amount");
// $yearwise->addSeries ("sales", "Sales", $totalSalesArr, array(
// 'numberPrefix' => "$"
// ));
// $yearwise->addDrillStep("get_monthwise", $this);
// $yearwise->addDrillStep("get_daywise", $this);
// $totalSales = 0;
// foreach ($totalSalesArr as $key => $value) {
// $totalSales += $value;
// }
// $yearwise->addComponentKPI("sales", array(
// "caption" => "Total Sales",
// "value" => $totalSales,
// "numberPrefix" => "$",
// "numberHumanize" => true
// ));
// $yearwise->addComponentKPI("second", array(
// "caption" => "Revenue",
// "value" => $totalSales,
// "numberPrefix" => "$",
// "numberHumanize" => true
// ));
// $this->addComponent ($yearwise);
$category = new ChartComponent('category');
$category->setCaption("Category wise Sales");
$category->setDimensions(6, 6);
$categoryData = $this->get_category();
$quantityData = $this->get_units();
$category->setLabels(ArrayUtils::pluck($categoryData, 'CategoryName'));
$category->setYAxis("Sales", array("numberHumanize" => true, 'numberPrefix' => "\$"));
$totalSalesArr = ArrayUtils::pluck($categoryData, "total_amount");
$category->addSeries("sales", "Sales", $totalSalesArr, array('numberPrefix' => "\$"));
$category->addYAxis('unitsAx', "Units in Inventory", array());
$totalUnitsArr = ArrayUtils::pluck($quantityData, "total_quantity");
$category->addSeries("units", "Units in Inventory", $totalUnitsArr, array("seriesDisplayType" => "line", "yAxis" => 'unitsAx'));
$category->addDrillStep("get_prod", $this);
$category->addComponentKPI("cost", array("caption" => "Total Sales", "value" => $this->get_cost_inventory(), "numberPrefix" => "\$"));
$category->addComponentKPI("units", array("caption" => "Total Units in Inventory", "value" => $this->get_unit_inventory()));
$this->addComponent($category);
$chart = new ChartComponent("Customer_satisfaction");
$chart->setCaption("Customer Satisfaction");
$chart->setDimensions(6, 6);
$chart->setLabels(["Very Unsatisfied", "UnSatisfied", "Neutral", "Satisfied", "Very Satisfied"]);
$chart->setPieValues([4, 10, 25, 25, 36], array("numberSuffix" => "%"));
$this->addComponent($chart);
$table = new TableComponent('table');
$table->setCaption("Average Shipping Time");
$table->setDimensions(6, 6);
$ship = $this->get_shipping();
$table->addColumn('country', 'Country');
$table->addColumn('avg_time', 'Average Time', array("textAlign" => "right"));
$table->addMultipleRows($this->PolulateData($ship));
$table->setRowsPerPage(12);
$this->addComponent($table);
$goods = new ChartComponent('goods_sold');
$goods->setCaption("Cost of Goods Sold");
$goods->setDimensions(6, 6);
$yearArr = $this->get_yearName();
$goods->setLabels(ArrayUtils::pluck($yearArr, 'payment_year'));
$goods->setYAxis("Sales", array("numberHumanize" => true, 'numberPrefix' => "\$"));
$goodsSoldData = $this->get_goodsSold();
foreach ($goodsSoldData as $key => $value) {
$goods->addSeries($key, $key, ArrayUtils::pluck($value, "total_amount"), array('numberPrefix' => "\$", 'seriesStacked' => true));
}
$this->addComponent($goods);
}
