public function execute()
 {
     try {
         $where = null;
         //            $idAnimal = request::getInstance()->getRequest(animalTableClass::ID);
         if (request::getInstance()->hasRequest('filter')) {
             $report = request::getInstance()->getPost('filter');
             if (isset($report['numero']) and $report['numero'] !== null and $report['numero'] !== '') {
                 $where[animalTableClass::getNameTable() . '.' . animalTableClass::ID] = $report['numero'];
             }
             //close if
             if (isset($report['lote']) and $report['lote'] !== null and $report['lote'] !== '') {
                 $where[animalTableClass::getNameTable() . '.' . animalTableClass::LOTE_ID] = $report['lote'];
             }
             //close if
         }
         //close if
         $fieldsAnimal = array(animalTableClass::ID, animalTableClass::NUMERO, animalTableClass::LOTE_ID);
         $fieldsLote = array(loteTableClass::NOMBRE);
         $fJoin1 = animalTableClass::LOTE_ID;
         $fJoin2 = loteTableClass::ID;
         //            print_r($where);
         //echo 12;
         //        exit();
         $this->objAnimal = animalTableClass::getAllJoin($fieldsAnimal, $fieldsLote, null, null, $fJoin1, $fJoin2, null, null, null, null, true, null, null, null, null, $where);
         $this->mensajeDetalle = "Inventario de Cerdos por Lote";
         log::register(i18n::__('reporte'), animalTableClass::getNameTable());
         $this->defineView('reportDetalle', '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
             $fecha = request::getInstance()->getPost(gestacionTableClass::getNameField(gestacionTableClass::FECHA, true));
             $empleado = request::getInstance()->getPost(gestacionTableClass::getNameField(gestacionTableClass::EMPLEADO, true));
             $animal = request::getInstance()->getPost(gestacionTableClass::getNameField(gestacionTableClass::ANIMAL, true));
             $fecha_monta = request::getInstance()->getPost(gestacionTableClass::getNameField(gestacionTableClass::FECHA_MONTA, true));
             //        $fecha_parto = request::getInstance()->getPost(gestacionTableClass::getNameField(gestacionTableClass::FECHA_PROBABLE_PARTO, true));
             $fecundador = request::getInstance()->getPost(gestacionTableClass::getNameField(gestacionTableClass::ANIMAL_FECUNDADOR, true));
             //validar si los campos estan vacios
             $datos = array($fecha, $empleado, $animal, $fecha_monta, $fecundador);
             gestacionTableClass::validate($fecha, $fecha_monta);
             //Insertar la informacion del usuario
             $data = array(gestacionTableClass::FECHA => $fecha, gestacionTableClass::EMPLEADO => $empleado, gestacionTableClass::ANIMAL => $animal, gestacionTableClass::FECHA_MONTA => $fecha_monta, gestacionTableClass::ANIMAL_FECUNDADOR => $fecundador);
             gestacionTableClass::insert($data);
             session::getInstance()->setSuccess(i18n::__('succesCreate', null, 'gestacion'));
             log::register(i18n::__('create'), animalTableClass::getNameTable());
             routing::getInstance()->redirect('animal', 'indexGestacion', array(hojaVidaTableClass::getNameField(hojaVidaTableClass::ANIMAL) => $animal));
         } else {
             log::register(i18n::__('create'), animalTableClass::getNameTable(), i18n::__('errorCreateBitacora'));
             session::getInstance()->setError(i18n::__('errorCreate', null, 'animal'));
             routing::getInstance()->redirect('animal', 'indexGestacion');
         }
     } 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
             $numeroIdentificacion = request::getInstance()->getPost(animalTableClass::getNameField(animalTableClass::NUMERO, true));
             //validar si los campos estan vacios
             $datos = array($numeroIdentificacion);
             $validatorEmpty = validator::getInstance()->validateFieldsEmpty($datos);
             if ($validatorEmpty == false) {
                 throw new PDOException(i18n::__(10006, null, 'errors', null, 10006));
             }
             //Validar el formato de fecha
             //                $validacionFecha = validator::getInstance()->validateDate($fecha);
             //                if ($validacionFecha == true) {
             //                    throw new PDOException(i18n::__(10005, null, 'errors', null, 10005));
             //                }
             //Validar campos numericos
             //            $validacionNumericos = validator::getInstance()->validateCharactersNumber($peso);
             //            if ($validacionNumericos == true) {
             //                throw new PDOException(i18n::__(10005, null, 'errors', null, 10005));
             //            }
             //                $validacionNumericos = validator::getInstance()->validateCharactersNumber($edad);
             //                if ($validacionNumericos == true) {
             //                    throw new PDOException(i18n::__(10005, null, 'errors', null, 10005));
             //                }
             //Insertar la informacion del usuario
             $data = array(animalTableClass::LOTE_ID => 2, animalTableClass::NUMERO => $numeroIdentificacion);
             animalTableClass::insert($data);
             session::getInstance()->setSuccess(i18n::__('succesCreate', null, 'animal'));
             log::register(i18n::__('create'), animalTableClass::getNameTable());
             routing::getInstance()->redirect('animal', 'indexAnimal');
         } else {
             log::register(i18n::__('create'), animalTableClass::getNameTable(), i18n::__('errorCreateBitacora'));
             session::getInstance()->setError(i18n::__('errorCreate', null, 'animal'));
             routing::getInstance()->redirect('animal', 'indexAnimal');
         }
     } 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()->hasPost('chk')) {
             $idsToDelete = request::getInstance()->getPost('chk');
             foreach ($idsToDelete as $id) {
                 $ids = array(animalTableClass::ID => $id);
                 animalTableClass::delete($ids, true);
             }
             log::register(i18n::__('delete'), animalTableClass::getNameTable());
             session::getInstance()->setSuccess(i18n::__('succesDelete', null, 'animal'));
             routing::getInstance()->redirect('animal', 'indexAnimal');
         } else {
             log::register(i18n::__('errorDelete'), animalTableClass::getNameTable());
             session::getInstance()->setError(i18n::__('errorDeleteMasivo', null, 'user'));
             routing::getInstance()->redirect('animal', 'indexAnimal');
         }
     } 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(animalTableClass::getNameField(animalTableClass::ID, true));
             //$observacion = request::getInstance()->getPost(usuarioTableClass::getNameField(usuarioTableClass::OBSERVACION, true));
             $ids = array(animalTableClass::ID => $id);
             animalTableClass::delete($ids, true);
             $this->arrayAjax = array('code' => 11, 'msg' => 'La eliminacion ha sido exitosa');
             $this->defineView('delete', 'animal', session::getInstance()->getFormatOutput());
             log::register(i18n::__('delete'), usuarioTableClass::getNameTable());
             session::getInstance()->setSuccess(i18n::__('succesDelete', null, 'animal'));
         } else {
             log::register(i18n::__('delete'), animalTableClass::getNameTable(), i18n::__('errorDeleteBitacora'));
             session::getInstance()->setError(i18n::__('errorDelete', null, 'animal'));
             routing::getInstance()->redirect('animal', 'index');
         }
     } catch (PDOException $exc) {
         session::getInstance()->setFlash('exc', $exc);
         routing::getInstance()->forward('shfSecurity', 'exception');
     }
 }