Can anyone help me how to display the product name? I have productquantity stored in my purchase record and now I want to display the product name in productquantity record.
I have 3 Tables
Purchaserecord - id - purchasenumber - prodquantityid
Productquantities - id - prod_id
Product - id - productname
I have this in my controller
public function createpurchase(Request $request)
{
$purchasenumber = $request->purchasenumber;
$dataPurchaseRecord = Purchaserecord::where('purchasenumber','=',$purchasenumber)->with('productquantity')->get();
return view('admin.createpurchase',compact('purchasenumber', 'dataPurchaseRecord'));
}
In my view
@forelse($dataPurchaseRecord as $Request)
<tr>
<td> <a class="name"></a></td>
<td><em class="productprice"></em> </td>
<td style="width:100px;" class="td-actions"><a href="javascript:;" class="delete-modal btn btn-mini btn-danger" data-id="" ><i class="icon-minus"> </i>Remove</a> </td>
</tr>
@empty
<tr><td colspan='4'><em>No Data</em></td></tr>
@endforelse
in my model
public function product()
{
return $this->belongsTO('App\Product', 'prodquantityid', 'id');
}
this should be display the product name instead of the id How can I build the model and view on this? Please help.
Thank you
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire