public function execute()
 {
     try {
         if (request::getInstance()->isMethod('POST')) {
             $id = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::ID, true));
             $TIPO_DOCUMENTO_ID = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::TIPO_DOCUMENTO_ID, true));
             $IDENTIFICACION = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::IDENTIFICACION, true));
             $NOMBRE = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::NOMBRE, true));
             $APELLIDO = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::APELLIDO, true));
             $DIRECCION = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::DIRECCION, true));
             $TELEFONO = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::TELEFONO, true));
             $MOVIL = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::MOVIL, true));
             $CORREO = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::CORREO, true));
             //        $LOCALIDAD_ID = request::getInstance()->getPost( empleadoTableClass::getNameField( empleadoTableClass::LOCALIDAD_ID, true));
             //        $USUARIO_ID = request::getInstance()->getPost( empleadoTableClass::getNameField( empleadoTableClass::USUARIO_ID, true));
             $id = array(empleadoTableClass::ID => $id);
             $data = array(empleadoTableClass::TIPO_DOCUMENTO_ID => $TIPO_DOCUMENTO_ID, empleadoTableClass::IDENTIFICACION => $IDENTIFICACION, empleadoTableClass::NOMBRE => $NOMBRE, empleadoTableClass::APELLIDO => $APELLIDO, empleadoTableClass::DIRECCION => $DIRECCION, empleadoTableClass::TELEFONO => $TELEFONO, empleadoTableClass::MOVIL => $MOVIL, empleadoTableClass::CORREO => $CORREO);
             empleadoTableClass::update($id, $data);
         }
         session::getInstance()->setSuccess('El registro fue modificado exitosamente');
         routing::getInstance()->redirect('@empleado_listado');
         //$this->defineView('editBanco', 'banco', 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') and request::getInstance()->isAjaxRequest()) {
             $id = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::ID, true));
             $ids = array(empleadoTableClass::ID => $id);
             $this->arrayAjax = array('code' => 11, 'msg' => 'La eliminacion ha sido exitosa');
             empleadoTableClass::delete($ids, true);
             $this->defineView('delete', 'empleado', session::getInstance()->getFormatOutput());
         } else {
             routing::getInstance()->redirect('personal', 'indexEmpleado');
         }
     } catch (PDOException $exc) {
         session::getInstance()->setFlash('exc', $exc);
         routing::getInstance()->forward('shfSecurity', 'exception');
     }
 }
 public function execute()
 {
     try {
         if (request::getInstance()->isMethod('POST')) {
             $ids = array(usuarioTableClass::ID => request::getInstance()->getPost(usuarioTableClass::getNameField(usuarioTableClass::ID, true)));
             $data = array(usuarioTableClass::USER => request::getInstance()->getPost('inputUsuario'), usuarioTableClass::PASSWORD => md5(request::getInstance()->getPost('inputPassword')));
             $data1 = array(empleadoTableClass::NOMBRE => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::NOMBRE, true)), empleadoTableClass::APELLIDO_EMPLEADO => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::APELLIDO_EMPLEADO, true)), empleadoTableClass::DIRECCION_EMPLEADO => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::DIRECCION_EMPLEADO, true)), empleadoTableClass::TELEFONO_EMPLEADO => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::TELEFONO_EMPLEADO, true)), empleadoTableClass::MOVIL_EMPELADO => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::MOVIL_EMPELADO, true)), empleadoTableClass::CORREO_EMPLEADO => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::CORREO_EMPLEADO, true)), empleadoTableClass::CARGO_ID => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::CARGO_ID, true)));
             $ids1 = array(empleadoTableClass::ID => request::getInstance()->getPost(usuarioTableClass::getNameField(usuarioTableClass::ID, true)));
             session::getInstance()->setSuccess('El empleado fue actulizado exitosamente');
             // $this->defineView('cliente', 'prestamo', session::getInstance()->getFormatOutput());
             $this->defineView('index', 'prestamo', session::getInstance()->getFormatOutput());
             usuarioTableClass::update($ids, $data);
             empleadoTableClass::update($ids1, $data1);
         }
         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')) {
             // primero hay que crear el cliente y luego si los datos!!!
             $data = array(usuarioTableClass::USER => request::getInstance()->getPost('inputUsuario'), usuarioTableClass::PASSWORD => md5(request::getInstance()->getPost('inputPassword')), '__sequence' => 'usuario_id_seq');
             $usuario_id = usuarioTableClass::insert($data);
             //validate::validateInsert();
             $data1 = array(empleadoTableClass::NOMBRE => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::NOMBRE, true)), empleadoTableClass::APELLIDO_EMPLEADO => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::APELLIDO_EMPLEADO, true)), empleadoTableClass::DIRECCION_EMPLEADO => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::DIRECCION_EMPLEADO, true)), empleadoTableClass::TELEFONO_EMPLEADO => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::TELEFONO_EMPLEADO, true)), empleadoTableClass::MOVIL_EMPELADO => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::MOVIL_EMPELADO, true)), empleadoTableClass::CORREO_EMPLEADO => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::CORREO_EMPLEADO, true)), empleadoTableClass::CARGO_ID => request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::CARGO_ID, true)), empleadoTableClass::USUARIO_ID => $usuario_id);
             empleadoTableClass::insert($data1);
             session::getInstance()->setSuccess('El empleado fue creado exitosamente');
             // $this->defineView('cliente', 'prestamo', session::getInstance()->getFormatOutput());
             $this->defineView('index', 'prestamo', session::getInstance()->getFormatOutput());
         } else {
             //inputBarrio
             routing::getInstance()->redirect('prestamo', 'createEmpleado');
         }
     } 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(empleadoTableClass::getNameField(empleadoTableClass::ID, true));
             $numero_documento = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::NUMERO_DOC, true));
             $nombre_completo = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::NOMBRE, true));
             $tipo_doc = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::TIPO_DOC, true));
             $cargo = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::CARGO, true));
             $ciudad = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::CIUDAD, true));
             $telefono = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::TEL, true));
             $direccion = request::getInstance()->getPost(empleadoTableClass::getNameField(empleadoTableClass::DIRECCION, true));
             empleadoTableClass::validateUpdate($nombre_completo, $direccion, $telefono, $numero_documento);
             $ids = array(empleadoTableClass::ID => $id);
             $data = array(empleadoTableClass::NUMERO_DOC => $numero_documento, empleadoTableClass::NOMBRE => $nombre_completo, empleadoTableClass::TIPO_DOC => $tipo_doc, empleadoTableClass::CARGO => $cargo, empleadoTableClass::TEL => $telefono, empleadoTableClass::DIRECCION => $direccion, empleadoTableClass::CIUDAD => $ciudad);
             empleadoTableClass::update($ids, $data);
             log::register('update', empleadoTableClass::getNameTable());
         }
         routing::getInstance()->redirect('personal', 'indexEmpleado');
     } catch (PDOException $exc) {
         session::getInstance()->setFlash('exc', $exc);
         routing::getInstance()->forward('shfSecurity', 'exception');
     }
 }
 public static function validateUpdate($nombre_completo, $direccion, $telefono, $numero_documento)
 {
     $flag = false;
     $patron = "^[a-zA-Z0-9]{3,20}\$";
     if (empty($numero_documento)) {
         session::getInstance()->setError('vacio el campo num');
         $flag = true;
         session::getInstance()->setFlash(empleadoTableClass::getNameField(empleadoTableClass::NUMERO_DOC, true), true);
     }
     if (empty($telefono)) {
         session::getInstance()->setError('vacio el campo tel');
         $flag = true;
         session::getInstance()->setFlash(empleadoTableClass::getNameField(empleadoTableClass::TEL, true), true);
     }
     if (empty($direccion)) {
         session::getInstance()->setError('vacio el campo direc');
         $flag = true;
         session::getInstance()->setFlash(empleadoTableClass::getNameField(empleadoTableClass::DIRECCION, true), true);
     }
     if (empty($nombre_completo) or !isset($nombre_completo) or $nombre_completo == '') {
         session::getInstance()->setError('No puede ser vacio');
         $flag = true;
         session::getInstance()->setFlash(empleadoTableClass::getNameField(empleadoTableClass::NOMBRE, true), true);
     } else {
         if (strlen($nombre_completo) < 2) {
             session::getInstance()->setError('Minimo dos caracteres');
             $flag = true;
             session::getInstance()->setFlash(empleadoTableClass::getNameField(empleadoTableClass::NOMBRE, true), true);
         } else {
             if (!ereg($patron, $nombre_completo)) {
                 session::getInstance()->setError('No se permiten caracteres especiales');
                 $flag = true;
                 session::getInstance()->setFlash(empleadoTableClass::getNameField(empleadoTableClass::NOMBRE, true), true);
             }
         }
     }
 }
}
?>
                            </select>
                        </th>
                    </tr>
                    <tr>
                        <th>
                            <?php 
echo i18n::__('cargo', null, 'cargo');
?>
:
                        </th>

                        <th>
                            <select name="<?php 
echo empleadoTableClass::getNameField(empleadoTableClass::CARGO, true);
?>
">
                                <option>...</option>
                                <?php 
foreach ($objCargo as $key) {
    ?>
                                    <option value="<?php 
    echo $key->id;
    ?>
">
                                        <?php 
    echo $key->descripcion_cargo;
    ?>
                                    </option>
                                <?php 
use mvc\routing\routingClass as routing;
use mvc\i18n\i18nClass as i18n;
$id = procesoCompraTableClass::ID;
$nombreEmpleado = empleadoTableClass::NOMBRE;
$nombreProveedor = proveedorTableClass::NOMBRE;
?>
<form method="post" action="<?php 
echo routing::getInstance()->getUrlWeb('factura', isset($objFacturaCompra) == TRUE ? 'updateFacturaCompra' : 'createFacturaCompra');
?>
">
  <?php 
if (isset($objFacturaCompra)) {
    ?>
    <input type="hidden" name="<?php 
    echo empleadoTableClass::getNameField(empleadoTableClass::ID, TRUE);
    ?>
" value="<?php 
    echo $objFacturaCompra[0]->{$id};
    ?>
">
  <?php 
}
//close if
?>
  <div class="container">
    <div class="row">
      <div class="col-xs-6-offset-3">
          <div class="table-responsive">
          <table class="table  "> 
                          <tr>
                    <a href="#close" title="Close" class="close">X</a>
                    <div class="modal-body">
                  <?php 
    echo i18n::__('eliminarIndividual');
    ?>
                    </div>
                    <div class="modal-footer">
                      <a href="#close2" title="Close" class="close2 btn btn-default fa fa-times-circle-o close2"><?php 
    echo i18n::__('cancel');
    ?>
</a>
                      <button type="button" class="btn btn-primary fa fa-eraser" onclick="eliminar(<?php 
    echo $key->{$id};
    ?>
, '<?php 
    echo empleadoTableClass::getNameField(empleadoTableClass::ID, true);
    ?>
', '<?php 
    echo routing::getInstance()->getUrlWeb('personal', 'deleteEmpleado');
    ?>
')"><?php 
    echo i18n::__('delete');
    ?>
</button>
                    </div>
                  </div>
                </div>
                <?php 
    $countDetale++;
    ?>
              <?php 
if (session::getInstance()->hasFlash('inputcargo')) {
    ?>
          <span class="glyphicon glyphicon-remove form-control-feedback" aria-hidden="true"></span>
        <?php 
}
?>
      </div>
     
     
     
     
     <!--
      <label for="inputUsuario" class="col-sm-2 control-label">USUARIO</label>
      <div class="col-sm-10">
        <select class="form-control" name="<?php 
echo empleadoTableClass::getNameField(empleadoTableClass::USUARIO_ID, true);
?>
">
          <option value="">Seleccione USUARIO</option>
          <?php 
$localidad = '';
?>
          <?php 
foreach ($objUsuari as $usuario) {
    ?>
            <option value="<?php 
    echo $usuario->id;
    ?>
"><?php 
    echo $usuario->usuario_id;
    ?>