advancedrelationsbehavior Follow @yiiframework

/**
 * This is the model class for table "blog_category".
 *
 * The followings are the available columns in table 'blog_category':
 * @property integer $id
 * @property string $parent_id
 * @property integer $sort
 */
class BlogCategory extends CActiveRecord
{
    ...
    public function behaviors()
    {
        return array(
            'AdvancedRelationsBehavior' => array(
                'class' => 'AdvancedRelationsBehavior',
                'relations' => array(
                    // HAS_MANY relations
                    'categories',
                    // MANY_MANY relations
                    'posts',
                ),
            ),
        );
    }
    ...
}
 
/**
 * This is the model class for table "blog_post_to_category".
 *
 * The followings are the available columns in table 'blog_post_to_category':
 * @property integer $post_id
 * @property integer $category_id
 * @property integer $sort
 */
class BlogPostToCategory extends CActiveRecord
{
    ...
}
 
/**
 * This is the model class for table "blog_post".
 *
 * The followings are the available columns in table 'blog_post':
 * @property integer $id
 */
class BlogPost extends CActiveRecord
{
    ...
    public function behaviors()
    {
        return array(
            'AdvancedRelationsBehavior' => array(
                'class' => 'AdvancedRelationsBehavior',
                'autoUpdate' => false,  // disable automatic update of related records
                'relations' => array(
                    // MANY_MANY relations
                    'categories',
                    'tags', // same structure as `blog_post_to_category`
                ),
            ),
        );
    }
    ...
}

$model = BlogCategory::model()->findByPk(3);
$model->categories = array(1, 2);
$model->save();

$model = BlogCategory::model()->findByPk(1);
$model->posts = BlogPost::model()->findAll();
$model->save();

$model = new BlogPost;
$model->categories = BlogCategory::model()->findAll();
// update only `categories` relation, `tags` relation is ignored
if($model->save())
    $model->updateRelations('categories');

/**
 * Task: build this categories tree, add "Welcome" post to each "Posts" sub-category
 *  - News
 *      - Business
 *          - Posts
 *      - Sci/Tech
 *          - Posts
 *      - Entertainment
 *          - Posts
 *      - Sports
 *          - Posts
 *      - Health
 *          - Posts
 */
 
// the root category model
$rootCategory = new BlogCategory;
$rootCategory->title = "News";
 
// we cannot make direct modifications to the CActiveRecord relations,
// so we need to make a temporary buffer for this
$categories = array();
 
foreach(array(
    'Business',
    'Sci/Tech',
    'Entertainment',
    'Sports',
    'Health'
    ) as $categoryTitle)
{
    $category = new BlogCategory;
    $category->title = $categoryTitle;
 
    // add sub-category
    $postsCategory = new BlogCategory;
    $postsCategory->title = "Posts";
 
    // add "Welcome" post to the "Posts"
    $post = new BlogPost;
    $post->title = "Welcome";
    $postsCategory->posts = $post;
 
    // save "Posts" category with "Welcome" post
    $postsCategory->saveWithRelated('posts');
 
    $category->categories = $postsCategory;
 
    $categories[] = $category;
}
 
$rootCategory->categories = $categories;
 
// save the categories tree
$rootCategory->saveWithRelated('categories');