コード例 #1
0
 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 {
         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');
     }
 }
コード例 #3
0
 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');
     }
 }
コード例 #4
0
 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');
     }
 }
コード例 #5
0
 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');
     }
 }
コード例 #8
0
 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');
     }
 }