public function program_reports() { $malaria_report_data = ''; $user_indicator = $this->session->userdata('user_indicator'); switch ($user_indicator) { case facility_admin: case facility: $facility_id = $this->session->userdata('facility_id'); $report_malaria = Malaria_Data::get_facility_report_details($facility_id); $report_RH = RH_Drugs_Data::get_facility_report_details($facility_id); $report_TB = tb_data::get_facility_report_details($facility_id); $facility_details = Facilities::get_facility_name2($facility_id); $facility_mfl = $facility_id; $facility_name = $facility_details['facility_name']; // $malaria_report_data = '<tr><td>'.$facility_name.'</td><td>'.$facility_mfl.'</td><td>HCMP</td><td><a href = "'.base_url().'divisional_reports/malaria_report" class = "btn btn-primary btn-sm">View Malaria Report</a></td></tr>'; if (!empty($report_RH) && !empty($report_malaria) && !empty($report_TB)) { $report_RH_report[$index] = $report_RH; $report_malaria_report[$index] = $report_malaria; $report_tuberculosis_report[$index] = $report_TB; } else { } $data['fac_mfl'] = $facility_mfl; $data['mal_report_data'] = $this->createmalariareport($facility_mfl); $data['page_header'] = "Program Reports"; $data['malaria'] = $report_malaria_report; $data['RH'] = $report_RH_report; $data['TB'] = $report_tuberculosis_report; $data['title'] = "Facility Program Reports"; $data['banner_text'] = "Facility Program Reports"; $data['report_view'] = "subcounty/reports/program_reports_v"; $data['sidebar'] = "shared_files/report_templates/side_bar_v"; $data['active_panel'] = "program_reports"; break; case district: $district_id = $this->session->userdata('district_id'); $facilities = Facilities::get_district_facilities($district_id); $index = 0; foreach ($facilities as $ids) { $facility_id = $ids['facility_code']; $report_malaria = Malaria_Data::get_facility_report_details($facility_id); $report_RH = RH_Drugs_Data::get_facility_report_details($facility_id); $report_TB = tb_data::get_facility_report_details($facility_id); $facility_details = Facilities::get_facility_name2($facility_id); $facility_mfl = $facility_id; $facility_name = $facility_details['facility_name']; $malaria_report_data .= '<option value = "' . $facility_mfl . '">' . $facility_name . '</option>'; if (!empty($report_RH) && !empty($report_malaria)) { $report_RH_report[$index] = $report_RH; $report_malaria_report[$index] = $report_malaria; $report_tuberculosis[$index] = $report_TB; } else { } $index++; } $data['mal_report_data'] = $malaria_report_data; $data['page_header'] = "Program Reports"; $data['title'] = "District Program Reports"; $data['banner_text'] = "District Program Reports"; $data['sidebar'] = "shared_files/report_templates/side_bar_sub_county_v"; break; case county: $county_id = $this->session->userdata('county_id'); // $facilities = Facilities::get_all_facilities_in_county($county_id); $subcounties = Counties::get_subcounties_in_county($county_id); $subcounties_listing = ''; foreach ($subcounties as $key => $value) { $subcounties_listing .= '<option value = "' . $value['id'] . '">' . $value['district'] . '</option>'; } $index = 0; // foreach ($facilities as $ids) // { // $facility_id = $ids['facilities']; // $report_malaria = Malaria_Data::get_facility_report_details($facility_id); // $report_RH = RH_Drugs_Data::get_facility_report_details($facility_id) ; // $report_TB = tb_data::get_facility_report_details($facility_id); // $facility_details = Facilities::get_facility_name2($facility_id); // $facility_mfl = $facility_id; // $facility_name = $facility_details['facility_name']; // $malaria_report_data .= '<option value = "'.$facility_mfl.'">'.$facility_name.'</option>'; // if ((!empty($report_RH))&&(!empty($report_malaria))) // { // $report_RH_report[$index] = $report_RH; // $report_malaria_report[$index] = $report_malaria; // $report_tuberculosis[$index] = $report_TB; // }else{ // } // $index++; // } $data['sub_counties'] = $subcounties_listing; $data['mal_report_data'] = $malaria_report_data; $data['page_header'] = "Program Reports"; $data['title'] = "County Program Reports"; $data['banner_text'] = " County Program Reports"; $data['sidebar'] = "shared_files/report_templates/side_bar_sub_county_v"; break; } $data['malaria'] = $report_malaria_report; $data['RH'] = $report_RH_report; $data['TB'] = $report_tuberculosis_report; $data['report_view'] = "subcounty/reports/program_reports_v"; $data['active_panel'] = 'divisional'; if ($this->input->is_ajax_request()) { return $this->load->view("subcounty/reports/program_reports_v", $data); } $data['content_view'] = "facility/facility_reports/reports_v"; $this->load->view('shared_files/template/template', $data); }
public function generate_antimalarial_graph_ajax($county_id) { $subcounties = Counties::get_subcounties_in_county($county_id); $county_dets = Counties::get_county_name($county_id); foreach ($county_dets as $value) { $county_name = $value; } $subcounties_listing = array(); $sub_counties_graph = array(); $sub_counties_names = array(); foreach ($subcounties as $key => $value) { $subcounty_id = $value['id']; $subcounty_name = $value['district']; $antimalarial_data = Malaria_Data::get_sub_county_antimalaria($subcounty_id); if (count($antimalarial_data > 0)) { $b6 = $antimalarial_data[0]['quantity'] != '' ? $antimalarial_data[0]['quantity'] : 0; $b12 = $antimalarial_data[1]['quantity'] != '' ? $antimalarial_data[1]['quantity'] : 0; $b18 = $antimalarial_data[2]['qusantity'] != '' ? $antimalarial_data[2]['quantity'] : 0; $b24 = $antimalarial_data[3]['quantity'] != '' ? $antimalarial_data[3]['quantity'] : 0; } $b6 = intval($b6); $b12 = intval($b12); $b18 = intval($b18); $b24 = intval($b24); $sub_counties_names_list = array('Blister of 6', 'Blister of 12', 'Blister of 18', 'Blister of 24'); array_push($sub_counties_names, $sub_counties_names_list); array_push($sub_counties_graph, $subcounty_name); $bdata = array('Blister of 6' => $b6, 'Blister of 12' => $b12, 'Blister of 18' => $b18, 'Blister of 24' => $b24); // $bdata = array($b6,$b12,$b18,$b24); $subcounties_listing[] = array('id' => $subcounty_id, 'name' => $subcounty_name, 'data' => $bdata); } // $sub_counties_names= array('Blister of 6','Blister of 12','Blister of 18','Blister of 24'); // echo "<pre>"; // print_r($subcounties_listing);die; // $data['count_records'] = count($sub_counties_graph); // $sub_counties_graph = json_encode($sub_counties_graph); // $data['sub_counties'] = str_replace('"', "'", $sub_counties_graph); $graph_data = array(); $graph_data = array_merge($graph_data, array("graph_id" => 'graph-section')); $graph_data = array_merge($graph_data, array("graph_title" => $county_name . ' County Antimalarial Stocks')); $graph_data = array_merge($graph_data, array("graph_type" => 'bar')); $graph_data = array_merge($graph_data, array("graph_yaxis_title" => 'Quantity in Packs')); $graph_data = array_merge($graph_data, array("graph_categories" => array())); $graph_data = array_merge($graph_data, array("series_data" => array($subcounties_listing))); foreach ($subcounties_listing as $subcounties_graph_listing) { $graph_data['graph_categories'] = $sub_counties_graph; $graph_data['series_data']['Quantity'] = array($subcounties_graph_listing['data']); } // foreach ($subcounties_listing as $subcounties_graph_listing) : // echo "<pre>"; // print_r($graph_data['series_data']);die; // $graph_data['graph_categories'] = $sub_counties_names; // $graph_data['series_data']= array($subcounties_graph_listing['data']); // endforeach; // echo "<pre>"; // print_r($graph_data);die; $data['high_graph'] = $this->hcmp_functions->create_high_chart_graph($graph_data); // $data['sub_counties'] = $sub_counties_graph); // echo $data['high_graph'];die; // print_r($data['sub_counties']);die; // $data['graph_title'] = $county_name.' County Antimalarial Stocks'; // // echo $data['graph_title'];die; // $data['report_view'] = "subcounty/reports/program_reports_v_titus"; // $data['content_view'] = "facility/facility_reports/reports_v"; // // $data['subcounties_listing']=json_encode($subcounties_listing); // $data['sidebar'] = "shared_files/report_templates/side_bar_v"; // // $data['report_title'] = "Divisional Malaria Reports"; // $this -> load -> view('shared_files/template/template', $data); return $this->load->view("shared_files/report_templates/high_charts_template_v", $data); }