INNER JOIN mst_coll_type AS ct ON i.coll_type_id=ct.coll_type_id
GROUP BY i.coll_type_id ORDER BY COUNT(loan_id) DESC');
while ($data = $report_q->fetch_row()) {
$plot_data[] = array($data[0], $data[1]);
$data_colors[] = '#' . generateRandomColors();
}
break;
default:
$stat_query = $dbs->query('SELECT gmd_name, COUNT(biblio_id) AS total_titles
FROM `biblio` AS b
INNER JOIN mst_gmd AS gmd ON b.gmd_id = gmd.gmd_id
GROUP BY b.gmd_id HAVING total_titles>0 ORDER BY COUNT(biblio_id) DESC');
// set plot data and colors
while ($data = $stat_query->fetch_row()) {
$plot_data[] = array($data[0], $data[1]);
$data_colors[] = '#' . generateRandomColors();
}
break;
}
/**
* Charts data definition end
*/
// Create plot
if ($plot_data && $chart) {
// set plot titles
$plot->SetTitle($chart_title);
// set data
$plot->SetDataValues($plot_data);
// set plot colors
$plot->SetDataColors($data_colors);
// set plot shading
}
break;
default:
$stat_query = $dbs->query('SELECT gmd_name, COUNT(biblio_id) AS total_titles
FROM `biblio` AS b
INNER JOIN mst_gmd AS gmd ON b.gmd_id = gmd.gmd_id
GROUP BY b.gmd_id HAVING total_titles>0 ORDER BY COUNT(biblio_id) DESC');
// set plot data and colors
while ($data = $stat_query->fetch_row()) {
if ($sysconf['chart']['mode'] == 'plot') {
$plot_data[] = array($data[0], $data[1]);
$data_colors[] = '#' . generateRandomColors();
} else {
$plot_data .= '{ value: ' . $data[1] . ',
color: "#' . generateRandomColors() . '",
highlight: "#' . generateRandomColors() . '",
label: "' . $data[0] . '" },';
}
}
break;
}
/**
* Charts data definition end
*/
// Create plot
if ($sysconf['chart']['mode'] == 'plot') {
if ($plot_data && $chart) {
// set plot titles
$plot->SetTitle($chart_title);
// set data
$plot->SetDataValues($plot_data);
