public function execute() { try { $where = null; if (request::getInstance()->hasRequest('filter')) { $report = request::getInstance()->getPost('filter'); if (isset($report['numero']) and $report['numero'] !== null and $report['numero'] !== '') { $where[carneVacunasTableClass::getNameTable() . '.' . carneVacunasTableClass::ANIMAL] = $report['numero']; } //close if } //close if $fields = array(carneVacunasTableClass::ID, carneVacunasTableClass::ACCION, carneVacunasTableClass::DOSIS, carneVacunasTableClass::FECHA_VACUNACION); $fields2 = array(animalTableClass::NUMERO); $fields3 = array(veterinarioTableClass::NOMBRE); $fields4 = array(vacunaTableClass::NOMBRE_VACUNA); $fJoin1 = carneVacunasTableClass::ANIMAL; $fJoin2 = animalTableClass::ID; $fJoin3 = carneVacunasTableClass::VACUNA; $fJoin4 = vacunaTableClass::ID; $fJoin5 = carneVacunasTableClass::VETERINARIO; $fJoin6 = veterinarioTableClass::ID; $orderBy = array(carneVacunasTableClass::FECHA_VACUNACION); $this->objCarne = carneVacunasTableClass::getAllJoin($fields, $fields2, $fields3, $fields4, $fJoin1, $fJoin2, $fJoin3, $fJoin4, $fJoin5, $fJoin6, false, $orderBy, 'ASC', null, null, $where); $this->mensaje = 'Carnet de Vacunas del Cerdo'; log::register(i18n::__('reporte'), carneVacunasTableClass::getNameTable()); $this->defineView('indexVacunacion', '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 { 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'); } }
?> </select> <br/> <?php echo i18n::__('dosis', null, 'detalleVacunacion'); ?> <input type="number" name="<?php echo carneVacunasTableClass::getNameField(carneVacunasTableClass::DOSIS, true); ?> "> <br/> <?php echo i18n::__('accion'); ?> <select name="<?php echo carneVacunasTableClass::getNameField(carneVacunasTableClass::ACCION, true); ?> "> <option value="">...</option> <option><?php echo i18n::__('enfermedad'); ?> </option> <option><?php echo i18n::__('gestacion'); ?> </option> <option><?php echo i18n::__('parto'); ?> </option>
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 static function validateModificar($veterinario, $vacuna, $fecha, $dosis, $accion) { $flag = false; $dateNow = date("Y-m-d H:m", strtotime("now")); if (empty($veterinario) or !isset($veterinario) or $veterinario == '') { session::getInstance()->setError(i18n::__(10092, null, 'errors')); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::VETERINARIO, true), true); } if (!is_numeric($veterinario)) { session::getInstance()->setError(i18n::__(10056, null, 'errors', array('%veterinario%' => $veterinario))); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::VETERINARIO, true), true); } if ($veterinario < 0) { session::getInstance()->setError(i18n::__(10094, null, 'errors')); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::VETERINARIO, true), true); } if (empty($fecha) or !isset($fecha) or $fecha == '') { session::getInstance()->setError(i18n::__(10058, null, 'errors', array('%campo%' => $fecha))); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::FECHA_VACUNACION, true), true); } if ($fecha > $dateNow) { session::getInstance()->setError(i18n::__(10010, null, 'errors', array('%fecha%' => $fecha))); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::FECHA_VACUNACION, true), true); } if (empty($vacuna) or !isset($vacuna) or $vacuna == '') { session::getInstance()->setError(i18n::__(10096, null, 'errors')); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::VACUNA, true), true); } if (!is_numeric($vacuna)) { session::getInstance()->setError(i18n::__(10060, null, 'errors', array('%id_vacuna%' => $vacuna))); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::VACUNA, true), true); } if ($vacuna < 0) { session::getInstance()->setError(i18n::__(10097, null, 'errors')); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::VACUNA, true), true); } if (empty($dosis) or !isset($dosis) or $dosis == '') { session::getInstance()->setError(i18n::__(10064, null, 'errors', array('%campo%' => $dosis))); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::DOSIS, true), true); } if (!is_numeric($dosis)) { session::getInstance()->setError(i18n::__(10066, null, 'errors', array('%campo%' => $dosis))); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::DOSIS, true), true); } if ($dosis < 0) { session::getInstance()->setError(i18n::__(10098, null, 'errors')); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::DOSIS, true), true); } if (strlen($dosis) > 10) { session::getInstance()->setError(i18n::__(10062, null, 'errors')); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::DOSIS, true), true); } if (empty($accion) or !isset($accion) or $accion == '') { session::getInstance()->setError(i18n::__(10065, null, 'errors', array('%campo%' => $accion))); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::ACCION, true), true); } if (strlen($accion) > 50) { session::getInstance()->setError(i18n::__(10063, null, 'errors')); $flag = true; session::getInstance()->setFlash(carneVacunasTableClass::getNameField(carneVacunasTableClass::ACCION, true), true); } if ($flag == true) { request::getInstance()->setMethod('GET'); routing::getInstance()->forward('animal', 'editVacunacion'); } }