CODEWITHSUNDEEP
cakephpcakephp-3.0
Satu Sultana
Satu Sultana

Reputation: 537

Cakephp 3 : Sum a single field without using foreach

I am using cakephp 3. Here I need sum a field, I already done it. 

//mobile recharge total balance
$user_balance = $this->Users->find();
$user_balance
->select(['sum' => $user_balance->func()->sum('Users.balance')])
->first();
foreach ($user_balance as $balance) {
    $this->set("user_balance", $balance->sum);
}

Here I have used first(), but why still it's returning an object. Is it possible to get direct sum or array. Here I don't want to use foreach.

Upvotes: 4

Views: 2292

Answers (1)

sradha
sradha

Reputation: 2244

$query = $this->Models->find('all'); //fetch the record

$res = $query->select(['total_sum' =>$query->func()->sum('the_field_you_need')])->first(); //perform the sum operation 
$total = $res->total_sum; your total sum result

$user_balance = $this->Users->find();
$res =$user_balance->select(['sum' => $user_balance->func()->sum('Users.balance')])->first();
$total = $res->sum; //your total sum result

Upvotes: 8

Related Questions