ilStudyProgrammeProgressRepositoryTest.php

Go to the documentation of this file.

<?php

class ilStudyProgrammeProgressRepositoryTest extends \PHPUnit\Framework\TestCase
{
    protected $backupGlobals = false;
    protected static $created = [];

    protected function setUp() : void
    {
        PHPUnit_Framework_Error_Deprecated::$enabled = false;

        global $DIC;
        if (!$DIC) {
            include_once("./Services/PHPUnit/classes/class.ilUnitUtil.php");
            ilUnitUtil::performInitialisation();
        }
        global $DIC;
        $this->db = $DIC['ilDB'];
    }

    public function test_init()
    {
        $repo = new ilStudyProgrammeProgressDBRepository($this->db);
        $this->assertInstanceOf(ilStudyProgrammeProgressRepository::class, $repo);
        return $repo;
    }

    public function test_create($repo)
    {
        $prg = new ilStudyProgrammeSettings(1);
        $prg->setPoints(123);
        $ass = new ilStudyProgrammeAssignment(20);
        $ass->setUserId(30);
        $prgs = $repo->createFor($prg, $ass);
        self::$created[$prgs->getId()] = $prgs;
        $this->assertEquals($prgs->getNodeId(), 1);
        $this->assertEquals($prgs->getAssignmentId(), 20);
        $this->assertEquals($prgs->getUserId(), 30);
        $this->assertEquals($prgs->getAmountOfPoints(), 123);
        $this->assertEquals($prgs->getCurrentAmountOfPoints(), 0);
        $this->assertEquals($prgs->getStatus(), ilStudyProgrammeProgress::STATUS_IN_PROGRESS);
        $this->assertEquals($prgs->getAssignmentDate()->format('Y-m-d'), (new DateTime())->format('Y-m-d'));
        $this->assertNull($prgs->getCompletionBy());
        $this->assertNull($prgs->getDeadline());
        $this->assertNull($prgs->getCompletionDate());
        $this->assertNull($prgs->getValidityOfQualification());

        $prg = new ilStudyProgrammeSettings(1);
        $prg->setPoints(123);
        $ass = new ilStudyProgrammeAssignment(21);
        $ass->setUserId(30);
        $prgs = $repo->createFor($prg, $ass);
        self::$created[$prgs->getId()] = $prgs;

        $prg = new ilStudyProgrammeSettings(1);
        $prg->setPoints(123);
        $ass = new ilStudyProgrammeAssignment(22);
        $ass->setUserId(31);
        $prgs = $repo->createFor($prg, $ass);
        self::$created[$prgs->getId()] = $prgs;

        $prg = new ilStudyProgrammeSettings(2);
        $prg->setPoints(123);
        $ass = new ilStudyProgrammeAssignment(23);
        $ass->setUserId(31);
        $prgs = $repo->createFor($prg, $ass);
        self::$created[$prgs->getId()] = $prgs;

        $prg = new ilStudyProgrammeSettings(2);
        $prg->setPoints(123);
        $ass = new ilStudyProgrammeAssignment(24);
        $ass->setUserId(32);
        $prgs = $repo->createFor($prg, $ass);
        self::$created[$prgs->getId()] = $prgs;
    }

    public function test_save_and_load()
    {
        $repo = new ilStudyProgrammeProgressDBRepository($this->db);
        $prgs = current(self::$created);
        $prgs = $repo->get($prgs->getId());
        $this->assertEquals($prgs->getNodeId(), 1);
        $this->assertEquals($prgs->getAssignmentId(), 20);
        $this->assertEquals($prgs->getUserId(), 30);
        $this->assertEquals($prgs->getAmountOfPoints(), 123);
        $this->assertEquals($prgs->getCurrentAmountOfPoints(), 0);
        $this->assertEquals($prgs->getStatus(), ilStudyProgrammeProgress::STATUS_IN_PROGRESS);
        $this->assertNull($prgs->getCompletionBy());
        $this->assertNull($prgs->getDeadline());
        $this->assertNull($prgs->getCompletionDate());
        $this->assertFalse($prgs->isInvalidated());
        $prgs->setAmountOfPoints(234)
            ->setCurrentAmountOfPoints(345)
            ->setStatus(ilStudyProgrammeProgress::STATUS_ACCREDITED)
            ->setCompletionBy(6)
            ->setDeadline(DateTime::createFromFormat(ilStudyProgrammeProgress::DATE_FORMAT, '2018-01-01'))
            ->setCompletionDate(DateTime::createFromFormat(ilStudyProgrammeProgress::DATE_FORMAT, '2017-01-01'))
            ->setValidityOfQualification(DateTime::createFromFormat(ilStudyProgrammeProgress::DATE_FORMAT, '2020-01-01'));
        $repo->update($prgs);
        
        $repo = new ilStudyProgrammeProgressDBRepository($this->db);
        $prgs = $repo->get($prgs->getId());
        $this->assertEquals($prgs->getNodeId(), 1);
        $this->assertEquals($prgs->getAssignmentId(), 20);
        $this->assertEquals($prgs->getUserId(), 30);
        $this->assertEquals($prgs->getAmountOfPoints(), 234);
        $this->assertEquals($prgs->getCurrentAmountOfPoints(), 345);
        $this->assertEquals($prgs->getStatus(), ilStudyProgrammeProgress::STATUS_ACCREDITED);
        $this->assertEquals($prgs->getCompletionBy(), 6);
        $this->assertEquals($prgs->getDeadline()->format(ilStudyProgrammeProgress::DATE_FORMAT), '2018-01-01');
        $this->assertEquals($prgs->getCompletionDate()->format(ilStudyProgrammeProgress::DATE_FORMAT), '2017-01-01');
        $this->assertEquals($prgs->getValidityOfQualification()->format(ilStudyProgrammeProgress::DATE_FORMAT), '2020-01-01');
        $this->assertFalse($prgs->isInvalidated());
    }

    public function test_query_ByIds()
    {
        $repo = new ilStudyProgrammeProgressDBRepository($this->db);
        $prgs = $repo->getByIds(1, 20, 30);
        $this->assertEquals($prgs->getNodeId(), 1);
        $this->assertEquals($prgs->getAssignmentId(), 20);
        $this->assertEquals($prgs->getUserId(), 30);
        $this->assertEquals($prgs->getAmountOfPoints(), 234);
        $this->assertEquals($prgs->getCurrentAmountOfPoints(), 345);
        $this->assertEquals($prgs->getStatus(), ilStudyProgrammeProgress::STATUS_ACCREDITED);
        $this->assertEquals($prgs->getCompletionBy(), 6);
        $this->assertEquals($prgs->getDeadline()->format(ilStudyProgrammeProgress::DATE_FORMAT), '2018-01-01');
        $this->assertEquals($prgs->getCompletionDate()->format(ilStudyProgrammeProgress::DATE_FORMAT), '2017-01-01');
        $this->assertEquals($prgs->getValidityOfQualification()->format(ilStudyProgrammeProgress::DATE_FORMAT), '2020-01-01');
        $this->assertFalse($prgs->isInvalidated());
    }

    public function test_query_ByPrgIdUsrId()
    {
        $repo = new ilStudyProgrammeProgressDBRepository($this->db);
        $prgss = $repo->getByPrgIdAndUserId(1, 30);
        $this->assertCount(2, $prgss);
        $assignments = [];
        foreach ($prgss as $prgs) {
            $this->assertEquals($prgs->getNodeId(), 1);
            $this->assertEquals($prgs->getUserId(), 30);
            $assignments[] = $prgs->getAssignmentId();
        }
        $this->assertEquals([20,21], $assignments);
    }

    public function test_query_ByPrgId()
    {
        $repo = new ilStudyProgrammeProgressDBRepository($this->db);
        $prgss = $repo->getByPrgId(1);
        $this->assertCount(3, $prgss);
        $assignments = [];
        foreach ($prgss as $prgs) {
            $this->assertEquals($prgs->getNodeId(), 1);
            $assignments[] = $prgs->getAssignmentId();
            if (in_array($prgs->getAssignmentId(), [20,21])) {
                $this->assertEquals($prgs->getUserId(), 30);
                continue;
            }
            if ($prgs->getAssignmentId() === 22) {
                $this->assertEquals($prgs->getUserId(), 31);
                continue;
            }
            $this->assertFalse('unexpected assignment id');
        }
        $this->assertEquals([20,21,22], $assignments);
    }


    public function test_query_past_succsessful_1()
    {
        $repo = new ilStudyProgrammeProgressDBRepository($this->db);
        $prgss = $repo->getByPrgId(1);

        $yesterday = new DateTime();
        $yesterday->sub(new DateInterval('P1D'));

        $prgrs1 = array_shift($prgss);
        $prgrs1->setValidityOfQualification($yesterday);
        $prgrs1->setStatus(ilStudyProgrammeProgress::STATUS_COMPLETED);
        $repo->update($prgrs1);

        $prgrs2 = array_shift($prgss);
        $prgrs2->setValidityOfQualification($yesterday);
        $prgrs2->setStatus(ilStudyProgrammeProgress::STATUS_COMPLETED);
        $prgrs2->invalidate();
        $repo->update($prgrs2);

        $prgrs3 = array_shift($prgss);
        $prgrs3->setStatus(ilStudyProgrammeProgress::STATUS_ACCREDITED);
        $repo->update($prgrs1);

        $prgrss = $repo->getExpiredSuccessfull();

        $this->assertEquals(
            [$prgrs1->getId()],
            array_map(function ($prgrs) {
                return $prgrs->getId();
            }, $prgrss)
        );

        $u_prgrss = ilStudyProgrammeDIC::dic()['ilStudyProgrammeUserProgressDB']->getExpiredSuccessfulInstances();
        $this->assertEquals(
            [$prgrs1->getId()],
            array_map(function ($prgrs) {
                return $prgrs->getId();
            }, $u_prgrss)
        );
    }

    public function test_query_past_succsessful_2()
    {
        $repo = new ilStudyProgrammeProgressDBRepository($this->db);
        $prgss = $repo->getByPrgId(1);

        $yesterday = new DateTime();
        $yesterday->sub(new DateInterval('P1D'));
        $tomorrow = new DateTime();
        $tomorrow->add(new DateInterval('P1D'));

        $prgrs1 = array_shift($prgss);
        $prgrs1->setValidityOfQualification($yesterday);
        $prgrs1->setStatus(ilStudyProgrammeProgress::STATUS_ACCREDITED);
        $repo->update($prgrs1);

        $prgrs2 = array_shift($prgss);
        $prgrs1->setStatus(ilStudyProgrammeProgress::STATUS_ACCREDITED);
        $repo->update($prgrs1);

        $prgrs3 = array_shift($prgss);
        $prgrs2->setValidityOfQualification($yesterday);
        $prgrs3->setStatus(ilStudyProgrammeProgress::STATUS_FAILED);
        $repo->update($prgrs1);

    
        $prgrss = [];
        foreach ($repo->getExpiredSuccessfull() as $key => $prgrs) {
            $prgrss[] = $prgrs;
        }

        $this->assertEquals(
            [$prgrs1->getId()],
            array_map(function ($prgrs) {
                return $prgrs->getId();
            }, $prgrss)
        );

        $u_prgrss = ilStudyProgrammeDIC::dic()['ilStudyProgrammeUserProgressDB']->getExpiredSuccessfulInstances();
        $this->assertEquals(
            [$prgrs1->getId()],
            array_map(function ($prgrs) {
                return $prgrs->getId();
            }, $u_prgrss)
        );
    }


    public static function tearDownAfterClass() : void
    {
        global $DIC;
        if (!$DIC) {
            include_once("./Services/PHPUnit/classes/class.ilUnitUtil.php");
            ilUnitUtil::performInitialisation();
        }
        global $DIC;
        $db = $DIC['ilDB'];
        if (count(self::$created) > 0) {
            $db->manipulate(
                'DELETE FROM ' . ilStudyProgrammeProgressDBRepository::TABLE
                . '     WHERE'
                . '     ' . $db->in(
                    ilStudyProgrammeProgressDBRepository::FIELD_ID,
                    array_keys(self::$created),
                    false,
                    'integer'
                )
            );
        }
    }
}