SistemaMantenimiento/sistema-mantenimiento-back/app/Http/Controllers/UsersProfilesController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Facades\Hash;

class UsersProfilesController extends Controller{
    private $responseController;

    public function __construct($responseController = new ResponseController()){
        $this->responseController = $responseController;
    }
    
    public function getUsers(){
        try{
            $users = DB::table('samusua')->join('samperf', 'USUA_PERF', '=', 'PERF_IDPE')->select(
                'USUA_IDUS as IDUSUARIO',
                'USUA_NOMB as NOMBRE',
                'USUA_APPA as APEPAT',
                'USUA_APMA as APEMAT',
                'USUA_EMAI as EMAIL',
                'PERF_NOPE as PERFIL',
                'USUA_ESTA as ESTATUS',
            )->get();
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la consulta a la base.", [], 500);
        }
        
        return $this->responseController->makeresponse(false, "EXITO", $users);
    }

    public function getUser($id){
        try{
            $user = DB::table('samusua')->select(
                'USUA_IDUS as IDUSUARIO',
                'USUA_NOMB as NOMBRE',
                'USUA_APPA as APEPAT',
                'USUA_APMA as APEMAT',
                'USUA_EMAI as EMAIL',
                'USUA_PERF as PERFIL',
                'USUA_ESTA as ESTATUS'
            )->where('USUA_IDUS', '=', $id)->get()->first();
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la consulta a la base.", [], 500);
        }

        if(is_null($user)){
            return $this->responseController->makeResponse(true, "El usuario consultado no existe.", [], 404);
        }
        
        return $this->responseController->makeresponse(false, "EXITO", $user);
    }

    public function getProfiles(){
        try{
            $profiles = DB::table('samperf')->select(
                'PERF_IDPE as IDPERFIL',
                'PERF_NOPE as NOMBREPERFIL',
                'PERF_ESTA as ESTATUS',
                'PERF_PERM as PERMISOS'
            )->get();
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la consulta a la base.", [], 500);
        }
        
        return $this->responseController->makeresponse(false, "EXITO", $profiles);
    }

    public function getProfile($id){
        try{
            $profile = DB::table('samperf')->select(
                'PERF_IDPE as IDPERFIL',
                'PERF_NOPE as NOMBREPERFIL',
                'PERF_ESTA as ESTATUS',
                'PERF_PERM as PERMISOS'
            )->where('PERF_IDPE', '=', $id)->get()->first();
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la consulta a la base.", [], 500);
        }

        if(is_null($profile)){
            return $this->responseController->makeResponse(true, "El perfil consultado no existe.", [], 404);
        }
        
        return $this->responseController->makeresponse(false, "EXITO", $profile);
    }

    public function updateUser(Request $request){
        $validator = Validator::make($request->all(), [
            'id' => 'required|string',
            'name' => 'required|string|max:50',
            'fApe' => 'required|string|max:50',
            'email' => 'required|string|email',
            'perf' => 'required|integer',
        ]);

        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $user = $request->all();

        try{
            DB::table('samusua')->where('USUA_IDUS', '=', $user['id'])->update([
                'USUA_NOMB' => $user['name'],
                'USUA_APPA' => $user['fApe'],
                'USUA_APMA' => array_key_exists('sApe', $user) ? $user['sApe'] : null,
                'USUA_EMAI' => $user['email'],
                'USUA_PERF' => $user['perf']
            ]);
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la actualización del usuario.", [], 500);
        }

        return $this->responseController->makeResponse(false, "EXITO: Actualización correcta.");
    }

    public function createUser(Request $request){
        $validator = Validator::make($request->all(), [
            'name' => 'required|string|max:50',
            'fApe' => 'required|string|max:50',
            'email' => 'required|string|email',
            'perf' => 'required|integer',
            'password' => 'required|string|min:8|confirmed',
        ]);

        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $user = $request->all();

        try{
            $userVer = DB::table('samusua')->where('USUA_EMAI', '=', $user['email'])->get()->first();
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la consulta a la base.", [], 500);
        }

        if($userVer){
            return $this->responseController->makeResponse(true, "El correo electrónico ya se encuentra registrado en la base.", [], 401);
        }

        try{
            $lastID = DB::table('samusua')->orderByDesc('USUA_IDUS')->limit(1)->get()->first();
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la consulta a la base.", [], 500);
        }

        $idNum = intval(substr($lastID->USUA_IDUS, 3));
        $idNum++;

        $idUsr = "SAM";
        if($idNum < 10) $idUsr .= "00$idNum";
        else if($idNum < 100) $idUsr .= "0$idNum";
        else $idUsr .= "$idNum";

        $pass = Hash::make($user['password']);
        
        try{
            DB::table('samusua')->insert([
                'USUA_IDUS' => $idUsr,
                'USUA_NOMB' => $user['name'],
                'USUA_APPA' => $user['fApe'],
                'USUA_APMA' => array_key_exists('sApe', $user) ? $user['sApe'] : null,
                'USUA_PERF' => $user['perf'],
                'USUA_EMAI' => $user['email'],
                'USUA_CONT' => $pass,
            ]);
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la inserción del usuario a la base.", [], 500);
        }

        return $this->responseController->makeResponse(false, "EXITO: Registro correcto.");
    }

    public function blockUser(Request $request){
        $validator = Validator::make($request->all(), [
            'id' => 'required|string',
            'estatus' => 'required|in:Activo,Inactivo'
        ]);

        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $user = $request->all();

        try{
            DB::table('samusua')->where('USUA_IDUS', '=', $user['id'])->update([
                'USUA_ESTA' => $user['estatus']
            ]);
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la actualización del usuario.", [], 500);
        }

        return $this->responseController->makeResponse(false, "EXITO: Actualización correcta.");
    }

    public function updatePass(Request $request){
        $validator = Validator::make($request->all(), [
            'id' => 'required|string',
            'password' => 'required|string|min:8|confirmed',
        ]);

        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $user = $request->all();
        $newPass = Hash::make($user['password']);

        try{
            $usr = DB::table('samusua')->select('USUA_CONT')->where('USUA_IDUS', '=', $user['id'])->get()->first();
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la consulta a la base.", [], 500);
        }

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, "El usuario consultado no existe.", [], 404);
        }

        if(Hash::check($user['password'], $usr->USUA_CONT)){
            return $this->responseController->makeResponse(true, "La contraseña nueva es igual a la anterior.", [], 401);
        }

        try{
            DB::table('samusua')->where('USUA_IDUS', '=', $user['id'])->update([
                'USUA_CONT' => $newPass
            ]);
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la actualización del usuario.", [], 500);
        }

        return $this->responseController->makeResponse(false, "EXITO: Actualización correcta.");
    }

    public function deleteUser(Request $request){
        $validator = Validator::make($request->all(), [
            'id' => 'required|string',
        ]);

        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $user = $request->all();

        try{
            DB::table('samusua')->where('USUA_IDUS', '=', $user['id'])->update([
                'USUA_ESTA' => 'Eliminado'
            ]);
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la actualización del usuario.", [], 500);
        }

        return $this->responseController->makeResponse(false, "EXITO: Actualización correcta.");
    }

    public function getModules(){
        try{
            $modules = DB::table('sammodu')->select(
                'MODU_IDMO as IDMODULO',
                'MODU_NOMO as NOMBREMODULO'
            )->get();
        }catch(PDOException $e){
            return $this->responseController->makeResponse(true, "No se pudo realizar la consulta a la base.", [], 500);
        }
        
        return $this->responseController->makeresponse(false, "EXITO", $modules);
    }
}