Hi, I have a model which transaction record per month. Underlying database is MySQL with DDL sql as below
CREATE TABLE `estimations` ( `id` int(11) NOT NULL auto_increment, `customer_id` varchar(200) NOT NULL, `item_id` varchar(200) NOT NULL, `amount` int(11) NOT NULL, `month` tinyint(4) NOT NULL, `year` int(11) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `customer_id` (`customer_id`,`item_id`,`month`,`year`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; Question is.. Is it possible to display 'analysis' report data with CakePHP pagination ? The output will somehow looks like this. ------------------------------------------------------------------------------------------------------ Customer | Item | Jan 2007 Est | Feb 2007 Est | Mar 2007 Est | |----------------------------------------------------------------------------------------------------| | XXXXXXX | XXXX | 999999 | 999999 | 999999 | | XXXXXXX | XXXX | 999999 | 999999 | 999999 | | XXXXXXX | XXXX | 999999 | 999999 | 999999 | ------------------------------------------------------------------------------------------------------ Regards, Feris --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
