Re: Filtering/Searching/Sorting
I did a similar filter form, although not with pagination. For drop downs, I made the form with the field names as they would be in an edit form, then in the controller, I check if the form was submitted, and put the conditions in the where clause of the call to findAll()... For text matches i checked if any search words were submitted, and added an SQL LIKE clause for that. This way, if the form wasnt' submitted, you do a normal findAlll with no conditions, otherwise you filter. It was something like that anyway, it was a while ago...It was pretty easy. I hope that gives you some inspiration! On May 25, 1:33 pm, phpsmitty <[EMAIL PROTECTED]> wrote: > AD i downloaded and started working with the pagination class. Do you > think there is a way to mod it to give me a a search box at the top. > I'm looking for something like: > > Drop Down Box Of Fields | Drop Down of Operators | Text box for search > critera | Search Button > > --Bryan > > On May 9, 4:04 am, AD7six <[EMAIL PROTECTED]> wrote: > > > On 30 abr, 18:47, phpsmitty <[EMAIL PROTECTED]> wrote: > > > > This is similar functionality that the masterbake.php file can bake up > > > but the code it produces is very messy. Seams like a couple include > > > files should be able to dynamically generate this functionality > > > automatically. > > > Hi, > > > You can download and pick through a few examples of filtering and > > sorting data using the 1.1paginationcomponent/helper > > here:http://cakeforge.org/frs/?group_id=152 > > > hth, > > > AD --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Filtering/Searching/Sorting
AD i downloaded and started working with the pagination class. Do you think there is a way to mod it to give me a a search box at the top. I'm looking for something like: Drop Down Box Of Fields | Drop Down of Operators | Text box for search critera | Search Button --Bryan On May 9, 4:04 am, AD7six <[EMAIL PROTECTED]> wrote: > On 30 abr, 18:47, phpsmitty <[EMAIL PROTECTED]> wrote: > > > This is similar functionality that the masterbake.php file can bake up > > but the code it produces is very messy. Seams like a couple include > > files should be able to dynamically generate this functionality > > automatically. > > Hi, > > You can download and pick through a few examples of filtering and > sorting data using the 1.1paginationcomponent/helper > here:http://cakeforge.org/frs/?group_id=152 > > hth, > > AD --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Filtering/Searching/Sorting
Of course and in case you didn't know, 1.2 has native pagination support. filtering is a matter of setting a search criteria. On May 9, 8:04 am, AD7six <[EMAIL PROTECTED]> wrote: > On 30 abr, 18:47, phpsmitty <[EMAIL PROTECTED]> wrote: > > > This is similar functionality that the masterbake.php file can bake up > > but the code it produces is very messy. Seams like a couple include > > files should be able to dynamically generate this functionality > > automatically. > > Hi, > > You can download and pick through a few examples of filtering and > sorting data using the 1.1 pagination component/helper > here:http://cakeforge.org/frs/?group_id=152 > > hth, > > AD --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Filtering/Searching/Sorting
On 30 abr, 18:47, phpsmitty <[EMAIL PROTECTED]> wrote: > This is similar functionality that the masterbake.php file can bake up > but the code it produces is very messy. Seams like a couple include > files should be able to dynamically generate this functionality > automatically. Hi, You can download and pick through a few examples of filtering and sorting data using the 1.1 pagination component/helper here: http://cakeforge.org/frs/?group_id=152 hth, AD --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Filtering/Searching/Sorting
This is similar functionality that the masterbake.php file can bake up but the code it produces is very messy. Seams like a couple include files should be able to dynamically generate this functionality automatically. On Apr 27, 3:35 am, "Jon Bennett" <[EMAIL PROTECTED]> wrote: > > Sorting: > > > Use the AjaxHelper::sortable helper > > Think this uses the scriptaculous sortable library?? > > nope, this won?t do what you?re after, that?s for sortable lists (pick > up and change order of items). > I think you want to be looking at the Pagination > component,http://bakery.cakephp.org/articles/view/paginationshould get you > started. > > cheers, > > Jon > > > > > Filtering - not too sure what you mean by this, but maybe > > NeatArray::filter, which filters data from an array > > > Winston > > -- > > jon bennett > t: +44 (0) 1225 341 039 w:http://www.jben.net/ > iChat (AIM): jbendotnet Skype: jon-bennett --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Filtering/Searching/Sorting
More or less I'd like to be able to sort my vaiours columns and be able to search through them. If you have 1000 entries it becomes cumbersome to find items you'd like to edit. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Filtering/Searching/Sorting
> Sorting: > > Use the AjaxHelper::sortable helper > Think this uses the scriptaculous sortable library?? nope, this won�t do what you�re after, that�s for sortable lists (pick up and change order of items). I think you want to be looking at the Pagination component, http://bakery.cakephp.org/articles/view/pagination should get you started. cheers, Jon > > Filtering - not too sure what you mean by this, but maybe > NeatArray::filter, which filters data from an array > > Winston > > > > > -- jon bennett t: +44 (0) 1225 341 039 w: http://www.jben.net/ iChat (AIM): jbendotnet Skype: jon-bennett --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Filtering/Searching/Sorting
Sorting: Use the AjaxHelper::sortable helper Think this uses the scriptaculous sortable library?? Filtering - not too sure what you mean by this, but maybe NeatArray::filter, which filters data from an array Winston --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Filtering/Searching/Sorting
Hi, I'm pretty new to Cake PHP. I am making my first app and have a few tables with crud functionality. I'm looking to add clickable column titles that will allow me to sort the columns. I'm also looking for something similar to symfony's filter functionality found on this pagehttp://www.symfony-project.com/book/trunk/14-Generators#Administration this would allow me to find records in a long list of entries. If anyone has any pointers I would appreciate the help. Thanks, Smitty --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---