public function execute()
{
try {
$where = null;
if (request::getInstance()->hasPost('filter')) {
$filter = request::getInstance()->getPost('filter');
if (isset($filter['nombre']) and $filter['nombre'] !== null and $filter['nombre'] !== '') {
$where[vacunaTableClass::NOMBRE_VACUNA] = $filter['nombre'];
}
//close if
if (isset($filter['lote']) and $filter['lote'] !== null and $filter['lote'] !== '') {
$where[vacunaTableClass::LOTE_VACUNA] = $filter['lote'];
}
//close if
if (isset($filter['fecha_f']) and $filter['fecha_f'] !== null and $filter['fecha_f'] !== '') {
$where[vacunaTableClass::FECHA_FABRICACION] = $filter['fecha_f'];
}
//close if
if (isset($filter['fecha_v']) and $filter['fecha_v'] !== null and $filter['fecha_v'] !== '') {
$where[vacunaTableClass::FECHA_VENCIMIENTO] = $filter['fecha_v'];
}
//close if
if (isset($filter['valor']) and $filter['valor'] !== null and $filter['valor'] !== '') {
$where[vacunaTableClass::VALOR] = $filter['valor'];
}
//close if
if (isset($filter['cantidad']) and $filter['cantidad'] !== null and $filter['cantidad'] !== '') {
$where[vacunaTableClass::CANTIDAD] = $filter['cantidad'];
}
//close if
if (isset($filter['stock']) and $filter['stock'] !== null and $filter['stock'] !== '') {
$where[vacunaTableClass::STOCK_MINIMO] = $filter['stock'];
}
//close if
session::getInstance()->setAttribute('vacunaFilters', $where);
} elseif (session::getInstance()->hasAttribute('vacunaFilters')) {
$where = session::getInstance()->getAttribute('vacunaFilters');
}
//close if
$fields = array(vacunaTableClass::FECHA_VENCIMIENTO, vacunaTableClass::FECHA_FABRICACION, vacunaTableClass::ID, vacunaTableClass::LOTE_VACUNA, vacunaTableClass::NOMBRE_VACUNA, vacunaTableClass::VALOR, vacunaTableClass::CANTIDAD, vacunaTableClass::STOCK_MINIMO);
$orderBy = array(vacunaTableClass::ID);
$page = 0;
if (request::getInstance()->hasGet('page')) {
$page = request::getInstance()->getGet('page') - 1;
$page = $page * config::getRowGrid();
}
//close if
$f = array(vacunaTableClass::ID);
$lines = config::getRowGrid();
if (request::getInstance()->hasGet('page')) {
$this->page = request::getInstance()->getGet('page');
} else {
$this->page = $page;
}
//close if
$objVacuna = vacunaTableClass::getAll($fields, true, $orderBy, 'ASC', config::getRowGrid(), $page, $where);
foreach ($objVacuna as $key) {
if ($key->cantidad < $key->stock_minimo and $key->cantidad >= 1) {
session::getInstance()->setWarning("La vacuna " . $key->nombre_vacuna . " " . "esta a punto de agotarse " . "le quedan " . $key->cantidad . " " . "y " . "su cantidad minima es de " . $key->stock_minimo);
} elseif ($key->cantidad < $key->stock_minimo) {
session::getInstance()->setWarning("La vacuna " . $key->nombre_vacuna . " " . "se ha agotado");
}
}
$this->cntPages = vacunaTableClass::getAllCount($f, false, $lines);
$this->objVacuna = vacunaTableClass::getAll($fields, true, $orderBy, 'ASC', config::getRowGrid(), $page, $where);
log::register(i18n::__('ver', null, 'vacunacion'), vacunaTableClass::getNameTable());
$this->defineView('index', 'vacuna', session::getInstance()->getFormatOutput());
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
