public function get_consumption_chart_ajax_all($sub_category = null)
{
$commodity_id = $this->input->post('commodity_id');
$from = $this->input->post('from');
$to = $this->input->post('to');
$total = 0;
$to = $to == "NULL" || !isset($to) ? date('Y-m-d 23:59:59') : date('Y-m-d 23:59:59', strtotime(urldecode($to)));
$from = $from == "NULL" || !isset($from) ? date('Y-m-d 00:00:00') : date('Y-m-d 00:00:00', strtotime(urldecode($from)));
$consumption = facility_stocks::get_dispensing_consumption_by_commodity($from, $to, $sub_category);
// echo "<pre>";
// print_r($consumption);die;
// $commodity_details = Commodities::get_commodity_name($commodity_id);
$graph_id = 'dem_graph_';
$data['graph_id'] = 'dem_graph_';
// $commodity_name = $commodity_details[0]['commodity_name'];
$text_title = 'Top 10 Highest Consumption by Commodity between ' . date('F d Y', strtotime($from)) . ' and ' . date('F d Y', strtotime($to));
$result_chart = " \$('#{$graph_id}').highcharts({\n chart: {\n plotBackgroundColor: null,\n plotBorderWidth: null,\n plotShadow: false,\n type: 'pie'\n },\n title: {\n text: '{$text_title}'\n },\n tooltip: {\n pointFormat: '{series.name}: <b>{point.percentage:.1f}%</b>'\n },\n plotOptions: {\n pie: {\n allowPointSelect: false,\n cursor: 'pointer',\n dataLabels: {\n enabled: true\n },\n showInLegend: true\n }\n },\n series: [{\n name: 'Test',\n colorByPoint: true,\n data:[";
foreach ($consumption as $key => $raw_data) {
$name = $raw_data['commodity_name'];
$val = intval($raw_data['total']);
$result_chart .= "{ name: '{$name} ({$val} units)', y:{$val}";
$result_chart .= "},";
}
// series: [{
// name: '$commodity_name',
// colorByPoint: true,
// data: [{
// name: 'Under 5 years ($val1 units)',
// y: $val1
// }, {
// name: 'Over 5 Years ($val2 units)',
// y:$val2,
// selected: true
// }]
// }]
// });";
$result_chart .= "] }] })";
$data['high_graph'] = $result_chart;
return $this->load->view("shared_files/report_templates/high_charts_template_v", $data);
// echo $result_chart;
}
