Yii CActiveDataProvider多：：多

Question

我有两个模型:项目和用户连接(User.php)：

public function relations()
{
    // NOTE: you may need to adjust the relation name and the related
    // class name for the relations automatically generated below.
    return array(
            "projects"=>array(self::MANY_MANY, 'Project','projects_users(user_id, project_id)'),
    );
}

我想向所有在CActiveDataProvider中是而不是与项目相关的的用户展示。我该怎么做呢？

Answer 1

我找到了解决办法：

$criteria=new CDbCriteria;

foreach($model->users as $cur) {
    $criteria->addCondition("ID != ".$cur->ID);
    }

$users=User::model()->findAll($criteria);

$dataProvider2=new CActiveDataProvider('User');
$dataProvider2->data = $users;

Answer 2

试试这个：

$users = User::model()->with('projects')->findAll(array(
    'together' => true,
    'condition' => 'projects.id IS NULL',
));