It's real code - try it! So is Category->findAllById(). Cakey
automagic goodness!
They're nice shortcuts, but they do make it difficult to set other
options, like order, recursive, and whatnot.
On Oct 18, 11:06 am, BoSc <[EMAIL PROTECTED]> wrote:
> Btw.... is the findAllByAuthorId intented to be pseudo-code, or is
> this really possible in CakePHP?
>
> On Oct 18, 11:55 am, grigri <[EMAIL PROTECTED]> wrote:
>
> > I'm not 100% sure of the "official" way of doing this, but I'd do it
> > by putting a specialized search function in the model. Which model is
> > up to you - a bit of a grey area. I've written a quick (untested!)
> > example, in which I've put it in the Author class. Depending on other
> > stuff, it might make more sense for you to have a
> > "findAllCategorizedByAuthor" function in the Book model, or something.
> > Anyway:
>
> > class Author extends AppModel {
> > var $name = "Author";
>
> > var $hasMany = array(
> > 'Book'
> > );
>
> > function findCategorizedBooks($author_id) {
> > // First get all the books
> > // Order them by whatever you like, add extra conditions, ...
> > // Set recursive to -1 - we'll get the categories later
> > $books = $this->Book->findAllByAuthorId($author_id);
>
> > // Build a lookup table of category ids to book indices
> > $catLUT = array();
> > foreach ($books as $bookIdx => $book) {
> > $catId = $book['Book']['category_id'];
> > if (!isset($catLUT[$catId])) {
> > $catLUT[$catId] = array();
> > }
>
> > array_push($catLUT[$catId], $bookIdx);
> > }
> > // Grab the IDs for the findAll
> > $catIds = array_keys($catLUT);
>
> > // Find all the relevant categories
> > // Again, set recursive to -1 because we've already for the books
> > and the author
> > // Order by whatever you like, add extra conditions, bla bla woof
> > woof
> > $cats = $this->Book->Category->findAllById($catIds);
>
> > // Now loop through the category list and append the books
> > foreach ($cats as $catIdx => $cat) {
> > $cats[$catIdx]['Book'] = array();
> > foreach ($catLUT[$cat['Category']['id']] as $bookIdx) {
> > array_push($cats[$catIdx]['Book'], $books[$bookIdx]['Book']);
> > }
> > }
>
> > // We're done
> > return $cats;
> > }
>
> > }
>
> > Like I said, not tested, but I have written similar code before on a
> > cake project of mine - the concept is sound.
> > (Formatted a bit better here:http://openpaste.org/en/3506/)
>
> > On Oct 18, 10:06 am, BoSc <[EMAIL PROTECTED]> wrote:
>
> > > Hi,
>
> > > I've got 3 tables with a 1:n relationship:
>
> > > - author (has many books)
> > > ^
> > > |
> > > |
> > > V
> > > - books (belongs to categories) (has many authors)
>
> > > |
> > > |
> > > V
>
> > > - categories (has many books)
>
> > > What I would like to do on one page, is show a categorized view of all
> > > books by a specific author. The problem lies in the fact that each
> > > category and each book also has some kind of sorting involved, which
> > > states at what place in a category a book should be shown...
>
> > > >From which Point of View should I query this, and am I able to
>
> > > implement this in 1 query?
>
> > > What I would like to end up with is the following array
>
> > > array
> > > category 2
> > > book 1
> > > name
> > > blabla
> > > book 3
> > > name
> > > blabla
> > > book 2
> > > name
> > > blabla
> > > category 1
> > > book 4
> > > name
> > > blabla
> > > book 6
> > > name
> > > blabla
> > > book 5
> > > name
> > > blabla
>
> > > The problem is, when I use findAll on Category, I'm not able to choose
> > > how Cake should order the Books. Any workarounds?
>
> > > Thanks
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
