PRGUpdateRestartedSourceMigration Class Reference

Inheritance diagram for PRGUpdateRestartedSourceMigration:

Collaboration diagram for PRGUpdateRestartedSourceMigration:

Public Member Functions
	getLabel ()
	getDefaultAmountOfStepsPerRun ()
	getPreconditions (Environment $environment)
	prepare (Environment $environment)
	step (Environment $environment)
	getRemainingAmountOfSteps ()

Private Attributes
const	DEFAULT_AMOUNT_OF_STEPS = 1
ilDBInterface	$db
mixed	$io

Detailed Description

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

Member Function Documentation

getDefaultAmountOfStepsPerRun()

PRGUpdateRestartedSourceMigration::getDefaultAmountOfStepsPerRun

(

)

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

                                                   : int
    {
        return self::DEFAULT_AMOUNT_OF_STEPS;
    }

getLabel()

PRGUpdateRestartedSourceMigration::getLabel

(

)

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

                              : string
    {
        return "Update 'Assigned By' for restarted assignments";
    }

getPreconditions()

PRGUpdateRestartedSourceMigration::getPreconditions

(

Environment

$environment

)

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

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

getRemainingAmountOfSteps()

PRGUpdateRestartedSourceMigration::getRemainingAmountOfSteps

(

)

Definition at line 69 of file class.PRGUpdateRestartedSourceMigration.php.

References ilPRGAssignment\AUTO_ASSIGNED_BY_RESTART.

                                               : int
    {
        $query = "SELECT count(restarted_assignment_id) AS cnt FROM prg_usr_assignments" . PHP_EOL
            . " WHERE restarted_assignment_id != -1" . PHP_EOL
            . "AND restarted_assignment_id NOT IN (SELECT id FROM prg_usr_assignments WHERE last_change_by = " . ilPRGAssignment::AUTO_ASSIGNED_BY_RESTART . ");";

        $result = $this->db->query($query);
        $row = $this->db->fetchAssoc($result);
        return (int) $row['cnt'] > 0 ? 1 : 0;
    }

prepare()

PRGUpdateRestartedSourceMigration::prepare

(

Environment

$environment

)

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

References ILIAS\Setup\Environment\getResource().

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

Here is the call graph for this function:

step()

PRGUpdateRestartedSourceMigration::step

(

Environment

$environment

)

Exceptions

Exception

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

References ilPRGAssignment\AUTO_ASSIGNED_BY_RESTART.

                                                  : void
    {
        $query = "UPDATE prg_usr_assignments SET last_change_by = " . ilPRGAssignment::AUTO_ASSIGNED_BY_RESTART . PHP_EOL
            . "WHERE id in (SELECT restarted_assignment_id FROM prg_usr_assignments WHERE restarted_assignment_id != -1)" . PHP_EOL
            . "AND restarted_assignment_id NOT IN (SELECT id FROM prg_usr_assignments WHERE last_change_by = " . ilPRGAssignment::AUTO_ASSIGNED_BY_RESTART . ")";
        $this->db->manipulate($query);
    }

Field Documentation

$db

ilDBInterface PRGUpdateRestartedSourceMigration::$db

private

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

$io

mixed PRGUpdateRestartedSourceMigration::$io

private

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

DEFAULT_AMOUNT_OF_STEPS

const PRGUpdateRestartedSourceMigration::DEFAULT_AMOUNT_OF_STEPS = 1

private

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

---

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

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