PRGUpdateCRSRefLPSettingMigration Class Reference

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;
    }

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.

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

                                                : 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'];
    }

prepare()

PRGUpdateCRSRefLPSettingMigration::prepare

(

Environment

$environment

)

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

References ILIAS\Setup\Environment\getResource().

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

Here is the call graph for this function:

step()

PRGUpdateCRSRefLPSettingMigration::step

(

Environment

$environment

)

Exceptions

Exception

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

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

                                                   : 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);
    }

Field Documentation

$db

ilDBInterface PRGUpdateCRSRefLPSettingMigration::$db

private

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

$io

mixed PRGUpdateCRSRefLPSettingMigration::$io

private

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

DEFAULT_AMOUNT_OF_STEPS

const PRGUpdateCRSRefLPSettingMigration::DEFAULT_AMOUNT_OF_STEPS = 1000

private

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

---

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

• Modules/StudyProgramme/classes/Setup/class.PRGUpdateCRSRefLPSettingMigration.php