public function undo_reverse_issue($facility_code, $raw_date, $issued_by, $type)
{
$current_time = date("Y-m-d H:i:s", time());
$created_at = date("Y-m-d H:i:s", $raw_date);
$issue_details = Facility_issues::get_undo_issue_details_for_reversals($facility_code, $created_at, $issued_by);
if ($type == 'view') {
foreach ($issue_details as $key => $value) {
$facility_code = $value['facility_code'];
$facility_name = $value['facility_name'];
$commodity_name = $value['commodity_name'];
$batch_no = $value['batch_no'];
$qty_issued = $value['qty_issued'];
$date_issued_raw = $value['date_issued'];
$issued_by = $value['issued_by'];
$date_issued = date('d F Y', strtotime($date_issued_raw));
$output[] = array($facility_name, $facility_code, $commodity_name, $batch_no, $qty_issued, $date_issued);
}
echo json_encode($output);
} else {
if ($type == 'reverse') {
foreach ($issue_details as $key => $value) {
$undo_reversed_data = array('facility_code' => $value['facility_code'], 's11_No' => $value['s11'], 'commodity_id' => $value['commodity_id'], 'batch_no' => $value['batch_no'], 'expiry_date' => $value['expiry_date'], 'balance_as_of' => $value['balance_as_of'], 'adjustmentpve' => $value['adjustmentpve'], 'adjustmentnve' => $value['adjustmentnve'], 'qty_issued' => $value['qty_issued'], 'date_issued' => $value['date_issued'], 'issued_to' => $value['issued_to'], 'created_at' => $value['created_at'], 'issued_by' => $value['issued_by'], 'status' => $value['status']);
$this->db->insert('facility_issues', $undo_reversed_data);
$facility_stocks_data = facility_stocks::get_current_stock_for_reversal($value['facility_code'], $value['commodity_id'], $value['batch_no']);
foreach ($facility_stocks_data as $keys => $values) {
$id = $values['id'];
$initial_quantity = $values['initial_quantity'];
$current_balance = intval($values['current_balance']);
$new_balance = $current_balance - intval($value['qty_issued']);
$update_data = array('current_balance' => $new_balance);
$this->db->where('id', $id);
$this->db->update('facility_stocks', $update_data);
}
$this->db->where('id', $value['id']);
$this->db->delete('reversals');
}
redirect('admin/reversals');
}
}
}
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();
}
public function get_reversed_table()
{
$graph_data = array();
$facility_code = $this->session->userdata('facility_id');
$start_date = date('Y-m-01', strtotime('-0 month'));
$current_reversals = Facility_issues::get_facility_issues_reversals($facility_code, $start_date);
foreach ($current_reversals as $key => $value) {
$commodity_id = $value['commodity_id'];
$commodity_name = $value['commodity_name'];
$batch_no = $value['batch_no'];
$qty_issued = intval($value['qty_issued']) * -1;
$issued_to = $value['issued_to'];
// $issue_date = $value['date_issued'];
$create_date_raw = $value['date_issued'];
$create_date = date('F, d Y', strtotime($create_date_raw));
// $issue_date = date('F, m Y', strtotime($issue_date));
$issuer = $value['fname'] . ' ' . $value['lname'];
$issuer_id = $value['issued_by'];
$create_date_timestamp = strtotime($create_date_raw);
// $data_id = $facility_code.'/'.$create_date_timestamp.'/'.$issuer_id;
// $button_dets_link = '<button class="btn btn-success status_btn form-control" style="width:98%" data-id="'.$data_id.'" id="'.$data_id.'" data-attr="'.$data_id.'" data-value="'.$data_id.'">View Details</button>';
// $button_reverse_link = "<a href=\"".base_url().'issues/reverse_issue/'.$commodity_id.'/'.$create_date_timestamp.'/'.$issuer_id.'/reverse'."\"><button class=\"btn btn-danger form-control\" style=\"width:98%\">Reverse Issue</button></a>";
$output[] = array($commodity_name, $batch_no, $qty_issued, $issued_to, $create_date, $issuer);
}
echo json_encode($output);
// $category_data = array( array("Commodity Name", "Batch Number","Quantity Reversed (Units)", "Date of Reversal", "Issued To", "Person Reversing"));
// $graph_data = array_merge($graph_data, array("table_id" => 'reversed_issues_tbl '));
// $graph_data = array_merge($graph_data, array("table_header" => $category_data));
// $graph_data = array_merge($graph_data, array("table_body" => $output));
// $data = array();
// $data['table'] = $this -> hcmp_functions -> create_data_table($graph_data);
// return $this -> load -> view("shared_files/report_templates/data_table_template_v", $data);
}
