public function execute(array $args)
{
if (isset($args['e_id'])) {
} else {
$usersMaper = MySQLEntityManager::createMaper(User::class);
$body = $usersMaper->select('id, nombre, rol_id')->with('rol');
}
return $this->responseInfo = ['body' => $body->toArray(), 'status' => self::STATUS_OK];
}
public function execute(array $args)
{
$maper = MySQLEntityManager::createMaper(SolicitudPQR::class);
if ($maper->delete(['id' => $args['pqr_id']])) {
return $this->responseInfo = ['body' => '', 'status' => self::STATUS_OK];
} else {
return false;
}
}
public function execute(array $args)
{
$maper = MySQLEntityManager::createMaper(SolicitudPQR::class);
$data = $maper->get($args['pqr_id'])->toArray();
if ($data) {
return $this->responseInfo = ['body' => $data, 'status' => self::STATUS_OK];
} else {
return false;
}
}
public function execute(array $args)
{
$data = json_decode($this->request->getBody());
$maper = MySQLEntityManager::createMaper(SolicitudPQR::class);
$result = $maper->create(['cedula_empleado' => $data->cedula_empleado, 'mensaje' => $data->mensaje]);
if ($result) {
return $this->responseInfo = ['body' => $result, 'status' => self::STATUS_CREATED];
} else {
return false;
}
}
public function execute(array $args)
{
$data = json_decode($this->request->getBody());
$mapper = MySQLEntityManager::createMaper(User::class);
$user = $mapper->checkUser($data);
$tokenId = base64_encode(mcrypt_create_iv(32));
if ($user) {
$signer = new Sha256();
$token = (new Builder())->setId($tokenId, true)->setIssuedAt(time())->set('user', $user)->sign($signer, getenv("SECRET_KEY"))->getToken();
return $this->responseInfo = ['body' => ['token' => "{$token}"], 'status' => self::STATUS_OK];
} else {
return $this->responseInfo = ['body' => ['msj' => 'credenciales incorrestas'], 'status' => self::STATUS_UNAUTHORIZED];
}
}
public function execute(array $args)
{
$data = json_decode($this->request->getBody());
$mapper = MySQLEntityManager::createMaper(User::class);
$user = $mapper->checkUser($data->id_user, $data->username);
if ($user) {
$user = $mapper->get($data->id_user);
$user->contrasena = password_hash($data->new_password, PASSWORD_BCRYPT);
$mapper->update($user);
return $this->responseInfo = ['body' => ['body' => 'contraseña actualizada'], 'status' => self::STATUS_OK];
} else {
return false;
}
}
public function execute(array $args)
{
$data = json_decode($this->request->getBody());
$maper = MySQLEntityManager::createMaper(SolicitudPQR::class);
$solicitud_pqr = $maper->get($data->id);
if ($solicitud_pqr) {
$solicitud_pqr->respuesta = $data->respuesta;
$solicitud_pqr->fecha_respuesta = new \DateTime();
$solicitud_pqr->usuario_que_responde = $data->user_id;
$maper->update($solicitud_pqr);
return $this->responseInfo = ['body' => '', 'status' => self::STATUS_OK];
} else {
return false;
}
}
public function execute(array $args)
{
$manager = MySQLEntityManager::createMaper(Periodo::class);
$periodos = $manager->where(['anio' => $args['anio']]);
if (count($periodos) == 0) {
$periodo = 1;
for ($i = 1; $i <= 12; $i++) {
$mes = $i < 10 ? "0{$i}" : $i;
$periodo1 = $manager->create(['anio' => $args['anio'], 'numero' => $periodo, 'fecha_inicial' => new \DateTime($args['anio'] . '-' . $mes . '-01'), 'fecha_final' => new \DateTime($args['anio'] . '-' . $mes . '-15')]);
$periodo++;
$periodo2 = $manager->create(['anio' => $args['anio'], 'numero' => $periodo, 'fecha_inicial' => new \DateTime($args['anio'] . '-' . $mes . '-16'), 'fecha_final' => new \DateTime($args['anio'] . '-' . $mes . '-' . date("d", mktime(0, 0, 0, $mes + 1, 1, $args['anio']) - 1))]);
$periodo++;
}
$periodos = $manager->where(['anio' => $args['anio']]);
}
return $this->responseInfo = ['body' => $periodos->toArray(), 'status' => self::STATUS_CREATED];
}
public function execute(array $args)
{
$maper = MySQLEntityManager::createMaper(SolicitudPQR::class);
$solicitudes_pqr = $maper->query('SELECT s1.* FROM solicitudes_pqr s1 ORDER BY s1.fecha');
$data = [];
foreach ($solicitudes_pqr as $solicitud) {
$s = $solicitud->toArray();
$empleado = new Empleado($solicitud->cedula_empleado);
$s['empleado'] = $empleado->getData();
array_push($data, $s);
}
if ($data) {
return $this->responseInfo = ['body' => $data, 'status' => self::STATUS_OK];
} else {
return false;
}
}
public function getCertificado(array $args)
{
if (isset($args['crt_id'])) {
// TODO: implementar metodo para la validacion de los certificados
} elseif (isset($args['e_id']) && isset($args['tipo_crt'])) {
$certificado_id = $this->getCertificadoId($args['e_id'], $args['tipo_crt']);
$certificadosMaper = MySQLEntityManager::createMaper(Certificado::class);
$certificado = $certificadosMaper->get($certificado_id);
if ($certificado) {
return $certificado;
} else {
$certificado = $certificadosMaper->create(['id' => $certificado_id, 'cedula_empleado' => $args['e_id'], 'tipo' => $args['tipo_crt']]);
return $certificado;
}
} else {
return false;
}
}
public function execute(array $args)
{
$usersMaper = MySQLEntityManager::createMaper(User::class);
$rolesMaper = MySQLEntityManager::createMaper(Rol::class);
$count_nuevos = 0;
$count_actualizados = 0;
$empleados = EmpleadosMaper::all();
$rolEmpleados = $rolesMaper->first(['nombre' => 'EMPL_ORD']);
$rolEmpleadosTemporales = $rolesMaper->first(['nombre' => 'EMPL_ORD_TEMP']);
$rolEmpleadosInactivos = $rolesMaper->first(['nombre' => 'EMPL_ORD_INACTIVO']);
foreach ($empleados as $empleado) {
$usuario = null;
if (!($usuario = $usersMaper->first(['nombre' => $empleado->cedula]))) {
$vinculacion_empleado = $empleado->vinculacion();
if ($vinculacion_empleado['CODIGO'] == '01') {
if ($empleado->estadoC() == 'R') {
$usuario = $usersMaper->build(['nombre' => $empleado->cedula, 'contrasena' => password_hash($empleado->cedula, PASSWORD_BCRYPT), 'rol_id' => $rolEmpleadosInactivos->id]);
} else {
$usuario = $usersMaper->build(['nombre' => $empleado->cedula, 'contrasena' => password_hash($empleado->cedula, PASSWORD_BCRYPT), 'rol_id' => $rolEmpleados->id]);
}
} else {
$usuario = $usersMaper->build(['nombre' => $empleado->cedula, 'contrasena' => password_hash($empleado->cedula, PASSWORD_BCRYPT), 'rol_id' => $rolEmpleadosTemporales->id]);
}
$usersMaper->save($usuario);
++$count_nuevos;
} else {
$vinculacion_empleado = $empleado->vinculacion();
if ($vinculacion_empleado['CODIGO'] == '01') {
if ($empleado->estadoC() == 'R') {
$usuario->rol_id = $rolEmpleadosInactivos->id;
} else {
$usuario->rol_id = $rolEmpleados->id;
}
} else {
$usuario->rol_id = $rolEmpleadosTemporales->id;
}
$usersMaper->save($usuario);
++$count_actualizados;
}
}
$body = ['empleados agregados' => $count_nuevos, 'empleados actualizados' => $count_actualizados, 'total_empleados' => count($empleados)];
return $this->responseInfo = ['body' => $body, 'status' => self::STATUS_CREATED];
}
public function execute(array $args)
{
$maper = MySQLEntityManager::createMaper(SolicitudPQR::class);
if (isset($args['e_id'])) {
$solicitud_pqr = $maper->where(['cedula_empleado' => $args['e_id']])->order(['fecha' => 'DESC'])->first();
$data = $solicitud_pqr ? $solicitud_pqr : $maper->build(['id' => -1, 'cedula_empleado' => $args['e_id']]);
} else {
$solicitudes_pqr = $maper->query('SELECT s1.* FROM solicitudes_pqr s1 ORDER BY s1.fecha');
$data = [];
foreach ($solicitudes_pqr as $solicitud) {
$s = $solicitud->toArray();
$s['empleado'] = new Empleado($solicitud->cedula_empleado);
array_push($data, $s);
}
}
if ($data) {
return $this->responseInfo = ['body' => $data, 'status' => self::STATUS_OK];
} else {
return false;
}
}
public function execute(array $args)
{
$manager = MySQLEntityManager::createMaper(Periodo::class);
$periodo = $manager->getActual();
return $this->responseInfo = ['body' => $periodo, 'status' => self::STATUS_CREATED];
}
public function __invoke(Request $request, Response $response, $args)
{
$decoded_jwt = $args["decoded"];
$mapper = MySQLEntityManager::createMaper(User::class);
return $mapper->checkUser($decoded_jwt->user->id, $decoded_jwt->user->nombre);
}
