37 lines
1.1 KiB
PHP
Executable File
37 lines
1.1 KiB
PHP
Executable File
<?php
|
|
|
|
use common\components\Migration\MigrationWithDefaultOptions;
|
|
use common\modules\abiturient\models\AbiturientQuestionary;
|
|
use common\modules\abiturient\models\interfaces\IDraftable;
|
|
|
|
|
|
|
|
|
|
class m220419_105557_remove_redundant_ques extends MigrationWithDefaultOptions
|
|
{
|
|
|
|
|
|
|
|
public function safeUp()
|
|
{
|
|
$latest_quest_ids = AbiturientQuestionary::find()
|
|
->active()
|
|
->andWhere(['status' => AbiturientQuestionary::STATUS_CREATE_FROM_1C])
|
|
->andWhere(['draft_status' => IDraftable::DRAFT_STATUS_APPROVED])
|
|
->select(['max(id)'])
|
|
->groupBy('user_id');
|
|
$ques_to_delete_batches = AbiturientQuestionary::find()
|
|
->active()
|
|
->andWhere(['status' => AbiturientQuestionary::STATUS_CREATE_FROM_1C])
|
|
->andWhere(['draft_status' => IDraftable::DRAFT_STATUS_APPROVED])
|
|
->andWhere(['not', ['id' => $latest_quest_ids]])
|
|
->batch();
|
|
foreach ($ques_to_delete_batches as $batch) {
|
|
foreach ($batch as $q) {
|
|
$q->delete();
|
|
}
|
|
}
|
|
}
|
|
|
|
}
|