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

<?php

namespace App\Http\Controllers;

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

use Dompdf\Dompdf;
use Illuminate\Support\Facades\Storage;
use Illuminate\Http\File;

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Style\Border;
use PhpOffice\PhpSpreadsheet\Style\Color;
use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup;
use PhpOffice\PhpSpreadsheet\Writer\Pdf\Mpdf;

class EquipmentManagementController extends Controller{
    private $responseController;
    private $encryptionController;
    private $functionsController;
    private $templatesUbic;
    private $documentManagementController;
    private $pccValidElements;
    
    public function __construct(){
        $this->responseController = new ResponseController();
        $this->encryptionController = new EncryptionController();
        $this->functionsController = new FunctionsController();
        if ($_SERVER['SERVER_NAME'] === '192.168.100.105') {
            $this->templatesUbic = "C:\ITTEC\SAM\Dev\SistemaMantenimiento\sistema-mantenimiento-back\storage\app\public\pdf_templates\\01_05_GEEQ\\";
        } else {
            $this->templatesUbic = "C:\inetpub\wwwroot\sam\storage\app\public\pdf_templates\\01_05_GEEQ\\";
        }
        $this->documentManagementController = new DocumentManagementController();

        $this->pccValidElements = [
            ['coord' => '0N',  'element' => 'PDC',                                     'code' => 'PDCXX'],
            ['coord' => '1F',  'element' => 'BAT',                                     'code' => 'BATXX'],
            ['coord' => '1I',  'element' => 'BAT',                                     'code' => 'BATXX'],
            ['coord' => '1R',  'element' => 'SAP/IHM OA',                              'code' => 'SAIOA'],
            ['coord' => '2F',  'element' => 'UPS',                                     'code' => 'UPSXX'],
            ['coord' => '2I',  'element' => 'UPS',                                     'code' => 'UPSXX'],
            ['coord' => '2R',  'element' => 'PIU/DDP',                                 'code' => 'PIUDD'],
            ['coord' => '2V',  'element' => 'ODF',                                     'code' => 'ODFXX'],
            ['coord' => '3F',  'element' => 'BAT',                                     'code' => 'BATXX'],
            ['coord' => '3I',  'element' => 'BAT',                                     'code' => 'BATXX'],
            ['coord' => '3Ñ',  'element' => 'SRV-COMMS PCC-A',                         'code' => 'SRCPA'],
            ['coord' => '3R',  'element' => 'CCTV',                                    'code' => 'CCTVX'],
            ['coord' => '4F',  'element' => 'BAT',                                     'code' => 'BATXX'],
            ['coord' => '4I',  'element' => 'BAT',                                     'code' => 'BATXX'],
            ['coord' => '4Ñ',  'element' => 'SRV-COMMS PCC-B',                         'code' => 'SRCPB'],
            ['coord' => '4R',  'element' => 'LTE',                                     'code' => 'LTEXX'],
            ['coord' => '4V',  'element' => 'AC',                                      'code' => 'ACXXX'],
            ['coord' => '5Ñ',  'element' => 'SRV-COMMS PCC-C',                         'code' => 'SRCPC'],
            ['coord' => '6F',  'element' => 'UPS',                                     'code' => 'UPSXX'],
            ['coord' => '6I',  'element' => 'UPS',                                     'code' => 'UPSXX'],
            ['coord' => '6R',  'element' => 'TEL/GDA',                                 'code' => 'TELGD'],
            ['coord' => '6V',  'element' => 'AC',                                      'code' => 'ACXXX'],
            ['coord' => '7Ñ',  'element' => 'SCADA E&M',                               'code' => 'SCAEM'],
            ['coord' => '7R',  'element' => 'CLK/CDA',                                 'code' => 'CLKCD'],
            ['coord' => '8B',  'element' => 'INTERRUPTOR ELECTROMAGNÉTICO 3x1600 AMP', 'code' => 'IE316'],
            ['coord' => '8R',  'element' => 'RMS',                                     'code' => 'RMSXX'],
            ['coord' => '9V',  'element' => 'LTE-B',                                   'code' => 'LTEBX'],
            ['coord' => '10B', 'element' => 'TRANSFORMADOR TIPO SECO 500 KVA',         'code' => 'TTS5K'],
            ['coord' => '11U', 'element' => 'ARMARIOS RECUPERACIÓN DE MANDO L1 A L6',  'code' => 'ARM16'],
            ['coord' => '11V', 'element' => 'ARMARIOS RECUPERACIÓN DE MANDO L1 A L6',  'code' => 'ARM16'],
            ['coord' => '11W', 'element' => 'MDF',                                     'code' => 'MDFXX'],
            ['coord' => '11Y', 'element' => 'ODF',                                     'code' => 'ODFXX'],
            ['coord' => '12F', 'element' => 'UPS',                                     'code' => 'UPSXX'],
            ['coord' => '12J', 'element' => 'COBRE',                                   'code' => 'COBRE'],
            ['coord' => '12L', 'element' => 'COBRE',                                   'code' => 'COBRE'],
            ['coord' => '12M', 'element' => 'COBRE',                                   'code' => 'COBRE'],
            ['coord' => '12Ñ', 'element' => 'RED',                                     'code' => 'REDXX'],
            ['coord' => '12O', 'element' => 'RED',                                     'code' => 'REDXX'],
            ['coord' => '12Q', 'element' => 'RED',                                     'code' => 'REDXX'],
            ['coord' => '13B', 'element' => 'TABLERO A',                               'code' => 'TABLA'],
            ['coord' => '14F', 'element' => 'BAT',                                     'code' => 'BATXX'],
            ['coord' => '15F', 'element' => 'UPS',                                     'code' => 'UPSXX'],
            ['coord' => '15K', 'element' => 'CCTV L1 A L6',                            'code' => 'CCT16'],
            ['coord' => '15Ñ', 'element' => 'RED C Y S L1 A L6',                       'code' => 'RCS16'],
            ['coord' => '15W', 'element' => 'TRACCIÓN',                                'code' => 'TRACC'],
            ['coord' => '16B', 'element' => 'TABLERO P',                               'code' => 'TABLP'],
            ['coord' => '16F', 'element' => 'BAT',                                     'code' => 'BATXX'],
            ['coord' => '16K', 'element' => 'CCTV L1 A L6',                            'code' => 'CCT16'],
            ['coord' => '16Ñ', 'element' => 'RED C Y S L1 A L6',                       'code' => 'RCS16'],
            ['coord' => '16W', 'element' => 'TRACCIÓN',                                'code' => 'TRACC'],
            ['coord' => '17W', 'element' => 'DISTRIBUCIÓN DE ENERGÍA L2',              'code' => 'DIEL2'],
            ['coord' => '19B', 'element' => 'TABLERO B',                               'code' => 'TABLB'],
            ['coord' => '19K', 'element' => 'TELECOM L2',                              'code' => 'TELL2'],
            ['coord' => '19Ñ', 'element' => 'SERVIDOR BASE DE DATOS L2',               'code' => 'SBDL2'],
            ['coord' => '19R', 'element' => 'SERVIDOR DE APLICACIONES L2',             'code' => 'SEAL2'],
            ['coord' => '19W', 'element' => 'DISTRIBUCIÓN DE ENERGÍA L3',              'code' => 'DIEL3'],
            ['coord' => '20F', 'element' => 'UPS',                                     'code' => 'UPSXX'],
            ['coord' => '20K', 'element' => 'TELECOM L3',                              'code' => 'TELL3'],
            ['coord' => '20Ñ', 'element' => 'SERVIDOR BASE DE DATOS L3',               'code' => 'SBDL3'],
            ['coord' => '20R', 'element' => 'SERVIDOR DE APLICACIONES L3',             'code' => 'SEAL3'],
            ['coord' => '20W', 'element' => 'DISTRIBUCIÓN DE ENERGÍA L4',              'code' => 'DIEL4'],
            ['coord' => '21B', 'element' => 'TRANSFORMADOR TIPO SECO 500 KVA',         'code' => 'TTS5K'],
            ['coord' => '21F', 'element' => 'BAT',                                     'code' => 'BATXX'],
            ['coord' => '22F', 'element' => 'UPS',                                     'code' => 'UPSXX'],
            ['coord' => '22K', 'element' => 'TELECOM L4',                              'code' => 'TELL4'],
            ['coord' => '22Ñ', 'element' => 'SERVIDOR BASE DE DATOS L4',               'code' => 'SBDL4'],
            ['coord' => '22R', 'element' => 'SERVIDOR DE APLICACIONES L4',             'code' => 'SEAL4'],
            ['coord' => '22W', 'element' => 'DISTRIBUCIÓN DE ENERGÍA L5',              'code' => 'DIEL5'],
            ['coord' => '23F', 'element' => 'BAT',                                     'code' => 'BATXX'],
            ['coord' => '23K', 'element' => 'TELECOM L5',                              'code' => 'TELL5'],
            ['coord' => '23Ñ', 'element' => 'SERVIDOR BASE DE DATOS L5',               'code' => 'SBDL5'],
            ['coord' => '23R', 'element' => 'SERVIDOR DE APLICACIONES L5',             'code' => 'SEAL5'],
            ['coord' => '24B', 'element' => 'INTERRUPTOR ELECTROMAGNÉTICO 3x1600 AMP', 'code' => 'IE316'],
            ['coord' => '24K', 'element' => 'TELECOM L6',                              'code' => 'TELL6'],
            ['coord' => '24Ñ', 'element' => 'SERVIDOR BASE DE DATOS L6',               'code' => 'SBDL6'],
            ['coord' => '24R', 'element' => 'SERVIDOR DE APLICACIONES L6',             'code' => 'SEAL6'],
            ['coord' => '24W', 'element' => 'DISTRIBUCIÓN DE ENERGÍA L6',              'code' => 'DIEL6'],
        ];
    }

    public function registerFamily(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'family_code' => 'required|string',
            'family_name' => 'required|string|max:50',
            'family_icon' => 'required|string|max:25',
            'custom_icon' => 'required|string|in:S,N',
            'icon_file' => 'required_if:custom_icon,=,S|string'
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $familyCode = $this->encryptionController->decrypt($form['family_code']);
        if(!$familyCode){
            return $this->responseController->makeResponse(true, 'El código de la familia no fue encriptado correctamente.', [], 400);
        }

        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $form['linea']],
            ['FAMI_COFA', '=', $familyCode],
        ])->get()->all();

        if(count($family) > 0){
            return $this->responseController->makeResponse(true, 'El código de la familia ya se encuentra registrado.', [], 401);
        }

        $aipe = null;
        if($form['custom_icon'] == 'S'){
            $tempFileID = $this->encryptionController->decrypt($form['icon_file']);
            if(!$tempFileID){
                return $this->responseController->makeResponse(true, 'El código del archivo temporal del icono personalizado no fue encriptado correctamente.', [], 400);
            }

            $tempFile = DB::table('S002V01TARTE')->where([
                ['ARTE_IDAR', '=', $tempFileID],
                ['ARTE_NULI', '=', $form['linea']]
            ])->first();

            if(is_null($tempFile)){
                return $this->responseController->makeResponse(true, 'El archivo temporal del icono personalizado no existe.', [], 404);
            }else if($tempFile->ARTE_ESTA == 'Eliminado'){
                return $this->responseController->makeResponse(true, 'El archivo temporal del icono personalizado está eliminado.', [], 404);
            }

            $finalFile = $this->documentManagementController->moveFinalFile($form['linea'], 'GEEQ', 'FO', $tempFile, $idUser);
            if(!$finalFile[0]){
                return $this->responseController->makeResponse(true, $finalFile[1], [], 400);
            }

            $aipe = $finalFile[1];
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        DB::table('S002V01TFAMI')->insert([
            'FAMI_NULI' => $form['linea'],
            'FAMI_COFA' => $familyCode,
            'FAMI_NOFA' => $form['family_name'],
            'FAMI_ICON' => $form['family_icon'],
            'FAMI_ICPE' => $form['custom_icon'],
            'FAMI_AIPE' => $aipe,
            'FAMI_USRE' => $idUser,
            'FAMI_FERE' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F02DFSU',
            'S002V01P02REFA',
            'Registro',
            "El usuario $name (" . $usr->USUA_IDUS . ") registró la familia $form[family_name].",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function getFamilies($idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $families = DB::table('S002V01TFAMI')->select([
            'FAMI_COFA AS CODIGOFAMILIA',
            'FAMI_NOFA AS NOMBREFAMILIA',
            'FAMI_ICON AS ICONO',
            'FAMI_ICPE AS ICONO_PERSONALIZADO',
            'FAMI_AIPE AS ARCHIVO_ICONO',
            'FAMI_ESTA AS ESTADO',
            'FAMI_USRE AS USRREG',
            'FAMI_FERE AS FECREG',
            'FAMI_USMO AS USRMOD',
            'FAMI_FEMO AS FECMOD'
        ])->where('FAMI_NULI', '=', $line)->get()->all();

        foreach($families as $key=>$val){
            $usrReg = DB::table('S002V01TUSUA')->where([
                ['USUA_NULI', '=', $line],
                ['USUA_IDUS', '=', $val->USRREG],
            ])->first();
            $nameReg = $this->functionsController->joinName($usrReg->USUA_NOMB, $usrReg->USUA_APPA, $usrReg->USUA_APMA);
            $val->USRREG = $nameReg . " (" . $val->USRREG . ")";

            if($val->USRMOD != null){
                $usrMod = DB::table('S002V01TUSUA')->where([
                    ['USUA_NULI', '=', $line],
                    ['USUA_IDUS', '=', $val->USRMOD],
                ])->first();
                $nameMod = $this->functionsController->joinName($usrMod->USUA_NOMB, $usrMod->USUA_APPA, $usrMod->USUA_APMA);
                $val->USRMOD = $nameMod . " (" . $val->USRMOD . ")";
            }

            $subfamilies = DB::table('S002V01TSUBF')->where([
                ['SUBF_NULI', '=', $line],
                ['SUBF_COFA', '=', $val->CODIGOFAMILIA],
            ])->get()->all();
            
            $val->SUBFAMILIAS = count($subfamilies);
            $val->CODIGOFAMILIA = $this->encryptionController->encrypt($val->CODIGOFAMILIA);
         
            if(!is_null($val->ARCHIVO_ICONO)){
                $val->ARCHIVO_ICONO = $this->encryptionController->encrypt($val->ARCHIVO_ICONO);
            }

            $families[$key] = $val;
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F02DFSU',
            'S002V01P01COFA',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó las familias registradas.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $families);
    }

    public function getFamily($familyCode, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $familyCode = $this->encryptionController->decrypt($familyCode);
        if(!$familyCode){
            return $this->responseController->makeResponse(true, 'El código de la familia seleccionada no está encriptado correctamente', [], 400);
        }

        $family = DB::table('S002V01TFAMI')->select([
            'FAMI_COFA AS CODIGO_FAMILIA',
            'FAMI_NOFA AS NOMBRE_FAMILIA',
            'FAMI_ICON AS ICONO',
            'FAMI_ICPE AS ICONO_PERSONALIZADO',
            'FAMI_AIPE AS ARCHIVO_ICONO',
            'FAMI_ESTA AS ESTADO',
            'FAMI_USRE AS USRREG',
            'FAMI_FERE AS FECREG',
            'FAMI_USMO AS USRMOD',
            'FAMI_FEMO AS FECMOD',
        ])->where([
            ['FAMI_NULI', '=', $line],
            ['FAMI_COFA', '=', $familyCode]
        ])->first();

        if(is_null($family)){
            return $this->responseController->makeResponse(true, 'La familia seleccionada no existe.', [], 404);
        }

        $family->CODIGO_FAMILIA = $this->encryptionController->encrypt($family->CODIGO_FAMILIA);
        if(!is_null($family->ARCHIVO_ICONO)){
            $family->ARCHIVO_ICONO = $this->encryptionController->encrypt($family->ARCHIVO_ICONO);
        }

        $usrReg = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $family->USRREG],
        ])->first();
        $nameReg = $this->functionsController->joinName($usrReg->USUA_NOMB, $usrReg->USUA_APPA, $usrReg->USUA_APMA);
        $family->USRREG = $nameReg . " (" . $family->USRREG . ")";

        if($family->USRMOD != null){
            $usrMod = DB::table('S002V01TUSUA')->where([
                ['USUA_NULI', '=', $line],
                ['USUA_IDUS', '=', $family->USRMOD],
            ])->first();
            $nameMod = $this->functionsController->joinName($usrMod->USUA_NOMB, $usrMod->USUA_APPA, $usrMod->USUA_APMA);
            $family->USRMOD = $nameMod . " (" . $family->USRMOD . ")";
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F02DFSU',
            'S002V01P01COFA',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó la familia $familyCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $family);
    }

    public function updateFamily(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'family_code' => 'required|string',
            'family_name' => 'required|string|max:50',
            'family_icon' => 'required|string|max:25',
            'custom_icon' => 'required|string|in:S,N',
            'icon_file' => 'required_if:custom_icon,=,S|string'
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $familyCode = $this->encryptionController->decrypt($form['family_code']);
        if(!$familyCode){
            return $this->responseController->makeResponse(true, 'El código de la familia no fue encriptado correctamente.', [], 400);
        }

        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $form['linea']],
            ['FAMI_COFA', '=', $familyCode],
        ])->first();
        
        if(is_null($family)){
            return $this->responseController->makeResponse(true, 'La familia que desea actualizar no existe.', [], 404);
        }else if($family->FAMI_ESTA == 'Eliminado'){
            return $this->responseController->makeResponse(true, 'La familia que desea actualizar está eliminada.', [], 404);
        }

        $aipe = null;
        if($form['custom_icon'] == 'S'){
            $tempFileID = $this->encryptionController->decrypt($form['icon_file']);
            if(!$tempFileID){
                return $this->responseController->makeResponse(true, 'El código del archivo temporal del icono personalizado no fue encriptado correctamente.', [], 400);
            }else if(str_contains($tempFileID, '=')){
                $aipe = $tempFileID;
                goto familyUpdate;
            }

            $tempFile = DB::table('S002V01TARTE')->where([
                ['ARTE_IDAR', '=', $tempFileID],
                ['ARTE_NULI', '=', $form['linea']]
            ])->first();

            if(is_null($tempFile)){
                return $this->responseController->makeResponse(true, 'El archivo temporal del icono personalizado no existe.', [], 404);
            }else if($tempFile->ARTE_ESTA == 'Eliminado'){
                return $this->responseController->makeResponse(true, 'El archivo temporal del icono personalizado está eliminado.', [], 404);
            }

            $finalFile = $this->documentManagementController->moveFinalFile($form['linea'], 'GEEQ', 'FO', $tempFile, $idUser);
            if(!$finalFile[0]){
                return $this->responseController->makeResponse(true, $finalFile[1], [], 400);
            }

            $aipe = $finalFile[1];
        }
        
        familyUpdate:
        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $form['linea']],
            ['FAMI_COFA', '=', $familyCode],
        ])->update([
            'FAMI_NOFA' => $form['family_name'],
            'FAMI_ICON' => $form['family_icon'],
            'FAMI_ICPE' => $form['custom_icon'],
            'FAMI_AIPE' => $aipe,
            'FAMI_USMO' => $idUser,
            'FAMI_FEMO' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F02DFSU',
            'S002V01P02REFA',
            'Actualización',
            "El usuario $name (" . $usr->USUA_IDUS . ") actualizó la familia $familyCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function deleteFamily(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'family_code' => 'required|string',
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $familyCode = $this->encryptionController->decrypt($form['family_code']);
        if(!$familyCode){
            return $this->responseController->makeResponse(true, 'El código de la familia no fue encriptado correctamente.', [], 400);
        }

        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $form['linea']],
            ['FAMI_COFA', '=', $familyCode],
        ])->first();
        
        if(is_null($family)){
            return $this->responseController->makeResponse(true, 'La familia que desea eliminar no existe.', [], 404);
        }else if($family->FAMI_ESTA == 'Eliminado'){
            return $this->responseController->makeResponse(true, 'La familia que desea eliminar está eliminada.', [], 404);
        }
        
        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $form['linea']],
            ['FAMI_COFA', '=', $familyCode],
        ])->update([
            'FAMI_ESTA' => 'Eliminado',
            'FAMI_USMO' => $idUser,
            'FAMI_FEMO' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F02DFSU',
            'S002V01P02REFA',
            'Eliminación',
            "El usuario $name (" . $usr->USUA_IDUS . ") eliminó la familia $familyCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function registerSubfamily(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'family_code' => 'required|string',
            'subfamily_code' => 'required|string',
            'subfamily_name' => 'required|string|max:50',
            'subfamily_icon' => 'required|string|max:25',
            'custom_icon' => 'required|string|in:S,N',
            'icon_file' => 'required_if:custom_icon,=,S|string'
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $familyCode = $this->encryptionController->decrypt($form['family_code']);
        if(!$familyCode){
            return $this->responseController->makeResponse(true, 'El código de la familia relacionada no fue encriptado correctamente.', [], 400);
        }

        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $form['linea']],
            ['FAMI_COFA', '=', $familyCode],
        ])->first();
        
        if(is_null($family)){
            return $this->responseController->makeResponse(true, 'La familia relacionada no existe.', [], 404);
        }else if($family->FAMI_ESTA == 'Eliminado'){
            return $this->responseController->makeResponse(true, 'La familia relacionada está eliminada.', [], 404);
        }

        $subfamilyCode = $this->encryptionController->decrypt($form['subfamily_code']);
        if(!$subfamilyCode){
            return $this->responseController->makeResponse(true, 'El código de la subfamilia no fue encriptado correctamente.', [], 400);
        }

        $subfamily = DB::table('S002V01TSUBF')->where([
            ['SUBF_NULI', '=', $form['linea']],
            ['SUBF_COFA', '=', $familyCode],
            ['SUBF_COSU', '=', $subfamilyCode],
        ])->get()->all();

        if(count($subfamily) > 0){
            return $this->responseController->makeResponse(true, 'El código de la subfamilia ya se encuentra registrado.', [], 401);
        }

        $aipe = null;
        if($form['custom_icon'] == 'S'){
            $tempFileID = $this->encryptionController->decrypt($form['icon_file']);
            if(!$tempFileID){
                return $this->responseController->makeResponse(true, 'El código del archivo temporal del icono personalizado no fue encriptado correctamente.', [], 400);
            }

            $tempFile = DB::table('S002V01TARTE')->where([
                ['ARTE_IDAR', '=', $tempFileID],
                ['ARTE_NULI', '=', $form['linea']]
            ])->first();

            if(is_null($tempFile)){
                return $this->responseController->makeResponse(true, 'El archivo temporal del icono personalizado no existe.', [], 404);
            }else if($tempFile->ARTE_ESTA == 'Eliminado'){
                return $this->responseController->makeResponse(true, 'El archivo temporal del icono personalizado está eliminado.', [], 404);
            }

            $finalFile = $this->documentManagementController->moveFinalFile($form['linea'], 'GEEQ', 'FO', $tempFile, $idUser);
            if(!$finalFile[0]){
                return $this->responseController->makeResponse(true, $finalFile[1], [], 400);
            }

            $aipe = $finalFile[1];
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        DB::table('S002V01TSUBF')->insert([
            'SUBF_NULI' => $form['linea'],
            'SUBF_COFA' => $familyCode,
            'SUBF_COSU' => $subfamilyCode,
            'SUBF_NOSU' => $form['subfamily_name'],
            'SUBF_ICON' => $form['subfamily_icon'],
            'SUBF_ICPE' => $form['custom_icon'],
            'SUBF_AIPE' => $aipe,
            'SUBF_USRE' => $idUser,
            'SUBF_FERE' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F02DFSU',
            'S002V01P04RESU',
            'Registro',
            "El usuario $name (" . $usr->USUA_IDUS . ") registró la subfamilia $form[subfamily_name].",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function getSubfamilies($familyCode, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $familyCode = $this->encryptionController->decrypt($familyCode);
        if(!$familyCode){
            return $this->responseController->makeResponse(true, 'El código de la familia relacionada no fue encriptado correctamente.', [], 400);
        }

        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $line],
            ['FAMI_COFA', '=', $familyCode],
        ])->first();
        
        if(is_null($family)){
            return $this->responseController->makeResponse(true, 'La familia relacionada no existe.', [], 404);
        }else if($family->FAMI_ESTA == 'Eliminado'){
            return $this->responseController->makeResponse(true, 'La familia relacionada está eliminada.', [], 404);
        }

        $subfamilies = DB::table('S002V01TSUBF')->select([
            'SUBF_COFA AS CODIGOFAMILIA',
            'SUBF_COSU AS CODIGOSUBFAMILIA',
            'SUBF_NOSU AS NOMBRESUBFAMILIA',
            'SUBF_ICON AS ICONO',
            'SUBF_ICPE AS ICONO_PERSONALIZADO',
            'SUBF_AIPE AS ARCHIVO_ICONO',
            'SUBF_ESTA AS ESTADO',
            'SUBF_USRE AS USRREG',
            'SUBF_FERE AS FECREG',
            'SUBF_USMO AS USRMOD',
            'SUBF_FEMO AS FECMOD'
        ])->where([
            ['SUBF_NULI', '=', $line],
            ['SUBF_COFA', '=', $familyCode],
        ])->get()->all();

        foreach($subfamilies as $key=>$val){
            $val->CODIGOFAMILIA = $this->encryptionController->encrypt($val->CODIGOFAMILIA);
            $val->CODIGOSUBFAMILIA = $this->encryptionController->encrypt($val->CODIGOSUBFAMILIA);
            if(!is_null($val->ARCHIVO_ICONO)){
                $val->ARCHIVO_ICONO = $this->encryptionController->encrypt($val->ARCHIVO_ICONO);
            }

            $usrReg = DB::table('S002V01TUSUA')->where([
                ['USUA_NULI', '=', $line],
                ['USUA_IDUS', '=', $val->USRREG],
            ])->first();
            $nameReg = $this->functionsController->joinName($usrReg->USUA_NOMB, $usrReg->USUA_APPA, $usrReg->USUA_APMA);
            $val->USRREG = $nameReg . " (" . $val->USRREG . ")";

            if($val->USRMOD != null){
                $usrMod = DB::table('S002V01TUSUA')->where([
                    ['USUA_NULI', '=', $line],
                    ['USUA_IDUS', '=', $val->USRMOD],
                ])->first();
                $nameMod = $this->functionsController->joinName($usrMod->USUA_NOMB, $usrMod->USUA_APPA, $usrMod->USUA_APMA);
                $val->USRMOD = $nameMod . " (" . $val->USRMOD . ")";
            }
            
            $families[$key] = $val;
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F02DFSU',
            'S002V01P03COSU',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó las subfamilias relacionadas a la familia $familyCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $subfamilies);
    }

    public function updateSubfamily(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'family_code' => 'required|string',
            'subfamily_code' => 'required|string',
            'subfamily_name' => 'required|string|max:50',
            'subfamily_icon' => 'required|string|max:25',
            'custom_icon' => 'required|string|in:S,N',
            'icon_file' => 'required_if:custom_icon,=,S|string'
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $familyCode = $this->encryptionController->decrypt($form['family_code']);
        if(!$familyCode){
            return $this->responseController->makeResponse(true, 'El código de la familia relacionada no fue encriptado correctamente.', [], 400);
        }

        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $form['linea']],
            ['FAMI_COFA', '=', $familyCode],
        ])->first();
        
        if(is_null($family)){
            return $this->responseController->makeResponse(true, 'La familia relacionada no existe.', [], 404);
        }else if($family->FAMI_ESTA == 'Eliminado'){
            return $this->responseController->makeResponse(true, 'La familia relacionada está eliminada.', [], 404);
        }

        $subfamilyCode = $this->encryptionController->decrypt($form['subfamily_code']);
        if(!$subfamilyCode){
            return $this->responseController->makeResponse(true, 'El código de la subfamilia no fue encriptado correctamente.', [], 400);
        }

        $subfamily = DB::table('S002V01TSUBF')->where([
            ['SUBF_NULI', '=', $form['linea']],
            ['SUBF_COFA', '=', $familyCode],
            ['SUBF_COSU', '=', $subfamilyCode],
        ])->first();
        
        if(is_null($subfamily)){
            return $this->responseController->makeResponse(true, 'La subfamilia que desea actualizar no existe.', [], 404);
        }else if($subfamily->SUBF_ESTA == 'Eliminado'){
            return $this->responseController->makeResponse(true, 'La subfamilia que desea actualizar está eliminada.', [], 404);
        }

        $aipe = null;
        if($form['custom_icon'] == 'S'){
            $tempFileID = $this->encryptionController->decrypt($form['icon_file']);
            if(!$tempFileID){
                return $this->responseController->makeResponse(true, 'El código del archivo temporal del icono personalizado no fue encriptado correctamente.', [], 400);
            }else if(str_contains($tempFileID, '=')){
                $aipe = $tempFileID;
                goto subfamilyUpdate;
            }

            $tempFile = DB::table('S002V01TARTE')->where([
                ['ARTE_IDAR', '=', $tempFileID],
                ['ARTE_NULI', '=', $form['linea']]
            ])->first();

            if(is_null($tempFile)){
                return $this->responseController->makeResponse(true, 'El archivo temporal del icono personalizado no existe.', [], 404);
            }else if($tempFile->ARTE_ESTA == 'Eliminado'){
                return $this->responseController->makeResponse(true, 'El archivo temporal del icono personalizado está eliminado.', [], 404);
            }

            $finalFile = $this->documentManagementController->moveFinalFile($form['linea'], 'GEEQ', 'FO', $tempFile, $idUser);
            if(!$finalFile[0]){
                return $this->responseController->makeResponse(true, $finalFile[1], [], 400);
            }

            $aipe = $finalFile[1];
        }
        
        subfamilyUpdate:
        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        DB::table('S002V01TSUBF')->where([
            'SUBF_NULI' => $form['linea'],
            'SUBF_COFA' => $familyCode,
            'SUBF_COSU' => $subfamilyCode,
        ])->update([
            'SUBF_NOSU' => $form['subfamily_name'],
            'SUBF_ICON' => $form['subfamily_icon'],
            'SUBF_ICPE' => $form['custom_icon'],
            'SUBF_AIPE' => $aipe,
            'SUBF_USMO' => $idUser,
            'SUBF_FEMO' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F02DFSU',
            'S002V01P04RESU',
            'Actualización',
            "El usuario $name (" . $usr->USUA_IDUS . ") actualizó la subfamilia $subfamilyCode de la familia $familyCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function deleteSubfamily(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'family_code' => 'required|string',
            'subfamily_code' => 'required|string',
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $familyCode = $this->encryptionController->decrypt($form['family_code']);
        if(!$familyCode){
            return $this->responseController->makeResponse(true, 'El código de la familia relacionada no fue encriptado correctamente.', [], 400);
        }

        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $form['linea']],
            ['FAMI_COFA', '=', $familyCode],
        ])->first();
        
        if(is_null($family)){
            return $this->responseController->makeResponse(true, 'La familia relacionada no existe.', [], 404);
        }else if($family->FAMI_ESTA == 'Eliminado'){
            return $this->responseController->makeResponse(true, 'La familia relacionada está eliminada.', [], 404);
        }

        $subfamilyCode = $this->encryptionController->decrypt($form['subfamily_code']);
        if(!$subfamilyCode){
            return $this->responseController->makeResponse(true, 'El código de la subfamilia no fue encriptado correctamente.', [], 400);
        }

        $subfamily = DB::table('S002V01TSUBF')->where([
            ['SUBF_NULI', '=', $form['linea']],
            ['SUBF_COFA', '=', $familyCode],
            ['SUBF_COSU', '=', $subfamilyCode],
        ])->first();
        
        if(is_null($subfamily)){
            return $this->responseController->makeResponse(true, 'La subfamilia que desea eliminar no existe.', [], 404);
        }else if($subfamily->SUBF_ESTA == 'Eliminado'){
            return $this->responseController->makeResponse(true, 'La subfamilia que desea eliminar está eliminada.', [], 404);
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        DB::table('S002V01TSUBF')->where([
            'SUBF_NULI' => $form['linea'],
            'SUBF_COFA' => $familyCode,
            'SUBF_COSU' => $subfamilyCode,
        ])->update([
            'SUBF_ESTA' => 'Eliminado',
            'SUBF_USMO' => $idUser,
            'SUBF_FEMO' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F02DFSU',
            'S002V01P04RESU',
            'Eliminación',
            "El usuario $name (" . $usr->USUA_IDUS . ") eliminó la subfamilia $subfamilyCode de la familia $familyCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function getLocations($idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $locationsEnc = file_get_contents($ubic . "locations.sam");
        $locationsDec = $this->encryptionController->decrypt($locationsEnc);
        $locationsArr = json_decode($locationsDec, true);

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó el arreglo de ubicaciones de la línea.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $locationsArr);
    }

    public function getOccupationAreas($idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $occupationAreasEnc = file_get_contents($ubic . "occupation-areas.sam");
        $occupationAreasDec = $this->encryptionController->decrypt($occupationAreasEnc);
        $occupationAreasArr = json_decode($occupationAreasDec, true);

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó las áreas de ocupación.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $occupationAreasArr);
    }

    public function registerOccupation(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'area' => 'required|string',
            'description' => 'required|string|min:15|max:150',
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $occupationAreasEnc = file_get_contents($ubic . "occupation-areas.sam");
        $occupationAreasDec = $this->encryptionController->decrypt($occupationAreasEnc);
        $occupationAreasArr = json_decode($occupationAreasDec, true);
        $occupationAreasArrDec = [];

        foreach($occupationAreasArr as $area){
            $occupationAreasArrDec[] = [
                'CODE' => $this->encryptionController->decrypt($area['CODE']),
                'AREA' => $this->encryptionController->decrypt($area['AREA'])
            ];
        }

        $areaCode = $this->encryptionController->decrypt($form['area']);
        if(!$areaCode){
            return $this->responseController->makeResponse(true, 'El área de ocupación no fue encriptada correctamente.', [], 400);
        }

        $areaCodeExists = array_filter($occupationAreasArrDec, function($v, $k) use ($areaCode) {
            return $v['CODE'] == $areaCode;
        }, ARRAY_FILTER_USE_BOTH);
        
        if(count($areaCodeExists) < 1){
            return $this->responseController->makeResponse(true, 'El área de ocupación seleccionada no existe.', [], 400);
        }
        
        $areaName = end($areaCodeExists)['AREA'] . " ($areaCode)";
        $lastOccupationByArea = DB::table('S002V01TOCUP')->where([
            ['OCUP_NULI', '=', $form['linea']],
            ['OCUP_AREA', '=', $areaCode]
        ])->orderBy('OCUP_IDOC', 'desc')->first();

        $id = 0;
        if(is_null($lastOccupationByArea)){
            $id = 1;
        }else{
            $id = $lastOccupationByArea->OCUP_IDOC + 1;
        }

        if($id > 999){
            return $this->responseController->makeResponse(true, "El área $areaName llegó al límite de 999 elementos.", [], 401);
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        DB::table('S002V01TOCUP')->insert([
            'OCUP_NULI' => $form['linea'],
            'OCUP_AREA' => $areaCode,
            'OCUP_IDOC' => $id,
            'OCUP_DESC' => $form['description'],
            'OCUP_USRE' => $idUser,
            'OCUP_FERE' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Registro',
            "El usuario $name (" . $usr->USUA_IDUS . ") registró una nueva ocupación para el área $areaName.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function getOccupations($idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $occupationAreasEnc = file_get_contents($ubic . "occupation-areas.sam");
        $occupationAreasDec = $this->encryptionController->decrypt($occupationAreasEnc);
        $occupationAreasArr = json_decode($occupationAreasDec, true);
        $occupationAreasArrDec = [];

        foreach($occupationAreasArr as $area){
            $occupationAreasArrDec[] = [
                'CODE' => $this->encryptionController->decrypt($area['CODE']),
                'AREA' => $this->encryptionController->decrypt($area['AREA'])
            ];
        }

        $occupations = DB::table('S002V01TOCUP')->where('OCUP_NULI', '=', $line)->get()->all();
        $occupationsFn = [];
        foreach($occupations as $occupation){
            $areaInd = $occupation->OCUP_AREA;
            $areaStr = $areaInd < 10 ? "0$areaInd" : "$areaInd";
            $area = array_filter($occupationAreasArrDec, function($v, $k) use ($areaStr) {
                return $v['CODE'] == $areaStr;
            }, ARRAY_FILTER_USE_BOTH);
            $areaName = end($area)['AREA'] . " (" . end($area)['CODE'] . ")";

            $occupationInd = "" . $occupation->OCUP_IDOC . "";
            $occupationStr = "";
            for($i = strlen($occupationInd); $i < 3; $i++){
                $occupationStr .= '0';
            }

            $usrReg = DB::table('S002V01TUSUA')->where([
                ['USUA_NULI', '=', $line],
                ['USUA_IDUS', '=', $occupation->OCUP_USRE],
            ])->first();
            $usrRegName = $this->functionsController->joinName($usrReg->USUA_NOMB, $usrReg->USUA_APPA, $usrReg->USUA_APMA) . " (" .  $occupation->OCUP_USRE . ")";

            $usrModName = null;
            if($occupation->OCUP_USMO != null){
                $usrMod = DB::table('S002V01TUSUA')->where([
                    ['USUA_NULI', '=', $line],
                    ['USUA_IDUS', '=', $occupation->OCUP_USMO],
                ])->first();
                $usrModName = $this->functionsController->joinName($usrMod->USUA_NOMB, $usrMod->USUA_APPA, $usrMod->USUA_APMA) . " (" .  $occupation->OCUP_USMO . ")";
            }

            $occupationStr = $areaStr . $occupationStr . $occupationInd;
            $occupationsFn[] = [
                "NOMBREAREA" => $areaName,
                "OCUPACION" => $occupationStr,
                "DESCRIPCION" => $occupation->OCUP_DESC,
                "ESTADO" => $occupation->OCUP_ESTA,
                "USRREG" => $usrRegName,
                "FECREG" => $occupation->OCUP_FERE,
                "USRMOD" => $usrModName,
                "FECMOD" => $occupation->OCUP_FEMO,
            ];
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó las ocupaciones registradas.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $occupationsFn);
    }

    public function updateOccupation(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'area' => 'required|string',
            'occupation' => 'required|string',
            'description' => 'required|string|min:15|max:150',
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $occupationAreasEnc = file_get_contents($ubic . "occupation-areas.sam");
        $occupationAreasDec = $this->encryptionController->decrypt($occupationAreasEnc);
        $occupationAreasArr = json_decode($occupationAreasDec, true);
        $occupationAreasArrDec = [];

        foreach($occupationAreasArr as $area){
            $occupationAreasArrDec[] = [
                'CODE' => $this->encryptionController->decrypt($area['CODE']),
                'AREA' => $this->encryptionController->decrypt($area['AREA'])
            ];
        }

        $areaCode = $this->encryptionController->decrypt($form['area']);
        if(!$areaCode){
            return $this->responseController->makeResponse(true, 'El área de ocupación no fue encriptada correctamente.', [], 400);
        }

        $areaCodeExists = array_filter($occupationAreasArrDec, function($v, $k) use ($areaCode) {
            return $v['CODE'] == $areaCode;
        }, ARRAY_FILTER_USE_BOTH);
        
        if(count($areaCodeExists) < 1){
            return $this->responseController->makeResponse(true, 'El área de ocupación relacionada no existe.', [], 400);
        }

        $occupation = $this->encryptionController->decrypt($form['occupation']);
        if(!$occupation){
            return $this->responseController->makeResponse(true, 'La ocupación no fue encriptada correctamente.', [], 400);
        }

        $occupationID = substr($occupation, 2);
        $occupationObj = DB::table('S002V01TOCUP')->where([
            ['OCUP_NULI', '=', $form['linea']],
            ['OCUP_AREA', '=', $areaCode],
            ['OCUP_IDOC', '=', $occupationID],
        ])->first();
        
        if(is_null($occupationObj)){
            return $this->responseController->makeResponse(true, 'La ocupación que desea actualizar no existe.', [], 404);
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        DB::table('S002V01TOCUP')->where([
            ['OCUP_NULI', '=', $form['linea']],
            ['OCUP_AREA', '=', $areaCode],
            ['OCUP_IDOC', '=', $occupationID],
        ])->update([
            'OCUP_DESC' => $form['description'],
            'OCUP_USMO' => $idUser,
            'OCUP_FEMO' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Actualización',
            "El usuario $name (" . $usr->USUA_IDUS . ") actualizó la ocupación $occupation.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function deleteOccupation(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'area' => 'required|string',
            'occupation' => 'required|string',
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $occupationAreasEnc = file_get_contents($ubic . "occupation-areas.sam");
        $occupationAreasDec = $this->encryptionController->decrypt($occupationAreasEnc);
        $occupationAreasArr = json_decode($occupationAreasDec, true);
        $occupationAreasArrDec = [];

        foreach($occupationAreasArr as $area){
            $occupationAreasArrDec[] = [
                'CODE' => $this->encryptionController->decrypt($area['CODE']),
                'AREA' => $this->encryptionController->decrypt($area['AREA'])
            ];
        }

        $areaCode = $this->encryptionController->decrypt($form['area']);
        if(!$areaCode){
            return $this->responseController->makeResponse(true, 'El área de ocupación no fue encriptada correctamente.', [], 400);
        }

        $areaCodeExists = array_filter($occupationAreasArrDec, function($v, $k) use ($areaCode) {
            return $v['CODE'] == $areaCode;
        }, ARRAY_FILTER_USE_BOTH);
        
        if(count($areaCodeExists) < 1){
            return $this->responseController->makeResponse(true, 'El área de ocupación relacionada no existe.', [], 400);
        }

        $occupation = $this->encryptionController->decrypt($form['occupation']);
        if(!$occupation){
            return $this->responseController->makeResponse(true, 'La ocupación no fue encriptada correctamente.', [], 400);
        }

        $occupationID = substr($occupation, 2);
        $occupationObj = DB::table('S002V01TOCUP')->where([
            ['OCUP_NULI', '=', $form['linea']],
            ['OCUP_AREA', '=', $areaCode],
            ['OCUP_IDOC', '=', $occupationID],
        ])->first();
        
        if(is_null($occupationObj)){
            return $this->responseController->makeResponse(true, 'La ocupación que desea eliminar no existe.', [], 404);
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        DB::table('S002V01TOCUP')->where([
            ['OCUP_NULI', '=', $form['linea']],
            ['OCUP_AREA', '=', $areaCode],
            ['OCUP_IDOC', '=', $occupationID],
        ])->update([
            'OCUP_ESTA' => 'Eliminado',
            'OCUP_USMO' => $idUser,
            'OCUP_FEMO' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Eliminación',
            "El usuario $name (" . $usr->USUA_IDUS . ") eliminó la ocupación $occupation.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function saveEquipmentPreCodified(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'hierarchy' => 'required|string|in:Padre,Hijo',
            'parent_equipment' => 'required_if:hierarchy,=,Hijo|string',
            'code_type' => 'required|integer|between:1,6',
            'origin_location' => 'required|string',
            'origin_level' => 'required|string',
            'origin_occupation' => 'required|string',
            'origin_element' => 'required_unless:code_type,4|string',
            'origin_element_enc' => 'required_if:code_type,=,4|string',
            'family' => 'required|string',
            'subfamily' => 'required|string',
            'status' => 'required|string',
            'equipment_type' => 'required|string|max:150',
            'equipment_model' => 'required|string|max:75',
            'images' => 'required|json',
            'documents' => 'required|json',
            'acquisition_date' => 'required|date',
            'warranty_start_date' => 'required|date',
            'warranty_end_date' => 'required|date',
            'equipment_provider' => 'required|string',
            'serial_number' => 'required|string|max:150',
            'has_software' => 'required|string|in:Si,No',
            'software_name' => 'required_if:has_software,=,Si|string|max:150',
            'software_version' => 'required_if:has_software,=,Si|string|max:75',
            'pre_generated_code' => 'required|string',
            'pcc_intersection' => 'required_if:code_type,=,2|string|max:5',
            'pcc_position' => 'required_if:code_type,=,2|string|max:2',
            'origin_kilometer' => 'required_if:code_type,=,3|numeric',
            'origin_code_type' => 'required_if:code_type,=,6|numeric|between:1,5',
            'origin_kilometer' => 'required_if:origin_code_type,=,3|numeric',
            'train_area' => 'required_if:code_type,=,5|string',
            'destiny_location' => 'required_if:code_type,=,3|string',
            'destiny_level' => 'required_if:code_type,=,3|string',
            'destiny_occupation' => 'required_if:code_type,=,3|string',
            'destiny_element' => 'required_if:code_type,=,3|string|max:150',
            'destiny_element' => 'required_if:code_type,=,6|string',
            'destiny_element_enc' => 'required_if:code_type,=,4|string',
            'destiny_kilometer' => 'required_if:code_type,=,3|string',
            'destiny_location' => 'required_if:code_type,=,4|string',
            'destiny_level' => 'required_if:code_type,=,4|string',
            'destiny_occupation' => 'required_if:code_type,=,4|string',
            'destiny_code_type' => 'required_if:code_type,=,6|numeric|between:1,5',
            'destiny_kilometer' => 'required_if:destiny_code_type,=,3|numeric',
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $eqpa = null;
        if($form['hierarchy'] == 'Hijo'){
            $eqpa = $this->encryptionController->decrypt($form['parent_equipment']);
            if(!$eqpa){
                return $this->responseController->makeResponse(true, 'El ID del equipamiento padre no fue encriptado correctamente.', [], 400);
            }

            $parentEquipment = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $form['linea']],
                ['EQUI_COEQ', '=', $eqpa],
            ])->first();
        
            if(is_null($parentEquipment)){
                return $this->responseController->makeResponse(true, 'El equipamiento padre no existe.', [], 404);
            }
        }

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $locationsEnc = file_get_contents($ubic . "locations.sam");
        $locationsDec = $this->encryptionController->decrypt($locationsEnc);
        $locationsArr = json_decode($locationsDec, true);
        $locationsArrDec = [];
        foreach($locationsArr as $location){
            $locationStr = $this->encryptionController->decrypt($location['LOCATION']);
            $code = $this->encryptionController->decrypt($location['CODE']);

            $locationsArrDec[] = [
                'LOCATION' => $locationStr,
                'CODE' => $code
            ];
        }

        $originLocation = $this->encryptionController->decrypt($form['origin_location']);
        if(!$originLocation){
            return $this->responseController->makeResponse(true, 'La ubicación de origen no fue encriptada correctamente.', [], 400);
        }

        $originLocationFilt = array_filter($locationsArrDec, function($v, $k) use ($originLocation) {
            return $v['CODE'] == $originLocation;
        }, ARRAY_FILTER_USE_BOTH);

        if(count($originLocationFilt) < 1){
            return $this->responseController->makeResponse(true, 'La ubicación de origen no se encuentra registrada en el sistema.', [], 404);
        }

        $destinyLocation = null;
        if(isset($form['destiny_location'])){
            $destinyLocation = $this->encryptionController->decrypt($form['destiny_location']);
            if(!$destinyLocation){
                return $this->responseController->makeResponse(true, 'La ubicación de destino no fue encriptada correctamente.', [], 400);
            }

            $destinyLocationFilt = array_filter($locationsArrDec, function($v, $k) use ($destinyLocation) {
                return $v['CODE'] == $destinyLocation;
            }, ARRAY_FILTER_USE_BOTH);

            if(count($destinyLocationFilt) < 1){
                return $this->responseController->makeResponse(true, 'La ubicación de destino no se encuentra registrada en el sistema.', [], 404);
            }
        }

        $originLevel = $this->encryptionController->decrypt($form['origin_level']);
        if(!$originLevel){
            return $this->responseController->makeResponse(true, 'El nivel de origen no fue encriptado correctamente.', [], 400);
        }

        $supportedLevels = [];
        for($i = 5; $i > 0; $i--){
            $supportedLevels[] = "S0$i";
        }

        for($i = 0; $i <= 15; $i++){
            $tag = $i < 10 ? "P0$i" : "P$i";
            $supportedLevels[] = $tag;
        }

        if(!in_array($originLevel, $supportedLevels)){
            return $this->responseController->makeResponse(true, 'El nivel de origen seleccionado es inválido.', [], 400);
        }

        $destinyLevel = null;
        if(isset($form['destiny_level'])){
            $destinyLevel = $this->encryptionController->decrypt($form['destiny_level']);

            if(!in_array($destinyLevel, $supportedLevels)){
                return $this->responseController->makeResponse(true, 'El nivel de destino seleccionado es inválido.', [], 400);
            }
        }

        $originOccupationStr = $this->encryptionController->decrypt($form['origin_occupation']);
        if(!$originOccupationStr){
            return $this->responseController->makeResponse(true, 'La ocupación de origen no fue encriptada correctamente.', [], 400);
        }

        if($form['code_type'] == '5'){
            $trainOccupationsEnc = file_get_contents($ubic . "train-occupations.sam");
            $trainOccupationsDec = $this->encryptionController->decrypt($trainOccupationsEnc);
            $trainOccupationsArr = json_decode($trainOccupationsDec, true);

            foreach($trainOccupationsArr as $k0=>$v0){
                $trainOccupation = [];
                foreach($v0 as $k1=>$v1){
                    $valDec = $this->encryptionController->decrypt($v1);
                    $trainOccupation[$k1] = $valDec;
                }

                $trainOccupationsArr[$k0] = $trainOccupation;
            }

            $occupationFilt = array_filter($trainOccupationsArr, function($v, $k) use ($originOccupationStr) {
                return $v['CODE'] == $originOccupationStr;
            }, ARRAY_FILTER_USE_BOTH);

            if(count($occupationFilt) < 1){
                return $this->responseController->makeResponse(true, 'La ocupación de origen seleccionada no existe.', [], 404);
            }
        }else{
            $originOccupationArea = substr($originOccupationStr, 0, 2);
            $originOccupationID = substr($originOccupationStr, 2);
            $originOccupation = DB::table('S002V01TOCUP')->where([
                ['OCUP_NULI', '=', $form['linea']],
                ['OCUP_AREA', '=', $originOccupationArea],
                ['OCUP_IDOC', '=', $originOccupationID]
            ])->first();
   
            if(is_null($originOccupation)){
                return $this->responseController->makeResponse(true, 'La ocupación de origen seleccionada no existe.', [], 404);
            }
        }

        $destinyOccupationStr = null;
        if(isset($form['destiny_occupation'])){
            $destinyOccupationStr = $this->encryptionController->decrypt($form['destiny_occupation']);
            if(!$destinyOccupationStr){
                return $this->responseController->makeResponse(true, 'La ocupación de destino no fue encriptada correctamente.', [], 400);
            }

            $destinyOccupationArea = substr($destinyOccupationStr, 0, 2);
            $destinyOccupationID = substr($destinyOccupationStr, 2);
            $destinyOccupation = DB::table('S002V01TOCUP')->where([
                ['OCUP_NULI', '=', $form['linea']],
                ['OCUP_AREA', '=', $destinyOccupationArea],
                ['OCUP_IDOC', '=', $destinyOccupationID]
            ])->first();

            if(is_null($destinyOccupation)){
                return $this->responseController->makeResponse(true, 'La ocupación de destino seleccionada no existe.', [], 404);
            }
        }

        $familyCode = $this->encryptionController->decrypt($form['family']);
        if(!$familyCode){
            return $this->responseController->makeResponse(true, 'La familia del equipamiento no fue encriptada correctamente.', [], 400);
        }

        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $form['linea']],
            ['FAMI_COFA', '=', $familyCode]
        ])->first();

        if(is_null($family)){
            return $this->responseController->makeResponse(true, 'La familia seleccionada no existe.', [], 404);
        }

        $subfamilyCode = $this->encryptionController->decrypt($form['subfamily']);
        if(!$subfamilyCode){
            return $this->responseController->makeResponse(true, 'La subfamilia del equipamiento no fue encriptada correctamente.', [], 400);
        }

        $subfamily = DB::table('S002V01TSUBF')->where([
            ['SUBF_NULI', '=', $form['linea']],
            ['SUBF_COFA', '=', $familyCode],
            ['SUBF_COSU', '=', $subfamilyCode]
        ])->first();

        if(is_null($subfamily)){
            return $this->responseController->makeResponse(true, 'La subfamilia seleccionada no existe.', [], 404);
        }

        $validStatus = ["A", "S", "T", "I", "R", "D"];
        $status = $this->encryptionController->decrypt($form['status']);
        if(!$status){
            return $this->responseController->makeResponse(true, 'La estado del equipamiento no fue encriptado correctamente.', [], 400);
        }else if(!in_array($status, $validStatus)){
            return $this->responseController->makeResponse(true, 'El estado seleccionado para el equipamiento es inválido.', [], 400);
        }

        $imagesArr = json_decode($form['images'], true);
        if(count($imagesArr) < 1){
            return $this->responseController->makeResponse(true, 'El arreglo de la galería de imágenes está vacío.', [], 400);
        }

        $imagesGallery = [];
        foreach($imagesArr as $imageFile){
            if(!array_key_exists('type', $imageFile)){
                return $this->responseController->makeResponse(true, 'El arreglo de la galería de imágenes tiene un formato inválido.', [], 400);
            }else if($imageFile['type'] == 'Nuevo'){
                $tempFileID = $this->encryptionController->decrypt($imageFile['id']);
                $tempFile = DB::table('S002V01TARTE')->where([
                    ['ARTE_IDAR', '=', $tempFileID],
                    ['ARTE_NULI', '=', $form['linea']]
                ])->first();

                $finalFile = $this->documentManagementController->moveFinalFile($form['linea'], 'GEEQ', 'FO', $tempFile, $idUser);
                if(!$finalFile[0]){
                    return $this->responseController->makeResponse(true, $finalFile[1], [], 400);
                }

                $imagesGallery[] = $finalFile[1];
            }else{
                $fileID = $this->encryptionController->decrypt($imageFile['id']);
                $imagesGallery[] = $fileID;
            }
        }

        $imagesGalleryStr = json_encode($imagesGallery);
        $documentsArr = json_decode($form['documents'], true);
        if(count($documentsArr) < 1){
            return $this->responseController->makeResponse(true, 'El arreglo de documentos relacionados está vacío.', [], 400);
        }

        $documents = [];
        foreach($documentsArr as $documentFile){
            if(!array_key_exists('type', $documentFile)){
                return $this->responseController->makeResponse(true, 'El arreglo de documentos asociados tiene un formato inválido.', [], 400);
            }else if($documentFile['type'] == 'Nuevo'){
                $tempFileID = $this->encryptionController->decrypt($documentFile['id']);
                $tempFile = DB::table('S002V01TARTE')->where([
                    ['ARTE_IDAR', '=', $tempFileID],
                    ['ARTE_NULI', '=', $form['linea']]
                ])->first();

                $finalFile = $this->documentManagementController->moveFinalFile($form['linea'], 'GEEQ', 'IN', $tempFile, $idUser);
                if(!$finalFile[0]){
                    return $this->responseController->makeResponse(true, $finalFile[1], [], 400);
                }

                $documents[] = $finalFile[1];
            }else{
                $fileID = $this->encryptionController->decrypt($documentFile['id']);
                $documents[] = $fileID;
            }
        }

        $documentsStr = json_encode($documents);
        $acquisitionDate = new Carbon($form['acquisition_date']);
        $warrantyStartDate = new Carbon($form['warranty_start_date']);
        $warrantyEndDate = new Carbon($form['warranty_end_date']);

        if($warrantyStartDate->lt($acquisitionDate)){
            return $this->responseController->makeResponse(true, 'La fecha de inicio de la grantía no puede ser menor a la fecha de adquisición.', [], 400);
        }else if($warrantyEndDate->lte($acquisitionDate)){
            return $this->responseController->makeResponse(true, 'La fecha de término de la grantía no puede ser menor o igual a la fecha de inicio de la garantía.', [], 400);
        }

        $providerID = $this->encryptionController->decrypt($form['equipment_provider']);
        if(!$providerID){
            return $this->responseController->makeResponse(true, 'El proveedor del equipamiento no fue encriptado correctamente.', [], 400);
        }

        $provider = DB::table('S002V01TPROV')->where([
            ['PROV_NUPR', '=', $providerID],
            ['PROV_NULI', '=', $form['linea']]
        ])->first();

        if(is_null($provider)){
            return $this->responseController->makeResponse(true, 'La proveedor seleccionada no existe.', [], 404);
        }

        $serialNumer = $this->encryptionController->decrypt($form['serial_number']);
        if(!$serialNumer){
            return $this->responseController->makeResponse(true, 'El número de serie del equipamiento no fue encriptado correctamente.', [], 400);
        }

        $serialNmberDB = DB::table('S002V01TEQUI')->where([
            ['EQUI_NULI', '=', $form['linea']],
            ['EQUI_NUSE', '=', $serialNumer]
        ])->first();

        if(!is_null($serialNmberDB)){
            $serialNumberStr = $serialNmberDB->EQUI_COEQ;
            return $this->responseController->makeResponse(true, "El número de serie enviado ya se encuentra relacionado al equipamiento $serialNumberStr.", [], 401);
        }

        $preCode = $this->encryptionController->decrypt($form['pre_generated_code']);
        if(!$preCode){
            return $this->responseController->makeResponse(true, 'El código pre generado no fue encriptado correctamente.', [], 400);
        }

        $elde = null;
        $destinyElementSecuence = null;
        $originElement = '';
        $originElementSecuence = null;
        $trainArea = null;


        if($form['code_type'] == '4'){
            $originElementDec = $this->encryptionController->decrypt($form['origin_element_enc']);
            if(!$originElementDec){
                return $this->responseController->makeResponse(true, 'El elemento de origen no fue encriptado correctamente.', [], 400);
            }

            $originElementObj = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $form['linea']],
                ['EQUI_COEQ', '=', $originElementDec]
            ])->first();

            if(is_null($originElementObj)){
                return $this->responseController->makeResponse(true, "El elemento de origen no existe.", [], 404);
            }

            $originElement = $originElementObj->EQUI_ELOR;
            $originElementSecuence = $originElementObj->EQUI_IDEQ;
            $destinyElementDec = $this->encryptionController->decrypt($form['destiny_element_enc']);
            if(!$destinyElementDec){
                return $this->responseController->makeResponse(true, 'El elemento de destino no fue encriptado correctamente.', [], 400);
            }

            $destinyElementObj = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $form['linea']],
                ['EQUI_COEQ', '=', $destinyElementDec]
            ])->first();

            if(is_null($destinyElementObj)){
                return $this->responseController->makeResponse(true, "El elemento de destino no existe.", [], 404);
            }

            $elde = $destinyElementObj->EQUI_ELOR;
            $destinyElementSecuence = $destinyElementObj->EQUI_IDEQ;
        }else if($form['code_type'] == '5'){
            $originElement = $this->encryptionController->decrypt($form['origin_element']);
            if(!$originElement){
                return $this->responseController->makeResponse(true, 'El elemento de origen no fue encriptado correctamente.', [], 400);
            }

            $trainElementsEnc = file_get_contents($ubic . "train-elements.sam");
            $trainElementsDec = $this->encryptionController->decrypt($trainElementsEnc);
            $trainElementsArr = json_decode($trainElementsDec, true);

            foreach($trainElementsArr as $k0=>$v0){
                $trainElement = [];
                foreach($v0 as $k1=>$v1){
                    $valDec = $this->encryptionController->decrypt($v1);
                    $trainElement[$k1] = $valDec;
                }

                $trainElementsArr[$k0] = $trainElement;
            }

            $trainElementFilt = array_filter($trainElementsArr, function($v, $k) use ($originElement) {
                return $v['CODE'] == $originElement;
            }, ARRAY_FILTER_USE_BOTH);

            if(count($trainElementFilt) < 1){
                return $this->responseController->makeResponse(true, "El elemento de origen no existe.", [], 404);
            }
            
            $trainArea = $this->encryptionController->decrypt($form['train_area']);
            if(!$trainArea){
                return $this->responseController->makeResponse(true, 'El área del tren no fue encriptado correctamente.', [], 400);
            }

            $carAreasEnc = file_get_contents($ubic . "car-areas.sam");
            $carAreasDec = $this->encryptionController->decrypt($carAreasEnc);
            $carAreasArr = json_decode($carAreasDec, true);
            $carAreasArrDec = [];
    
            foreach($carAreasArr as $key=>$val){
                $keyDec = $this->encryptionController->decrypt($key);
                $carAreasArrDec[$keyDec] = $val;
            }

            $occupationAreasFilt = array_filter($carAreasArrDec, function($v, $k) use($originOccupationStr) {
                return $k == $originOccupationStr;
            }, ARRAY_FILTER_USE_BOTH);

            if(count($occupationAreasFilt) < 1){
                return $this->responseController->makeResponse(true, "No se encontraron áreas relacionadas a la ocupación $originOccupationStr.", [], 404);
            }

            $occupationAreasArr = end($occupationAreasFilt);
            foreach($occupationAreasArr as $k0=>$v0){
                $occupationArea = [];
                foreach($v0 as $k1=>$v1){
                    $valDec = $this->encryptionController->decrypt($v1);
                    $occupationArea[$k1] = $valDec;
                }

                $occupationAreasArr[$k0] = $occupationArea;
            }

            $occupationAreaFilt = array_filter($occupationAreasArr, function($v, $k) use($trainArea) {
                return $v['CODE'] == $trainArea;
            }, ARRAY_FILTER_USE_BOTH);

            if(count($occupationAreaFilt) < 1){
                return $this->responseController->makeResponse(true, "el área del tren seleccionada no existe.", [], 404);
            }
        }else{
            $originElement = $form['origin_element'];
            $elde = isset($form['destiny_element']) ? $form['destiny_element'] : null;
        }

        $ipcc = isset($form['pcc_intersection']) ? $form['pcc_intersection'] : null;
        $ppcc = isset($form['pcc_position']) ? $form['pcc_position'] : null;
        $kior = isset($form['origin_kilometer']) ? $form['origin_kilometer'] : null;
        $kide = isset($form['destiny_kilometer']) ? $form['destiny_kilometer'] : null;

        $tcor = null;
        $ceor = null;
        $tcde = null;
        $cede = null;

        if($form['code_type'] == '6'){
            if($form['origin_code_type'] == $form['destiny_code_type']){
                return $this->responseController->makeResponse(true, 'El tipo de código de origen no puede ser igual al tipo de código de destino.', [], 400);
            }

            $ceor = $this->encryptionController->decrypt($form['origin_element']);
            if(!$ceor){
                return $this->responseController->makeResponse(true, 'El código del elemento de origen no fue encriptado correctamente.', [], 400);
            }

            $tcor = $form['origin_code_type'];
            $originElementCodeArr0 = explode('_', $ceor);
            if($form['origin_code_type'] == '1'){
                $originPBSArr = explode('.', $originElementCodeArr0[0]);

                $originLocation = $originPBSArr[1];
                $originLevel = $originPBSArr[2];
                $originOccupationStr = $originPBSArr[3];
                $originElement = $originPBSArr[4];

                $originLBSArr = explode('.', $originElementCodeArr0[1]);
                $originLBSArr = array_reverse($originLBSArr);
                $originEquipment = explode('-', $originLBSArr[0]);
                $originElementSecuence = $originEquipment[2];
            }else if($form['origin_code_type'] == '2'){
                $originPBSArr = explode('.', $originElementCodeArr0[0]);

                $originLocation = $originPBSArr[1];
                $originLevel = $originPBSArr[2];
                $originOccupationStr = $originPBSArr[3];
                $originElement = $originPBSArr[4];
                $ipcc = $originPBSArr[5];
                $ppcc = $originPBSArr[6];

                $originLBSArr = explode('.', $originElementCodeArr0[1]);
                $originLBSArr = array_reverse($originLBSArr);
                $originEquipment = explode('-', $originLBSArr[0]);
                $originElementSecuence = $originEquipment[2];
            }else if($form['origin_code_type'] == '3'){
                $originElementCodeArr1 = explode(':', $originElementCodeArr0[0]);
                $originPBSArr = explode('.', $originElementCodeArr1[0]);

                $originLocation = $originPBSArr[1];
                $originLevel = $originPBSArr[2];
                $originOccupationStr = $originPBSArr[3];

                $originLBSArr = explode('.', $originElementCodeArr0[1]);
                $originLBSArr = array_reverse($originLBSArr);
                $originEquipment = explode('-', $originLBSArr[0]);

                $originElement = $originEquipment[0];
                $originKilometerArr = explode('.', $form['origin_kilometer']);
                $kior = implode(',', $originKilometerArr);
            }else if($form['origin_code_type'] == '4'){
                $originElementCodeArr1 = explode(':', $originElementCodeArr0[0]);
                $originPBSArr = explode('.', $originElementCodeArr1[0]);

                $originLocation = $originPBSArr[1];
                $originLevel = $originPBSArr[2];
                $originOccupationStr = $originPBSArr[3];

                $originLBSArr = explode('.', $originElementCodeArr0[1]);
                $originLBSArr = array_reverse($originLBSArr);
                $originEquipment = explode('-', $originLBSArr[0]);

                $originElement = $originEquipment[0];
                $originElementSecuence = $originEquipment[2];
            }else if($form['origin_code_type'] == '5'){
                $originPBSArr = explode('.', $originElementCodeArr0[0]);

                $originLocation = $originPBSArr[1];
                $originLevel = $originPBSArr[2];
                $originOccupationStr = $originPBSArr[3];
                $originElement = $originPBSArr[5];
                $trainArea = $originPBSArr[4];

                $originLBSArr = explode('.', $originElementCodeArr0[1]);
                $originLBSArr = array_reverse($originLBSArr);
                $originEquipment = explode('-', $originLBSArr[0]);
                $originElementSecuence = $originEquipment[2];
            }

            $cede = $this->encryptionController->decrypt($form['destiny_element']);
            if(!$cede){
                return $this->responseController->makeResponse(true, 'El código del elemento de destino no fue encriptado correctamente.', [], 400);
            }

            $tcde = $form['destiny_code_type'];
            $destinyElementCodeArr0 = explode('_', $cede);
            if($form['destiny_code_type'] == '1'){
                $destinyPBSArr = explode('.', $destinyElementCodeArr0[0]);

                $destinyLocation = $destinyPBSArr[1];
                $destinyLevel = $destinyPBSArr[2];
                $destinyOccupationStr = $destinyPBSArr[3];
                $elde = $destinyPBSArr[4];

                $destinyLBSArr = explode('.', $destinyElementCodeArr0[1]);
                $destinyLBSArr = array_reverse($destinyLBSArr);
                $destinyEquipment = explode('-', $destinyLBSArr[0]);
                $destinyElementSecuence = $destinyEquipment[2];
            }else if($form['destiny_code_type'] == '2'){
                $destinyPBSArr = explode('.', $destinyElementCodeArr0[0]);

                $destinyLocation = $destinyPBSArr[1];
                $destinyLevel = $destinyPBSArr[2];
                $destinyOccupationStr = $destinyPBSArr[3];
                $elde = $destinyPBSArr[4];
                $ipcc = $destinyPBSArr[5];
                $ppcc = $destinyPBSArr[6];

                $destinyLBSArr = explode('.', $destinyElementCodeArr0[1]);
                $destinyLBSArr = array_reverse($destinyLBSArr);
                $destinyEquipment = explode('-', $destinyLBSArr[0]);
                $destinyElementSecuence = $destinyEquipment[2];
            }else if($form['destiny_code_type'] == '3'){
                $destinyElementCodeArr1 = explode(':', $destinyElementCodeArr0[0]);
                $destinyPBSArr = explode('.', $destinyElementCodeArr1[1]);

                $destinyLocation = $destinyPBSArr[0];
                $destinyLevel = $destinyPBSArr[1];
                $destinyOccupationStr = $destinyPBSArr[2];

                $destinyBSArr = explode('.', $destinyElementCodeArr0[1]);
                $destinyBSArr = array_reverse($destinyBSArr);
                $destinyEquipment = explode('-', $destinyBSArr[0]);

                $elde = $destinyEquipment[0];
                $destinyKilometerArr = explode('.', $form['destiny_kilometer']);
                $kide = implode(',', $destinyKilometerArr);
            }else if($form['destiny_code_type'] == '4'){
                $destinyElementCodeArr1 = explode(':', $destinyElementCodeArr0[0]);
                $destinyPBSArr = explode('.', $destinyElementCodeArr1[1]);

                $destinyLocation = $destinyPBSArr[0];
                $destinyLevel = $destinyPBSArr[1];
                $destinyOccupationStr = $destinyPBSArr[2];

                $destinyBSArr = explode('.', $destinyElementCodeArr0[1]);
                $destinyBSArr = array_reverse($destinyBSArr);
                $destinyEquipment = explode('-', $destinyBSArr[0]);

                $elde = $destinyEquipment[0];
                $destinyElementSecuence = $destinyEquipment[2];
            }else if($form['destiny_code_type'] == '5'){
                $destinyPBSArr = explode('.', $destinyElementCodeArr0[0]);

                $destinyLocation = $destinyPBSArr[1];
                $destinyLevel = $destinyPBSArr[2];
                $destinyOccupationStr = $destinyPBSArr[3];
                $elde = $destinyPBSArr[5];
                $trainArea = $destinyPBSArr[4];

                $destinyBSArr = explode('.', $destinyElementCodeArr0[1]);
                $destinyBSArr = array_reverse($destinyBSArr);
                $destinyEquipment = explode('-', $destinyBSArr[0]);
                $destinyElementSecuence = $destinyEquipment[2];
            }
        }

        $codeVerified = $this->verifyPreCode([
            "line" => $form['linea'],
            "originLocation" => $originLocation,
            "originLevel" => $originLevel,
            "originOccupation" => $originOccupationStr,
            "originElement" => $originElement,
            "family" => $familyCode,
            "subfamily" => $subfamilyCode,
            "status" => $status,
            "equipmentType" => $form['equipment_type'],
            "equipmentModel" => $form['equipment_model'],
            "equipmentID" => "XXXXX",
            "pccIntersection" => $ipcc,
            "pccPosition" => $ppcc,
            "originKilometers" => $kior,
            "destinyLocation" => $destinyLocation,
            "destinyLevel" => $destinyLevel,
            "destinyOccupation" => $destinyOccupationStr,
            "destinyElement" => $elde,
            "destinyKilometers" => $kide,
            "originElementSecuence" => $originElementSecuence,
            "destinyElementSecuence" => $destinyElementSecuence,
            "trainArea" => $trainArea,
            "originCodeType" => isset($form['origin_code_type']) ? $form['origin_code_type'] : null,
            "destinyCodeType" => isset($form['destiny_code_type']) ? $form['destiny_code_type'] : null,
        ], $form['code_type'], $form['hierarchy'], $eqpa);

        if($codeVerified != $preCode){
            return $this->responseController->makeResponse(true, 'El código generado no coincide con el código verificado a partir de la información del formulario.', [$preCode, $codeVerified], 400);
        }

        $deso = isset($form['software_name']) ? $form['software_name'] : null;
        $veso = isset($form['software_version']) ? $form['software_version'] : null;

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        DB::table('S002V01TPCEQ')->insert([
            'PCEQ_NULI' => $form['linea'],
            'PCEQ_CPGE' => $preCode,
            'PCEQ_JERA' => $form['hierarchy'],
            'PCEQ_EQPA' => $eqpa,
            'PCEQ_TICO' => $form['code_type'],
            'PCEQ_UBOR' => $originLocation,
            'PCEQ_NIOR' => $originLevel,
            'PCEQ_OCOR' => $originOccupationStr,
            'PCEQ_ELOR' => $originElement,
            'PCEQ_FAMI' => $familyCode,
            'PCEQ_SUBF' => $subfamilyCode,
            'PCEQ_ESEQ' => $status,
            'PCEQ_TIEQ' => $form['equipment_type'],
            'PCEQ_MOEQ' => $form['equipment_model'],
            'PCEQ_IPCC' => $ipcc,
            'PCEQ_PPCC' => $ppcc,
            'PCEQ_KIOR' => $kior,
            'PCEQ_SEOR' => $originElementSecuence,
            'PCEQ_ARTR' => $trainArea,
            'PCEQ_TCOR' => $tcor,
            'PCEQ_CEOR' => $ceor,
            'PCEQ_UBDE' => $destinyLocation,
            'PCEQ_NIDE' => $destinyLevel,
            'PCEQ_OCDE' => $destinyOccupationStr,
            'PCEQ_ELDE' => $elde,
            'PCEQ_KIDE' => $kide,
            'PCEQ_SEDE' => $destinyElementSecuence,
            'PCEQ_TCDE' => $tcde,
            'PCEQ_CEDE' => $cede,
            'PCEQ_FEAD' => $form['acquisition_date'],
            'PCEQ_FIGA' => $form['warranty_start_date'],
            'PCEQ_FTGA' => $form['warranty_end_date'],
            'PCEQ_PREQ' => $providerID,
            'PCEQ_NUSE' => $serialNumer,
            'PCEQ_DESO' => $deso,
            'PCEQ_VESO' => $veso,
            'PCEQ_GAIM' => $imagesGalleryStr,
            'PCEQ_DORE' => $documentsStr,
            'PCEQ_USRE' => $idUser,
            'PCEQ_FERE' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P11REEQ',
            'Registro',
            "El usuario $name (" . $usr->USUA_IDUS . ") solicitó el registro del equipamiento $preCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function saveEquipmentPreCodifiedStock(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'hierarchy' => 'required|string|in:Padre,Hijo',
            'parent_equipment' => 'required_if:hierarchy,=,Hijo|string',
            'code_type' => 'required|integer|between:1,7',
            'origin_location'   => 'required_unless:code_type,7|string|nullable',
            'origin_level'      => 'required_unless:code_type,7|string|nullable',
            'origin_occupation' => 'required_unless:code_type,7|string|nullable',
            'origin_element'    => 'required_unless:code_type,7|string|max:150|nullable',
            'family' => 'required|string',
            'subfamily' => 'required|string',
            'status' => 'required|string',
            'equipment_type' => 'required|string|max:150',
            'equipment_model' => 'required|string|max:75',
            'images' => 'required|json',
            'documents' => 'required|json',
            'acquisition_date' => 'required|date',
            'warranty_start_date' => 'required|date',
            'warranty_end_date' => 'required|date',
            'equipment_provider' => 'required|string',
            'serial_number' => 'nullable|string',
            'has_software' => 'required|string|in:Si,No',
            'software_name' => 'required_if:has_software,=,Si|string|max:150',
            'software_version' => 'required_if:has_software,=,Si|string|max:75',
            'pre_generated_code' => 'required|string',
            'pcc_intersection' => 'required_if:code_type,=,2|string|max:5',
            'pcc_position' => 'required_if:code_type,=,2|string|max:2',
            'origin_kilometer' => 'required_if:code_type,=,3|numeric',
            'destiny_location' => 'required_if:code_type,=,3|string',
            'destiny_level' => 'required_if:code_type,=,3|string',
            'destiny_occupation' => 'required_if:code_type,=,3|string',
            'destiny_element' => 'required_if:code_type,=,3|string|max:150',
            'destiny_kilometer' => 'required_if:code_type,=,3|string',
            'warehouse' => 'required_if:code_type,=,7|string',
            'area' => 'required_if:code_type,=,7|string',
            'level' => 'required_if:code_type,=,7|string',
            'zone' => 'required_if:code_type,=,7|string',
            'number_items' => 'required|integer',
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        
        // Desencriptación del usuario
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }
        // Obtención del usuario
        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();

        // Verificación de la existencia del usuario
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        // El código del equipo padre se inicializa
        $eqpa = null;
        // Si la jerarquía es de tipo "Hijo", Entonces
        if($form['hierarchy'] == 'Hijo'){
            // Se desencripta el código del equipamiento padre
            $eqpa = $this->encryptionController->decrypt($form['parent_equipment']);
            if(!$eqpa){
                return $this->responseController->makeResponse(true, 'El ID del equipamiento padre no fue encriptado correctamente.', [], 400);
            }
            // Se obtiene la información del equipo padre
            $parentEquipment = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $form['linea']],
                ['EQUI_COEQ', '=', $eqpa],
            ])->first();
            // Se verifica que el equipo padre exista
            if(is_null($parentEquipment)){
                return $this->responseController->makeResponse(true, 'El equipamiento padre no existe.', [], 404);
            }
        }
        
        // Se obtiene la ubicación de las plantillas
        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $locationsEnc = file_get_contents($ubic . "locations.sam");
        $locationsDec = $this->encryptionController->decrypt($locationsEnc);
        $locationsArr = json_decode($locationsDec, true);
        $locationsArrDec = [];
        foreach($locationsArr as $location){
            $locationStr = $this->encryptionController->decrypt($location['LOCATION']);
            $code = $this->encryptionController->decrypt($location['CODE']);

            $locationsArrDec[] = [
                'LOCATION' => $locationStr,
                'CODE' => $code
            ];
        }


        $originLocation = null;
        $originLevel = null;
        $originOccupationStr = null;


        $idWarehouse = null;
        $idArea = null;
        $idLevel = null;
        $idZone = null;

        if ($form['code_type'] !== '7') {
            // Se desencripta la ubicación de origen
            $originLocation = $this->encryptionController->decrypt($form['origin_location']);
            if(!$originLocation){
                return $this->responseController->makeResponse(true, 'La ubicación de origen no fue encriptada correctamente.', [], 400);
            }
            // Se verifica con la información del sistema
            $originLocationFilt = array_filter($locationsArrDec, function($v, $k) use ($originLocation) {
                return $v['CODE'] == $originLocation;
            }, ARRAY_FILTER_USE_BOTH);
            // Se verifica que la ubicacion exista en la información del sistema
            if(count($originLocationFilt) < 1){
                return $this->responseController->makeResponse(true, 'La ubicación de origen no se encuentra registrada en el sistema.', [], 404);
            }

            // Se desencripta el nivel del origen
            $originLevel = $this->encryptionController->decrypt($form['origin_level']);
            if(!$originLevel){
                return $this->responseController->makeResponse(true, 'El nivel de origen no fue encriptado correctamente.', [], 400);
            }
            // Se obtienen los niveles disponibles
            $supportedLevels = [];
            for($i = 5; $i > 0; $i--){
                $supportedLevels[] = "S0$i";
            }
            for($i = 0; $i <= 15; $i++){
                $tag = $i < 10 ? "P0$i" : "P$i";
                $supportedLevels[] = $tag;
            }
            // Se verifica que el origen sea válido
            if(!in_array($originLevel, $supportedLevels)){
                return $this->responseController->makeResponse(true, 'El nivel de origen seleccionado es inválido.', [], 400);
            }

            // Se desencripta la ocupación de orden
            $originOccupationStr = $this->encryptionController->decrypt($form['origin_occupation']);
            if(!$originOccupationStr){
                return $this->responseController->makeResponse(true, 'La ocupación de origen no fue encriptada correctamente.', [], 400);
            }
            // Se obtiene la información de la ocupación
            $originOccupationArea = substr($originOccupationStr, 0, 2);
            $originOccupationID = substr($originOccupationStr, 2);
            $originOccupation = DB::table('S002V01TOCUP')->where([
                ['OCUP_NULI', '=', $form['linea']],
                ['OCUP_AREA', '=', $originOccupationArea],
                ['OCUP_IDOC', '=', $originOccupationID]
            ])->first();
            // Se verifica que exista la ocupació
            if(is_null($originOccupation)){
                return $this->responseController->makeResponse(true, 'La ocupación de origen seleccionada no existe.', [], 404);
            }
        } else {

            $form['origin_element'] = null;

            $idWarehouse = $this->encryptionController->decrypt($form['warehouse']);
            if ($idWarehouse === false) {
                return $this->responseController->makeResponse(true, 'El almacen no está encriptado correctamente.', [], 404);
            }
            $idArea = $this->encryptionController->decrypt($form['area']);
            if ($idArea === false) {
                return $this->responseController->makeResponse(true, 'El área no está encriptado correctamente.', [], 404);
            }
            $idLevel = $this->encryptionController->decrypt($form['level']);
            if ($idLevel === false) {
                return $this->responseController->makeResponse(true, 'El nivel no está encriptado correctamente.', [], 404);
            }
            $idZone = $this->encryptionController->decrypt($form['zone']);
            if ($idZone === false) {
                return $this->responseController->makeResponse(true, 'La zona no está encriptado correctamente.', [], 404);
            }

            try {
                $validateWarehouse = DB::table('S002V01TALMA')
                    ->where('ALMA_COAL', '=', $idWarehouse)
                    ->where('ALMA_NULI', '=', $form['linea'])
                    ->exists();
            } catch (\Throwable $th) {
                return $this->responseController->makeResponse(true, 'Ocurrió un error al validar el almacen.', [], 500);
            }
            if (!$validateWarehouse) {
                return $this->responseController->makeResponse(true, 'El almacen no existe.', [], 500);
            }

            try {
                $validateArea = DB::table('S002V01TAREA')
                    ->where('AREA_COAL', '=', $idWarehouse)
                    ->where('AREA_COAR', '=', $idArea)
                    ->where('AREA_NULI', '=', $form['linea'])
                    ->exists();
            } catch (\Throwable $th) {
                return $this->responseController->makeResponse(true, 'Ocurrió un error al validar el almacen.', [], 500);
            }
            if (!$validateArea) {
                return $this->responseController->makeResponse(true, 'El almacen no existe.', [], 500);
            }

            try {
                $validateLevel = DB::table('S002V01TNIVE')
                    ->where('NIVE_COAL', '=', $idWarehouse)
                    ->where('NIVE_COAR', '=', $idArea)
                    ->where('NIVE_CONI', '=', $idLevel)
                    ->where('NIVE_NULI', '=', $form['linea'])
                    ->exists();
            } catch (\Throwable $th) {
                return $this->responseController->makeResponse(true, 'Ocurrió un error al validar el almacen.', [], 500);
            }
            if (!$validateLevel) {
                return $this->responseController->makeResponse(true, 'El almacen no existe.', [], 500);
            }

            try {
                $validateZone = DB::table('S002V01TZONA')
                    ->where('ZONA_COAL', '=', $idWarehouse)
                    ->where('ZONA_COAR', '=', $idArea)
                    ->where('ZONA_CONI', '=', $idLevel)
                    ->where('ZONA_COZO', '=', $idZone)
                    ->where('ZONA_NULI', '=', $form['linea'])
                    ->exists();
            } catch (\Throwable $th) {
                return $this->responseController->makeResponse(true, 'Ocurrió un error al validar el almacen.', [], 500);
            }
            if (!$validateZone) {
                return $this->responseController->makeResponse(true, 'El almacen no existe.', [], 500);
            }
        }

        // Se desencripta la familia 
        $familyCode = $this->encryptionController->decrypt($form['family']);
        if(!$familyCode){
            return $this->responseController->makeResponse(true, 'La familia del equipamiento no fue encriptada correctamente.', [], 400);
        }
        // Se obtienen los datos de la familia
        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $form['linea']],
            ['FAMI_COFA', '=', $familyCode]
        ])->first();

        // Se verifica que la familia exista
        if(is_null($family)){
            return $this->responseController->makeResponse(true, 'La familia seleccionada no existe.', [], 404);
        }


        // Se desencripta la subfamilia
        $subfamilyCode = $this->encryptionController->decrypt($form['subfamily']);
        if(!$subfamilyCode){
            return $this->responseController->makeResponse(true, 'La subfamilia del equipamiento no fue encriptada correctamente.', [], 400);
        }

        // Se obtienen los datos de la subfamilia
        $subfamily = DB::table('S002V01TSUBF')->where([
            ['SUBF_NULI', '=', $form['linea']],
            ['SUBF_COFA', '=', $familyCode],
            ['SUBF_COSU', '=', $subfamilyCode]
        ])->first();

        // Se verifica que la subfamilia exista
        if(is_null($subfamily)){
            return $this->responseController->makeResponse(true, 'La subfamilia seleccionada no existe.', [], 404);
        }

        // Se inicializa arreglo con los estados disponibles
        $validStatus = ["A", "S", "T", "I", "R", "D"];
        // Se desencripta el estado
        $status = $this->encryptionController->decrypt($form['status']);
        // Se verifica que el estado sea un valor válido
        if(!$status){
            return $this->responseController->makeResponse(true, 'La estado del equipamiento no fue encriptado correctamente.', [], 400);
        }else if(!in_array($status, $validStatus)){
            return $this->responseController->makeResponse(true, 'El estado seleccionado para el equipamiento es inválido.', [], 400);
        }

        // Se obtiene el arreglo de las imagenes
        $imagesArr = json_decode($form['images'], true);
        // Se verifica que el arreglo contenga imagenes
        if(count($imagesArr) < 1){
            return $this->responseController->makeResponse(true, 'El arreglo de la galería de imágenes está vacío.', [], 400);
        }

        $imagesGallery = [];
        // Se iteran las imagenes
        foreach($imagesArr as $imageFile){
            // Se verifica que tenga un formato correcto
            if(!array_key_exists('type', $imageFile)){
                return $this->responseController->makeResponse(true, 'El arreglo de la galería de imágenes tiene un formato inválido.', [], 400);
            // Si la imagen es nueva, entonces...
            }else if($imageFile['type'] == 'Nuevo'){
                // Se obtiene el ID de la imagen
                $tempFileID = $this->encryptionController->decrypt($imageFile['id']);
                // Se obtiene la información registrada en la tabla de archivos temporales
                $tempFile = DB::table('S002V01TARTE')->where([
                    ['ARTE_IDAR', '=', $tempFileID],
                    ['ARTE_NULI', '=', $form['linea']]
                ])->first();
                // La imagen es colocada en su posición final
                $finalFile = $this->documentManagementController->moveFinalFile($form['linea'], 'GEEQ', 'FO', $tempFile, $idUser);
                // Si ocurrió un error, entonces se manda el error
                if(!$finalFile[0]){
                    return $this->responseController->makeResponse(true, $finalFile[1], [], 400);
                }
                // La información es guardada en un arreglo
                $imagesGallery[] = $finalFile[1];
            }else{
                // Se desencripta el id de la imagen
                $fileID = $this->encryptionController->decrypt($imageFile['id']);
                // Es guardada en un arreglo
                $imagesGallery[] = $fileID;
            }
        }

        // El arreglo de las imagenes es pasada en formato string
        $imagesGalleryStr = json_encode($imagesGallery);
        // Se obtiene el arreglo de los documentos
        $documentsArr = json_decode($form['documents'], true);
        if(count($documentsArr) < 1){
            return $this->responseController->makeResponse(true, 'El arreglo de documentos relacionados está vacío.', [], 400);
        }

        $documents = [];
        // Se iteran los documentos
        foreach($documentsArr as $documentFile){
            // Se verifica que tenga un formato correcto
            if(!array_key_exists('type', $documentFile)){
                return $this->responseController->makeResponse(true, 'El arreglo de documentos asociados tiene un formato inválido.', [], 400);
            // Si el documento es nuevo, entonces...
            }else if($documentFile['type'] == 'Nuevo'){
                // Se obtiene el ID del documento
                $tempFileID = $this->encryptionController->decrypt($documentFile['id']);
                // Se obtiene la información registrada en la tabla de archivos temporales
                $tempFile = DB::table('S002V01TARTE')->where([
                    ['ARTE_IDAR', '=', $tempFileID],
                    ['ARTE_NULI', '=', $form['linea']]
                ])->first();
                // El documento es colocada en su posición final
                $finalFile = $this->documentManagementController->moveFinalFile($form['linea'], 'GEEQ', 'IN', $tempFile, $idUser);
                // Si ocurrió un error, entonces se manda el error
                if(!$finalFile[0]){
                    return $this->responseController->makeResponse(true, $finalFile[1], [], 400);
                }
                // La información es guardada en un arreglo
                $documents[] = $finalFile[1];
            }else{
                // Se desencripta el id del documento
                $fileID = $this->encryptionController->decrypt($documentFile['id']);
                // Es guardada en un arreglo
                $documents[] = $fileID;
            }
        }
        
        // El arreglo de los documentos es pasada en formato string
        $documentsStr = json_encode($documents);
        
        // Se obtiene el formato de la fecha en formato manejable
        $acquisitionDate = new Carbon($form['acquisition_date']);
        $warrantyStartDate = new Carbon($form['warranty_start_date']);
        $warrantyEndDate = new Carbon($form['warranty_end_date']);

        // Se verifica que la fecha de inicio de la garantia sea menor a la fecha final de la garantia
        if($warrantyStartDate->lt($acquisitionDate)){
            return $this->responseController->makeResponse(true, 'La fecha de inicio de la grantía no puede ser menor a la fecha de adquisición.', [], 400);
        }else if($warrantyEndDate->lte($acquisitionDate)){
            return $this->responseController->makeResponse(true, 'La fecha de término de la grantía no puede ser menor o igual a la fecha de inicio de la garantía.', [], 400);
        }


        // Se desencripta el numero del proveedor
        $providerID = $this->encryptionController->decrypt($form['equipment_provider']);
        if(!$providerID){
            return $this->responseController->makeResponse(true, 'El proveedor del equipamiento no fue encriptado correctamente.', [], 400);
        }
        // Se obtiene la información del proveedor
        $provider = DB::table('S002V01TPROV')->where([
            ['PROV_NUPR', '=', $providerID],
            ['PROV_NULI', '=', $form['linea']]
        ])->first();
        // Se verifica que el proveedor exista
        if(is_null($provider)){
            return $this->responseController->makeResponse(true, 'La proveedor seleccionada no existe.', [], 404);
        }

        $arrSerialNumber = array();
        if ($form['serial_number'] !== '' && !is_null($form['serial_number'])) {
            // Se desencripta el número de serie
            $serialNumer = $this->encryptionController->decrypt($form['serial_number']);
            if(!$serialNumer){
                return $this->responseController->makeResponse(true, 'El número de serie del equipamiento no fue encriptado correctamente.', [], 400);
            }
            $arrSerialNumber = explode(',', $serialNumer);

            if (count($arrSerialNumber) === 1 && intval($form['number_items']) > 1)  {
                $arrSerialContinue = array();
                for ($item = 1; $item <= intval($form['number_items']); $item++) {
                    $arrSerialContinue[] = "{$arrSerialNumber[0]}-$item";
                }
                $arrSerialNumber = $arrSerialContinue;
            } else {
                if (intval($form['number_items']) !== count($arrSerialNumber)) {
                    return $this->responseController->makeResponse(true, 'La cantidad de número de series no corresponde con la cantidad de artículos a registrar.', [], 400);
                }
                foreach ($arrSerialNumber as $key => $serialNumber) {
                    // Se obtiene la información del equipamiento por medio del número de serie
                    $serialNmberDB = DB::table('S002V01TPCEQ')->where([
                        ['PCEQ_NULI', '=', $form['linea']],
                        ['PCEQ_NUSE', '=', $serialNumber]
                    ])->first();
                    // Se verifica que exista el código de serie
                    if(!is_null($serialNmberDB)){
                        $serialNumberStr = $serialNmberDB->PCEQ_CPGE;
                        return $this->responseController->makeResponse(true, "El número de serie $serialNumber enviado ya se encuentra relacionado al equipamiento $serialNumberStr.", [], 401);
                    }
                }
    
                $temp_array = array_unique($arrSerialNumber);
                $duplicates = sizeof($temp_array) != sizeof($arrSerialNumber);
                if ($duplicates) {
                    return $this->responseController->makeResponse(true, 'Los número de serie no se pueden repetir.', [], 400);
                }
            }

            
        } else {
            try {
                $getEquipment = DB::table('S002V01TPCEQ')
                    ->where('PCEQ_NULI', '=', $form['linea'])
                    ->where('PCEQ_NUSE', 'LIKE', '0-%')
                    ->get(['PCEQ_NUSE AS NUMERO_SERIE']);
            } catch (\Throwable $th) {
                return $this->responseController->makeResponse(true, 'Ocurrió un error al obtener los artículos.', $th->getMessage(), 400);
            }

            
            $lastSerie = 0;
            if (count($getEquipment) > 0) {
                foreach ($getEquipment as $key => $equipment) {
                    $serie = str_replace('0-', '', $equipment->NUMERO_SERIE);
                    $serie = intval($serie);
                    if (is_null($lastSerie)) {
                        $lastSerie = $serie;
                    } else if ($serie > $lastSerie) {
                        $lastSerie = $serie;
                    }
                }
            } 
            
            for ($i=0; $i < $form['number_items']; $i++) { 
                $lastSerie = $lastSerie + 1;
                $arrSerialNumber[] = '0-'.$lastSerie;
            }
        }
        if ( empty($arrSerialNumber) ) {
            return $this->responseController->makeResponse(true, 'No hay números de serie disponibles.', [], 400);
        }
        

        // Se desencripta el código pregenerado en Angular
        $preCode = $this->encryptionController->decrypt($form['pre_generated_code']);
        if(!$preCode){
            return $this->responseController->makeResponse(true, 'El código pre generado no fue encriptado correctamente.', [], 400);
        }

        // Se obtiene el código pregenerado en Laravel
        $codeVerified = $this->verifyPreCode([
            "line" => $form['linea'],
            "originLocation" => $originLocation,
            "originLevel" => $originLevel,
            "originOccupation" => $originOccupationStr,
            "originElement" => $form['origin_element'],
            "warehouse" => $idWarehouse,
            "area" => $idArea,
            "level" => $idLevel,
            "zone" => $idZone,
            "family" => $familyCode,
            "subfamily" => $subfamilyCode,
            "status" => $status,
            "equipmentType" => $form['equipment_type'],
            "equipmentModel" => $form['equipment_model'],
            "equipmentID" => "XXXXX",
            "pccIntersection" => null,
            "pccPosition" => null,
            "originKilometers" => null,
            "destinyLocation" => null,
            "destinyLevel" => null,
            "destinyOccupation" => null,
            "destinyElement" => null,
            "destinyKilometers" => null
        ], $form['code_type'], $form['hierarchy'], $eqpa);

        // Se verifica que el código pregenerado en Angular y el pregenerado en Laravel
        if($codeVerified != $preCode){
            return $this->responseController->makeResponse(true, 'El código generado no coincide con el código verificado a partir de la información del formulario.', [], 400);
        }

        // Se verifica que la información del sfotware
        $deso = isset($form['software_name']) ? $form['software_name'] : null;
        $veso = isset($form['software_version']) ? $form['software_version'] : null;

        // Se obtiene la fecha actual
        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        

        $arrPreCodification = array();
        $numberItems = intval($form['number_items']);
        for ($i=0; $i < $numberItems; $i++) { 
            // Se ingresa la información a la tabla de los precódigos de los equipamientos
            $idPreCodification = DB::table('S002V01TPCEQ')->insertGetId([
                'PCEQ_NULI' => $form['linea'],
                'PCEQ_CPGE' => $preCode,
                'PCEQ_JERA' => $form['hierarchy'],
                'PCEQ_EQPA' => $eqpa,
                'PCEQ_TICO' => $form['code_type'],
                'PCEQ_UBOR' => $originLocation,
                'PCEQ_NIOR' => $originLevel,
                'PCEQ_OCOR' => $originOccupationStr,
                'PCEQ_ELOR' => $form['origin_element'],
                'PCEQ_ALMA' => $idWarehouse,
                'PCEQ_AREA' => $idArea,
                'PCEQ_NIVE' => $idLevel,
                'PCEQ_ZONA' => $idZone,
                'PCEQ_FAMI' => $familyCode,
                'PCEQ_SUBF' => $subfamilyCode,
                'PCEQ_ESEQ' => $status,
                'PCEQ_TIEQ' => $form['equipment_type'],
                'PCEQ_MOEQ' => $form['equipment_model'],
                'PCEQ_IPCC' => null,
                'PCEQ_PPCC' => null,
                'PCEQ_KIOR' => 0.0,
                'PCEQ_UBDE' => '',
                'PCEQ_NIDE' => '',
                'PCEQ_OCDE' => '',
                'PCEQ_ELDE' => '',
                'PCEQ_KIDE' => 0.0,
                'PCEQ_FEAD' => $form['acquisition_date'],
                'PCEQ_FIGA' => $form['warranty_start_date'],
                'PCEQ_FTGA' => $form['warranty_end_date'],
                'PCEQ_PREQ' => $providerID,
                'PCEQ_NUSE' => count($arrSerialNumber) === 1 ? $arrSerialNumber[0] : $arrSerialNumber[$i],
                'PCEQ_DESO' => $deso,
                'PCEQ_VESO' => $veso,
                'PCEQ_GAIM' => $imagesGalleryStr,
                'PCEQ_DORE' => $documentsStr,
                'PCEQ_USRE' => $idUser,
                'PCEQ_FERE' => $nowStr,
            ]);

            $idPreCodification = $this->encryptionController->encrypt($idPreCodification);
            $arrPreCodification[] = $idPreCodification;
        }

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P11REEQ',
            'Registro',
            "El usuario $name (" . $usr->USUA_IDUS . ") solicitó el registro del equipamiento $preCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.', $arrPreCodification);
    }

    public function verifyPreCode(array $parameters, string $type, string $mode, string | null $parentCode = '') : string {
        $code = "";

        if($mode == 'Hijo'){
            $code .= $parentCode;
            $equipment = ['equipmentType', 'equipmentModel', 'equipmentID'];
            $equipmentStr = "";
            foreach($equipment as $ctrl){
                $val = $parameters[$ctrl];
                if($ctrl == 'equipmentModel'){
                    $val = $this->processElement($val, 'model');
                }else if($ctrl == 'equipmentType'){
                    $val = $this->processElement($val, 'element');
                }

                $equipmentStr .= $val . '-';
            }
    
            $equipmentStr = substr($equipmentStr, 0, -1);
            $code .= "." . $equipmentStr;
        }else{
            switch($type){
                case "1":
                    //CASO 1: Codificación general
                    $lbs = ['line', 'originLocation', 'originLevel', 'originOccupation', 'originElement'];
                    $lbsStr = "";
                    foreach($lbs as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'line'){
                            $val = intval($val) < 10 ? "0$val" : "$val";
                        }else if($ctrl == 'originElement'){
                            $val = $this->processElement($val, 'element');
                        }
    
                        $lbsStr .= $val . ".";
                    }
    
                    $lbsStr = substr($lbsStr, 0, -1);
                    $pbs = ['family', 'subfamily', 'status'];
                    $pbsStr = "";
                    foreach($pbs as $ctrl){
                        $val = $parameters[$ctrl];
                        $pbsStr .= $val . ".";
                    }
    
                    $pbsStr = substr($pbsStr, 0, -1);
                    $equipment = ['equipmentType', 'equipmentModel', 'equipmentID'];
                    $equipmentStr = "";
                    foreach($equipment as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'equipmentModel'){
                            $val = $this->processElement($val, 'model');
                        }else if($ctrl == 'equipmentType'){
                            $val = $this->processElement($val, 'element');
                        }
    
                        $equipmentStr .= $val . '-';
                    }
    
                    $equipmentStr = substr($equipmentStr, 0, -1);
                    $code = $lbsStr . "_" . $pbsStr . "." . $equipmentStr;
                break;
                case "2":
                    // CASO 2: Elemento en PCC
                    $lbs = ['line', 'originLocation', 'originLevel', 'originOccupation', 'originElement', 'pccIntersection', 'pccPosition'];
                    $lbsStr = "";
                    foreach($lbs as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'line'){
                            $val = intval($val) < 10 ? "0$val" : "$val";
                        }else if($ctrl == 'originElement'){
                            $elementArr = explode(' - ', $val);
                            if(count($elementArr) > 1){
                                $elementCode = $elementArr[1];
                                $pccElementFilt = array_filter($this->pccValidElements, function($v, $k) use ($elementCode) {
                                    return $elementCode == $v['code'];
                                }, ARRAY_FILTER_USE_BOTH);

                                if(count($pccElementFilt) > 0){
                                    $pccElement = end($pccElementFilt);
                                    $val = $pccElement['code'];
                                }
                            }
                        }
    
                        $lbsStr .= $val . ".";
                    }
    
                    $lbsStr = substr($lbsStr, 0, -1);
                    $pbs = ['family', 'subfamily', 'status'];
                    $pbsStr = "";

                    foreach($pbs as $ctrl){
                        $val = $parameters[$ctrl];
                        $pbsStr .= $val . ".";
                    }
    
                    $pbsStr = substr($pbsStr, 0, -1);
                    $equipment = ['equipmentType', 'equipmentModel', 'equipmentID'];
                    $equipmentStr = "";
                    foreach($equipment as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'equipmentModel'){
                            $val = $this->processElement($val, 'model');
                        }else if($ctrl == 'equipmentType'){
                            $val = $this->processElement($val, 'element');
                        }
    
                        $equipmentStr .= $val . '-';
                    }
    
                    $equipmentStr = substr($equipmentStr, 0, -1);
                    $code = $lbsStr . "_" . $pbsStr . "." . $equipmentStr;
                break;
                case "3":
                    // CASO 3: Origen - destino para líneas y enlaces
                    $lbsOrigin = ['line', 'originLocation', 'originLevel', 'originOccupation', 'originElement', 'originKilometers'];
                    $lbsOriginTag = "";
                    foreach($lbsOrigin as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'line'){
                            $val = intval($val) < 10 ? "0$val" : "$val";
                        }else if($ctrl == 'originElement'){
                            $val = $this->processElement($val, 'element');
                        }else if($ctrl == 'originKilometers'){
                            $valArr = explode('.', $val);
                            $val = implode(',', $valArr);
                        }
    
                        $lbsOriginTag .= $val . ".";
                    }
    
                    $lbsOriginTag = substr($lbsOriginTag, 0, -1);
                    $lbsDestiny = ['destinyLocation', 'destinyLevel', 'destinyOccupation', 'destinyElement', 'destinyKilometers'];
                    $lbsDestinyTag = "";
                    foreach($lbsDestiny as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'line'){
                            $val = intval($val) < 10 ? "0$val" : "$val";
                        }else if($ctrl == 'destinyElement'){
                            $val = $this->processElement($val, 'element');
                        }else if($ctrl == 'destinyKilometers'){
                            $valArr = explode('.', $val);
                            $val = implode(',', $valArr);
                        }
    
                        $lbsDestinyTag .= $val . ".";
                    }
                    
                    $lbsDestinyTag = substr($lbsDestinyTag, 0, -1);
                    $pbs = ['family', 'subfamily', 'status'];
                    $pbsStr = "";

                    foreach($pbs as $ctrl){
                        $val = $parameters[$ctrl];
                        $pbsStr .= $val . ".";
                    }
    
                    $pbsStr = substr($pbsStr, 0, -1);
                    $equipment = ['equipmentType', 'equipmentModel', 'equipmentID'];
                    $equipmentStr = "";
                    foreach($equipment as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'equipmentModel'){
                            $val = $this->processElement($val, 'model');
                        }else if($ctrl == 'equipmentType'){
                            $val = $this->processElement($val, 'element');
                        }
    
                        $equipmentStr .= $val . '-';
                    }
    
                    $equipmentStr = substr($equipmentStr, 0, -1);
                    $code = "$lbsOriginTag:$lbsDestinyTag" . "_" . "$pbsStr.$equipmentStr";
                break;
                case "4":
                    // CASO 4: Origen - destino para estaciones y edificios
                    $lbsOrigin = ['line', 'originLocation', 'originLevel', 'originOccupation', 'originElement', 'originElementSecuence'];
                    $lbsOriginTag = "";
                    foreach($lbsOrigin as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'line'){
                            $val = intval($val) < 10 ? "0$val" : "$val";
                        }else if($ctrl == 'originElement'){
                            $val = $this->processElement($val, 'element');
                        }else if($ctrl == 'originElementSecuence'){
                            $valStr = "$val";
                            $valLength = strlen($valStr);
                            $valStrAux = "";

                            for($i = $valLength; $i < 6; $i++){
                                $valStrAux .= "0";
                            }

                            $val = "$valStrAux$valStr";
                        }
    
                        $lbsOriginTag .= $val . ".";
                    }
    
                    $lbsOriginTag = substr($lbsOriginTag, 0, -1);
                    $lbsDestiny = ['destinyLocation', 'destinyLevel', 'destinyOccupation', 'destinyElement', 'destinyElementSecuence'];
                    $lbsDestinyTag = "";
                    foreach($lbsDestiny as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'line'){
                            $val = intval($val) < 10 ? "0$val" : "$val";
                        }else if($ctrl == 'destinyElement'){
                            $val = $this->processElement($val, 'element');
                        }else if($ctrl == 'destinyElementSecuence'){
                            $valStr = "$val";
                            $valLength = strlen($valStr);
                            $valStrAux = "";

                            for($i = $valLength; $i < 6; $i++){
                                $valStrAux .= "0";
                            }

                            $val = "$valStrAux$valStr";
                        }
    
                        $lbsDestinyTag .= $val . ".";
                    }
                    
                    $lbsDestinyTag = substr($lbsDestinyTag, 0, -1);
                    $pbs = ['family', 'subfamily', 'status'];
                    $pbsStr = "";
                    foreach($pbs as $ctrl){
                        $val = $parameters[$ctrl];
                        $pbsStr .= $val . ".";
                    }
    
                    $pbsStr = substr($pbsStr, 0, -1);
                    $equipment = ['equipmentType', 'equipmentModel', 'equipmentID'];
                    $equipmentStr = "";
                    foreach($equipment as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'equipmentModel'){
                            $val = $this->processElement($val, 'model');
                        }else if($ctrl == 'equipmentType'){
                            $val = $this->processElement($val, 'element');
                        }
    
                        $equipmentStr .= $val . '-';
                    }
    
                    $equipmentStr = substr($equipmentStr, 0, -1);
                    $code = "$lbsOriginTag:$lbsDestinyTag" . "_" . "$pbsStr.$equipmentStr";
                break;
                case "5":
                    // CASO 4: Tren
                    $lbs = ['line', 'originLocation', 'originLevel', 'originOccupation', 'trainArea', 'originElement'];
                    $lbsStr = "";
                    foreach($lbs as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'line'){
                            $val = intval($val) < 10 ? "0$val" : "$val";
                        }
    
                        $lbsStr .= $val . ".";
                    }
    
                    $lbsStr = substr($lbsStr, 0, -1);
                    $pbs = ['family', 'subfamily', 'status'];
                    $pbsStr = "";

                    foreach($pbs as $ctrl){
                        $val = $parameters[$ctrl];
                        $pbsStr .= $val . ".";
                    }
    
                    $pbsStr = substr($pbsStr, 0, -1);
                    $equipment = ['equipmentType', 'equipmentModel', 'equipmentID'];
                    $equipmentStr = "";
                    foreach($equipment as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'equipmentModel'){
                            $val = $this->processElement($val, 'model');
                        }else if($ctrl == 'equipmentType'){
                            $val = $this->processElement($val, 'element');
                        }
    
                        $equipmentStr .= $val . '-';
                    }
    
                    $equipmentStr = substr($equipmentStr, 0, -1);
                    $code = $lbsStr . "_" . $pbsStr . "." . $equipmentStr;
                break;
                case "6":
                    $lbsOrigin = [];
                    if($parameters['originCodeType'] == '1'){
                        $lbsOrigin = ['line', 'originLocation', 'originLevel', 'originOccupation', 'originElement', 'originElementSecuence'];
                    }else if($parameters['originCodeType'] == '2'){
                        $lbsOrigin = ['line', 'originLocation', 'originLevel', 'originOccupation', 'originElement', 'pccIntersection', 
                        'pccPosition', 'originElementSecuence'];
                    }else if($parameters['originCodeType'] == '3'){
                        $lbsOrigin = ['line', 'originLocation', 'originLevel', 'originOccupation', 'originElement', 'originKilometers'];
                    }else if($parameters['originCodeType'] == '4'){
                        $lbsOrigin = ['line', 'originLocation', 'originLevel', 'originOccupation', 'originElement', 'originElementSecuence'];
                    }else if($parameters['originCodeType'] == '5'){
                        $lbsOrigin = ['line', 'originLocation', 'originLevel', 'originOccupation', 'trainArea', 'originElement', 'originElementSecuence'];
                    }

                    $lbsOriginTag = "";
                    foreach($lbsOrigin as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'line'){
                            $val = intval($val) < 10 ? "0$val" : "$val";
                        }else if($ctrl == 'originElement' && $parameters['originCodeType'] != '5'){
                            $val = $this->processElement($val, 'element');
                        }else if($ctrl == 'originElementSecuence'){
                            $valStr = "$val";
                            $valLength = strlen($valStr);
                            $valStrAux = "";

                            for($i = $valLength; $i < 6; $i++){
                                $valStrAux .= "0";
                            }

                            $val = "$valStrAux$valStr";
                        }
    
                        $lbsOriginTag .= $val . ".";
                    }
    
                    $lbsOriginTag = substr($lbsOriginTag, 0, -1);
                    $lbsDestiny = [];

                    if($parameters['destinyCodeType'] == '1'){
                        $lbsDestiny = ['destinyLocation', 'destinyLevel', 'destinyOccupation', 'destinyElement', 'destinyElementSecuence'];
                    }else if($parameters['destinyCodeType'] == '2'){
                        $lbsDestiny = ['destinyLocation', 'destinyLevel', 'destinyOccupation', 'destinyElement', 'pccIntersection', 
                        'pccPosition', 'destinyElementSecuence'];
                    }else if($parameters['destinyCodeType'] == '3'){
                        $lbsDestiny = ['destinyLocation', 'destinyLevel', 'destinyOccupation', 'destinyElement', 'destinyKilometers'];
                    }else if($parameters['destinyCodeType'] == '4'){
                        $lbsDestiny = ['destinyLocation', 'destinyLevel', 'destinyOccupation', 'destinyElement', 'destinyElementSecuence'];
                    }else if($parameters['destinyCodeType'] == '5'){
                        $lbsDestiny = ['destinyLocation', 'destinyLevel', 'destinyOccupation', 'trainArea', 'destinyElement', 'destinyElementSecuence'];
                    }

                    $lbsDestinyTag = "";
                    foreach($lbsDestiny as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'line'){
                            $val = intval($val) < 10 ? "0$val" : "$val";
                        }else if($ctrl == 'destinyElement' && $parameters['destinyCodeType'] != '5'){
                            $val = $this->processElement($val, 'element');
                        }else if($ctrl == 'destinyElementSecuence'){
                            $valStr = "$val";
                            $valLength = strlen($valStr);
                            $valStrAux = "";

                            for($i = $valLength; $i < 6; $i++){
                                $valStrAux .= "0";
                            }

                            $val = "$valStrAux$valStr";
                        }
    
                        $lbsDestinyTag .= $val . ".";
                    }
                    
                    $lbsDestinyTag = substr($lbsDestinyTag, 0, -1);
                    $pbs = ['family', 'subfamily', 'status'];
                    $pbsStr = "";
                    foreach($pbs as $ctrl){
                        $val = $parameters[$ctrl];
                        $pbsStr .= $val . ".";
                    }
    
                    $pbsStr = substr($pbsStr, 0, -1);
                    $equipment = ['equipmentType', 'equipmentModel', 'equipmentID'];
                    $equipmentStr = "";
                    foreach($equipment as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'equipmentModel'){
                            $val = $this->processElement($val, 'model');
                        }else if($ctrl == 'equipmentType'){
                            $val = $this->processElement($val, 'element');
                        }
    
                        $equipmentStr .= $val . '-';
                    }
    
                    $equipmentStr = substr($equipmentStr, 0, -1);
                    $code = "$lbsOriginTag:$lbsDestinyTag" . "_" . "$pbsStr.$equipmentStr";
                break;
                case "7":
                    $siteTag = '';
                    $site = ['line', 'area', 'level'];
                    foreach($site as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'line'){
                            $val = intval($val) < 10 ? "0$val" : "$val";
                        }
                        $siteTag .= $val.'.';
                    }
                    $siteTag = substr($siteTag, 0, -1);


                    $areaTag = '';
                    $area = ['warehouse', 'zone'];
                    foreach($area as $ctrl){
                        $val = $parameters[$ctrl];
                        $areaTag .= $val.'.';
                    }
                    $areaTag = substr($areaTag, 0, -1);


                    $technicalSpecificationTag = '';
                    $technicalSpecification = ['family', 'subfamily', 'status'];
                    foreach($technicalSpecification as $ctrl){
                        $val = $parameters[$ctrl];
                        $technicalSpecificationTag .= $val.'.';
                    }
                    $technicalSpecificationTag = substr($technicalSpecificationTag, 0, -1);


                    $equipmentIdentifierTag = '';
                    $equipmentIdentifier = ['equipmentType', 'equipmentModel', 'equipmentID'];
                    foreach($equipmentIdentifier as $ctrl){
                        $val = $parameters[$ctrl];
                        if($ctrl == 'equipmentModel'){
                            $val = $this->processElement($val, 'model');
                        }else if($ctrl == 'equipmentType'){
                            $val = $this->processElement($val, 'element');
                        }

                        $equipmentIdentifierTag .= $val.'-';
                    }
                    $equipmentIdentifierTag = substr($equipmentIdentifierTag, 0, -1);
                    
                    $code = $siteTag.'-'.$areaTag.'_'.$technicalSpecificationTag.'.'.$equipmentIdentifierTag;
                break;
            }
        }

        return $code;
    }

    private function processElement(string $value, string $type) : string {
        $value = strtoupper($value);
        $validVal0 = $this->functionsController->unaccent($value);
        $validVal0 = strtoupper($validVal0);

        $validVal0 = str_replace('-', '', $validVal0);

        $CONNECTORS = ['DE', 'PARA', 'Y', 'O', 'DEL', 'EL', 'LA', 'LOS', 'POR', 'EN'];
        $valueArr1 = explode(' ', $validVal0);
        $validVal1 = [];

        foreach($valueArr1 as $word){
            if(!in_array($word, $CONNECTORS)){
                $validVal1[] = $word;
            }
        }

        $validLength = count($validVal1);
        $validVal2 = "";

        if($validLength < 1){
            return "ERROR";
        }else if($validLength == 1){
            if(strlen($validVal1[0]) < 5){
                $validVal2 = $validVal1[0];
                for($i = strlen($validVal1[0]); $i < 5; $i++){
                    if($type == 'model'){
                        $validVal2 = "X$validVal2";
                    }else{
                        $validVal2 = $validVal2 . "X";
                    }
                }
            }else{
                $validVal2 = substr($validVal1[0], 0, 5);
            }
        }else if($validLength == 2){
            $word1 = "";
            if(strlen($validVal1[0]) < 2){
                if($type == 'model'){
                    $word1 = "X$validVal1[0]";
                }else{
                    $word1 = $validVal1[0] . "X";
                }
            }else{
                $word1 = substr($validVal1[0], 0, 2);
            }

            $word2 = "";
            if(strlen($validVal1[1]) < 3){
                $word2 = $validVal1[1];
                for($i = strlen($validVal1[1]); $i < 3; $i++){
                    if($type == 'model'){
                        $word2 = "X$word2";
                    }else{
                        $word2 = $word2 . "X";
                    }
                }
            }else{
                $word2 = substr($validVal1[1], 0, 3);
            }

            $validVal2 = $word1 . $word2;
        }else if($validLength == 3){
            $word1 = "";
            if(strlen($validVal1[0]) < 2){
                if($type == 'model'){
                    $word1 = "X$validVal1[0]";
                }else{
                    $word1 = $validVal1[0] . "X";
                }
            }else{
                $word1 = substr($validVal1[0], 0, 2);
            }
            
            $word2 = substr($validVal1[1], 0, 1);

            $word3 = "";
            if(strlen($validVal1[2]) < 2){
                if($type == 'model'){
                    $word3 = "X$validVal1[2]";
                }else{
                    $word3 = $validVal1[2] . "X";
                }
            }else{
                $word3 = substr($validVal1[2], 0, 2);
            }

            $validVal2 = $word1 . $word2 . $word3;
        }else if($validLength == 4){
            $word1 = "";
            if(strlen($validVal1[0]) < 2){
                if($type == 'model'){
                    $word1 = "X$validVal1[0]";
                }else{
                    $word1 = $validVal1[0] . "X";
                }
            }else{
                $word1 = substr($validVal1[0], 0, 2);
            }
            
            $word2 = substr($validVal1[1], 0, 1);
            $word3 = substr($validVal1[2], 0, 1);
            $word4 = substr($validVal1[3], 0, 1);

            $validVal2 = $word1 . $word2 . $word3 . $word4;
        }else if($validLength >= 5){
            $word1 = substr($validVal1[0], 0, 1);
            $word2 = substr($validVal1[1], 0, 1);
            $word3 = substr($validVal1[2], 0, 1);
            $word4 = substr($validVal1[3], 0, 1);
            $word5 = substr($validVal1[4], 0, 1);

            $validVal2 = $word1 . $word2 . $word3 . $word4 . $word5;
        }else{
            return "ERROR";
        }

        return $validVal2;
    }

    public function getPendigEquipments($idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $pendingEquipments = DB::table('S002V01TPCEQ')->select([
            'PCEQ_IDPR AS IDREG',
            'PCEQ_CPGE AS CODIGO',
            'PCEQ_TICO AS TIPO_CODIGO',
            'PCEQ_TIEQ AS TIPO_EQUIPAMIENTO',
            'PCEQ_MOEQ AS MODELO_EQUIPAMIENTO',
            'PCEQ_GAIM AS GALERIA_IMAGENES',
            'PCEQ_ESRE AS ESTADO_REGISTRO',
        ])->where([
            ['PCEQ_NULI', '=', $line],
            ['PCEQ_ESRE', '=', 'Revisión'],
        ])->get()->all();

        $idUserEnc = $this->encryptionController->encrypt($idUser);
        foreach($pendingEquipments as $key=>$equipment){
            $equipment->IDREG = $this->encryptionController->encrypt($equipment->IDREG);
            $equipment->CODIGO = $this->encryptionController->encrypt($equipment->CODIGO);

            $imagesGalleryArr = json_decode($equipment->GALERIA_IMAGENES);
            $imagesGalleryFn = [];
            foreach($imagesGalleryArr as $imageCode){
                $imageCodeEnc = $this->encryptionController->encrypt($imageCode);
                $publicUri = $this->documentManagementController->privateGetPublicDocumentURL(
                    $imageCodeEnc,
                    $idUserEnc,
                    $line
                );

                if($publicUri['error']){
                    return $this->responseController->makeresponse(true, $publicUri['msg'], [], 500);
                }else{
                    $uriEnc = $this->encryptionController->encrypt($publicUri['response']['public_uri']);
                    $imagesGalleryFn[] = $uriEnc;
                }
            }

            $equipment->GALERIA_IMAGENES = json_encode($imagesGalleryFn);
            $equipment->TIPO_EQUIPAMIENTO = $this->encryptionController->encrypt($equipment->TIPO_EQUIPAMIENTO);
            $equipment->MODELO_EQUIPAMIENTO = $this->encryptionController->encrypt($equipment->MODELO_EQUIPAMIENTO);
            
            $pendingEquipments[$key] = $equipment;
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó los equipamientos en revisión.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $pendingEquipments);
    }

    public function getPendigEquipment($idReg, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $idReg = $this->encryptionController->decrypt($idReg);
        if(!$idReg){
            return $this->responseController->makeResponse(true, 'El ID del pre-registro no está encriptado correctamente', [], 400);
        }

        $pendingEquipment = DB::table('S002V01TPCEQ')->select([
            'PCEQ_IDPR AS IDREG',
            'PCEQ_CPGE AS CODIGO',
            'PCEQ_JERA AS JERARQUIA',
            'PCEQ_EQPA AS PADRE',
            'PCEQ_TICO AS TIPO_CODIGO',
            'PCEQ_UBOR AS UBICACION_ORIGEN',
            'PCEQ_NIOR AS NIVEL_ORIGEN',
            'PCEQ_OCOR AS OCUPACION_ORIGEN',
            'PCEQ_ELOR AS ELEMENTO_ORIGEN',
            'PCEQ_FAMI AS FAMILIA',
            'PCEQ_SUBF AS SUBFAMILIA',
            'PCEQ_ESEQ AS ESTADO_EQUIPAMIENTO',
            'PCEQ_TIEQ AS TIPO_EQUIPAMIENTO',
            'PCEQ_MOEQ AS MODELO_EQUIPAMIENTO',
            'PCEQ_IPCC AS INTERSECCION_PCC',
            'PCEQ_PPCC AS POSICION_PCC',
            'PCEQ_KIOR AS KILOMETRO_ORIGEN',
            'PCEQ_UBDE AS UBICACION_DESTINO',
            'PCEQ_NIDE AS NIVEL_DESTINO',
            'PCEQ_OCDE AS OCUPACION_DESTINO',
            'PCEQ_ELDE AS ELEMENTO_DESTINO',
            'PCEQ_KIDE AS KILOMETRO_DESTINO',
            'PCEQ_FEAD AS FECHA_ADQUISICION',
            'PCEQ_FIGA AS FECHA_INICIO_GARANTIA',
            'PCEQ_FTGA AS FECHA_FIN_GARANTIA',
            'PCEQ_PREQ AS PROVEEDOR',
            'PCEQ_NUSE AS NUMERO_SERIAL',
            'PCEQ_DESO AS DENOMINACION_SOFTWARE',
            'PCEQ_VESO AS VERSION_SOFTWARE',
            'PCEQ_GAIM AS GALERIA_IMAGENES',
            'PCEQ_DORE AS DOCUMENTOS',
            'PCEQ_ESRE AS ESTADO_REGISTRO',
            'PCEQ_CORE AS COMENTARIOS_RECHAZO',
            'PCEQ_COAC AS COMENTARIOS_ACEPTACION',
            'PCEQ_USRE AS USUARIO_REGISTRO',
            'PCEQ_FERE AS FECHA_REGISTRO',
            'PCEQ_USMO AS USUARIO_MODIFICO',
            'PCEQ_FEMO AS FECHA_MODIFICACION'
        ])->where([
            ['PCEQ_NULI', '=', $line],
            ['PCEQ_IDPR', '=', $idReg],
            ['PCEQ_ESRE', '=', 'Revisión'],
        ])->first();

        if(is_null($pendingEquipment)){
            return $this->responseController->makeResponse(true, 'El pre-registro solicitado no existe', [], 404);
        }

        $pendingEquipment->IDREG = $this->encryptionController->encrypt($pendingEquipment->IDREG);
        $pendingEquipment->CODIGO = $this->encryptionController->encrypt($pendingEquipment->CODIGO);

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $locationsEnc = file_get_contents($ubic . "locations.sam");
        $locationsDec = $this->encryptionController->decrypt($locationsEnc);
        $locationsArr = json_decode($locationsDec, true);
        $locationsArrDec = [];
        foreach($locationsArr as $location){
            $locationStr = $this->encryptionController->decrypt($location['LOCATION']);
            $code = $this->encryptionController->decrypt($location['CODE']);

            $locationsArrDec[] = [
                'LOCATION' => $locationStr,
                'CODE' => $code
            ];
        }

        $originLocation = $pendingEquipment->UBICACION_ORIGEN;
        $originLocationFilt = array_filter($locationsArrDec, function ($v, $k) use ($originLocation) {
            return $v['CODE'] == $originLocation;
        }, ARRAY_FILTER_USE_BOTH);

        $pendingEquipment->UBICACION_ORIGEN = end($originLocationFilt)['LOCATION'] . " (" . $pendingEquipment->UBICACION_ORIGEN . ")";
        $levelsArr = [];
    
        for($i = 5; $i > 0; $i--){
            $levelsArr[] = [
                'LEVEL' => "Subterráneo S0$i",
                'CODE' => "S0$i",
            ];
        }

        for($i = 0; $i <= 15; $i++){
            $code = $i < 10 ? "P0$i" : "P$i";
            $level = $i == 0 ? "Planta baja P00" : "Piso $code";
            $levelsArr[] = [
                'LEVEL' => $level,
                'CODE' => $code,
            ];
        }

        $originLevel = $pendingEquipment->NIVEL_ORIGEN;
        $originLevelFilt = array_filter($levelsArr, function ($v, $k) use ($originLevel) {
            return $v['CODE'] == $originLevel;
        }, ARRAY_FILTER_USE_BOTH);

        $pendingEquipment->NIVEL_ORIGEN = end($originLevelFilt)['LEVEL'] . " (" . $pendingEquipment->NIVEL_ORIGEN . ")";
        $originOccupationStr = $pendingEquipment->OCUPACION_ORIGEN;
        $originOccupationArea = substr($originOccupationStr, 0, 2);
        $originOccupationID = substr($originOccupationStr, 2);
        $originOccupation = DB::table('S002V01TOCUP')->where([
            ['OCUP_NULI', '=', $line],
            ['OCUP_AREA', '=', $originOccupationArea],
            ['OCUP_IDOC', '=', $originOccupationID]
        ])->first();

        $pendingEquipment->OCUPACION_ORIGEN = $originOccupation->OCUP_DESC . " (" . $originOccupationStr . ")";
        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $line],
            ['FAMI_COFA', '=', $pendingEquipment->FAMILIA],
        ])->first();
        
        $subfamily = DB::table('S002V01TSUBF')->where([
            ['SUBF_NULI', '=', $line],
            ['SUBF_COFA', '=', $pendingEquipment->FAMILIA],
            ['SUBF_COSU', '=', $pendingEquipment->SUBFAMILIA],
        ])->first();

        $pendingEquipment->FAMILIA = $family->FAMI_NOFA . " (" . $pendingEquipment->FAMILIA . ")";
        $pendingEquipment->SUBFAMILIA = $subfamily->SUBF_NOSU . " (" . $pendingEquipment->SUBFAMILIA . ")";

        $validStatus = ["A" => "Adquisición", "S" => "Stock", "T" => "Traslado", "I" => "Instalación", "R" => "Reparación", "D" => "Disposición"];
        $pendingEquipment->ESTADO_EQUIPAMIENTO = $validStatus[$pendingEquipment->ESTADO_EQUIPAMIENTO] . " (" . $pendingEquipment->ESTADO_EQUIPAMIENTO . ")";

        $idUserEnc = $this->encryptionController->encrypt($idUser);
        $imagesGalleryArr = json_decode($pendingEquipment->GALERIA_IMAGENES);
        $imagesGalleryFn = [];
        foreach($imagesGalleryArr as $imageCode){
            $imageCodeEnc = $this->encryptionController->encrypt($imageCode);
            $publicUri = $this->documentManagementController->privateGetPublicDocumentURL(
                $imageCodeEnc,
                $idUserEnc,
                $line
            );
            
            if($publicUri['error']){
                return $this->responseController->makeresponse(true, $publicUri['msg'], [], 500);
            }else{
                $uriEnc = $this->encryptionController->encrypt($publicUri['response']['public_uri']);
                $imagesGalleryFn[] = $uriEnc;
            }
        }

        $documentsArr = json_decode($pendingEquipment->DOCUMENTOS);
        $documentsFn = [];
        foreach($documentsArr as $document){
            $codeArr = explode('=',$document);
            $codeArr0 = explode('-', $codeArr[0]);

            $file = DB::table('S002V01TAFAL')->where([
                ['AFAL_NULI', '=', $line],
                ['AFAL_COMO', '=', $codeArr0[1]],
                ['AFAL_CLDO', '=', $codeArr0[2]],
                ['AFAL_FECR', '=', $codeArr0[3]],
                ['AFAL_NUSE', '=', $codeArr0[4]],
                ['AFAL_NUVE', '=', $codeArr[1]],
            ])->first();

            if(is_null($file)){
                return $this->responseController->makeResponse(true, "El archivo $document no está registrado.", [], 404);
            }

            $documentsFn[] = [
                'id' => $this->encryptionController->encrypt($document),
                'name' => $document,
                'size' => $file->AFAL_TAMA
            ];
        }

        $pendingEquipment->GALERIA_IMAGENES = json_encode($imagesGalleryFn);
        $pendingEquipment->DOCUMENTOS = json_encode($documentsFn);
        $pendingEquipment->PROVEEDOR = $this->encryptionController->encrypt($pendingEquipment->PROVEEDOR);
        $pendingEquipment->NUMERO_SERIAL = $this->encryptionController->encrypt($pendingEquipment->NUMERO_SERIAL);

        $usrReg = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $pendingEquipment->USUARIO_REGISTRO]
        ])->first();

        $usrRegName = $this->functionsController->joinName($usrReg->USUA_NOMB, $usrReg->USUA_APPA, $usrReg->USUA_APMA);
        $pendingEquipment->USUARIO_REGISTRO = $usrRegName . " (" . $pendingEquipment->USUARIO_REGISTRO . ")";

        if(!is_null($pendingEquipment->USUARIO_MODIFICO)){
            $usrMod = DB::table('S002V01TUSUA')->where([
                ['USUA_NULI', '=', $line],
                ['USUA_IDUS', '=', $pendingEquipment->USUARIO_MODIFICO]
            ])->first();

            $usrModName = $this->functionsController->joinName($usrMod->USUA_NOMB, $usrMod->USUA_APPA, $usrMod->USUA_APMA);
            $pendingEquipment->USUARIO_MODIFICO = $usrModName . " (" . $pendingEquipment->USUARIO_MODIFICO . ")";
        }

        $pendingEquipment->TIPO_EQUIPAMIENTO = $this->encryptionController->encrypt($pendingEquipment->TIPO_EQUIPAMIENTO);
        $pendingEquipment->MODELO_EQUIPAMIENTO = $this->encryptionController->encrypt($pendingEquipment->MODELO_EQUIPAMIENTO);

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó el equipamiento pre codificado $idReg.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $pendingEquipment);
    }

    public function changePreCodedEquipmentStatus(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'id_reg' => 'required|string',
            'status' => 'required|string|in:Aprobado,Rechazado',
            'comments' => 'required|string|min:15',
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $idReg = $this->encryptionController->decrypt($form['id_reg']);
        if(!$idReg){
            return $this->responseController->makeResponse(true, 'El ID del pre-registro no está encriptado correctamente', [], 400);
        }

        $pendingEquipment = DB::table('S002V01TPCEQ')->where([
            ['PCEQ_NULI', '=', $form['linea']],
            ['PCEQ_IDPR', '=', $idReg],
        ])->first();

        if(is_null($pendingEquipment)){
            return $this->responseController->makeResponse(true, 'El pre-registro solicitado no existe.', [], 404);
        }else if($pendingEquipment->PCEQ_ESRE == 'Rechazado'){
            return $this->responseController->makeResponse(true, 'El pre-registro se encuentra rechazado.', [], 400);
        }else if($pendingEquipment->PCEQ_ESRE == 'Aprobado'){
            return $this->responseController->makeResponse(true, 'El pre-registro se encuentra aprobado.', [], 400);
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        if($form['status'] == 'Rechazado'){
            DB::table('S002V01TPCEQ')->where([
                ['PCEQ_IDPR', '=', $idReg],
                ['PCEQ_NULI', '=', $form['linea']],
            ])->update([
                'PCEQ_ESRE' => $form['status'],
                'PCEQ_CORE' => $form['comments'],
                'PCEQ_USMO' => $idUser,
                'PCEQ_FEMO' => $nowStr,
            ]);
        }else{
            //PASO 1: SE BUSCA EL ÚLTIMO ID DEL EQUIPAMIENTO
            $lastID = DB::table('S002V01TEQUI')->select([
                'EQUI_IDEQ AS LAST_ID'
            ])->where([
                ['EQUI_NULI', '=', $form['linea']],
                ['EQUI_FAMI', '=', $pendingEquipment->PCEQ_FAMI],
                ['EQUI_SUBF', '=', $pendingEquipment->PCEQ_SUBF],
                ['EQUI_TIPO', '=', $pendingEquipment->PCEQ_TIEQ],
                ['EQUI_MODE', '=', $pendingEquipment->PCEQ_MOEQ],
            ])->orderBy('EQUI_IDEQ', 'asc')->first();

            //PASO 2: SE DEFINE EL ID DEL NUEVO EQUIPAMIENTO
            $IDNum = is_null($lastID) ? 1 : $lastID->LAST_ID + 1;

            //PASO 3: SE DEFINE UN ESPACIO PARA RETORNAR EL PROCESO
            doAgain:

            //PASO 4: SE RELLENA EL ID CON CEROS A LA IZQUIERDA PARA DARLE EL FORMATO DE LA CODIFICACIÓN
            $IDStr = "$IDNum";
            for($i = strlen($IDStr); $i < 6; $i++){
                $IDStr = "0$IDStr";
            }

            //PASO 5: SE INTEGRA EL ID AL CÓDIGO PRE-GENERADO
            $preCodeArr = explode('_', $pendingEquipment->PCEQ_CPGE);
            $previewPBS = $preCodeArr[1];
            $previewPBSArr = explode('-', $previewPBS);
            $previewPBSArr = array_reverse($previewPBSArr);

            $previewPBSArr[0] = $IDStr;
            $previewPBSArr = array_reverse($previewPBSArr);
            $previewPBS = implode('-', $previewPBSArr);

            //PASO 6: SE BUSCA SI EL CÓDIGO ESTÁ REGISTRADO EN ALGÚN EQUIPAMIENTO O EN EL HISTORIAL DE CÓDIGOS DE ALGÚN EQUIPAMIENTO
            $previewCode = $preCodeArr[0] . "_" . $previewPBS;
            $registeredCode = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $form['linea']],
                ['EQUI_COEQ', '=', $previewCode]
            ])->first();

            $codeInHistory = DB::table('S002V01TEQUI')
            ->where('EQUI_NULI', '=', $form['linea'])
            ->whereJsonContains('EQUI_HICO->CODIGO', $previewCode)->first();

            //PASO 7: VERIFICAR QUE EL CÓDIGO NO EXISTA, SI EXISTE SE REALIZA NUEVAMENTE EL PROCESO AUMENTANDO EN 1 EL ID
            if(!is_null($registeredCode) || !is_null($codeInHistory)){
                $IDNum++;
                goto doAgain;
            }

            //PASO 8: REALIZAR EL REGISTRO DEL EQUIPAMIENTO
            $hico = json_encode([
                [
                    'CODIGO' => $previewCode,
                    'PADRE' => $pendingEquipment->PCEQ_EQPA
                ]
            ]);

            DB::table('S002V01TEQUI')->insert([
                'EQUI_NULI' => $form['linea'],
                'EQUI_FAMI' => $pendingEquipment->PCEQ_FAMI,
                'EQUI_SUBF' => $pendingEquipment->PCEQ_SUBF,
                'EQUI_TIPO' => $pendingEquipment->PCEQ_TIEQ,
                'EQUI_MODE' => $pendingEquipment->PCEQ_MOEQ,
                'EQUI_IDEQ' => $IDNum,
                'EQUI_ESEQ' => $pendingEquipment->PCEQ_ESEQ,
                'EQUI_COEQ' => $previewCode,
                'EQUI_JERA' => $pendingEquipment->PCEQ_JERA,
                'EQUI_EQPA' => $pendingEquipment->PCEQ_EQPA,
                'EQUI_TICO' => $pendingEquipment->PCEQ_TICO,
                'EQUI_UBOR' => $pendingEquipment->PCEQ_UBOR,
                'EQUI_NIOR' => $pendingEquipment->PCEQ_NIOR,
                'EQUI_OCOR' => $pendingEquipment->PCEQ_OCOR,
                'EQUI_ELOR' => $pendingEquipment->PCEQ_ELOR,
                'EQUI_ALMA' => $pendingEquipment->PCEQ_ALMA,
                'EQUI_AREA' => $pendingEquipment->PCEQ_AREA,
                'EQUI_NIVE' => $pendingEquipment->PCEQ_NIVE,
                'EQUI_ZONA' => $pendingEquipment->PCEQ_ZONA,
                'EQUI_IPCC' => $pendingEquipment->PCEQ_IPCC,
                'EQUI_PPCC' => $pendingEquipment->PCEQ_PPCC,
                'EQUI_KIOR' => $pendingEquipment->PCEQ_KIOR,
                'EQUI_SEOR' => $pendingEquipment->PCEQ_SEOR,
                'EQUI_ARTR' => $pendingEquipment->PCEQ_ARTR,
                'EQUI_TCOR' => $pendingEquipment->PCEQ_TCOR,
                'EQUI_CEOR' => $pendingEquipment->PCEQ_CEOR,
                'EQUI_UBDE' => $pendingEquipment->PCEQ_UBDE,
                'EQUI_NIDE' => $pendingEquipment->PCEQ_NIDE,
                'EQUI_OCDE' => $pendingEquipment->PCEQ_OCDE,
                'EQUI_ELDE' => $pendingEquipment->PCEQ_ELDE,
                'EQUI_KIDE' => $pendingEquipment->PCEQ_KIDE,
                'EQUI_SEDE' => $pendingEquipment->PCEQ_SEDE,
                'EQUI_TCDE' => $pendingEquipment->PCEQ_TCDE,
                'EQUI_CEDE' => $pendingEquipment->PCEQ_CEDE,
                'EQUI_FEAD' => $pendingEquipment->PCEQ_FEAD,
                'EQUI_FIGA' => $pendingEquipment->PCEQ_FIGA,
                'EQUI_FTGA' => $pendingEquipment->PCEQ_FTGA,
                'EQUI_PREQ' => $pendingEquipment->PCEQ_PREQ,
                'EQUI_NUSE' => $pendingEquipment->PCEQ_NUSE,
                'EQUI_DESO' => $pendingEquipment->PCEQ_DESO,
                'EQUI_VESO' => $pendingEquipment->PCEQ_VESO,
                'EQUI_HICO' => $hico,
                'EQUI_GAIM' => $pendingEquipment->PCEQ_GAIM,
                'EQUI_DORE' => $pendingEquipment->PCEQ_DORE,
                'EQUI_USRE' => $idUser,
                'EQUI_FERE' => $nowStr,
            ]);

            DB::table('S002V01TPCEQ')->where([
                ['PCEQ_IDPR', '=', $idReg],
                ['PCEQ_NULI', '=', $form['linea']],
            ])->update([
                'PCEQ_ESRE' => $form['status'],
                'PCEQ_CORE' => $form['comments'],
                'PCEQ_USMO' => $idUser,
                'PCEQ_FEMO' => $nowStr,
            ]);
        }

        if ($pendingEquipment->PCEQ_TICO === '7') {
            try {
                $star = (array) DB::table('S002V01TSTAR')
                    ->where('STAR_IDPC', '=', $pendingEquipment->PCEQ_IDPR)
                    ->where('STAR_ESTA', '=', 'Pendiente')
                    ->where('STAR_NULI', '=', $form['linea'])
                    ->first();
            } catch (\Throwable $th) {
                return $this->responseController->makeResponse(true, 'Ocurrió un error al obtener los artículos en Stock.', [], 500); 
            }

            if ( !empty($star) && !is_null($star) ) {

                try {
                    $validateUpdate = DB::table('S002V01TSTAR')
                        ->where('STAR_IDPC', '=', $pendingEquipment->PCEQ_IDPR)
                        ->where('STAR_ESTA', '=', 'Pendiente')
                        ->where('STAR_NULI', '=', $form['linea'])
                        ->update([
                            'STAR_ESTA' => 'Activo',
                            'STAR_USMO' => $idUser,
                            'STAR_FEMO' => $nowStr,
                            'STAR_FEAR' => DB::raw('CURRENT_TIMESTAMP'),
                        ]);
                } catch (\Throwable $th) {
                    return $this->responseController->makeResponse(true, 'Ocurrió un al actualizar el stock.', [], 500); 
                }
                if (!$validateUpdate) {
                    return $this->responseController->makeResponse(true, 'No se pudo actualizar la información en stock.', [], 500); 
                }


                try {
                    $validateUpdate = DB::table('S002V01TUBAR')
                        ->where('UBAR_IDST', '=', $star['STAR_IDST'])
                        ->where('UBAR_ESTA', '=', 'Pendiente')
                        ->where('UBAR_NULI', '=', $form['linea'])
                        ->update([
                            'UBAR_COUB' => $previewCode,
                            'UBAR_ESTA' => 'Activo',
                            'UBAR_USMO' => $idUser,
                            'UBAR_FEMO' => $nowStr,
                            'UBAR_FEAR' => DB::raw('CURRENT_TIMESTAMP'),
                        ]);
                } catch (\Throwable $th) {
                    return $this->responseController->makeResponse(true, 'Ocurrió un al actualizar el stock.', [], 500); 
                }
                if (!$validateUpdate) {
                    return $this->responseController->makeResponse(true, 'No se pudo actualizar la información en stock.', [], 500); 
                }
            }
        }

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P11REEQ',
            'Registro',
            "El usuario $name (" . $usr->USUA_IDUS . ") cambió el estado del pre-registro $idReg a $form[status].",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function getEquipments($idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $equipments = DB::table('S002V01TEQUI')->select([
            'EQUI_COEQ AS CODIGO',
            'EQUI_TIPO AS TIPO',
            'EQUI_MODE AS MODELO',
            'EQUI_IDEQ AS ID_EQUIPO',
            'EQUI_ESFU AS ESTADO_FUNCIONAMIENTO',
            'EQUI_GAIM AS GALERIA_IMAGENES',
            'EQUI_ELOR AS ELEMENTO_ORIGEN',
            'EQUI_TICO AS TIPO_CODIGO',
            'EQUI_EQPA AS EQUIPO_PADRE',
        ])->where('EQUI_NULI', '=', $line)->get()->all();

        $idUserEnc = $this->encryptionController->encrypt($idUser);
        foreach($equipments as $key=>$equipment){
            $children = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $line],
                ['EQUI_EQPA', '=', $equipment->CODIGO],
            ])->get()->all();

            $equipment->CODIGO = $this->encryptionController->encrypt($equipment->CODIGO);
            $equipment->ID_EQUIPO = $this->encryptionController->encrypt($equipment->ID_EQUIPO);
            $equipment->EQUIPO_PADRE = is_null($equipment->EQUIPO_PADRE) ? null : $this->encryptionController->encrypt($equipment->EQUIPO_PADRE);

            $imagesGalleryArr = json_decode($equipment->GALERIA_IMAGENES, true);
            $imagesGalleryFn = [];
            foreach($imagesGalleryArr as $imageCode){
                $imageCodeEnc = $this->encryptionController->encrypt($imageCode);
                $publicUri = $this->documentManagementController->privateGetPublicDocumentURL(
                    $imageCodeEnc,
                    $idUserEnc,
                    $line
                );

                if($publicUri['error']){
                    return $this->responseController->makeresponse(true, $publicUri['msg'], [], 500);
                }else{
                    $uriEnc = $this->encryptionController->encrypt($publicUri['response']['public_uri']);
                    $imagesGalleryFn[] = $uriEnc;
                }
            }

            $equipment->GALERIA_IMAGENES = json_encode($imagesGalleryFn);
            $equipment->TIENE_HIJOS = count($children) > 0 ? 'Si' : 'No';
            $equipments[$key] = $equipment;
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P01MEEQ',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó los equipamientos registrados.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $equipments);
    }

    public function getEquipmentsBySubfamily($familyCode, $subfamilyCode, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $familyCode = $this->encryptionController->decrypt($familyCode);
        if(!$familyCode){
            return $this->responseController->makeResponse(true, 'El código de la familia no está encriptado correctamente', [], 400);
        }
        
        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $line],
            ['FAMI_COFA', '=', $familyCode],
        ])->first();

        if(is_null($family)){
            return $this->responseController->makeResponse(true, 'La familia relacionada no está registrada.', [], 404);
        }

        $subfamilyCode = $this->encryptionController->decrypt($subfamilyCode);
        if(!$subfamilyCode){
            return $this->responseController->makeResponse(true, 'El código de la subfamilia no está encriptado correctamente', [], 400);
        }

        $subfamily = DB::table('S002V01TSUBF')->where([
            ['SUBF_NULI', '=', $line],
            ['SUBF_COFA', '=', $familyCode],
            ['SUBF_COSU', '=', $subfamilyCode],
        ])->first();

        if(is_null($subfamily)){
            return $this->responseController->makeResponse(true, 'La subfamilia relacionada no está registrada.', [], 404);
        }

        $equipments = DB::table('S002V01TEQUI')->select([
            'EQUI_COEQ AS CODIGO',
            'EQUI_TIPO AS TIPO',
            'EQUI_MODE AS MODELO',
            'EQUI_IDEQ AS ID_EQUIPO',
            'EQUI_ESFU AS ESTADO_FUNCIONAMIENTO',
            'EQUI_GAIM AS GALERIA_IMAGENES',
        ])->where([
            ['EQUI_NULI', '=', $line],
            ['EQUI_FAMI', '=', $familyCode],
            ['EQUI_SUBF', '=', $subfamilyCode],
            ['EQUI_JERA', '=', 'Padre']
        ])->get()->all();

        $idUserEnc = $this->encryptionController->encrypt($idUser);
        foreach($equipments as $key=>$equipment){
            $equipment->CODIGO = $this->encryptionController->encrypt($equipment->CODIGO);
            $equipment->ID_EQUIPO = $this->encryptionController->encrypt($equipment->ID_EQUIPO);

            $imagesGalleryArr = json_decode($equipment->GALERIA_IMAGENES, true);
            $imagesGalleryFn = [];
            foreach($imagesGalleryArr as $imageCode){
                $imageCodeEnc = $this->encryptionController->encrypt($imageCode);
                $publicUri = $this->documentManagementController->privateGetPublicDocumentURL(
                    $imageCodeEnc,
                    $idUserEnc,
                    $line
                );

                if($publicUri['error']){
                    return $this->responseController->makeresponse(true, $publicUri['msg'], [], 500);
                }else{
                    $uriEnc = $this->encryptionController->encrypt($publicUri['response']['public_uri']);
                    $imagesGalleryFn[] = $uriEnc;
                }
            }

            $equipment->GALERIA_IMAGENES = json_encode($imagesGalleryFn);
            $equipments[$key] = $equipment;
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P01MEEQ',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó los equipamientos relacionados a la subfamilia $subfamilyCode de la familia $familyCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $equipments);
    }

    public function getEquipmentsByParent($parentCode, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $parentCode = $this->encryptionController->decrypt($parentCode);
        if(!$parentCode){
            return $this->responseController->makeResponse(true, 'El código del equipamiento padre no está encriptado correctamente', [], 400);
        }

        $equipments = DB::table('S002V01TEQUI')->select([
            'EQUI_COEQ AS CODIGO',
            'EQUI_TIPO AS TIPO',
            'EQUI_MODE AS MODELO',
            'EQUI_IDEQ AS ID_EQUIPO',
            'EQUI_ESFU AS ESTADO_FUNCIONAMIENTO',
            'EQUI_GAIM AS GALERIA_IMAGENES',
            'EQUI_EQPA AS EQUIPO_PADRE',
        ])->where([
            ['EQUI_NULI', '=', $line],
            ['EQUI_JERA', '=', 'Hijo'],
            ['EQUI_EQPA', '=', $parentCode],
        ])->get()->all();

        $idUserEnc = $this->encryptionController->encrypt($idUser);
        foreach($equipments as $key=>$equipment){
            $children = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $line],
                ['EQUI_EQPA', '=', $equipment->CODIGO],
            ])->get()->all();

            $equipment->CODIGO = $this->encryptionController->encrypt($equipment->CODIGO);
            $equipment->ID_EQUIPO = $this->encryptionController->encrypt($equipment->ID_EQUIPO);
            $equipment->EQUIPO_PADRE = is_null($equipment->EQUIPO_PADRE) ? null : $this->encryptionController->encrypt($equipment->EQUIPO_PADRE);

            $imagesGalleryArr = json_decode($equipment->GALERIA_IMAGENES, true);
            $imagesGalleryFn = [];
            foreach($imagesGalleryArr as $imageCode){
                $imageCodeEnc = $this->encryptionController->encrypt($imageCode);
                $publicUri = $this->documentManagementController->privateGetPublicDocumentURL(
                    $imageCodeEnc,
                    $idUserEnc,
                    $line
                );

                $response = json_decode($publicUri->original, true);
                if($response['error']){
                    return $this->responseController->makeresponse(true, $response['msg'], [], 500);
                }else{
                    $uriEnc = $this->encryptionController->encrypt($response['response']['public_uri']);
                    $imagesGalleryFn[] = $uriEnc;
                }
            }

            $equipment->GALERIA_IMAGENES = json_encode($imagesGalleryFn);
            $equipment->TIENE_HIJOS = count($children) > 0 ? 'Si' : 'No';
            $equipments[$key] = $equipment;
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P02DEEQ',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó los equipamientos relacionados al equipamiento $parentCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $equipments);
    }

    public function getEquipmentDetails($equipmentCode, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $equipmentCode = $this->encryptionController->decrypt($equipmentCode);
        if(!$equipmentCode){
            return $this->responseController->makeResponse(true, 'El código del equipamiento no está encriptado correctamente', [], 400);
        }

        $equipment = DB::table('S002V01TEQUI')->select([
            'EQUI_FAMI AS FAMILIA',
            'EQUI_SUBF AS SUBFAMILIA',
            'EQUI_TIPO AS TIPO_EQUIPAMIENTO',
            'EQUI_MODE AS MODELO',
            'EQUI_IDEQ AS ID_EQUIPAMIENTO',
            'EQUI_ESEQ AS ESTADO',
            'EQUI_COEQ AS CODIGO',
            'EQUI_JERA AS JERARQUIA',
            'EQUI_EQPA AS EQUIPO_PADRE',
            'EQUI_TICO AS TIPO_CODIGO',
            'EQUI_UBOR AS UBICACION_ORIGEN',
            'EQUI_NIOR AS NIVEL_ORIGEN',
            'EQUI_OCOR AS OCUPACION_ORIGEN',
            'EQUI_ELOR AS ELEMENTO_ORIGEN',
            'EQUI_IPCC AS INTERSECCION_PCC',
            'EQUI_PPCC AS POSICION_PCC',
            'EQUI_KIOR AS KILOMETRO_ORIGEN',
            'EQUI_SEOR AS SECUENCIA_ELEMENTO_ORIGEN',//
            'EQUI_ARTR AS AREA_TREN',//
            'EQUI_TCOR AS TIPO_CODIFICACION_ORIGEN',//
            'EQUI_CEOR AS CODIGO_ELEMENTO_ORIGEN',//
            'EQUI_UBDE AS UBICACION_DESTINO',
            'EQUI_NIDE AS NIVEL_DESTINO',
            'EQUI_OCDE AS OCUPACION_DESTINO',
            'EQUI_ELDE AS ELEMENTO_DESTINO',
            'EQUI_KIDE AS KILOMETRO_DESTINO',
            'EQUI_SEDE AS SECUENCIA_ELEMENTO_DESTINO',//
            'EQUI_TCDE AS TIPO_CODIFICACION_DESTINO',//
            'EQUI_CEDE AS CODIGO_ELEMENTO_DESTINO',//
            'EQUI_CRSE AS NIVEL_CRITICIDAD',//
            'EQUI_FEAD AS FECHA_ADQUISICION',
            'EQUI_FIGA AS FECHA_INICIO_GARANTIA',
            'EQUI_FTGA AS FECHA_TERMINO_GARANTIA',
            'EQUI_PREQ AS PROVEEDOR',
            'EQUI_NUSE AS NUMERO_SERIAL',
            'EQUI_DESO AS DENOMINACION_SOFTWARE',
            'EQUI_VESO AS VERSION_SOFTWARE',
            'EQUI_HICO AS HISTORIAL_CODIGOS',
            'EQUI_GAIM AS GALERIA_IMAGENES',
            'EQUI_DORE AS DOCUMENTOS',
            'EQUI_ESFU AS ESTADO_FUNCIONAMIENTO',
            'EQUI_USRE AS USUARIO_REGISTRO',
            'EQUI_FERE AS FECHA_REGISTRO',
            'EQUI_USMO AS USUARIO_MODIFICACION',
            'EQUI_FEMO AS FECHA_MODIFICACION',
        ])->where([
            ['EQUI_NULI', '=', $line],
            ['EQUI_COEQ', '=', $equipmentCode],
        ])->first();

        $family = DB::table('S002V01TFAMI')->where([
            ['FAMI_NULI', '=', $line],
            ['FAMI_COFA', '=', $equipment->FAMILIA]
        ])->first();

        $subfamily = DB::table('S002V01TSUBF')->where([
            ['SUBF_NULI', '=', $line],
            ['SUBF_COFA', '=', $equipment->FAMILIA],
            ['SUBF_COSU', '=', $equipment->SUBFAMILIA]
        ])->first();

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $equipment->FAMILIA = $family->FAMI_NOFA . " (" . $equipment->FAMILIA . ")";
        $equipment->SUBFAMILIA = $subfamily->SUBF_NOSU . " (" . $equipment->SUBFAMILIA . ")";
        $equipment->ID_EQUIPAMIENTO = $this->encryptionController->encrypt($equipment->ID_EQUIPAMIENTO);
        $equipment->CODIGO = $this->encryptionController->encrypt($equipment->CODIGO);

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $locationsEnc = file_get_contents($ubic . "locations.sam");
        $locationsDec = $this->encryptionController->decrypt($locationsEnc);
        $locationsArr = json_decode($locationsDec, true);
        $locationsArrDec = [];
        foreach($locationsArr as $location){
            $locationStr = $this->encryptionController->decrypt($location['LOCATION']);
            $code = $this->encryptionController->decrypt($location['CODE']);

            $locationsArrDec[] = [
                'LOCATION' => $locationStr,
                'CODE' => $code
            ];
        }

        $originLocation = $equipment->UBICACION_ORIGEN;
        $originLocationFilt = array_filter($locationsArrDec, function ($v, $k) use ($originLocation) {
            return $v['CODE'] == $originLocation;
        }, ARRAY_FILTER_USE_BOTH);

        $equipment->UBICACION_ORIGEN = end($originLocationFilt)['LOCATION'] . " (" . $equipment->UBICACION_ORIGEN . ")";
        if(!is_null($equipment->UBICACION_DESTINO) && $equipment->UBICACION_DESTINO != ''){
            $destinyLocation = $equipment->UBICACION_DESTINO;
            $destinyLocationFilt = array_filter($locationsArrDec, function ($v, $k) use ($destinyLocation) {
                return $v['CODE'] == $destinyLocation;
            }, ARRAY_FILTER_USE_BOTH);

            $equipment->UBICACION_DESTINO = end($destinyLocationFilt)['LOCATION'] . " (" . $equipment->UBICACION_DESTINO . ")";
        }

        $levelsArr = [];
        for($i = 5; $i > 0; $i--){
            $levelsArr[] = [
                'LEVEL' => "Subterráneo S0$i",
                'CODE' => "S0$i",
            ];
        }

        for($i = 0; $i <= 15; $i++){
            $code = $i < 10 ? "P0$i" : "P$i";
            $level = $i == 0 ? "Planta baja P00" : "Piso $code";
            $levelsArr[] = [
                'LEVEL' => $level,
                'CODE' => $code,
            ];
        }

        $originLevel = $equipment->NIVEL_ORIGEN;
        $originLevelFilt = array_filter($levelsArr, function ($v, $k) use ($originLevel) {
            return $v['CODE'] == $originLevel;
        }, ARRAY_FILTER_USE_BOTH);

        $equipment->NIVEL_ORIGEN = end($originLevelFilt)['LEVEL'] . " (" . $equipment->NIVEL_ORIGEN . ")";
        if(!is_null($equipment->NIVEL_DESTINO) && $equipment->NIVEL_DESTINO != ''){
            $destinyLevel = $equipment->NIVEL_DESTINO;
            $destinyLevelFilt = array_filter($levelsArr, function ($v, $k) use ($destinyLevel) {
                return $v['CODE'] == $destinyLevel;
            }, ARRAY_FILTER_USE_BOTH);

            $equipment->NIVEL_DESTINO = end($destinyLevelFilt)['LEVEL'] . " (" . $equipment->NIVEL_DESTINO . ")";
        }

        if($equipment->TIPO_CODIGO == '5'){
            $trainOccupationsEnc = file_get_contents($ubic . "train-occupations.sam");
            $trainOccupationsDec = $this->encryptionController->decrypt($trainOccupationsEnc);
            $trainOccupationsArr = json_decode($trainOccupationsDec, true);

            $trainOccupationsArrDec = [];
            foreach($trainOccupationsArr as $k0=>$v0){
                $trainOccupation = [];
                foreach($v0 as $k1=>$v1){
                    $valDec = $this->encryptionController->decrypt($v1);
                    $trainOccupation[$k1] = $valDec;
                }

                $trainOccupationsArrDec[$k0] = $trainOccupation;
            }

            $originOccupation = $equipment->OCUPACION_ORIGEN;
            $trainOccupationFilt = array_filter($trainOccupationsArrDec, function($v, $k) use($originOccupation){
                return $v['CODE'] == $originOccupation;
            }, ARRAY_FILTER_USE_BOTH);

            $trainOccupation = end($trainOccupationFilt);
            $equipment->OCUPACION_ORIGEN = $trainOccupation['CAR'] . " (" . $trainOccupation['CODE'] . ")";

            $trainElementsEnc = file_get_contents($ubic . "train-elements.sam");
            $trainElementsDec = $this->encryptionController->decrypt($trainElementsEnc);
            $trainElementsArr = json_decode($trainElementsDec, true);

            $trainElementsArrDec = [];
            foreach($trainElementsArr as $k0=>$v0){
                $trainElement = [];
                foreach($v0 as $k1=>$v1){
                    $valDec = $this->encryptionController->decrypt($v1);
                    $trainElement[$k1] = $valDec;
                }

                $trainElementsArrDec[$k0] = $trainElement;
            }

            $originElement = $equipment->ELEMENTO_ORIGEN;
            $trainElementFilt = array_filter($trainElementsArrDec, function($v, $k) use($originElement){
                return $v['CODE'] == $originElement;
            }, ARRAY_FILTER_USE_BOTH);

            $trainElement = end($trainElementFilt);
            $equipment->ELEMENTO_ORIGEN = $trainElement['ELEMENT'] . " (" . $trainElement['CODE'] . ")";

            $carAreasEnc = file_get_contents($ubic . "car-areas.sam");
            $carAreasDec = $this->encryptionController->decrypt($carAreasEnc);
            $carAreasArr = json_decode($carAreasDec, true);

            $carAreasArrDec = [];
            foreach($carAreasArr as $k0=>$v0){
                $keyDec = $this->encryptionController->decrypt($k0);
                if($keyDec == $trainOccupation['CODE']){
                    foreach($v0 as $k1=>$v1){
                        $carArea = [];
                        foreach($v1 as $k2=>$v2){
                            $valDec = $this->encryptionController->decrypt($v2);
                            $carArea[$k2] = $valDec;
                        }

                        $carAreasArrDec[$k1] = $carArea;
                    }
                }
            }

            $trainArea = $equipment->AREA_TREN;
            $carAreaFilt = array_filter($carAreasArrDec, function($v, $k) use($trainArea){
                return $v['CODE'] == $trainArea;
            }, ARRAY_FILTER_USE_BOTH);

            $carArea = end($carAreaFilt);
            $equipment->AREA_TREN = $carArea['AREA'] . " (" . $carArea['CODE'] . ")";
        }else{
            $originOccupationStr = $equipment->OCUPACION_ORIGEN;
            $originOccupationArea = substr($originOccupationStr, 0, 2);
            $originOccupationID = substr($originOccupationStr, 2);
            $originOccupation = DB::table('S002V01TOCUP')->where([
                ['OCUP_NULI', '=', $line],
                ['OCUP_AREA', '=', $originOccupationArea],
                ['OCUP_IDOC', '=', $originOccupationID]
            ])->first();

            $equipment->OCUPACION_ORIGEN = $originOccupation->OCUP_DESC . " (" . $originOccupationStr . ")";
            if(!is_null($equipment->OCUPACION_DESTINO) && $equipment->OCUPACION_DESTINO != ''){
                $destinyOccupationStr = $equipment->OCUPACION_DESTINO;
                $destinyOccupationArea = substr($destinyOccupationStr, 0, 2);
                $destinyOccupationID = substr($destinyOccupationStr, 2);
                $destinyOccupation = DB::table('S002V01TOCUP')->where([
                    ['OCUP_NULI', '=', $line],
                    ['OCUP_AREA', '=', $destinyOccupationArea],
                    ['OCUP_IDOC', '=', $destinyOccupationID]
                ])->first();

                $equipment->OCUPACION_DESTINO = $destinyOccupation->OCUP_DESC . " (" . $destinyOccupationStr . ")";
            }
        }

        if(!is_null($equipment->SECUENCIA_ELEMENTO_ORIGEN)){
            $equipment->SECUENCIA_ELEMENTO_ORIGEN = $this->encryptionController->encrypt($equipment->SECUENCIA_ELEMENTO_ORIGEN);
        }

        if(!is_null($equipment->SECUENCIA_ELEMENTO_DESTINO)){
            $equipment->SECUENCIA_ELEMENTO_DESTINO = $this->encryptionController->encrypt($equipment->SECUENCIA_ELEMENTO_DESTINO);
        }

        if(!is_null($equipment->CODIGO_ELEMENTO_ORIGEN)){
            $equipment->CODIGO_ELEMENTO_ORIGEN = $this->encryptionController->encrypt($equipment->CODIGO_ELEMENTO_ORIGEN);
        }

        if(!is_null($equipment->CODIGO_ELEMENTO_DESTINO)){
            $equipment->CODIGO_ELEMENTO_DESTINO = $this->encryptionController->encrypt($equipment->CODIGO_ELEMENTO_DESTINO);
        }

        $validStatus = ["A" => "Adquisición", "S" => "Stock", "T" => "Traslado", "I" => "Instalación", "R" => "Reparación", "D" => "Disposición"];
        $equipment->ESTADO = $validStatus[$equipment->ESTADO] . " (" . $equipment->ESTADO . ")";

        $idUserEnc = $this->encryptionController->encrypt($idUser);
        $imagesGalleryArr = json_decode($equipment->GALERIA_IMAGENES);
        $imagesGalleryFn = [];
        foreach($imagesGalleryArr as $imageCode){
            $imageCodeEnc = $this->encryptionController->encrypt($imageCode);
            $publicUri = $this->documentManagementController->privateGetPublicDocumentURL(
                $imageCodeEnc,
                $idUserEnc,
                $line
            );

            if($publicUri['error']){
                return $this->responseController->makeresponse(true, $publicUri['msg'], [], 500);
            }else{
                $uriEnc = $this->encryptionController->encrypt($publicUri['response']['public_uri']);
                $imagesGalleryFn[] = $uriEnc;
            }
        }

        $documentsArr = json_decode($equipment->DOCUMENTOS);
        $documentsFn = [];
        foreach($documentsArr as $document){
            $codeArr = explode('=',$document);
            $codeArr0 = explode('-', $codeArr[0]);

            $file = DB::table('S002V01TAFAL')->where([
                ['AFAL_NULI', '=', $line],
                ['AFAL_COMO', '=', $codeArr0[1]],
                ['AFAL_CLDO', '=', $codeArr0[2]],
                ['AFAL_FECR', '=', $codeArr0[3]],
                ['AFAL_NUSE', '=', $codeArr0[4]],
                ['AFAL_NUVE', '=', $codeArr[1]],
            ])->first();

            if(is_null($file)){
                return $this->responseController->makeResponse(true, "El archivo $document no está registrado.", [], 404);
            }

            $documentsFn[] = [
                'id' => $this->encryptionController->encrypt($document),
                'name' => $document,
                'size' => $file->AFAL_TAMA
            ];
        }

        if(!is_null($equipment->NIVEL_CRITICIDAD)){
            $equipment->NIVEL_CRITICIDAD = $this->encryptionController->encrypt($equipment->NIVEL_CRITICIDAD);
        }

        $equipment->GALERIA_IMAGENES = json_encode($imagesGalleryFn);
        $equipment->DOCUMENTOS = json_encode($documentsFn);

        $provider = DB::table('S002V01TPROV')->where([
            ['PROV_NULI', '=', $line],
            ['PROV_NUPR', '=', $equipment->PROVEEDOR],
        ])->first();
        
        $equipment->PROVEEDOR = $provider->PROV_NOCO . " (" . $equipment->PROVEEDOR . ")";
        $equipment->NUMERO_SERIAL = $this->encryptionController->encrypt($equipment->NUMERO_SERIAL);

        $codesHistory = json_decode($equipment->HISTORIAL_CODIGOS, true);
        $codesHistoryFn = [];
        foreach($codesHistory as $code){
            $code['CODIGO'] = $this->encryptionController->encrypt($code['CODIGO']);

            if(isset($code['PADRE'])){
                $code['PADRE'] = $this->encryptionController->encrypt($code['PADRE']);
            }
            
            $codesHistoryFn[] = $code;
        }

        $equipment->HISTORIAL_CODIGOS = json_encode($codesHistoryFn);
        $usrReg = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $equipment->USUARIO_REGISTRO]
        ])->first();

        $usrRegName = $this->functionsController->joinName($usrReg->USUA_NOMB, $usrReg->USUA_APPA, $usrReg->USUA_APMA);
        $equipment->USUARIO_REGISTRO = $usrRegName . " (" . $equipment->USUARIO_REGISTRO . ")";

        if(!is_null($equipment->USUARIO_MODIFICACION)){
            $usrMod = DB::table('S002V01TUSUA')->where([
                ['USUA_NULI', '=', $line],
                ['USUA_IDUS', '=', $equipment->USUARIO_MODIFICACION]
            ])->first();

            $usrModName = $this->functionsController->joinName($usrMod->USUA_NOMB, $usrMod->USUA_APPA, $usrMod->USUA_APMA);
            $equipment->USUARIO_MODIFICACION = $usrModName . " (" . $equipment->USUARIO_MODIFICACION . ")";
        }

        $equipment->TIPO_EQUIPAMIENTO = $this->encryptionController->encrypt($equipment->TIPO_EQUIPAMIENTO);
        $equipment->MODELO = $this->encryptionController->encrypt($equipment->MODELO);

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P01MEEQ',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó el equipamiento $equipmentCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $equipment);
    }

    public function getTrainOccupations($idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $trainOccupationsEnc = file_get_contents($ubic . "train-occupations.sam");
        $trainOccupationsDec = $this->encryptionController->decrypt($trainOccupationsEnc);
        $trainOccupationsArr = json_decode($trainOccupationsDec, true);

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó las ocupaciones de tren.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $trainOccupationsArr);
    }

    public function getTrainAreas($trainOccupation, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $trainOccupation = $this->encryptionController->decrypt($trainOccupation);
        if(!$trainOccupation){
            return $this->responseController->makeResponse(true, 'La ocupación no fue encriptada correctamente.', [], 400);
        }

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $carAreasEnc = file_get_contents($ubic . "car-areas.sam");
        $carAreasDec = $this->encryptionController->decrypt($carAreasEnc);
        $carAreasArr = json_decode($carAreasDec, true);
        $carAreasArrDec = [];

        foreach($carAreasArr as $key=>$val){
            $keyDec = $this->encryptionController->decrypt($key);
            $carAreasArrDec[$keyDec] = $val;
        }

        if(!array_key_exists($trainOccupation, $carAreasArrDec)){
            return $this->responseController->makeResponse(true, "La ocupación $trainOccupation no existe.", [], 404);
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó las áreas de la ocupación $trainOccupation de tren.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $carAreasArrDec[$trainOccupation]);
    }

    public function getTrainElements($idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $ubic = $this->templatesUbic;
        $ubic = str_replace("pdf_templates\\01_05_GEEQ", "global_resources", $ubic);

        $trainElementsEnc = file_get_contents($ubic . "train-elements.sam");
        $trainElementsDec = $this->encryptionController->decrypt($trainElementsEnc);
        $trainElementsArr = json_decode($trainElementsDec, true);

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó los elementos de tren.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $trainElementsArr);
    }

    public function getEquipmentsByCodeType($codeType, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $codeType = $this->encryptionController->decrypt($codeType);
        if(!$codeType){
            return $this->responseController->makeResponse(true, 'El tipo de código seleccionado no está encriptado correctamente', [], 400);
        }

        $equipments = DB::table('S002V01TEQUI')->select([
            'EQUI_COEQ AS CODIGO',
            'EQUI_TIPO AS TIPO',
            'EQUI_MODE AS MODELO',
            'EQUI_IDEQ AS ID_EQUIPO',
            'EQUI_ESFU AS ESTADO_FUNCIONAMIENTO',
            'EQUI_GAIM AS GALERIA_IMAGENES',
            'EQUI_ELOR AS ELEMENTO_ORIGEN',
            'EQUI_TICO AS TIPO_CODIGO',
            'EQUI_EQPA AS EQUIPO_PADRE',
        ])->where([
            ['EQUI_NULI', '=', $line],
            ['EQUI_TICO', '=', $codeType],
        ])->get()->all();

        $idUserEnc = $this->encryptionController->encrypt($idUser);
        foreach($equipments as $key=>$equipment){
            $children = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $line],
                ['EQUI_EQPA', '=', $equipment->CODIGO],
            ])->get()->all();

            $equipment->CODIGO = $this->encryptionController->encrypt($equipment->CODIGO);
            $equipment->ID_EQUIPO = $this->encryptionController->encrypt($equipment->ID_EQUIPO);
            $equipment->EQUIPO_PADRE = is_null($equipment->EQUIPO_PADRE) ? null : $this->encryptionController->encrypt($equipment->EQUIPO_PADRE);

            $imagesGalleryArr = json_decode($equipment->GALERIA_IMAGENES, true);
            $imagesGalleryFn = [];
            foreach($imagesGalleryArr as $imageCode){
                $imageCodeEnc = $this->encryptionController->encrypt($imageCode);
                $publicUri = $this->documentManagementController->privateGetPublicDocumentURL(
                    $imageCodeEnc,
                    $idUserEnc,
                    $line
                );

                $response = json_decode($publicUri->original, true);
                if($response['error']){
                    return $this->responseController->makeresponse(true, $response['msg'], [], 500);
                }else{
                    $uriEnc = $this->encryptionController->encrypt($response['response']['public_uri']);
                    $imagesGalleryFn[] = $uriEnc;
                }
            }

            $equipment->GALERIA_IMAGENES = json_encode($imagesGalleryFn);
            $equipment->TIENE_HIJOS = count($children) > 0 ? 'Si' : 'No';
            $equipments[$key] = $equipment;
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P01MEEQ',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó los equipamientos con tipo de código #$codeType.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $equipments);
    }

    public function generateGraphicArborescence(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'equipment_code' => 'required|string',
            'equipment_arborescence' => 'required|string',
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $equipmentCodeDec = $this->encryptionController->decrypt($form['equipment_code']);
        if(!$equipmentCodeDec){
            return $this->responseController->makeResponse(true, 'El código del equipamiento no fue encriptado correctamente.', [], 400);
        }

        $equipment = DB::table('S002V01TEQUI')->where([
            ['EQUI_NULI', '=', $form['linea']],
            ['EQUI_COEQ', '=', $equipmentCodeDec]
        ])->first();
        
        if(is_null($equipment)){
            return $this->responseController->makeResponse(true, 'El equipamiento solicitado no existe.', [], 404);
        }

        $arborescenceDec = $this->encryptionController->decrypt($form['equipment_arborescence']);
        if(!$arborescenceDec){
            return $this->responseController->makeResponse(true, 'El arreglo de la arborescencia no fue encriptado correctamente.', [], 400);
        }

        $materialIcons = [];
        $iconsLocation = $this->templatesUbic;
        $iconsLocation = str_replace("pdf_templates\\01_05_GEEQ\\", "global_resources\\mat_icons_png", $iconsLocation);

        if(!file_exists($iconsLocation)){
            return $this->responseController->makeResponse(true, 'No se pudo obtener la lista de iconos.', [], 404);
        }

        $iconsList = scandir($iconsLocation);
        foreach($iconsList as $category){
            if($category != '.' && $category != '..'){
                $categoryIcons = scandir("$iconsLocation\\$category");
                foreach($categoryIcons as $icon){
                    if($icon != '.' && $icon != '..'){
                        if(file_exists("$iconsLocation\\$category\\$icon\\materialicons\\48dp\\2x")){
                            $imgFiles = scandir("$iconsLocation\\$category\\$icon\\materialicons\\48dp\\2x");
                            if(count($imgFiles) == 3){
                                foreach($imgFiles as $imgStr){
                                    if($imgStr != '.' && $imgStr != '..'){
                                        $materialIcons[] = [
                                            'category' => $category,
                                            'icon' => $icon,
                                            'iconRoute' => "$iconsLocation\\$category\\$icon\\materialicons\\48dp\\2x\\$imgStr"
                                        ];
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }

        $html = file_get_contents($this->templatesUbic . "01-GEEQ-PL-010101-000001=01=PDF_ARBORESCENCIA.html");
        $arborescenceArr = json_decode($arborescenceDec, true);
        $tableBody = "";
        foreach($arborescenceArr as $level=>$item){
            $levelIndex = $level + 1;
            if(!array_key_exists('label', $item) || !array_key_exists('graph', $item)){
                return $this->responseController->makeResponse(true, "El elemento del nivel $levelIndex de la arborescencia tiene un formato inválido.", [], 404);
            }

            if($levelIndex == 1){
                $logo = file_get_contents("C:\inetpub\wwwroot\sam\storage\app\public\global_resources\sam-short-logo.png");
                $logoStr = "data:image/svg+xml;base64," . base64_encode($logo);
                $tableBody .= "
                    <tr>
                        <td class=\"td-label\">Línea 1</td>
                        <td style=\"padding: 8px; text-align:center;\">
                            <img src=\"$logoStr\" width=\"256px\">
                        </td>
                    </tr>
                ";
            }else if($levelIndex > 1 && $levelIndex <= 3){
                $graphArr = json_decode($item['graph'], true);
                if($graphArr['customIcon'] == 'N'){
                    $iconName = $graphArr['icon'];
                    $iconFilt = array_filter($materialIcons, function($v, $k) use ($iconName) {
                        return $v['icon'] == $iconName;
                    }, ARRAY_FILTER_USE_BOTH);

                    $iconObj = end($iconFilt);
                    $imageContent = file_get_contents($iconObj['iconRoute']);
                    $imageContentStr = "data:image/svg+xml;base64," . base64_encode($imageContent);
                    $tableBody .= "
                        <tr>
                            <td class=\"td-label\">$item[label]</td>
                            <td style=\"padding: 8px; text-align:center;\">
                                <img src=\"$imageContentStr\" width=\"128px\" height=\"128px\" style=\"opacity:0.6;\">
                            </td>
                        </tr>
                    ";
                }
            }else{
                $graphLocation = str_replace('http://git.ittec.mx/', '', $item['graph']);
                $graphLocation = str_replace('/', "\\", $graphLocation);

                $publicImagesLocation = str_replace('sam\storage\app\public\pdf_templates\01_05_GEEQ\\', '', $this->templatesUbic);
                $graphLocation = $publicImagesLocation . $graphLocation;

                if(file_exists($graphLocation)){
                    $graphSize = getimagesize($graphLocation);
                    $graphWidth = $graphSize[0];
                    $graphHeight = $graphSize[1];
                    $graphSizeStr = '';

                    if($graphWidth > $graphHeight){
                        $widthZoom = round($this->functionsController->floatDiv($graphWidth, 272));
                        $widthZoom = $widthZoom <= 0 ? 1 : $widthZoom;

                        $graphWidth = round($this->functionsController->floatDiv($graphWidth, $widthZoom));
                        $graphHeight = round($this->functionsController->floatDiv($graphHeight, $widthZoom));

                        $graphSizeStr = "width=\"" . $graphWidth . "px\" height=\"" . $graphHeight . "px\"";
                    }else if($graphWidth < $graphHeight){
                        $heightZoom = round($this->functionsController->floatDiv($graphHeight, 272));
                        $heightZoom = $heightZoom <= 0 ? 1 : $heightZoom;

                        $graphWidth = round($this->functionsController->floatDiv($graphWidth, $heightZoom));
                        $graphHeight = round($this->functionsController->floatDiv($graphHeight, $heightZoom));

                        $graphSizeStr = "width=\"" . $graphWidth . "px\" height=\"" . $graphHeight . "px\"";
                    }else{
                        $widthZoom = round($this->functionsController->floatDiv($graphWidth, 272));
                        $widthZoom = $widthZoom <= 0 ? 1 : $widthZoom;

                        $heightZoom = round($this->functionsController->floatDiv($graphHeight, 272));
                        $heightZoom = $heightZoom <= 0 ? 1 : $heightZoom;
                        

                        $graphWidth = round($this->functionsController->floatDiv($graphWidth, $widthZoom));
                        $graphHeight = round($this->functionsController->floatDiv($graphHeight, $heightZoom));

                        $graphSizeStr = "width=\"" . $graphWidth . "px\" height=\"" . $graphHeight . "px\"";
                    }

                    $labelArr = explode(' - ', $item['label']);
                    $graphContent = file_get_contents($graphLocation);
                    $graphContentStr ="data:image/svg+xml;base64," . base64_encode($graphContent);
                    $tableBody .= "
                        <tr>
                            <td class=\"td-label\">
                                <b>Código: </b>$labelArr[0]<br><br>
                                <b>Descripción: </b>$labelArr[1] - $labelArr[2]
                            </td>
                            <td style=\"padding: 8px; text-align:center;\">
                                <img src=\"$graphContentStr\" $graphSizeStr>
                            </td>
                        </tr>
                    ";
                }
            }
        }

        $html = str_replace('%tableBody%', $tableBody, $html);

        $elementCodeArr0 = explode('_', $equipmentCodeDec);
        $elementCodeStr0 = end($elementCodeArr0);
        $elementCodeArr1 = explode('.', $elementCodeStr0);
        $elementCodeStr = end($elementCodeArr1);

        $como = 'GEEQ';
        $cldo = 'IN';
        $noar = "arborescencia_$elementCodeStr";
        $exte = "pdf";
        $line = intval($form['linea']);
        $line = $line < 10 ? "0$line" : "$line";

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();

        $nowArr = explode(" ", $nowStr);
        $dateArr = explode("-", $nowArr[0]);
        $year = substr($dateArr[0], 2);
        $fecr = $year . $dateArr[1] .$dateArr[2];

        $sec = DB::table('S002V01TAFAL')->where([
            ['AFAL_NULI', '=', $line],
            ['AFAL_COMO', '=', $como],
            ['AFAL_CLDO', '=', $cldo],
        ])->orderBy('AFAL_NUSE', 'desc')->first();

        $nuse = is_null($sec) ? "1" : "" . intval($sec->AFAL_NUSE) + 1 . "";
        for($i = strlen($nuse); $i < 6; $i++){
            $nuse = "0$nuse";
        }

        $ver = DB::table('S002V01TAFAL')->where([
            ['AFAL_NULI', '=', $line],
            ['AFAL_COMO', '=', $como],
            ['AFAL_CLDO', '=', $cldo],
            ['AFAL_NOAR', '=', $noar],
            ['AFAL_EXTE', '=', $exte],
        ])->orderBy('AFAL_NUVE', 'desc')->first();

        $nuve = is_null($ver) ? "1" : "" . intval($ver->AFAL_NUVE) + 1 . "";
        for($i = strlen($nuve); $i < 2; $i++){
            $nuve = "0$nuve";
        }

        $filePath = 'C:\inetpub\wwwroot\sam\public_files\\';
        $fileName = "$line-$como-$cldo-$fecr-$nuse=$nuve=$noar.$exte";

        $dompdf = new Dompdf();
        $dompdf->loadHtml($html);
        $dompdf->setPaper('A4', 'portrait');
        $dompdf->render();

        $output = $dompdf->output();
        
        $tempFile = $filePath . $fileName;
        if(!file_exists($tempFile)){
            fopen($tempFile, 'w');
        }

        file_put_contents($tempFile, $output);
        $ubic = Storage::putFile('files', new File($tempFile));
        $ubic = str_replace("/", "\\", $ubic);
        $ubic = "C:\inetpub\wwwroot\sam\storage\app\\" . $ubic;
        $tama = filesize($ubic);
        $usac = json_encode([$idUser]);
        unlink($tempFile);

        DB::table('S002V01TAFAL')->insert([
            'AFAL_NULI' => $line,
            'AFAL_COMO' => $como,
            'AFAL_CLDO' => $cldo,
            'AFAL_FECR' => $fecr,
            'AFAL_NUSE' => $nuse,
            'AFAL_NUVE' => $nuve,
            'AFAL_NOAR' => $noar,
            'AFAL_EXTE' => $exte,
            'AFAL_TAMA' => $tama,
            'AFAL_UBIC' => $ubic,
            'AFAL_USAC' => $usac,
            'AFAL_USRE' => $idUser,
            'AFAL_FERE' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Registro',
            "El usuario $name (" . $usr->USUA_IDUS . ") generó el archivo de arborescencia del equipamiento $equipmentCodeDec.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', ['fileID' => $this->encryptionController->encrypt($fileName)]);
    }

    public function updateSecurityCriticality(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'equipment_code' => 'required|string',
            'criticality' => 'required|string',
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $equipmentCodeDec = $this->encryptionController->decrypt($form['equipment_code']);
        if(!$equipmentCodeDec){
            return $this->responseController->makeResponse(true, 'El código del equipamiento no fue encriptado correctamente.', [], 400);
        }

        $equipment = DB::table('S002V01TEQUI')->where([
            ['EQUI_NULI', '=', $form['linea']],
            ['EQUI_COEQ', '=', $equipmentCodeDec]
        ])->first();
        
        if(is_null($equipment)){
            return $this->responseController->makeResponse(true, 'El equipamiento solicitado no existe.', [], 404);
        }

        $criticality = $this->encryptionController->decrypt($form['criticality']);
        if(!$criticality){
            return $this->responseController->makeResponse(true, 'La criticidad seleccionada no fue encriptada correctamente.', [], 400);
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        DB::table('S002V01TEQUI')->where([
            ['EQUI_NULI', '=', $form['linea']],
            ['EQUI_COEQ', '=', $equipmentCodeDec]
        ])->update([
            'EQUI_CRSE' => $criticality,
            'EQUI_USMO' => $idUser,
            'EQUI_FEMO' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $form['linea'],
            'S002V01M07GEEQ',
            'S002V01F03GCSE',
            'S002V01P01GECR',
            'Actualización',
            "El usuario $name (" . $usr->USUA_IDUS . ") actualizó la criticidad de seguridad del equipamiento $equipmentCodeDec.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $form['linea']);
        return $this->responseController->makeResponse(false, 'EXITO.');
    }

    public function generateEquipmentFile(Request $request) {
        DB::enableQueryLog();
        $validator = Validator::make($request->all(), [
            'id_user' => 'required|string',
            'linea' => 'required|integer',
            'file_type' => 'required|string|in:PDF,XLS',
            'file_data' => 'required|string',
        ]);
 
        if($validator->fails()){
            return $this->responseController->makeResponse(
                true,
                "Se encontraron uno o más errores.",
                $this->responseController->makeErrors(
                    $validator->errors()->messages()
                ),
                401
            );
        }

        $form = $request->all();
        $idUser = $this->encryptionController->decrypt($form['id_user']);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID de usuario no fue encriptado correctamente.', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $form['linea']],
            ['USUA_IDUS', '=', $idUser]
        ])->first();
        
        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la petición no existe.', [], 404);
        }

        $fileData = $this->encryptionController->decrypt($form['file_data']);
        if(!$fileData){
            return $this->responseController->makeResponse(true, 'La información del equipamiento no fue encriptada correctamente.', [], 400);
        }

        $fileDataArr = json_decode($fileData, true);
        $spreadsheet = $this->generateEquipmentDataSheet($fileDataArr);

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        
        $dateTimeArr = explode(" ", $nowStr);
        $dateArr = explode("-", $dateTimeArr[0]);
        $year = substr($dateArr[0], 2);
        $como = 'GEEQ';
        $cldo = 'IN';
        $fecr = $year . $dateArr[1] . $dateArr[2];

        $sec = DB::table('S002V01TAFAL')->where([
            ['AFAL_NULI', '=', $form['linea']],
            ['AFAL_COMO', '=', $como],
            ['AFAL_CLDO', '=', $cldo],
        ])->orderBy('AFAL_NUSE', 'desc')->first();

        $nuse = "";
        if(is_null($sec)){
            $nuse = '000001';
        }else{
            $secu = "" . intval($sec->AFAL_NUSE) + 1 . "";
            $nuse = "";

            for($i = strlen($secu); $i < 6; $i++){
                $nuse .= "0";
            }

            $nuse = $nuse . $secu;
        }

        $equipmentCode = $fileDataArr['CODIGO'];
        $equipmentCodeArr0 = explode('_', $equipmentCode);
        $equipmentCodeArr1 = explode('.', $equipmentCodeArr0[1]);
        $equipmentCodeArr1 = array_reverse($equipmentCodeArr1);

        $timestamp = $now->timestamp;
        $noar = "ficha_descriptiva_$equipmentCodeArr1[0]_$timestamp";
        $exte = $form['file_type'] == 'XLS' ? "xlsx": 'pdf';

        $ver = DB::table('S002V01TAFAL')->where([
            ['AFAL_NULI', '=', $form['linea']],
            ['AFAL_COMO', '=', $como],
            ['AFAL_CLDO', '=', $cldo],
            ['AFAL_NOAR', '=', $noar],
            ['AFAL_EXTE', '=', $exte],
        ])->orderBy('AFAL_NUVE', 'desc')->first();

        $nuve = "";
        if(is_null($ver)){
            $nuve = "01";
        }else{
            $vers = intval($ver->AFAL_NUVE) + 1;
            $nuve = $vers < 10 ? "0$vers" : "$vers";
        }

        $line = $form['linea'] < 10 ? "0$form[linea]" : "$form[linea]";
        $filePath = 'C:\inetpub\wwwroot\sam\public_files\\';
        $fileName = "$line-$como-$cldo-$fecr-$nuse=$nuve=$noar.$exte";
        
        $tempFile = $filePath . $fileName;
        if(file_exists($tempFile)){
            unlink($tempFile);
        }

        if($form['file_type'] == 'XLS'){
            $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
        }else{
            $writer = new Mpdf($spreadsheet);
            $writer->setOrientation(PageSetup::ORIENTATION_LANDSCAPE);
        }

        $writer->save($tempFile);
        $ubic = Storage::putFile('files', new File($tempFile));
        $ubic = str_replace("/", "\\", $ubic);
        $ubic = "C:\inetpub\wwwroot\sam\storage\app\\" . $ubic;
        $tama = filesize($ubic);
        $usac = json_encode([$idUser]);
        unlink($tempFile);

        DB::table('S002V01TAFAL')->insert([
            'AFAL_NULI' => $line,
            'AFAL_COMO' => $como,
            'AFAL_CLDO' => $cldo,
            'AFAL_FECR' => $fecr,
            'AFAL_NUSE' => $nuse,
            'AFAL_NUVE' => $nuve,
            'AFAL_NOAR' => $noar,
            'AFAL_EXTE' => $exte,
            'AFAL_TAMA' => $tama,
            'AFAL_UBIC' => $ubic,
            'AFAL_USAC' => $usac,
            'AFAL_USRE' => $idUser,
            'AFAL_FERE' => $nowStr,
        ]);

        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            '-',
            'Registro',
            "El usuario $name (" . $usr->USUA_IDUS . ") generó la ficha descriptiva del equipamiento #$equipmentCode.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', ['fileID' => $this->encryptionController->encrypt($fileName)]);
    }

    private function generateEquipmentDataSheet($equipmentInfo) : Spreadsheet {
        $spreadsheet = new Spreadsheet;
        $spreadsheet->getProperties()
            ->setCreator('STC')
            ->setTitle('Ficha descriptiva de equipamiento.')
            ->setSubject('Ficha equipamiento')
            ->setKeywords('Ficha Técnica Equipamiento')
            ->setCategory('Fichas técnicas');

        $worksheet = $spreadsheet->getActiveSheet();
        $worksheet->setTitle('FICHA DESCRIPTIVA');

        $worksheet->mergeCells('B2:M2');
        $worksheet->setCellValue('B2', $equipmentInfo['CODIGO'])->getStyle('B2')->getFill()
            ->setFillType(Fill::FILL_SOLID)
            ->getStartColor()->setRGB('B7BCC4');
        $worksheet->getStyle('B2')->getFont()->setBold(true);
        $worksheet->getStyle('B2')->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);

        $worksheet->getColumnDimension('B')->setWidth(16);
        $worksheet->getColumnDimension('C')->setWidth(16);
        $worksheet->getColumnDimension('D')->setWidth(16);
        $worksheet->getColumnDimension('E')->setWidth(16);
        $worksheet->getColumnDimension('F')->setWidth(16);
        $worksheet->getColumnDimension('G')->setWidth(16);
        $worksheet->getColumnDimension('H')->setWidth(16);
        $worksheet->getColumnDimension('I')->setWidth(16);
        $worksheet->getColumnDimension('J')->setWidth(16);
        $worksheet->getColumnDimension('K')->setWidth(16);
        $worksheet->getColumnDimension('L')->setWidth(16);
        $worksheet->getColumnDimension('M')->setWidth(16);

        /*INICIO COLUMNA 1*/
        $worksheet->mergeCells('B3:E3');
        $worksheet->setCellValue('B3', "Tipo: $equipmentInfo[TIPO_EQUIPAMIENTO]");

        $worksheet->mergeCells('F3:I3');
        $worksheet->setCellValue('F3', "Modelo: $equipmentInfo[MODELO]");

        $worksheet->mergeCells('J3:M3');
        $worksheet->setCellValue('J3', "ID: $equipmentInfo[ID_EQUIPAMIENTO]");
        /*FIN COLUMNA 1*/

        /*INICIO COLUMNA 2*/
        $worksheet->mergeCells('B4:E4');
        $worksheet->setCellValue('B4', "Familia: $equipmentInfo[FAMILIA]");

        $worksheet->mergeCells('F4:I4');
        $worksheet->setCellValue('F4', "Subfamilia: $equipmentInfo[SUBFAMILIA]");

        $worksheet->mergeCells('J4:M4');
        $worksheet->setCellValue('J4', "Estado: $equipmentInfo[ESTADO]");
        /*FIN COLUMNA 2*/

        /*INICIO COLUMNA 3*/
        $worksheet->mergeCells('B5:E5');
        $worksheet->setCellValue('B5', "Jerarquía: $equipmentInfo[JERARQUIA]");

        $parentCode = is_null($equipmentInfo['EQUIPO_PADRE']) ? '-' : $equipmentInfo['EQUIPO_PADRE'];
        $worksheet->mergeCells('F5:M5');
        $worksheet->setCellValue('F5', "Equipo padre: $parentCode");
        /*FIN COLUMNA 3*/

        /*INICIO COLUMNA 4*/
        $worksheet->mergeCells('B6:D6');
        $worksheet->setCellValue('B6', "Tipo de codificación: $equipmentInfo[TIPO_CODIGO]");

        $worksheet->mergeCells('E6:G6');
        $worksheet->setCellValue('E6', "Ubicación de origen: $equipmentInfo[UBICACION_ORIGEN]");

        $worksheet->mergeCells('H6:J6');
        $worksheet->setCellValue('H6', "Nivel de origen: $equipmentInfo[NIVEL_ORIGEN]");

        $worksheet->mergeCells('K6:M6');
        $worksheet->setCellValue('K6', "Ocupación de origen: $equipmentInfo[OCUPACION_ORIGEN]");
        /*FIN COLUMNA 4*/

        /*INICIO COLUMNA 5*/
        $worksheet->mergeCells('B7:D7');
        $worksheet->setCellValue('B7', "Elemento de origen: $equipmentInfo[ELEMENTO_ORIGEN]");

        $pccIntersection = is_null($equipmentInfo['INTERSECCION_PCC']) ? 'No aplica' : $equipmentInfo['INTERSECCION_PCC'];
        $worksheet->mergeCells('E7:G7');
        $worksheet->setCellValue('E7', "Intersección en PCC: $pccIntersection");

        $pccPosition = is_null($equipmentInfo['POSICION_PCC']) ? 'No aplica' : $equipmentInfo['POSICION_PCC'];
        $worksheet->mergeCells('H7:J7');
        $worksheet->setCellValue('H7', "Posición en PCC: $pccPosition");

        $pccPosition = is_null($equipmentInfo['KILOMETRO_ORIGEN']) ? 'No aplica' : $equipmentInfo['KILOMETRO_ORIGEN'];
        $worksheet->mergeCells('K7:M7');
        $worksheet->setCellValue('K7', "Kilómetro de origen: $pccPosition");
        /*FIN COLUMNA 5*/

        /*INICIO COLUMNA 6*/
        $trainArea = is_null($equipmentInfo['AREA_TREN']) ? 'No aplica' : $equipmentInfo['AREA_TREN'];
        $worksheet->mergeCells('B8:D8');
        $worksheet->setCellValue('B8', "Área del tren: $trainArea");

        $originElementSecuence = is_null($equipmentInfo['SECUENCIA_ELEMENTO_ORIGEN']) ? 'No aplica' : $equipmentInfo['SECUENCIA_ELEMENTO_ORIGEN'];
        $worksheet->mergeCells('E8:G8');
        $worksheet->setCellValue('E8', "Secuencia del elemento de origen: $originElementSecuence");

        $originCodificationType = is_null($equipmentInfo['TIPO_CODIFICACION_ORIGEN']) ? 'No aplica' : $equipmentInfo['TIPO_CODIFICACION_ORIGEN'];
        $worksheet->mergeCells('H8:J8');
        $worksheet->setCellValue('H8', "Tipo de codificación de origen: $originCodificationType");

        $originElementCode = is_null($equipmentInfo['CODIGO_ELEMENTO_ORIGEN']) ? 'No aplica' : $equipmentInfo['CODIGO_ELEMENTO_ORIGEN'];
        $worksheet->mergeCells('K8:M8');
        $worksheet->setCellValue('K8', "Código del elemento de origen: $originElementCode");
        /*FIN COLUMNA 6*/

        /*INICIO COLUMNA 7*/
        $destinyLocation = is_null($equipmentInfo['UBICACION_DESTINO']) ? 'No aplica' : $equipmentInfo['UBICACION_DESTINO'];
        $worksheet->mergeCells('B9:D9');
        $worksheet->setCellValue('B9', "Ubicación de destino: $destinyLocation");

        $destinyLevel = is_null($equipmentInfo['NIVEL_DESTINO']) ? 'No aplica' : $equipmentInfo['NIVEL_DESTINO'];
        $worksheet->mergeCells('E9:G9');
        $worksheet->setCellValue('E9', "Nivel de destino: $destinyLevel");

        $destinyOccupation = is_null($equipmentInfo['OCUPACION_DESTINO']) ? 'No aplica' : $equipmentInfo['OCUPACION_DESTINO'];
        $worksheet->mergeCells('H9:J9');
        $worksheet->setCellValue('H9', "Ocupación de destino: $destinyOccupation");

        $destinyElement = is_null($equipmentInfo['ELEMENTO_DESTINO']) ? 'No aplica' : $equipmentInfo['ELEMENTO_DESTINO'];
        $worksheet->mergeCells('K9:M9');
        $worksheet->setCellValue('K9', "Elemento de destino: $destinyElement");
        /*FIN COLUMNA 7*/

        /*INICIO COLUMNA 8*/
        $destinyKilometer = is_null($equipmentInfo['KILOMETRO_DESTINO']) ? 'No aplica' : $equipmentInfo['KILOMETRO_DESTINO'];
        $worksheet->mergeCells('B10:D10');
        $worksheet->setCellValue('B10', "Kilómetro de destino: $destinyKilometer");

        $destinyElementSecuence = is_null($equipmentInfo['SECUENCIA_ELEMENTO_DESTINO']) ? 'No aplica' : $equipmentInfo['SECUENCIA_ELEMENTO_DESTINO'];
        $worksheet->mergeCells('E10:G10');
        $worksheet->setCellValue('E10', "Secuencia del elemento de destino: $destinyElementSecuence");

        $destinyCodificationType = is_null($equipmentInfo['TIPO_CODIFICACION_DESTINO']) ? 'No aplica' : $equipmentInfo['TIPO_CODIFICACION_DESTINO'];
        $worksheet->mergeCells('H10:J10');
        $worksheet->setCellValue('H10', "Tipo de codificación de destino: $destinyCodificationType");

        $destinyElementCode = is_null($equipmentInfo['CODIGO_ELEMENTO_DESTINO']) ? 'No aplica' : $equipmentInfo['CODIGO_ELEMENTO_DESTINO'];
        $worksheet->mergeCells('K10:M10');
        $worksheet->setCellValue('K10', "Código del elemento de destino: $destinyElementCode");
        /*FIN COLUMNA 8*/

        /*INICIO COLUMNA 9*/
        $criticalityLevel = !isset($equipmentInfo['NIVEL_CRITICIDAD_OBJ']) ? 'No configurado' : $equipmentInfo['NIVEL_CRITICIDAD_OBJ']['label'];
        $worksheet->mergeCells('B11:D11');
        $worksheet->setCellValue('B11', "Nivel de criticidad de seguridad: $criticalityLevel");

        $worksheet->mergeCells('E11:G11');
        $worksheet->setCellValue('E11', "Fecha de adquisición: $equipmentInfo[FECHA_ADQUISICION]");

        $worksheet->mergeCells('H11:J11');
        $worksheet->setCellValue('H11', "Fecha de inicio de la garantía: $equipmentInfo[FECHA_INICIO_GARANTIA]");

        $worksheet->mergeCells('K11:M11');
        $worksheet->setCellValue('K11', "Fecha de término de la garantía: $equipmentInfo[FECHA_TERMINO_GARANTIA]");
        /*FIN COLUMNA 9*/

        /*INICIO COLUMNA 10*/
        $worksheet->mergeCells('B12:D12');
        $worksheet->setCellValue('B12', "Proveedor: $equipmentInfo[PROVEEDOR]");

        $requiredSoftware = is_null($equipmentInfo['TIPO_CODIFICACION_DESTINO']) ? 'Ningúno' : $equipmentInfo['TIPO_CODIFICACION_DESTINO'];
        $worksheet->mergeCells('E12:G12');
        $worksheet->setCellValue('E12', "Software requerido: $requiredSoftware");

        $softwareVersion = is_null($equipmentInfo['VERSION_SOFTWARE']) ? 'No aplica' : $equipmentInfo['VERSION_SOFTWARE'];
        $worksheet->mergeCells('H12:J12');
        $worksheet->setCellValue('H12', "Versión del software: $softwareVersion");

        $worksheet->mergeCells('K12:M12');
        $worksheet->setCellValue('K12', "Estado de funcionamiento: $equipmentInfo[ESTADO_FUNCIONAMIENTO]");
        /*FIN COLUMNA 10*/

        /*INICIO COLUMNA 11*/
        $worksheet->mergeCells('B13:G13');
        $worksheet->setCellValue('B13', "Usuario que registró: $equipmentInfo[USUARIO_REGISTRO]");

        $worksheet->mergeCells('H13:M13');
        $worksheet->setCellValue('H13', "Fecha de registro: $equipmentInfo[FECHA_REGISTRO]");
        /*FIN COLUMNA 11*/

        /*INICIO COLUMNA 12*/
        $usrMod = is_null($equipmentInfo['USUARIO_MODIFICACION']) ? '-' : $equipmentInfo['USUARIO_MODIFICACION'];
        $worksheet->mergeCells('B14:G14');
        $worksheet->setCellValue('B14', "Usuario que modificó: $usrMod");

        $fecMod = is_null($equipmentInfo['FECHA_MODIFICACION']) ? '-' : $equipmentInfo['FECHA_MODIFICACION'];
        $worksheet->mergeCells('H14:M14');
        $worksheet->setCellValue('H14', "Fecha última modificación: $fecMod");
        /*FIN COLUMNA 12*/

        $startRow = 2;
        $startCol = 2;
        $maxRow = $startRow + 12;
        $maxCol = $startCol + 11;

        for($row = $startRow; $row <= $maxRow; $row++){
            for($col = $startCol; $col <= $maxCol; $col++){
                $colStr = Coordinate::stringFromColumnIndex($col);

                $worksheet->getStyle($colStr . $row)->getBorders()->getOutline()->setBorderStyle(Border::BORDER_THIN)->setColor(new Color('55000000'));
            }
        }
        return $spreadsheet;
    }

    public function getEquipmentTypes($idUser, $line){
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $equipmentTypes = DB::table('S002V01TEQUI')->select([
            DB::raw('COUNT(*) AS CANTIDAD_EQUIPAMIENTOS'),
            'EQUI_TIPO AS TIPO_EQUIPAMIENTO',
        ])->groupBy('EQUI_TIPO')->get()->all();

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P12GCTE',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó la cantidad de equipamientos por tipo.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $equipmentTypes);
    }

    public function getEquipmentsByType($equipmentType, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $equipmentType = urldecode($equipmentType);
        $equipments = DB::table('S002V01TEQUI')->select([
            'EQUI_COEQ AS CODIGO',
            'EQUI_TIPO AS TIPO',
            'EQUI_MODE AS MODELO',
            'EQUI_IDEQ AS ID_EQUIPO',
            'EQUI_ESFU AS ESTADO_FUNCIONAMIENTO',
            'EQUI_GAIM AS GALERIA_IMAGENES',
            'EQUI_ELOR AS ELEMENTO_ORIGEN',
            'EQUI_TICO AS TIPO_CODIGO',
            'EQUI_EQPA AS EQUIPO_PADRE',
        ])->where([
            ['EQUI_NULI', '=', $line],
            ['EQUI_TIPO', '=', $equipmentType],
        ])->get()->all();

        $idUserEnc = $this->encryptionController->encrypt($idUser);
        foreach($equipments as $key=>$equipment){
            $children = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $line],
                ['EQUI_EQPA', '=', $equipment->CODIGO],
            ])->get()->all();

            $equipment->CODIGO = $this->encryptionController->encrypt($equipment->CODIGO);
            $equipment->ID_EQUIPO = $this->encryptionController->encrypt($equipment->ID_EQUIPO);
            $equipment->EQUIPO_PADRE = is_null($equipment->EQUIPO_PADRE) ? null : $this->encryptionController->encrypt($equipment->EQUIPO_PADRE);

            $imagesGalleryArr = json_decode($equipment->GALERIA_IMAGENES, true);
            $imagesGalleryFn = [];
            foreach($imagesGalleryArr as $imageCode){
                $imageCodeEnc = $this->encryptionController->encrypt($imageCode);
                $publicUri = $this->documentManagementController->privateGetPublicDocumentURL(
                    $imageCodeEnc,
                    $idUserEnc,
                    $line
                );

                $response = json_decode($publicUri->original, true);
                if($response['error']){
                    return $this->responseController->makeresponse(true, $response['msg'], [], 500);
                }else{
                    $uriEnc = $this->encryptionController->encrypt($response['response']['public_uri']);
                    $imagesGalleryFn[] = $uriEnc;
                }
            }

            $equipment->GALERIA_IMAGENES = json_encode($imagesGalleryFn);
            $equipment->TIENE_HIJOS = count($children) > 0 ? 'Si' : 'No';
            $equipments[$key] = $equipment;
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P12GCTE',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó los equipamientos de tipo $equipmentType.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $equipments);
    }

    public function getEquipmentsByKilometer($startPK, $endPK, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $startPK = floatval($startPK);
        $endPK = floatVal($endPK);

        $equipments = DB::table('S002V01TEQUI')->select([
            'EQUI_COEQ AS CODIGO',
            'EQUI_TIPO AS TIPO',
            'EQUI_MODE AS MODELO',
            'EQUI_IDEQ AS ID_EQUIPO',
            'EQUI_ESFU AS ESTADO_FUNCIONAMIENTO',
            'EQUI_GAIM AS GALERIA_IMAGENES',
            'EQUI_ELOR AS ELEMENTO_ORIGEN',
            'EQUI_TICO AS TIPO_CODIGO',
            'EQUI_EQPA AS EQUIPO_PADRE',
            'EQUI_KIOR AS KILOMETRO_ORIGEN',
            'EQUI_KIDE AS KILOMETRO_DESTINO'
        ])->where('EQUI_NULI', '=', $line)
        ->whereBetween('EQUI_KIOR', [$startPK, $endPK])
        ->orWhereBetween('EQUI_KIDE', [$startPK, $endPK])->get()->all();

        foreach($equipments as $key=>$equipment){
            $children = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $line],
                ['EQUI_EQPA', '=', $equipment->CODIGO],
            ])->get()->all();

            $equipment->CODIGO = $this->encryptionController->encrypt($equipment->CODIGO);
            $equipment->ID_EQUIPO = $this->encryptionController->encrypt($equipment->ID_EQUIPO);
            $equipment->EQUIPO_PADRE = is_null($equipment->EQUIPO_PADRE) ? null : $this->encryptionController->encrypt($equipment->EQUIPO_PADRE);
            $equipment->GALERIA_IMAGENES = $this->encryptionController->encrypt($equipment->GALERIA_IMAGENES);
            $equipment->TIENE_HIJOS = count($children) > 0 ? 'Si' : 'No';

            $equipments[$key] = $equipment;
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P13LOEQ',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó los equipamientos entre los kilómetros $startPK y $endPK.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $equipments);
    }

    public function getEquipmentsByTrainArea($car, $area, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $car = $this->encryptionController->decrypt($car);
        if(!$car){
            return $this->responseController->makeResponse(true, 'El código del coche no está encriptado correctamente', [], 400);
        }

        $area = $this->encryptionController->decrypt($area);
        if(!$area){
            return $this->responseController->makeResponse(true, 'El código del área no está encriptado correctamente', [], 400);
        }

        $equipments = DB::table('S002V01TEQUI')->select([
            'EQUI_COEQ AS CODIGO',
            'EQUI_TIPO AS TIPO',
            'EQUI_MODE AS MODELO',
            'EQUI_IDEQ AS ID_EQUIPO',
            'EQUI_ESFU AS ESTADO_FUNCIONAMIENTO',
            'EQUI_GAIM AS GALERIA_IMAGENES',
            'EQUI_ELOR AS ELEMENTO_ORIGEN',
            'EQUI_TICO AS TIPO_CODIGO',
            'EQUI_EQPA AS EQUIPO_PADRE',
        ])->where([
            ['EQUI_NULI', '=', $line],
            ['EQUI_OCOR', '=', $car],
            ['EQUI_ARTR', '=', $area]
        ])->get()->all();

        foreach($equipments as $key=>$equipment){
            $children = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $line],
                ['EQUI_EQPA', '=', $equipment->CODIGO],
            ])->get()->all();

            $equipment->CODIGO = $this->encryptionController->encrypt($equipment->CODIGO);
            $equipment->ID_EQUIPO = $this->encryptionController->encrypt($equipment->ID_EQUIPO);
            $equipment->EQUIPO_PADRE = is_null($equipment->EQUIPO_PADRE) ? null : $this->encryptionController->encrypt($equipment->EQUIPO_PADRE);
            $equipment->GALERIA_IMAGENES = $this->encryptionController->encrypt($equipment->GALERIA_IMAGENES);
            $equipment->TIENE_HIJOS = count($children) > 0 ? 'Si' : 'No';

            $equipments[$key] = $equipment;
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P13LOEQ',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó los equipamientos del área $area en el coche $car.",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $equipments);
    }

    public function getEquipmentsByPCCIntersection($intersection, $element, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $intersection = $this->encryptionController->decrypt($intersection);
        if(!$intersection){
            return $this->responseController->makeResponse(true, 'La interección no está encriptada correctamente', [], 400);
        }

        $element = $this->encryptionController->decrypt($element);
        if(!$element){
            return $this->responseController->makeResponse(true, 'El elemento de la intersección no está encriptado correctamente', [], 400);
        }

        $equipments = DB::table('S002V01TEQUI')->select([
            'EQUI_COEQ AS CODIGO',
            'EQUI_TIPO AS TIPO',
            'EQUI_MODE AS MODELO',
            'EQUI_IDEQ AS ID_EQUIPO',
            'EQUI_ESFU AS ESTADO_FUNCIONAMIENTO',
            'EQUI_GAIM AS GALERIA_IMAGENES',
            'EQUI_ELOR AS ELEMENTO_ORIGEN',
            'EQUI_TICO AS TIPO_CODIGO',
            'EQUI_EQPA AS EQUIPO_PADRE',
        ])->where([
            ['EQUI_NULI', '=', $line],
            ['EQUI_IPCC', '=', $intersection],
        ])->orWhere([
            ['EQUI_ELOR', 'LIKE', "%$element%"],
            ['EQUI_ELDE', 'LIKE', "%$element%"],
        ])->get()->all();

        foreach($equipments as $key=>$equipment){
            $children = DB::table('S002V01TEQUI')->where([
                ['EQUI_NULI', '=', $line],
                ['EQUI_EQPA', '=', $equipment->CODIGO],
            ])->get()->all();

            $equipment->CODIGO = $this->encryptionController->encrypt($equipment->CODIGO);
            $equipment->ID_EQUIPO = $this->encryptionController->encrypt($equipment->ID_EQUIPO);
            $equipment->EQUIPO_PADRE = is_null($equipment->EQUIPO_PADRE) ? null : $this->encryptionController->encrypt($equipment->EQUIPO_PADRE);
            $equipment->GALERIA_IMAGENES = $this->encryptionController->encrypt($equipment->GALERIA_IMAGENES);
            $equipment->TIENE_HIJOS = count($children) > 0 ? 'Si' : 'No';

            $equipments[$key] = $equipment;
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P13LOEQ',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó los equipamientos de la intersección $intersection del PCC",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $equipments);
    }

    public function getArborescenceByDate($date, $idUser, $line) {
        DB::enableQueryLog();

        $idUser = $this->encryptionController->decrypt($idUser);
        if(!$idUser){
            return $this->responseController->makeResponse(true, 'El ID del usuario que realizó la solicitud no está encriptado correctamente', [], 400);
        }

        $usr = DB::table('S002V01TUSUA')->where([
            ['USUA_NULI', '=', $line],
            ['USUA_IDUS', '=', $idUser],
        ])->first();

        if(is_null($usr)){
            return $this->responseController->makeResponse(true, 'El usuario que realizó la consulta no está registrado', [], 404);
        }

        $dateArr = explode('-', $date);
        if(count($dateArr) != 3){
            return $this->responseController->makeResponse(true, 'La fecha enviada no tiene un formato correcto YYYY-MM-DD.', [], 400);
        }

        $validDate = checkdate(intval($dateArr[1]), intval($dateArr[2]), intval($dateArr[0]));
        if(!$validDate){
            return $this->responseController->makeResponse(true, 'La fecha enviada es inválida.', [], 400);
        }

        $searchDate = new Carbon($date);
        //CONSTRUCCIÓN DE LA ARBORESCENCIA
        //Paso 1: Consultar las familias
        $families = DB::table('S002V01TFAMI')->select([
            'FAMI_COFA AS CODIGO_FAMILIA',
            'FAMI_NOFA AS NOMBRE_FAMILIA',
        ])->where([
            ['FAMI_ESTA', '=', 'Activo'],
            ['FAMI_NULI', '=', $line]
        ])->get()->all();

        $familyArborescenceArr = [];
        foreach($families as $family){
            //Paso 2: Consultar las subfamilias de cada familia
            $subfamilies = DB::table('S002V01TSUBF')->select([
                'SUBF_COSU AS CODIGO_SUBFAMILIA',
                'SUBF_NOSU AS NOMBRE_SUBFAMILIA',
            ])->where([
                ['SUBF_NULI', '=', $line],
                ['SUBF_COFA', '=', $family->CODIGO_FAMILIA],
                ['SUBF_ESTA', '=', 'Activo']
            ])->get()->all();

            $subfamilyArborescenceArr = [];
            foreach($subfamilies as $subfamily){
                //Paso 3: Consultar los equipamientos padre
                $equipments = DB::table('S002V01TEQUI')->select([
                    'EQUI_TIPO AS TIPO_EQUIPAMIENTO',
                    'EQUI_MODE AS MODELO_EQUIPAMIENTO',
                    'EQUI_IDEQ AS ID_EQUIPAMIENTO',
                    'EQUI_HICO AS HISTORIAL_CODIGOS'
                ])->where([
                    ['EQUI_NULI', '=', $line],
                    ['EQUI_FAMI', '=', $family->CODIGO_FAMILIA],
                    ['EQUI_SUBF', '=', $subfamily->CODIGO_SUBFAMILIA],
                    ['EQUI_JERA', '=', 'Padre'],
                ])->get()->all();

                $equipmentArborescenceArr = [];
                foreach($equipments as $equipment){
                    $codesHistory = json_decode($equipment->HISTORIAL_CODIGOS, true);
                    $codeFilt = array_filter($codesHistory, function($v, $k) use ($searchDate){
                        $codeDate = new Carbon($v['FECHA']);
                        return $codeDate->lte($searchDate);
                    }, ARRAY_FILTER_USE_BOTH);

                    if(count($codeFilt) > 0){
                        $lastCode = end($codeFilt);
                        $children = $this->getEquipmentChildren(
                            $lastCode['CODIGO'],
                            $line,
                            $family,
                            $subfamily,
                            $searchDate
                        );
    
                        $equipmentElement = $lastCode['CODIGO'] . ' - ' . $equipment->TIPO_EQUIPAMIENTO . ' - ' . $equipment->MODELO_EQUIPAMIENTO . ' (' . $equipment->ID_EQUIPAMIENTO . ')';
                        $equipmentArborescenceArr[] = [
                            'ELEMENTO' => $this->encryptionController->encrypt($equipmentElement),
                            'HIJOS' => $children,
                        ];
                    }
                }

                $subfamilyElement = $subfamily->NOMBRE_SUBFAMILIA . ' (' . $subfamily->CODIGO_SUBFAMILIA . ')';
                $subfamilyArborescenceArr[] = [
                    'ELEMENTO' => $this->encryptionController->encrypt($subfamilyElement),
                    'HIJOS' => $equipmentArborescenceArr,
                ];
            }

            $familyElement = $family->NOMBRE_FAMILIA . ' (' . $family->CODIGO_FAMILIA . ')';
            $familyArborescenceArr[] = [
                'ELEMENTO' => $this->encryptionController->encrypt($familyElement),
                'HIJOS' => $subfamilyArborescenceArr,
            ];
        }

        $now = $this->functionsController->now();
        $nowStr = $now->toDateTimeString();
        $actions = DB::getQueryLog();
        $name = $this->functionsController->joinName($usr->USUA_NOMB, $usr->USUA_APPA, $usr->USUA_APMA);
        
        $idac = $this->functionsController->registerActivity(
            $line,
            'S002V01M07GEEQ',
            'S002V01F01ADEQ',
            'S002V01P14VAFD',
            'Consulta',
            "El usuario $name (" . $usr->USUA_IDUS . ") consultó la arborescencia en la fecha $date",
            $idUser,
            $nowStr,
        );

        $this->functionsController->registerLog($actions, $idUser, $nowStr, $idac, $line);
        return $this->responseController->makeResponse(false, 'EXITO.', $familyArborescenceArr);
    }

    private function getEquipmentChildren($equipmentCode, $line, $family, $subfamily, $searchDate) {
        $children = DB::table('S002V01TEQUI')->select([
            'EQUI_TIPO AS TIPO_EQUIPAMIENTO',
            'EQUI_MODE AS MODELO_EQUIPAMIENTO',
            'EQUI_IDEQ AS ID_EQUIPAMIENTO',
            'EQUI_HICO AS HISTORIAL_CODIGOS'
        ])->where([
            ['EQUI_NULI', '=', $line],
            ['EQUI_FAMI', '=', $family->CODIGO_FAMILIA],
            ['EQUI_SUBF', '=', $subfamily->CODIGO_SUBFAMILIA],
            ['EQUI_JERA', '=', 'Hijo'],
        ])->whereRaw("JSON_SEARCH(
            EQUI_HICO, 'one', ?, NULL, '$[*].PADRE'
        )", [$equipmentCode])->get()->all();

        $childrenFn = [];
        foreach($children as $child){
            $codesHistory = json_decode($child->HISTORIAL_CODIGOS, true);
            $codeFilt = array_filter($codesHistory, function($v, $k) use ($searchDate){
                $codeDate = new Carbon($v['FECHA']);
                return $codeDate->lte($searchDate);
            }, ARRAY_FILTER_USE_BOTH);

            if(count($codeFilt) > 0){
                $lastCode = end($codeFilt);
                $children = $this->getEquipmentChildren(
                    $lastCode['CODIGO'],
                    $line,
                    $family,
                    $subfamily,
                    $searchDate
                );
                
                $childElement = $lastCode['CODIGO'] . ' - ' . $child->TIPO_EQUIPAMIENTO . ' - ' . $child->MODELO_EQUIPAMIENTO . ' (' . $child->ID_EQUIPAMIENTO . ')';
                $childrenFn[] = [
                    'ELEMENTO' => $this->encryptionController->encrypt($childElement),
                    'HIJOS' => $children,
                ];
            }
        }

        return $childrenFn;
    }
}