Get count of rows by date greater than today

Try doing it this way:

$deliveriesToday = $userorderstoday->whereDate('delivery_date', '=', now())->count();
$allDeliveries = $userorderstoday->whereDate('delivery_date', '>', now())->count();

// alternatively
$allDeliveries = $userorderstoday->whereDate('delivery_date', '>', now()->addDays(5))->count();

Getting 0 on both deliveriesToday and allDeliveries with now().

@vilfago the whereDate method is not found in the class. Here is what I am using. Do I need to add something?

namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;
use Carbon\Carbon;
use Illuminate\Support\Facades\View;

Which version of laravel do you use ?

Is the delivery date a timestamp or a date field in db?

Didn't pay attention that it was on a collection, not in the query that you want to count the result...

You should filter the collection ( https://stackoverflow.com/questions/33806518/laravel-collection-date-comparison ), and then count the result.

Maybe it's easier and more efficient to do the count on the database query.

Laravel Spark version 5.0.1

It's a date field, not timestamp

Thanks @vilfago for the confirmation on what I suspected. i.e. My approach was wrong and too simple. I also looked at implementing something like this https://code.i-harness.com/en/q/13a60c3 and will look at this from a different angle.

And just a posted code solution that worked for anyone else who may read this:

public function show()
    {
        $ID = auth()->user()->id;
        $date = Carbon::today()->toDateString();
        $today = Carbon::today();

        $userorders = DB::table('order_headers')->where('user_id', $ID);
        $ordercount = $userorders->where('status', 'active')->count();

        $usertickets = DB::table('ticketit')->where('user_id', $ID);
        $ticketcount = $usertickets->where('status_id', '1')->count();

        $modified_date = Carbon::today()->addDay(5);
        
        $userorderstoday = DB::table('order_headers')->where('user_id', $ID);
        $deliveriesToday = $userorderstoday->whereDate('delivery_date', '=', $today)->count();
        
        $deliveryOrders = $userorders->where('delivery_date','>',$today)->where('delivery_date','<', $modified_date->endOfDay())->count();

        return view('home', ['date' =>$date, 'ordercount' => $ordercount, 'deliveryOrders' => $deliveryOrders, 'modified_date' =>$modified_date, 'ticketcount' => $ticketcount, 'deliveriesToday' => $deliveriesToday]);
    }