Build An Sql With Criteria

Yii 1.1 General Discussion
1

Could someone help me to build this sql with criteria

select D.category, D.account, D.officeID, D.id, D.dateReceived, D.amount,D.receivedBy, D.type, D.comment, sum(P.amount)as sumPaid from tblDeposit D, tblPaid P where D.dateReceived <="2009-12-31" and D.category="C" and D.id=P.receiptNo group by P.receiptNo order by D.dateReceived;

2

try this





$dataProvider = new CActiveDataProvider('Deposit', array(

    	'criteria'=>array(

        	'alias' => 'D',

        	'select' => 'D.category, D.account, D.officeID, D.id, D.dateReceived, D.amount,D.receivedBy, D.type, D.comment',

        	'with'=>array(

            	'Paid' => array(

                	'alias'=>'P',

                	'select' => 'sum(P.amount) as sumPaid',

                	)

            	),

        	'condition'=>'D.dateReceived <= 2009-12-31 AND D.category="C" AND D.id=P.receiptNo',

        	'group'=>'P.receiptNo',

        	'order'=>'D.dateReceived'

    	),

	));