I’m trying to create a custom report dashboard in the front-end with a nice chart with the daily sales, but I fail to retrieve the reports
what I tried which its giving me You have an error in your SQL syntax
error is
function full_month_report(){
include_once(WC()->plugin_path().'/includes/admin/reports/class-wc-admin-report.php');
include_once(WC()->plugin_path(). '/includes/admin/reports/class-wc-report-sales-by-date.php' );
$sales_by_date = new WC_Report_Sales_By_Date();
$d = date_i18n('t');
$d = (int)$d;
$month_report = array();
for($i = 1; $i <= $d; $i++){
$i = sprintf("%02d", $i);
$date = strtotime(date( 'Ym'.$i ));
$sales_by_date->start_date = $date;
$sales_by_date->end_date = $date;
$day_report = $sales_by_date->get_report_data();
array_push($day_report, $month_report);
}
return $month_report;
}
What’s the best way to get an object/array with the reports data in front-end?
Go to Source
Author: Razvan Cuceu