EVOLUTION-MANAGER

Edit File: GacetasController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\gacetas_anio;
use App\gacetas;
use Log;

class GacetasController extends Controller
{

public function buscar_gacetas(Request $request){
        try {
            
            $buscar = $request->buscar;
            $lista_gacetas = [];

if(preg_match('/^[a-zA-Z0-9 .()-]+$/', $buscar)){

$lista_gacetas = gacetas_anio::with(["gacetas"=>function($query) use ($buscar){
                    $query->where("gaceta", "like", "%$buscar%")
                    ->orWhere("titulo1", "like", "%$buscar%")
                    ->orWhere("titulo2", "like", "%$buscar%")
                    ->orWhere("titulo3", "like", "%$buscar%")
                    ->orWhere("titulo4", "like", "%$buscar%");
                }])
                ->whereHas("gacetas", function($query)use($buscar){
                    $query->where("gaceta", "like", "%$buscar%")
                    ->orWhere("titulo1", "like", "%$buscar%")
                    ->orWhere("titulo2", "like", "%$buscar%")
                    ->orWhere("titulo3", "like", "%$buscar%")
                    ->orWhere("titulo4", "like", "%$buscar%");
                })                
                ->orWhere("anio", $buscar)
                ->orderBy("anio", "desc")
                ->get();

}else if(empty($buscar)){
                $lista_gacetas = gacetas_anio::with("gacetas")
                ->orderBy("anio", "desc")
                ->get();
            }

return response()->json([
                "status"=> 200,
                "response"=> $lista_gacetas
            ]);

} catch (\Throwable $th) {
            dd($th->getMessage());
            Log::error(__CLASS__." => ".__FUNCTION__." => Mensaje => ".$th->getMessage()." => en la linea: ".$th->getLine());
            return response()->json([
                "status"=> 500,
                "message"=> "Error interno"
            ]);
        }
    }

}