README

Yii2 多对多活动记录级别行为

扩展保存多对多相关数据

安装

安装此扩展的首选方式是通过 Composer。

运行以下命令之一

php composer.phar require --prefer-dist vadymsemeniuk/yii2-many-to-many-ar-level-save-behavior "*"

或

"vadymsemeniuk/yii2-many-to-many-ar-level-save-behavior": "*"

将以下内容添加到您的 composer.json 文件的 require 部分。

使用方法

使用示例可能如下

假设您有以下架构。

CREATE TABLE `article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
);

CREATE TABLE `tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
);

CREATE TABLE `article_to_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `article_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk-article_to_tag-article_id-article-id` (`article_id`),
  KEY `fk-article_to_tag-tag_id-tag-id` (`tag_id`),
  CONSTRAINT `fk-article_to_tag-article_id-article-id` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk-article_to_tag-tag_id-tag-id` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
)

您的代码必须如下所示

use vadymsemenykv\manyToManyBehavior\ManyToManyArLevelSaveBehavior

/**
 * @ property Tag[] $tags
 */
class Article extends ActiveRecord {
    public $tagIds = [];
    
    public function tableName() {
        return 'article';
    }
    
    public function getTags()
    {
        return $this->hasMany(Tag::className(), ['id' => 'tag_id'])
            ->viaTable('article_to_tag', ['article_id' => 'id']);
    }
    
    public function behaviors()
    {
        return [
            'manyToManyBehavior' => [
                'class' => ManyToManyArLevelSaveBehavior::className(),
                'relations' => [
                    'tags' => [
                        'modelClass' => Tag::className(),
                        'attribute' => 'tagIds',
                        'pkColumnName' => 'id',
                        'deleteAllRelatedEntriesBeforeSave' => true,
                    ],
                ],
            ],
        ];
    }
}

class Tag extends ActiveRecord {

    public function tableName() {
        return 'tag';
    }
}

$tag = new Tag();
$tag->id = 1;
$tag->label = 'Tag #1';
$tag->save();


$tag = new Tag();
$tag->id = 2;
$tag->label = 'Tag #2';
$tag->save();

$article = new Article();
$article->label = 'New article';
$article->tagIds = [1, 2];
$article->save();

$tags = $article->tags;

/**
 *  $tags = [
 *     0 => object(Tag)
 *          ...
 *          private '_attributes' (yii\db\BaseActiveRecord) =>
 *                  'id' => int 1
 *                  'label' => string 'Tag #1'
 *          ... 
 *     1 => object(Tag)
 *          ...
 *          private '_attributes' (yii\db\BaseActiveRecord) =>
 *                  'id' => int 2
 *                  'label' => string 'Tag #2'
 *          ...                
 *  ]
 */

高级使用

例如，如果在上述示例中的表 article_to_tag 中存在具有某些附加标识符的 type_id 列，则行为配置可能如下所示

public function behaviors()
{
    return [
        'manyToManyBehavior' => [
            'class' => ManyToManyArLevelSaveBehavior::className(),
            'relations' => [
                'tags' => [
                    'modelClass' => Tag::className(),
                    'attribute' => 'tagIds',
                    'pkColumnName' => 'id',
                    'deleteAllRelatedEntriesBeforeSave' => true,
                    'extraColumns' => [
                        'type_id' => ArticleToTag::TYPE_1
                    ],
                    'additionalUnlinkCondition' => [
                        'type_id' => ArticleToTag::TYPE_1,
                    ]
                ],
            ],
        ],
    ];
}

其中 extraColumns 将在 link() 方法中使用，而 additionalUnlinkCondition 将与 unlink 条件合并。