$arr = DBHelper::selectRows(TBL_REPORTS, null, null, REPORT_PACKAGE_NAME . ',COUNT(*)', REPORT_PACKAGE_NAME, null, false);
if ($arr != null) {
for ($i = 0; $i < sizeof($arr); ++$i) {
$arr[$i][0] = ReportHelper::formatPackageName($arr[$i][0], true);
}
$data = ChartHelper::convertMySQLArrToPieChartJSON($arr);
} else {
$message = 'No data yet recorded.|';
}
break;
case REPORTS_EVOLUTION_LINE_CHART_ID:
$projection = 'DATE(NOW()-INTERVAL ' . INC_VALUE . ' DAY) date, ' . 'DATE_FORMAT(DATE(NOW()-INTERVAL ' . INC_VALUE . ' DAY),"%m-%d") formatted_date, ' . '(SELECT COUNT(*) FROM ' . TBL_REPORTS . ' WHERE DATE(user_crash_date)=date) reports,' . '(SELECT COUNT(*) FROM ' . TBL_ISSUES . ' WHERE DATE(issue_datetime)=date) issues, ' . '(SELECT count(*)/DAYOFYEAR(DATE_FORMAT(' . REPORT_CRASH_DATE . ', "%Y-%m-%d")) FROM ' . TBL_REPORTS . ' WHERE DATE_FORMAT(' . REPORT_CRASH_DATE . ',"%Y")=\'' . date('Y') . '\') avg_per_day_current_year';
$orderby = 'inc ASC LIMIT 15';
$arr = DBHelper::selectRows(TBL_INCREMENTS, null, $orderby, $projection, null, null, true);
if ($arr != null && count($arr) > 0) {
$data = ChartHelper::convertMySQLArrToReportsEvolChartJSON($arr);
} else {
$message = 'No data yet recorded.|';
}
break;
default:
$message = 'Unhandled chart id requested !!!';
}
echo $message . '|' . $data;
break;
//////// CLEAR LOGS
//////// CLEAR LOGS
case 'clearlogs':
if (strcmp($_POST['tab'], 'tabFile') == 0) {
$mDebug = new Debug();
$mDebug->clearLogFile();
