/**
* Function generates an array with details for generating the chart
*
*
* @return xml
*/
function generateChart()
{
$output['type'] = Display_DChart::getType();
$output['frommnth'] = Display_DChart::getDay(0);
$output['tomnth'] = Display_DChart::getDay(1);
$output['fromyr'] = Display_DChart::getYear(0);
$output['toyr'] = Display_DChart::getYear(1);
$id = ctype_digit($_GET['id']) ? $_GET['id'] : '';
$ChartDetails = new Core_CChart();
$chartdet = $ChartDetails->getChartDetails($id);
$output['id'] = $id;
$output['header'] = $chartdet['header'];
$sql = $chartdet['sql'];
$strParam = $chartdet['strParam'];
$genXML = new Core_CChart();
$output['xml'] = $genXML->generateXML($sql, $strParam);
return $output;
}
/**
* Function generates the data need for the chart to be displayed at the BI Module
* from admin side
*
* @return array
*/
function showChart()
{
include 'classes/Core/CRoleChecking.php';
$chkuser = Core_CRoleChecking::checkRoles();
if ($chkuser) {
include 'classes/Core/CAdminHome.php';
$output['username'] = Core_CAdminHome::userName();
$output['currentDate'] = date('l, M d, Y H:i:s');
$output['monthlyorders'] = (int) Core_CAdminHome::monthlyOrders();
$output['previousmonthorders'] = (int) Core_CAdminHome::previousMonthOrders();
$output['totalorders'] = (int) Core_CAdminHome::totalOrders();
$output['currentmonthuser'] = (int) Core_CAdminHome::currentMonthUser();
$output['previousmonthuser'] = (int) Core_CAdminHome::previousMonthUser();
$output['totalusers'] = (int) Core_CAdminHome::totalUsers();
$output['currentmonthincome'] = Core_CAdminHome::currentMonthIncome();
$output['previousmonthincome'] = Core_CAdminHome::previoustMonthIncome();
$output['totalincome'] = Core_CAdminHome::totalIncome();
$output['currentmonthproudctquantity'] = (int) Core_CAdminHome::currentMonthProudctQuantity();
$output['previousmonthproudctquantity'] = (int) Core_CAdminHome::previousMonthProudctQuantity();
$output['totalproudctquantity'] = (int) Core_CAdminHome::totalProudctQuantity();
$output['lowstock'] = Core_CAdminHome::lowStock();
$output['totalproducts'] = Core_CAdminHome::totalProducts();
$output['enabledproducts'] = Core_CAdminHome::enabledProducts();
$output['disabledproducts'] = Core_CAdminHome::disabledProducts();
$output['pendingorders'] = (int) Core_CAdminHome::pendingOrders();
$output['processingorders'] = (int) Core_CAdminHome::processingOrders();
$output['deliveredorders'] = (int) Core_CAdminHome::deliveredOrders();
include 'classes/Core/CChart.php';
include 'classes/Display/DChart.php';
$output['showchart'] = Core_CChart::generateChart();
Bin_Template::createTemplate('chart.html', $output);
} else {
$output['usererr'] = 'You are Not having Privilege to view this page contact your Admin for detail';
Bin_Template::createTemplate('Errors.html', $output);
}
}
