Thanks a bunch Grigri, I guess dynamic binding was the clue I needed.
The cookie methaphore I used was of course meant for the sake of
simplicity, I can see you don't see more sense in using hasMany
relations, but in my real world situation I do need HABTM relations,
since it's a pretty complex structure.
Big up.
On 26 okt, 17:44, grigri <[EMAIL PROTECTED]> wrote:
> I can see what you want to achieve, but in your specific example it
> doesn't make sense.
>
> Each baker has MANY cookies associated with him, so you can't sort by
> a list; only by a 1:1 field.
>
> So you don't want to sort the bakers by the rate of their baked
> cookies - you need to be much more specific.
>
> How about sorting the bakers by the rate of their personal best? Or by
> their personal worst? Or some other, more complicated metric (mean
> average for example)
>
> As you can see, you need to create a 1-to-1 relationship between Baker
> and Cookie, dynamically bind on it, and perform the sort on that
> cookie's rating.
>
> If you have Baker hasMany Cookie, you'd do it like this (I know you've
> got a HABTM, but this is easier to explain - HABTM is similar but more
> long-winded)
>
> $this->Bakery->Baker->bindModel(array('hasOne' => array('BestCookie'
> => array('className' => 'cookie', 'order' => 'BestCookie.rating
> DESC'))));
> $this->Bakery->hasMany['Baker']['order'] = 'BestCookie.rating DESC';
> $bakeries = $this->Bakery->findAll(...);
>
> (The order clause in the hasOne binding specifies the best cookie -
> use ASC for the worst. The second order clause is what order the
> bakers appear in - here I've done best to worst - use ASC for worst to
> best)
>
> On Oct 26, 2:22 pm, David Spreekmeester <[EMAIL PROTECTED]>
> wrote:
>
> > Thanks for replying, Paul. So I seem not to be the only one, do none
> > of the gurus here have a clue how to do this in a tidy efficient way
> > without sorting afterwards?
>
> > On Oct 26, 3:04 am, "Paul Webster" <[EMAIL PROTECTED]> wrote:
>
> > > I tried to do something very similar not so long ago, and too had trouble
> > > getting it to do as I wanted.
>
> > > In the end not having time to pursue it further I did just sort after the
> > > query was made, as far as I could tell due to the way habtm's are querried
> > > it wasn't a simple case of altering the association settings etc.
>
> > > I'd be interested to see if anyone has some clear thoughts on this too.
>
> > > -----Original Message-----
> > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
>
> > > Of David Spreekmeester
> > > Sent: Friday, 26 October 2007 9:02 a.m.
> > > To: Cake PHP
> > > Subject: ordering a model through related model order
>
> > > Hey there bakers.
>
> > > I couldn't find an appropriate answer to this anywhere. Suppose I have
> > > three models:
>
> > > Bakery <- hasAndBelongsToMany -> Baker <- hasAndBelongsToMany ->
> > > Cookie
>
> > > Suppose there is a cookie baking contest going on. Every cookie is
> > > rated for quality (int Cookie.quality). I would like to do a find()
> > > for a certain bakery, and then *sort the employed bakers there by the
> > > rate of their baked cookies*. I tried stuff like setting the 'order'
> > > property to 'Cookie.quality' in the Cookie model file, but of course
> > > that just orders the cookies, and doesn't sort the bakers. The same
> > > goes for setting 'Cookie.quality' as the sorting parameter in the
> > > find() call.
>
> > > Of course I could just sort the bakers afterwards with my own custom
> > > sort function, but is there a way to do this automagically?
>
> > > __________ NOD32 2617 (20071025) Information __________
>
> > > This message was checked by NOD32 antivirus system.http://www.eset.com
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
