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); }