Monthly Report

'; function GetMonthsSales() { $sql = " select count(1) as bills, DATE_FORMAT(STR_TO_DATE(JSON_UNQUOTE(JSON_EXTRACT(attributes,'$.issue_date')), '%Y-%m-%d'),'%M %Y') as vshow , DATE_FORMAT(STR_TO_DATE(JSON_UNQUOTE(JSON_EXTRACT(attributes,'$.issue_date')), '%Y-%m-%d'),'%Y%m') as value from billing_invoice group by DATE_FORMAT(STR_TO_DATE(JSON_UNQUOTE(JSON_EXTRACT(attributes,'$.issue_date')),'%Y-%m-%d'),'%M %Y') ,DATE_FORMAT(STR_TO_DATE(JSON_UNQUOTE(JSON_EXTRACT(attributes,'$.issue_date')),'%Y-%m-%d'),'%Y%m') order by DATE_FORMAT(STR_TO_DATE(JSON_UNQUOTE(JSON_EXTRACT(attributes,'$.issue_date')),'%Y-%m-%d'),'%Y%m') desc; "; $db=Master_DBController::getInstance(); $Amount = $db->runBaseQuery($sql); return (json_encode($Amount)); } $Months = GetMonthsSales(); $m = json_decode($Months); echo ' '; echo '

'; $temp_name_pdf = '/apps/billing/tmp/sales_' . $_SESSION['user_id'] . '.pdf'; if (file_exists($_SERVER['DOCUMENT_ROOT'] .$temp_name_pdf)) unlink($_SERVER['DOCUMENT_ROOT'] .$temp_name_pdf); createPDFSales($dat, $_SERVER['DOCUMENT_ROOT'] . $temp_name_pdf); ?>