Here is an example to set order by on pagination http://arafats.info/cakephp-coditions-on-paginate/
Thanks Arafat On Mon, Sep 24, 2012 at 1:35 AM, lowpass <[email protected]> wrote: > Use SortableBehavior. Add a new column "order" to the table and sort on > that. > > https://github.com/sersilva/cakephp-sortable-behavior > > On Sat, Sep 22, 2012 at 10:48 AM, sathishbabu R <[email protected]> > wrote: > > Guys, > > > > Any Solution ?. > > > > > > On Sat, Sep 22, 2012 at 7:50 PM, sathishbabu R <[email protected]> > > wrote: > >> > >> Thanks, > >> > >> But I am not sure, We can do with cakephp pagination itself. > >> > >> > >> On Sat, Sep 22, 2012 at 7:32 PM, Tilen Majerle <[email protected] > > > >> wrote: > >>> > >>> you need than create your custom pagination process...cake's pagination > >>> system will not help you :) > >>> -- > >>> Lep pozdrav, Tilen Majerle > >>> http://majerle.eu > >>> > >>> > >>> > >>> 2012/9/22 sathishbabu R <[email protected]> > >>>> > >>>> Thanks for great answer, > >>>> > >>>> Customizing array format is not going to complex, But here, I want > >>>> pagination data based on my sorted list and its should be based on > paginate > >>>> limit, > >>>> > >>>> eg, > >>>> > >>>> if my paginate limit is 2, > >>>> > >>>> Then it should show at first page > >>>> > >>>> 7,1 based on my array format, > >>>> > >>>> and 2nd page, > >>>> > >>>> 3,2 > >>>> > >>>> and 3 rd page > >>>> 5. > >>>> > >>>> like that. > >>>> > >>>> > >>>> > >>>> On Sat, Sep 22, 2012 at 7:15 PM, Tilen Majerle < > [email protected]> > >>>> wrote: > >>>>> > >>>>> i hope i understand you good, but pagination is created for records > >>>>> from database..for ordering arrays and stuff like that use Set (in > new > >>>>> version is Hash) class from cake :) > >>>>> > >>>>> http://book.cakephp.org/2.0/en/core-utility-libraries/hash.html > >>>>> -- > >>>>> Lep pozdrav, Tilen Majerle > >>>>> http://majerle.eu > >>>>> > >>>>> > >>>>> > >>>>> 2012/9/22 Steve Babs <[email protected]> > >>>>>> > >>>>>> I am having array like, > >>>>>> > >>>>>> $mysort_array = array(7,1,3,2,5) . > >>>>>> > >>>>>> > >>>>>> I want pagination data order by above array value ordered. > >>>>>> > >>>>>> ex, > >>>>>> > >>>>>> 'order' => array('Table.id'=> $mysort_array). > >>>>>> > >>>>>> My pagination result should be ordered like below, > >>>>>> > >>>>>> Table.id => 7, > >>>>>> Table.id => 1, > >>>>>> Table.id => 3, > >>>>>> Table.id => 2, > >>>>>> Table.id => 5, > >>>>>> > >>>>>> > >>>>>> Order By Field only works in find query. Not in pagination, Please > >>>>>> guys help me to come out from this problem. > >>>>>> > >>>>>> > >>>>>> -- > >>>>>> Like Us on FacekBook https://www.facebook.com/CakePHP > >>>>>> Find us on Twitter http://twitter.com/CakePHP > >>>>>> > >>>>>> --- > >>>>>> You received this message because you are subscribed to the Google > >>>>>> Groups "CakePHP" group. > >>>>>> To post to this group, send email to [email protected]. > >>>>>> To unsubscribe from this group, send email to > >>>>>> [email protected]. > >>>>>> Visit this group at http://groups.google.com/group/cake-php?hl=en. > >>>>>> > >>>>>> > >>>>> > >>>>> > >>>>> -- > >>>>> Like Us on FacekBook https://www.facebook.com/CakePHP > >>>>> Find us on Twitter http://twitter.com/CakePHP > >>>>> > >>>>> --- > >>>>> You received this message because you are subscribed to the Google > >>>>> Groups "CakePHP" group. > >>>>> To post to this group, send email to [email protected]. > >>>>> To unsubscribe from this group, send email to > >>>>> [email protected]. > >>>>> Visit this group at http://groups.google.com/group/cake-php?hl=en. > >>>>> > >>>>> > >>>> > >>>> > >>>> > >>>> > >>>> -- > >>>> Regards, > >>>> > >>>> R. Sathishbabu > >>>> > >>>> > >>>> -- > >>>> Like Us on FacekBook https://www.facebook.com/CakePHP > >>>> Find us on Twitter http://twitter.com/CakePHP > >>>> > >>>> --- > >>>> You received this message because you are subscribed to the Google > >>>> Groups "CakePHP" group. > >>>> To post to this group, send email to [email protected]. > >>>> To unsubscribe from this group, send email to > >>>> [email protected]. > >>>> Visit this group at http://groups.google.com/group/cake-php?hl=en. > >>>> > >>>> > >>> > >>> > >>> -- > >>> Like Us on FacekBook https://www.facebook.com/CakePHP > >>> Find us on Twitter http://twitter.com/CakePHP > >>> > >>> --- > >>> You received this message because you are subscribed to the Google > Groups > >>> "CakePHP" group. > >>> To post to this group, send email to [email protected]. > >>> To unsubscribe from this group, send email to > >>> [email protected]. > >>> Visit this group at http://groups.google.com/group/cake-php?hl=en. > >>> > >>> > >> > >> > >> > >> > >> -- > >> Regards, > >> > >> R. Sathishbabu > >> > > > > > > > > -- > > Regards, > > > > R. Sathishbabu > > > > -- > > Like Us on FacekBook https://www.facebook.com/CakePHP > > Find us on Twitter http://twitter.com/CakePHP > > > > --- > > You received this message because you are subscribed to the Google Groups > > "CakePHP" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > Visit this group at http://groups.google.com/group/cake-php?hl=en. > > > > > > -- > Like Us on FacekBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > Visit this group at http://groups.google.com/group/cake-php?hl=en. > > > -- *Thanks & Regards. ----------------------------------------------------------------------------------------------------------------------------- Yasir Arafat (Hasib)* *Deputy Project Manager, *Software Solutions Grameen Solutions Contact Information: ** ** Cell : +8801816 536 901, +880197 *333* 2 888 Web: http://arafats.info <http://arafats.info> -- Like Us on FacekBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en.
