public function potentialExpiries()
{
//New
$facility_c = $this->session->userdata('news');
$data['title'] = "Stock";
$data['content_view'] = "potentialExp";
$data['banner_text'] = "Potential Expiries";
$data['link'] = "order_management";
$data['stocks'] = Facility_Stock::expiries($facility_c);
//$data['tester']=Drug::getSome();
$data['quick_link'] = "stock_view";
$this->load->view("template", $data);
}
public function county_potential_expiries($facility_code = NULL)
{
if (!isset($facility_code)) {
$facility_c = $this->session->userdata('news');
} else {
$facility_c = $facility_code;
}
$data['title'] = "Potential Expiries";
$data['content_view'] = "county/county_potential_expiries_v";
$data['banner_text'] = "Expired Products";
$data['report'] = Facility_Stock::expiries($facility_c);
$data['mycount'] = count(Facility_Stock::expiries($facility_c));
$data['expired'] = Districts::get_district_expiries($date, $district);
$data['potential_expiries'] = Counties::get_potential_expiry_summary($county);
$data['table_body2'] = "";
if (count($data['expired'])) {
foreach ($data['expired'] as $item) {
$data['table_body2'] .= "<tr>\n\t\t\t<td>" . $item['facility_code'] . "</td>\n\t\t\t<td>" . $item['facility_name'] . "</td>\n\t\t\t<td>" . $item['balance'] . "</td>\n\t\t\t<td><a href=" . site_url('stock_expiry_management/expired/' . $item['facility_code']) . " class='link'>View</a></td>\n\t\t\t</tr>";
}
} else {
$data['table_body2'] = "<div id='notification'>No records found</div>";
}
$this->load->view("template", $data);
}
public function gen_pdf()
{
$timeinterval = $_POST['timer'];
$facility_c = $this->session->userdata('news');
$report = Facility_Stock::expiries($facility_c, $timeinterval);
$report_name = 'Potential Expiries ' . $facility_c . ' Next ' . $timeinterval . 'Months';
$title = 'test';
/**************************************set the style for the table****************************************/
$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 = '';
/*****************************setting up the report*******************************************/
$html_data1 .= '<table class="data-table"><thead>
<tr >
<th><strong>Kemsa Code</strong></th>
<th><strong>Description</strong></th>
<th><strong>Unit size</strong></th>
<th><strong>Unit Cost</strong></th>
<th><strong>Batch No</strong></th>
<th><strong>Expiry Date</strong></th>
<th><strong><b>Units</b></strong></th>
<th><strong><b>Stock Worth(Ksh)</b></strong></th>
</tr><tbody>';
/*******************************begin adding data to the report*****************************************/
foreach ($report 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>' . $unitS . '</td>
<td>' . $unitC . '</td>
<td>' . $drug->batch_no . '</td>
<td>' . $myvalue . '</td>
<td>' . $drug->balance . '</td>
<td >' . $calc * $unitC . '</td>
</tr>';
/***********************************************************************************************/
}
}
$html_data1 .= '</tbody></table>';
$html_data .= $html_data1;
$date = new DateTime();
$interval = new DateInterval('P' . $timeinterval . 'M');
$date->add($interval);
$formateddate = $date->format('M-d-Y') . "\n";
$this->generatePE_pdf($report_name, $title, $html_data, $facility_c, $timeinterval, $formateddate);
}
