Query builder fetch data in cakephp 3.2

Question

I am using this below code to sum up all my wallet balance .

$query = $this->Wallets->find();
$query->select([
    'count' => $query->func()->count('id'), 
    'total_price' => $query->func()->sum('amount')
])
->where(['status' => 4, 'user_id' => $user_id]);
pj($query);
echo $query->total_price;
exit;

out put of pj($query);

[
    {
        "count": 2,
        "total_price": 700
    }
]

Here i have tried to get single individual value using below query

echo $query->total_price;

I am not getting it. What is the proper syntax ,plz suggest me. Thanx.

arilia · Answer 1 · 2016-05-17T07:43:16.490

5

add first() to your query, see the manual

$query->select([
    'count' => $query->func()->count('id'), 
    'total_price' => $query->func()->sum('amount')
])
->where(['status' => 4, 'user_id' => $user_id]);

$wallet = $query->first();

debug($wallet);

debug($wallet->total_price);

edited May 17 '16 at 07:43

answered May 17 '16 at 06:39

arilia

9,373
2
20
44

Not getting the result. – sradha May 17 '16 at 06:48
Add more information: what do you get? What query is generated? what you get when you `debug($query)`? – arilia May 17 '16 at 07:05
Yes degug($query) returning result ,but debug($query->total_price) ,this one throwing error.i am not getting the single individual value. – sradha May 17 '16 at 07:15

Salines · Accepted Answer · 2016-05-17T08:03:14.680

1

$query = $this->Wallets->find();
$query->select([
    'count' => $query->func()->count('id'), 
    'total_price' => $query->func()->sum('amount')
])
->where(['status' => 4, 'user_id' => $user_id]);
debug($query);

// loop your results
foreach($query as $result){
   echo $result->total_price;
}

// or
$query->toArray();
echo $query[0]->total_price;
echo $query[1]->total_price;
...
exit;

edited May 17 '16 at 08:03

answered May 17 '16 at 07:29

Salines

5,674
3
25
50

Yes the foreach one is working ,i am getting exact result . Second one not working (answer in or). – sradha May 17 '16 at 07:43
Ok .thank you ,i got my answer. Thank you for your help. – sradha May 17 '16 at 07:43

Query builder fetch data in cakephp 3.2

2 Answers2

Linked