cakePHP query using find() method

Question

how can I convert this query to use cakePHP's method find() ?

query:

SELECT Ch.id, COUNT( DU.d_id ) AS a, SUM(DU.d_id) AS b
FROM c AS Ch
LEFT JOIN du AS DU ON DU.c_id = Ch.id AND MONTH( DU.created ) = MONTH( NOW( ) )
LEFT JOIN d AS D ON DU.d_id = D.id
GROUP BY Ch.id

Raisen · Accepted Answer · 2011-04-12 07:13:59Z

1

$Ch->find(
    'all',      
    'fields' => array(
               'Ch.id','COUNT( DU.d_id ) AS a', 'SUM(DU.d_id) AS b'),
    'joins'  => array(
                      array(
                            'table' => 'du',
                            'alias' => 'DU',
                            'type' => 'LEFT',
                            'conditions' => array('DU.c_id = Ch.id AND MONTH( DU.created ) = MONTH( NOW( )')),
                       array(
                            'table' => 'd',
                            'alias' => 'D',
                            'type' => 'LEFT',
                            'conditions' => array('DU.c_id = Ch.id AND MONTH( DU.created ) = MONTH( NOW( )')),
    'group' => 'Ch.id');

I haven't tested. More info on Cake JOINs:

http://book.cakephp.org/view/1018/find

answered Apr 12, 2011 at 7:13

Raisen

4,4952 gold badges29 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

cakePHP query using find() method

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related