laravel get Data from table using model in laravel 5.2

Question

i want to get vendor_name and user who assign order to vendor in view. But every time i got this error

ErrorException in b6bb559eccdc8a2d45a2d2d6ce89e8e217411386.php line 26: Trying to get property of non-object (View: E:\xampp\htdocs\ftdindia\resources\views\view\Orders\allorder.blade.php) in b6bb559eccdc8a2d45a2d2d6ce89e8e217411386.php line 26 at CompilerEngine->handleViewException(object(ErrorException), '1') in PhpEngine.php line 44

my codes are given below

Controller for Order

public function allorder(){
    $orders = OrderGrid::paginate(100);

    return view ('view.Orders.allorder', ['orders' => $orders]);


    //dd($orders->all());

}

Here is My Model

class OrderGrid extends model{

    protected $table = 'order_grids';

    public function vendor() { 
        return $this->belongsTo(User::class);
    } 

    public function assignedBy() { 
        return $this->belongsTo(User::class, 'vendor_assigned_by_user');
    } 
}

Here is my view

@foreach($orders as $order)
<tr>
    <td> {{ $i }}</td>
    <td>{{ $order->order_id }}</td>
    <td>{{ $order->vendor->username }}</td>
    <td>{{ $order->assignedBy->username }}</td>
    <td>{{ $order->delivery_city }}</td>
    <td>{{ $order->delivery_date }}</td>
    <td>{{ $order->delivery_time }}</td>
    <td>{{ $order->order_statuss }}</td>
    <td>{{ $order->order_status }}</td>
    <td>
        @if(!$order->vendor_id)
            Unassigned
        @else
            Assigned
        @endif
    </td>
    <td></td>
</tr>
<?php $i +=1; ?>
@endforeach

try changing method name "vendor()" to something else "order_vendor()" in your model. and then use it in view like - $order->order_vendor->username. based on this link - laravel.io/forum/… — Manoj Salvi
– Manoj Salvi, Commented Jul 14, 2016 at 7:11

cool Quazi · Accepted Answer · 2016-07-14 07:56:05Z

@foreach($orders as $order)
<tr>
    <td> {{ $i }}</td>
    <td>{{ $order->order_id }}</td>
    <td>{{ $order->vendor->username }}</td>  inspite of this do <td>{{ !is_null($order->vendorName) ? $order->vendorName->username : null }}</td>
    <td>{{ $order->assignedBy->username }}</td> and same here also <td>{{ !is_null($order->assignedBy) ? $order->assignedBy->username : null }}</td>
    <td>{{ $order->delivery_city }}</td>
    <td>{{ $order->delivery_date }}</td>
    <td>{{ $order->delivery_time }}</td>
    <td>{{ $order->order_statuss }}</td>
    <td>{{ $order->order_status }}</td>
    <td>
        @if(!$order->vendor_id)
            Unassigned
        @else
            Assigned
        @endif
    </td>
    <td></td>
</tr>
<?php $i +=1; ?>
@endforeach

and in Model

public function vendorName() { 
        return $this->belongsTo('App\Model\User', 'vendor_id', 'id');
    } 

    public function assignedBy() { 
        return $this->belongsTo('App\Model\User', 'assigned_by', 'id');
    }

Nitish Kumar · Accepted Answer · 2016-07-14 07:14:02Z

0

The error you are getting relates to how you are calling the vendor() function in the $order collection.

The docs are a good place for a solid understanding on this, but essentially all Eloquent relationships are defined via functions and so you may call those functions to obtain an instance of the relationship without actually executing the relationship queries.

As such it needs to be:

<td>{{ $order->vendor()->username }}</td>

Nothing that we are now chaining vendor() rather than vendor.

answered Jul 14, 2016 at 7:14

Nitish Kumar

6,30722 gold badges88 silver badges160 bronze badges

3 Comments

cool Quazi Over a year ago

not working..... i had made some changes but this return only 1..... here are the changes... {{ !is_null($order->assignedBy ? $order->assignedBy->username: null) }}

Nitish Kumar Over a year ago

again you are doing the same mistake try assignedBy() instead of assignedBy.

cool Quazi Over a year ago

hmmm thanks for that.... i've got the solution actually you are that letting me know there is issue in view

Collectives™ on Stack Overflow

laravel get Data from table using model in laravel 5.2

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related