public function execute() { try { $where = null; $idVacunacion = request::getInstance()->getRequest(vacunacionTableClass::ID); if (request::getInstance()->hasRequest('report')) { $report = request::getInstance()->getPost('report'); if (isset($report['fecha']) and $report['fecha'] !== null and $report['fecha'] !== '') { $where[detalleVacunacionTableClass::FECHA] = $report['fecha']; } //close if if (isset($report['vacuna']) and $report['vacuna'] !== null and $report['vacuna'] !== '') { $where[detalleVacunacionTableClass::VACUNA] = $report['vacuna']; } //close if if (isset($report['dosis']) and $report['dosis'] !== null and $report['dosis'] !== '') { $where[detalleVacunacionTableClass::DOSIS] = $report['dosis']; } //close if if (isset($report['accion']) and $report['accion'] !== null and $report['accion'] !== '') { $where[detalleVacunacionTableClass::ACCION] = $report['accion']; } //close if } //close if $where[detalleVacunacionTableClass::ID_REGISTRO] = $idVacunacion; $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; $fieldsVacunacion = array(vacunacionTableClass::ID, vacunacionTableClass::FECHA); $fieldsVete = array(veterinarioTableClass::NOMBRE); $fieldsAni = array(animalTableClass::NUMERO); $fJoinVacunacion1 = vacunacionTableClass::VETERINARIO; $fJoinVacunacion2 = veterinarioTableClass::ID; $fJoinVacunacion3 = vacunacionTableClass::ANIMAL; $fJoinVacunacion4 = animalTableClass::ID; $whereVacunacion = array(vacunacionTableClass::getNameTable() . "." . vacunacionTableClass::ID => $idVacunacion); $this->objDetalleVacunacion = detalleVacunacionTableClass::getAllJoin($fieldsDetalleVacunacion, $fieldsVacu, null, null, $fJoin1, $fJoin2, null, null, null, null, true, null, null, null, null, $where); $this->objVacunacion = vacunacionTableClass::getAllJoin($fieldsVacunacion, $fieldsVete, $fieldsAni, null, $fJoinVacunacion1, $fJoinVacunacion2, $fJoinVacunacion3, $fJoinVacunacion4, null, null, true, null, null, null, null, $whereVacunacion); $this->mensajeDetalle = "Informe de Detalles del Control de Vacunacion"; log::register(i18n::__('reporte'), detalleVacunacionTableClass::getNameTable()); $this->defineView('reportDetalle', 'vacunacion', session::getInstance()->getFormatOutput()); } catch (PDOException $exc) { session::getInstance()->setFlash('exc', $exc); routing::getInstance()->forward('shfSecurity', 'exception'); } }
public function execute() { try { $fields = array(vacunacionTableClass::ID, vacunacionTableClass::FECHA, vacunacionTableClass::VETERINARIO, vacunacionTableClass::ANIMAL); $fieldsVeterinario = array(veterinarioTableClass::NOMBRE); $fieldsAnimal = array(animalTableClass::NUMERO); $fJoin1 = vacunacionTableClass::VETERINARIO; $fJoin2 = veterinarioTableClass::ID; $fJoin3 = vacunacionTableClass::ANIMAL; $fJoin4 = animalTableClass::ID; $orderBy = array(vacunacionTableClass::FECHA); $this->mensaje = "Informe del Control de Vacunacion"; $this->objVacunacion = vacunacionTableClass::getAllJoin($fields, $fieldsVeterinario, $fieldsAnimal, null, $fJoin1, $fJoin2, $fJoin3, $fJoin4, null, null, true, $orderBy, 'ASC', null); log::register(i18n::__('reporte'), vacunacionTableClass::getNameTable()); $this->defineView('report', 'vacunacion', 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 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'); } }