public function execute() { try { echo 1; $fields = array(cargoBaseTableClass::ID, cargoBaseTableClass::DESCRIPCION); $orderBy = array(cargoTableClass::ID); $page = 0; if (request::getInstance()->hasGet('page')) { $page = request::getInstance()->getGet('page') - 1; $page = $page * config::getRowGrid(); } $f = array(cargoTableClass::ID); $lines = config::getRowGrid(); $this->cntPages = cargoTableClass::getAllCount($f, true, $lines); if (request::getInstance()->hasGet('page')) { $this->page = request::getInstance()->getGet('page'); } else { $this->page = $page; } $this->objCargo = cargoTableClass::getAll($fields, true, $orderBy, 'ASC', config::getRowGrid(), $page); $this->defineView('index', 'cargo', session::getInstance()->getFormatOutput()); } catch (PDOException $exc) { session::getInstance()->setFlash('exc', $exc); routing::getInstance()->forward('shfSecurity', 'exception'); } }
public static function validateInsert() { $flag = false; $cargo = request::getInstance()->getPost('inputCargo'); if (self::notBlank($cargo)) { $flag = true; session::getInstance()->setFlash('inputCargo', true); session::getInstance()->setError('El campo cargo es obligatorio', 'inputCargo'); } else { if (is_numeric($cargo)) { $flag = true; session::getInstance()->setFlash('inputCargo', true); session::getInstance()->setError('El campo no debe ser númerico', 'inputCargo'); } else { if (strlen($cargo) > \cargoTableClass::DESC_CARGO_LENGTH) { $flag = true; session::getInstance()->setFlash('inputCargo', true); session::getInstance()->setError('El campo no debe de exceder el mínimo de caracteres permitidos', 'inputCargo'); } else { if (self::isUnique(\cargoTableClass::ID, true, array(\cargoTableClass::DESC_CARGO => $cargo), \cargoTableClass::getNameTable())) { $flag = true; session::getInstance()->setFlash('inputCargo', true); session::getInstance()->setError('Este cargo ya está creado', 'inputCargo'); } } } } if ($flag === true) { //request::getInstance()->setMethod('GET'); routing::getInstance()->forward('prestamo', 'formInsertarCargo'); } }
public function execute() { try { // $fields = array( // empleadoBaseTableClass::ID, // empleadoBaseTableClass::NOMBRE, // empleadoBaseTableClass::APELLIDO_EMPLEADO, // empleadoBaseTableClass::DIRECCION_EMPLEADO, // empleadoBaseTableClass::TELEFONO_EMPLEADO, // empleadoBaseTableClass::MOVIL_EMPELADO, // empleadoBaseTableClass::CORREO_EMPLEADO, // empleadoBaseTableClass::USUARIO_ID, // // ); // // $fields1 = array(cargoTableClass::ID, cargoTableClass::DESC_CARGO); // // $fields3 = array( // usuarioTableClass::ID, // usuarioTableClass::PASSWORD, // usuarioTableClass::LAST_LOGIN_AT // // ); $this->objCargo = cargoTableClass::getAll($fields1); // $this->objUsuario= usuarioTableClass::getAll($fields3); $this->defineView('formEmpleado', 'prestamo', 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'); // validacion de datos if (isset($filter['telefono']) and $filter['telefono'] !== null and $filter['telefono'] !== '') { $where[empleadoTableClass::TEL] = $filter['telefono']; } if (isset($filter['nombre_completo']) and $filter['nombre_completo'] !== null and $filter['nombre_completo'] !== '') { $where[empleadoTableClass::NOMBRE] = $filter['nombre_completo']; } if (isset($filter['cargo']) and $filter['cargo'] !== null and $filter['cargo'] !== '') { $where[empleadoTableClass::CARGO] = $filter['cargo']; } if (isset($filter['tipo_doc']) and $filter['tipo_doc'] !== null and $filter['tipo_doc'] !== '') { $where[empleadoTableClass::TIPO_DOC] = $filter['tipo_doc']; } session::getInstance()->setAttribute('empleadoDeleteFilters', $where); } $fieldsCargo = array(cargoTableClass::ID, cargoTableClass::DESCRIPCION); $fieldsTipoDoc = array(tipoDocumentoTableClass::ID, tipoDocumentoTableClass::DESCRIPCION); $fields = array(empleadoTableClass::ID, empleadoTableClass::NUMERO_DOC, empleadoTableClass::CIUDAD, empleadoTableClass::NOMBRE, empleadoTableClass::TEL, empleadoTableClass::CARGO, empleadoTableClass::TIPO_DOC, empleadoTableClass::DIRECCION); $fields2 = array(ciudadTableClass::NOMBRE); $fields3 = array(cargoTableClass::DESCRIPCION); $fields4 = array(tipoDocumentoTableClass::DESCRIPCION); $fJoin1 = empleadoTableClass::CIUDAD; $fJoin2 = ciudadTableClass::ID; $fJoin3 = empleadoTableClass::CARGO; $fJoin4 = cargoTableClass::ID; $fJoin5 = empleadoTableClass::TIPO_DOC; $fJoin6 = tipoDocumentoTableClass::ID; $orderBy = array(empleadoTableClass::ID); $page = 0; if (request::getInstance()->hasGet('page')) { $page = request::getInstance()->getGet('page') - 1; $page = $page * config::getRowGrid(); } $f = array(empleadoTableClass::ID); $lines = config::getRowGrid(); $this->cntPages = empleadoTableClass::getAllCount($f, true, $lines); if (request::getInstance()->hasGet('page')) { $this->page = request::getInstance()->getGet('page'); } else { $this->page = $page; } $this->objEmpleado = empleadoTableClass::getAllJoin($fields, $fields2, $fields3, $fields4, $fJoin1, $fJoin2, $fJoin3, $fJoin4, $fJoin5, $fJoin6, true, $orderBy, 'ASC', config::getRowGrid(), $page, $where); $this->objCargo = cargoTableClass::getAll($fieldsCargo, true); $this->objtipoDoc = tipoDocumentoTableClass::getAll($fieldsTipoDoc, false); $this->defineView('index', 'empleado', session::getInstance()->getFormatOutput()); } catch (PDOException $exc) { session::getInstance()->setFlash('exc', $exc); routing::getInstance()->forward('shfSecurity', 'exception'); } }
public function execute() { try { $fields = array(cargoTableClassTableClass::ID, cargoTableClassTableClass::DESC_CARGO); $this->objcargo = cargoTableClass::getAll($fields, true); $this->defineView($cargo, $default, session::getInstance()->getFormatOutput()); } catch (PDOException $exc) { echo $exc->getMessage(); echo 'br'; echo $exc->getTraceAsString(); } }
public static function validateCreate($descripcion) { $flag = false; $patternC = "^[a-zA-Z0-9]{3,20}\$"; if (ereg($patternC, $descripcion) == false) { session::getInstance()->setError('nop'); $flag = true; session::getInstance()->setFlash(cargoTableClass::getNameField(cargoTableClass::DESCRIPCION, true), true); } if ($flag == true) { request::getInstance()->setMethod('GET'); routing::getInstance()->forward('personal', 'insertCargo'); } }
public function execute() { try { $fieldsTipo_doc = array(tipoDocumentoTableClass::ID, tipoDocumentoTableClass::DESCRIPCION); $fieldsCargo = array(cargoTableClass::ID, cargoTableClass::DESCRIPCION); $fieldsCiudad = array(ciudadTableClass::ID, ciudadTableClass::NOMBRE); $this->objCargo = cargoTableClass::getAll($fieldsCargo, true); $this->objCiudad = ciudadTableClass::getAll($fieldsCiudad, true); $this->objTipo_doc = tipoDocumentoTableClass::getAll($fieldsTipo_doc, true); $this->defineView('insert', 'empleado', session::getInstance()->getFormatOutput()); } catch (PDOException $exc) { session::getInstance()->setFlash('exc', $exc); routing::getInstance()->forward('shfSecurity', 'exception'); } }
public function execute() { try { if (request::getInstance()->hasRequest(cargoTableClass::ID)) { $fields = array(cargoTableClass::ID, cargoTableClass::DESCRIPCION); $where = array(cargoTableClass::ID => request::getInstance()->getRequest(cargoTableClass::ID)); $this->objCargo = cargoTableClass::getAll($fields, false, null, null, null, null, $where); $this->defineView('edit', 'cargo', session::getInstance()->getFormatOutput()); } else { routing::getInstance()->redirect('personal', 'indexCargo'); } } 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(cargoTableClass::getNameField(cargoTableClass::ID, true)); $descripcion = request::getInstance()->getPost(cargoTableClass::getNameField(cargoTableClass::DESCRIPCION, true)); $ids = array(cargoTableClass::ID => $id); $data = array(cargoTableClass::DESCRIPCION => $descripcion); cargoTableClass::update($ids, $data); } routing::getInstance()->redirect('personal', 'indexCargo'); } catch (PDOException $exc) { session::getInstance()->setFlash('exc', $exc); routing::getInstance()->forward('shfSecurity', 'exception'); } }
public function execute() { try { if (request::getInstance()->isMethod('POST')) { validate::validateInsert(); $data = array(cargoTableClass::DESC_CARGO => request::getInstance()->getPost('inputCargo')); cargoTableClass::insert($data); session::getInstance()->setSuccess('El cargo fue creado exitosamente'); $this->defineView('index', 'default', session::getInstance()->getFormatOutput()); } else { //inputCargo routing::getInstance()->redirect('default', 'index'); } } catch (PDOException $exc) { session::getInstance()->setFlash('exc', $exc); routing::getInstance()->forward('shfSecurity', 'exception'); } }
public function execute() { try { if (request::getInstance()->isMethod('POST')) { $descripcion = request::getInstance()->getPost(cargoBaseTableClass::getNameField(cargoBaseTableClass::DESCRIPCION, true)); cargoTableClass::validateCreate($descripcion); $data = array(cargoBaseTableClass::DESCRIPCION => $descripcion); cargoBaseTableClass::insert($data); session::getInstance()->setSuccess(i18n::__('succesCreate')); log::register(i18n::__('create'), cargoTableClass::getNameTable()); routing::getInstance()->redirect('personal', 'indexCargo'); } else { log::register(i18n::__('create'), cargoTableClass::getNameTable(), i18n::__('errorCreateBitacora')); session::getInstance()->setError(i18n::__('errorCreate')); routing::getInstance()->redirect('personal', 'indexCargo'); } } catch (PDOException $exc) { session::getInstance()->setFlash('exc', $exc); routing::getInstance()->forward('shfSecurity', 'exception'); } }
public function execute() { try { if (request::getInstance()->hasRequest(usuarioTableClass::ID)) { $fields = array(usuarioTableClass::ID, usuarioTableClass::USER, usuarioTableClass::PASSWORD); $where = array(usuarioTableClass::ID => request::getInstance()->getRequest(usuarioTableClass::ID)); $fields1 = array(empleadoTableClass::ID, empleadoTableClass::NOMBRE, empleadoTableClass::APELLIDO_EMPLEADO, empleadoTableClass::DIRECCION_EMPLEADO, empleadoTableClass::TELEFONO_EMPLEADO, empleadoTableClass::MOVIL_EMPELADO, empleadoTableClass::CORREO_EMPLEADO, empleadoTableClass::CARGO_ID); $where1 = array(empleadoTableClass::ID => request::getInstance()->getRequest(usuarioTableClass::ID)); $fields2 = array(cargoTableClass::ID, cargoTableClass::DESC_CARGO); $this->objCargo = cargoTableClass::getAll($fields2); $this->objUsuario = usuarioTableClass::getAll($fields, true, null, null, null, null, $where); $this->objEmpleado = empleadoTableClass::getAll($fields1, true, null, null, null, null, $where1); $this->defineView('formEmpleado', 'prestamo', session::getInstance()->getFormatOutput()); } else { routing::getInstance()->redirect('prestamo', 'insert'); } // if (request::getInstance()->isMethod('POST')) { // // $usuario = request::getInstance()->getPost(usuarioTableClass::getNameField(usuarioTableClass::USUARIO, true)); // $password = request::getInstance()->getPost(usuarioTableClass::getNameField(usuarioTableClass::PASSWORD, true)); // // if (strlen($usuario) > usuarioTableClass::USUARIO_LENGTH) { // throw new PDOException(i18n::__(00001, null, 'errors', array(':longitud' => usuarioTableClass::USUARIO_LENGTH)), 00001); // } // // $data = array( // usuarioTableClass::USUARIO => $usuario, // usuarioTableClass::PASSWORD => md5($password) // ); // usuarioTableClass::insert($data); // routing::getInstance()->redirect('default', 'index'); // } else { // routing::getInstance()->redirect('default', 'index'); // } } 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(cargoTableClass::ID => $id); cargoTableClass::delete($ids, true); } log::register(i18n::__('delete'), cargoTableClass::getNameTable()); session::getInstance()->setSuccess(i18n::__('succesDelete', null, 'cargo')); routing::getInstance()->redirect('empleado', 'indexCargo'); } else { log::register(i18n::__('errorDelete'), cargoTableClass::getNameTable()); session::getInstance()->setError(i18n::__('errorDeleteMasivo', null, 'user')); routing::getInstance()->redirect('empleado', 'indexCargo'); } } catch (PDOException $exc) { session::getInstance()->setFlash('exc', $exc); routing::getInstance()->forward('shfSecurity', 'exception'); } }
public function execute() { try { if (request::getInstance()->hasRequest(empleadoTableClass::ID)) { $fields = array(empleadoTableClass::ID, empleadoTableClass::NUMERO_DOC, empleadoTableClass::NOMBRE, empleadoTableClass::TEL, empleadoTableClass::CIUDAD, empleadoTableClass::CARGO, empleadoTableClass::DIRECCION, empleadoTableClass::TIPO_DOC); $where = array(empleadoTableClass::ID => request::getInstance()->getRequest(empleadoTableClass::ID)); $fieldsCiudad = array(ciudadTableClass::ID, ciudadTableClass::NOMBRE); $fieldsCargo = array(cargoTableClass::ID, cargoTableClass::DESCRIPCION); $fieldsTipo_doc = array(tipoDocumentoTableClass::ID, tipoDocumentoTableClass::DESCRIPCION); $this->objCargo = cargoTableClass::getAll($fieldsCargo, true); $this->objCiudad = ciudadTableClass::getAll($fieldsCiudad, true); $this->objTipo_doc = tipoDocumentoTableClass::getAll($fieldsTipo_doc, false); $this->objEmpleado = empleadoTableClass::getAll($fields, true, null, null, null, null, $where); $this->defineView('edit', 'empleado', session::getInstance()->getFormatOutput()); } else { routing::getInstance()->redirect('personal', 'indexEmpleado'); } } catch (PDOException $exc) { session::getInstance()->setFlash('exc', $exc); routing::getInstance()->forward('shfSecurity', 'exception'); } }
} ?> <div class="container"> <div class="row"> <div class="col-xs-6-offset-3"> <table class="table table-responsive "> <tr> <th> <?php echo i18n::__('cargo', NULL, 'cargo'); ?> :</th> <th> <input required pattern="[a-zA-Z0-9]{3,20}$" placeholder="cargo" name="<?php echo cargoTableClass::getNameField(cargoTableClass::DESCRIPCION, true); ?> "></th> <tr> <th colspan="2"> <div class="titulo"> <input type="submit" value="<?php echo i18n::__(isset($objCargo) == TRUE ? 'edit' : 'register', $culture = NULL); ?> "> </div> </th> </tr> </table> </div>