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

<?php
/*
    Desarrollador: Ing. Jean Jairo Benitez Meza
    Ultima Modificación: 11/04/2023
    Módulo: Gestión de Adquisiciones
*/
namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use App\Http\Controllers\ResponseController;
use App\Http\Controllers\EncryptionController;
use Illuminate\Http\Request;
use Illuminate\Support\Carbon;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Validator;
use \Mpdf\Mpdf as PDF; 

use PhpOffice\PhpSpreadsheet\Calculation\Category;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Worksheet\Table;
use PhpOffice\PhpSpreadsheet\Worksheet\Table\TableStyle;


class ProviderController extends Controller{

    private $responseController;
    private $encController;
    private $resourcesController;

    private $arrAlphabet = array("A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","U","V","W","X","Y","Z");

    private $arrHeader = array(
        array(
            'POSITION' => 'A',
            'CODE' => 'ARTI_IDAR',
            'COLUMN' => 'ID Artículo',
            'OBLIGATORY' => true
        ),
        array(
            'POSITION' => 'B',
            'CODE' => 'ARTI_NOMB',
            'COLUMN' => 'Artículo',
            'OBLIGATORY' => true
        ),
        array(
            'POSITION' => 'C',
            'CODE' => 'FAMI_NOMB',
            'COLUMN' => 'Familia',
            'OBLIGATORY' => true
        ),
        array(
            'POSITION' => 'D',
            'CODE' => 'SUBF_NOMB',
            'COLUMN' => 'Subfamilia',
            'OBLIGATORY' => true
        ),
        array(
            'POSITION' => 'E',
            'CODE' => 'ARTI_CODI',
            'COLUMN' => 'Código de Barra',
            'OBLIGATORY' => true
        ),
        array(
            'POSITION' => 'F',
            'CODE' => 'DEAR_COWE',
            'COLUMN' => 'Compra Web',
            'OBLIGATORY' => true
        ),
        array(
            'POSITION' => 'G',
            'CODE' => 'DEAR_IDUN',
            'COLUMN' => 'Tipo de Unidad',
            'OBLIGATORY' => true
        ),
        array(
            'POSITION' => 'H',
            'CODE' => 'DEAR_DESC',
            'COLUMN' => 'Descripción',
            'OBLIGATORY' => true
        ),
        array(
            'POSITION' => 'I',
            'CODE' => 'DEAR_CARA',
            'COLUMN' => 'Características',
            'OBLIGATORY' => false
        ),
    );

    private $arrHeaderDetails = array(
        array(
            'POSITION' => 'A',
            'CODE' => 'INAR_IDIN',
            'COLUMN' => 'ID Detalle',
            'OBLIGATORY' => true,
        ),
        array(
            'POSITION' => 'B',
            'CODE' => 'INAR_CODI',
            'COLUMN' => 'Código',
            'OBLIGATORY' => true,
        ),
        array(
            'POSITION' => 'C',
            'CODE' => 'INAR_MODE',
            'COLUMN' => 'Modelo',
            'OBLIGATORY' => true,
        ),
        array(
            'POSITION' => 'D',
            'CODE' => 'INAR_PREC',
            'COLUMN' => 'Precio',
            'OBLIGATORY' => true,
        ),
        array(
            'POSITION' => 'E',
            'CODE' => 'INAR_MONE',
            'COLUMN' => 'Moneda',
            'OBLIGATORY' => true,
        ),
        array(
            'POSITION' => 'F',
            'CODE' => 'INAR_MOMI',
            'COLUMN' => 'Monto Mínimo',
            'OBLIGATORY' => true,
        ),
        array(
            'POSITION' => 'G',
            'CODE' => 'INAR_CARA',
            'COLUMN' => 'Características',
            'OBLIGATORY' => true,
        ),
    );

    public function __construct() {
        $this->responseController = new ResponseController();
        $this->encController = new EncryptionController();
        $this->resourcesController = new ResourcesController();
    }

    public function getAllProvider($line){
        try {
            $arrProvider = DB::table('S002V01TPROV')
                ->where('PROV_NULI', '=', $line)
                ->get([
                    'PROV_NUPR AS NUMERO_PROVEEDOR',
                    'PROV_NOCO AS RAZON_SOCIAL',
                    'PROV_NOMB AS NOMBRE',
                    'PROV_APPA AS PRIMER_APELLIDO',
                    'PROV_APMA AS SEGUNDO_APELLIDO',
                    'PROV_CORR AS CORREO',
                    'PROV_LAD1 AS LADA1',
                    'PROV_TEL1 AS TELEFONO1',
                    'PROV_LAD2 AS LADA2',
                    'PROV_TEL2 AS TELEFONO2',
                    'PROV_XRFC AS RFC',
                    'PROV_XTAX AS TAXID',
                    'PROV_CORF AS REGIMEN_FISCAL',
                    'PROV_TIPO AS TIPO_EMPRESA',
                    'PROV_SIWE AS SITIO_WEB',
                    'PROV_MEPA AS METODO_PAGO',
                    'PROV_ESTA AS ESTADO',
                    'PROV_USRE AS USUARIO_REGISTRA',
                    'PROV_FERE AS FECHA_REGISTRA',
                    'PROV_USMO AS USUARIO_MODIFICA',
                    'PROV_FEMO AS FECHA_MODIFICA',
                ]);


            $arrResponse = array();
            foreach ($arrProvider as $provider) {
                $provider = (array) $provider;
                $provider['SEGUNDO_APELLIDO'] = $provider['SEGUNDO_APELLIDO'] == null ? '' : $provider['SEGUNDO_APELLIDO'];

                $arrReferences = DB::table('S002V01TPRRE')
                    ->where('PRRE_NULI', '=', $line)
                    ->where('PRRE_ESTA', '=', 'Activo')
                    ->where('PRRE_NUPR', '=', $provider['NUMERO_PROVEEDOR'])
                    ->get([
                        'PRRE_IDRE AS NUMERO_REFERENCIA',
                        'PRRE_EMPR AS EMPRESA',
                        'PRRE_CORR AS CORREO',
                        'PRRE_LADA AS LADA',
                        'PRRE_TELE AS TELEFONO',
                        'PRRE_XRFC AS RFC',
                        'PRRE_DIRE AS DIRECCION',
                        'PRRE_ESTA AS ESTADO',
                        'PRRE_USRE AS USUARIO_REGISTRA',
                        'PRRE_FERE AS FECHA_REGISTRA',
                        'PRRE_USMO AS USUARIO_MODIFICA',
                        'PRRE_FEMO AS FECHA_MODIFICA',
                    ]);

                $arrContacts = DB::table('S002V01TPRCO')
                    ->where('PRCO_NULI', '=', $line)
                    ->where('PRCO_ESTA', '=', 'Activo')
                    ->where('PRCO_NUPR', '=', $provider['NUMERO_PROVEEDOR'])
                    ->get([
                        'PRCO_IDCP AS NUMERO_CONTACTO',
                        'PRCO_NOMB AS NOMBRE_CONTACTO',
                        'PRCO_TIPO AS TIPO_CONTACTO',
                        'PRCO_CALL AS CALLE',
                        'PRCO_NUEX AS NUMERO_EXTERIOR',
                        'PRCO_NUIN AS NUMERO_INTERIOR',
                        'PRCO_COPO AS CODIGO_POSTAL',
                        'PRCO_COLO AS COLONIA',
                        'PRCO_MUNI AS MUNICIPIO',
                        'PRCO_ENTI AS ENTIDAD',
                        'PRCO_PAIS AS PAIS',
                        'PRCO_LAD1 AS LADA1',
                        'PRCO_TEL1 AS TELEFONO1',
                        'PRCO_LAD2 AS LADA2',
                        'PRCO_TEL2 AS TELEFONO2',
                        'PRCO_COR1 AS CORREO1',
                        'PRCO_COR2 AS CORREO2',
                        'PRCO_OBSE AS OBSERVACIONES',
                        'PRCO_ESTA AS ESTADO',
                        'PRCO_USRE AS USUARIO_REGISTRA',
                        'PRCO_FERE AS FECHA_REGISTRA',
                        'PRCO_USMO AS USUARIO_MODIFICA',
                        'PRCO_FEMO AS FECHA_MODIFICA',
                    ]);

                $arrConditions = DB::table('S002V01TPRCN')
                    ->where('PRCN_NULI', '=', $line)
                    ->where('PRCN_ESTA', '=', 'Activo')
                    ->where('PRCN_NUPR', '=', $provider['NUMERO_PROVEEDOR'])
                    ->get([
                        'PRCN_IDCM AS NUMERO_CONDICION',
                        'PRCN_TIPO AS TIPO_CONDICION',
                        'PRCN_INFO AS INFORMACION',
                        'PRCN_ESTA AS ESTADO',
                        'PRCN_USRE AS USUARIO_REGISTRA',
                        'PRCN_FERE AS FECHA_REGISTRA',
                        'PRCN_USMO AS USUARIO_MODIFICA',
                        'PRCN_FEMO AS FECHA_MODIFICA',
                    ]);

                $arrCatalogs = DB::table('S002V01TPRCE')
                    ->where('PRCE_NULI', '=', $line)
                    ->where('PRCE_ESTA', '=', 'Activo')
                    ->where('PRCE_NUPR', '=', $provider['NUMERO_PROVEEDOR'])
                    ->get([
                        'PRCE_IDCE AS NUMERO_CATALAGO',
                        'PRCE_CATA AS CATALAGO',
                        'PRCE_DESC AS DESCRIPCION',
                        'PRCE_XURL AS URL_CATALAGO',
                        'PRCE_ESTA AS ESTADO',
                        'PRCE_USRE AS USUARIO_REGISTRA',
                        'PRCE_FERE AS FECHA_REGISTRA',
                        'PRCE_USMO AS USUARIO_MODIFICA',
                        'PRCE_FEMO AS FECHA_MODIFICA',
                    ]);


                $arrPayment = json_decode($provider['METODO_PAGO']);

                $arrPaymentFormat = array();
                foreach ($arrPayment as $key => $payment) {
                    $arrPaymentFormat[] = [
                        'name' => $key,
                        'completed' => $payment,
                    ];
                }

                $provider['REFERENCIAS'] = $arrReferences;
                $provider['CONTACTOS'] = $arrContacts;
                $provider['CONDICIONES'] = $arrConditions;
                $provider['CATALAGOS'] = $arrCatalogs;
                $provider['METODOS_PAGO'] = $arrPaymentFormat;

                $arrResponse[] = $provider;
            }


        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_GET000: No se pudo realizar la consulta a la base.", $th->getMessage(), 500);
        }

        return $this->responseController->makeResponse(false, "ÉXITO: Consulta Exitosa", $arrResponse);
    }

    public function getProvidersActives($line) {
        try {
            $arrProvider = DB::table('S002V01TPROV')
                ->where('PROV_ESTA', '=', 'Activo')
                ->where('PROV_NULI', '=', $line)
                ->get([
                    'PROV_NUPR AS NUMERO_PROVEEDOR',
                    'PROV_NOCO AS RAZON_SOCIAL',
                    'PROV_NOMB AS NOMBRE',
                    'PROV_APPA AS PRIMER_APELLIDO',
                    'PROV_APMA AS SEGUNDO_APELLIDO',
                    'PROV_CORR AS CORREO',
                    'PROV_LAD1 AS LADA1',
                    'PROV_TEL1 AS TELEFONO1',
                    'PROV_LAD2 AS LADA2',
                    'PROV_TEL2 AS TELEFONO2',
                    'PROV_XRFC AS RFC',
                    'PROV_XTAX AS TAXID',
                    'PROV_CORF AS REGIMEN_FISCAL',
                    'PROV_TIPO AS TIPO_EMPRESA',
                    'PROV_SIWE AS SITIO_WEB',
                    'PROV_MEPA AS METODO_PAGO',
                    'PROV_USRE AS USUARIO_REGISTRA',
                    'PROV_FERE AS FECHA_REGISTRA',
                    'PROV_USMO AS USUARIO_MODIFICA',
                    'PROV_FEMO AS FECHA_MODIFICA',
                ]);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_GET000: No se pudo realizar la consulta a la base.", $th->getMessage(), 500);
        }
        return $this->responseController->makeResponse(false, "ÉXITO: Consulta Exitosa", $arrProvider);
    }

    public function getProvidersByNumber($provider, $line) {
        try {
            $arrProvider = DB::table('S002V01TPROV')
                ->where('PROV_NUPR', '=', $provider)
                ->where('PROV_ESTA', '=', 'Activo')
                ->where('PROV_NULI', '=', $line)
                ->first([
                    'PROV_NUPR AS NUMERO_PROVEEDOR',
                    'PROV_NOCO AS RAZON_SOCIAL',
                    'PROV_NOMB AS NOMBRE',
                    'PROV_APPA AS PRIMER_APELLIDO',
                    'PROV_APMA AS SEGUNDO_APELLIDO',
                    'PROV_CORR AS CORREO',
                    'PROV_LAD1 AS LADA1',
                    'PROV_TEL1 AS TELEFONO1',
                    'PROV_LAD2 AS LADA2',
                    'PROV_TEL2 AS TELEFONO2',
                    'PROV_XRFC AS RFC',
                    'PROV_XTAX AS TAXID',
                    'PROV_CORF AS REGIMEN_FISCAL',
                    'PROV_TIPO AS TIPO_EMPRESA',
                    'PROV_SIWE AS SITIO_WEB',
                    'PROV_MEPA AS METODO_PAGO',
                    'PROV_USRE AS USUARIO_REGISTRA',
                    'PROV_FERE AS FECHA_REGISTRA',
                    'PROV_USMO AS USUARIO_MODIFICA',
                    'PROV_FEMO AS FECHA_MODIFICA',
                ]);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_GET000: No se pudo realizar la consulta a la base.", $th->getMessage(), 500);
        }
        return $this->responseController->makeResponse(false, "ÉXITO: Consulta Exitosa", $arrProvider);

    }

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

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

        DB::beginTransaction();
        $requestData = $request->all();
        $line = $requestData['line'];

        try {
            $user = $this->encController->decrypt($request['user']);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD001: No se pudo obtener el usuario.", $th->getMessage(), 500);
        }
        try {
            $obj_response = json_decode($requestData['obj_response']);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD002: Ocurrió un error al obtener los datos del proveedor.", $th->getMessage(), 500);
        }

        $arrInformationPersonal = (array) $obj_response->INFORMACION;
        $arrReferences = (array) $obj_response->REFERENCIAS;
        $arrContacts = (array) $obj_response->CONTACTOS;
        $arrConditions = (array) $obj_response->CONDICIONES;
        $arrPaymentMedia = (array) $obj_response->METODOS_PAGO;
        $arrCatalogs = (array) $obj_response->CATALAGOS;

        $numeroProveedor = $arrInformationPersonal['NUMERO_PROVEEDOR'];
        $currentDate = Carbon::now()->timezone('America/Mazatlan')->toDateTimeString();

        $arrPaymentTemp = array();
        foreach ($arrPaymentMedia as $payment) {
            $arrPaymentTemp[$payment->name] = $payment->completed;
        }
        try {
            $strPayment = json_encode($arrPaymentTemp);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD003: Ocurrió un error al obtener los datos del método de pago.", $th->getMessage(), 500);
        }

        $updatePersonal = [
            'PROV_NOCO' => $arrInformationPersonal['RAZON_SOCIAL'],
            'PROV_NOMB' => $arrInformationPersonal['NOMBRE'],
            'PROV_APPA' => $arrInformationPersonal['PRIMER_APELLIDO'],
            'PROV_APMA' => $arrInformationPersonal['SEGUNDO_APELLIDO'] != '' ? $arrInformationPersonal['SEGUNDO_APELLIDO'] : null,
            'PROV_CORR' => $arrInformationPersonal['CORREO'],
            'PROV_LAD1' => $arrInformationPersonal['LADA1'],
            'PROV_TEL1' => $arrInformationPersonal['TELEFONO1'],
            'PROV_LAD2' => $arrInformationPersonal['LADA2'] != '' ? $arrInformationPersonal['LADA2'] : null,
            'PROV_TEL2' => $arrInformationPersonal['TELEFONO2'] != '' ? $arrInformationPersonal['TELEFONO2'] : null,
            'PROV_XRFC' => $arrInformationPersonal['RFC'],
            'PROV_XTAX' => $arrInformationPersonal['TAXID'] != '' ? $arrInformationPersonal['TAXID'] : null,
            'PROV_CORF' => $arrInformationPersonal['REGIMEN_FISCAL'],
            'PROV_TIPO' => $arrInformationPersonal['TIPO_EMPRESA'],
            'PROV_SIWE' => $arrInformationPersonal['SITIO_WEB'],
            'PROV_MEPA' => $strPayment,
            'PROV_USMO' => $user,
            'PROV_FEMO' => $currentDate,
            'PROV_FEAR' => DB::raw('CURRENT_TIMESTAMP')
        ];
        try {
            $resp = DB::table('S002V01TPROV')->where('PROV_NUPR', '=', $numeroProveedor)->where('PROV_NULI', '=', $line)->update($updatePersonal);
            if (!$resp) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD004: Ocurrió un error al obtener el contenido.", [], 500);
            }
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD005: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
        }

        foreach ($arrReferences as $references) {
            if ($references->ESTADO == 'Activo' || $references->ESTADO == 'Modificado') {
                $updateReferences = [
                    'PRRE_EMPR' => $references->EMPRESA,
                    'PRRE_CORR' => $references->CORREO,
                    'PRRE_LADA' => $references->LADA,
                    'PRRE_TELE' => $references->TELEFONO,
                    'PRRE_XRFC' => $references->RFC,
                    'PRRE_DIRE' => $references->DIRECCION,
                    'PRRE_USMO' => $user,
                    'PRRE_FEMO' => $currentDate,
                    'PRRE_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRRE')
                        ->where('PRRE_IDRE', '=', $references->NUMERO_REFERENCIA)
                        ->where('PRRE_NUPR', '=', $numeroProveedor)
                        ->where('PRRE_NULI', '=', $line)
                        ->update($updateReferences);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD006: Ocurrió un error al obtener el contenido. ", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD007: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }else if($references->ESTADO == 'Nuevo') {
                $insertReferences = [
                    'PRRE_NUPR' => $numeroProveedor,
                    'PRRE_EMPR' => $references->EMPRESA,
                    'PRRE_CORR' => $references->CORREO,
                    'PRRE_LADA' => $references->LADA,
                    'PRRE_TELE' => $references->TELEFONO,
                    'PRRE_XRFC' => $references->RFC,
                    'PRRE_DIRE' => $references->DIRECCION,
                    'PRRE_NULI' => $line,
                    'PRRE_USRE' => $user,
                    'PRRE_FERE' => $currentDate,
                    'PRRE_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRRE')->insert($insertReferences);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD008: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD009: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            } else if($references->ESTADO == 'Eliminado'){
                $updateReferences = [
                    'PRRE_ESTA' => 'Eliminado',
                    'PRRE_USMO' => $user,
                    'PRRE_FEMO' => $currentDate,
                    'PRRE_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRRE')
                        ->where('PRRE_IDRE', '=', $references->NUMERO_REFERENCIA)
                        ->where('PRRE_NUPR', '=', $numeroProveedor)
                        ->where('PRRE_NULI', '=', $line)
                        ->update($updateReferences);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD010: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD011: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }
        }

        foreach ($arrContacts as $contacts) {
            if ($contacts->ESTADO == 'Activo' && $contacts->ESTADO == 'Modificado') {
                $updateContacts = [
                    'PRCO_NOMB' => $contacts->NOMBRE_CONTACTO,
                    'PRCO_TIPO' => $contacts->TIPO_CONTACTO,
                    'PRCO_CALL' => $contacts->CALLE,
                    'PRCO_NUEX' => $contacts->NUMERO_EXTERIOR,
                    'PRCO_NUIN' => $contacts->NUMERO_INTERIOR != '' ? $contacts->NUMERO_INTERIOR : null,
                    'PRCO_COPO' => $contacts->CODIGO_POSTAL,
                    'PRCO_COLO' => $contacts->SUBURB,
                    'PRCO_MUNI' => $contacts->MUNICIPIO,
                    'PRCO_ENTI' => $contacts->ENTIDAD,
                    'PRCO_PAIS' => $contacts->PAIS,
                    'PRCO_TEL1' => $contacts->TELEFONO1,
                    'PRCO_TEL2' => $contacts->TELEFONO2 != '' ? $contacts->TELEFONO2 : null,
                    'PRCO_COR1' => $contacts->CORREO1,
                    'PRCO_COR2' => $contacts->CORREO2 != '' ? $contacts->CORREO2 : null,
                    'PRCO_OBSE' => $contacts->OBSERVACIONES,
                    'PRCO_USMO' => $user,
                    'PRCO_FEMO' => $currentDate,
                    'PRCO_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCO')
                        ->where('PRCO_IDCP', '=', $contacts->NUMERO_CONTACTO)
                        ->where('PRCO_NUPR', '=', $numeroProveedor)
                        ->where('PRCO_NULI', '=', $line)
                        ->update($updateContacts);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD012: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD013: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }

            }else if($contacts->ESTADO == 'Nuevo'){
                $insertContacts = [
                    'PRCO_NUPR' => $numeroProveedor,
                    'PRCO_NOMB' => $contacts->NOMBRE_CONTACTO,
                    'PRCO_TIPO' => $contacts->TIPO_CONTACTO,
                    'PRCO_CALL' => $contacts->CALLE,
                    'PRCO_NUEX' => $contacts->NUMERO_EXTERIOR,
                    'PRCO_NUIN' => $contacts->NUMERO_INTERIOR != '' ? $contacts->NUMERO_INTERIOR : null,
                    'PRCO_COPO' => $contacts->CODIGO_POSTAL,
                    'PRCO_COLO' => $contacts->COLONIA,
                    'PRCO_MUNI' => $contacts->MUNICIPIO,
                    'PRCO_ENTI' => $contacts->ENTIDAD,
                    'PRCO_PAIS' => $contacts->PAIS,
                    'PRCO_LAD1' => $contacts->LADA1,
                    'PRCO_TEL1' => $contacts->TELEFONO1,
                    'PRCO_LAD2' => $contacts->LADA2 != '' ? $contacts->LADA2 : null,
                    'PRCO_TEL2' => $contacts->TELEFONO2 != '' ? $contacts->TELEFONO2 : null,
                    'PRCO_COR1' => $contacts->CORREO1,
                    'PRCO_COR2' => $contacts->CORREO2 != '' ? $contacts->CORREO2 : null,
                    'PRCO_OBSE' => $contacts->OBSERVACIONES,
                    'PRCO_NULI' => $line,
                    'PRCO_USRE' => $user,
                    'PRCO_FERE' => $currentDate,
                    'PRCO_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCO')->insert($insertContacts);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD014: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD015: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }else if($contacts->ESTADO == 'Eliminado'){
                $updateContacts = [
                    'PRCO_ESTA' => 'Eliminado',
                    'PRCO_USMO' => $user,
                    'PRCO_FEMO' => $currentDate,
                    'PRCO_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCO')
                        ->where('PRCO_IDCP', '=', $contacts->NUMERO_CONTACTO)
                        ->where('PRCO_NUPR', '=', $numeroProveedor)
                        ->where('PRCO_NULI', '=', $line)
                        ->update($updateContacts);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD016: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD017: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }
        }

        foreach ($arrConditions as $conditions) {
            if ($conditions->ESTADO == 'Activo' && $conditions->ESTADO == 'Modificado') {
                $updateConditions = [
                    'PRCN_TIPO' => $conditions->TIPO_CONDICION,
                    'PRCN_INFO' => $conditions->INFORMACION,
                    'PRCN_USMO' => $user,
                    'PRCN_FEMO' => $currentDate,
                    'PRCN_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCN')
                        ->where('PRCN_IDCM', '=', $conditions->NUMERO_CONDICION)
                        ->where('PRCN_NUPR', '=', $numeroProveedor)
                        ->where('PRCN_NULI', '=', $line)
                        ->update($updateConditions);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD018: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD019: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }else if($conditions->ESTADO == 'Nuevo'){
                $insertConditions = [
                    'PRCN_NUPR' => $numeroProveedor,
                    'PRCN_TIPO' => $conditions->TIPO_CONDICION,
                    'PRCN_INFO' => $conditions->INFORMACION,
                    'PRCN_NULI' => $line,
                    'PRCN_USRE' => $user,
                    'PRCN_FERE' => $currentDate,
                    'PRCN_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCN')->insert($insertConditions);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD020: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD021: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }else if ($conditions->ESTADO == 'Eliminado'){
                $updateConditions = [
                    'PRCN_ESTA' => 'Eliminado',
                    'PRCN_USMO' => $user,
                    'PRCN_FEMO' => $currentDate,
                    'PRCN_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCN')
                        ->where('PRCN_IDCM', '=', $conditions->NUMERO_CONDICION)
                        ->where('PRCN_NUPR', '=', $numeroProveedor)
                        ->where('PRCN_NULI', '=', $line)
                        ->update($updateConditions);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD022: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD023: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }
        }

        foreach ($arrCatalogs as $catalogs) {
            if ($catalogs->ESTADO == 'Activo' || $catalogs->ESTADO == 'Modificado') {
                $updateCatalogs = [
                    'PRCE_CATA' => $catalogs->CATALAGO,
                    'PRCE_DESC' => $catalogs->DESCRIPCION,
                    'PRCE_XURL' => $catalogs->URL_CATALAGO,
                    'PRCE_USMO' => $user,
                    'PRCE_FEMO' => $currentDate,
                    'PRCE_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCE')
                        ->where('PRCE_IDCE', '=', $catalogs->NUMERO_CATALAGO)
                        ->where('PRCE_NUPR', '=', $numeroProveedor)
                        ->where('PRCE_NULI', '=', $line)
                        ->update($updateCatalogs);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD024: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD025: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }else if($catalogs->ESTADO == 'Nuevo'){
                $insertCatalogs = [
                    'PRCE_NUPR' => $numeroProveedor,
                    'PRCE_CATA' => $catalogs->CATALAGO,
                    'PRCE_DESC' => $catalogs->DESCRIPCION,
                    'PRCE_XURL' => $catalogs->URL_CATALAGO,
                    'PRCE_NULI' => $line,
                    'PRCE_USRE' => $user,
                    'PRCE_FERE' => $currentDate,
                    'PRCE_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCE')->insert($insertCatalogs);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD026: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD027: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }else if($catalogs->ESTADO == 'Eliminado'){
                $updateCatalogs = [
                    'PRCE_ESTA' => 'Eliminado',
                    'PRCE_USMO' => $user,
                    'PRCE_FEMO' => $currentDate,
                    'PRCE_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCE')
                        ->where('PRCE_IDCE', '=', $catalogs->NUMERO_CATALAGO)
                        ->where('PRCE_NUPR', '=', $numeroProveedor)
                        ->where('PRCE_NULI', '=', $line)
                        ->update($updateCatalogs);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD028: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_MOD029: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }
        }

        DB::commit();
        return $this->responseController->makeResponse(false, "EXITO: Modificación Exitosa");
    }

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

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

        DB::beginTransaction();
        $requestData = $request->all();
        $line = $requestData['line'];

        try {
            $user = $this->encController->decrypt($requestData['user']);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG001: Ocurrió un error al obtener el usuario.", $th->getMessage(), 500);
        }
        try {
            $obj_response = json_decode($requestData['obj_response']);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG002: Ocurrió un error al obtener los datos del proveedor.", $th->getMessage(), 500);
        }

        $arrInformationPersonal = (array) $obj_response->INFORMACION;
        $arrReferences = (array) $obj_response->REFERENCIAS;
        $arrContacts = (array) $obj_response->CONTACTOS;
        $arrConditions = (array) $obj_response->CONDICIONES;
        $arrPaymentMedia = (array) $obj_response->METODOS_PAGO;
        $arrCatalogs = (array) $obj_response->CATALAGOS;

        $currentDate = Carbon::now()->timezone('America/Mazatlan')->toDateTimeString();

        $arrPaymentTemp = array();
        foreach ($arrPaymentMedia as $payment) {
            $arrPaymentTemp[$payment->name] = $payment->completed;
        }

        try {
            $strPayment = json_encode($arrPaymentTemp);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG003: Ocurrió un error al obtener los métodos de pago del proveedor.", $th->getMessage(), 500);
        }

        $insertPersonal = [
            'PROV_NOCO' => $arrInformationPersonal['RAZON_SOCIAL'],
            'PROV_NOMB' => $arrInformationPersonal['NOMBRE'],
            'PROV_APPA' => $arrInformationPersonal['PRIMER_APELLIDO'],
            'PROV_APMA' => $arrInformationPersonal['SEGUNDO_APELLIDO'] != '' ? $arrInformationPersonal['SEGUNDO_APELLIDO'] : null,
            'PROV_CORR' => $arrInformationPersonal['CORREO'],
            'PROV_LAD1' => $arrInformationPersonal['LADA1'],
            'PROV_TEL1' => $arrInformationPersonal['TELEFONO1'],
            'PROV_LAD2' => $arrInformationPersonal['LADA2'] != '' ? $arrInformationPersonal['LADA2'] : null,
            'PROV_TEL2' => $arrInformationPersonal['TELEFONO2'] != '' ? $arrInformationPersonal['TELEFONO2'] : null,
            'PROV_XRFC' => $arrInformationPersonal['RFC'],
            'PROV_XTAX' => $arrInformationPersonal['TAXID'] != '' ? $arrInformationPersonal['TAXID'] : null,
            'PROV_CORF' => $arrInformationPersonal['REGIMEN_FISCAL'],
            'PROV_TIPO' => $arrInformationPersonal['TIPO_EMPRESA'],
            'PROV_SIWE' => $arrInformationPersonal['SITIO_WEB'],
            'PROV_MEPA' => $strPayment,
            'PROV_NULI' => $line,
            'PROV_USRE' => $user,
            'PROV_FERE' => $currentDate,
            'PROV_FEAR' => DB::raw('CURRENT_TIMESTAMP')
        ];
        try {
            $idProdiver = DB::table('S002V01TPROV')->insertGetId($insertPersonal);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG004: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
        }
        foreach ($arrReferences as $references) {
            if ($references->ESTADO == 'Activo' ||  $references->ESTADO == 'Nuevo') {
                $insertReferences = [
                    'PRRE_NUPR' => $idProdiver,
                    'PRRE_EMPR' => $references->EMPRESA,
                    'PRRE_CORR' => $references->CORREO,
                    'PRRE_LADA' => $references->LADA,
                    'PRRE_TELE' => $references->TELEFONO,
                    'PRRE_XRFC' => $references->RFC,
                    'PRRE_DIRE' => $references->DIRECCION,
                    'PRRE_NULI' => $line,
                    'PRRE_USRE' => $user,
                    'PRRE_FERE' => $currentDate,
                    'PRRE_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRRE')->insert($insertReferences);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG005: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG006: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }
        }

        foreach ($arrContacts as $contacts) {
            if ($contacts->ESTADO == 'Activo' || $contacts->ESTADO == 'Nuevo') {
                $insertContacts = [
                    'PRCO_NUPR' => $idProdiver,
                    'PRCO_NOMB' => $contacts->NOMBRE_CONTACTO,
                    'PRCO_TIPO' => $contacts->TIPO_CONTACTO,
                    'PRCO_CALL' => $contacts->CALLE,
                    'PRCO_NUEX' => $contacts->NUMERO_EXTERIOR,
                    'PRCO_NUIN' => $contacts->NUMERO_INTERIOR != '' ? $contacts->NUMERO_INTERIOR : null,
                    'PRCO_COPO' => $contacts->CODIGO_POSTAL,
                    'PRCO_COLO' => $contacts->COLONIA,
                    'PRCO_MUNI' => $contacts->MUNICIPIO,
                    'PRCO_ENTI' => $contacts->ENTIDAD,
                    'PRCO_PAIS' => $contacts->PAIS,
                    'PRCO_LAD1' => $contacts->LADA1,
                    'PRCO_TEL1' => $contacts->TELEFONO1,
                    'PRCO_LAD2' => $contacts->LADA2 != '' ? $contacts->LADA2 : null,
                    'PRCO_TEL2' => $contacts->TELEFONO2 != '' ? $contacts->TELEFONO2 : null,
                    'PRCO_COR1' => $contacts->CORREO1,
                    'PRCO_COR2' => $contacts->CORREO2 != '' ? $contacts->CORREO2 : null,
                    'PRCO_OBSE' => $contacts->OBSERVACIONES,
                    'PRCO_NULI' => $line,
                    'PRCO_USRE' => $user,
                    'PRCO_FERE' => $currentDate,
                    'PRCO_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCO')->insert($insertContacts);
                    
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG007: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG008: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }
        }

        foreach ($arrConditions as $conditions) {
            if ($conditions->ESTADO == 'Activo') {
                $insertConditions = [
                    'PRCN_NUPR' => $idProdiver,
                    'PRCN_TIPO' => $conditions->TIPO_CONDICION,
                    'PRCN_INFO' => $conditions->INFORMACION,
                    'PRCN_NULI' => $line,
                    'PRCN_USRE' => $user,
                    'PRCN_FERE' => $currentDate,
                    'PRCN_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCN')->insert($insertConditions);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG009: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG010: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }
        }

        foreach ($arrCatalogs as $catalogs) {
            if ($catalogs->ESTADO == 'Activo' || $catalogs->ESTADO == 'Nuevo') {
                $insertCatalogs = [
                    'PRCE_NUPR' => $idProdiver,
                    'PRCE_CATA' => $catalogs->CATALAGO,
                    'PRCE_DESC' => $catalogs->DESCRIPCION,
                    'PRCE_XURL' => $catalogs->URL_CATALAGO,
                    'PRCE_NULI' => $line,
                    'PRCE_USRE' => $user,
                    'PRCE_FERE' => $currentDate,
                    'PRCE_FEAR' => DB::raw('CURRENT_TIMESTAMP')
                ];
                try {
                    $resp = DB::table('S002V01TPRCE')->insert($insertCatalogs);
                    if (!$resp) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG011: Ocurrió un error al obtener el contenido.", [], 500);
                    }
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_PROVIDER_REG012: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
                }
            }
        }

        DB::commit();
        return $this->responseController->makeResponse(false, "EXITO: Registro Exitoso");
    }

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

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

        DB::beginTransaction();
        $requestData = $request->all();
        $currentDate = Carbon::now()->timezone('America/Mazatlan')->toDateTimeString();
        $line = $requestData['line'];

        try {
            $numeroProveedor = $this->encController->decrypt($requestData['numero_proveedor']);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL001: Ocurrió un error al obtener el número del proveedor.", $th->getMessage(), 500);
        }
        try {
            $user = $this->encController->decrypt($requestData['user']);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL002: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
        }

        $update = [
            'PROV_ESTA' => 'Eliminado',
            'PROV_USMO' => $user,
            'PROV_FEMO' => $currentDate,
            'PROV_FEAR' => DB::raw('CURRENT_TIMESTAMP')
        ];
        try {
            $resp = DB::table('S002V01TPROV')->where('PROV_NUPR', '=', $numeroProveedor)->where('PROV_NULI', '=', $line)->update($update);
            if (!$resp) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL003: Ocurrió un error al obtener el contenido. ", [], 500);
            }
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL004: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
        }

        $update = [
            'PRRE_ESTA' => 'Eliminado',
            'PRRE_USMO' => $user,
            'PRRE_FEMO' => $currentDate,
            'PRRE_FEAR' => DB::raw('CURRENT_TIMESTAMP')
        ];
        try {
            $resp = DB::table('S002V01TPRRE')->where('PRRE_NUPR', '=', $numeroProveedor)->where('PRRE_NULI', '=', $line)->update($update);
            if (!$resp) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL005: Ocurrió un error al obtener el contenido. ", [], 500);
            }
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL006: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
        }

        $update = [
            'PRCO_ESTA' => 'Eliminado',
            'PRCO_USMO' => $user,
            'PRCO_FEMO' => $currentDate,
            'PRCO_FEAR' => DB::raw('CURRENT_TIMESTAMP')
        ];
        try {
            $resp = DB::table('S002V01TPRCO')->where('PRCO_NUPR', '=', $numeroProveedor)->where('PRCO_NULI', '=', $line)->update($update);
            if (!$resp) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL007: Ocurrió un error al obtener el contenido. ", [], 500);
            }
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL008: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
        }

        $update = [
            'PRCN_ESTA' => 'Eliminado',
            'PRCN_USMO' => $user,
            'PRCN_FEMO' => $currentDate,
            'PRCN_FEAR' => DB::raw('CURRENT_TIMESTAMP')
        ];
        try {
            $resp = DB::table('S002V01TPRCN')->where('PRCN_NUPR', '=', $numeroProveedor)->where('PRCN_NULI', '=', $line)->update($update);
            if (!$resp) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL009: Ocurrió un error al obtener el contenido. ", [], 500);
            }
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL010: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
        }

        $update = [
            'PRCE_ESTA' => 'Eliminado',
            'PRCE_USMO' => $user,
            'PRCE_FEMO' => $currentDate,
            'PRCE_FEAR' => DB::raw('CURRENT_TIMESTAMP')
        ];
        try {
            $resp = DB::table('S002V01TPRCE')->where('PRCE_NUPR', '=', $numeroProveedor)->where('PRCE_NULI', '=', $line)->update($update);
            if (!$resp) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL011: Ocurrió un error al obtener el contenido. ", [], 500);
            }
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_DEL012: Ocurrió un error al obtener el contenido.", $th->getMessage(), 500);
        }

        DB::commit();
        return $this->responseController->makeResponse(false, "EXITO: Eliminación correcta",);

    }

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

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

        $response = $request->all();
        $numeroArticulo = $this->encController->decrypt($response['NUMERO_ARTICULO']);
        try {
            $arrDescription = DB::table('S002V01TDEAR')
                ->where('DEAR_ESTA', '=', 'Activo')
                ->where('DEAR_IDAR', '=', $numeroArticulo)
                ->join('S002V01TPROV', 'DEAR_NUPR', '=', 'PROV_NUPR')
                ->get([
                    'DEAR_IDDE AS NUMERO_DESCRIPTION',
                    'PROV_NUPR AS NUMERO_PROVEEDOR',
                    'PROV_NOCO AS RAZON_SOCIAL',
                    'PROV_NOMB AS NOMBRE',
                    'PROV_APPA AS PRIMER_APELLIDO',
                    'PROV_APMA AS SEGUNDO_APELLIDO',
                    'PROV_CORR AS CORREO',
                    'PROV_LAD1 AS LADA1',
                    'PROV_TEL1 AS TELEFONO1',
                    'PROV_LAD2 AS LADA2',
                    'PROV_TEL2 AS TELEFONO2',
                    'PROV_XRFC AS RFC',
                    'PROV_XTAX AS TAXID',
                    'PROV_CORF AS REGIMEN_FISCAL',
                    'PROV_TIPO AS TIPO_EMPRESA',
                    'PROV_SIWE AS SITIO_WEB',
                    'PROV_MEPA AS METODO_PAGO',
                    'PROV_ESTA AS ESTADO',
                    'PROV_USRE AS USUARIO_REGISTRA',
                    'PROV_FERE AS FECHA_REGISTRA',
                    'PROV_USMO AS USUARIO_MODIFICA',
                    'PROV_FEMO AS FECHA_MODIFICA',
                ]);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_PROVIDER_GET000: No se pudo realizar la consulta a la base.", $th->getMessage(), 500);
        }

        return $this->responseController->makeResponse(false, "ÉXITO", $arrDescription);

    }

    public function generateSheetProvider($encProvider, $encUser, $line) {
        try {
            $provider = $this->encController->decrypt($encProvider);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_GENERATE_SHEET_REG000: Ocurrió un error al obtener la ordens.", $th->getMessage(), 500);
        }
        try {
            $user = $this->encController->decrypt($encUser);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_GENERATE_SHEET_REG001: Ocurrió un error al obtener la ordens.", $th->getMessage(), 500);
        }

        try {
            $getProvider = (array) DB::table('S002V01TPROV')
                ->where('PROV_NUPR', '=', $provider)
                ->first([
                    'PROV_NOCO',
                    'PROV_NOMB', 
                    'PROV_APPA', 
                    'PROV_APMA', 
                    'PROV_CORR', 
                    'PROV_LAD1', 
                    'PROV_TEL1', 
                    'PROV_LAD2', 
                    'PROV_TEL2', 
                    'PROV_XRFC', 
                    'PROV_XTAX', 
                    'PROV_CORF', 
                    'PROV_TIPO', 
                    'PROV_SIWE', 
                    'PROV_MEPA', 
                    'PROV_USRE', 
                    'PROV_FERE', 
                    'PROV_USMO', 
                    'PROV_FEMO', 
                ]);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_GENERATE_SHEET_REG002: Ocurrió un error al obtener la ordens.", $th->getMessage(), 500);
        }

        try {
            $getProviderReferences = DB::table('S002V01TPRRE')
                ->where('PRRE_NUPR', '=', $provider)
                ->where('PRRE_ESTA', '=', 'Activo')
                ->where('PRRE_NULI', '=', $line)
                ->get([
                    'PRRE_IDRE',
                    'PRRE_EMPR',
                    'PRRE_CORR',
                    'PRRE_LADA',
                    'PRRE_TELE',
                    'PRRE_XRFC',
                    'PRRE_DIRE',
                ]);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_GENERATE_SHEET_REG003: Ocurrió un error al obtener la ordens.", $th->getMessage(), 500);
        }
        $getProviderReferences = json_decode(json_encode($getProviderReferences), true);

        try {
            $getProviderCondiciones = DB::table('S002V01TPRCN')
                ->where('PRCN_NUPR', '=', $provider)
                ->where('PRCN_ESTA', '=', 'Activo')
                ->where('PRCN_NULI', '=', $line)
                ->get([
                    'PRCN_IDCM',
                    'PRCN_TIPO',
                    'PRCN_INFO',
                ]);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_GENERATE_SHEET_REG004: Ocurrió un error al obtener la ordens.", $th->getMessage(), 500);
        }
        $getProviderCondiciones = json_decode(json_encode($getProviderCondiciones), true);

        try {
            $getProviderCatalog = DB::table('S002V01TPRCE')
                ->where('PRCE_NUPR', '=', $provider)
                ->where('PRCE_ESTA', '=', 'Activo')
                ->where('PRCE_NULI', '=', $line)
                ->get([
                    'PRCE_IDCE',
                    'PRCE_CATA',
                    'PRCE_DESC',
                    'PRCE_XURL',
                ]);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_GENERATE_SHEET_REG005: Ocurrió un error al obtener la ordens.", $th->getMessage(), 500);
        }
        $getProviderCatalog = json_decode(json_encode($getProviderCatalog), true);

        try {
            $getProviderContacto = DB::table('S002V01TPRCO')
                ->where('PRCO_NUPR', '=', $provider)
                ->where('PRCO_ESTA', '=', 'Activo')
                ->where('PRCO_NULI', '=', $line)
                ->get([
                    'PRCO_IDCP',
                    'PRCO_NOMB',
                    'PRCO_TIPO',
                    'PRCO_CALL',
                    'PRCO_NUEX',
                    'PRCO_NUIN',
                    'PRCO_COPO',
                    'PRCO_COLO',
                    'PRCO_MUNI',
                    'PRCO_ENTI',
                    'PRCO_PAIS',
                    'PRCO_LAD1',
                    'PRCO_TEL1',
                    'PRCO_LAD2',
                    'PRCO_TEL2',
                    'PRCO_COR1',
                    'PRCO_COR2',
                    'PRCO_OBSE',
                ]);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_GENERATE_SHEET_REG006: Ocurrió un error al obtener la ordens.", $th->getMessage(), 500);
        }
        $getProviderContacto = json_decode(json_encode($getProviderContacto), true);


        $mpdf = new PDF( [
            'mode' => 'utf-8',
            'format' => 'A4',
            'margin_header' => '3',
            'margin_top' => '20',
            'margin_bottom' => '20',
            'margin_footer' => '2',
        ]);

        $mpdf->SetHTMLHeader('
            <div style="display:flex; align-items: center; text-align: right;">
                <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAACpYAAAYlCAMAAAAW/o21AAAAk1BMVEX///+ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA2ysrHpVA3rYBvtbSvveDjwhEfyj1b0m2X1pXX3sIT4u5T6xaP70LP82cP95NL97eH+9vD////p3kpDAAAAH3RSTlMAEBAgIDAwQEBQUGBgcHCAgJCQoKCwsMDA0NDg4PDwFagsVAAAIABJREFUeJzs3WfD20S6gGGH3mGX0HYXcuid8P9/3SEhQGJZtjXtmXJdn8k7kkfS3NiWfDoBAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAcI9XX3/z/Sc+aeijB+nb+1HLDf3Dv1I39M3GG/rJq+kvagkPWs/Mm6lb+nbjDc043Ju+qE+vA2++/nry1i7jtTfe+uCJTxnbxy8FH0jRLwCZnl4H3nrjtdjjaB4PXn/3w08+fxTis/SF+tXWm/xh6pZ+2HhDPw/t0gefNd7d5Hl5u/GGZsxL8xf12RZ/8uH7r2f8r+O8Xnrjg4effvF/zOI/oV36mkNpGl98+vC9N4L/L2dwL7/94X9DFry/6NIKIrtUle5Kf/cxqEqf+e9H7wa/Ad+X1977+H/Rax+lRXapKp3O/x6+80rcATWyN4OT9CldWkFcl6rSXW+nv6qhVfrU5x++7V3TP7z0zkMJMae4LlWlc/rfw7eiDqlBPXj7o+iV7hldWkFUl6rSXRlV2vro2fHR6mX60jsfR6901BPVpap0Yh+/4/P8e73+YdB3SS/RpRXEdKkq3TV+lT7xUfLtZeN7S5NOLqZLVencvnj4RsRhNZoH73bw2f3zdGkFEV2qSnfNUaV/+O/7L6fvyrhe+cDXSecX0aWqdH7/e89bpte93NMbpc/o0grad6kq3TVNlT7x4XJh+srD6IWNJtp3qSpdwhcP3QC17+X+FrknRurS5OeXzt6lqnTXVFX6h0+WeqTpG59GL2q00rpLVekyhOmOTqP00VhdmtwYc3epKt01W5X+4ZNl3jF9RZSupG2XqtKVCNMLHrwfvZZdoUsraNmlqnTXhFX6hw+XuC3/JR/fL6Zll6rSxXzgO6Zn3u7vO6XP+yx9z3TpnnZdqkp3zVmlfxxc76fv2Cg+0A3LadelqnQ5X7zT6uAawqufRK9ityR3hi7d16pLVemuWav0D/+d/Cumb7j7fkWtulSVrujT19ocXSPo+fP7v+jSCtp0qSrdNXGV/uFfE3+S/9K/o1cwYrTpUlW6qA9aHF0DeDX+xwvvoUsraNGlqnTX3FU68xum3ipdV4suVaXL+o83TP/wbt/fKv2HLq2gfpc2r9JPUrdUlZY36TdMP4heuwhUv0tV6cK+eK/24dW9Bx9FL1z306UV1O7S5lWa/NQGVVrDJxN+kP+Sp0KtrXaXqtK1fbz4LfmDfID/jC6toG6XqtJdS1TpH8fXdB/kvyEaVle3S1Xp6tb+IP/NUT7Af0aXVlCzS1XprkWq9FHWnvboneg1i3g1u1SV8sVb9Y6v3r0bvWAdpksrqNelqnTXOlWaddb2xxP0+b+aXapK+cOyXzAdbnl7pEur+LzSb0Wq0l0rVemjRx9N8wXTlz6OXq7oQ60uVaU89bDO8dW7AZe3R7q0iowfd71Cle5aq0prHWDtvfSf6MWKXtTpUlXKMyt26YPuf9hphy6toEY2qNJdq1XpLF2qSvlHjS5Vpfzt0+VuyG/eDOXo0grKZ4Mq3bVelc7RpaqU55XvUlXKc1r90G0vBq5SXVpF6WxQpbtWrNIZulSV8qLS2aBKecFiXTrQQ/Qv0KUVlM0GVbprzSodv0tVKefKZsNLqpQXfVzy+Ord0MvbI11aRclsUKW7Vq3S0btUlbJVsksdYWwsdN/T4MvbI11aRblsUKW71q3SwZ9f6nmlXFCuS1UpFyzTpc2X4gp0aQWlulSV7lq5SofuUlXKRaW6VJVy0Ttljq/evR69OBWRscK92XpbF+tSVbpr7Sod+HdI/eIoO8p0qSplxxsljq/evdz6zcJKMrp0nBoZsUtV6a7Vq/TRo2q/c1vXa9FLE/0q0aWqlD1fvJJ/fPVu6EdDvUCXVpDfpap0lyp99PmQtz25RZor8rtUlbJvgcdEzbK+PdKlVeR2qSrdpUr/8En6ixDn0+iFia7ldoMq5Zrpb3tq/r3KmnRpBXldqkp3qdKn3k9/GaJ8EL0s0bm8LlWlXPdWqUtZn2b5YukzurSCnC5VpbtU6TPDfb3UF0u5JadLVSk3TP710k+i16TCdGkF6V2qSnep0r+M9lR91cBt6V3q+OKmT0te0XrzbvSSVJwurSA1HMap0uYPSVOl/xjsY3wf4XOH1C5VpdzhvbIXtZ48mOsj/Kd0aQVpuTdOlY7ziwoTVulgH+P7CJ+7pHWpKuUeX8x7N/5H0etRDbq0gpTgU6W7VOkLPkt/OdqTDdwnpUtVKff5uPylrQ9z/LzThi6t4HjyqdJdqvTMu+kvSGvvRS9HDON4l6pS7jXrjz39N3o1qkSXVnA0+lTpLlV6bpyH6nuQPvc72qWqlLv9r84VLtp89zv9RZdWcCz7VOkuVbr1r/TXpK1/Ry9GjORYl6pSDpjyrqcZ73f6yxJd2vrhXkfCT5XuUqWXvJz+qrT0SvRSxFiOdKkq5Ygp73p6P3olqmmFLu04/TretDOqtA8ZJ2xLD6OXIgZzf5eqUo75oOalLsbMb5Y+0qVV3Bt/3W7YhirtxRBvl3qzlKP+c+expUo5aMK3S6d+s/SRLq3ivvzrdLMuUKXdGOLtUm+WctjDuw4tVcph071dOvmbpY90aRX3BGCXG3WRKu3IAG+XerOUBPd0qSrluOneLm1eXu3p0gpuJ2CHm7RDlfZkgLdLvVlKittdqkpJ8U6Dq15Lsz6z9Hm6tIJbEdjdBu1SpV3p/9mlnllKmltdqkpJMtmzS9+MXoSa0KUV3MjA1j9oq0pn0f1PPfmBJxJd71JVSqK3Gl372mgdD0F0aQVXQ7Dvh/w/R5X25r/pL1Ab/4tegxjWtS5VpaT6uNnVr4GXo5egVnRpBVdSUJXuUaU3vZ7+ErXwRvQSxMD2u1SVku6VhlfA2ub93dFzurSC3RhUpXtU6W2d3/Tkhicy7HWpKiXDTL9AusINT8/o0gp2clCV7lGld/g8/UVqwQ1P5LjcpaqUHBPd9PRq9ALUki6t4GIQqtI9qvQub6a/TPW9Fb0AMbhLXapKyfNa8ythLf+KXn+a0qUVXEhCVbpHld6n60/xfYZPpm2XqlIy/TvgWljHQp/hP6FLK9hEoSrdo0rv1PWn+D7DJ9d5l6pSck3zKf4y9+H/RZdWcJaFqnSPKr1bx5/i+wyffC92qSol3yz34q9zH/5fdGkFL4ShKt2TceytVqWP/pX+WtX27+jVhxk836WqlAJmuRd/kWfpP0+XVvBcGqrSPar0gI6fqO9Z+pTwT5eqUkqY5Yn6rVfmHujSCv6OQ1W6R5Ue8nL6y1XXK9GLD5P4q0tVKUV8EXphLGapx0P9TZdW8CwPVekeVXpMxvdw63onevFhFn92qSqlkDeCr41lrPfV0qd0aQVPA1GV7lGlB3X75VJfLaWUJ12qSillji+XLvjV0qd0aQV/JKIq3aNKj/os/RWrS0VQzENVSjlzfLl0saeW/mOkLn01cUPbd6kq3aNKj0t/yeqKXnqYyUNVSjFTPLn0QfTKE2egLv18mC5tTJVO7fX0F62mN6KXHoCLXoq+PBbwevTKE0iXjk6Vzu3d9FetpveiVx6Ai2a452nRO57+pEvHpkon9376y1aTO56APs1wz9O/oleeULp0ZKp0dp+kv241fRq98gBc9O/oy2MBn0SvPLF06bhU6fQ6/Z0nv/EE9OnT6MtjAZMmy9106ahU6QLSX7maohcegMv+E315LCB63QmnS8eU/GKo0oGk/q9HVS9FLzwAO6KvjwVErzvxdOmIVOkSunxClOdDAb2Kvj7mezV63emALh2PKl2DLAU4YPwnRK382NK/6dLRqNJFpP7sblXvRK87ADtk6Rx06VhU6Sq6fHDpB9HrDsAOWToJXToSVboMWQpwwPhZ+n70utMJXToOVboOWQpwwAfRF8hssvQZXToKVboQWQpwgCydhy4dgypdiSwFOECWbpaREbz5+iUZT+7Wpc0sUaWniwfoCEr3tCwFOECWnovenyC6tJE1qnRcxf83N3qHLpGlQK9k6bno/YmiS5tQpZ2TpQCBZOm56P0Jo0sbUKW9k6UAgWTpuej9ifNu4VfylgW7VJV2T5YCBJKl56L3J1Dru6eX61JV2j9ZChBIlp6L3p9IurQqVToAWQoQSJaei96fULq0IlU6AlkKEEiWnoven1i6tBpVOgRZChBIlp6L3p9gurQSVToGWQoQSJaei96faLq0ClU6CFkKEEiWnoven3C6tAJVOgpZChBIlp6L3p94urS4cXZx9SqVpQCRZOm56P3pgC4tbJwdXL5KZSlAJFl6Lnp/eqBLixpn91SpLAWIJEvPRe9PF3RpQePsnCqVpQChZOm56P3pgy4tZpxdU6UnWQoQSpaei96fTujSQsbZMVX6hCwFCCRLz0XvTy+G6dLmj1A6RJUORpYCBJKl56L3pxu6tABVOhpZChBIlp6L3p9+6NJsqnQ4shQgkCw9F70/HdGlmVTpeGQpQCBZei56f3qiS7Oo0gHJUoBAsvRc9P50RZdmUKUjkqUAgWTpuej96YsuTaZKhyRLAQLJ0nPR+9MZXZpIlY5JlgIEkqXnovenN7o0iSodlCwFCCRLz0XvT3d0aQJVOipZChBIlp6L3p/+6NLDVOmwZClAIFl6Lnp/OqRLD1Kl45KlAIFk6bno/emRLj1ElQ5MlgIEkqXnovenS7q0xcar0g7IUoBAsvRc9P70SZfW33RV2gNZChBIlp6L3p9O6dLaG968Sj9K3NC5yVKAQLL0XPT+9EqX1t3s5lX62YPELZ3bm4VfZlkKcIAsPRe9P93SpTU3WpV24vXCr7MsBThAlp6L3p9+6dJ6m6xKeyFLAQLJ0nPR+9MxXVprg1VpN2QpQCBZei56f3qmS+tsrirthywFCCRLz0XvT9ead+nLiRsa0aWqdAayFCCQLD0XvT99a92lyQHVvktV6RRkKUAgWXouen86p0t3qNI5yFKAQLL0XPT+9E6XXqRKJyFLAQLJ0nPR+9M9XXqBKp2FLAUIJEvPRe9P/3TphiqdhiwFCCRLz0XvzwB06RlVOg9ZChBIlp6L3p8R6NIXvZ64eaq0P7IUIJAsPXd4A15/f1Sp7/Hp0he9nbhxI1Xpm9EHa7pjz76VpQCBZOm58A1oJ/mzZ136vBWq9O3Gm1rSsfeyZSlAIFl6LnwDGtKlBajSzsnSDVkK9EqWngvfgJZ0aTZV2jtZuiFLgV7J0nPhG9CULs2kSrsnSzdkKdArWXoufAPa0qVZVGn/ZOmGLAV6JUvPhW9AY7o0gyodgCzdkKVAr2TpufANaE2XJlOlI5ClG7IU6JUsPRe+Ac3p0kSqdAiydEOWAr2SpefCN6A9XZpElY5Blm7IUqBXsvRc+AYE0KUJVOkgZOmGLAV6JUvPhW9ABF16mCodhSzdkKVAr2TpufANCKFLD1Klw5ClG7IU6JUsPRe+ATEyunSY0CrYpap0HLJ0Q5YCvZKl58I3IEh6l46TWsW6VJUORJZuyFKgV7L0XPgGRNGld1OlI5GlG7IU6JUsPRe+AWF06Z1U6VBk6YYsBXolS8+Fb0AcXXoXVToWWbohS4FeydJz4RsQSJfeQZUORpZuyFKgV7L0XPgGRNKlN6nS0cjSDVkK9EqWngvfgFC69IbUKh3nMVqzVaks3ZKlQK9k6bnwDYilS69KrtJhfnRguiqVpVuyFOiVLD0XvgHBdOkVqnRAsnRDlgK9kqXnwjcgmi7dpUpHJEs3ZCnQK1l6LnwDwunSHap0SLJ0Q5YCvZKl58I3IJ4uvUiVjkmWbshSoFey9Fz4BnRghS49nB+qdFCydEOWAr2SpefCN6AHK3TpwQRTpaOSpRuyFOiVLD0XvgFd0KVnVOmwZOmGLAV6JUvPhW9AH3TpC1TpuGTphiwFeiVLz4VvQCd06XNU6cBk6YYsBXolS8+Fb0AvdOnfVOnIZOmGLAV6JUvPhW9AN3TpM6p0aLJ0Q5YCvZKl58I3oB+69ClVOjZZuiFLgV7J0nPhG9ARXfpIlQ5Plm7IUqBX/46+QGaTpRXpUlU6PFm6IUuBXn0afYHMJktrWr5LVenwZOmGLAV6JUvPhW9AXxbvUlU6Plm6IUuBXsnSc+Eb0Jmlu1SVTkCWbshSoFey9Fz4BvRm4S5VpTOQpRuyFOiVLD0XvgHdWbZLVekUZOmGLAV6JUvPhW9AfxbtUlU6B1m6IUuBXsnSc+Eb0KElu3SYKv385dQtXaJKZemWLAV6JUvPhW9Ajxbs0nGqNHlu1qhSWbolS4FeydJz4RvQpeW6VJVOQ5ZuyFKgV7L0XPgG9GmxLlWl85ClG7IU6JUsPRe+AZ1aqktV6URk6YYsBXolS8+Fb0CvFupSVToTWbohS4FeydJz4RvQrYG69KPULX0aa6p0KrJ0Q5YCvZKl58I3oF8DdemHqVv6tiqdjSzdkKVAr2TpufAN6NgSXapKJyNLN2Qp0CtZei58A3q2QpemUqWdkqUbshTolSw9F74BXdOle1Rpr2TphiwFeiVLz4VvQN906WUDVembjTc1mizdkKVAr2TpufAN6JwuvWSgKn3188bbGk2WbshSoFey9Fz4BvROl26p0o7J0g1ZCvRKlp4L34Du6dJzqrRnsnRDlgK9kqXnwjegf7r0Raq0a7J0Q5YCvZKl58I3YAC69HmqtG+ydEOWAr2SpefCN2AEuvQfqrRzsVn6ZvJsVSRLgV6Nn6XvFl5GDm/AilmqS/+mSnsXmqXJvxlWlSwFejV+lpbugsPjL5mluvQZVdq9yCzts0plKdCtCbK0cBkcHn7NLNWlT6nS/gVmaadVKkuBbs2QpWXb4PDoi2apLj2p0iHEZWmvVSpLgW5NkaVF6+Dw4KtmqS5VpUMIy9Juq1SWAt2aI0tL9sHhsZfN0uW7VJUOISpL+61SWQp0a5IsLVgIh4deN0sX71JVOoagLO24SmUp0K1ZsrRcIxweeeEsffT5y6nzNX6XqtJBxGRpz1UqS4FuTZOlxSrh8MArZ+mjzx6kztfoXapKRxGSpV1XqSwFujVPlpbqhMPjLp2lGV3aPJaKdqkqHUZElvZdpbIU6NZEWVqoFA4Pu3aWLtqlqnQcAVnaeZXKUqBbM2VpmVY4POriWbpkl6rSgbTP0t6rVJYC3ZoqS4vUwuFBV8/SBbtUlY6keZZ2X6WyFOjWXFlaohcOj7l8li7Xpap0KK2ztP8qlaVAtybL0gLFcHhIWbpYl6rSsTTO0gGqVJYC3ZotS/Ob4fCIsnStLlWlg2mbpSNUqSwFujVdlmZXw+EBZemjlbr03cabq0pzNc3SIapUlgLdmi9Lc7v08Hiy9IlVuvTtxhurSrO1zNIxqlSWAt2aMEszu/TwcLL0qTW6VJWOp2GWDlKlshTo1oxZmtelh0eTpX9aoUtV6YDaZekoVSpLgW5NmaVZXXp4sNJZ+vqoXk6er1G6dKAqPb0afTgkK31PWbMsHaZKZSnQrTmzNKdLD49VOksrvBzdG6NLR6rSgRX//7xDo6dn6ThVKkuBbk2apRldengoWVrACF2qStsYNEsHqlJZCnRr1ixN79LDI8nSEvrvUlXayJhZOlKVylKgW9NmaXKXHh5IlhbRe5eq0laGzNKhqlSWAt2aN0tTu/TwOLK0jL67VJU2M2KWjlWlshTo1sRZmtilh4eRpYX03KWqtJ0Bs3SwKpWlQLdmztK0Lj08iiwtpd8uVaUNjZelo1WpLAW6NXWWJnXp4UFkaTG9dqkqbWm4LB2uSmUp0K25szSlSw+PIUvL6bNLVWlTo2XpeFUqS4FuTZ6lCV16eAhZWlCPXapK2xosSwesUlkKdGv2LH3w2dFV5vAQsrSk/rpUlTY2VpaOWKWyFOjW7Fl6vEsPjyBLi+qtS1Vpa0Nl6ZBVKkuBbk2fpYe79PAAsrSsvrpUlTY3UpaOWaWyFOjW/Fl6tEsP/31ZWlhPXapK2xsoSwetUlkKdGuBLD3YpYf/vCwtrZ8uVaUBxsnSUatUlgLdWiFLj3Xp4b8uS4vrpUtVaYRhsnTYKpWlQLeWyNJDXXr4j8vS8vro0tZV+kiVPjFKlo5bpbIU6NYaWXqkSw//bVlaQQ9d2rxKB+6ckgbJ0vcr7X4LshTo1SJZeqBLD/9pWVpDfJeq0iBjZOmdv1vbJ1kK9GqVLL2/Sw//ZVlaRXSXqtIoQ2Tp0FUqS4FuLZOld3fp4T8sS+uI7VJVGmaELB27SmUp0K11svTeLj38d2VpJZFdqkrjDJClg1epLAW6tVCW3tmlh/+sLK2leZf+66+RVWmg/rN09CqVpUC3VsrS+7r08F+VpdU079JndahKI3WfpcNXqSwFurVUlt7VpYf/qCytJ6ZLVWmo3rN0/CqVpUC31srSe7r08N+UpRVFdKkqjdV5lk5QpbIU6NZiWXpHlx7+k7K0pvZdqkqD9Z2lM1SpLAW6tVqW3u7Sw39RllbVvEtbU6Vnus7SKapUlgLdWi5Lb3bp4T8oS+uavEtV6bmes3SOKpWlQLfWy9JbXXr478nSyqbuUlW60XGWTlKla2Xpj78wix9/eOq7b7755uvo44pqFszSG116+M/J0tom7lJVutVvls5SpWtl6S+/M6lfn4Tq999882X0MUZRK2bp9S49/NdkaXXTdqkqvaDbLJ2mSmUpk/ntl59++FaeTmLJLL3apYf/mCytb9IuVaWX9Jql81SpLGVSf9TpN19FH3FkWjNLr3Xp4b8lSxuYsktV6UWdZulEVSpLmdovP33vndOBLZqlV7r08J+SpS1M2KWq9LI+s3SmKpWlzO+3n3/QpmNaNUv3u/TwX5KlTUzXpap0R5dZOlWVylIW8etP37llfzjLZululx7+Q7K0jcm6VJXu6TFL56pSWcpCHv/8vTQdyrpZutelh/+OLG1kqi5Vpbs6zNKMKn21x5mWpaxFmo5k/Cx9P/myf7lLj29A4VU0dXfmN1GX9tgqvegvS3Oq9PP30/9xNbKU9Tz+6Ts36Q9hgixNX+IvdmnCBpSVujcLmKZLVekV3WVpVpU+kqXBZCl/+/VHb5r2b4YsLdulKRtQVOrOrGCSLlWl1/SWpXlVKkujyVKe9/inb92g37cpsrRolyZtQEmp+7KEKbpUlV7VWZZmVqksjSZLOffzd8q0Y3NkackuTduAglJ3ZQ0TdKkqva6vLM2o0pefHquyNJgs5QJl2q9JsrRglyZuQDmpe7KIK79ZPgZVekNXWZpRpc8uLbI0mCzlMmXaqVmytFyXpm5AMak7soq3C7/ejanSW3rK0vwqlaXRZCm7fvo2+vBka5osffRm6h8469LkDSgldT+WMXSXqtKbOsrSAlUqS6PJUq547N787syTpZ+/mvoXXuzS5A0o5ejww3pw+KV+ZuAuTa/SV6OnK93Bne4nS0tUqSyNJku57tfvfZjflXmytFSXpm9AIQeHLzx6Q5+t16UZVTrwrV6fHNvVbrK0SJXK0miylJt++ib6MOUfE2VpoS7N2IAyDg5fePSWluvSNat01CwtU6WyNJos5Q6/uf+pGzNlaZkuzdmAIg4OX3j0phbr0kWrdNAsLVSlsjSaLOUuj3/y26R9mCpLi3Rp1gaUcHD4wqO3tVSXrlqlY2ZpqSqVpdFkKff6xY35PZgrS0t0ad4GFHBw+MKjN7ZQly5bpUNmabEqlaXRZCn381l+BybL0gJdmrkB+Q4OX3j01pbp0nWrdMQsLVelsjSaLOWIxz8I02CzZWl+l+ZuQLaDwxcevblFunThKh0wSwtWqSyNJks5yJdMY02Xpdldmr0BuQ4OX3j09pbo0pWrdLwsLVmlsjSaLOUwYRppvizN7dL8Dch0cPjCowdYoEuXrtLhsrRolcrSaLKUBMI0zoRZmtmlBTYgz8HhC48eYfouXbtKR8vSslUqS6PJUpII0ygzZmlel5bYgCwHhy88eojJu3TxKh0sSwtXqSyNJktJJExjTJmlWV1aZANyHBy+8Ogxpu7S1at0rCzNcLFKZWk0WUoyYRphzizN6dIyG5Dh4PCFRw8ycZcuX6WrZOnlKpWl0WQpGX7yuKjmJs3SjC4ttAHpDg5fePQo03apKl0kS3eqVJZGk6Xk8BzT5mbN0oZdKkuLmLRL06v05VmqdI0s3atSWRpNlpLn8XfRx/Bips3Sdl0qS8uYskvTq3Q3c8azQpbuT5csDSZLyfXbN9FH8VLmzdJmXSpLC5mwS1XpEwtk6ZXpkqXBZCn5fnHvUzsTZ2mrLpWlpUzXpar0qfmz9Np0ydJgspQSfMW0mZmztFGXytJiJutSVfqn6bP06nTJ0mCylCJ8xbSVqbO0TZfK0nKm6lJV+szH4/YbAAAgAElEQVTsWXp9umRpMFlKIT7Jb2PuLG3SpbK0oIm6VJX+ZfIsvTFdsjSYLKUYn+S3MHmWtuhSWVrSNF2qSv82d5bemi5ZGkyWUo578hv4IvoCme3GIla/S2VpUZN0qSr9x9RZenO6ZGkwWUpJP3vDtLroC2S2W4tY9S6VpWVN0aWq9DkzZ+nt6ZKlwWQpRT3+NvqQnl70BTLbzUWsdpfK0sIm6FJV+ryJs/SO6ZKlwWQphf3s1qe6oi+Q2W4vYpW7VJaWNnyX/it1+6es0omz9J7pkqXBZCmlPf4++qieW/QFMtsdi1jdLpWlxQ3epR+mbv2cVTpvlt41XbI0mCylPN8wrSn6ApntnkWsapfK0vKG7lJVembWLL1vumRpMFlKBb5hWlH0BTLbXYtYzS6VpRUcLJnnhHepKj03aZbeOV2yNJgspQpvmFYTfYHMdt8iVrFLZWkN6XEX3KWqdGPOLL13umRpMFlKHZ5hWkv0BTLbnYtYvS6VpVUM2qWqdGvKLL17umRpMFlKLT9EH9yTir5AZrt3EavWpbK0jiG7VJVeMGOW3j9dsjSYLKWaXz0qqoboC2S2uxexWl0qSysZsEtV6SUTZumB6ZKlwWQp9bjzqYboC2S2+xexSl0qS2sZrktV6UXzZemR6ZKlwWQpNf0YfYBPKPoCme3AIlanS2VpNYN1qSq9bLosPTRdsjSYLKUqH+QXF32BzHZkEavSpbK0nqG6VJXumC1Lj02XLA0mS6nLB/mlRV8gsx1axGp0qSytaKAuVaV7JsvSg9MlS4PJUmpzR35Z0RfIbMcWsQpdKktrGqZLVemuubL06HTJ0mCylOp+8Wj9kqIvkNkOLmLlu1SWVjVIl6rSfVNl6eHpkqXBZCn1/fZ19HE+k+gLZLaji1jxLpWldQ3Rpar0ipmy9Ph0ydJgspQGHn8XfaBPJPoCme3wIla6S2VpZQN0qSq9ZqIsTZguWRpMltKEJ0UVE32BzHZ8ESvcpbK0tu67VJVeNU+WpkyXLA0mS2njZ18wLST6ApktYREr26WytLrOu1SVXjdNliZNlywNJktpxBNMC4m+QGZLWcSKdqksra/rLlWlN8ySpWnTJUuDyVJaeezGpyKiL5DZkhaxkl0qSxvouEtV6S2TZGnidMnSYLKUZtz4VET0BTJb2iJWsEtlaQvddqkqvWmOLE2dLlkaTJbSkC4tIPoCmS1xESvXpbK0iU67VJXeNkWWJk+XLA0mS2npp+gDfgLRF8hsqYtYsS6VpW102aWq9A4zZGn6dMnSYLKUpnRptugLZLbkRaxUl8rSRjrsUlV6jwmyNGO6ZGkwWUpbv3pQVKboC2S29EWsUJfK0la661JVepfxszRnumRpMFlKY7o0U/QFMlvGIlamS2VpM511qSq9z/BZmjVdsjSYLKW1Xz0oKkv0BTJbziJWpEtlaTtddakqvdPwWZo1XbI0mCylOQ8wzRJ9gcyWtYiV6FJZ2lB6Cn7Yz6YsVqXDZ2neoSNLg8lS2tOlOaIvkNnyFrECXSpLW+qmS1Xp3QbP0swDR5YGk6UE0KUZoi+Q2TIXsc8fBG/AxsHhC4/evU66VJXeb+wszT1sZGkwWUoEXZou+gKZLXcR+yy3S2VpW110qSo9YOgszT5oZGkwWUoMP/iUKvoCmS17EcvtUlnaWAddqkqPGDlL8w8ZWRpMlhJElyaKvkBmy1/EMrtUlrYW3qWq9JCBs7TAASNLg8lSoujSNNEXyGwFFrG8LpWlzQV3qSo9JjZL02erzOEiS4PJUsLo0iTRF8hsJRaxrC59t8AGPO/g8IVHH0Nol6rSg0KzNLpKZWk0WUocXZoi+gKZrcgiltWlhZ88dHD0soOPIrBLVelRkVkaXqWyNJosJY778VNEXyCzlVnEOurSg4MXHXscYV2qSg8LzNL4KpWl0WQpgXRpgugLZLZCi1g/XXpw7JJDjySoS1XpcXFZ2kGVytJospRIuvS46AtktlKLWDddenDogiOPJaRLVWmCsCztoUplaTRZSihdelj0BTJbsUWsly49OHK5gUcT0KWqNEVUlnZRpbI0miwl1uOvos+B0URfILOVe2+lky49OHCxccfTvEtVaZKgLO2jSmVpNFlKsF+/jD4JBhN9gcxW8JtofXTpwXFLDTuixl2qStPEZGknVSpLo8lSounSY6IvkNlK3rfbRZceHLbQqGNq2qWqNFFIlvZSpbI0miwl3K/RZ8FYoi+Q2Yo+5bCHLj04aplBR9WwS1Vpqogs7aZKZWk0WUq8n6JPg6FEXyCzlf1NmA669OCgRcYcV7MuVaXJArK0nyqVpdFkKR34Mfo8GEn0BTJb4V/Qju/Sg2OWGHJkjbpUlaZrn6UdVaksjSZL6YGfIb1f9AUyW+Esje/Sg0MWGHFsTbpUlWZonqU9VaksjSZL6cK30WfCOKIvkNlKZ2l4lx4cMX/A0TXoUlWao3WWdlWlsjSaLKULHqt/t+gLZLbiWRrdpQcHLLDDo6vepao0S+Ms7atKZWk0WUofHntM1J2iL5DZymdpcJceHK/EDo+ucpeq0jxts7SzKpWl0WQpnfD40jtFXyCzVcjS2C49OFyRHR5d1S5VpZmaZmlvVSpLo8lSeuExUfeJvkBmq5GloV16cLQyOzy6il2qSnO1zNLuqlSWRpOldOOH6LNhDNEXyGxVsjSySw8OVmiHR1etS1VptoZZ2l+VytJospR+uB3/HtEXyGx1sjSwSw+OVWqHR1epS1VpvnZZ2mGVytJospR+uB3/HtEXyGyVsjSuSw8OVWyH//Th66NKn68rs5XROS9HvyDpCh9TzbK0xyqVpdFkKR1x29Mdoi+Q2WplaViXHhyp3A4/1eMiWt3ubH0UvWUxCh9TrbK0yyrt8oySpRDk5+gTYgDRF8hs1bI0qksPDlRwh5/ocRGtb2e2so6AgRU+phplaZ9V2uUZJUshitueboq+QGarl6VBXXpwnJI7/KjPRbSBi7O1apWOmaWdVmmXZ5QshTDfRJ8S3Yu+QGarmKUxXXpwmKI73Oci2sKF2Vq2SofM0l6rtMszSpZCGL/2dEv0BTJbzSwN6dKDo5Td4S4X0SY2s7VulY6Ypd1WaZdnlCyFOL9EnxO9i75AZquapRFdenCQwjvc4yLaxtlsLVylA2Zpv1Xa5RklSyGQr5deF32BzFY3SwO69OAYhfe3x0W0kRdma+UqHS9LO67SLs8oWQqRfL30qugLZLbKWdq+Sw8OUXh3e1xEW3lutpau0uGytOcq7fKMkqUQyddLr4q+QGarnaXNu/TgCIX3tsdFtJm/Z2vtKh0tS7uu0i7PKFkKoXy99JroC2S26lnauksPDlB4Z3tcRNv5sMCMT6DwMVU5S/uu0i7PKFkKsb6PPi96Fn2BzFY/Sxt36cG/X3hfe1xEG/owe75nUPiYqpulnVdpl2eULIVgX0efGB2LvkBma5Clbbv04J8vvKs9LqItfahKx8rS3qu0yzNKlkKwX329dFf0BTJbiyxt2qUH/3rhPe1xEW3qQ1U6UpZ2X6VdnlGyFKL9GH1m9Cv6ApmtSZa27NKDf7zwjva4iNJY4WOqYpb2X6VdnlGyFMJ5StSe6AtktjZZ2rBLD/7twvvZ4yJKY4WPqXpZOkCVdnlGyVII95uP8XdEXyCzNcrSdl168E8X3s0eF1EaK3xMVcvSEaq0yzNKlkK8n6PPjV5FXyCztcrSZl168C8X3sseF1EaK3xM1crSIaq0yzNKlkIHvo0+OToVfYHM1ixLW3XpwT9ceCd7XERprPAxVSlLx6jSLs8oWQod8GNPl0VfILO1y9JGXXrw7xbexx4XURorfEzVydJBqrTLM0qWQg98jH9R9AUyW8MsbdOlB/9s4V3scRGlscLHVJUsHaVKuzyjZCl0wd34l0RfILO1zNImXXrwrxbewx4XURorfEzVyNJhqrTLM0qWQhfcjX9J9AUyW9MsbdGlB/9o4R3scRGlscLHVIUsHadKuzyjlspSpvH1N3/4/ocffv7l1+icLMZD9S+IvkBma5ulDbr04N8svH89LqI0VviYKp+lA1Vpl2eULGV433z7w08zvBP+dfQL2aHoC2S2xllav0sP/snCu9fjIkpjhY+p4lk6UpV+/mrGxtYiS5nEV9/88PNv0WWZ5dfol7BD0RfIbA8+a7zO1O7Sg3+x8N7JUnrPUlWaS5Yyky+//WHg902/j375+hN9gcw3W5ce/IOFd06W0nmWqtJsspTpfDNqmj7+Kvql6070BbKAybr04N8rvG+ylL6zVJXmk6XM6Mtvf3ocHZkJPLz0XPQFsoS5uvTgnyu8a7KUrrM0p0r/VXjHbum1SmUp0/r6x/G+aurhpWeiL5BFTNWlB/9a4T2TpfScpTlV+nbh/bql2yqVpcxsuDL9LfoV6030BbKMmbr04B8rvGOylI6zVJUWIUuZ29djfZr/Q/Tr1ZnoC2Qhzbv0o5ytvdqlB/9W4f2SpfSbpaq0DFnK9L4b6A6ox37r6QXRF8hSmndpzgp5tUsP/qnCuyVL6TZLVWkhspQFfPXjMG+Z/hT9WvUl+gJZzDRdevAvFd4rWUqvWapKS5GlLOHL70b5lqnfenpe9AWynFm69OAfKrxTspROs1SVFiNLWcW3Y3yW/0v069SV6AtkQZN06cG/U3ifZCl9ZqkqLUeWso5vhgjTb6Nfpp5EXyBLmqNLD/6ZwrskS+kyS1VpQbKUlXz9U3R03uYhUc+JvkAWNUWXHvwrhfdIltJjlqrSkmQpaxngHdPvol+jjkRfIMuaoUsP/pHCOyRL6TBLVWlRspTVdB+mHhL1j+gLZGETdOnBv1F4f2Qp/WWpKi1LlrKebzu/K98z9f8WfYEsbfwuPfgnCu+OLKW7LFWlhclSVvRD188x9Xbp36IvkMUN36UH/0LhvZGl9JalqrQ0WcqSvuz63idvl/4l+gJZ3uhdevAPFN4ZWUpnWapKi5OlLOqbX6Pjc5+3S/8SfYGsYPAuPfjvC++LLKWvLFWl5clSlvVDdH3u8xOkz0RfIGsYu0sP/vPCuyJL6SpLVWkFspR1fdXvPflfRb82nYi+QFYxdJce/NeF90SW0lOWqtIaZCkr+77XW5+8Xfqn6AtkHSN36cF/XHhHZCkdZakqrUKWsrSve/2GqbdLn4q+QFYycJce/LeF96NRlr721gf//nRY//7grdfavE5PFNjgd46NWPiYSs9SVVqHLGVxnX7D1NulT0VfIGsZt0sP/tPCu1E/S1955+F/oo/6Ej799zuvVH+xniiwrR8cG7HwMZWcpaq0ElnK6r7p8uH6bsZ/KvoCWc2wXXrwXxbei7pZ+tJbD/8XfcSX9L+Hb1V9vZ4qsJ1jZulIVfpopCqVpfDlz9ENeolnlz4RfYGsZ9QuPfgPC+9ExSx96Z2Po4/2Gj4++An5YQW2ccgsHapK387Y2PZkKfzf99ENeoG3S5+IvkBWNGiXHvx3hfehWpa+8fCL6GO9li8eVv2maYEtHDFLVWk9shT+7/++6fCOfG+X/t/UWXp6+fPGi1ORLj34zwrvQqUsfWeKr5PuO3pT0REFNm/ALFWlFclS+MNX/d2R/zj6NelB9AWyqldH7NKD/6rwHtTI0pc+mOoLpZf9r1qYFti48bJUldYkS+GJL3+KztCN76Jfkw5EXyDrGrFLD/6jwjtQIUvfm/bT+xfVCtMCmzZcln527J+8QJXeJEvhT909Keq36FekA9EXyMoG7NKD/6bw9hfP0rcWeKf0L/97o/Sr90SBDRstSz97cOyfPE+V3iZL4Znvojv03LfRr0i86AtkbeN16cF/UnjzC2fpK59GH+BtfVrhUaYFNmuwLFWllclS+MvXnd349Ev0CxLvpegrZG3DdenBf1F468tm6XrL3xcHC/AOBbZqrCxVpbWtd17Crq87e7L+19EvSLgqHzt2ZbQuPfgPCm98ySx9bfLb7y/7T+mnRRXYpqGy9HVVWpsshX982dcN+X6BdP4sHa1LD/73hbe9YJa+F31sB/nivXKv4RMFNmmoLM2gSu8jS+E5nXXp8o/UXyBLB+vSgwpverEsfWnKn3S6z8dFvxpTYIMWyVJVeidZCs/rq0uXf6T+Clk6dZcW3vJSWfraQjfgbxX9IL/A9qyRpar0XrIUXtBVly7/jKglsnTmLi284YWy9J1FnlW654uC51WBzVkiS1Xp3WQpvKirLl39GVFrZOnEXVp4u8tk6TvRh3W8cs/WL7AxK2SpKr2fLIUzPXXpz9EvRrBFsnTeLi282UWy9GH0Ud2DYk+Kar8thY+pJlmqSg+QpXCupy79KvrFiLVKlk7bpYW3ukSWqtKnHhZ4KZ8osCnzZ6kqPUKWwkZHXbr4TU/LZOmsXVp4owtkqSp9plCXFtiS6bNUlR4iS2Grny5d/KandbJ00i4tvM35WapK/1amSwtsyOxZqkqPkaVwwZfd/A7p2jc9LZSlc3Zp4U3OzlJV+pwiD9YvsB2TZ6kqPUiWwiVf99Kla9/0tFKWTtmlhbc4N0vdg/+CEvfjF9iMubNUlR4lS+Gir6N79C9L/9LTUlk6Y5cW3uDMLH0r+njuTYHzq8BWTJ2lqvQwWQqXfRfdo898H/1CRForSyfs0sLbm5elry3+FP2tL17JnuECWzFzlqrS42Qp7PghOkj/9Gv06xBpsSydr0sLb25Wlr609C+OXvafl3JnuMBGTJylqjSBLIU9P0cX6Z9WfnTpalk6XZcW3tqsLP04+mjuUfbt+AW2Yd4sVaUpZCns6eQxUT9Gvw6BlsvS2bq08MbmZOl70Qdzn3JveyqwCdNmqSpNIkth11dd3I6/8qNL18vSybq08LZmZOlr0cdyp3K/XlpgE2bNUlWaRpbCvm+jk/Spr6NfhjgLZulcXVp4UzOy9D/Rx3KvPs2b4QJbMGmWqtJEshSu6OK2p4U/xV8xS6fq0sJbmp6llrpdeU/VL7ABc2apKk3lXIVrfolu0j88jn4R4iyZpTN1aeENTc7SVzwbatcXWXfjF9iAKbNUlSaTpXBNF79Cuu4PkK6ZpRN1aeHtTM7ST6OP5J5l3Y1fYPwZs1SVppOlcFUPXy/9KfpFCLNols7TpYU3MzVL34g+kPuWc5oVGH7CLFWlGWQpXPdjdJSu/Cn+qlk6TZcW3srULPUg/aty7noqMPx8WTpOlb5acrcLkaVwXQ9PL132Xvzhs/TNB4n/cJIuLbyRiVn6TvRx3LuMh5cWGH26LB2nSj/M+znfOmQp3PB1dJQufC/+8Fn6/mdrd2nhbUxcRL1ZesP/0me4wOizZelAVZr3u2mVyFK4Jf4pUcs+UX/8LH20dpcW3sS0RdSbpTelv11aYPDJsvT1wht4U0aVylIYU/zH+Kt+ij9Blq7dpYW3MG0R9WbpTf9JnuECg8+Vpc1P25wqlaUwpviP8X+IfgmCzJClS3dp4Q1MWkS9WXqH5DOtwNhTZelYVSpLYVDhd+P/Gv0KBJkiSwfq0uKPmSm8fUmLqGeW3uHj1BkuMPZMWTrOKfu0SmUpDOrL36K79MvolyDGHFm6cJcW3ryURfSV6IN4DK8kznCBoSfK0nFO2D+rVJbCqMIfqv9d9CsQY5IsXbdLC29dyiL67+iDeAwH2/Bv7YcufEyVzNJxTtdnVSpLYVi/BGfpz9EvQIxZsnTZLi28cSmL6BfRB/EYUp8RVWDoabJ0nJP1ryqVpTCsr4KzdNEfepomS1ft0sLblrCIvhV9DI8i8VwrMPIsWTrOqfp3lcpSGFf0w0vXfETUPFm6aJcW3rSERfRh9DE8iodpM1xg5EmydJwT9Z8qlaUwri8fx2bpmo+ImihL1+zSwluWsIj6DP9OiZ/iFxh5jiwd5zR9rkplKQzs+9gs/SV6/0PMlKVLdmnhDTu+iPoM/26vJc1wgYGnyNJxTtLnq1SWwsiCHxK15COipsrSFbu08HYdX0Tdh3+3tHvx2w9c+Jgqk6XjnKIvVKkshZF9F5ul30bvf4S5snTBLi28WccX0f9EH8Lj+DRphgsMPEGWjnOCvlilshSGFvuQqB+jdz/CZFm6XpcW3qrDi+hL0UfwSJJmuMC442fpOKfnWZXKUhjaN6FZuuTvj86Wpct1aeGNOryI+mrpAUlnW4Fxh8/ScU7O8yqVpTC22LdLV/xy6XRZulqXFt6mw4uor5YekPTl0vbjFj6m8rN0nFNzU6WyFMYW+3bpil8unS9LF+vSwpt0eBH9NPoIHsnHKTNcYNzBs3ScE3NbpbI02tffZAl7s+qrvO1+QdxD2QvuRNxU/BqZpSt+uXTCLF2rSwtv0eFFNPoAHkrSk0sLjDt2lo5zWl6oUlkaLf8j2F9/+fGH9k1U+D26x7/8/MO37fO08Afgf0zF9+2nIvRm/BWfXDpjli7VpYU36Ogi+kr0ATyWlBkuMOzQWTrOSXmpSmVptFJh9NtP33015Ia/4Jcfvmm6E1WKrvlUhD67tOme9mHKLF2pSwtvz9FF9I3oA3gsKadbgWFHztJxTsmLVSpLo5Wsu99+bPh+Y7X36H7+ruH7jbWK7tcppuIebf8/ogtzZulCXVp4c44uou9FH8BjeSdhhgsMO3CWjnNCXq5SWRqt8JuOv/3Y7I26iu/R/dzsRpqKRffbD62m4svH9fbipu8b7WRHJs3Sdbq08NYcXUSXWuDypdyK337YwsfURwk7/Zfmp+O7qVu6U6WyNFr5z8J/adR0VX+O/XGjpqtbdD83eivxh5o7cWsf2+xiT2bN0mW6tPDGHF1EP44+gMfy74QZLjBsaJYmn4mngJPxw9Qt3atSWRqtxlc0f/uuxZbXfo/upyZh+mPdnWgzFV/V3Ynre9hiB/sybZau0qWfld2Wo4uo50MdkvLzowWGjczSxatUlkar8zD0JjX0U5VNf06LMK1edE2m4ufae3HFeg/UnzdL09fDN2sseNfkdOmDsl0qS6taL0tXr1JZGq3Wb/T8Vv/z468rbfpzfqjfPPV/JOmX+lMR+Uj99R6oP3GWpq+Ib5df8K7rp0tlaVXLZenyVSpLo9Wrop+rv9fY4Dnuj6tHT4vb2H+qXteBz4j6ofa+dWfmLNWlx8nSqlbLUlUqS6NVfLPuce2bpJs8mOiX2nXd4jb26nUdeNPTeg/UnzpLdelhsrSqxbJUlcrScFU/Q66cdF/W3Pa/Pa785czKNz0983PdN0wDb3pa756nubNUlx4lS6taK0tV6SNZGq7uVxsrv0tX/aanP9X9DLzBV2SfeFz3G6aBNz0td8/T5FmqSw+SpVUtlaWq9AlZGqz2HTdVv/n3beWN/8uvVX8yqcFXZJ+q+p2KwF96Wu53nmbPUl16TECWfvrBYQVG/d/xUR8W2NeEuc0fNSZLVelTsjRY9RvBq3563Ornhaq+61v1dwGeV/Nd3zZfqLhouXueps9SXXpIQJYm/PJRgWU1IRDfCBn1lD9qSJaq0j/J0mD1n0/0a8UYavQp/h8qfsG03fcy55iKcz/V26k+zZ+luvQIWbpPlh6gSp+RpcHqZ+nvj+t9BN7qU/zfq74n1+pT/Kpd2nAqzix3K/4CWapLD5Cl+2Tp/VTpX2RpsAZZWrNLW32K/3vNN+WafYpfdSra7cS5arvUqRWyVJfeT5buk6V3U6V/k6XBWmRpxRhq+dFxtS5t+XSlelMRdy9+g9+I7coSWapL7yZL98nSe6nSf8jSYE2ytF4MNf3ouFqXtvsU//fff6v1OX7cvfir3Yq/Rpbq0nvJ0n2y9E6q9DmyNFibLK0XQw0/xa9331ObJ+o/U+v7pXH34q92K/4iWapL7yRL98nS+6jS58nSYI2ytFoMtf3ouFKXNnqi/jO/1tmJZofSxo+VdqhXq2SpLr2PLN0nS++iSl8gS4M1a4mf62x/24+Oa30Zoel7vrW+jNDwzq0XrXYr/jJZqkvvIkv3ydJ7qNIXydJg7d7iqvNRa+MfY6/0ZYTGD/2s86Zv2/d8n/O4yu70a50s1aX3kKX7ZOkdVOkZWRqs4Sevde5M+a3dDjxR55251rcL1XnTt+17vs+psjf9WihLdekdZOk+WXqbKj0nS4M1zNLHVd5pbHq70O+Vflm+8Xu+ld70DXtEVL2HsXZppSzVpbfJ0n2y9CZVuiFLg7W8T6XK10ub/7pQlQZq/J5vna+Xhn25dLEnRC2Vpbr0Jlm6T5beskaVHrsYyNJgTW+f/rbCDjR/LlGVG9mb/6J8jakI+3LpYk+IWitLdektsnSfLL1BlV4gS4M1zdIqH+O3fBb9UzUiqPmz6Kt8jB/15VJZOpZjWfros9RxFulSWbpPll6nSi+RpcHaPmyyxmfHzd9ofFzhxy5bf7m0zsM+o75cutgTolbL0nbLUbaQLpWl+2TpVar0IlkarPEz0Ct8C7D9j17W+I5s+zcaK8T1D8134k+ydCxHs1SXXiVL98nSa1TpZbI0WOMsrRAQAd9orBDX7X8iqcJUfNN8J/602INL18tSXXqNLN0nS69QpTtkabDWOVThVpvGe/B7laILeKOxQly334k/ld+Tni2Ypbr0Clm6T5buU6V7ZGmw1ln62/i78HuNomv+nKsqcd389rNnKnwhoWMrZqku3SdL98nSXap0lywN1rzpyv/wZesH6v9eo+ja3/NUI66j7nla68GlS2apLt0lS/fJ0j2qdJ8sDdY8S8sXXft7nmp0UMDDlcpPRdQ9T7J0KElZqkv3yNJ9snSHKr1ClgZr/wl48YSIuNGm/M34AV9FKP/Zd9Q9T2s9uHTRLNWlO2TpPll6mSq9RpYGa19D5Z9d2nwXfq9QdAFfRSg/FRFfRXhClg4lMUt16WWydJ8svUiVXiVLgwW8SVf894Va/6D8E8WfRh/xg/LlH6wUsBNPyNKhpGapLr1Ilu6TpZeo0utkabCALP1+gn0o/0SBkM+/i99/FjEVv1vZz2QAACAASURBVK/2PP11s1SXXiJL98nSC3Kq9MECVSpLowV0xK+l9yHi8+/iD2AN+fy7+Fdkg27Fl6VDSc9SXXqBLN0nS7eyqjT1F3JThZzwsjTYDHfahNz/Xfx7mRE7UfwLFUG34svSoWRk6UBd+mbGK3Ro9Zel+2Tpxn9V6S2yNFhElpb+FD/k8+/i38sMeRR96U/xIx7W9ftqvz66dJaO06Wfv5rxEh1Z/2XpPlla8rBcpEplabSILC393lbMY4m+LrwXIV/LLP0pftQTogrvRt/WzlJdek6W7pOlBQ/KVapUlkYLiaHSHx1H7EPxu79DviFb+m3GryN24ndZOpa8LNWlZ2TpPlla7pBcpkplabSQLC19u1DEPhR/zzfma5ml3/MN2QlZOpbMLNWlL5Kl+2RpsQNynSqVpdFCsrT0G40hX8ssnUIRDy4t/z3fkJ2o8OsGPVs+S3XpC2TpPlla6nBcqEplabSQLC39RmPM0zIL/4pqzNcyS3+5NOjBpcV/0bZnslSXPk+W7pOlhQ7GlapUlkaLyYgpdqLwG40xWVr6ZwFkaX2ydJUuve8XdWTpPlla5lBcqkplabSYjCj8jcaYr2UWfnJp0O/JF779TJbWJ0sf6dLnyNJ9srTIgbhWlcrSaDEZUfiep5gsLf1VhJCdKB10Qc/Tl6UjKZGluvRvsnSfLC1xGC5WpbI0WkyWFr7nKaiFyu5EUJYW/iqCLK1Plj6lS5+RpftkaYGDcLUqlaXRYrK08OffMTexl/78O2Yn5vg/hNKPHOuaLP1T9OJ1t8pdKkv3ydL8Q3C5KpWl0WKytPDn30G/LVT4LbrHITtR+Fb8oCwt/cixrsnSZ8KXr3vV7VJZuk+WZh+A61WpLI0mS9MVztIppuK7kJ2QpUMplaUdLGB3qtqlsnSfLM09/BasUlkaLejO6bI7EZSl35XdiymyNGgqZOlIimVpD0vYfWp2qSzdJ0szD74Vq1SWRpOl6Qq3kKlIJ0tHUi5Lu1jE7lKxS2XpPlmqSo+TpcG0UDpZujXHVPRNlj6ni2XsHvW6VJbuk6Wq9DhZGkwLpZOlW3NMRd9k6fP6WMjuUK1LZek+WapKj5OlwbRQOlm6NcdU9E2WvqCTpey2Wl0qS/ctn6WqNIEsDaaF0snSrTmmom+y9EW9LGY3VepSWbpv9Swdqko/Sd3S0ieyLA2mhdLJ0q05pqJvsvTM4l0qS/ctnqVDVelnDxK3tPhpLEuDaaF0snRrjqnomyw9t3aXytJ9a2epKk0jS4NpoXSydGuOqeibLN1I7tIPi2/KdTW6VJbuWzpLVWkiWRpMC6WTpVtzTEXfZOnWyl0qS/etnKWqNJUsDaaF0snSrTmmom+y9IKFu1SW7ls4S1VpMlkaTAulk6Vbc0xF32TpJet2qSzdt26WqtJ0sjSYFkonS7fmmIq+ydKLlu1SWbpv2SxVpRlkaTAtlE6Wbs0xFX2TpZet2qWydN+qWapKc8jSYFoonSzdmmMq+iZLdyzapbJ036JZqkqzyNJgWiidLN2aYyr6Jkv3rNmlsnTfmlmqSvPI0mBaKJ0s3ZpjKvr2TvQVMle1LF2zS2XpviWzVJVmkqXBtFA6Wbo1x1T0LaEJ+lIvS5fsUlm6b8UsVaW5ZGkwLZROlm7NMRV9k6VXLNilsnTfglmqSrPJ0mBaKJ0s3ZpjKvomS69Zr0tl6b71slSV5pOlwbRQOlm6NcdU9E2WXrVcl8rSfctlqSotQJYG00LpZOnWHFPRN1l63WpdKkv3rZalqrQEWRpMC6WTpVtzTEXfZOkNi3WpLN23WJaq0iJkaTAtlE6Wbs0xFX2Tpbes1aWydN9aWapKy5ClwbRQOlm6NcdU9E2W3rRUl8rSfUtlqSotRJYG00LpZOnWHFPRN1l620pdKkv3rZSlqrQUWRpMC6WTpVtzTEXfZOkdFupSWbpvoSxdo0pfb7F1sjSYFkonS7fmmIq+ydJ7rNOlsnTfOlm6RpWe/e5uJbI0mBZKJ0u35piKvsnSuyzTpbJ03zJZqkoLkqXBtFA6Wbo1x1T0TZZWXlwG61JZum+ZLH05YSufUaXnZGkwLZROlm7NMRV9k6V3ejt1A8fq0ncP/gNZWnvUU/6o7c5yVbohS4NpoXSydGuOqeibLL3XGl16lCytPeopf9RmZ7kq3ZKlwbRQOlm6NcdU9E2W3k2XXiBLa496yh+11VmuSi+QpcG0UDpZujXHVPRNlt5Pl27J0tqjnvJHbXSWq9JLZGkwLZROlm7NMRV9k6UH6NINWVp71FP+qG3OclV6kSwNpoXSydKtOaaib7L0CF16TpbWHvWUP2qTs1yVXiZLg2mhdLJ0a46p6JssPUSXnpGltUc95Y/a4ixXpTtkaTAtlE6Wbs0xFX2Tpcfo0hfJ0tqjnvJHbXCWq9I9sjSYFkonS7fmmIq+ydKDdOkLZGntUU/5o9Y/y1XprjeLvtBlyNL6yu7EHC1kKtItlaVvRV8hczVfZnTp82Rp7VFP+aNWz1JVuiv5clHTWwWOqWFooXSydGuOqejaO9EXyHzjLDQzdqksrT3qKX/U6ln6SeMjW5VmeqfAQTUKLZROlm7NMRU9m6BKR1pqJuxSWVp71FP+qLWztPVxrUqzLdSlWiidLN2aYyo6NkWVjrTYNO/S1PX7brK09qin/FErZ6kq3dNtla7UpVoonSzdmmMq+jVJlY603Ayzgt9LltYe9ZQ/at0sHeaYHucy0cIyXaqF0snSrTmmolvTVOlIC84wa/idZGntUU/5o1bN0mGO6HEuEm2s0qVaKJ0s3ZpjKno1UZWOtOQMs4rfR5bWHvWUP2rNLB3meB7nEtHKIl2qhdLJ0q05pqJTU1XpSIvOMOv4XWRp7VFP+aNWzNJhjuZxLhDtrNGlWiidLN2aYyr6NFmVjrTsDLOS30OW1h71lD9qvSwd5lhufnn4V9HXuZIlulQLpZOlW3NMRZemq1Jduq9ml8rS2qOe8ketlqXDHMnNLw4fFn2dq1mhS7VQOlm6NcdU9GjCKj2dXm+88ujSkyytP+opf9RaWTrMcaxK9yzQpVoonSzdmmMqOjRllZ5Obzdee3SpLK0/6il/1EpZOsxRrEr3zd+lWiidLN2aYyr6M2mV6tJ91bpUltYe9ZQ/ap0sHeYYVqXXTN+lWiidLN2aYyq6M22V6tJ9tbpUltYe9ZQ/apUsHeYIVqXXzd6lWiidLN2aYyp6M3GV6tJ9lbpUltYe9ZQ/ao0sHeb4VaW3TN6lWiidLN2aYyo6M3WV6tJ9dbpUltYe9ZQ/aoUsHeboVaW3zd2lWiidLN2aYyr6MnmV6tJ9VbpUltYe9ZQ/avksHebYVaX3mLpLtVA6Wbo1x1R0Zfoq1aX7anSpLK096il/1OJZOsyRq0rvM3OXaqF0snRrjqnoyQJVqkv3VehSWVp71FP+qKWzdJjjVpXea+Iu1ULpZOnWHFPRkSWqVJfuK9+lsrT2qKf8UQtn6TBHrSq937xdqoXSydKtOaaiH4tUqS7dV7xLZWntUU/5o5bN0mGOWVV6xLRdqoXSydKtOaaiG8tUqS7dV7pLZWntUU/5oxbN0mGOWFV6zKxdqoXSydKtOaaiFwtVqS7dV7hLZWntUU/5o5bM0tbH6+eqtJVJu1QLpZOlW3NMRSeWqlJduq9sl8rS2qOe8kctmKXNq/TVxA1VpcfN2aVaKJ0s3ZpjKvqwWJXq0n1Fu1SW1h71lD9quSxVpXsmqNJJu1QLpZOlW3NMRReWq9KBuvTBZ403tGSXytLao57yRy2Wpap0zxRVOmeXaqF0snRrjqnowYJVqkv3FexSWVp71FP+qKWyVJXumaRKp+xSLZROlm7NMRUdWLJKdem+cl0qS2uPesoftVCWqtI901TpjF2qhdLJ0q05piLeolWqS/cV61JZWnvUU/6oZbJUle6ZqEon7FItlE6Wbs0xFeGWrVJduq9Ul8rS2qOe8kctkqWqdM9UVTpfl2qhdLJ0a46piLZwlerSfYW6VJbWHvWUP2qJLFWleyar0um6VAulk6Vbc0xFsKWrVJfuK9OlsrT2qKf8UQtkqSrdM12VztalWiidLN2aYypiLV6lunRfkS6VpbVHPeWPmp+lqnTPhFU6WZdqoXSydGuOqQi1fJXq0n0lulSW1h71lD9qdpaq0j1TVulcXaqF0snSrTmmIpIqPenSfQW6VJbWHvWUP2pulqrSPZNW6en07wJHXSe0UDpZujXHVARSpU/p0j35XSpLa496yh81M0tV6Z5pq/R0eljgsOuDFkonS7fmmIo4qvQZXbonu0tlae1RT/mj5mWpKt0zcZVO1KVaKJ0s3ZpjKsKo0r/p0j25XSpLa496yh81K0tV6Z6pq3SeLtVC6WTp1hxTEUWVPkeX7snsUllae9RT/qg5WapK90xepdN0qRZKJ0u35piKIKr0Bbp0T16XytLao57yR83IUlW6Z/oqnaVLtVA6Wbo1x1TEUKVndOmerC6VpbVHPeWPmp6lqnTPAlU6SZdqoXSydGuOqQjx7+gLWn906Z6cLpWltUc95Y+anKWqdM8SVTpHl2qhdLJ0a46piPAw+nLWI126J6NLZWntUU/5o6ZmqSrds0iVTtGlWiidLN2aYyoCqNKLdOme9C6VpbVHPeWPmpilw1Rp8/NlmSqdoUu1UDpZujXHVLSnSnfo0j3JXSpLa496yh81LUtV6Z6FqnSCLtVC6WTp1hxT0Zwq3aVL96R2qSytPeopf9SkLFWle5aq0vG7VAulk6Vbc0xFa6r0iuZdOsxam9ilsrT2qKf8UVNeYlW6Z7EqHb5LtVA6Wbo1x1Q0pkqvat2l46y2aV0qS2uPesofNeElVqV7lqvS0btUC6WTpVtzTEVbqvQGXbonqUtlae1RT/mjHn+JVemeBat08C7VQulk6dYcU9GUKr1Jl+5J6VJZWnvUU/6oh19iVbpnySodu0u1UDpZujXHVLSkSu+gS/ckdKksrT3qKX/Uoy+xKt2zaJUO3aVaKJ0s3ZpjKhpSpXfRpXuOd6ksrT3qKX/Ugy+xKt2zbJWO3KVaKJ0s3ZpjKtpRpXfSpXsOd6ksrT3qKX/UYy+xKt2zcJUO3KVaKJ0s3ZpjKppRpXfTpXuOdqksrT3qKX/UQy+xKt2zdJWO26VaKJ0s3ZpjKlpRpQfo0j0Hu1SW1h71lD/qkZdYle5ZvEqH7VItlE6Wbs0xFY2o0kN06Z5jXSpLa496yh/1wEusSvcsX6WjdqkWSidLt+aYijZU6UG6dM+hLpWltUc95Y96/0usSveo0tOgXaqF0snSrTmmoglVepgu3XOkS2Vp7VFP+aPe/RK/2/hIG+ecUKVPjdilWiidLN2aYypaUKUJdOmeA10qS2uPesof9d6X2BmxR5U+M2CXaqF0snRrjqloQJUmsQrv+ejuTZOltUc95Y9650vsfNijSv82XpdqoXSydGuOqahPlSayDu+5ex2WpbVHPeWPet9L7GzYo0qfM1yXaqF0snRrjqmoTpUmsxLvuXcllqW1Rz3lj3rXS+xc2KNKXzBal2qhdLJ0a46pqE2VZrAW77lzLZaltUc95Y96z0vsTNijSs8M1qVaKJ0s3ZpjKipTpVmsxnvuW41lae1RT/mj3vESOw/23P8962WM1aVaKJ0s3ZpjKupSpXlaP6jx8I/O/+XVzxtv6dt3bZYsrT3qKX/UO17iTg+vC4Y5Y6f10n8KHJLtaKF0snRrjqmo6z8vRV+khjbMGtdrNsjS2qOe8ke95yXu9QDbGuacndRgVaqFMsjSrTmmojJdmmGYFa7baJCltUc95Y9610vc7SG2McxZO6XRqlQLZZClW3NMRW26NNkw61u/ySBLa496yh/1vpe434Ps3DDn7YSGq1ItlEGWbs0xFdXp0kTDrG4dB4MsrT3qKX/UO1/ijg+zM8OcudMZr0q1UAZZujXHVNSnS5MMs7b1nAuytPaop/xR732Jez7QXjTMuTuZAatUC2WQpVtzTEUDujTBMCtb81j414GNk6W1Rz3lj3r3S6xL9+jSJ0asUi2UQZZuzTEVLejSw4ZZ15qnwqHHh8vS2qOe8ke9/yXWpXt06aBVqoUyyNKtOaaiCV160DCrWt9VKkurj3rKH/XAS/xm46NNl45jzCrVQhlk6dYcU9GGLj1kmDWt8yqVpdVHPeWPeuQlbv1zT7p0FINWqRbKIEu35piKRnTpAcOsaL1XqSytPuopf9RDL7Eu3bN2l45apVoogyzdmmMqWtGldxtmPeu+SmVp9VFP+aMee4l16Z6Vu3TYKtVCGWTp1hxT0YwuvdMwq1n/VSpLq496yh/14EusS/es26XjVqkWyiBLt+aYinZ06V2GWcsGqFJZWn3UU/6oR19iXbpn1S4duEq1UAZZujXHVDSkS+8wzEo2QpXK0uqjnvJHPfwS69I9a3bpyFWqhTLI0q05pqIlXXrTMOvYEFUqS6uPesof9fhLrEv3rNilQ1epFsogS7fmmIqmdOkNw6xiY1SpLK0+6il/1ISXWJfuWa9Lx65SLZRBlm7NMRVt6dKrhlnDBqlSWVp91FP+qCkvsS7ds1qXDl6lWiiDLN2aYyoa06VXDLOCjVKlsrT6qKf8UVNeYl26a60uHb1KtVAGWbo1x1S0pkt3tV6/Pn81cUOHqVJZWn3UU/6oSVmqS3et1KXDV6kWyiBLt+aYiuZ06Q5Vuie5SmVp9VFP+aOmZaku3bVOl45fpVoogyzdmmMq2tOlF6nSPelVKkurj3rKHzUxSwfq0s8ab+gqXTpBlWqhDLJ0a46pCKBLL1ClezKqVJZWH/WUP2pqlo7TpQ90aQ0zVKkWyiBLt+aYigi6dEOV7smpUllafdRT/qjJWapLd63QpVNUqRbKIEu35piKELr0jCrdk1WlsrT6qKf8UdOzVJfumr9L56hSLZRBlm7NMRUxHkZf0/qiSvfkVaksrT7qKX/UjCzVpbtm79JJqlQLZZClW3NMRRBd+hxVuiezSmVp9VFP+aPmZKku3TV3l85SpVoogyzdmmMqoujSv6nSPblVKkurj3rKHzUrS3Xprpm7dJoq1UIZZOnWHFMRRpc+o0r3ZFepLK0+6il/1Lws1aW75u3SeapUC2WQpVtzTEUcXfqUKt2TX6WytPqop/xRM7NUl+6atUsnqlItlEGWbs0xFYF06UmV7itQpbK0+qin/FFzs1SX7pq0Swuc1t3QQulk6dYcUxFJl6rSXSWqVJZWH/WUP2p2lurSXVN26cMCx1w3tFA6Wbo1x1SEWr5LVemeIlUqS6uPesofNT9LdemuCbt0qirVQhlk6dYcUxFr8S5VpXvKVKksrT7qKX/UAlmqS3dN16VzVakWyiBLt+aYimBLd6kq3VOoSmVp9VFP+aOWyFJdumuyLp2sSrVQBlm6NcdURFu4S1XpnlJVKkurj3rKH7VIlurSXVN16WxVqoUyyNKtOaYi3LJdqkr3FKtSWVp91FP+qGWyVJfumqhLp6tSLZRBlm7NMRXxFu1SVbqnXJXK0uqjnvJHLZSlunTXNF06X5VqoQyydGuOqejAkl2qSvcUrFJZWn3UU/6opbJUl+6apEsnrFItlEGWbs0xFT1YsEtV6Z6SVSpLq496yh+1WJbq0l1TdOmMVaqFMsjSrTmmogvLdekwVfrgv423tGiVytLqo57yRy2Xpbp01wRdOmWVaqEMsnRrjqnow2JdOk6Vtl49y1apLK0+6il/1IJZqkt3Dd+lc1apFsogS7fmmIpOLNWlqnRP4SqVpdVHPeWPWjJL23fp64kbqkuPmbRKtVAGWbo1x1T0YqEuVaV7SlepLK0+6il/1KJZ2rxLxzm7hu7SWatUC2WQpVtzTEU3lulSVbqneJXK0uqjnvJHLZulunTXwF06bZVqoQyydGuOqejHIl2qSveUr1JZWn3UU/6ohbNUl+4atkvnrVItlEGWbs0xFR1ZoktV6Z4KVSpLq496yh+1dJbq0l2DdunEVaqFMsjSrTmmoicLdKkq3VOjSmVp9VFP+aMWz1JdumvILp25SrVQBlm6NcdUdGX6LlWle6pUqSytPuopf9TyWapLdw3YpVNXqRbKIEu35piKvkzepap0T50qlaXVRz3lj1ohS3XpruG6dO4q1UIZZOnWHFPRmam7VJXuqVSlsrT6qKf8UWtkqS7dNViXTl6lWiiDLN2aYyp6M3GXqtI9tapUllYf9ZQ/apUs1aW7hurS2atUC2WQpVtzTEV3pu1SVbqnWpXK0uqjnvJHrZOlunTXQF06fZVqoQyydGuOqejPpF2qSvfUq1JZWn3UU/6olbJUl+4apkvnr1ItlEGWbs0xFR2askutkXsqVqksrT7qKX/UWlnqnNs1SJcuUKVaKIMs3ZpjKno0YZdaIffUrFJZWn3UU/6o1bLUWbfrk6KvcyUrVKkWyiBLt+aYii5N16XWxz1Vq1SWVh/1lD9qvSx13u2qe94VsUSVaqEMsnRrjqno02RdanXcU3l1lKW1Rz3lj1oxS515u7rv0jWqVAtlkKVbc0xFp6bqUmvjntproyytPeopf9SaWerc29V5ly5SpVoogyzdmmMqejVRl1oZ91RfGWVp7VFP+aNWzVJn366uu3SVKtVCGWTp1hxT0a1putS6uKf+uihLa496yh+1bpY6/3Z13KXLVKkWyiBLt+aYin5N0qVWxT0NVkVZWnvUU/6olbPUGbir2y5dp0q1UAZZujXHVHRsii61Ju5p8exEWVp71FP+qLWz1Dm4q9MuXahKtVAGWbo1x1T0bIIufbPxOjPOitjkid6ytPaop/xRq2epLt3VZZe+V+CYGoYWSidLt+aYiq6N36Xvt11lxlkP2/zOjCytPeopf9T6WeqXf3e9W/R1LqPA+TMOLZROlm7NMRV9ey/6CpmrbZaOsxo2+vVDWVp71FP+qA2yVJfueb/oy1yGLK2v7E7M0UKmIt1SWdpgwaqraZYOsxY2+01uWVp71FP+qE3Ocl16mSwNpoXSydKtOaaib7L0gFFWwnZVKkurj3rKH7XNWa5LL5KlwbRQOlm6NcdU9E2W3m+QdfBRwyqVpdVHPeWP2ugs16WXyNJgWiidLN2aYyr6JkvvNsYq+ER6lb569AYNWVp71FP+qK3Ocl16gSwNpoXSydKtOaaib7L0XkOsgU9lVOnnRxdRWVp71FP+qM3Ocl26JUuDaaF0snRrjqnomyy90wgr4J9yqvTwIipLa496yh+13VmuSzdkaTAtlE6Wbs0xFX2TpfcZYP17JqtKZekV62Tpmwmb+Sddek6WBtNC6WTp1hxT0TdZepf+V7+/5FWpLL1inSx99HbCdv5Jl56RpcG0UDpZujXHVPRNlt7l9cStG61KZekVC2WpLi1GlgbTQulk6dYcU9E3WXqP1EV6uCqVpVeslKW6tBRZGkwLpZOlW3NMRd9k6R3WqVJZesVSWapLC5GlwbRQOlm6NcdU9E2W3rZQlcrSK9bK0hW69O/DviJZGkwLpZOlW3NMRd9k6U0rVaksvWKxLNWlRcjSYFoonSzdmmMq+iZLb1mqSmXpFatlqS4tQZYG00LpZOnWHFPRN1l6w1pVKkuvWC5LdWkBsjSYFkonS7fmmIq+ydLrFqtSWXrFelmqS/PJ0mBaKJ0s3ZpjKvomS69arUpl6RULZqkuzSZLg2mhdLJ0a46p6JssvWa5KpWlV6yYpY9SY0+XPiNLg2mhdLJ0a46p6JssvWK9KpWlVyyZpcmxp0v/JEuDaaF0snRrjqnomyzdt2CVytIrlsxSXZpJlgbTQulk6dYcU9E3WbprxSqVpVesmaW6NI8sDaaF0snSrTmmom+ydM+SVSpLr1g0S3VpFlkaTAulk6Vbc0xF32TpjjWrVJZesWqW6tIcsjSYFkonS7fmmIq+ydLLFq1SWXrFslmqSzPI0mBaKJ0s3ZpjKvomSy9atUpl6RXrZqkuTSdLg2mhdLJ0a46p6JssvWTZKpWlVyycpbo0mSwNpoXSydKtOaaib7L0gnWrVJZesXKW6tJUsjSYFkonS7fmmIq+ydKthatUll6xdJbq0kSyNJgWSidLt+aYir7J0o2Vq1SWXrF2lurSNLI0mBZKJ0u35piKvsnSc0tXaZeLKK1dPjZ0aYoezyhZWl/ZnZijhUxFOlk6ktJZmlqlzVfeKlXa5SJKazsHhy5N0OMZJUvrK7sTc7SQqUgnS0dSOEsXr9IuF1Fa2zs6dOlxPZ5RsrS+sjsxRwuZinSydCRls3T1Ku1yEaW13cNjpC5NPUMKd2mPZ5Qsra/sTszRQqYinSwdSdEsXb5Ku1xEaW3/+BioS5PPkbJd2uMZJUvrK7sTc7SQqUgnS0dSMktVaZeLKK1dOUB06UE9nlGytL6yOzFHC5mKdLJ0JAWzVJX2uYjS2rUjRJce0+MZJUvrK7sTc7SQqUgnS0dSLktV6aM+F1Fau3qI6NJDejyjZGl9ZXdijhYyFelk6UiKZakqfaLHRZTWrh8juvSIHs8oWVpf2Z2Yo4VMRTpZOpJSWapKn+pxEaW1GweJLj2gxzNKltZXdifmaCFTkU6WjqRQlqrSP/W4iNLaraNEl96vxzNKltZXdifmaCFTkU6WjqRMlqrSZ3pcRGnt5mGiS+/W4xklS+sruxNztJCpSCdLR1IkS1XpX3pcRGnt9nGiS+/V4xklS+sruxNztJCpSCdLR1IiS1Xp33pcRGntjgNFl96pxzNKltZXdifmaCFTkU6WjqRAlqrSf/S4iNLaPUeKLr1Pj2eULK2v7E7M0UKmIp0sHUl+lqrS5/S4iNLaXYeKLr1Lj2eULK2v7E7M0UKmIp0sHUl2lqrS5/W4iNLafceKLr1Hj2eULK2v7E7M0UKmIp0sHUlulqrSF/S4iNLanQeLLr1Dj2eULK2v7E7M0UKmIp0sHUlmlqrSF/W4iNLacBBgkgAAIABJREFUvUeLLr2txzNKltZXdifmaCFTkU6WjiQvS1XpmR4XUVq7+3DRpTf1eEbJ0vrK7sQcLWQq0snSkWRlqSo91+MiSmv3Hy+69JYezyhZWl/ZnZijhUxFOlk6kpwsVaUbPS6itHbggNGlN/R4RsnS+sruxBwtZCrSydKRZGTpMFX632ZV2uUiSmtHjhhdel2PZ5Qsra/sTszRQqYinSwdSXqWDlOl6Qv/8eW0x0WU1hodnkt0aY9nlCytr+xOzNFCpiKdLB1Jcpaq0kt6XERprdUBevro8AGaJ6BLezyjZGl9ZXdijhYyFelk6UhSs1SVXtTjIkprzQ7RB58dP0SztO/SHs8oWVpf2Z2Yo4VMRTpZOpLELFWll/W4iNJau4N0/i7t8YySpfWV3Yk5WshUpJOlI0nLUlW6o8dFlNYaHqbTd2mPZ5Qsra/sTszRQqYinSwdSVKWqtI9PS6itNbyQJ29S3s8o2RpfWV3Yo4WMhXpZOlIUrJUle7qcRGltaaH6uRd2uMZJUvrK7sTc7SQqUgnS0eSkKWqdF+PiyittT1Y5+7SHs8oWVpf2Z2Yo4VMRTpZOpLjWapKr+hxEaW1xofr1F3a4xklS+sruxNztJCpSCdLR3I4S1XpNT0uorTW+oCduUt7PKNkaX1ld2KOFjIV6WTpSI5mqSq9qsdFlNaaH7ITd2mPZ5Qsra/sTszRQqYinSwdycEsVaXX9biI0lr7g3beLu3xjJKl9ZXdiTlayFSkk6UjOZalH6YOs0iVdrmI0lrAYTttl/Z4RsnS+sruxBwtZCrSydKRHMpSVXpLj4sorUUcuLN2aY9nlCytr+xOzNFCpiKdLB3JkSxVpTf1uIjSWsihO1CXHhmlxzNKltZXdifmaCFTkU6WjuRAlqrS23pcRGkt5uAdp0vfPjBIj2eULK2v7E7M0UKmIp0sHcn9WapK79DjIkprQYfvlF3a4xklS+sruxNztJCpSCdLR3J3lqrSe/S4iNJa1AE8Y5f2eEbJ0vrK7sQcLWQq0snSkdybpar0Lj0uorQWdghP2KU9nlGytL6yOzFHC5mKdLJ0JHdmqSq9T4+LKK3FHcTzdWmPZ5Qsra/sTszRQqYinSwdyX1Zqkrv1OMiSmvZh5Eu/VuPZ5Qsra/sTszRQqYinSwdyV1Zqkrv1eMiSmv5x5Eu/UuPZ5Qsra/sTszRQqYinSwdyT1Zqkrv1uMiSmsFDiRd+kyPZ5Qsra/sTszRQqYinSwdyR1Zqkrv1+MiSmsljiRd+qcezyhZWl/ZnZijhUxFOlk6kttZukCVPihVpV0uorRW5FDSpU/1eEbJ0vrK7sQcLWQq0snSkdzM0hWqtNwy3uMiSmtljqUuDuj7VOzSHs8oWVpf2Z2Yo4VMRTpZOpJbWapKDzm6iH4afQBzh6NneaGDqY9D+i71ulSWBtNC6WTp1hxT0bfZs1SVHiNLZxSUpb0c1Peo1qWyNJgWSidLt+aYir5NnqWq9CBZOqOoLO3msL5DrS6VpcG0UDpZujXHVPRt7ixVpUfJ0hmFZWk/B/ZtlbpUlgbTQulk6dYcU9G3qbN0gSo9FV68ZemM4rJUl8rSYFoonSzdmmMq+jZzlq5QpSUL4glZOqPALF2+S2VpMC2UTpZuzTEVfZs4S5eoUlnKbZFZunqXytJgWiidLN2aYyr6Nm+WJlfpv2oseFdkVaks5bbQLF28S2VpMC2UTpZuzTEVfZs2S5Or9K4fui4or0plKbfFZumjTw4O/48JulSWBtNC6WTp1hxT0bdZs3SVKpWl3DZslk7QpbI0mBZKJ0u35piKvk2apctUqSzltnGztH2XJm/szqVDlgbTQulk6dYcU9G3ObN0nSqVpdw2cJa279LCFw9ZGkwLpZOlW3NMRd+mzNKFqlSWctvIWTp6l8rSYFoonSzdmmMq+jZjlq5UpbKU24bO0sG7VJYG00LpZOnWHFPRtwmzdKkqlaXcNnaWjt2lsjSYFkonS7fmmIq+zZela1WpLOW2wbN06C6VpcG0UDpZujXHVPRtuixdrEplKbeNnqUjd6ksDaaF0snSrTmmom+zZelqVSpLuW34LB24S2VpMC2UTpZuzTEVfZssS5erUlnKbeNn6bhdKkuDaaF0snRrjqno21xZul6VylJumyBLh+1SWRpMC6WTpVtzTEXfpsrSBatUlnLbDFk6apfK0mBaKJ0s3ZpjKvo2U5auWKWylNumyNJBu1SWBtNC6WTp1hxT0beJsnTJKpWl3DZHlo7ZpbI0mBZKJ0u35piKvs2TpWtWqSzltkmydMgulaXBtFA6Wbo1x1T0bZosXbRKZSm3zZKlI3apLA2mhdLJ0q05pqJvs2TpqlUqS7ltmiwdsEtlaTAtlE6Wbs0xFf/f3t0uyVFcgdoVYFlggcHm21gQceKNN879X+GxkDGIHk13Zu2s3HvXWr+NMrOyuvLxzHR3bk2y9LJVKku5r0+W1utSWbqZFponS2/12IrcemTpdatUlnJfoywt16WydDMtNE+W3uqxFbm1yNILV6ks5b5OWVqtS2XpZlponiy91WMrcuuQpWWq9JdXkSt/J3iGsrSjVllarEtl6WZaaJ4svdVjK3JrkKV1qvR15ML/K3iKsrSjXllaq0tl6WZaaJ4svdVjK3Krn6XXrlJZyn3NsvTFR2+CZ3jPgYeMLN1MC82Tpbd6bEVu5bN0+q81e1SpLOW+bln64mWdLpWlm2mhebL0Vo+tyK18ls5qUqWylPvaZWmhLv0octlBZOl6sYvo0UK2Yp4svYAuVSpLua9flhbq0oRk6Xqxi+jRQrZiniztr02VylLua5iluvQAWbpe7CJ6tJCtmCdL2+tTpbKU+zpmqS6dJ0vXi11EjxayFfNkaXeNqlSWcl/LLNWl02TperGL6NFCtmKeLG2uU5XKUu7rmaW6dJYsXS92ET1ayFbMk6W9tapSWcp9TbNUl06SpevFLqJHC9mKebK0tV5VKku5r2uW6tI5snS92EX0aCFbMU+WdtasSmUp97XNUl06RZauF7uIHi1kK+bJ0sa6Vaks5b6+WapLZ8jS9WIX0aOFbMU8WdpXuyqVpdzXOEt16QRZul7sInq0kK2YJ0vb6lelspT7OmepLh0nS9eLXUSPFrIV82RpVw2rVJZyX+ss1aXDZOl6sYvo0UK2Yp4sbapjlcpS7uudpbp0lCxdL3YRPVrIVsyTpT21rFJZyn3Ns1SXDpKl68UuokcL2Yp5srSlnlUqS7mve5bq0jGydL3YRfRoIVsxT5Z21LRKZSn3tc9SXTpElq4Xu4geLWQr5snShrpWqSzlvv5ZqktHyNL1YhfRo4VsxTxZ2k+dKv1o8H8fPG9Z2tEFslSXDpCl68UuokcL2Yp5srSdQlX64+B/EDxxWdrRFbJUlz5Olq4Xu4geLWQr5snSbipV6S+D/0XwzGVpR5fIUl36MFm6XuwierSQrZgnS5spVaWylHDXyFJd+ihZul7sInq0kK2YJ0t7qVWlspRwtbL01ejfV/+PLn2MLF0vdhE9WshWzJOlrRSrUllKuFpZ+uWPunQtWbpe7CJ6tJCtmCdLO6lWpbKUcMWy9BddupYsXS92ET1ayFbMk6WNlKtSWUq4almqS9eSpevFLqJHC9mKebK0j3pVKksJVy5LdelSsnS92EX0aCFbMU+WtlGwSmUp4eplqS5dSZauF7uIHi1kK+bJ0i4qVqksJVzBLNWlC8nS9WIX0aOFbMU8WdpEySqVpYSrmKW6dB1Zul7sInq0kK2YJ0t7eHXy2RRTpbKUcCWzVJcuI0vXi11EjxayFfNkaQunH00xVSpLCVczS3XpKrJ0vdhF9GghWzFPlnZQtUplKeGKZqkuXUSWrhe7iB4tZCvmydIGylapLCVc1Syt1KVfzM50A1m6XuwierSQrZgnS+urW6XFsvTzr8jv07031XyWVurS6UfA+WTperGL6NFCtmKeLC2vzpF0U6XFspSOgm+qA1mqS1eQpevFLqJHC9mKebK0ujoH0m2VylK2C76pjmSpLl1Alq4Xu4geLWQr5snS4uocR09UqSxlu+Cb6lCW6tJ4snS92EX0aCFbMU+W1lbnMHqqSmUp2wXfVMeyVJeGk6XrxS6iRwvZinmytLQ6R9GTVSpL2S74pjqYpbo0mixdL3YRPVrIVsyTpZXVOYierlJZynbBN9XRLNWlwWTperGL6NFCtmKeLC2szjH0gSqVpWwXfFMdzlJdGkuWrhe7iB4tZCvmydK66hxCH6pSWcp2wTfV8SzVpaFk6Xqxi+jRQrZiniwtq84R9MEqlaVsF3xTBWSpLo0kS9eLXUSPFrIV82RpVXUOoA9XqSxlu+CbKiJLdWkgWbpe7CJ6tJCtmCdLi6pz/DxTpbKU7YJvqpAs1aVxZOl6sYvo0UK2Yp4sranO4fNclcpStgu+qWKyVJeGkaXrxS6iRwvZinmytKQ6R8+zVSpL2S74pgrKUl0aRZauF7uIHi1kK+bJ0orqHDzPV6ksZbvgmyoqS3VpEFm6XuwierSQrZgnSwuqc+zcqVJZynbBN1VYlurSGLJ0vdhF9GghWzFPltZT59C5V6WylO2Cb6q4LNWlIWTperGL6NFCtmKeLC2nzpFzt0plKdsF31SBWapLI8jS9WIX0aOFbMU8WVrN6QfO17MzvV+lspTtgm+qyCzVpQFk6Xqxi+jRQrZiniwtpk6VvrhfpbKU7YJvqtAs1aXHydL1YhfRo4VsxTxZWkuhKv36gX998J8MXpssJXmWHujSz4IXdlfSLpWl68UuokcL2Yp5srSUZlUqS9ku+KYKztIDXfo6eGV35exSWbpe7CJ6tJCtmCdLK+lWpbKU7YJvqugs1aUHydL1YhfRo4VsxTxZWsn9MyzW6iqVpWwXfFOFZ2mlLv1sdqYLydL1YhfRo4VsxTxZWsnJWbq8SmUp2wXfVPFZWqhLM76iZOl6sYvo0UK2Yp4sreTcLF1fpbKU7YJvqgVZWqdLM76iZOl6sYvo0UK2Yp4sreTULD2hSmUp2wXfVCuytEyXZnxFydL1YhfRo4VsxTxZWsmZWXpGlcpStgu+qZZkaZUuzfiKkqXrxS6iRwvZinmytJITs/SUKpWlbBd8U63J0iJdmvEVJUvXi11EjxayFfNkaSXnZek5VSpL2S74plqUpTW6NOMrSpauF7uIHi1kK+bJ0kpOy9KTqlSWsl3wTbUqS0t0acZXlCxdL3YRPVrIVsyTpZWclaVnVaksZbvgm2pZllbo0oyvKFm6XuwierSQrZgnSys5KUtPq1JZynbBN9W6LC3QpRlfUbJ0vdhF9GghWzFPllZyTpaeV6WydK+XL3fPIIHgm2phlubv0oyvKFm6XuwierSQrZgnSys5JUtPrFJZutXLN290aaUsTd+lGV9RsnS92EX0aCFbMU+WVnJGlp5ZpbJ0p5dvfvlFl5bK0uxdmvEVJUvXi11EjxayFfNkaSUnZOmpVSpLN3pbpbq0WJYm79KMryhZul7sInq0kK2YJ0srWZ+l51apLN3nXZXq0mJZmrtLM76iZOl6sYvo0UK2Yp4srWR5lp5cpbJ0m9+qVJcG31SrszR1l2Z8RcnS9WIX0aOFbMU8WVrJ6iw9u0pl6S6/V+nluzT4plqepZm7NOMrSpauF7uIHi1kK+bJ0koWZ+npVSpLN/ljlV69S4NvqvVZmrhLM76iZOl6sYvo0UK2Yp4srWRtlp5fpbJ0j/er9OJdGnxTnZClebs04ytKlq4Xu4geLWQr5snSSpZm6YYqlaVb/LlKr92lwTfVGVmatkszvqJk6Xqxi+jRQrZiniytZGWW7qhSWbrDbZVeukuDb6pTsjRrl2Z8RcnS9WIX0aOFbMU8WVrJwizdUqWydIOnqvTKXRp8U52TpUm7NOMrSpauF7uIHi1kK+bJ0krWZemeKpWl53u6Si/cpcE31UlZmrNLM76iZOl6sYvo0UK2Yp4srWRZlm6qUll6ug9V6XW7NPimOitLU3ZpxleULF0vdhE9WshWzJOllazK0l1VujlLv/+yqM+m9+vDVXqoS1/uviIHRN9UY1fuwPAJu1SWbqaF5snSWz22IjdZ+rRtVbo5S6ua75HnqvRQlx69Efo4L0sTdqks3UwLzZOlt3psRW6y9En7qlSWzlhVpbo0wolZ+suP09u1qEtl6WZaaJ4svdVjK3KTpU/ZWKWydMK6KtWlAc7M0gOv3TVdKks300LzZOmtHluRmyx9ws4qlaXjVlapLj3u1CzN1qWydDMtNE+W3uqxFbnJ0ltbq1SWDltbpbr0sHOzNFmXytLNtNA8WXqrx1bkJktv7K1SWTpqdZXq0qNOztJcXSpLN9NC82TprR5bkZss/bPNVSpLB62vUl160NlZmqpLZelmWmieLL3VYytyk6V/srtKZemY+Sr96OEq1aXHnJ6lmbpUlm6mhebJ0ls9tiI3Wfq+7VUqS4ccqNIfR8bRpQecn6WJulSWbqaF5snSWz22IjdZ+p79VSpLR5xVpbr0iA1ZmqdLZelmWmieLL3VYytyk6V/lKBKZemA86pUlx6wI0vTdKks3UwLzZOlt3psRW6y9A8yVKksfdyZVapL523J0ixdKks300LzZOmtHluRmyz9XYoqlaUPO7dKdem0PVmapEtl6WZaaJ4svdVjK3KTpf+To0pl6aPOrtJDXTo5Yg+bsjRHl8rSzbTQPFl6q8dW5CZLf5OkSmXpg86v0iNdOj9mA7uyNEWXytLNtNA8WXqrx1bkJkv/K0uVytLH7KhSXTpnW5Zm6FJZupkWmidLb/XYitxk6Tvz59cXMRP4n8Hhg0evYk+V6tIp+7I0QZfK0s200DxZeqvHVuQmS381f3qFf83U4PDBoxexq0p16YyNWbq/S2XpZlponiy91WMrcpOlbx2oUlm6wb4q1aUTdmbp9i6VpZtpoXmy9FaPrchNlv5yrEpl6fl2VqkuHbc1S3d3qSzdTAvNk6W3emxFbrL0YJXK0tPtrVJdOmxvlo6+ov4goktl6WZaaJ4svdVjK3KTpQerdPchGjx6AburVJeOKpulEV0qSzfTQvNk6a0eW5GbLD1YpbsP0eDR89tfpbp0UN0sDehSWbqZFponS2/12IrcLp+lR6t09yEaPHp6GapUl44pnKXHu1SWbqaF5snSWz22IrerZ+nhKt19iAaPnl2OKtWlQypn6eEulaWbaaF5svRWj63I7eJZ+u3uCdwaHD549OSyVKkuHVE6S492qSzdTAvNk6W3emxFbtfO0vnKCZrAEwaHDx49tzxVqksH1M7Sg10qSzfTQvNk6a0eW5HbpbM0okp3H6LBo6eWqUp16eOKZ+mxLpWlm2mhebL0Vo+tyO3KWRpSpbsP0eDRM8tVpbr0YdWz9MXXB0aXpZtpoXmy9FaPrcjtwlkaU6W7D9Hg0RPLVqW69FHls/RIl8rSzbTQPFl6q8dW5HbdLA2q0t2HaPDoeeWrUl36oPpZeqBLZelmWmieLL3VYytyu2yWRlXp7kM0ePS0MlapLn1Mgyyd71JZupkWmidLb/XYityumqVhVbr7EA0ePaucVapLH9IhS6e7VJZupoXmydJbPbYit4tmaVyV7j5Eg0dPKmuV6tJHtMjS2S6VpZtpoXmy9FaPrcjtmlkaWKW7D9Hg0XPKW6X/6dLEc0uiR5ZOdqks3UwLzZOlt3psRW6XzNLIKt19iAaPnlLmKs0+uwyaZOlcl8rSzbTQPFl6q8dW5HbFLA2t0t2HaPDoGWXvvuzz265Llk51qSzdTAvNk6W3emxFbhfM0tgq3X2IBo+eUP7qyz/Dvdpk6UyXytLNtNA8WXqrx1bkdr0sDa7S3Ydo8Oj5VGi+CnPcqE+WTnSpLN1MC82Tpbd6bEVul8vS6CrdfYgGj55OjeKrMctdGmXpeJfK0s200DxZeqvHVuR2tSwNr9Ldh2jw6NlU6b0q89yiU5YOd6ks3UwLzZOlt3psRW4Xy9L4Kt19iAaPnkyd2qsz0/O1ytLRLpWlm2mhebL0Vo+tyO1aWbqgSncfosGj51Kp9SrN9WS9snSwS2XpZlponiy91WMrcrtUlq6o0t2HaPDoqdQqvVqzPVOzLB3rUlm6mRaaJ0tv9diK3K6UpUuqdPchGjx6JtU6r9p8T9MtS4e6VJZupoXmydJbPbYitwtl6Zoq3X2IBo+eSL3Kqzfjc7TL0pEulaWbaaF5svRWj63I7TpZuqhKdx+iwaPnUbHxKs75BP2ydKBLZelmWmieLL3VYytyu0yWrqrS3Ydo8Ohp1Cy8mrNerWGWPt6lsnQzLTRPlt7qsRW5XSVLl1Xp7kM0ePQsqvZd1Xkv1TFLH+5SWbqZFponS2/12IrcLpKl66p09yEaPHoSdeuu7szXaZmlj3apLN1MC82Tpbd6bEVu18jShVW6+xANHj2Hym1Xee6L9MzSB7tUlm6mhebJ0ls9tiK3S2TpyirdfYgGj55C7bKrPfsVmmbpY10qSzfTQvNk6a0eW5HbFbJ0aZXuPkSDR8+getdVn3+4rln6UJfK0s200DxZeqvHVuR2gSxdW6W7D9Hg0ROoX3X1VxCrbZY+0qWydDMtNE+W3uqxFbn1z9LFVbr7EA0efb8OTddhDYH6ZukDXSpLN9NC82TprR5bkVv7LF1dpbsP0eDRt+tRdD1WEaVxlt7vUlm6mRaaJ0tv9diK3Lpn6fIq3X2IBo++W5ee67KOEJ2z9G6XytLNtNA8WXqrx1bk1jxL11fp7kM0ePTN+tRcn5Uc1zpL73WpLN1MC82Tpbd6bEVuvbP0hCrdfYgGj75Xp5brtJaDemfpnS6VpZtpoXmy9FaPrcitdZaeUaW7D9Hg0bd606rkdOlvmmfp810qSzfTQvNk6a0eW5Fb5yw9pUp3H6LBo+/05uXsHuTsOF36X92z9NkulaWbaaF5svRWj63IrXGWnlOluw/R4NE36laluvQ37bP0uS6VpZtpoXmy9FaPrcitb5aeVKW7D9Hg0ffpV6W69L/6Z+kzXSpLN9NC82TprR5bkVvbLJ0sgo8+iZrASYdo8OjbzFfpY19NvocufesCWfrhm1CWbqaF5snSWz22IreuWTpbpT++CprAWYdo8Oi79KxSXfqrK2TpB29DWbqZFponS2/12IrcmmbpdJX+Ikt36FqluvStS2Tph25EWbqZFponS2/12IrcembpfJXK0h36Vqku/eUqWfqBW1GWbqaF5snSWz22IreWWXqgSmXpBp2rVJdWy9L5/XryZpSlm2mhebL0Vo+tyK1jlh6pUll6vt5VqkuLZemB/XrqdpSlm2mhebL0Vo+tyK1hlh6qUll6uu5VqkuLZWlsl8rSzbTQPFl6q8dW5NYvS49VqSw9W/8qvXyXVsvS0C6VpZtpoXmy9FaPrcitXZYerFJZerIrVOnVu7RclkZ2qSzdTAvNk6W3emxFbt2y9GiVytJzXaNKL96l9bI0sEtl6WZaaJ4svdVjK3JrlqWHq1SWnuoqVXrtLi2YpXFdKks300LzZOmtHluRW68sPV6lsvRM16nSS3dpxSwN61JZupkWmidLb/XYitxaZWlAlcrSE12pSq/cpSWzNKpLZelmWmieLL3VYyty65SlEVUqS89zrSq9cJfWzNKgLpWlm2mhebL0Vo+tyK1RloZUqSw9zdWq9LpdWjRLf/l68L/83R9uUFm6mRaaJ0tv9diK3PpkaUyVytKzXK9KL9ulVbM0pEtl6WZaaJ4svdVjK3Jrk6VBVVouS19V9cnohf6fslV6qEt379cBg/8HJE+WRnSpLN1MC82Tpbd6bEVuXbI0qkrLZen1FK7SI116HYmyNKBLZelmWmieLL3VYytya5Klb6KqVJZmV7pKdekDMmXp8S6VpZtpoXmy9FaPrcitR5ZO/p3iU3+wJ0tzK16luvS+VFl6uEtl6WZaaJ4svdVjK3JrkaWBVSpLcytfpbr0rlxZeqBLv337n8vSzbTQPFl6q8dW5NYhSyOrVJam1qBKdek9ybJ0vkt/fcLI0s200DxZeqvHVuTWIEtDq1SWZtaiSnXpHdmy9FiXytLNtNA8WXqrx1bkVj9LY6tUlibWpEp16fPSZemhLpWlm2mhebL0Vo+tyK18lr6OrVJZmlebKtWlz8qXpUe6VJZupoXmydJbPbYit/JZOufDX5ojS7NqVKW69DkJs/RAlw4/UE4gS9eLXUSPFrIV82Rpe898laMsTapVlerSZ2TM0gPvx09Ilq4Xu4geLWQr5snS7p77gnFZmlOzKm3WOaFSZmmr/ZKl68UuokcL2Yp5srS556pUlubUrkp7dU6onFnaab9k6Xqxi+jRQrZinizt7dkqlaUpNazSVp0TKmmWNtovWbpe7CJ6tJCtmCdLW3u+SmVpRi2rtFPnhMqapX32S5auF7uIHi1kK+bJ0s7uVKksTahplTbqnFBps7TNfsnS9WIX0aOFbMU8WdrYvSqVpfm0rdI+nRMqb5Z22S9Zul7sInq0kK2YJ0v7ululsjSdxlXapnNCJc7SJvt1qSz9///vFrGL+D97FvH/xa7CVswL3orcrpWl96tUlmbTukq7dE6ozFnaY78ulaVALZfK0geqVJYmc3aVvnngHgnVonNCpc7SFvslS4G0rpSlj1SpLM3l9Cp9+dBdEqlD54TKnaUd9kuWAmldKEsf6w1Zmsn5VfrofRKoQeeESp6lDfZLlgJpXSdLH6wNWZrIjirVpbtlz9L6+yVLgbQuk6WPtoYszWNPlerSzdJnafn9kqVAWlfJ0odLQ5amsatKdele+bO0+n7JUiCti2Tp450hS7PYV6W6dKsCWVp8v2QpkNY1snSgMl6P/tuydI2dVapLd6qQpbX3S5YCaV0iS0ca48vRf1yWLrG3SnXpRiWytPR+yVIgrStk6VBhyNIUdlepLt2nRpZW3i9ZCqT8nklSAAAarElEQVR1gSwd6wtZmsH+KtWl2xTJ0sL7JUuBtPpn6WBdyNIEMlSpLt2lSpbW3S9ZCqTVPktH20KW7pejSnXpJmWytOx+yVIgre5ZOlwWsnS7LFX6n7vnp5OnUrVzQtXJ0qr7JUuBtJpn6fjPu2Tpbnmq9MWLl29OnkzRzglVKEuL7pcsBdLqnaUTv4WVpZtlqlJdukOlLK25X7IUSKt1ls78baAs3StXlerSDUplacn9kqVAWp2zdOodK7J0q2xVqkvPVytLK+6XLAXSapylc++jlqU75atSXXq6YllacL9kKZBW3yyd/HQfWbpRxirVpWerlqX19kuWAmm1zdLZz5yUpftEX8p7HqtSXXqycllabr9kKZBW1yyd/iR0WbrN6+Arec+jVapLz1UvS6vtlywF0mqapfPfzyNLd8lbpbr0VAWztNh+yVIgrZ5ZeuBbI2XpJpmrVJeeqWKW1tovWQqk1TJLj3yXuSzdI3eV6tITlczSUvslS4G0OmbpkSqVpXtkr1Jdep6aWVppv2QpkFbDLD1UpbJ0i/xVqktPUzRLC+2XLAXS6pelx6pUlu5QoUp16VmqZmmd/ZKlQFrtsvRgle7P0i+L+mJ+z2pUaa0u/WL3/TDv++CrOHjlDoxUpUtlKZBWtyw9WqX7s7So2dR7UadKS3Xp6VPNa/DKHRmqSJfKUiCtZll6uEpl6ZxLVKkuLWnwwh0aq0aXylIgrV5ZerxKZemUi1SpLq1o8LodG6xEl8pSIK1WWRpQpbJ0xmWqVJcWNHjZDo5WoUtlKZBWpyyNqFJZOuFCVapL6xm8akeHK9ClshRIq1GWhlSpLB13qSrVpeUMXrTD4+XvUlkKpNUnS2OqVJYOu1iV6tJqBq/Z8QHTd6ksBdJqk6VBVSpLR12uSnVpMYOXLGDE7F0qS4G0umRpVJXK0kEXrFJdWsvgFYsYMnmXylIgrSZZGlalsnTMJatUl5YyeMFCxszdpbIUSKtHlsZVqSwdctEq1aWVDF6vmEFTd6ksBdJqkaWBVSpLR1y2SnVpIYOXK2jUzF0qS4G0OmRpZJXK0gEXrlJdWsfg1YoaNnGXylIgrQZZGlqlsvRxhar0l8+mp/pBurSIwYsVNm7eLpWlQFr1szS2SmXpwypV6evpqT5Dl9YweK3iBk7bpbIUSKt8lgZXqSx91OWrVJcWMXipAkfO2qWyFEirfJZGV6EsfYwqfaFLaxi8UpFDJ+1SWQqkJUv/RJY+RJX+SpcWMHihQsfO2aWyFEhLlv6JLH2EKv2v02Nv+P7cN9UsBq9T7OApu1SWAmnJ0j+RpQ9Qpf9zeuzNr+eqXTp4mYJH/2J6v9aRpUBasvRPZOl9qvQPdGl2g1cpePT5H2+vI0uBtGTp0VPkelmqSt+jS5MbvEjBo8tSgAGy9Ogpcr0snf9o+o5VqkuzG7xGwaPLUoABsvToKXK5LJ2Pop5VqkuTG7xEwaPLUoABsvToKXK1LFWlt3RpZoNXKHh0WQowQJYePUUulqWq9Cm6NLHBCxQ8uiwFGCBLj54i18pSVfo0XZrX4PUJHl2WAgyQpUdPkUtlqSr9EF2a1uDlCR5dlgIMkKVHT5ErZakq/TBdmtXg1QkeXZYCDJClR0+RC2WpKn2OLk1q8OIEjy5LAQbI0qOnyHWyVJU+T5fmNHhtgkeXpQADZOnRU+QyWapK79GlKQ1emuDRZSnAAFl69BS5SpZepEpf/+PAf6xLMxq8MsGjy1KAAbL06ClykSy9SpX+8svXB/5zXZrQ4IUJHl2WAgyQpUdPkWtk6XWqVJd2M3hdgkeXpQADZOnRU+QSWXqlKtWlzQxeluDRZSnAAFl69BS5QpZeq0p1aS+DVyV4dFkKMECWHj1FLpClV6tSXdrK4EUJHl2WAgyQpUdPkf5Zer0q1aWdDF6T4NFlKcAAWXr0FGmfpVesUl3ayOAlCR5dlgIMkKVHT5HuWXrNKj32j72qs/ILdOngFQkeXZYCDJClR0+R5ll61SoN/+eyrr1/lw5ekODRZSnAAFl69BTpnaXXrVJd2sXg9QgeXZYCDJClR0+R1ll65SrVpU0MXo7g0WUpwABZevQU6Zyl165SXdrD4NUIHl2WAgyQpUdPkcZZevUq1aUtDF6M4NFlKcAAWXr0FOmbpapUl3YweC2CR5elAANk6dFTpG2WFoqchfGoS8sbvBTBo8tSgAGy9Ogp0jVLCyXO0nTUpdUNXong0WUpwABZevQUaZqlhQJncTjq0uIGL0Tw6LIUYIAsPXqK9MzSQnmzPBt1aW2D1yF4dFkKMECWHj1FWmZpobg5IRp1aWmDlyF4dFkKMECWHj1FOmZpobQ5JRl1aWWDVyF4dFkKMECWHj1FGmZpobA5KRh1aWGDFyF4dFkKMECWHj1F+mVpoaw5LRd1aV2D1yB4dFkKMECWHj1F2mVpoag5MRZ1aVmDlyB4dFkKMECWHj1FumVpoaQ5NRV1aVWDVyB4dFkKMECWHj1FmmVpoaA5ORR1aVGDFyB4dFkKMECWHj1FemVpoZw5PRN1aU2D6w8eXZYCDJClR0+RVllaKGY2RKIuLWlw+cGjy1KAAbL06CnSKUsLpcyWRNSlFQ2uPnh0WQowQJYePUUaZWmhkNkUiLq0oMHFB48uSwEGyNKjp0ifLC2UMdvyUJfWM7j24NFlKcAAWXr0FGmTpYUiZmMc6tJyBpcePLosBRggS4+eIl2ytFDCbE3Di3Tpq7Onus7gyoNHl6UAA2Tp0VOkSZaq0iLDnzXZ06e6zODCg0eXpQADZOnRU6RHlqrSQhM4Z7JtunRw3cGjy1KAAbL06CnSIktVabEpnDHZLl06uOzg0WUpwABZevQU6ZClF6nSsL+X1KWVDK46eHRZCjBAlh49RRpkaaEq/Xp6qqGT1aWFDC46eHRZCjBAlh49RepnqSodp0vrGFxz8OiyFGCALD16ipTPUlU6Q5eWMbjk4NFlKcAAWXr0FKmepap0ji6tYnDFwaPLUoABsvToKVI8S1XpLF1axOCCg0eXpQADZOnRU6R2lqrSeaW69GWdqUYbXG/w6LIUYIAsPXqKlM5SVXpEpS59c90uHVxu8OiyFGCALD16ilTOUlV6jC6tYHC1waPLUoABsvToKVI4S1XpUbq0gMHFBo8uSwEGyNKjp0jdLFWlx+nS/AbXGjy6LAUYIEuPniKfvCpqPlJU6e8u0qUvd9+tBwwuNfiiy1KAAbK0wCmSjCr9o4t06XUEX/OMDxRZCqQlSwucIrmo0vfp0l6CL3nGB4osBdKSpQVOkVRU6Z/p0laCr3jGB4osBdKSpQVOkUxU6S1d2knwBc/4QJGlQFqytMApkogqfYoubST4emd8oMhSIC1ZWuAUyUOVPk2X9hF8uTM+UGQpkJYsLXCKpKFKP0SXthF8tTM+UGQpkJYsLXCKZKFKP0yXdhF8sTM+UGQpkJYsLXCKJKFKn6NLmwi+1hkfKLIUSEuWFjhFclClz9OlPQRf6owPFFkKpCVLC5wiKajSe3RpC8FXOuMDRZYCacnSAqdIBqr0Pl3aQfCFzvhAkaVAWrK0wCmSgCp9hC5tIPg6Z3ygyFIgLVla4BTZT5U+RpfWF3yZMz5QZCmQliwtcIpsp0ofpUvLC77KGR8oshRIS5YWOEV2U6WP++zA1HVpBsEXOeMDRZYCacnSAqfIZqp0wKHU+0elyXYVfI0zPlBkKZCWLC1wiuylSoccSr2vK022qeBLnPGBIkuBtGRpgVNkK1U6SJfWFnyFMz5QZCmQliwtcIrspEqH6dLSgi9wxgeKLAXSkqUFTpGNVOkEXVpZ8PXN+ECRpUBasrTAKbKPKp2iSwsLvrwZHyiyFEhLlhY4Rbb5SJXO0aV1BV/djA8UWQqkJUsLnCK7fPRj8MW9p0uV6tLCgi9uxgeKLAXSkqUFTpFNVOkBurSq4Gub8YEiS4G0ZGmBU2QPVXqILi0q+NJmfKDIUiAtWVrgFNlClR6kS2sKvrIZHyiyFEhLlhY4RXZQpYfp0pKCL2zGB4osBdKSpQVOkQ1UaQBdWlHwdc34QJGlQFqytMApcj5VGkKXFhR8WTM+UGQpkJYsLXCKnE6VBtGl9QRf1YwPFFkKpCVLC5wiZ1OlYXRpOcEXNeMDRZYCacnSAqfIyVRpIF1aTfA1zfhAkaVAWrK0wClyLlUaSpcWE3xJMz5QZCmQliwtcIqcSpUG06W1BF/RjA8UWQqkJUsLnCJnUqXhdGkpwRc04wNFlgJpydICp8iJVOkCurSS4OuZ8YEiS4G0ZGmBU+Q8qnQJXVpI8OXM+ECRpUBasrTAKXIaVbqILq0j+GpmfKDIUiAtWVrgFDmLKl1Gl5YRfDEzPlBkKZCWLC1wipxElS6kS6sIvpYZHyiyFEhLlhY4Rc6hSpfSpUUEX8qMDxRZCqQlSwucIqdQpYvp0hqCr2TGB4osBdKSpQVOkTOo0uV0aQnBFzLjA0WWAmnJ0gKnyAlOr9Jvj0z2p5MnG0SXVhB8HTM+UGQpkJYsLXCKrHd6lf74UaHJhtGlBQRfxowPFFkKpCVL/+T7L8uav4iq9CRX6dKP3t2R31cUfBVlKcAAWdrG6+lrqEpPc5UufX3yVPOSpQADZGkXqrQEXXoxshRgQPks/WL3sZOEKi2iVpd+Mj1VXfqOLAUY8LfdT8ijXu0+dnJQpWWU6tIDm6VLfyVLAQZ8uvsJeZQsfUuVFqJLr0SWAgyQpR2o0lJ06YW8OrDXq/xt97ED8CHls/ST3cdOAqq0GF16HRmz9NPdxw7Ah3y8+wl52O5jZz9VWo4uvYyMX0ogS4G0dj8gj9t97GynSgvSpVdxYJ/X2X3sAHzAz7ufj8dFfytLNaq0JF16EQe2eZ3d5w7AB/yw+/l43MWzVJUWpUsv4fsDu7zOv3YfPABP+2738/G4a3/NkyotS5dewbcHNnmd73YfPABPK/8lTxc/9VRpYbr0AjJ+bKkPLgXS+nz38/G4K39wqSotTZf299mBLV7HB5cCSf119/MxwO6DZx9VWpwube+TAzu8zl93HzwAT9v9eIzQNlruUaXl6dLm3hzY35V2HzwAT/rX7qdjhLNP5yxUaQO6tLecb8R/8eKH3UcPwFP+ufvpGOGiJ54qbUGXtpbzHU/e8wQk1eAdTy9efLL76NlCla7x/dmpp0s7e3Vgc1fynififONzcInzl91PxxA/7T57NlClyyarS5+hS8cc2NqlPt599NDHNy8+1qVE+ffuh2OMC/5xqSpdOFld+gxdOiLrn5b6nifCfPOf20mXEuWb3c/GGNc77lTp0snq0mfo0gFfHNjYtfxxKTHeVYQuJcjfNj8ag3y0+/A5mypdPFld+gxd+rgj+7qWTy4lxG8/29KlxPh464Mxzve7T59zqdLlk9Wlz9Clj/rpwK6u9u/dpw8d/P4bV11KhO82PhRDfbH7+DmVKj1hsqd36YErpUuz+seBTV3tn7uPHxr4498B6lICtPh4qLcu9RFRqvSUyRZKve3XasSlujTv7/D9Fp8A7787RZdyXJff4V/qt/iq9KTJ6tI1k71Ql2b+Hb7f4nPYn98zrUs5qs3v8K901KnS0yarS9dM9jqf55b1K57e8Vt8jrn9JB9dykFtfof/n1P5ze4T6CRfz1+iQuGSZLK6dM1kL9Oln8zv5wn+svsAoranPl9Sl3LIz6c/Bxe6yEmnSk+drC5dM9mLvFq/nd/NU/yw+wiisqc/9VyXckSTz9J/5+XuI+gUqvTkyerSNZO9Rpd+Nr+Zp/h89xFEYR/qB13KAX859RG42hXe9DRfpfpqcrKu25rJXqFLc7/h6S1vemLWh3+qpUuZ9sOJj78TfLb7EFpPlW6YrCu3ZrIX6NK8Xzz6m7/vPoSo6rnftepSZn162sPvHD/tPoVWU6VbJuvarZls+y499AUJ5/j4592nEDU9/xeAupQ5/z7pyXea7p8RpUo3TdbVWzPZ7l2a+9Oh3vlq9zFESffel6JLmdLo06H+q/ePS1Xptsm6fmsm27tLC/yw1I9LmXL/3dK6lAntflja/MelqnTjZF3BNZNt3aUVfljqx6VMeOQzfHQp4/r9sPTFi7MP5BOp0q2TdQ3XTLZxl5b4YakflzLusU+W1KWMavY2/Hde7T6KllGlmyfrKq6ZbN8unf+S4HN5Mz5jHv28c13KoG5vw3+n62eXqtLtk3Ud10y2a5f+OL99J/PZpYx4/Ft4dClDvlv4mNvok92H0RqqNMFkXck1k23apa/md+9kn+4+jKhk5LshdSkDfu71BU+/+3L3abSCKk0xWddyzWRbdumB1+zpvtt9HFHH2DeW61Ie99WiB9x+DT8kSpUmmayruWayDbu0yPud3vGuJx41VqW6lMf9a8nTLYV+73pSpWkm63qumWy/Lv1sfuM2+Hz3gUQRo1WqS3lYz/c7vfOP3SdSMFWaaLKu6JrJduvSb+e3bQu/xucR41WqS3lQ31/hv9hwGq+lSlNN9tsa0yx1Td/q1aWlfoX/ll/j84CZKtWlPKTxr/Dfevlm96kUSJXmmmyZiVabbKsurfMu/N/8bfehRH5zVapLecDPfw19oOXzxe5TKY4qzTbZQlOtNdlGXVrjW0ff98/dxxLZzVapLuW+jt86+r42J5wqNdnLTLbNq/b7+f3aSDnwrPkq1aXcc+TuKqLLn5eq0nyTLTbdSpNt0qXl/rD0HX9eynOOdYMu5Tn/+jjoMZbZJy3+vFSV5ptsuQlXmmyLLn3zcn6ztvqrLuWDjn4tpC7lw36+QpX2eNuTKs032YJTrjTZDl36en6rNvPppXzI8Z9m6VI+pP3bnX7zevfpdJgqzTfZkpOuNNn6XVq3Sl+8+Pvu44mkIn7Hqkv5gP5vd/pN9S4tVKWH/piuUkL/rlLqlZps9S498LJN4Jvd5xMpxfzlny7lSdep0hcvvtx9Qh1SqUqP/DFdzSqtlXqlJlu7S2tXqS7lKVHvR9GlPOFKVVr7gFOla0RVaa3UKzXZi75sk9Cl/Fncu6R1KTf+GXV3FVH3gFOla8RVaa3UKzXZS75s09ClvC/ys3t0KX9ytSqt+3VPqnSNyCqtlXqlJlu1SztUqS7lfbGfKKlLec+1foP/Ts33PanSNWKrtFbqnT/Zb+fnWrNLe1SpLuWPoj/nXJfyB1es0ppdqkrXiK5SXfq8QvdxhMqfDPU+n1/Kb+K/fUeX8pufr1mlFT9Xv9BpfvEq1aXPK3QnH/bms/nFpvO573viVyu+E1KX8s5lPkX/1idnH8YHFTrLL1+luvR5he7lg36q+o2jT/M9pLy15pvKdSlv/esvK+6uIj4qdcIVOslV6Qtd+rxCd/Mh3y+6u7b5+IfdZxb7ralSXcpb3yy6u6oo9Ib8Que4Kv2VLn1Oofv5gC/nV5nWV7tPLXZbVaW6lOv+WenvXlb5RX6hU1yV/pcufU6hO3rWT6/m15jYp36Rf23rqlSXXt6/rvtnpb/76B+7z66HFDrDVen/6NLnFLqn53zb7Rf4v/n4u91nFxutrFJdenHX+wz9p736affxdV+hE1yV/oEufU6hu3pCq3fg/9nf/MD0stZWqS69sn9/uvbeKuSjL3efYPcUOr9V6Xt06XMK3dfD/tH1R6XvfPzP3ScYe6yuUl16XV+tvrVK+eT73YfYswqd3qr0T3Tpcwrd2WO+7/WxUE/51Fvyr2h9lerSi/rhyh8L9aTMv8kvdHar0hu69DmF7u0BP/X5XqfnfP7v3QcZZzujSnXpFf3L7++f8DprmBY6uVXpE3Tpcwrd3Y96c40ofevv/sT0Ws6pUt/acDn/9qlQH5AzTAud26r0Sbr0OYXu74f89Lr3H5W+7+O/+4nphZxVpbr0WkTpcz7L9zemhU5tVfoBuvQ5he7w+368zk9Kf+NX+ZdxXpXq0gv54W/n3VY1vfz6ze6T7T2FzmxV+kG69DmF7vE7vu758fn3fPrN7oONM5xZpbr0In7+xsfnP+Cj14l+ZFroxC5VpT+d/ItWXfqcQnf5M3784kq/vX/fx3/3HpX2zq1SXXoF331+8k1V2CdfJCnTQud1qSo9NNkpuvQ5he7zD/jxi0/m19DCX5Rpb2dXqS7t7ru/+0SoMR+9/nr/G6AKndaq9A5d+pxCd/qtN1+/vnqTvvOXz78TEl2dX6W6tLF/f+PnpHM+ef2Ps4/n9xQ6q1XpXbr0OYXu9ff8+PXr/h+cP+Kvf//GT00b2lGlurSnH/75uR+THvPysy+//X7L26AKndSq9AG69DmF7vZfvfn+2y9fX/MdTvd9+vlX3/2gKBrZU6W6tJeff/juq795h1OgV2999uV5vpif6ycnTvNXR0Kv1GQP+ejslR6pptMne+D34F+cOM3Xvz4IrvvmphEff/rW519R3rZfuP5198o57m+/Pgh23UIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMO7/ASQgZ5/BhiTTAAAAAElFTkSuQmCC" width="100">
            </div>
        ');
        
        $mpdf->WriteHTML('<b>Número de Proveedor:</b> '.$provider);
        $mpdf->WriteHTML('<b>Nombre Comercial:</b> '.$getProvider['PROV_NOCO']);
        $mpdf->WriteHTML('<b>Encargado:</b> '.$getProvider['PROV_NOMB'].' '.$getProvider['PROV_APPA'].' '.$getProvider['PROV_APMA']);
        $mpdf->WriteHTML('<b>Correo Electrónico:</b> '.$getProvider['PROV_CORR']);
        $mpdf->WriteHTML('<b>Teléfono Principal:</b> +'.$getProvider['PROV_LAD1'].' '.$getProvider['PROV_TEL1']);
        if ($getProvider['PROV_LAD2'] != null) {
            $mpdf->WriteHTML('<b>Teléfono Secundario:</b> +'.$getProvider['PROV_LAD2'].' '.$getProvider['PROV_TEL2']);
        }
        if ($getProvider['PROV_XRFC'] != null) {
            $mpdf->WriteHTML('<b>R.F.C.:</b> '.$getProvider['PROV_XRFC']);
        }
        if ($getProvider['PROV_XTAX'] != null) {
            $mpdf->WriteHTML('<b>TAX ID:</b> '.$getProvider['PROV_XTAX']);
        }
        $mpdf->WriteHTML('<b>Regimen Fiscal:</b> '.$getProvider['PROV_CORF']);
        $mpdf->WriteHTML('<b>Tipo de Proveedor:</b> '.$getProvider['PROV_TIPO']);
        $mpdf->WriteHTML('<b>Sitio Web:</b> '.$getProvider['PROV_SIWE']);

        
        $mpdf->WriteHTML('<hr>');

        $mpdf->WriteHTML('<b>Métodos de Pago Aceptados:</b>');
        $arrMethod = json_decode($getProvider['PROV_MEPA'], true);
        $htmlList = '<ul style="margin: 0;">';
        foreach ($arrMethod as $keyMethod => $isHabilited) {
            if ($isHabilited) {
                $htmlList .= '<li>';
                $htmlList .= $keyMethod;
                $htmlList .= '</li>';
            }   
        }
        $htmlList .= '</ul>';
        $mpdf->WriteHTML($htmlList);

        $mpdf->WriteHTML('<hr>');

        $htmlReferences = '<b>Contactos del Proveedor</b><br>
            <table border="1" style="margin-top: 12px;">
                <thead>
                    <tr>
                        <th style="font-size: 8pt;">No</th>
                        <th style="font-size: 8pt;">Nombre Empleado</th>
                        <th style="font-size: 8pt;">Dirección</th>
                        <th style="font-size: 8pt;">Teléfono 1</th>
                        <th style="font-size: 8pt;">Teléfono 2</th>
                        <th style="font-size: 8pt;">Correo Electrónico 1</th>
                        <th style="font-size: 8pt;">Correo Electrónico 2</th>
                        <th style="font-size: 8pt;">Observaciones</th>
                    </tr>
                </thead>
                <tbody>';
        foreach ($getProviderContacto as $key => $providerContacto) {
            $htmlReferences .= '<tr>';
            // No
            $htmlReferences .='<td style="font-size: 8pt;">'.$providerContacto['PRCO_IDCP'].'</td>';
            // Nombre Empleado
            $htmlReferences .='<td style="font-size: 8pt;">'.$providerContacto['PRCO_NOMB'].'</td>';
            // Direccion
            $direction = $providerContacto['PRCO_CALL'].' '.$providerContacto['PRCO_NUEX'].' '.$providerContacto['PRCO_NUIN'].' '.$providerContacto['PRCO_COPO'].' '.
                $providerContacto['PRCO_MUNI'].' '.$providerContacto['PRCO_ENTI'].' '.$providerContacto['PRCO_PAIS'];
            $htmlReferences .='<td style="font-size: 8pt;">'.$direction.'</td>';
            // Teléfono 1
            $htmlReferences .='<td style="font-size: 8pt;">+'.$providerContacto['PRCO_LAD1'].' '.$providerContacto['PRCO_TEL1'].'</td>';
            // Teléfono 2
            if ($providerContacto['PRCO_LAD2'] != null) {
                $htmlReferences .='<td style="font-size: 8pt;">+'.$providerContacto['PRCO_LAD2'].' '.$providerContacto['PRCO_TEL2'].'</td>';
            } else {
                $htmlReferences .= '<td>-</td>';
            }
            // Correo 1
            $htmlReferences .='<td style="font-size: 8pt;">'.$providerContacto['PRCO_COR1'].'</td>';
            // Correo 2
            if ($providerContacto['PRCO_COR2'] != null) {
                $htmlReferences .='<td style="font-size: 8pt;">'.$providerContacto['PRCO_COR2'].'</td>';
            } else {
                $htmlReferences .= '<td>-</td>';
            }
            // Observaciones
            if ($providerContacto['PRCO_OBSE'] != null) {
                $htmlReferences .='<td style="font-size: 8pt;">'.$providerContacto['PRCO_OBSE'].'</td>';
            } else {
                $htmlReferences .= '<td>-</td>';
            }
            $htmlReferences .= '</tr>';
        }
        $htmlReferences .= '</tbody></table>';
        $mpdf->WriteHTML($htmlReferences);
        $mpdf->WriteHTML('<hr>');
        $htmlReferences = '<b>Referencias del Proveedor</b><br>
            <table border="1" style="margin-top: 12px;">
                <thead>
                    <tr>
                        <th style="font-size: 8pt;">No</th>
                        <th style="font-size: 8pt;">Empresa</th>
                        <th style="font-size: 8pt;">Correo Electrónico</th>
                        <th style="font-size: 8pt;">Teléfono</th>
                        <th style="font-size: 8pt;">R.F.C.</th>
                        <th style="font-size: 8pt;">Dirección</th>
                    </tr>
                </thead>
                <tbody>';
        foreach ($getProviderReferences as $key => $providerReferences) {
            $htmlReferences .= '<tr>';
            $htmlReferences .='<td style="font-size: 8pt;">'.$providerReferences['PRRE_IDRE'].'</td>';
            $htmlReferences .='<td style="font-size: 8pt;">'.$providerReferences['PRRE_EMPR'].'</td>';
            $htmlReferences .='<td style="font-size: 8pt;">'.$providerReferences['PRRE_CORR'].'</td>';
            $htmlReferences .='<td style="font-size: 8pt;">+'.$providerReferences['PRRE_LADA'].' '.$providerReferences['PRRE_TELE'].'</td>';
            $htmlReferences .='<td style="font-size: 8pt;">'.$providerReferences['PRRE_XRFC'].'</td>';
            $htmlReferences .='<td style="font-size: 8pt;">'.$providerReferences['PRRE_DIRE'].'</td>';
            $htmlReferences .= '</tr>';
        }
        $htmlReferences .= '</tbody></table>';
        $mpdf->WriteHTML($htmlReferences);
        $mpdf->WriteHTML('<hr>');

        $htmlCondition = '<b>Condiciones del Proveedor</b><br>';
        foreach ($getProviderCondiciones as $key => $providerCondiciones) {
            $htmlCondition .= '<b>Tipo de Condición</b>: '.$providerCondiciones['PRCN_TIPO'];
            $htmlCondition .= '<p>'.$providerCondiciones['PRCN_INFO'].'</p>';
        }
        $mpdf->WriteHTML($htmlCondition);

        $contentFile = $mpdf->Output('', "S");
        $base64File = base64_encode($contentFile);

        try {
            $arrResponse = $this->resourcesController->saveDocument($base64File, 'GEAD','FICHA_PROVEEDOR_'.$provider.'.pdf','IN',$line);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_GENERATE_SHEET_REG008: Ocurrió un error al obtener la información.", $th->getMessage(), 500);
        }

        if ($arrResponse['error']) {
            return $this->responseController->makeResponse(true, "ERR_GENERATE_SHEET_REG009: Ocurrió un error al obtener la información.", [], 500);
        }

        try {
            $validateInsert = DB::table('S002V01TPRDO')->insert([
                'PRDO_NUPR' => $provider,
                'PRDO_CODU' => $arrResponse['response'],
                'PRDO_DESC' => 'Ficha',
                'PRDO_TIPO' => 'IN',
                'PRDO_NULI' => $line,
                'PRDO_USRE' => $user,
                'PRDO_FERE' => Carbon::now()->timezone('America/Mazatlan')->toDateTimeString(),
                'PRDO_FEAR' => DB::raw('CURRENT_TIMESTAMP'),
            ]);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(true, "ERR_GENERATE_SHEET_REG010: Ocurrió un error al ingresar la ficha.", $th->getMessage(), 500);
        }

        if (!$validateInsert) {
            return $this->responseController->makeResponse(true, "ERR_GENERATE_SHEET_REG011: No se pudo ingresar la ficha.", [], 500);
        }

        return $this->responseController->makeResponse(false, "ÉXITO: Ficha Exitosa", $arrResponse['response']);
    }

    public function getArtitlesByProvider($encProvider, $line) {
        DB::beginTransaction();

        // Se obtiene el número del proveedor
        try {
            $provider = $this->encController->decrypt($encProvider);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_ARTITLES_PROVIDER_GET000: Ocurrió un error al obtener el número del proveedor.", $th->getMessage(), 500);
        }
        
        // Verifica su existe el proveedor
        try {
            $validateExist = DB::table('S002V01TPROV')
                ->where('PROV_NUPR', '=', $provider)
                ->where('PROV_NULI', '=', $line)
                ->exists();
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_ARTITLES_PROVIDER_GET001: Ocurrió un error al identificar el proveedor.", $th->getMessage(), 500);
        }

        // Valida si existe el proveedor
        if (!$validateExist) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_ARTITLES_PROVIDER_GET002: El proveedor no existe", [], 500);
        }

        // Obtiene todos las descripciones de los artículos del proveedor
        try {
            $getDescriptionArtitles = DB::table('S002V01TDEAR')
                ->where('DEAR_NUPR', '=', $provider)
                ->where('DEAR_NULI', '=', $line)
                ->where('DEAR_ESTA', '=', 'Activo')
                ->get([
                    'DEAR_IDDE', # Identificador de la descripción
                    'DEAR_IMAG', # Imagenes de los artículos
                    'DEAR_DESC', # Descripción del artículo
                    'DEAR_CARA', # Características del artículo
                    'DEAR_COWE', # Compra web
                    'DEAR_IDUN', # Identificador del tipo de unidad
                    'DEAR_IDAR', # Identificador del artículo principal
                    'DEAR_USRE', # Usuario de registro
                    'DEAR_FERE', # Fecha de registro
                    'DEAR_USMO', # Usuario de modificación
                    'DEAR_FEMO', # Fecha de modificación
                ]);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_ARTITLES_PROVIDER_GET003: El proveedor no existe", $th->getMessage(), 500);
        }

        // El resultado pasa a ser un arreglo
        $arrDescriptionArtitles = json_decode(json_encode($getDescriptionArtitles), true);

        $arrDescription = array();
        foreach ($arrDescriptionArtitles as $keyDescription => $descriptionArtitle) {
            // Obtiene las imagenes y las pasa a un arreglo
            $descriptionArtitle['DEAR_IMAG'] = json_decode($descriptionArtitle['DEAR_IMAG']);
            $descriptionArtitle['DEAR_IMAG'] = json_decode($descriptionArtitle['DEAR_IMAG']);

            // Obtiene la información principal del artículo
            try {
                $objArtitle = DB::table('S002V01TARTI')
                    ->where('ARTI_IDAR', '=', $descriptionArtitle['DEAR_IDAR'])
                    ->where('ARTI_NULI', '=', $line)
                    ->where('ARTI_ESTA', '=', 'Activo')
                    ->join('S002V01TFAMI', 'ARTI_IDFA', '=', 'FAMI_IDFA')
                    ->join('S002V01TSUBF', 'ARTI_IDSU', '=', 'SUBF_IDSU')
                    ->first([
                        'ARTI_IDAR', # Identificador del artículo
                        'ARTI_IDFA', # Identificador de la familia del artículo
                        'FAMI_NOMB', # Nombre de la familia del artículo
                        'ARTI_IDSU', # Identificador de la subfamilia del artículo
                        'SUBF_NOMB', # Nombre de la subfamilia del artículo
                        'ARTI_CODI', # Código de barras del artículo
                        'ARTI_NOMB', # Nombre principal del artículo
                        // 'ARTI_USRE', # Usuario de registro
                        // 'ARTI_FERE', # Fecha de registro
                        // 'ARTI_USMO', # Usuario de modificación
                        // 'ARTI_FEMO', # Fecha de modificación
                    ]);
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_ARTITLES_PROVIDER_GET004: Ocurrió un error al obtener la información del artículo.", $th->getMessage(), 500);
            }
            // La información es guardada en el arreglo de respuesta
            foreach ($objArtitle as $keyArtitle => $artitle) {
                $descriptionArtitle[$keyArtitle] = $artitle;
            }

            // Se obtiene la unidad del artículo
            try {
                $objUnit = DB::table('S002V01TUNID')
                    ->where('UNID_IDUN', '=', $descriptionArtitle['DEAR_IDUN'])
                    ->where('UNID_NULI', '=', $line)
                    ->where('UNID_ESTA', '=', 'Activo')
                    ->first([
                        'UNID_IDUN', # Identificador de la unidad
                        'UNID_NOMB', # Nombre de la unidad
                        'UNID_ACRO', # Acrónimo de la unidad
                        'UNID_USRE', # Usuario de registro
                        'UNID_FERE', # Fecha de registro
                        'UNID_USMO', # Usuario de modificación
                        'UNID_FEMO', # Fecha de modificación
                    ]);
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_ARTITLES_PROVIDER_GET005: Ocurrió un error al obtener el tipo de unidad.", $th->getMessage(), 500);
            }

            // La información es guardada en el arreglo de respuesta
            $descriptionArtitle['DEAR_IDUN'] = $objUnit;
            
            // Se obtienen los detalles de la descripción
            try {
                $getDetailsDescription = DB::table('S002V01TINAR')
                    ->where('INAR_IDDE', '=', $descriptionArtitle['DEAR_IDDE'])
                    ->where('INAR_NULI', '=', $line)
                    ->where('INAR_ESTA', '=', 'Activo')
                    ->get([
                        'INAR_IDIN', # Identificador de los detalles
                        'INAR_CODI', # Código del artículo
                        'INAR_MODE', # Módelo del artículo
                        'INAR_MONE', # Tipo de moneda
                        'INAR_PREC', # Precio unitario del artículo
                        'INAR_MOMI', # Mónto mínimo
                        'INAR_CARA', # Características
                        'INAR_USRE', # Usuario de registro
                        'INAR_FERE', # Fecha de registro
                        'INAR_USMO', # Usuario de modificación
                        'INAR_FEMO', # Fecha de modificación
                    ]);
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_ARTITLES_PROVIDER_GET007: Ocurrió un error al obtener los detalles de la descripción del artículo.", $th->getMessage(), 500);
            }
            
            // La información es guardada en el arreglo de respuesta
            $descriptionArtitle['DETAILS'] = $getDetailsDescription;

            // Se almacen el arreglo de respuesta en el arreglo principal
            $arrDescription[] = $descriptionArtitle;
        }

        DB::commit(); # Para guardar los cambios en la base de datos
        return $this->responseController->makeResponse(false, "ÉXITO: Consulta exitosa", $arrDescription);
    }

    public function downloadArtitlesByProvider(Request $request) {
        $validator = Validator::make($request->all(), [
            'PROVIDER' => 'required|string',
            'USER' => 'required|string',
            'LINE_NUMBER' => 'required|string',
            'DOWNLOAD' => 'required|array',
        ]);

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

        try {
            $user = $this->encController->decrypt($responseData['USER']);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_DOWNLOAD_ARTITLE_DOW001: No se pudo obtener los datos del usuario", $th->getMessage(), 500);
        }
        
        // Verifica su existe el proveedor
        try {
            $validateExist = DB::table('S002V01TPROV')->where('PROV_NUPR', '=', $responseData['PROVIDER'])->where('PROV_NULI', '=', $responseData['LINE_NUMBER'])->exists();
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_DOWNLOAD_ARTITLE_DOW002: Ocurrió un error al identificar el proveedor.", $th->getMessage(), 500);
        }

        // Valida si existe el proveedor
        if (!$validateExist) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_DOWNLOAD_ARTITLE_DOW003: El proveedor no existe", [], 500);
        }

        $arrDescriptionId = $responseData['DOWNLOAD'];
        $arrDataArtitles = array();
        foreach ($arrDescriptionId as $keyId => $idDescription) {
            // Obtiene todos las descripciones de los artículos del proveedor
            try {
                $getDescriptionArtitles = DB::table('S002V01TDEAR')
                    ->where('DEAR_IDDE', '=', $idDescription)
                    ->where('DEAR_NUPR', '=', $responseData['PROVIDER'])
                    ->where('DEAR_NULI', '=', $responseData['LINE_NUMBER'])
                    ->where('DEAR_ESTA', '=', 'Activo')
                    ->first([
                        'DEAR_IDDE', # Identificador de la descripción
                        'DEAR_IMAG', # Imagenes de los artículos
                        'DEAR_DESC', # Descripción del artículo
                        'DEAR_CARA', # Características del artículo
                        'DEAR_COWE', # Compra web
                        'DEAR_IDUN', # Identificador del tipo de unidad
                        'DEAR_IDAR', # Identificador del artículo principal
                        'DEAR_USRE', # Usuario de registro
                        'DEAR_FERE', # Fecha de registro
                        'DEAR_USMO', # Usuario de modificación
                        'DEAR_FEMO', # Fecha de modificación
                    ]);
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_DOWNLOAD_ARTITLE_DOW004: El proveedor no existe", $th->getMessage(), 500);
            }
            $arrDescriptionArtitles = (array) $getDescriptionArtitles;


            // Obtiene la información principal del artículo
            try {
                $objArtitle = DB::table('S002V01TARTI')
                    ->where('ARTI_IDAR', '=', $arrDescriptionArtitles['DEAR_IDAR'])
                    ->where('ARTI_NULI', '=', $responseData['LINE_NUMBER'])
                    ->where('ARTI_ESTA', '=', 'Activo')
                    ->join('S002V01TFAMI', 'ARTI_IDFA', '=', 'FAMI_IDFA')
                    ->join('S002V01TSUBF', 'ARTI_IDSU', '=', 'SUBF_IDSU')
                    ->first([
                        'ARTI_IDAR', # Identificador del artículo
                        'ARTI_IDFA', # Identificador de la familia del artículo
                        'FAMI_NOMB', # Nombre de la familia del artículo
                        'ARTI_IDSU', # Identificador de la subfamilia del artículo
                        'SUBF_NOMB', # Nombre de la subfamilia del artículo
                        'ARTI_CODI', # Código de barras del artículo
                        'ARTI_NOMB', # Nombre principal del artículo
                    ]);
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_DOWNLOAD_ARTITLE_DOW005: Ocurrió un error al obtener la información del artículo.", $th->getMessage(), 500);
            }
            $objArtitle = (array) $objArtitle;
            // La información es guardada en el arreglo de respuesta
            foreach ($objArtitle as $keyArtitle => $artitle) {
                $arrDescriptionArtitles[$keyArtitle] = $artitle;
            }

            // Se obtiene la unidad del artículo
            try {
                $objUnit = DB::table('S002V01TUNID')
                    ->where('UNID_IDUN', '=', $arrDescriptionArtitles['DEAR_IDUN'])
                    ->where('UNID_NULI', '=', $responseData['LINE_NUMBER'])
                    ->where('UNID_ESTA', '=', 'Activo')
                    ->first([
                        'UNID_IDUN', # Identificador de la unidad
                        'UNID_NOMB', # Nombre de la unidad
                        'UNID_ACRO', # Acrónimo de la unidad
                    ]);
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_DOWNLOAD_ARTITLE_DOW006: Ocurrió un error al obtener el tipo de unidad.", $th->getMessage(), 500);
            }

            // La información es guardada en el arreglo de respuesta
            $arrDescriptionArtitles['DEAR_IDUN'] = $objUnit;

            // Se obtienen los detalles de la descripción
            try {
                $getDetailsDescription = DB::table('S002V01TINAR')
                    ->where('INAR_IDDE', '=', $idDescription)
                    ->where('INAR_NULI', '=', $responseData['LINE_NUMBER'])
                    ->where('INAR_ESTA', '=', 'Activo')
                    ->get([
                        'INAR_IDIN', # Identificador de los detalles
                        'INAR_CODI', # Código del artículo
                        'INAR_MODE', # Módelo del artículo
                        'INAR_MONE', # Tipo de moneda
                        'INAR_PREC', # Precio unitario del artículo
                        'INAR_MOMI', # Mónto mínimo
                        'INAR_CARA', # Características
                        'INAR_USRE', # Usuario de registro
                        'INAR_FERE', # Fecha de registro
                        'INAR_USMO', # Usuario de modificación
                        'INAR_FEMO', # Fecha de modificación
                    ]);
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_DOWNLOAD_ARTITLE_DOW007: Ocurrió un error al obtener los detalles de la descripción del artículo.", $th->getMessage(), 500);
            }
            $arrDetailsDescription = json_decode(json_encode($getDetailsDescription), true);
            $arrDescriptionArtitles['DETAILS'] = $arrDetailsDescription;

            $arrDataArtitles[] = $arrDescriptionArtitles;
        }

        // Se inicializa el nombre del documento
        $nameDocument = "CONTENT_ARTITLE_BY_".$responseData['PROVIDER'].".xlsx";
        // Se crea el documento y se obtiene el base64 del documento
        $base64Document = $this->createDocument($arrDataArtitles);

        // Se guarda el documento y se genera el código del documento
        $arrResponseDocument = $this->resourcesController->saveDocument($base64Document, 'GEAD', $nameDocument, 'IN', $responseData['LINE_NUMBER']);
        if ( $arrResponseDocument['error'] ) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, 'ERR_DOWNLOAD_ARTITLE_DOW008:'.$arrResponseDocument['msg'], $arrResponseDocument['response'], 500);
        }
        // Se obtiene el código del documento
        $codeDocument = $arrResponseDocument['response'];

        try {
            $validaeInsert = DB::table('S002V01TPRDO')->insert([
                'PRDO_NUPR' => $responseData['PROVIDER'],
                'PRDO_CODU' => $codeDocument,
                'PRDO_TIPO' => 'IN',
                'PRDO_DESC' => 'GENERACIÓN DE DOCUMENTO DE ARTÍCULOS POR PROVEEDOR',
                'PRDO_NULI' => $responseData['LINE_NUMBER'],
                'PRDO_USRE' => $user,
                'PRDO_FERE' => Carbon::now()->timezone('America/Mazatlan')->toDateTimeString(),
                'PRDO_FEAR' => DB::raw('CURRENT_TIMESTAMP'),
            ]);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_DOWNLOAD_ARTITLE_DOW009: Ocurrió un error al registrar el documento.", $th->getMessage(), 500);
        }

        if (!$validaeInsert) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_DOWNLOAD_ARTITLE_DOW010: No se pudo registrar el documento en la base de datos", [], 500);
        }

        DB::commit(); # Para guardar los cambios en la base de datos
        return $this->responseController->makeResponse(false, "ÉXITO: Se genero correctamente.", $codeDocument);

    }

    public function uploadArtitlesByProvider(Request $request) {
        $validator = Validator::make($request->all(), [
            'PROVIDER' => 'required|string',
            'USER' => 'required|string',
            'LINE_NUMBER' => 'required|string',
            'DOCUMENT' => 'required|string',
        ]);
        if ($validator->fails()) {
            return $this->responseController->makeResponse(
                true,
                "ERR_UPLOAD_ARTITLE_UPL000: Se encontraron uno o más errores.",
                $this->responseController->makeErrors($validator->errors()->messages()),
                401
            );
        }

        DB::beginTransaction();
        $responseData = $request->all();

        try {
            $user = $this->encController->decrypt($responseData['USER']);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_UPLOAD_ARTITLE_UPL001: No se pudo obtener los datos del usuario", $th->getMessage(), 500);
        }

        $nameDocument = "UPLOAD_".$responseData['PROVIDER']."_".date('YmdHms').".xlsx";
        // Se guarda el documento y se genera el código del documento
        $arrResponseDocument = $this->resourcesController->saveDocument($responseData['DOCUMENT'], 'GEAD', $nameDocument, 'IN', $responseData['LINE_NUMBER']);
        if ( $arrResponseDocument['error'] ) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL002:'.$arrResponseDocument['msg'], $arrResponseDocument['response'], 500);
        }
        // Se obtiene el código del documento
        $codeDocument = $arrResponseDocument['response'];

        // Se obtiene la ruta en donde se guardará el archivo
        $routeSaveDocument = "/app/public/GEAD/";
        // Se obtiene la ruta completa del archivo a guardar
        $pathRoute = storage_path().$routeSaveDocument.$codeDocument;

        if(!file_exists($pathRoute)){
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_UPLOAD_ARTITLE_UPL003: No se pudo obtener el documento.", [], 500);
        }

        $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx;
        $spreadsheet = $reader->load($pathRoute);
        $sheet = $spreadsheet->getSheetByName('ART');
        $maxRow = $sheet->getHighestRow();
        $maxColumn = $sheet->getHighestColumn();
        try {
            $arrDataArtitle = array();
            for ($positionRow=2; $positionRow <= $maxRow; $positionRow++) { 
                $arrContentRow = array();
                for ($positionColumn = 0; $positionColumn <= array_search($maxColumn, $this->arrAlphabet); $positionColumn++) { 
                    $data = $sheet->getCell($this->arrAlphabet[$positionColumn].$positionRow)->getValue();
                    // $code = $this->arrHeader[array_search($this->arrAlphabet[$positionColumn], $this->arrAlphabet)]['CODE'];
                    $infoHeader = $this->arrHeader[array_search($this->arrAlphabet[$positionColumn], $this->arrAlphabet)];
                    $data = trim($data);
                    if ($data == '' && $infoHeader['OBLIGATORY']) {
                        $position = $this->arrAlphabet[$positionColumn].$positionRow;
                        return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL004: El campo "'.$position.'" de la hoja ART es obligatorio.', [], 500);
                    } else if ($data == '') {
                        $data = null;
                    }
                    $arrContentRow[$infoHeader['CODE']] = $data;
                }
                $arrDataArtitle[] = $arrContentRow;
            }
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_UPLOAD_ARTITLE_UPL005: No se pudieron obtener los datos. Verifique que el formato de su documento sea correcto.", $th->getMessage(), 500);
        }
        $arrIdDetails = array();
        foreach ($arrDataArtitle as $keyArtitle => $artitle) {

            foreach ($this->arrHeader as $keyHeader => $header) {
                if (!array_key_exists($header['CODE'], $artitle)) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL006: El campo "'.$header['COLUMN'].'" no existe en los encabezados.', [], 500);
                }
            }

            try {
                $validateExistArtitle = DB::table('S002V01TARTI')
                    ->where('ARTI_IDAR', '=', $artitle['ARTI_IDAR'])
                    ->where('ARTI_NULI', '=', $responseData['LINE_NUMBER'])
                    ->where('ARTI_ESTA', '=', 'Activo')
                    ->exists();
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL007: Ocurrió un error al validar los artículos', $th->getMessage(), 500);
            }
            if (!$validateExistArtitle) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL008: El artículo con el número '.$artitle['ARTI_IDAR'].' no existe.', [], 500);
            }
            
            try {
                $validateExistDetails = (array) DB::table('S002V01TDEAR')
                    ->where('DEAR_IDAR', '=', $artitle['ARTI_IDAR'])
                    ->where('DEAR_NUPR', '=', $responseData['PROVIDER'])
                    ->where('DEAR_ESTA', '=', 'Activo')
                    ->exists();
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL009: Ocurrió un error al validar la descripción', $th->getMessage(), 500);
            }
            if (!$validateExistDetails) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL010: La descripción del artículo no pudo ser encontrada.', [], 500);
            }
            // $arrIdDetails[] = $arrDescription['DEAR_IDDE'];
            try {
                $arrFamily = (array) DB::table('S002V01TFAMI')
                    ->where('FAMI_NULI', '=', $responseData['LINE_NUMBER'])
                    ->where('FAMI_ESTA', '=', 'Activo')
                    ->where('FAMI_NOMB', '=', $artitle['FAMI_NOMB'])
                    ->first();
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL011: Ocurrió un error al validar la descripción.', $th->getMessage(), 500);
            }

            if (count($arrFamily) == 0) {
                DB::rollBack();
                $indexHeader = array_search('FAMI_NOMB', array_column($this->arrHeader, 'CODE'));
                $header = $this->arrHeader[$indexHeader]['COLUMN'];
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL012: El valor del campo "'.$header.'" no es válido.', [], 500);
            }
            
            try {
                $arrSubfamily = (array) DB::table('S002V01TSUBF')
                    ->where('SUBF_NULI', '=', $responseData['LINE_NUMBER'])
                    ->where('SUBF_ESTA', '=', 'Activo')
                    ->where('SUBF_NOMB', '=', $artitle['SUBF_NOMB'])
                    ->first();
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL013: Ocurrió un error al validar la descripción.', $th->getMessage(), 500);
            }
            if (count($arrSubfamily) == 0) {
                DB::rollBack();
                $indexHeader = array_search('SUBF_NOMB', array_column($this->arrHeader, 'CODE'));
                $header = $this->arrHeader[$indexHeader]['COLUMN'];
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL014: El valor del campo "'.$header.'" no es válido.', [], 500);
            }

            try {
                $validateUpdate = DB::table('S002V01TARTI')
                    ->where('ARTI_IDAR', '=', $artitle['ARTI_IDAR'])
                    ->where('ARTI_NULI', '=', $responseData['LINE_NUMBER'])
                    ->update([
                        'ARTI_IDFA' => $arrFamily['FAMI_IDFA'],
                        'ARTI_IDSU' => $arrSubfamily['SUBF_IDSU'],
                        'ARTI_CODI' => $artitle['ARTI_CODI'],
                        'ARTI_NOMB' => $artitle['ARTI_NOMB'],
                        'ARTI_USMO' => $user,
                        'ARTI_FEMO' => Carbon::now()->timezone('America/Mazatlan')->toDateTimeString(),
                    ]);
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL015: Ocurrió un error al actualizar los artículos.', $th->getMessage(), 500);
            }
            if (!$validateUpdate) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL016: No se pudieron actualizar los artículos.', [], 500);
            }

            if ($artitle['DEAR_COWE'] == 'Si') {
                $webPurchase = 1;
            }else if ($artitle['DEAR_COWE'] == 'No') {
                $webPurchase = 0;
            } else {
                DB::rollBack();
                $indexHeader = array_search('DEAR_COWE', array_column($this->arrHeader, 'CODE'));
                $header = $this->arrHeader[$indexHeader]['COLUMN'];
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL017: El valor del campo "'.$header.'" no es válido.', [], 500);
            }

            try {
                $arrUnid = (array) DB::table('S002V01TUNID')
                    ->where('UNID_NULI', '=', $responseData['LINE_NUMBER'])
                    ->where('UNID_ESTA', '=', 'Activo')
                    ->where('UNID_NOMB', '=', $artitle['DEAR_IDUN'])
                    ->first();
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL018: Ocurrió un error al obtener las unidades.', $th->getMessage(), 500);
            }
            if (count($arrUnid) == 0) {
                DB::rollBack();
                $indexHeader = array_search('DEAR_IDUN', array_column($this->arrHeader, 'CODE'));
                $header = $this->arrHeader[$indexHeader]['COLUMN'];
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL019: El valor del campo "'.$header.'" no es válido.', [], 500);
            }
            try {
                $validateUpdate = DB::table('S002V01TDEAR')
                    ->where('DEAR_NUPR', '=', $responseData['PROVIDER'])
                    ->where('DEAR_IDAR', '=', $artitle['ARTI_IDAR'])
                    ->where('DEAR_ESTA', '=', 'Activo')
                    ->where('DEAR_NULI', '=', $responseData['LINE_NUMBER'])
                    ->update([
                        'DEAR_DESC' => $artitle['DEAR_DESC'],
                        'DEAR_CARA' => $artitle['DEAR_CARA'],
                        'DEAR_COWE' => $webPurchase,
                        'DEAR_IDUN' => $arrUnid['UNID_IDUN'],
                        'DEAR_USMO' => $user,
                        'DEAR_FEMO' => Carbon::now()->timezone('America/Mazatlan')->toDateTimeString(),
                        'DEAR_FEAR' => DB::raw('CURRENT_TIMESTAMP'),
                    ]);
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL020: Ocurrió un error al actualizar las descripciones de los artículos.', $th->getMessage(), 500);
            }
            if (!$validateUpdate) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL021: No se pudieron actualizar las descripciones de los.', [], 500);
            }
            
            $arrIdDetails[] = $artitle['ARTI_IDAR'];
        }

        foreach ($arrIdDetails as $idDetails) {
            $readerDetails = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx;
            $spreadsheet = $readerDetails->load($pathRoute);
            $sheet = $spreadsheet->getSheetByName('ARTDET-'.$idDetails);
            $maxRow = $sheet->getHighestRow();
            $maxColumn = $sheet->getHighestColumn();
            try {
                $arrDataDetails = array();
                for ($positionRow=2; $positionRow <= $maxRow; $positionRow++) { 
                    $arrContentRow = array();
                    for ($positionColumn = 0; $positionColumn <= array_search($maxColumn, $this->arrAlphabet); $positionColumn++) { 
                        $data = $sheet->getCell($this->arrAlphabet[$positionColumn].$positionRow)->getValue();
                        $infoHeader = $this->arrHeaderDetails[array_search($this->arrAlphabet[$positionColumn], $this->arrAlphabet)];
                        $data = trim($data);
                        if ($data == '' && $infoHeader['OBLIGATORY']) {
                            $position = $this->arrAlphabet[$positionColumn].$positionRow;
                            return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL022: El campo "'.$position.'" de la hoja ARTDET-'.$idDetails.' es obligatorio.', [], 500);
                        } else if ($data == '') {
                            $data = null;
                        }
                        $arrContentRow[$infoHeader['CODE']] = $data;
                    }
                    $arrDataDetails[] = $arrContentRow;
                }
            } catch (\Throwable $th) {
                DB::rollBack();
                return $this->responseController->makeResponse(true, "ERR_UPLOAD_ARTITLE_UPL023: No se pudieron obtener los datos. Verifique que el formato de su documento sea correcto.", $th->getMessage(), 500);
            }

            foreach ($arrDataDetails as $keyDetails => $details) {

                foreach ($this->arrHeaderDetails as $keyHeader => $header) {
                    if (!array_key_exists($header['CODE'], $details)) {
                        DB::rollBack();
                        return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL024: El campo "'.$header['COLUMN'].'" no existe en los encabezados.', [], 500);
                    }
                }
                try {
                    $validateDetails = DB::table('S002V01TINAR')
                        ->where('INAR_IDIN', '=', $details['INAR_IDIN'])
                        ->where('INAR_ESTA', '=', 'Activo')
                        ->where('INAR_NULI', '=', $responseData['LINE_NUMBER'])
                        ->exists();
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_UPLOAD_ARTITLE_UPL025: No se pudieron obtener los datos. Verifique que el formato de su documento sea correcto.", $th->getMessage(), 500);
                }
                if (!$validateDetails) {
                    DB::rollBack();
                    $indexHeader = array_search('INAR_IDIN', array_column($this->arrHeaderDetails, 'CODE'));
                    $header = $this->arrHeaderDetails[$indexHeader]['COLUMN'];
                    $position = $this->arrHeaderDetails[$indexHeader]['POSITION'];
                    $errorPosition = $position.$keyDetails+1;
                    return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL026: El valor del campo "'.$header.'" no es válido.', [], 500);
                }


                try {
                    $validateUpdate = DB::table('S002V01TINAR')
                        ->where('INAR_IDIN', '=', $details['INAR_IDIN'])
                        ->where('INAR_NULI', '=', $responseData['LINE_NUMBER'])
                        ->where('INAR_ESTA', '=', 'Activo')
                        ->update([
                            'INAR_CODI' => $details['INAR_CODI'],
                            'INAR_MODE' => $details['INAR_MODE'],
                            'INAR_MONE' => $details['INAR_MONE'],
                            'INAR_PREC' => $details['INAR_PREC'],
                            'INAR_MOMI' => $details['INAR_MOMI'],
                            'INAR_CARA' => $details['INAR_CARA'],
                            'INAR_USMO' => $user,
                            'INAR_FEMO' => Carbon::now()->timezone('America/Mazatlan')->toDateTimeString(),
                            'INAR_FEAR' => DB::raw('CURRENT_TIMESTAMP'),
                        ]
                    );
                } catch (\Throwable $th) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, "ERR_UPLOAD_ARTITLE_UPL027: Ocurrió un error al actualizar los detalles del artículo.", $th->getMessage(), 500);
                }

                if (!$validateUpdate) {
                    DB::rollBack();
                    return $this->responseController->makeResponse(true, 'ERR_UPLOAD_ARTITLE_UPL028: No se pudo actualizar los detalles del artículo.', [], 500);
                }
            }
        }
        DB::commit();
        return $this->responseController->makeResponse(false, "ÉXITO: Actualización Exitosa");
    }

    private function createDocument($arrDescription) {

        // Se inicializa el archivo xlsx
        $spreadsheet = new Spreadsheet();
        // Se crea la primera hoja donde se encontraran todos los artículos del proveedor
        $activeWorksheet = $spreadsheet->getActiveSheet()->setTitle("ART");
        
        // Se colocan los encabezados de la tabla
        $positionColumn = 0; # Posición de la columna (Empieza en 0 debído al arreglo del abecedario el cual corresponde a la letra A)
        // Se itean la información del encabezado
        foreach ($this->arrHeader as $keyArtitle => $header) {
            // Se ingresa el encabezado en la hoja
            $activeWorksheet->setCellValue($this->arrAlphabet[$positionColumn]."1", $header['COLUMN']);
            // Se incrementa la posición para la siguiente columna
            $positionColumn++;
        }

        // Se ingresa la información de los artículos
        $positionRow = 2; # Posición de la fila (Empieza en 2 debído a que la posición 1 ya la tomó la información del encabezado)
        // Se iteran los artículos del proveedor
        foreach ($arrDescription as $keyDescription => $arrArtitle) {
            $positionColumn = 0; # Siempre se inicializa en 0 por cada información de los artículos para que vuelva a comenzar en la columna A
            // Se itera el objeto que tiene la información del artículo
            foreach ($this->arrHeader as $keyHeader => $header) {
                // Se verifica que el campo obtenido se encuentre en la lista del encabezado
                // Se hace de esta manera para que se ordenen los campos de acuerdo al ordenamiento de los encabezados
                if(array_key_exists($header['CODE'], $arrArtitle)){

                    if ($header['CODE'] == 'DEAR_COWE') {
                        $arrArtitle[$header['CODE']] = $arrArtitle[$header['CODE']] == 0 ? 'No':'Si';
                    }
                    if ($header['CODE'] == 'DEAR_IDUN') {
                        $arrArtitle[$header['CODE']] = $arrArtitle[$header['CODE']]->UNID_NOMB;
                    }

                    // Se ingresa la información
                    $activeWorksheet->setCellValue($this->arrAlphabet[$positionColumn].$positionRow, $arrArtitle[$header['CODE']]);
                    // Se incrementa la posición para la siguiente columna
                    $positionColumn++;
                }
            }
            // Al terminar de procesar toda la información, la posición de la fila se incrementa para que pase a la siguiente fila
            $positionRow++;

            // Se verifica que la información obtenida tenga detalles
            if (count($arrArtitle['DETAILS']) > 0) {
                // En caso de ser verdadero, se crea una nueva hoja
                $spreadsheet->createSheet();
                // Se selecciona para trabajar ahora en esa hoja nueva
                $spreadsheet->setActiveSheetIndex($keyDescription + 1);

                // Se ingresa el nombre de la hoja, que es referente a su información perteneciente
                $activeWorksheetDetails = $spreadsheet->getActiveSheet()->setTitle('ARTDET-'.$arrArtitle['ARTI_IDAR']);

                // Se ingresan los encabezados en la nueva hoja
                $positionColumnDetails = 0; # Posición de la columna de los detalles (Empieza en 0 debído al arreglo del abecedario el cual corresponde a la letra A)
                // Se itean la información del encabezado de los detalles
                foreach ($this->arrHeaderDetails as $keyHeaderDetails => $headerDetails) {
                    // Se ingresa el encabezado en la hoja de los detalles
                    $activeWorksheetDetails->setCellValue($this->arrAlphabet[$positionColumnDetails]."1", $headerDetails['COLUMN']);
                    // Se incrementa la posición para la siguiente columna de los detalles
                    $positionColumnDetails++;
                }

                // Se ingresa la información de los artículos
                $positionRowDetails = 2; # Posición de la fila de los detalles (Empieza en 2 debído a que la posición 1 ya la tomó la información del encabezado de los detalles)
                // Se itera el objeto que tiene la información del artículo
                foreach ($arrArtitle['DETAILS'] as $key => $details) {
                    $positionColumnDetails = 0; # Siempre se inicializa en 0 por cada información de los detalles para que vuelva a comenzar en la columna A
                    // Se itera el objeto que tiene la información de los detalles
                    foreach ($this->arrHeaderDetails as $keyHeaderDetails => $headerDetails) {
                        // Se verifica que el campo obtenido se encuentre en la lista del encabezado de los detalles
                        // Se hace de esta manera para que se ordenen los campos de acuerdo al ordenamiento de los encabezados
                        if(array_key_exists($headerDetails['CODE'], $details)){
                            // Se ingresan los detalles
                            $activeWorksheetDetails->setCellValue($this->arrAlphabet[$positionColumnDetails].$positionRowDetails, $details[$headerDetails['CODE']]);
                            // Se incrementa la posición para la siguiente columna
                            $positionColumnDetails++;
                        }
                    }
                    // Al terminar de procesar toda la información, la posición de la fila se incrementa para que pase a la siguiente fila
                    $positionRowDetails++;
                }

                // Se inicializan las posiciones iniciales y finales
                $inicialPositionDetails = "A1";
                $finalPositionDetails = $this->arrAlphabet[$positionColumnDetails-1].$positionRowDetails-1;

                // Se inicializa el formato de la tabla
                $table = new Table("$inicialPositionDetails:$finalPositionDetails", 'Table'.$arrArtitle['ARTI_IDAR']);

                // Se inicializa los estilos de la tabla
                $tableStyle = new TableStyle();
                // Se ingresa el tipo de tabla
                $tableStyle->setTheme(TableStyle::TABLE_STYLE_MEDIUM10);
                // Se ingresa el estilo en la tabla
                $tableStyle->setShowRowStripes(true);
                $table->setStyle($tableStyle);
                $activeWorksheetDetails->addTable($table);

                // Se ajustan las dimensiones de la hoja de detalles
                $positionColumnDetails = 0; # Posición de la columna (Empieza en 0 debído al arreglo del abecedario el cual corresponde a la letra A)
                // Se iteran la información del encabezado de los detalles
                foreach ($this->arrHeaderDetails as $keyHeaderDetails => $headerDetails) {

                    if ($headerDetails['CODE'] == 'INAR_CARA') {
                        $activeWorksheetDetails->getColumnDimension($this->arrAlphabet[$positionColumnDetails])->setAutoSize(true);
                        $activeWorksheetDetails->getStyle($this->arrAlphabet[$positionColumnDetails])->getAlignment()->setWrapText(true); 

                    } else {
                        $activeWorksheetDetails->getColumnDimension($this->arrAlphabet[$positionColumnDetails])->setAutoSize(true);
                    }

                    // Las columnas son auto ajustadas
                    // Se incrementa la posición para la siguiente columna
                    $positionColumnDetails++;
                }
            }
        }
        // Se inicializan las posiciones iniciales y finales
        $inicialPosition = "A1";
        $finalPosition = $this->arrAlphabet[$positionColumn-1].$positionRow-1;

        // Se inicializa el formato de la tabla
        $table = new Table("$inicialPosition:$finalPosition", 'Table1');

        // Se inicializa los estilos de la tabla
        $tableStyle = new TableStyle();
        // Se ingresa el tipo de tabla
        $tableStyle->setTheme(TableStyle::TABLE_STYLE_MEDIUM8);
        // Se ingresa el estilo en la tabla
        $tableStyle->setShowRowStripes(true);
        $table->setStyle($tableStyle);
        $activeWorksheet->addTable($table);

        // Se ajustan las dimensiones de la hoja de los artículos
        $positionColumn = 0; # Posición de la columna (Empieza en 0 debído al arreglo del abecedario el cual corresponde a la letra A)
        // Se iteran la información del encabezado
        foreach ($this->arrHeader as $keyHeader => $header) {
            if ($header['CODE'] == 'DEAR_DESC' || $header['CODE'] == 'DEAR_CARA') {
                // Si se obtienen las siguientes columnas, entonces tendrá 40 de dimensión
                $activeWorksheet->getColumnDimension($this->arrAlphabet[$positionColumn])->setWidth(40);
                $activeWorksheet->getStyle($this->arrAlphabet[$positionColumn])->getAlignment()->setWrapText(true); 
            } else {
                // Las columnas son auto ajustadas
                $activeWorksheet->getColumnDimension($this->arrAlphabet[$positionColumn])->setAutoSize(true);
            }
            // Se incrementa la posición para la siguiente columna
            $positionColumn++;
        }


        $writer = new Xlsx($spreadsheet);
        ob_start();
        $writer->save('php://output');
        $base64 = base64_encode(ob_get_clean());
        return $base64;
        // $validate = \File::put( storage_path() . '/test.xlsx',  base64_decode($base64) );
    }
}