Reputation: 10790

Cakephp Containable not attaching to Model

I've used containable tons of times but I can not figure for the life of me why it is not working correctly now.

I have 3 models Project, User, and Country.

Project belongsTo User User belongsTo Country

here is the models

<?php
class User extends AppModel {
    var $name = 'User';
    var $displayField = 'username';
    var $belongsTo = array(
        'AccountType' => array(
            'className' => 'AccountType',
            'foreignKey' => 'account_type_id',
            'conditions' => '',
            'fields' => '',
            'order' => ''
        ),
        'PaymentType' => array(
            'className' => 'PaymentType',
            'foreignKey' => 'payment_type_id',
            'conditions' => '',
            'fields' => '',
            'order' => ''
        ),
        'Country' => array(
            'className' => 'Country',
            'foreignKey' => 'country_id',
            'conditions' => '',
            'fields' => '',
            'order' => ''
        ),
        'InstantMessenger' => array(
            'className' => 'InstantMessenger',
            'foreignKey' => 'instant_messenger_id',
            'conditions' => '',
            'fields' => '',
            'order' => ''
        ),
        'TimeZone' => array(
            'className' => 'TimeZone',
            'foreignKey' => 'time_zone_id',
            'conditions' => '',
            'fields' => '',
            'order' => ''
        ),
        'Language' => array(
            'className' => 'Language',
            'foreignKey' => 'language_id',
            'conditions' => '',
            'fields' => '',
            'order' => ''
        ),
    );
}


<?php
class Project extends AppModel {
    var $name = 'Project';
    var $displayField = 'project_title';

    var $belongsTo = array(
            'User' => array(
                    'className' => 'User',
                    'conditions' => '',
                    'fields' => '',
                    'order' => ''
            ),
            'ProjectType' => array(
                    'className' => 'ProjectType',
                    'foreignKey' => 'project_type_id',
                    'conditions' => '',
                    'fields' => '',
                    'order' => ''
            ),
            'BiddingType' => array(
                    'className' => 'BiddingType',
                    'foreignKey' => 'bidding_type_id',
                    'conditions' => '',
                    'fields' => '',
                    'order' => ''
            ),
            'ProjectStatus' => array(
                    'className' => 'ProjectStatus',
                    'foreignKey' => 'project_status',
                    'conditions' => '',
                    'fields' => '',
                    'order' => ''
            ),
            'EmploymentType',
            'PaymentType',
    );
}



<?php
class Country extends AppModel {
    var $name = 'Country';
    var $displayField = 'name';
    //The Associations below have been created with all possible keys, those that are not needed can be removed

    var $hasMany = array(
        'User' => array(
            'className' => 'User',
            'foreignKey' => 'country_id',
            'dependent' => false,
            'conditions' => '',
            'fields' => '',
            'order' => '',
            'limit' => '',
            'offset' => '',
            'exclusive' => '',
            'finderQuery' => '',
            'counterQuery' => ''
        )
    );

}

Now here is my code to try to attach a containable to project and add User

function smartbid($projid = null)
{
    $this->loadModel('Content');
    $content = $this->Content->findById(53);
    $this->set('content',$content);
    $this->Project->Behaviors->attach('Containable');
    $options = array(
       array(
        'conditions'=>
           array(
                'Project.id'=>$projid
            ),
           'contain'=>array(
               'User'
           )
        ) 
     );
    $project = $this->Project->find('first',$options);

    $this->set(compact('project'));
}

Now cakephp completely ignores my attached containable and returns this

)

as you can see it ignores my attachment. what am i doing wrong.

Upvotes: 1

Answers (2)

guillobuteler

Reputation: 368

This is a fairly old question, but for what its worth.

Here is the documentation for the Containable Behavior. It states that, to load the behavior on the fly, you should use:

$this->Model->Behaviors->load('Containable');

I believe the difference is merely due to the fact that attach and detach have been deprecated.

Also, why not just set the $actAs property in your model, or even in AppModel?

class AppModel extends Model {
    public $actAs = array('Containable');
    // public $recursive = 0;
    //...
}

The relation with the User model defined in the Project model is missing the foreignKey field, which may cause trouble. I assume Cake defaults that to user_id which should of course be the name of the column in the projects table.

Other than that, your use of the contain options seems ok.

Upvotes: 1

Paulo Rodrigues

Reputation: 5303

Try this:

$this->Project->Behaviors->attach('Containable');
$this->Project->contain(array(
            'conditions' => array('Project.id' => $projid),
            'User'));
$project = $this->Project->find('first');
$this->Project->Behaviors->detach('Containable');

Upvotes: 0

Cakephp Containable not attaching to Model

Answers (2)

Related Questions