Inheritance diagram for PRGUpdateCRSRefLPSettingMigration:

Collaboration diagram for PRGUpdateCRSRefLPSettingMigration:

Public Member Functions
	getLabel ()

	getDefaultAmountOfStepsPerRun ()

	getPreconditions (Environment $environment)

	prepare (Environment $environment)

	step (Environment $environment)

	getRemainingAmountOfSteps ()

Private Attributes
const	DEFAULT_AMOUNT_OF_STEPS = 1000

ilDBInterface	$db

mixed	$io

Detailed Description

Definition at line 25 of file class.PRGUpdateCRSRefLPSettingMigration.php.

Member Function Documentation

◆ getDefaultAmountOfStepsPerRun()

PRGUpdateCRSRefLPSettingMigration::getDefaultAmountOfStepsPerRun ( )

Definition at line 40 of file class.PRGUpdateCRSRefLPSettingMigration.php.

                                                    : int
    {
        return self::DEFAULT_AMOUNT_OF_STEPS;
    }

References DEFAULT_AMOUNT_OF_STEPS.

◆ getLabel()

PRGUpdateCRSRefLPSettingMigration::getLabel ( )

Definition at line 35 of file class.PRGUpdateCRSRefLPSettingMigration.php.

                               : string
    {
        return "Update LP Settings of Course References";
    }

◆ getPreconditions()

PRGUpdateCRSRefLPSettingMigration::getPreconditions ( Environment $environment )

Definition at line 45 of file class.PRGUpdateCRSRefLPSettingMigration.php.

                                                               : array
    {
        return [
            new ilDatabaseInitializedObjective(),
            new ilDatabaseUpdatedObjective()
        ];
    }

◆ getRemainingAmountOfSteps()

PRGUpdateCRSRefLPSettingMigration::getRemainingAmountOfSteps ( )

Definition at line 90 of file class.PRGUpdateCRSRefLPSettingMigration.php.

                                                : int
    {
        $query = "SELECT count(distinct od.obj_id) AS cnt " . PHP_EOL .
            "FROM object_reference oref " . PHP_EOL .
            "JOIN object_data od ON od.obj_id = oref.obj_id AND od.type = 'crsr'" . PHP_EOL .
            "JOIN tree ON oref.ref_id = tree.child" . PHP_EOL .
            "JOIN tree t2 ON t2.path > tree.path" . PHP_EOL .
            "JOIN object_reference oref2 ON oref2.ref_id = t2.child" . PHP_EOL .
            "JOIN object_data od2 ON od2.obj_id = oref2.obj_id AND od2.type = 'prg'" . PHP_EOL .
            "WHERE od.obj_id NOT IN (" . PHP_EOL .
            "SELECT obj_id FROM ut_lp_settings WHERE obj_type = 'crsr' AND u_mode = "
            . ilLPObjSettings::LP_MODE_COURSE_REFERENCE . PHP_EOL .
            ")";
        $result = $this->db->query($query);
        $row = $this->db->fetchAssoc($result);
 
        return (int) $row['cnt'];
    }

References $query, $result, and ilLPObjSettings\LP_MODE_COURSE_REFERENCE.

◆ prepare()

PRGUpdateCRSRefLPSettingMigration::prepare ( Environment $environment )

Definition at line 53 of file class.PRGUpdateCRSRefLPSettingMigration.php.

                                                      : void
    {
        $this->db = $environment->getResource(Setup\Environment::RESOURCE_DATABASE);
    }

References ILIAS\Setup\Environment\getResource().

Here is the call graph for this function:

◆ step()

PRGUpdateCRSRefLPSettingMigration::step ( Environment $environment )

Exceptions

Exception

Definition at line 61 of file class.PRGUpdateCRSRefLPSettingMigration.php.

                                                   : void
    {
        $query = "SELECT distinct od.obj_id AS objid " . PHP_EOL .
            "FROM object_reference oref " . PHP_EOL .
            "JOIN object_data od ON od.obj_id = oref.obj_id AND od.type = 'crsr'" . PHP_EOL .
            "JOIN tree ON oref.ref_id = tree.child" . PHP_EOL .
            "JOIN tree t2 ON t2.path > tree.path" . PHP_EOL .
            "JOIN object_reference oref2 ON oref2.ref_id = t2.child" . PHP_EOL .
            "JOIN object_data od2 ON od2.obj_id = oref2.obj_id AND od2.type = 'prg'" . PHP_EOL .
            "WHERE od.obj_id NOT IN (" . PHP_EOL .
            "SELECT obj_id FROM ut_lp_settings WHERE obj_type = 'crsr' AND u_mode = "
            . ilLPObjSettings::LP_MODE_COURSE_REFERENCE . PHP_EOL .
            ")" . PHP_EOL .
            "LIMIT 1";
 
        $result = $this->db->query($query);
        $row = $this->db->fetchAssoc($result);
        $q = 'DELETE FROM ut_lp_settings WHERE obj_id = ' . (int) $row['objid'];
        $this->db->manipulate($q);
 
        $q = 'INSERT INTO ut_lp_settings (obj_id, obj_type, u_mode)' . PHP_EOL .
            'VALUES (' .
            (int) $row['objid'] .
            ', "crsr", ' .
            ilLPObjSettings::LP_MODE_COURSE_REFERENCE .
            ');';
        $this->db->manipulate($q);
    }