public function execute()
{
try {
if (request::getInstance()->isMethod('POST')) {
$id_registro = request::getInstance()->getPost(detalleVacunacionTableClass::getNameField(detalleVacunacionTableClass::ID_REGISTRO, true));
$id_vacuna = request::getInstance()->getPost(detalleVacunacionTableClass::getNameField(detalleVacunacionTableClass::VACUNA, true));
$fecha_vacunacion = request::getInstance()->getPost(detalleVacunacionTableClass::getNameField(detalleVacunacionTableClass::FECHA, true));
$dosis_vacuna = request::getInstance()->getPost(detalleVacunacionTableClass::getNameField(detalleVacunacionTableClass::DOSIS, true));
$accion = request::getInstance()->getPost(detalleVacunacionTableClass::getNameField(detalleVacunacionTableClass::ACCION, true));
detalleVacunacionTableClass::validate($fecha_vacunacion, $dosis_vacuna, $accion, $id_vacuna);
$data = array(detalleVacunacionTableClass::ID_REGISTRO => $id_registro, detalleVacunacionTableClass::VACUNA => $id_vacuna, detalleVacunacionTableClass::FECHA => $fecha_vacunacion, detalleVacunacionTableClass::DOSIS => $dosis_vacuna, detalleVacunacionTableClass::ACCION => $accion);
// print_r($data);
//Manejo de inventario
$fieldsVacuna = array(vacunaTableClass::CANTIDAD);
$whereVacuna = array(vacunaTableClass::ID => $id_vacuna);
$objVacuna = vacunaTableClass::getAll($fieldsVacuna, true, null, null, null, null, $whereVacuna);
detalleVacunacionTableClass::validateInventario($objVacuna[0]->cantidad, 1);
$vacunaInventario = $objVacuna[0]->cantidad - 1;
$idsVacuna = array(vacunaTableClass::ID => $id_vacuna);
$dataVacuna = array(vacunaTableClass::CANTIDAD => $vacunaInventario);
vacunaTableClass::update($idsVacuna, $dataVacuna);
detalleVacunacionTableClass::insert($data);
session::getInstance()->setSuccess(i18n::__('succesCreate', null, 'detalleVacunacion'));
log::register(i18n::__('create'), detalleVacunacionTableClass::getNameTable());
routing::getInstance()->redirect('vacunacion', 'indexVacunacion');
} else {
session::getInstance()->setError('El Detalle de Vacunación no pudo ser insertado');
routing::getInstance()->redirect('vacunacion', 'indexVacunacion');
}
//close if
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
if (request::getInstance()->isMethod('POST')) {
$nombre = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::NOMBRE_VACUNA, true));
$lote = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::LOTE_VACUNA, true));
$fecha_fabricacion = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::FECHA_FABRICACION, true));
$fecha_vencimiento = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::FECHA_VENCIMIENTO, true));
$valor = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::VALOR, true));
$cantidad = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::CANTIDAD, true));
$stock = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::STOCK_MINIMO, true));
vacunaTableClass::validateCreate($nombre, $lote, $fecha_fabricacion, $fecha_vencimiento, $valor, $cantidad, $stock);
$data = array(vacunaTableClass::NOMBRE_VACUNA => $nombre, vacunaTableClass::FECHA_FABRICACION => $fecha_fabricacion, vacunaTableClass::FECHA_VENCIMIENTO => $fecha_vencimiento, vacunaTableClass::LOTE_VACUNA => $lote, vacunaTableClass::VALOR => $valor, vacunaTableClass::CANTIDAD => $cantidad, vacunaTableClass::STOCK_MINIMO => $stock);
vacunaTableClass::insert($data);
session::getInstance()->setSuccess(i18n::__('succesCreate', null, 'vacuna'));
log::register(i18n::__('create'), vacunaTableClass::getNameTable());
routing::getInstance()->redirect('vacunacion', 'indexVacuna');
} else {
log::register(i18n::__('create'), vacunaTableClass::getNameTable(), i18n::__('errorCreateBitacora'));
session::getInstance()->setError(i18n::__('errorCreate'));
routing::getInstance()->redirect('vacunacion', 'indexVacuna');
}
//close if
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
$fieldsVacuna = array(vacunaTableClass::ID, vacunaTableClass::NOMBRE_VACUNA);
$fieldsVacunacion = array(vacunacionTableClass::ID);
$this->objVacuna = vacunaTableClass::getAll($fieldsVacuna, true);
$this->objVacunacion = vacunacionTableClass::getAll($fieldsVacunacion, true);
$this->defineView('insert', 'detalleVacunacion', session::getInstance()->getFormatOutput());
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
if (session::getInstance()->hasAttribute('vacunaFilters')) {
session::getInstance()->deleteAttribute('vacunaFilters');
}
//close if
routing::getInstance()->redirect('vacunacion', 'indexVacuna');
log::register(i18n::__('eliminar filtros'), vacunaTableClass::getNameTable());
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
$fieldsAnimal = array(animalTableClass::ID, animalTableClass::NUMERO);
$fieldsVeterinario = array(veterinarioTableClass::ID, veterinarioTableClass::NOMBRE);
$fieldsVacuna = array(vacunaTableClass::ID, vacunaTableClass::NOMBRE_VACUNA);
$this->objAnimal = animalTableClass::getAll($fieldsAnimal, true);
$this->objVeterinario = veterinarioTableClass::getAll($fieldsVeterinario, true);
$this->objVacuna = vacunaTableClass::getAll($fieldsVacuna, true);
$this->idAnimalHojaVida = request::getInstance()->getGet(hojaVidaTableClass::getNameField(hojaVidaTableClass::ANIMAL, true));
$this->defineView('insertVacunacion', 'animal', session::getInstance()->getFormatOutput());
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
$fieldsVacunacion = array(carneVacunasTableClass::ACCION, carneVacunasTableClass::ANIMAL, carneVacunasTableClass::DOSIS, carneVacunasTableClass::FECHA_VACUNACION, carneVacunasTableClass::ID, carneVacunasTableClass::VACUNA, carneVacunasTableClass::VETERINARIO);
$fieldsAnimal = array(animalTableClass::ID, animalTableClass::NUMERO);
$fieldsVacuna = array(vacunaTableClass::ID, vacunaTableClass::NOMBRE_VACUNA);
$fieldsVeterinario = array(veterinarioTableClass::ID, veterinarioTableClass::NOMBRE);
$where = array(carneVacunasTableClass::ID => request::getInstance()->getRequest(carneVacunasTableClass::ID, true));
$this->objAnimal = animalTableClass::getAll($fieldsAnimal, true);
$this->objVacuna = vacunaTableClass::getAll($fieldsVacuna, true);
$this->objVeterinario = veterinarioTableClass::getAll($fieldsVeterinario, true);
$this->objCarne = carneVacunasTableClass::getAll($fieldsVacunacion, true, null, null, null, null, $where);
$this->defineView('editVacunacion', 'animal', session::getInstance()->getFormatOutput());
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
$where = null;
if (request::getInstance()->hasRequest('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
}
$fields = array(vacunaTableClass::ID, vacunaTableClass::NOMBRE_VACUNA, vacunaTableClass::LOTE_VACUNA, vacunaTableClass::FECHA_FABRICACION, vacunaTableClass::FECHA_VENCIMIENTO, vacunaTableClass::VALOR, vacunaTableClass::CANTIDAD, vacunaTableClass::STOCK_MINIMO);
$orderBy = array(vacunaTableClass::ID);
$this->objVacuna = vacunaTableClass::getAll($fields, true, $orderBy, 'ASC', null, null, $where);
$this->mensaje = 'Informe de Vacunas en Nuestro Sistema';
log::register(i18n::__('reporte'), vacunaTableClass::getNameTable());
$this->defineView('index', 'vacuna', session::getInstance()->getFormatOutput());
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
if (request::getInstance()->isMethod('POST')) {
$nombre = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::NOMBRE_VACUNA, true));
$lote = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::LOTE_VACUNA, true));
$fecha_fabricacion = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::FECHA_FABRICACION, true));
$fecha_vencimiento = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::FECHA_VENCIMIENTO, true));
$valor = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::VALOR, true));
$id = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::ID, true));
vacunaTableClass::validateEdit($nombre, $lote, $fecha_fabricacion, $fecha_vencimiento, $valor);
// $id = request::getInstance()->getPost(razaTableClass::getNameField(razaTableClass::ID, true));
// $nombre = request::getInstance()->getPost(razaTableClass::getNameField(razaTableClass::NOMBRE_RAZA, true));
//
// $ids = array(
// razaTableClass::ID => $id
// );
$ids = array(vacunaTableClass::ID => $id);
$data = array(vacunaTableClass::NOMBRE_VACUNA => $nombre, vacunaTableClass::LOTE_VACUNA => $lote, vacunaTableClass::FECHA_FABRICACION => $fecha_fabricacion, vacunaTableClass::FECHA_VENCIMIENTO => $fecha_vencimiento, vacunaTableClass::VALOR => $valor);
vacunaTableClass::update($ids, $data);
session::getInstance()->setSuccess(i18n::__('succesUpdate', null, 'vacuna'));
log::register(i18n::__('update'), vacunaTableClass::getNameTable());
routing::getInstance()->redirect('vacunacion', 'indexVacuna');
// $data = array(
// razaTableClass::NOMBRE_RAZA => $nombre
// );
//
// razaTableClass::update($ids, $data);
// session::getInstance()->setSuccess(i18n::__('succesUpdate'));
// log::register(i18n::__('update'), razaTableClass::getNameTable());
} else {
log::register(i18n::__('update'), vacunaTableClass::getNameTable(), i18n::__('errorUpdateBitacora'));
session::getInstance()->setError(i18n::__('errorUpdate'));
routing::getInstance()->redirect('vacunacion', 'indexVacuna');
}
//close if
// log::register(i18n::__('update'), razaTableClass::getNameTable(), i18n::__('errorUpdateBitacora'));
// session::getInstance()->setError(i18n::__('errorUpdate'));
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
if (request::getInstance()->hasGet(vacunaTableClass::ID)) {
$fields = array(vacunaTableClass::ID, vacunaTableClass::FECHA_FABRICACION, vacunaTableClass::FECHA_VENCIMIENTO, vacunaTableClass::LOTE_VACUNA, vacunaTableClass::NOMBRE_VACUNA, vacunaTableClass::VALOR, vacunaTableClass::CANTIDAD, vacunaTableClass::STOCK_MINIMO);
$where = array(vacunaTableClass::ID => request::getInstance()->getGet(vacunaTableClass::ID));
$this->objVacuna = vacunaTableClass::getAll($fields, false, null, null, null, null, $where);
$this->defineView('edit', 'vacuna', session::getInstance()->getFormatOutput());
} else {
$fields = array(vacunaTableClass::ID, vacunaTableClass::FECHA_FABRICACION, vacunaTableClass::FECHA_VENCIMIENTO, vacunaTableClass::LOTE_VACUNA, vacunaTableClass::NOMBRE_VACUNA, vacunaTableClass::VALOR, vacunaTableClass::CANTIDAD, vacunaTableClass::STOCK_MINIMO);
$where = array(vacunaTableClass::ID => request::getInstance()->getGet($id));
$this->objVacuna = vacunaTableClass::getAll($fields, false, null, null, null, null, $where);
$this->defineView('edit', 'vacuna', session::getInstance()->getFormatOutput());
// routing::getInstance()->redirect('vacunacion', 'editVacuna');
}
//close if
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
if (request::getInstance()->hasRequest(detalleVacunacionTableClass::ID)) {
$fields = array(detalleVacunacionTableClass::ID, detalleVacunacionTableClass::ID_REGISTRO, detalleVacunacionTableClass::VACUNA, detalleVacunacionTableClass::FECHA, detalleVacunacionTableClass::DOSIS);
$where = array(detalleVacunacionTableClass::ID => request::getInstance()->getRequest(detalleVacunacionTableClass::ID));
$fieldsVacuna = array(vacunaTableClass::ID, vacunaTableClass::NOMBRE_VACUNA);
$fieldsVacunacion = array(vacunacionTableClass::ID);
$this->objVacuna = vacunaTableClass::getAll($fieldsVacuna, true);
$this->objVacunacion = vacunacionTableClass::getAll($fieldsVacuna, true);
$this->objDetalleVacunacion = detalleVacunacionTableClass::getAll($fields, true, null, null, null, null, $where);
$this->defineView('edit', 'detalleVacunacion', session::getInstance()->getFormatOutput());
} else {
routing::getInstance()->redirect('vacunacion', 'indexDetalleVacunacion');
}
//close if
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
if (request::getInstance()->isMethod('POST') and request::getInstance()->isAjaxRequest()) {
$id = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::ID, true));
$ids = array(vacunaTableClass::ID => $id);
vacunaTableClass::delete($ids, true);
$this->arrayAjax = array('code' => 11, 'msg' => 'La eliminacion ha sido exitosa');
$this->defineView('delete', 'vacuna', session::getInstance()->getFormatOutput());
log::register(i18n::__('delete'), vacunaTableClass::getNameTable());
session::getInstance()->setSuccess(i18n::__('succesDelete', null, 'vacuna'));
} else {
log::register(i18n::__('delete'), vacunaTableClass::getNameTable(), i18n::__('errorDeleteBitacora'));
session::getInstance()->setError(i18n::__('errorDelete'));
routing::getInstance()->redirect('animal', 'indexRaza');
}
//close if
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
if (request::getInstance()->isMethod('POST')) {
$idsToDelete = request::getInstance()->getPost('chk');
foreach ($idsToDelete as $id) {
$ids = array(vacunaTableClass::ID => $id);
vacunaTableClass::delete($ids, true);
}
//close foreach
session::getInstance()->setSuccess(i18n::__('SuccesDeleteMasive', null, 'vacuna'));
log::register(i18n::__('borrar seleccion'), vacunaTableClass::getNameTable());
routing::getInstance()->redirect('vacunacion', 'indexVacuna');
} else {
session::getInstance()->setError('mal');
routing::getInstance()->redirect('vacunacion', 'indexVacuna');
}
//close if
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
if (request::getInstance()->isMethod('POST')) {
$id = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::ID, true));
$cantidad = request::getInstance()->getPost(vacunaTableClass::getNameField(vacunaTableClass::CANTIDAD, true));
// vacunaTableClass::validateUpdateInsert($cantidad);
$fieldsVacuna = array(vacunaTableClass::CANTIDAD);
$where = array(vacunaTableClass::ID => $id);
$vacuna = vacunaTableClass::getAll($fieldsVacuna, true, null, null, null, null, $where);
$vacunaTotal = $cantidad + $vacuna[0]->cantidad;
$ids = array(vacunaTableClass::ID => $id);
$data = array(vacunaTableClass::CANTIDAD => $vacunaTotal);
vacunaTableClass::update($ids, $data);
session::getInstance()->setSuccess(i18n::__('successUpdate', null, 'vacuna'));
log::register(i18n::__('update'), vacunaTableClass::getNameTable());
routing::getInstance()->redirect('vacunacion', 'indexVacuna');
// $data = array(
// razaTableClass::NOMBRE_RAZA => $nombre
// );
//
// razaTableClass::update($ids, $data);
// session::getInstance()->setSuccess(i18n::__('succesUpdate'));
// log::register(i18n::__('update'), razaTableClass::getNameTable());
} else {
log::register(i18n::__('update'), vacunaTableClass::getNameTable(), i18n::__('errorUpdateBitacora'));
session::getInstance()->setError(i18n::__('errorCreate'));
routing::getInstance()->redirect('vacunacion', 'indexVacuna');
}
//close if
// log::register(i18n::__('update'), razaTableClass::getNameTable(), i18n::__('errorUpdateBitacora'));
// session::getInstance()->setError(i18n::__('errorUpdate'));
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public function execute()
{
try {
if (request::getInstance()->isMethod('POST')) {
// DATOS DE ANIMAL
$veterinario = request::getInstance()->getPost(carneVacunasTableClass::getNameField(carneVacunasTableClass::VETERINARIO, true));
$animal = request::getInstance()->getPost(carneVacunasTableClass::getNameField(carneVacunasTableClass::ANIMAL, true));
$fecha_vacunacion = request::getInstance()->getPost(carneVacunasTableClass::getNameField(carneVacunasTableClass::FECHA_VACUNACION, true));
$id_vacuna = request::getInstance()->getPost(carneVacunasTableClass::getNameField(carneVacunasTableClass::VACUNA, true));
$dosis = request::getInstance()->getPost(carneVacunasTableClass::getNameField(carneVacunasTableClass::DOSIS, true));
$accion = request::getInstance()->getPost(carneVacunasTableClass::getNameField(carneVacunasTableClass::ACCION, true));
carneVacunasTableClass::validateCrear($veterinario, $fecha_vacunacion, $animal, $id_vacuna, $dosis, $accion);
$data = array(carneVacunasTableClass::ACCION => $accion, carneVacunasTableClass::ANIMAL => $animal, carneVacunasTableClass::DOSIS => $dosis, carneVacunasTableClass::FECHA_VACUNACION => $fecha_vacunacion, carneVacunasTableClass::VACUNA => $id_vacuna, carneVacunasTableClass::VETERINARIO => $veterinario);
$datos = array($veterinario, $animal, $fecha_vacunacion, $id_vacuna, $dosis, $accion);
//Manejo de inventario
$fieldsVacuna = array(vacunaTableClass::CANTIDAD);
$whereVacuna = array(vacunaTableClass::ID => $id_vacuna);
$objVacuna = vacunaTableClass::getAll($fieldsVacuna, true, null, null, null, null, $whereVacuna);
carneVacunasTableClass::validateInventario($objVacuna[0]->cantidad, 1);
$vacunaInventario = $objVacuna[0]->cantidad - 1;
$idsVacuna = array(vacunaTableClass::ID => $id_vacuna);
$dataVacuna = array(vacunaTableClass::CANTIDAD => $vacunaInventario);
vacunaTableClass::update($idsVacuna, $dataVacuna);
carneVacunasTableClass::insert($data);
session::getInstance()->setSuccess(i18n::__('succesCreate2', null, 'dpVenta'));
log::register(i18n::__('create'), carneVacunasTableClass::getNameTable());
routing::getInstance()->redirect('animal', 'indexVacunacion');
} else {
log::register(i18n::__('create'), carneVacunasTableClass::getNameTable(), i18n::__('errorCreateBitacora'));
session::getInstance()->setError(i18n::__('errorCreate2', null, 'animal'));
routing::getInstance()->redirect('animal', 'indexVacunacion');
}
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
?>
" ><font size="2">* <?php
echo i18n::__('oblig1', null, 'vacuna');
?>
</font></th>
</tr>
<tr>
<th> <?php
echo i18n::__('stock');
?>
:</th>
<th> <input placeholder="<?php
echo isset($objVacuna) == FALSE ? i18n::__('stock') : ($objVacuna[0]->{$stock} = ucwords($objVacuna[0]->{$stock}));
?>
" type="number" name="<?php
echo vacunaTableClass::getNameField(vacunaTableClass::STOCK_MINIMO, true);
?>
" ><font size="2">* <?php
echo i18n::__('oblig2', null, 'vacuna');
?>
</font></th>
</tr>
<?php
}
?>
<tr>
<th colspan="2">
<div class="text-center">
<input type="submit" class="btn" value="<?php
echo i18n::__(isset($objVacuna) == TRUE ? 'edit' : 'register');
?>
public function execute()
{
try {
$where = null;
$idHojaVida = request::getInstance()->getGet(hojaVidaBaseTableClass::getNameField(hojaVidaTableClass::ANIMAL, TRUE));
if (request::getInstance()->hasPost('filter')) {
$filter = request::getInstance()->getPost('filter');
if (isset($filter['fecha_inicio']) and $filter['fecha_inicio'] !== null and $filter['fecha_inicio'] !== '' and isset($filter['fecha_fin']) and $filter['fecha_fin'] !== null and $filter['fecha_fin'] !== '') {
$where[carneVacunasTableClass::getNameTable() . '.' . carneVacunasTableClass::FECHA_VACUNACION] = array(date(config::getFormatTimestamp(), strtotime($filter['fecha_inicio'] . ' 00.00.00')), date(config::getFormatTimestamp(), strtotime($filter['fecha_fin'] . ' 23.59.59')));
}
//close if
if (isset($filter['veterinario']) and $filter['veterinario'] !== null and $filter['veterinario'] !== '') {
$where[carneVacunasTableClass::getNameTable() . '.' . carneVacunasTableClass::VETERINARIO] = $filter['veterinario'];
}
//close if
if (isset($filter['vacuna']) and $filter['vacuna'] !== null and $filter['vacuna'] !== '') {
$where[carneVacunasTableClass::getNameTable() . '.' . carneVacunasTableClass::VACUNA] = $filter['vacuna'];
}
//close if
if (isset($filter['dosis']) and $filter['dosis'] !== null and $filter['dosis'] !== '') {
$where[carneVacunasTableClass::DOSIS] = $filter['dosis'];
}
//close if
if (isset($filter['accion']) and $filter['accion'] !== null and $filter['accion'] !== '') {
$where[carneVacunasTableClass::getNameTable() . '.' . carneVacunasTableClass::ACCION] = $filter['accion'];
}
//close if
session::getInstance()->setAttribute('animalFiltersVacunacion', $where);
} elseif (session::getInstance()->hasAttribute('animalFiltersVacunacion')) {
$where = session::getInstance()->getAttribute('animalFiltersVacunacion');
}
$fieldsVeterinario = array(veterinarioTableClass::ID, veterinarioTableClass::NOMBRE);
$fieldsAnimal = array(animalTableClass::ID, animalTableClass::NUMERO);
$fieldsVacuna = array(vacunaTableClass::ID, vacunaTableClass::NOMBRE_VACUNA);
$fields = array(carneVacunasTableClass::ACCION, carneVacunasTableClass::DOSIS, carneVacunasTableClass::FECHA_VACUNACION, carneVacunasTableClass::ID);
$fields2 = array(animalTableClass::NUMERO);
$fields3 = array(veterinarioTableClass::NOMBRE);
$fields4 = array(vacunaTableClass::NOMBRE_VACUNA);
$fJoin1 = carneVacunasTableClass::ANIMAL;
$fJoin2 = animalTableClass::ID;
$fJoin3 = carneVacunasTableClass::VETERINARIO;
$fJoin4 = veterinarioTableClass::ID;
$fJoin5 = carneVacunasTableClass::VACUNA;
$fJoin6 = vacunaTableClass::ID;
$orderBy = array(carneVacunasTableClass::FECHA_VACUNACION);
$page = 0;
if (request::getInstance()->hasGet('page')) {
$page = request::getInstance()->getGet('page') - 1;
$page = $page * config::getRowGrid();
}
$f = array(carneVacunasTableClass::ID);
$lines = config::getRowGrid();
$this->cntPages = carneVacunasTableClass::getAllCount($f, true, $lines);
if (request::getInstance()->hasGet('page')) {
$this->page = request::getInstance()->getGet('page');
} else {
$this->page = $page;
}
$this->idHojaVida = $idHojaVida;
$this->objCarne = carneVacunasTableClass::getAllJoin($fields, $fields2, $fields3, $fields4, $fJoin1, $fJoin2, $fJoin3, $fJoin4, $fJoin5, $fJoin6, true, $orderBy, 'ASC', config::getRowGrid(), $page, $where);
$this->objAnimal = animalTableClass::getAll($fieldsAnimal, true);
//$this->page = request::getInstance()->getGet('page');
$this->objVeterinario = veterinarioTableClass::getAll($fieldsVeterinario, true);
$this->objVacuna = vacunaTableClass::getAll($fieldsVacuna, true);
$this->idAnimalHojaVida = request::getInstance()->getGet(hojaVidaTableClass::getNameField(hojaVidaTableClass::ANIMAL, true));
$this->defineView('indexVacunacion', 'animal', session::getInstance()->getFormatOutput());
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
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');
}
}
public function execute()
{
try {
if (request::getInstance()->hasRequest(vacunacionTableClass::ID)) {
$idVacunacion = request::getInstance()->getRequest(vacunacionTableClass::ID);
$fieldsVacuna = array(vacunaTableClass::ID, vacunaTableClass::NOMBRE_VACUNA);
$orderBy = array(detalleVacunacionTableClass::ID);
$where = array(detalleVacunacionTableClass::ID_REGISTRO => $idVacunacion);
if (request::getInstance()->hasPost('filter')) {
$where = null;
$filter = request::getInstance()->getPost('filter');
if (isset($filter['fecha_inicial']) and $filter['fecha_inicial'] !== null and $filter['fecha_inicial'] !== '' and isset($filter['fecha_final']) and $filter['fecha_final'] !== null and $filter['fecha_final'] !== '') {
$where[detalleVacunacionTableClass::FECHA] = array(date(config::getFormatTimestamp(), strtotime($filter['fecha_inicial'] . ' 00.00.00')), date(config::getFormatTimestamp(), strtotime($filter['fecha_final'] . ' 23.59.59')));
}
//close if
if (isset($filter['vacuna']) and $filter['vacuna'] !== null and $filter['vacuna'] !== '') {
$where[detalleVacunacionTableClass::VACUNA] = $filter['vacuna'];
}
//close if
if (isset($filter['dosis']) and $filter['dosis'] !== null and $filter['dosis'] !== '') {
$where[detalleVacunacionTableClass::DOSIS] = $filter['dosis'];
}
//close if
// if (isset($filter['accion']) and $filter['accion'] !== null and $filter['accion'] !== '') {
// $where[detalleVacunacionTableClass::ACCION] = $filter['accion'];
// }
session::getInstance()->setAttribute('facturaVentaFilter', $where);
} elseif (session::getInstance()->hasAttribute('facturaVentaFilter')) {
$where = session::getInstance()->getAttribute('facturaVentaFilter');
}
//close if
$fieldsVacunacion = array(vacunacionTableClass::ID, vacunacionTableClass::FECHA);
$fieldsVete = array(veterinarioTableClass::NOMBRE);
$fieldsAni = array(animalTableClass::NUMERO);
$whereVacunacion = array(vacunacionTableClass::getNameTable() . '.' . vacunacionTableClass::ID => $idVacunacion);
$fieldsAnimal = array(animalTableClass::ID, animalTableClass::NUMERO);
$page = 0;
if (request::getInstance()->hasGet('page')) {
$page = request::getInstance()->getGet('page') - 1;
$page = $page * config::getRowGrid();
}
//close if
$f = array(detalleVacunacionTableClass::ID);
$whereCnt = array(detalleVacunacionTableClass::ID_REGISTRO => $idVacunacion);
$lines = config::getRowGrid();
$fieldsDetalleVacunacion = array(detalleVacunacionTableClass::ID, detalleVacunacionTableClass::ID_REGISTRO, detalleVacunacionTableClass::FECHA, detalleVacunacionTableClass::VACUNA, detalleVacunacionTableClass::DOSIS, detalleVacunacionTableClass::ACCION);
$fieldsVacu = array(vacunaTableClass::NOMBRE_VACUNA);
$fJoin1 = detalleVacunacionTableClass::VACUNA;
$fJoin2 = vacunaTableClass::ID;
$fJoinVacu1 = vacunacionTableClass::VETERINARIO;
$fJoinVacu2 = veterinarioTableClass::ID;
$fJoinVacu3 = vacunacionTableClass::ANIMAL;
$fJoinVacu4 = animalTableClass::ID;
$this->objAnimal = animalTableClass::getAll($fieldsAnimal, true);
$this->objVacuna = vacunaTableClass::getAll($fieldsVacuna, true);
$this->cntPages = detalleVacunacionTableClass::getAllCount($f, true, $lines, $whereCnt);
$this->objVacunacion = vacunacionTableClass::getAllJoin($fieldsVacunacion, $fieldsVete, $fieldsAni, null, $fJoinVacu1, $fJoinVacu2, $fJoinVacu3, $fJoinVacu4, null, null, true, $orderBy, 'ASC', config::getRowGrid(), $page, $whereVacunacion);
$this->objDetalleVacunacion = detalleVacunacionTableClass::getAllJoin($fieldsDetalleVacunacion, $fieldsVacu, null, null, $fJoin1, $fJoin2, null, null, null, null, true, $orderBy, 'ASC', config::getRowGrid(), $page, $where);
// $this->objDetalleVacunacion = detalleVacunacionTableClass::getAll($fields, true, $orderBy, 'ASC', 10, $page, $where);
$this->defineView('view', 'vacunacion', session::getInstance()->getFormatOutput());
} else {
session::getInstance()->setError('pailas');
routing::getInstance()->redirect('vacunacion', 'indexVacunacion');
}
//close if
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public static function validateUpdateInsert($cantidad)
{
$flag = false;
$patternC = "^[a-zA-Z0-9]{3,20}\$";
if (ereg($patternC, $cantidad) == false) {
session::getInstance()->setError(i18n::__(10124, null, 'errors', array('%campo%' => $cantidad)));
$flag = true;
session::getInstance()->setFlash(vacunaTableClass::getNameField(vacunaTableClass::CANTIDAD, true), true);
}
if (empty($cantidad) or !isset($cantidad) or $cantidad == '') {
session::getInstance()->setError(i18n::__(10122, null, 'errors'));
$flag = true;
session::getInstance()->setFlash(vacunaTableClass::getNameField(vacunaTableClass::CANTIDAD, true), true);
}
if (!is_numeric($cantidad)) {
session::getInstance()->setError(i18n::__(10123, null, 'errors', array('%campo%' => $cantidad)));
$flag = true;
session::getInstance()->setFlash(vacunaTableClass::getNameField(vacunaTableClass::CANTIDAD, true), true);
}
// if ($cantidad < 0) {
// session::getInstance()->setError(i18n::__(10125, null, 'errors', array('%campo%' => $cantidad)));
// $flag = true;
// session::getInstance()->setFlash(vacunaTableClass::getNameField(vacunaTableClass::CANTIDAD, true), true);
// }
if ($flag == true) {
request::getInstance()->setMethod('GET');
// request::getInstance()->addParamGet(array('id' => $id));
routing::getInstance()->forward('vacunacion', 'indexVacuna');
}
}
">
<a href="#close" title="Close" class="close">X</a>
<div class="modal-body">
<input type="hidden" name="<?php
echo vacunaTableClass::getNameField(vacunaTableClass::ID, true);
?>
" value="<?php
echo $key->id;
?>
">
<?php
echo i18n::__('cantidad');
?>
<input type="number" name="<?php
echo vacunaTableClass::getNameField(vacunaTableClass::CANTIDAD, true);
?>
">
</div>
<div class="modal-footer">
<a href="#close2" title="Close" type="button" class="btn btn-default fa fa-times-circle-o close2" data-dismiss="modal"> <?php
echo i18n::__('cancel');
?>
</a>
<button type="submit" class="btn btn-info active fa fa-plus-square" ><?php
echo i18n::__('insert', null, 'dpVenta');
?>
</button>
</div>
</form>
public function execute()
{
try {
$where = null;
if (request::getInstance()->hasPost('filter')) {
$filter = request::getInstance()->getPost('filter');
// if (isset($filter['id']) and $filter['id'] !== null and $filter['id'] !== '') {
// $where[vacunacionTableClass::getNameTable() . '.' . vacunacionTableClass::ID] = $filter['id'];
// }//close if
if (isset($filter['fecha']) and $filter['fecha'] !== null and $filter['fecha'] !== '') {
$where[vacunacionTableClass::FECHA] = $filter['fecha'];
}
//close if
if (isset($filter['animal']) and $filter['animal'] !== null and $filter['animal'] !== '') {
$where[vacunacionTableClass::ANIMAL] = $filter['animal'];
}
//close if
if (isset($filter['veterinario']) and $filter['veterinario'] !== null and $filter['veterinario'] !== '') {
$where[vacunacionTableClass::VETERINARIO] = $filter['veterinario'];
}
//close if
session::getInstance()->setAttribute('vacunacionFiltersAnimal', $where);
} elseif (session::getInstance()->hasAttribute('vacunacionFiltersAnimal')) {
$where = session::getInstance()->getAttribute('vacunacionFiltersAnimal');
}
//close if
$fieldsVeterinario = array(veterinarioTableCLass::ID, veterinarioTableClass::NOMBRE);
$fieldsAnimal = array(animalTableClass::ID, animalTableClass::NUMERO);
$orderBy = array(vacunacionTableClass::FECHA);
$page = 0;
if (request::getInstance()->hasGet('page')) {
$page = request::getInstance()->getGet('page') - 1;
$page = $page * config::getRowGrid();
}
//close if
$f = array(vacunacionTableClass::ID);
$lines = config::getRowGrid();
$this->cntPages = vacunacionTableClass::getAllCount($f, true, $lines, $where);
if (request::getInstance()->hasGet('page')) {
$this->page = request::getInstance()->getGet('page');
} else {
$this->page = $page;
}
//close if
$fieldsVavuna = array(vacunaTableClass::ID, vacunaTableClass::NOMBRE_VACUNA);
$fieldsVacunacion = array(vacunacionTableClass::ID, vacunacionTableClass::FECHA);
$fieldsVete = array(veterinarioTableClass::NOMBRE);
$fieldsAni = array(animalTableClass::NUMERO);
$fJoin1 = vacunacionTableClass::VETERINARIO;
$fJoin2 = veterinarioTableClass::ID;
$fJoin3 = vacunacionTableClass::ANIMAL;
$fJoin4 = animalTableClass::ID;
$this->objVacuna = vacunaTableClass::getAll($fieldsVavuna, true);
$this->objAnimal = animalTableClass::getAll($fieldsAnimal, true);
$this->objVeterinario = veterinarioTableClass::getAll($fieldsVeterinario, true);
$this->objVacunacion = vacunacionTableClass::getAllJoin($fieldsVacunacion, $fieldsVete, $fieldsAni, null, $fJoin1, $fJoin2, $fJoin3, $fJoin4, null, null, true, $orderBy, 'ASC', config::getRowGrid(), $page, $where);
// $this->objVacunacion = vacunacionTableClass::getAll($fields, true, $orderBy, 'ASC', config::getRowGrid(), $page, $where);
log::register(i18n::__('view', null, 'empleado'), vacunacionTableClass::getNameTable());
$this->defineView('index', 'vacunacion', session::getInstance()->getFormatOutput());
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
