how to write this mysql query using eloquent?

use orwhere instead of or

$now = \Carbon\Carbon::now()->format('Y-m-d H:i:s'); $afterTomorrow = \Carbon\Carbon::today()->addDays(2)->format('Y-m-d H:i:s'); \DB::raw("select * from games where ( started_at >= $now and started_at <= $afterTomorrow ) orwhere ( started_at <= $now and finished_at >= $now )")->getValue();

Something along these lines should do it:

$now = Carbon::now();
$afterTomorrow = Carbon::today()->addDays(2);

$games = Game::whereBetween('started_at', [$now, $afterTomorrow])
    ->orWhere(function($query) use ($now, $afterTomorrow) {
        $query->where('started_at', '<=', $now);
              ->orWhere('finished_at', '>=', $now);
    })
    ->get();

@GORAKH - OK, but my query is like this:

( whereDate && whereDate ) || (whereDate && whereDate )

How and Where can I used orWhere in this structure? like this?

( whereDate && whereDate ) || (orWhereDate && whereDate )

@alihoushyaripour please show me your query .

Try something like this.

$users = DB::table('users') ->where('votes', '>', 100) ->orWhere('name', 'John') ->get();

@GORAKH - I was write this first, but all of 4 whereDate executed as && together:

\App\Models\Game::whereNull('deleted_at')
    ->whereDate('started_at', '>=', $now)->whereDate('started_at', '<=', $afterTomorrow)
    ->whereDate('started_at', '<=', $now)->whereDate('finished_at', '>=', $now)
    ->orderBy('created_at', 'desc');

and then I was changed query to this:

\App\Models\Game::whereNull('deleted_at')
    ->whereDate('started_at', '>=', $now)->whereDate('started_at', '<=', $afterTomorrow)
    ->orWhereDate('started_at', '<=', $now)->whereDate('finished_at', '>=', $now)
    ->orderBy('created_at', 'desc');

but the first to the third query is executed correctly, but the fourth qurry doesn't executed correctly, because the first and second whereDate must be && together, and also the third and fourth whereDate query must be && together, and then the result of these two queries must be || together.

@alihoushyaripour

you can try this .

    $now = \Carbon\Carbon::now()->format('Y-m-d H:i:s');
    $afterTomorrow = \Carbon\Carbon::today()->addDays(2)->format('Y-m-d H:i:s');
   \DB::raw("select * from games whereBetween ( 'started_at',[$FromDate, $ToDate] ) orwhereBetween ( 
    'started_at',[$FromDate, $ToDate] )")->getValue();

You want to like this ?

          \App\Models\Game::whereNull('deleted_at')
         ->whereBetween('started_at',[$now,$afterTomorrow] )
         ->WhereDate('started_at', '<=', $now)
          ->whereDate('finished_at', '>=', $now)
          ->orderBy('created_at', 'desc');

@GORAKH - Yes my friend, I test now and both of them worked for me, thank you.

I set second answer as Best Answer because it's write using eloquent and be beauty and clean.

You could've used parameter grouping to achieve the effect you wanted with the query builder.