<?php

declare(strict_types=1);

namespace UserAccessManager\Setup\Update;

use UserAccessManager\Object\ObjectHandler;

class DatabaseUpdate4 extends DatabaseUpdate
{
    public function getVersion(): string
    {
        return '1.4.1';
    }

    public function update(): bool
    {
        $dbAccessGroupToObject = $this->database->getUserGroupToObjectTable();
        $alterQuery = "ALTER TABLE {$dbAccessGroupToObject}
            ADD general_object_type VARCHAR(64) NOT NULL AFTER object_id";

        $success = $this->database->query($alterQuery) !== false;

        $generalTermType = ObjectHandler::GENERAL_TERM_OBJECT_TYPE;
        $objectTypeConditions = [
            ObjectHandler::GENERAL_POST_OBJECT_TYPE => "object_type IN ('post', 'page', 'attachment')",
            ObjectHandler::GENERAL_ROLE_OBJECT_TYPE => "object_type = 'role'",
            ObjectHandler::GENERAL_USER_OBJECT_TYPE => "object_type = 'user'",
            $generalTermType => "object_type = 'term'"
        ];

        foreach ($objectTypeConditions as $generalObjectType => $condition) {
            $query = "UPDATE {$dbAccessGroupToObject}
                SET general_object_type = '$generalObjectType'
                WHERE $condition";

            $success = $success && $this->database->query($query) !== false;
        }

        $query = "UPDATE $dbAccessGroupToObject AS gto
            LEFT JOIN {$this->database->getTermTaxonomyTable()} AS tt 
              ON gto.object_id = tt.term_id
            SET gto.object_type = tt.taxonomy
            WHERE gto.general_object_type = '$generalTermType'";

        return $success && $this->database->query($query) !== false;
    }
}