Display Data in Laravel Query from another table using model

Question

Help me again.

I have this in my model

public function quantity()
    {
        return $this->hasMany('App\Productquantity', 'prod_id', 'id');
    }

and I want to get the branch name of each product quantity so the productquantity table has field of branch_id.

How can I display the branch name in branch table?

@forelse($Productquantity->quantity as $dataQuantity)
<tr class="item{{$dataQuantity->id}}">
<td align="center" style="text-align:center" width="100px"> <a href="#" class="avatar"><img src="{{ asset('productimg') }}/{{$dataQuantity->pic}}" width="50px"/></a> </td>
<td style="width:100px;"> {{$Productquantity->product_name}}</td>
<td>{{$dataQuantity->quantity}}</td>
<td>{{$dataQuantity->price}}</td>
<td>{{$dataQuantity->branch_id}}</td>
<td style="width:100px;" class="td-actions"><a href="javascript:;" class="edit-modal btn btn-mini btn-info" data-id="{{$dataQuantity->id}}" ><i class="icon-plus"> </i> Add Stocks</a> </td>
</tr>  

@empty
<tr>
<td colspan="5"> <em>No Data</em></td>
</tr>

@endforelse

this {{$dataQuantity->branch_id}} should be displayed the name instead of the branch Id.. Please help.

Daniel H · Accepted Answer · 2018-03-18 15:34:24Z

1

I would say you need a relationship on your Productquantity model to your branch.

Something like

public function branch()
{
    $this->hasOne('App\Branch', 'branch_id');
}

and then you could do this:

$dataQuantity->branch->branch_name

answered Mar 18, 2018 at 15:34

Daniel H

964 bronze badges

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

Collectives™ on Stack Overflow

Display Data in Laravel Query from another table using model

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related