public function new_disbursement($id = null)
 {
     if ($id != null) {
         $disbursement = Disbursements::getDisbursement($id);
         $data['disbursement'] = $disbursement[0];
         $data['edit'] = true;
         $data['id'] = $id;
     }
     $districts = new Districts();
     $regions = new Regions();
     $facilities = new Facilities();
     $additional_facilities = new Additional_Facilities();
     $data['vaccines'] = Vaccines::getAll_Minified();
     $archive_date = date('U');
     $data['stock_balance'] = array();
     $district_or_region = $this->session->userdata('district_province_id');
     //Retrieve the user identifier from the session
     $identifier = $this->session->userdata('user_identifier');
     //Check if it's a provincial officer
     if ($identifier == 'provincial_officer') {
         foreach ($data['vaccines'] as $vaccine) {
             $data['stock_balance'][$vaccine->id] = Disbursements::getRegionalPeriodBalance($district_or_region, $vaccine->id, $archive_date);
         }
         $data['districts'] = $districts->getAllDistricts();
         $data['regions'] = $regions->getAllRegions();
     } else {
         if ($identifier == 'district_officer') {
             foreach ($data['vaccines'] as $vaccine) {
                 $data['stock_balance'][$vaccine->id] = Disbursements::getDistrictPeriodBalance($district_or_region, $vaccine->id, $archive_date);
             }
             $district_province = $districts->getDistrictProvince($district_or_region);
             $data['districts'] = $districts->getProvinceDistricts($district_province['province']);
             $data['facilities'] = $facilities->getDistrictFacilities($district_or_region);
             $data['additional_facilities'] = $additional_facilities->getExtraFacilities($district_or_region);
         } else {
             if ($identifier == 'national_officer') {
                 foreach ($data['vaccines'] as $vaccine) {
                     $data['stock_balance'][$vaccine->id] = Disbursements::getNationalPeriodBalance($vaccine->id, $archive_date);
                 }
                 $data['districts'] = $districts->getAllDistricts();
                 $data['regions'] = $regions->getAllRegions();
             }
         }
     }
     $data['title'] = "Disbursement Management::Disburse Vaccines";
     $data['content_view'] = "add_disbursement_view";
     $data['quick_link'] = "new_disbursement";
     $this->base_params($data);
 }
 public function add($data = array())
 {
     $access_level = $this->session->userdata('user_indicator');
     if ($access_level == "district_clerk") {
         $district = $this->session->userdata('district_province_id');
         $data['facilities'] = Facilities::getDistrictFacilities($district);
     }
     $provinces = Province::getAll();
     $districts = District::getAll();
     $diseases = Disease::getAllObjects();
     $data['provinces'] = $provinces;
     $data['districts'] = $districts;
     $data['diseases'] = $diseases;
     $data['editing'] = false;
     $data['prediction'] = Surveillance::getPrediction();
     $data['scripts'] = array("special_date_picker.js", "validationEngine-en.js", "validator.js");
     $data["styles"] = array("validator.css");
     $this->base_params($data);
 }
Esempio n. 3
0
	public function get_district_facilities($district) {
		$facilities = Facilities::getDistrictFacilities($district);
		$facilities_array = array();
		$counter = 0;
		foreach ($facilities as $facility) {
			$facility_details = array("facility_code" => utf8_encode($facility -> facilitycode), "name" => utf8_encode($facility -> name));
			$facilities_array[$counter] = $facility_details;
			$counter++;
		}
		echo json_encode($facilities_array); 
	}
Esempio n. 4
0
 public function send_emails()
 {
     $this->load->helper(array('file'));
     $config['protocol'] = 'smtp';
     $config['smtp_host'] = 'ssl://smtp.googlemail.com';
     $config['smtp_port'] = 465;
     $config['smtp_user'] = stripslashes('*****@*****.**');
     $config['smtp_pass'] = stripslashes('projectDVI');
     $this->load->library('email', $config);
     $this->load->database();
     $period = 'Jun-12';
     //First, retrieve all the districts that have recipients
     $sql = "select distinct district, d.name as district_name from stock_out_recipient s left join districts d on district = d.id where s.disabled = '0'";
     $query = $this->db->query($sql);
     $district_array = $query->result_array();
     //get the total number of vaccines that report dhis data
     $vaccine_number = Vaccines::getTotalDHIS();
     $vaccine_number++;
     //Get the vaccines wiith dhis data
     $vaccines = Vaccines::getDHIS();
     $months = array();
     foreach ($district_array as $district) {
         $data_buffer = "\n\t\t\t<style>\n\t\t\ttable.data-table {\n\t\t\ttable-layout: fixed;\n\t\t\twidth: 1000px;\n\t\t\tborder-collapse:collapse;\n\t\t\tborder:1px solid black;\n\t\t\tmargin-top:20px;\n\t\t\t}\n\t\t\ttable.data-table td, th {\n\t\t\twidth: 100px;\n\t\t\tborder: 1px solid black;\n\t\t\t}\n\t\t\t.leftie{\n\t\t\t\ttext-align: left !important;\n\t\t\t}\n\t\t\t.right{\n\t\t\t\ttext-align: right !important;\n\t\t\t}\n\t\t\t.center{\n\t\t\t\ttext-align: center !important;\n\t\t\t}\n\t\t\t</style> \n\t\t\t";
         $data_buffer .= "<table class='data-table'>";
         $data_buffer .= $this->echoTitles();
         $data_buffer .= "<tr>";
         //loop through all the months in the season
         for ($x = 1; $x <= 12; $x++) {
             //get the month name
             $text = "2012-" . $x . "-1";
             $period = date("M-y", strtotime($text));
             $months[$x] = $period;
             $data_buffer .= "<td>" . $period . "</td>";
         }
         $data_buffer .= "</tr>";
         //Loop through the returned districts, generating a report for each
         $district_name = $district['district_name'];
         $district = $district['district'];
         //get all facilities for this district
         $facilities = Facilities::getDistrictFacilities($district);
         //loop through all the facilities to return immunization data
         foreach ($facilities as $facility) {
             $data_buffer .= "<tr><td rowspan='{$vaccine_number}'>" . $facility->name . "</td>";
             $data_buffer .= "<td>Children Immunized</td>";
             //get the total number of children immunized in this facility
             foreach ($months as $month) {
                 $sql_children = "select fully_immunized_children from dhis_data where facility_code = '{$facility->facilitycode}' and reporting_period = '{$month}'";
                 $query_children = $this->db->query($sql_children);
                 $immunized_children = $query_children->row_array();
                 if (isset($immunized_children['fully_immunized_children'])) {
                     $data_buffer .= "<td>" . $immunized_children['fully_immunized_children'] . "</td>";
                 } else {
                     $data_buffer .= "<td>N/A</td>";
                 }
             }
             $data_buffer .= "</tr>";
             foreach ($vaccines as $vaccine) {
                 $data_buffer .= "<tr><td>" . $vaccine->Name . "</td>";
                 $dhis_remaining = $vaccine->Dhis_Remaining;
                 $dhis_received = $vaccine->Dhis_Received;
                 $dhis_stock = $vaccine->Dhis_Stock;
                 foreach ($months as $month) {
                     //For each vaccine, create a query to get its dhis data
                     $sql_remaining = "select {$dhis_remaining}, {$dhis_received}, {$dhis_stock} from dhis_data where facility_code = '{$facility->facilitycode}' and reporting_period = '{$month}'";
                     $query_remaining = $this->db->query($sql_remaining);
                     $remaining_stock = $query_remaining->row_array();
                     //var_dump($query_remaining);
                     if (!empty($remaining_stock)) {
                         if (strlen($remaining_stock[$dhis_received]) > 0 || strlen($remaining_stock[$dhis_remaining]) > 0 || strlen($remaining_stock[$dhis_stock]) > 0) {
                             if ($remaining_stock[$dhis_remaining] == "0" || $remaining_stock[$dhis_remaining] == "" || $remaining_stock[$dhis_remaining] == null) {
                                 $data_buffer .= "<td style='background-color: red;'>" . $remaining_stock[$dhis_remaining] . "</td>";
                             } else {
                                 $data_buffer .= "<td>" . $remaining_stock[$dhis_remaining] . "</td>";
                             }
                         } else {
                             $data_buffer .= "<td style='text-align:center'>-</td>";
                         }
                     } else {
                         $data_buffer .= "<td style='text-align:center'>-</td>";
                     }
                 }
             }
             $data_buffer .= "</tr>";
         }
         $data_buffer .= "</table>";
         //echo $data_buffer;
         $this->generatePDF($data_buffer, $district_name);
     }
 }