public function get_facility_bin_card_pdf($facility_code, $report_type, $commodity_id)
{
$county_id = $this->session->userdata('county_id');
$district_id = $this->session->userdata('district_id');
$param = implode('/', func_get_args());
$args = array();
$args = func_get_args();
$facility_code = $args[0];
$commodity_id = $args[1];
$from_ = array($args[2], $args[3], $args[4]);
$to_ = array($args[5], $args[6], $args[7]);
$from = implode('/', $from_);
$to = implode('/', $to_);
$commodity_name = Commodities::get_commodity_name($commodity_id);
$county = Counties::get_county_name($county_id);
$district = Districts::get_district_name_($district_id);
$county_name = $county['county'];
$district_name = $district['district'];
$bin_card_data = Facility_issues::get_bin_card($facility_code, $commodity_id, $from, $to);
$myobj = Doctrine::getTable('Facilities')->findOneByfacility_code($facility_code);
$facility_name = $myobj->facility_name;
$bin_card_data_count = count(Facility_issues::get_bin_card($facility_code, $commodity_id, $from, $to));
//create the table for displaying the order details
$html_body = "<table class='data-table' width=100%>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>MFL No: {$facility_code}</td> \n\t\t\t\t\t\t\t<td>Health Facility Name:<br/> {$facility_name}</td>\n\t\t\t\t\t\t\t<td>Level:</td>\n\t\t\t\t\t\t\t<td>Dispensary</td>\n\t\t\t\t\t\t\t<td>Health Centre</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>County: {$county_name}</td> \n\t\t\t\t\t\t\t<td> District: {$district_name}</td>\n\t\t\t\t\t\t\t<td >Reporting Period <br/>\n\t\t\t\t\t\t\t\tStart Date: <br/> End Date: " . date('d M, Y') . "\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>";
$html_body .= "\n\t\t\t\t\t<table class='data-table'>\n\t\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<th><b>Commodity Name</b></th>\n\t\t\t\t\t\t\t\t<th><b>Date of Issue</b></th>\n\t\t\t\t\t\t\t\t<th><b>Reference No/S11 No</b></th>\n\t\t\t\t\t\t\t\t<th ><b>Commodity Unit Size</b></th>\n\t\t\t\t\t\t\t\t<th ><b>Batch No -Issued</b></th>\n\t\t\t\t\t\t\t\t<th ><b>Expiry Date</b></th>\n\t\t\t\t\t\t\t\t<th ><b>Opening Bal.</b></th>\n\t\t\t\t\t\t\t\t<th ><b>+ADJ</b></th>\n\t\t\t\t\t\t\t\t<th ><b>-ADJ</b></th>\n\t\t\t\t\t\t\t\t<th ><b>Receipts/Issues</b></th>\n\t\t\t\t\t\t\t\t<th ><b>Closing Bal.</b></th>\n\t\t\t\t\t\t\t\t<th ><b>Service Point</b></th>\n\t\t\t\t\t\t\t\t<th ><b>Issuing/Receiving Officer</b></th>\n\t\t\t\t\t\t\t</tr> \n\t\t\t\t\t\t</thead>\n\t\t\t\t\t\t<tbody>";
$html_body .= '<ol type="a">';
for ($i = 0; $i < $bin_card_data_count; $i++) {
$closing_balance = $bin_card_data[$i]['balance_as_of'] - $bin_card_data[$i]['qty_issued'];
$mydrug_name = $commodity_name;
$html_body .= "<tr>";
$html_body .= "<td>" . $commodity_name[0]['commodity_name'] . "</td>";
$html_body .= "<td>" . $bin_card_data[$i]['date_issued'] . "</td>";
$html_body .= "<td>" . $bin_card_data[$i]['s11_No'] . "</td>";
$html_body .= "<td>" . $bin_card_data[$i]['unit_size'] . "</td>";
$html_body .= "<td>" . $bin_card_data[$i]['batch_no'] . "</td>";
$html_body .= "<td>" . $bin_card_data[$i]['expiry_date'] . "</td>";
$html_body .= "<td>" . $bin_card_data[$i]['balance_as_of'] . "</td>";
$html_body .= "<td>" . $bin_card_data[$i]['adjustmentpve'] . "</td>";
$html_body .= "<td>" . $bin_card_data[$i]['adjustmentnve'] . "</td>";
$html_body .= "<td>" . $bin_card_data[$i]['qty_issued'] . "</td>";
$html_body .= "<td>" . $closing_balance . "</td>";
$html_body .= "<td>" . $bin_card_data[$i]['service_point_name'] . "</td>";
$html_body .= "<td>" . $bin_card_data[$i]['fname'] . " " . $bin_card_data[$i]['fname'] . "</td>";
$html_body .= "</tr>";
}
$html_body .= '</tbody></table></ol>';
$pdf_body = $html_body;
//end of bin card pdf
$file_name = $facility_name . '_facility_program_report_date_created_' . date('d-m-y');
$pdf_data = array("pdf_title" => "Program Report For {$facility_name}", 'pdf_html_body' => $pdf_body, 'pdf_view_option' => 'download', 'file_name' => $file_name);
$this->hcmp_functions->create_pdf($pdf_data);
redirect();
}
