ChangeUserNotificationSettingsNamespace.php

Go to the documentation of this file.

<?php
 
namespace Elgg\Upgrades;
 
use Elgg\Database\EntityTable;
use Elgg\Database\MetadataTable;
use Elgg\Upgrade\SystemUpgrade;
use Elgg\Upgrade\Result;
use Elgg\Database\Select;
use Elgg\Database\Update;
 
class ChangeUserNotificationSettingsNamespace extends SystemUpgrade {
 
    public function getVersion(): int {
        return 2021040701;
    }
 
    public function needsIncrementOffset(): bool {
        return false;
    }
 
    public function shouldBeSkipped(): bool {
        return empty($this->countItems());
    }
 
    public function countItems(): int {
        $select = Select::fromTable(MetadataTable::TABLE_NAME, MetadataTable::DEFAULT_JOIN_ALIAS);
        $entities_table = $select->joinEntitiesTable($select->getTableAlias(), 'entity_guid');
        
        $select->select('count(*) AS total')
            ->where($select->compare("{$select->getTableAlias()}.name", 'like', 'notification:method:%', ELGG_VALUE_STRING))
            ->andWhere($select->compare("{$entities_table}.type", '=', 'user', ELGG_VALUE_STRING));
        
        $result = _elgg_services()->db->getDataRow($select);
        
        return (int) $result->total;
    }
 
    public function run(Result $result, $offset): Result {
        $update = Update::table(MetadataTable::TABLE_NAME);
        $update->set('name', 'REPLACE(name, "notification:method:", "notification:default:")')
            ->where($update->compare('name', 'like', 'notification:method:%', ELGG_VALUE_STRING));
        
        $users = $update->subquery(EntityTable::TABLE_NAME);
        $users->select('guid')
            ->where($update->compare('type', '=', 'user', ELGG_VALUE_STRING));
        
        $update->andWhere($update->compare('entity_guid', 'in', $users->getSQL()));
        
        $num_rows = _elgg_services()->db->updateData($update, true);
        
        $result->addSuccesses($num_rows);
        
        return $result;
    }
}