Thanks Joel!
I will try it.
On 10 abr, 00:32, Joel <[EMAIL PROTECTED]> wrote:
> The query:
>
> $records = $this->Author->findAll();
>
> will return nested associative arrays in the form:
>
> Array
> (
> [0] => Array
> (
> [Author] => Array
> (
> ...// Fields from the Author model
> )
> [Book] => Array
> (
> [0] => Array
> (
> .. // Fields from the Book model.
>
> [AuthorsBooks] => Array
> (
> ..// The join Model information
> )
>
> )
> [1] => Array
> (
> .. // Fields from the Book model.
>
> [AuthorsBooks] => Array
> (
> ..// The join Model information
> )
>
> )
> )
> )
> )
>
> etc.
>
> From the above structure (which you can view by calling
> debug($records) ), and the article I linked earlier on the
> Set::extract methods, you should be able to massage
> the data into whatever logical form you desire.
>
> Hope this helps.
>
> -Joel.
>
> On Apr 9, 11:31 am,inma<[EMAIL PROTECTED]> wrote:
>
>
>
> > Thanks for your replies!
>
> > martin, if you have this tables:
> > CREATE TABLE `authors` (
> > `id` int(11) NOT NULL auto_increment,
> > `name` varchar(255) NOT NULL
> > PRIMARY KEY (`id`)
> > );
>
> > CREATE TABLE `books` (
> > `id` int(11) NOT NULL auto_increment,
> > `name` varchar(255) NOT NULL,
> > `price` float(8,2) NOT NULL
> > PRIMARY KEY (`id`)
> > );
>
> > CREATE TABLE `authors_books` (
> > `id` int(11) NOT NULL auto_increment,
> > `author_id` int(11) NOT NULL,
> > `book_id` int(11) NOT NULL,
> > PRIMARY KEY (`id`)
> > );
>
> > And this relation:
>
> > class Author extends AppModel
> > {
> > var $name = 'Author';
> > var $hasAndBelongsToMany = array('Book');
>
> > }
>
> > class Book extends AppModel
> > {
> > var $name = 'Book';
> > var $hasAndBelongsToMany = array('Author');
>
> > }
>
> > How do you display a report with all authors and their books?
>
> > author.id || author.name || book.name || book.price
>
> > I know it is a basic question, but I don't know how to do it
> > correctly...
>
> > Thanks.
>
> > On 9 abr, 17:00, "[EMAIL PROTECTED]"
>
> > <[EMAIL PROTECTED]> wrote:
> > > The usual and unhelpful answer applies:
> > > You will have to rearrange your array-data yourself if you need it in
> > > that format.
>
> > > I would take another look at the javascript-component you are using...
> > > because I can't really figure out why it would require the data in
> > > that format. Repeating the user-data for each group sounds strange.
>
> > > So if you really want to rearrange the data I would prefer to do it in
> > > the User Model. You could create a method called "getUsersForExtJS()"
> > > or something and in that method you do the actual findAll and some
> > > data-manipulation before returning the data to the controller.
>
> > > I would not use afterFind in this case since I really think it is only
> > > something you want to do for some specific JS-component and not every
> > > time you find a user.
>
> > > On Apr 9, 4:28 pm,inma<[EMAIL PROTECTED]> wrote:
>
> > > > Hi,
>
> > > > I have an User class and a PermissionGroup class. User has defined a
> > > > hasAndBelongsToMany relation with PermissionGroup.
>
> > > > If into database exists one user with two permission grups assigned,
> > > > when I run this code:
>
> > > > $userA = $this->User->findAll($sort, $limit, $page); //gets all the
> > > > User records and sorts them.
>
> > > > It returns an array that contains the user data array and the
> > > > permission groups array:
>
> > > > Array(
> > > > [User] => Array(
> > > > here the user data
> > > > )
> > > > [PermissionGroup] => Array(
> > > > [0] => Array(
> > > > here the FIRST permission data
> > > > )
> > > > [1] => Array(
> > > > here the SECOND permission data
> > > > )
> > > > )
> > > > )
>
> > > > I turn it into a json format because I use ExtJS library into the
> > > > views:
>
> > > > {"total":1, "users":[{"User":{ here the user data },
> > > > "PermissionGroup":
> > > > [{ here the first permission data }, { here the second permission
> > > > data }]}]}
>
> > > > But I need an array for each permission group assigned to user. Like
> > > > this:
>
> > > > Array(
> > > > [User] => Array(
> > > > here the user data
> > > > )
> > > > [PermissionGroup] => Array(
> > > > [0] => Array(
> > > > here the FIRST permission data
> > > > )
> > > > )
> > > > ),
> > > > Array(
> > > > [User] => Array(
> > > > here the user data
> > > > )
> > > > [PermissionGroup] => Array(
> > > > [0] => Array(
> > > > here the SECOND permission data
> > > > )
> > > > )
> > > > )
>
> > > > Turned into json format:
>
> > > > {"total":2,
> > > > "users":[{"User":{ here the user data }, "PermissionGroup":{ here the
> > > > FIRST permission data }},
> > > > {"User":{ here the user data }, "PermissionGroup":{ here the SECOND
> > > > permission data }}
> > > > ]}
>
> > > > ¿How can I do it?
>
> > > > Thanks in advance!
>
> > > > P.S: ( I have asked this questions a few hours ago, but it doesn't
> > > > appear. So I have repeated it...)- Ocultar texto de la cita -
>
> > > - Mostrar texto de la cita -- Ocultar texto de la cita -
>
> - Mostrar texto de la cita -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
