php.activerecord

Subject: [RESOLVED] Zend Framework Models and Relationships

Okay so this isn't really working the way I expected. I want a linking table to give me a many-to-many relationship between orgs and users through the orgs_users table.

UPDATE: I just edited my code to autoload the models in Zend without the typical Zend path names included in the model name. The models are loading fine, but I'm just getting NULL when I instantiate the Orgs model and try to call its $orgs->users.

class Orgs extends ActiveRecord\Model {
    static $table_name = 'orgs';
    static $primary_key = 'org_id';
    static $has_many = array(
        array(
            'orgs_users', 
            'class_name' => 'OrgsUsers',
            'primary_key' => 'org_id'  <--- not sure about this?
        ),
        array(
            'users', 
            'through' => 'orgs_users', 
            'class_name' => 'Users',
            'primary_key' => 'user_id'
        )
    );
}

class Users extends ActiveRecord\Model {
    static $table_name = 'users';
    static $primary_key = 'user_id';
    static $has_many = array(
        array(
            'orgs_users', 
            'class_name' => 'OrgsUsers',
            'primary_key' => 'user_id'  <----- not sure about this?
        ),
        array(
            'orgs', 
            'through' => 'orgs_users', 
            'class_name' => 'Orgs',
            'primary_key' => 'org_id'
        )
    );
}

class OrgsUsers extends ActiveRecord\Model {
    static $table_name = 'orgs_users';
    static $primary_key = 'orgs_users_id';
   static $belongs_to = array(
        array(
            'orgs', 
            'class_name' => 'Orgs',
            'primary_key' => 'org_id'
        ),
        array(
            'users', 
            'class_name' => 'Users',
            'primary_key' => 'user_id'
        )
    );
}

So, in ZF, I should be able to call the orgs model and have an array of all of the users for that org; but, alas, no joy, just a NULL. Any help on this would be appreciated. :)

-Beau