Why is laravel view returning array? instead of the value?

Question

Here is my controller function

public function index()
{
    $currentdate = Carbon::yesterday();
    $totalsales = DB::table('receipts')
        ->whereDate('created_at','=', $currentdate)
        ->where('status','=', 'served')
        ->orderBy('created_at','asc')
        ->select(DB::raw('SUM(amount_due) as totalsales'))
        ->get();
        // ->first();
        // return $totalsales;
    return view('dashboard.index',compact('totalsales'));
}

Here is my View

<div class="panel-body">
<h2>{{$totalsales}}</h2>

insted of the value itself the view returns an array like this

[{"totalsales":"130.00"}]

If you need only record, you can use ->first() on otherwise use ->get(). In above case you can use foreach on $totalsales. — Sagar Gautam
– Sagar Gautam, Commented Aug 3, 2017 at 1:39
And donot forget to accept if it really help to solve your problem. — Sagar Gautam
– Sagar Gautam, Commented Aug 3, 2017 at 2:06

Sagar Gautam · Accepted Answer · 2017-08-03 01:56:30Z

1

I think you need just sum of the amount_due column so you can use following query.

$totalsales = DB::table('receipts')
              ->whereDate('created_at','=', $currentdate)
              ->where('status','=', 'served')
              ->orderBy('created_at','asc')
              ->sum('amount_due');

Keep other code same, This will work for you.

Hope you understand

answered Aug 3, 2017 at 1:56

Sagar Gautam

9,4099 gold badges62 silver badges95 bronze badges

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

Comments

Jed · Accepted Answer · 2017-08-03 02:00:11Z

0

It doesn't know there's only one field.

You need to either specify

<h2>{{ $totalsales->totalsales }}</h2>

or change your query to:

    $totalsales = DB::table('receipts')
    ->whereDate('created_at','=', $currentdate)
    ->where('status','=', 'served')
    ->orderBy('created_at','asc')
    ->select(DB::raw('SUM(amount_due) as totalsales'))
    ->first()
    ->totalsales;

edited Aug 3, 2017 at 2:00

answered Aug 3, 2017 at 1:40

Jed

2161 silver badge5 bronze badges

2 Comments

Zack San Agustin Over a year ago

i tried this one but it showed me this errorCall to undefined method stdClass::value()

Jed Over a year ago

Check my edit. Instead of ->value('totalsales'), with Query Builder (DB), you need ->totalsales

Collectives™ on Stack Overflow

Why is laravel view returning array? instead of the value?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related