Chamilo\CoreBundle\Migrations\Schema\V111\Version20160705192000

Complexity

Total Complexity

3

Size/Duplication

Total Lines	29
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	13	2
A	down()	0	2	1

<?php
/* For licensing terms, see /license.txt */

namespace Chamilo\CoreBundle\Migrations\Schema\V111;

use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\DBAL\Types\Type;

/**
 * Class Version20160705192000
 * Add accumulate scorm time to c_lp table
 * @package Chamilo\CoreBundle\Migrations\Schema\V111
 */
class Version20160705192000 extends AbstractMigrationChamilo
{
    /**
     * @param Schema $schema
     * @throws \Doctrine\DBAL\DBALException
     * @throws \Doctrine\DBAL\Schema\SchemaException
     */
    public function up(Schema $schema)
    {
        $em = $this->getEntityManager();

        $result = $em
            ->getRepository('ChamiloCoreBundle:SettingsCurrent')
            ->findOneBy(['variable' => 'scorm_cumulative_session_time']);

        $cumulativeScormTime = 1;
        if ($result->getSelectedValue() === 'false') {
            $cumulativeScormTime = 0;
        }
        $this->addSql("UPDATE c_lp SET accumulate_scorm_time = $cumulativeScormTime");
    }

    /**
     * @param Schema $schema
     * @throws \Doctrine\DBAL\DBALException
     * @throws \Doctrine\DBAL\Schema\SchemaException
     */
    public function down(Schema $schema)
    {

    }
}