public function index()
{
$date = date('Y-m-d');
$facility = $this->session->userdata('news');
//echo $date;
$data['title'] = "Expired Products";
$data['content_view'] = "expire_v";
$data['banner_text'] = "Expired Products";
$data['exp'] = Facility_Stock::getexp($date, $facility);
$data['link'] = "expire_v";
$data['quick_link'] = "expire_v";
$this->load->view("template", $data);
}
public function get_decommission_report_pdf()
{
$facilityCode = $this->session->userdata('news');
$date = date('Y-m-d');
$date2 = date('d-M-Y');
$facility = $this->session->userdata('news');
$current_year = date('Y');
$current_month = date('F');
$current_monthdigit = date('m');
$id = $this->session->userdata('identity');
$report_name = 'Decommission Report for ' . $date2;
$title = 'Expired Commodities as of ' . $date2;
$expired = Facility_Stock::getexp($date, $facility);
$html_data = '<style>table.data-table {border: 1px solid #DDD;margin: 10px auto;border-spacing: 0px;}
table.data-table th {border: none;color: #036;text-align: center;background-color: #F5F5F5;border: 1px solid #DDD;border-top: none;max-width: 450px;}
table.data-table td, table th {padding: 4px;}
table.data-table td {border: none;border-left: 1px solid #DDD;border-right: 1px solid #DDD;height: 30px;margin: 0px;border-bottom: 1px solid #DDD;}
.col5{background:#C9C299;}</style>';
$html_data1 = '';
$html_data1 .= '<table class="data-table"><thead>
<tr>
<th>KEMSA Code</th>
<th>Description</th>
<th>Batch No Affected</th>
<th>Manufacturer</th>
<th>Expiry Date</th>
<th>Unit size</th>
<th>Stock Expired(Unit Size)</th>
</tr></thead><tbody>';
foreach ($expired as $drug) {
foreach ($drug->Code as $d) {
$name = $d->Drug_Name;
$code = $d->Kemsa_Code;
$unitS = $d->Unit_Size;
$unitC = $d->Unit_Cost;
$calc = $drug->balance;
$thedate = $drug->expiry_date;
$formatme = new DateTime($thedate);
$myvalue = $formatme->format('d M Y');
$html_data1 .= ' <tr>
<td>' . $code . '</td>
<td>' . $name . '</td>
<td>' . $drug->batch_no . '</td>
<td>' . $drug->manufacture . '</td>
<td>' . $myvalue . '</td>
<td>' . $unitS . '</td>
<td>' . $drug->quantity . '</td>
</tr>';
}
}
$html_data1 .= '</tbody></table>';
$html_data .= $html_data1;
$this->generate_decommission_report_pdf($report_name, $title, $html_data);
}
