Level 88
You can use the collection you get back from Laravel
$sum = $user->charges->sum('amount');
Documentation: https://laravel.com/docs/5.2/collections#method-sum
Jun 29, 2016
4
Level 3
ForEach on Collection from Model returns empty
Hiya all, once again with probably a newbie question lol. I'd appreciate your help. I have some users that are making payments into Stripe and I am storing the amounts they are paying in a table. I have a relationship of User::hasmany, and UserPaymphpent::belongsto. So when I have
public function charges(){
return $this->hasMany('App\UserPayment');
}
I get a collection of payments done by that Use. Now I need to iterate through each payment and sum up all the amounts they payed. When I just simply return the collection I get on blade the following:
[{"id":1,"member_id":"44","stripe_id":"cus_00000000000000","email":"[email protected]","amount":50000,"amount_decimal":0,"amount_refunded":0,"invoice_number":null,"date_created":1326853478,"created_at":"2016-06-28 20:12:35","updated_at":"2016-06-28 20:12:35"},{"id":2,"member_id":"44","stripe_id":"cus_00000000000000","email":"[email protected]","amount":50000,"amount_decimal":0,"amount_refunded":0,"invoice_number":null,"date_created":1326853478,"created_at":"2016-06-28 20:12:35","updated_at":"2016-06-28 20:12:35"},{"id":3,"member_id":"44","stripe_id":"cus_8iuCeLKHZGxWQD","email":"[email protected]","amount":50000,"amount_decimal":0,"amount_refunded":0,"invoice_number":null,"date_created":1467144078,"created_at":"2016-06-28 21:10:19","updated_at":"2016-06-28 21:10:19"}]
So I thought I could do foreach and just += each $payment->amount. But the for each is not going through them. Just returns blank, even If I just simply do inside the foreach($payments as $pay){echo "one payment";} I get blank. So I tried json_decode on the $payments collection and I get:
json_decode() expects parameter 1 to be string, object given How can I iterate through each payment and sum up the amounts? Thank you in advance.
Level 3
And here I am trying to complicate myself by doing a foreach, I still don't understand why it wont let me Iterate through each but this solves my problem thank you @bobbybouwmann. So now if I try to do money_format on the sum I get Call to undefined function App\money_format().
Level 88
What are you trying to do? Show us your code!
I guess you need to read this first: http://php.net/manual/en/function.money-format.php
Level 3
Hi @bobbybouwmann I just ended up using {{number_format($member->invested(),2)}} on my blade template. Seems to work. Thank you.
Please or to participate in this conversation.