public function consumption_stats_graph($commodity_id = null, $category_id = null, $district_id = null, $facility_code = null, $option = null, $from = null, $to = null, $report_type = null, $tracer = null) { //reset the values here // echo $report_type;exit; $commodity_id = $commodity_id == "NULL" ? null : $commodity_id; $district_id = isset($district_id) && $district_id ? $district_id : $this->session->userdata('district_id'); //$district_id = ($district_id=="NULL") ? null :$district_id; $facility_code = $facility_code == "NULL" ? null : $facility_code; $option = $option == "NULL" || $option == "null" ? null : $option; // $from = ($from == "NULL") ? strtotime(date('01-m-y')) : strtotime(urldecode($from)); // $to = ($to == "NULL") ? strtotime(date('d-m-y')) : strtotime(urldecode($to)); // echo "$from";die; $from = $from == "NULL" ? strtotime(date('Y-m-01')) : strtotime(urldecode($from)); $to = $to == "NULL" ? strtotime(date('Y-m-d')) : strtotime(urldecode($to)); $category_id = $category_id == "NULL" ? null : $category_id; $county_id = $this->session->userdata('county_id'); $county_name = counties::get_county_name($county_id); $category_data = $series_data = $graph_data = $series_data_ = array(); //check if the district is set $district_data = isset($district_id) && $district_id > 0 ? districts::get_district_name($district_id)->toArray() : null; $district_name_ = isset($district_data) ? " :" . $district_data[0]['district'] . " subcounty" : null; $option_new = isset($option) ? $option : "packs"; $facility_code_ = isset($facility_code) ? facilities::get_facility_name_($facility_code)->toArray() : null; $facility_name = $facility_code_[0]['facility_name']; $commodity_name = isset($commodity_id) ? Commodities::get_details($commodity_id)->toArray() : null; $category_name_ = @$commodity_name[0]['commodity_name']; $commodity_name = isset($category_name_) ? " for " . $category_name_ : null; $title = isset($facility_code) && isset($district_id) ? "{$district_name_} : {$facility_name}" : ($district_id > 0 && !isset($facility_code) ? "{$district_name_}" : "{$county_name['county']} county"); $time = "between " . date('j M y', $from) . " and " . date('j M y', $to); $consumption_data = Facility_stocks::get_county_consumption_level_new($facility_code, $district_id, $county_id, $category_id, $commodity_id, $option_new, $from, $to, $report_type, $tracer); // echo "<pre>"; // print_r($consumption_data);die; foreach ($consumption_data as $data) { if ($report_type == "table_data") { if ($commodity_id > 0) { array_push($series_data, array($data['district'], $data["facility_name"], $data["facility_code"], $data['commodity'], (int) $data['total'])); } else { array_push($series_data, array($data["name"], $data['commodity'], (int) $data['total'])); } } else { $series_data = array_merge($series_data, array((int) $data['total'])); $series_data_ = array_merge($series_data_, array(array($data["district"], $data["facility_name"], $data['commodity_name'], (int) $data['total']))); $category_data = array_merge($category_data, array($data["name"])); } // } if ($report_type == "csv_data") { //seth $excel_data = array('doc_creator' => $this->session->userdata('full_name'), 'doc_title' => "Consumption level {$commodity_name} {$title} {$time}", 'file_name' => "consumption_level_{$commodity_name_}{$title_}{$time}"); $row_data = array(); $column_data = array("District", "Facility", "Commodity", "Consumption Level in {$option_new}"); $excel_data['column_data'] = $column_data; $row_data = array_merge($row_data, $series_data_); //echo "<pre>";print_r($row_data);echo "</pre>";exit; $excel_data['row_data'] = $row_data; $this->hcmp_functions->create_excel($excel_data); //echo $commodity_name.$title.$time;exit; } elseif ($report_type == "table_data") { if ($commodity_id > 0) { $category_data = array(array("Sub-county", "Facility Name", "Mfl", "Commodity Name", "TOTAL " . $option_new)); } else { // array_push($category_data, array("Commodity Name", "stocks worth in $option_new")); array_push($category_data, array("Consumption level {$commodity_name} {$title} {$time}", "Commodity Name", "stocks worth in {$option_new}")); } $graph_data = array_merge($graph_data, array("table_id" => 'dem_graph_')); $graph_data = array_merge($graph_data, array("table_header" => $category_data)); $graph_data = array_merge($graph_data, array("table_body" => $series_data)); $data['table'] = $this->hcmp_functions->create_data_table($graph_data); $data['table_id'] = "dem_graph_"; return $this->load->view("shared_files/report_templates/data_table_template_v", $data); } else { $graph_type = 'bar'; // $graph_type = 'column'; $graph_data = array_merge($graph_data, array("graph_id" => 'dem_graph_')); $graph_data = array_merge($graph_data, array("graph_title" => "Consumption level {$commodity_name} {$title} {$time}")); $graph_data = array_merge($graph_data, array("graph_type" => $graph_type)); $graph_data = array_merge($graph_data, array("graph_yaxis_title" => "Commodity Consumption level in {$option_new}")); $graph_data = array_merge($graph_data, array("graph_categories" => $category_data)); $graph_data = array_merge($graph_data, array("series_data" => array('total' => $series_data))); $data = array(); $data['graph_id'] = 'dem_graph_'; $data['high_graph'] = $this->hcmp_functions->create_high_chart_graph($graph_data); return $this->load->view("shared_files/report_templates/high_charts_template_v", $data); } }