DNADesign\ElementalVirtual\Tasks\ResetGloballyEnabledElements

Complexity

Total Complexity

5

Size/Duplication

Total Lines	25
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	run()	0	19	5

<?php

namespace DNADesign\ElementalVirtual\Tasks;

use DNADesign\Elemental\Models\BaseElement;
use SilverStripe\Dev\BuildTask;
use SilverStripe\Core\ClassInfo;
use SilverStripe\Core\Config\Config;
use SilverStripe\ORM\DB;

class ResetGloballyEnabledElements extends BuildTask
{
    protected $title = 'Reset Globally Enabled elements';

    protected $description = 'Reset individual elements \'AvailableGlobally\' setting with the default_global_elements config';

    public function run($request)
    {
        // get all classes of BaseElement
        $elementClasses = ClassInfo::subclassesFor(BaseElement::class);
        $default = Config::inst()->get(BaseElement::class, 'default_global_elements') ? 1 : 0;

        // first update all to the default
        DB::query("UPDATE Element SET AvailableGlobally = $default");
        DB::query("UPDATE Element_Live SET AvailableGlobally = $default");
        DB::query("UPDATE Element_Versions SET AvailableGlobally = $default");

        foreach ($elementClasses as $class) {
            $isGlobal = Config::inst()->get($class, 'default_global_elements') ? 1 : 0;
            $ids = $class::get()->getIDList();
            if (!empty($ids)) {
                $idStr = implode("','", $ids);
                DB::query("UPDATE Element SET AvailableGlobally = $isGlobal WHERE ID IN ('$idStr')");
                DB::query("UPDATE Element_Live SET AvailableGlobally = $isGlobal WHERE ID IN ('$idStr')");
                DB::query("UPDATE Element_Versions SET AvailableGlobally = $isGlobal WHERE RecordID IN ('$idStr')");
            }
        }
    }
}