whereDate / whereMonth / whereDay / whereYear / whereTime ???

[Mellowz]

is whereDate / whereMonth / whereDay / whereYear / whereTime are not imlement ?

[msyahidin]

+1

[mean-cj]

+1

[Smolevich]

You can implement this function in trait for example or prepare implementation this examples

[AngusDV]

oh i am need a lot please prepare these functions

[gialang]

+1

[a-zog]

I'm not sure about your use case, but I could solve mine using the native Eloquent features.

If you need to get all posts for a specific time period and display a chart from the result.

  $results =\DB::collection($model)
                ->whereBetween(
                    'created_at',
                    array(
                        Carbon::parse($min),
                        Carbon::parse($max)
                    )
                 )
                ->get()
                ->groupBy(function ($item) {
                    return $item['created_at']->toDateTime()->format("Ym");
                });

Hope that would help

[teamseamive]

Any example to get current month records based on whereDate?
We're trying
Story::where('author_id', $userProfile->_id)->whereDate('timestamp', '>=', now()->month)->first();

We're using this for now

$firstOfMonth = now()->firstOfMonth();
$lastOfMonth  = now()->lastOfMonth();

$stories = Story::where('author_id', $userProfile->_id)
->whereBetween('timestamp', [$firstOfMonth, $lastOfMonth])
->get();

if (count($stories) > 0) {
 //have stories for current month
}