Laravel Select Count Where Query

Question

I have Orders table and status column in my DB, the status is stored as [1,2,3,4] which is corresponding at frontend to [issued, pending, on thew ay, delivered] now I need to get the count of each status between 2 dates,

Please Note : I need the count of each status like,

issued : 80 pending : 50 on the way : 20 delivered : 170

I tried below code but don't no how to accomplish my needs

$account = DB::table('order')
                    ->whereBetween('created_at',[$fromdate, $todate])
                    ->select(DB::raw('COUNT(order.status) as total'))
                    ->get();
                    return response()->json($account,200);

Any help will be much appreciated

possible duplicate of: stackoverflow.com/questions/13223512/… — loic.lopez
– loic.lopez, Commented Apr 15, 2019 at 15:45

Tharaka Dilshan · Accepted Answer · 2019-04-15 16:15:56Z

2

$account = DB::table('order')
    ->select(DB::raw('COUNT(order.id) as total'),'status')
    ->whereBetween('created_at',[$fromdate, $todate])
    ->whereIn('status',[1,2,3,4])
    ->groupBy('status')
    ->get();

return response()->json($account,200);

edited Apr 15, 2019 at 16:15

Tharaka Dilshan

4,4993 gold badges17 silver badges29 bronze badges

answered Apr 15, 2019 at 16:14

Sanjula Madumal Hewage

1428 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mohammed Riyadh Over a year ago

Thanks, this is what i was looking for

gbalduzzi · Accepted Answer · 2019-04-15 16:14:08Z

0

DB::table('order')
    ->select(DB::raw('COUNT(*) as total')
    ->whereBetween('created_at',[$fromdate, $todate])
    ->groupBy('status')
    ->get();

answered Apr 15, 2019 at 16:14

gbalduzzi

10.3k3 gold badges36 silver badges65 bronze badges

Collectives™ on Stack Overflow

Laravel Select Count Where Query

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related