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