Complex model relationship problems

[Dan Soendergaard]

Hi bakers!

In my application I've got the concept of "Spaces" which are basically
directories. I also have User and Document models.

Space -> HABTM <- User (a user may have access to several spaces)
Space -> hasMany -> Document
Document -> HABTM <- User (a document can have several owners)

The HABTM relationships are set up according to the solution shown
here: 
http://www.cricava.com/blogs/index.php?blog=6&title=modelizing_habtm_join_tables_in_cakephp_&more=1&c=1&tb=1&pb=1

Space uses the Tree behavior and the spaces table is properly
configured to use it (lft, rght and parent_id columns). A Space
contains Documents, and both Space and Document can be created by a
User.

I've been trying for two days to try figuring out how to do this:

    1. Get a tree of all rooms and documents that a specific user is
associated with
    2. Do the same, but only for a sub-tree

This seems impossible to do because Cake thinks that it should look
for parent_id, lft, and rght in the table spaces_users when using the
following query:

$spaces = $this->SpacesUser->find('threaded', array(
                'conditions' => array('User.id' => $user),
                'contain' => array(
                        'User.id', 'User.username',
                        'Space.name', 'Space.description', 'Space.created',
                        'Space.parent_id', 'Space.lft', 'Space.rght',
                        'Document'
                ),
                'order' => array('Space.name')
        )
);

On the other hand, this is the only way I can think of that allows me
to get the spaces associated with the user. Cake gives the following
errors:

Model "SpacesUser" is not associated with model "Document" [CORE/cake/
libs/model/behaviors/containable.php, line 340]

Undefined index:  parent_id [CORE/cake/libs/model/model.php, line
2163]

Note that when setting find('threaded'), the tree is not properly
built. Cake still returns a flat list.

Here are my models:

<?php
class Space extends AppModel {

        var $name = 'Space';

        var $actsAs = array('Tree');

        var $hasAndBelongsToMany = array(
                'User' => array(
                        'with' => 'SpacesUser'
                )
        );

        var $hasMany = array(
                'Document'
        );

        function get_structure($user = null) {
                $spaces = $this->SpacesUser->find('threaded', array(
                                'conditions' => array('User.id' => $user),
                                'contain' => array(
                                        'User.id', 'User.username',
                                        'Space.name', 'Space.description', 
'Space.created',
                                        'Space.parent_id', 'Space.lft', 
'Space.rght',
                                        'Document'
                                ),
                                'order' => array('Space.name')
                        )
                );

                return array('spaces' => $spaces);
        }

}
?>

<?php
class User extends AppModel {

        var $name = 'User';

        var $hasAndBelongsToMany = array(
                'Space' => array(
                        'with' => 'SpacesUser'
                ),
                'Document' => array(
                        'with' => 'DocumentsUser'
                )
        );

}
?>

<?php
class Document extends AppModel {

        var $name = 'Document';
        var $hasAndBelongsToMany = array(
                'User' => array(
                        'with' => 'DocumentsUser'
                )
        );

}
?>

<?php
class SpacesUser extends AppModel {

        var $name = 'SpacesUser';
        var $belongsTo = array('Space', 'User');

}
?>

<?php
class DocumentsUser extends AppModel {

        var $name = 'DocumentsUser';
        var $belongsTo = array('Document', 'User');

}
?>

<?php
class SpacesController extends AppController {

        var $name = 'Spaces';
        var $helpers = array('Html', 'Form', 'Time', 'Text');
        var $components = array('RequestHandler');

        var $paginate = array(
                'order' => array('Space.name' => 'asc')
        );

        function index() {
                $this->set('spaces', $this->Space->get_structure(7));
        }

}
?>

I hope that someone will be able to help :) Thanks in advance!

- Dan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to 
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---