public function export($type, $id, $vaccine) {
//Retrieve the user identifier
$from = $this -> session -> userdata('external_from');
$to = $this -> session -> userdata('external_to');
if ($to == false) {
$to = date("U", mktime(0, 0, 0, 1, 1, date("Y") + 1));
}
if ($from == false) {
$from = date("U", mktime(0, 0, 0, 1, 1, date('Y')));
}
$offset = 0;
$items_per_page = 1000;
$district = $this -> session -> userdata('external_district');
$region = $this -> session -> userdata('external_region');
$order_by = $this -> session -> userdata('external_order_by');
$order = $this -> session -> userdata('external_order');
$origin_region = $id;
$origin_district = $id;
$disbursements = null;
$data = null;
if ($type == "national_officer") {//National Level
if ($order == 2) {
$balance = Disbursements::getNationalPeriodBalance($vaccine, $from);
} else if ($order == "DESC") {
$balance = Disbursements::getNationalPeriodBalance($vaccine, $to);
}
$disbursements = Disbursements::getNationalDisbursements($vaccine, $from, $to, $offset, $items_per_page, $district, $region, $order_by, $order, $balance);
} else if ($type == 0) {//Regional Level
if ($order == "ASC") {
$balance = Disbursements::getRegionalPeriodBalance($origin_region, $vaccine, $from);
} else if ($order == "DESC") {
$balance = Disbursements::getRegionalPeriodBalance($origin_region, $vaccine, $to);
}
$disbursements = Disbursements::getRegionalDisbursements($origin_region, $vaccine, $from, $to, $offset, $items_per_page, $district, $region, $order_by, $order, $balance);
} else if ($type == 1) {//District Level
if ($order == "ASC") {
$balance = Disbursements::getDistrictPeriodBalance($origin_district, $vaccine, $from);
} else if ($order == "DESC") {
$balance = Disbursements::getDistrictPeriodBalance($origin_district, $vaccine, $to);
}
$disbursements = Disbursements::getDistrictDisbursements($origin_district, $vaccine, $from, $to, $offset, $items_per_page, $district, $region, $order_by, $order, $balance);
}
$reducing_balance = $balance;
$headers = "Balance From Previous Period: " . $balance . "\t\nDate Issued\t Vaccines To/From \t Amount Received\t Amount Issued \tStore Balance\t Voucher Number\t Batch Number\t Vaccine Expiry Date\t Recorded By\t\n";
foreach ($disbursements as $disbursement) {
$data .= $disbursement -> Date_Issued . "\t";
//If the vaccines were issued to a Region, display the name
if ($disbursement -> Issued_To_Region != null && $disbursement -> Issued_To_Region != $origin_region) {
$data .= $disbursement -> Region_Issued_To -> name . "\t";
$data .= " \t" . $disbursement -> Quantity . "\t";
}
//If the vaccines were received from a region (apart from ourselves ofcourse) display the name
if ($disbursement -> Issued_By_Region != null && $disbursement -> Issued_By_Region != $origin_region) {
$data .= $disbursement -> Region_Issued_By -> name . "\t";
$data .= $disbursement -> Quantity . "\t\t";
}
//If the vaccines were issued to a District other than ourselves, display the name
if ($disbursement -> Issued_To_District != null && $disbursement -> Issued_To_District != $origin_district) {
$data .= $disbursement -> District_Issued_To -> name . "\t";
$data .= " \t" . $disbursement -> Quantity . "\t";
}
//If the vaccines were received from a district (apart from ourselves ofcourse) display the name
if ($disbursement -> Issued_By_District != null && $disbursement -> Issued_By_District != $origin_district) {
$data .= $disbursement -> District_Issued_By -> name . "\t";
$data .= $disbursement -> Quantity . "\t\t";
}
//If the vaccines were issued the Central store, Display UNICEF as the source
if ($disbursement -> Issued_To_National == "0") {
$data .= "UNICEF\t";
$data .= $disbursement -> Quantity . "\t\t";
}
//If the vaccines were issued by Central store and if this is not the national store, Display National Store as the source
if ($disbursement -> Issued_By_National == "0" && $type != 2) {
$data .= "Central Vaccine Stores\t";
$data .= $disbursement -> Quantity . "\t\t";
}
$data .= $disbursement -> Total_Stock_Balance . "\t";
$data .= $disbursement -> Voucher_Number . "\t";
$data .= $disbursement -> Batch_Number . "\t";
$data .= $disbursement -> Batch -> Expiry_Date . "\t";
$data .= $disbursement -> User -> Full_Name . "\t";
$data .= "\n";
}
header("Content-type: application/vnd.ms-excel; name='excel'");
header("Content-Disposition: filename=stock_ledger_export.xls");
// Fix for crappy IE bug in download.
header("Pragma: ");
header("Cache-Control: ");
echo $headers . $data;
}
public function view_disbursements($paged_vaccine = null, $date_from = null, $date_to = null, $offset = 0, $default_offset = 0) {
$district_or_province = $this -> session -> userdata('district_province_id');
$this -> load -> helper('to_excel');
$to = $this -> input -> post('to');
$from = $this -> input -> post('from');
$store = $this -> input -> post('selected_store_id');
$order_by = $this -> input -> post('order_by');
$order = $this -> input -> post('order');
$per_page = $this -> input -> post('per_page');
if ($to == false) {
$to = date("U", mktime(0, 0, 0, 1, 1, date("Y") + 1));
} else if ($to == true) {
$to = strtotime($to);
}
if ($from == false) {
$from = date("U", mktime(0, 0, 0, 1, 1, date('Y')));
} else if ($from == true) {
$from = strtotime($from);
}
if ($date_from != null) {
$from = $date_from;
} else if ($date_to != null) {
$to = $date_to;
}
//Check if the user has specified how many items he/she wants per page. If not, default to 10 items per page.
if ($per_page > 0) {
$this -> session -> set_userdata(array("from" => $from, "to" => $to, "per_page" => $per_page, "order_by" => $order_by, "order" => $order));
} else {
$temp = $this -> session -> userdata('per_page');
if ($temp == false) {
$this -> session -> set_userdata(array("from" => $from, "to" => $to, "per_page" => 10, "order_by" => "Unix_Timestamp(str_to_date(Date_Issued,'%m/%d/%Y'))", "order" => "DESC"));
}
}
$items_per_page = $this -> session -> userdata('per_page');
$order_by = $this -> session -> userdata('order_by');
$order = $this -> session -> userdata('order');
$region = 0;
$district = 0;
if ($store != null) {
$split_parts = explode("_", $store);
$type = $split_parts[0];
$id = $split_parts[1];
if ($type == "district") {
$district = $id;
$this -> session -> set_userdata(array("region" => ""));
$this -> session -> set_userdata(array("district" => $district));
} else if ($type == "region") {
$region = $id;
$this -> session -> set_userdata(array("district" => ""));
$this -> session -> set_userdata(array("region" => $region));
} else if ($type == "national") {
$this -> session -> set_userdata(array("district" => ""));
$this -> session -> set_userdata(array("region" => ""));
}
}
$district = $this -> session -> userdata('district');
$region = $this -> session -> userdata('region');
$data['title'] = "Disbursement Management::Vaccine Stock Ledger For The Period Between " . date('d/m/Y', $from) . " to " . date('d/m/Y', $to);
$data['content_view'] = "view_ledger_view";
$data['vaccines'] = Vaccines::getAll_Minified();
$return_array = array();
$balances = array();
//Retrieve the user identifier from the session
$identifier = $this -> session -> userdata('user_identifier');
if ($identifier == "national_officer") {//National Level
foreach ($data['vaccines'] as $vaccine) {
//skip the vaccine that is currently being browsed through
if ($vaccine -> id == $paged_vaccine) {
continue;
}
$total_disbursements = Disbursements::getTotalNationalDisbursements($vaccine -> id, $from, $to, $district, $region);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "disbursement_management/view_disbursements/" . $vaccine -> id . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 7;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$vaccine -> id] = $this -> pagination -> create_links();
}
$balances[$vaccine -> id] = Disbursements::getNationalPeriodBalance($vaccine -> id, $from);
$return_array[$vaccine -> id] = Disbursements::getNationalDisbursements($vaccine -> id, $from, $to, $default_offset, $items_per_page, $district, $region, $order_by, $order, $balances[$vaccine -> id]);
}
if ($paged_vaccine != null) {
$data['paged_vaccine'] = $paged_vaccine;
$total_disbursements = Disbursements::getTotalNationalDisbursements($paged_vaccine, $from, $to, $district, $region);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "disbursement_management/view_disbursements/" . $paged_vaccine . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 6;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$paged_vaccine] = $this -> pagination -> create_links();
}
$balances[$paged_vaccine] = Disbursements::getNationalPeriodBalance($paged_vaccine, $from);
$return_array[$paged_vaccine] = Disbursements::getNationalDisbursements($paged_vaccine, $from, $to, $offset, $items_per_page, $district, $region, $order_by, $order, $balances[$paged_vaccine]);
}
} else if ($identifier == "provincial_officer") {//Regional Store Level
foreach ($data['vaccines'] as $vaccine) {
if ($vaccine -> id == $paged_vaccine) {
continue;
}
$total_disbursements = Disbursements::getTotalRegionalDisbursements($district_or_province, $vaccine -> id, $from, $to, $district, $region);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "disbursement_management/view_disbursements/" . $vaccine -> id . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 7;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$vaccine -> id] = $this -> pagination -> create_links();
}
$balances[$vaccine -> id] = Disbursements::getRegionalPeriodBalance($district_or_province, $vaccine -> id, $from);
$return_array[$vaccine -> id] = Disbursements::getRegionalDisbursements($district_or_province, $vaccine -> id, $from, $to, $default_offset, $items_per_page, $district, $region, $order_by, $order, $balances[$vaccine -> id]);
}
if ($paged_vaccine != null) {
$data['paged_vaccine'] = $paged_vaccine;
$total_disbursements = Disbursements::getTotalRegionalDisbursements($district_or_province, $paged_vaccine, $from, $to, $district, $region);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "disbursement_management/view_disbursements/" . $paged_vaccine . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 6;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$paged_vaccine] = $this -> pagination -> create_links();
}
$balances[$paged_vaccine] = Disbursements::getRegionalPeriodBalance($district_or_province, $paged_vaccine, $from);
$return_array[$paged_vaccine] = Disbursements::getRegionalDisbursements($district_or_province, $paged_vaccine, $from, $to, $offset, $items_per_page, $district, $region, $order_by, $order, $balances[$paged_vaccine]);
}
} else if ($identifier == "district_officer") {//District Store Level
foreach ($data['vaccines'] as $vaccine) {
if ($vaccine -> id == $paged_vaccine) {
continue;
}
$total_disbursements = Disbursements::getTotalDistrictDisbursements($district_or_province, $vaccine -> id, $from, $to, $district);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "disbursement_management/view_disbursements/" . $vaccine -> id . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 7;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$vaccine -> id] = $this -> pagination -> create_links();
}
$balances[$vaccine -> id] = Disbursements::getDistrictPeriodBalance($district_or_province, $vaccine -> id, $from);
$return_array[$vaccine -> id] = Disbursements::getDistrictDisbursements($district_or_province, $vaccine -> id, $from, $to, $default_offset, $items_per_page, $district, $order_by, $order, $balances[$vaccine -> id]);
}
if ($paged_vaccine != null) {
$data['paged_vaccine'] = $paged_vaccine;
$total_disbursements = Disbursements::getTotalDistrictDisbursements($district_or_province, $paged_vaccine, $from, $to, $district);
if ($total_disbursements > $items_per_page) {
$config['base_url'] = base_url() . "disbursement_management/view_disbursements/" . $paged_vaccine . "/" . $from . "/" . $to;
$config['total_rows'] = $total_disbursements;
$config['per_page'] = $items_per_page;
$config['uri_segment'] = 6;
$config['num_links'] = 5;
$this -> pagination -> initialize($config);
$data['pagination'][$paged_vaccine] = $this -> pagination -> create_links();
}
$balances[$paged_vaccine] = Disbursements::getDistrictPeriodBalance($district_or_province, $paged_vaccine, $from);
$return_array[$paged_vaccine] = Disbursements::getDistrictDisbursements($district_or_province, $paged_vaccine, $from, $to, $offset, $items_per_page, $district, $order_by, $order, $balances[$paged_vaccine]);
}
}
$data['disbursements'] = $return_array;
$data['balances'] = $balances;
$data['stylesheets'] = array("pagination.css");
//Get all the districts and regions so as to enable drilling down to a particular store
$data['districts'] = Districts::getAllDistricts();
$data['regions'] = Regions::getAllRegions();
$this -> base_params_min($data);
}
