Myujth

My two table Member and Deposit there has one to many relationship one member has multiple deposit in Deposit table i want to display last record of deposit table when i call all Member or a single Member.

This is my Member Table

1.id,
2.name,
3.phone,
4.account_no,
5.ac_open_date,
6.ac_close_date,
7.status,
8........

My Deposit Table

1.meber_id,
2.deposit_date,
3.deposit_amount,
4.total_amount,
5..........

My Controller Code

$member = Member::with(['Deposit'=>function($query)$query->select('*')->latest('deposit_date')->limit(1);])->where('status','ready')->get();

if i return $member variable then show my aspect data ok. but when i show this in my blade file this way ...

blade section

<td> $member->name </td>
 <td> $member->account_no </td>
 <td> $member->phone </td>
<td> $member->deposit->total_amount</td>

when i call the Deposit model to display to deposit table last row records then show the error.

"Property [total_amount] does not exist on this collection instance. (View: C:xampphtdocs........

what can i do .please help me anyone.

Try $member->deposit->first()->total_amount.

$member->deposit returns a collection of all deposits of the member, even if there is only one.

I understand that you update the total_amount for every transaction for a member with the total Deposits till now, if so, I suggest to add new attribute for the Member table and save this value on it, so you can get it easily, and you can update it when needed.