Home / Questions / 215801
Accepted
Alberto Ortega
Asked: 2020-11-22 12:23:33 +0800 CST 2020-11-22 12:23:33 +0800 CST

Does anyone know how I can do this kind of Eloquent queries?

  • 772

I need to have a query builder. The only way I have come up with is to make a string, and on the string form the eloquent query. I only have problem executing the query.

$variable = "where('a','asd')->get()";
return Modelo::$variable;

This error comes out:

Access to undeclared static property: App\Models\Api\Ela\Model::$variable"

php

1 Answers

  1. Best Answer

    You can build the Eloquent query based on what you get as follows:

    According to what I understood, different parameters arrive through json to build the query, assuming that one of those filters that you receive is called filter_name, and after encoding and processing the json or however you want to handle it, what came in that parameter is saved in a variable $filtro_nombreor the same is null;

    $query = Miobjeto::select("un_campo")
->when($filtro_nombre != null, function ($query) use ($filtro_nombre) {
    return $query->where('nombre', $filtro_nombre);
})
//aca puedes seguir agregando todos los when necesarios.
->get();

return $query;

    Now if you want you can also use Query Builder:

    $query= DB::table('mis_objetos')->select("un_campo");

if($filtro_nombre != null)
    $query->where('nombre',$filtro_nombre);

//aca puedes seguir construyendo la consulta.

return $query->get();

    I hope it helps.

    Cheers!

    • 1