How to use condition in query dynamically -

Category: Eloquent ORM Topic: Eloquent Builder Created: 3 years ago

$query   = Order::query();
$keyword = $request->query( 'keyword' ) ?? '';
if ( !empty( $request->query( 'keyword' ) ) ) {
	$query->where( 'id', $request->query( 'keyword' ) )->orWhere('company_name', $keyword)->orWhere('job_number', $keyword);
	$meta_title = 'Invoice #: "' . $request->query( 'keyword' );
}
$orders = $query->orderBy( 'id', 'desc' )->paginate( 10 )->withQueryString();

Now above code can be written elegantly using eloquent method when() that is mentioned in this tutorial step by step. What basically when() method serves is the same purpose in writing dynamic query based on query string existence instead of if else block .

Last Edited: 2 years ago

How to use condition in query dynamically

Related Posts

Using selectRaw with aggregate function, where, orderBy, groupBy, take and get

Using WhereIn

Updating multiple rows

How to delete all the rows in a table

How to use count with where condition

How to get names in list instead of associated array ( id as key and name as value )

Using Like

Checking what query is run with eloquent

Using orWhere

Using dynamic condition under auth check and request query

What is Query Builder?

Using "with" in eloquent query

Getting last inserted id

Selecting last row of a table

How to write multiple AND queries inside OR query using closure

Returning rows where a column is between two values

Selecting rows if they are NULL or NOT NULL

How to use whereHas to retrieve rows based on existence of relationship

Using withAggregates in Eloquent way

Selecting fields inside eager loading method "with"

Quick way to save or update post with one liner of eloquent code

Using model observer - a separate class to observe model changes and run desired logic

Changing model values using mutators before saving in database

Using parameters in find() method

Using findorFail() and firstOrFail() method

Using whereDate, whereYear, whereMonth, whereDay and whereCreatedAt for dates

Using brackets to specify two or more where clauses into its own where function in eloquent

Using local scope in eloquent

Using global scope in eloquent

How to use eloquent when - more elegant way of using if statement