DNADesign\ElementalVirtual\Tasks\ResetGloballyEnabledElements::run()

Complexity

Conditions	5
Paths	10

Size

Total Lines	19
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    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')");
            }