ilFileObjectRBACDatabaseSteps Class Reference

Inheritance diagram for ilFileObjectRBACDatabaseSteps:

Collaboration diagram for ilFileObjectRBACDatabaseSteps:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	assign to all roles which already have the "edit" operation assigned fo files More...
	step_2 ()
	add to all templates which already have the "edit" operation assigned fo files More...
	step_3 ()
Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Data Fields
const	EDIT_FILE = "edit_file"

Protected Member Functions
	getOpsID (ilDBInterface $db, string $operation)

Private Attributes
ilDBInterface	$database = null

Detailed Description

Author

Fabian Schmid fabia.nosp@m.n@sr.nosp@m..solu.nosp@m.tion.nosp@m.s

Definition at line 26 of file class.ilFileObjectRBACDatabaseSteps.php.

Member Function Documentation

getOpsID()

ilFileObjectRBACDatabaseSteps::getOpsID ( ilDBInterface  $db, string  $operation  )

protected

Definition at line 36 of file class.ilFileObjectRBACDatabaseSteps.php.

References $res, ilDBInterface\fetchAssoc(), null, and ilDBInterface\queryF().

Referenced by step_1(), and step_2().

                                                                     : ?int
    {
        $res = $db->queryF(
            "SELECT ops_id FROM rbac_operations WHERE operation = %s",
            ["text"],
            [self::EDIT_FILE]
        );

        return $db->fetchAssoc($res)['ops_id'] ?? null;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

prepare()

ilFileObjectRBACDatabaseSteps::prepare

(

ilDBInterface

$db

)

Definition at line 31 of file class.ilFileObjectRBACDatabaseSteps.php.

                                              : void
    {
        $this->database = $db;
    }

step_1()

ilFileObjectRBACDatabaseSteps::step_1

(

)

assign to all roles which already have the "edit" operation assigned fo files

Definition at line 50 of file class.ilFileObjectRBACDatabaseSteps.php.

References $q, $res, and getOpsID().

                            : void
    {
        $edit_file_ops_id = $this->getOpsID($this->database, self::EDIT_FILE);

        $q = "SELECT
                rbac_pa.rol_id,
                rbac_pa.ops_id,
                rbac_pa.ref_id
            FROM rbac_pa
            JOIN object_reference ON rbac_pa.ref_id = object_reference.ref_id
            JOIN object_data ON object_reference.obj_id = object_data.obj_id
            WHERE object_data.type = 'file';
        ";

        $res = $this->database->query($q);
        while ($row = $this->database->fetchAssoc($res)) {
            $ops_ids = unserialize($row['ops_id'], ['allowed_classes' => false]);
            if (in_array(4, $ops_ids, false) && !in_array($edit_file_ops_id, $ops_ids, false)) {
                $ops_ids[] = $edit_file_ops_id;
                $ops_ids = array_unique($ops_ids);
                $new_ops_ids = serialize($ops_ids);
                $this->database->update(
                    "rbac_pa",
                    [
                        'ops_id' => ['text', $new_ops_ids]
                    ],
                    [
                        'rol_id' => ['integer', $row['rol_id']],
                        'ref_id' => ['integer', $row['ref_id']]
                    ]
                );
            }
        }
    }

Here is the call graph for this function:

step_2()

ilFileObjectRBACDatabaseSteps::step_2

(

)

add to all templates which already have the "edit" operation assigned fo files

Definition at line 88 of file class.ilFileObjectRBACDatabaseSteps.php.

References $q, $res, and getOpsID().

                            : void
    {
        $edit_file_ops_id = $this->getOpsID($this->database, self::EDIT_FILE);

        $q = "SELECT * from rbac_templates WHERE type = %s AND ops_id = %s";
        $res = $this->database->queryF(
            $q,
            ['text', 'integer'],
            ['file', 4]
        );
        while ($row = $this->database->fetchAssoc($res)) {
            try {
                $this->database->insert(
                    "rbac_templates",
                    [
                        'type' => ['text', 'file'],
                        'ops_id' => ['integer', $edit_file_ops_id],
                        'rol_id' => ['integer', $row['rol_id']],
                        'parent' => ['integer', $row['parent']]
                    ]
                );
            } catch (Throwable) {
            };
        }
    }

Here is the call graph for this function:

step_3()

ilFileObjectRBACDatabaseSteps::step_3

(

)

Definition at line 114 of file class.ilFileObjectRBACDatabaseSteps.php.

                            : void
    {
        $read_position = $this->database->fetchAssoc(
            $this->database->queryF(
                "SELECT op_order FROM rbac_operations WHERE operation = %s",
                ['text'],
                [Permissions::READ->value]
            )
        )['op_order'] ?? 2000;

        // update position of view_content operation
        $this->database->update(
            "rbac_operations",
            [
                'op_order' => ['integer', $read_position + 1]
            ],
            [
                'operation' => ['text', Permissions::VIEW_CONTENT->value]
            ]
        );
    }

Field Documentation

$database

ilDBInterface ilFileObjectRBACDatabaseSteps::$database = null

private

Definition at line 29 of file class.ilFileObjectRBACDatabaseSteps.php.

EDIT_FILE

const ilFileObjectRBACDatabaseSteps::EDIT_FILE = "edit_file"

Definition at line 28 of file class.ilFileObjectRBACDatabaseSteps.php.

---

The documentation for this class was generated from the following file:

• components/ILIAS/File/classes/Setup/Database/class.ilFileObjectRBACDatabaseSteps.php