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...

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 24 of file class.ilFileObjectRBACDatabaseSteps.php.

Member Function Documentation

◆ getOpsID()

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

protected

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

References $res, ilDBInterface\fetchAssoc(), 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 29 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 48 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 86 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) {
             };
         }
     }