Note that you're fields will not be under 'UsersBook' in the array
because you're using DATE_FORMAT and COUNT. Do a debug() on the result
to see what I mean.
On Fri, Apr 24, 2009 at 2:48 PM, harpax <apsczo...@googlemail.com> wrote:
>
> Hi,
>
> The following should do the job:
>
> [..]
> // for the controller
> $params['fields'] = array(
> 'DATE_FORMAT(created, '%d.%m.%Y') AS sdate',
> 'COUNT(savedtime) AS saved',
> 'COUNT(encashedtime) AS encashed');
> $params['conditions'] = array(
> 'voucher_id' => array(8, 124, 120),
> 'created <= NOW()',
> 'DATE_SUB(NOW(), INTERVAL 30 DAY)'
> );
> $params['order'] = 'sdate';
> $params['group'] = 'sdate';
> $res = $this->UsersBook->find('all', $params);
> [..]
>
> Hope that helps,
> harpax
>
>
> On 24 Apr., 16:28, voocake <vooc...@gmail.com> wrote:
>> Hello,
>>
>> I have nice SQL query which makes most of the work for me, but i have
>> no plan how to convert it to a cakephp conform condition array. I'm
>> aware of the possibility to make a custom query, but i'm trying to
>> avoid this.
>>
>> May someone can help me with this?
>>
>> Here is the statement:
>>
>> SELECT DATE_FORMAT(created, '%d.%m.%Y') AS sdate, COUNT(savedtime) AS
>> saved , COUNT(encashedtime) AS encashed FROM users_books WHERE
>> voucher_id IN (8, 124, 120)
>> AND created <= NOW()
>> AND DATE_SUB(NOW(), INTERVAL 30 DAY)
>> GROUP BY sdate
>> ORDER BY sdate
>>
>> Thx
>> voocake
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
