public function donation_reports($year = null, $district_id = null, $facility_code = null) { //reset the values here $district_id = $this->session->userdata('district_id'); $year = $year == "NULL" ? date('Y') : $year; $district_id = $district_id == "NULL" ? NULL : $district_id; // echo $district_id;exit; $facility_code = $facility_code == "NULL" ? null : $facility_code; $county_id = $this->session->userdata('county_id'); $expiries_array = redistribution_data::get_redistribution_data($facility_code, $district_id, $county_id, $year); $data['donations'] = $expiries_array; $data['year'] = $year; $pending = redistribution_data::get_redistribution_pending($facility_code, $district_id, $county_id, $year); // echo "<pre>";print_r($expiries_array);exit; $data['redistribute_count'] = count(redistribution_data::get_redistribution_pending($facility_code, $district_id, $county_id, $year)); return $this->load->view("shared_files/redistributions_ajax", $data); }
public function donation_reports($year = null, $district_id = null, $facility_code = null) { //reset the values here $year = $year == "NULL" ? date('Y') : $year; $district_id = $district_id == "NULL" ? null : $district_id; $facility_code = $facility_code == "NULL" ? null : $facility_code; $county_id = $this->session->userdata('county_id'); $expiries_array = redistribution_data::get_redistribution_data($facility_code, $district_id, $county_id, $year); //$graph_data = $series_data = array(); //echo "<pre>";print_r($expiries_array);echo "</pre>";exit; //foreach ($expiries_array as $facility_expiry_data) : //$total_units = $facility_expiry_data['total_commodity_units']; //$sent_units = $facility_expiry_data['quantity_sent']; //$received_units = $facility_expiry_data['quantity_received']; // $total_sent = round(($sent_units / $total_units), 1); //$total_received = round(($received_units / $total_units), 1); //endforeach;//exit; //$total_expiry = number_format($total_expiry, 2, '.', ','); // array_push($series_data, array("","","Total for the next $year months",$total_expiry,'')); //$category_data = array( array("From", 'To', "Commodity Name", "District From", "District To", "Unit Size", 'Batch No', 'Expiry Date', 'Manufacturer', 'Quantity Sent(units)', 'Quantity Sent(packs)', 'Quantity Received (units)', 'Quantity Received (packs)', 'Date sent', 'Date Received', 'status')); //$graph_data = array_merge($graph_data, array("table_id" => 'dem_graph_1')); //$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['donations'] = $expiries_array; $data['year'] = $year; $data['redistribute_count'] = count(redistribution_data::get_redistribution_pending($facility_code, $district_id, $county_id, $year)) + 1; return $this->load->view("shared_files/redistributions_ajax", $data); }