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

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\ResponseController;
use App\Http\Controllers\EncryptionController;
use App\Http\Controllers\ResourcesController;
use Illuminate\Http\Request;
use Illuminate\Support\Carbon;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Validator;


class OrderReceptionController extends Controller
{
    private $responseController;
    private $encController;
    private $resourcesController;

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

    public function getOrderReception($user, $line) {
        DB::beginTransaction();
        try {
            $getOrderReception = DB::table('S002V01TORCO')
                ->where('ORCO_NULI', '=', $line)
                ->where('DESP_NULI', '=', $line)
                ->where('DESP_ESTA', '=', 'Activo')
                ->where('ORCO_ESTA', '=', 'Recibido')
                ->orWhere('ORCO_ESTA', '=', 'Facturado')
                ->orWhere('ORCO_ESTA', '=', 'Devuelto')
                ->join('S002V01TDESP','DESP_IDDE','=','ORCO_IDDE')
                ->join('S002V01TLINE','LINE_IDLI','=','ORCO_IDLI')
                ->get([
                    'ORCO_NUOR',
                    'ORCO_ESTA',
                    'ORCO_INEX',
                    'ORCO_USRE',
                    'ORCO_FERE',
                    'ORCO_USMO',
                    'ORCO_FEMO',
                    'ORCO_FEAR',
                    'LINE_IDLI',
                    'LINE_NUPR',
                    'LINE_OTPR',
                    'LINE_OTCO',
                    'DESP_IDDE',
                    'DESP_NODE',
                    'DESP_NOMB',
                    'DESP_APPA',
                    'DESP_APMA',
                    'DESP_LADA',
                    'DESP_TELE',
                    'DESP_CORR',
                    'DESP_CALL',
                    'DESP_NUEX',
                    'DESP_NUIN',
                    'DESP_COPO',
                    'DESP_COLO',
                    'DESP_LOCA',
                    'DESP_MUNI',
                    'DESP_ENTI',
                    'DESP_PAIS',
                    'DESP_COME',
                    'DESP_ESTA',
                    'DESP_INEX',
                    'DESP_USRE',
                    'DESP_FERE',
                    'DESP_USMO',
                    'DESP_FEMO',
                    'DESP_FEAR',
                ]);
        } catch (\Throwable $th) {
            DB::rollBack();
            return $this->responseController->makeResponse(true, "ERR_ORDER_RECEPTION_GET000: Ocurrió un error al obtener los datos.", $th->getMessage(), 500);
        }
        DB::commit();
        return $this->responseController->makeResponse(false, "ÉXITO: Consulta Exitosa", $getOrderReception);
    }
}