public function manage_commodities() { $data['title'] = "Commodities"; $data['content_view'] = "Admin/commodities_v"; $data['commodity_list'] = commodity_sub_category::get_all(); $this->load->view("shared_files/template/dashboard_v", $data); }
public function county_consumption() { $county_id = $this->session->userdata('county_id'); $data['district_data'] = districts::getDistrict($county_id); $data['c_data'] = Commodities::get_all_2(); $data['categories'] = commodity_sub_category::get_all_pharm(); $data['title'] = "Consumption"; $data['banner_text'] = "Consumption"; $data['content_view'] = "facility/facility_reports/reports_v"; $data['report_view'] = "subcounty/reports/county_consumption_data_filter_v"; $data['sidebar'] = "shared_files/report_templates/side_bar_sub_county_v"; $data['active_panel'] = 'consumption'; $this->load->view("shared_files/template/template", $data); }
public function get_consumption_chart_ajax($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_age($commodity_id, $from, $to, $sub_category); $commodity_name = ''; if ($commodity_id != '') { $commodity_details = Commodities::get_commodity_name($commodity_id); $commodity_name = $commodity_details[0]['commodity_name']; } else { $commodity_details = commodity_sub_category::get_dets_one($sub_category); } $val1 = intval($consumption['5']); $val2 = intval($consumption['above']); $graph_id = 'dem_graph_'; $data['graph_id'] = 'dem_graph_'; $text_title = $commodity_name . ' consumption by Age 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: '{$commodity_name}',\n colorByPoint: true,\n data: [{\n name: 'Under 5 years ({$val1} units)',\n y: {$val1}\n }, {\n name: 'Over 5 Years ({$val2} units)',\n y:{$val2},\n sliced: true,\n selected: true\n }]\n }]\n });"; // $result_table .= ' $data['high_graph'] = $result_chart; return $this->load->view("shared_files/report_templates/high_charts_template_v", $data); echo $result_chart; }