Version20201212203625::up() - Code Metrics - Inspection of "Merge branch 'master' of github.com:chamilo/chamil..." - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 2bea51...5a9f1f )

by Julito

created 2021-09-27 14:56 UTC

Version20201212203625::up() F

↳ Parent: Version20201212203625

Complexity

Conditions	21
Paths	882

Size

Total Lines	225
Code Lines	138

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	21
eloc	138
c	1
b	0
f	0
nc	882
nop	1
dl	0
loc	225
rs	0.1311

How to fix Long Method Complexity

<?php

declare(strict_types=1);

/* For licensing terms, see /license.txt */

namespace Chamilo\CoreBundle\Migrations\Schema\V200;

use Chamilo\CoreBundle\Entity\Asset;
use Chamilo\CoreBundle\Entity\AttemptFile;
use Chamilo\CoreBundle\Entity\Course;
use Chamilo\CoreBundle\Entity\TrackEAttempt;
use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
use Chamilo\CoreBundle\Repository\Node\CourseRepository;
use Chamilo\CourseBundle\Entity\CDocument;
use Chamilo\CourseBundle\Repository\CDocumentRepository;
use Chamilo\Kernel;
use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Schema\Schema;
use DocumentManager;
use Symfony\Component\HttpFoundation\File\UploadedFile;

final class Version20201212203625 extends AbstractMigrationChamilo
{
    public function getDescription(): string
    {
        return 'Migrate c_document';
    }

    public function up(Schema $schema): void
    {
        $container = $this->getContainer();
        $doctrine = $container->get('doctrine');
        $em = $doctrine->getManager();
        /** @var Connection $connection */
        $connection = $em->getConnection();

        $documentRepo = $container->get(CDocumentRepository::class);
        $courseRepo = $container->get(CourseRepository::class);
        $attemptRepo = $em->getRepository(TrackEAttempt::class);

        /** @var Kernel $kernel */
        $kernel = $container->get('kernel');
        $rootPath = $kernel->getProjectDir();

        $batchSize = self::BATCH_SIZE;

        // Migrate teacher exercise audio.
        $q = $em->createQuery('SELECT c FROM Chamilo\CoreBundle\Entity\Course c');
        /** @var Course $course */
        foreach ($q->toIterable() as $course) {
            $courseId = $course->getId();
            $sql = "SELECT iid, path
                    FROM c_document
                    WHERE
                          c_id = $courseId AND
                          path LIKE '/../exercises/teacher_audio%'
                    ";
            $result = $connection->executeQuery($sql);
            $documents = $result->fetchAllAssociative();

            foreach ($documents as $documentData) {
                $documentId = $documentData['iid'];
                $path = $documentData['path'];

                $path = str_replace('//', '/', $path);
                $path = str_replace('/../exercises/teacher_audio/', '', $path);

                $filePath = $rootPath.'/app/courses/'.$course->getDirectory().'/exercises/teacher_audio/'.$path;

                if ($this->fileExists($filePath)) {
                    preg_match('#/(.*)/#', '/'.$path, $matches);
                    if (isset($matches[1]) && !empty($matches[1])) {
                        $attemptId = $matches[1];
                        /** @var TrackEAttempt $attempt */
                        $attempt = $attemptRepo->find($attemptId);
                        if (null !== $attempt) {
                            if ($attempt->getAttemptFeedbacks()->count() > 0) {
                                continue;
                            }

                            $fileName = basename($filePath);
                            $mimeType = mime_content_type($filePath);
                            $file = new UploadedFile($filePath, $fileName, $mimeType, null, true);
                            $asset = (new Asset())
                                ->setCategory(Asset::EXERCISE_FEEDBACK)
                                ->setTitle($fileName)
                                ->setFile($file)
                            ;
                            $em->persist($asset);
                            $em->flush();

                            $attemptFile = (new AttemptFile())
                                ->setAsset($asset)
                            ;
                            $attempt->addAttemptFile($attemptFile);
                            $em->persist($attemptFile);
                            $em->flush();

                            $sql = "UPDATE c_document
                                    SET comment = 'skip_migrate'
                                    WHERE iid = $documentId
                            ";
                            $connection->executeQuery($sql);
                        }
                    }
                }
            }
            $em->flush();
            $em->clear();
        }

        $em->flush();
        $em->clear();

        // Migrate student exercise audio
        $q = $em->createQuery('SELECT c FROM Chamilo\CoreBundle\Entity\Course c');
        /** @var Course $course */
        foreach ($q->toIterable() as $course) {
            $courseId = $course->getId();

            $sql = "SELECT iid, path
                    FROM c_document
                    WHERE
                          c_id = $courseId AND
                          path NOT LIKE '/../exercises/teacher_audio%' AND
                          path LIKE '/../exercises/%'
                    ";
            $result = $connection->executeQuery($sql);
            $documents = $result->fetchAllAssociative();

            foreach ($documents as $documentData) {
                $documentId = $documentData['iid'];
                $path = $documentData['path'];

                $path = str_replace('//', '/', $path);
                $path = str_replace('/../exercises/', '', $path);

                $filePath = $rootPath.'/app/courses/'.$course->getDirectory().'/exercises/'.$path;
                if ($this->fileExists($filePath)) {
                    $fileName = basename($filePath);
                    preg_match('#/(.*)/(.*)/(.*)/(.*)/#', '/'.$path, $matches);
                    $sessionId = $matches[1] ?? 0;
                    $exerciseId = $matches[2] ?? 0;
                    $questionId = $matches[3] ?? 0;
                    $userId = $matches[4] ?? 0;

                    /** @var TrackEAttempt $attempt */
                    $attempt = $attemptRepo->findOneBy([
                        'user' => $userId,
                        'questionId' => $questionId,
                        'filename' => $fileName
                    ]);
                    if (null !== $attempt) {
                        if ($attempt->getAttemptFiles()->count() > 0) {
                            continue;
                        }

                        $mimeType = mime_content_type($filePath);
                        $file = new UploadedFile($filePath, $fileName, $mimeType, null, true);
                        $asset = (new Asset())
                            ->setCategory(Asset::EXERCISE_ATTEMPT)
                            ->setTitle($fileName)
                            ->setFile($file)
                        ;
                        $em->persist($asset);
                        $em->flush();

                        $attemptFile = (new AttemptFile())
                            ->setAsset($asset)
                        ;
                        $attempt->addAttemptFile($attemptFile);
                        $em->persist($attemptFile);
                        $em->flush();

                        $sql = "UPDATE c_document
                                SET comment = 'skip_migrate'
                                WHERE iid = $documentId
                        ";
                        $connection->executeQuery($sql);
                    }
                }
            }
            $em->flush();
            $em->clear();
        }

        $em->flush();
        $em->clear();

        // Migrate normal documents.
        $q = $em->createQuery('SELECT c FROM Chamilo\CoreBundle\Entity\Course c');
        /** @var Course $course */
        foreach ($q->toIterable() as $course) {
            $counter = 1;
            $courseId = $course->getId();

            $sql = "SELECT iid, path FROM c_document
                    WHERE
                          c_id = {$courseId} AND
                         (comment IS NULL OR comment <> 'skip_migrate')
                    ORDER BY filetype DESC, path";
            $result = $connection->executeQuery($sql);
            $documents = $result->fetchAllAssociative();
            foreach ($documents as $documentData) {
                $documentId = $documentData['iid'];
                $documentPath = $documentData['path'];
                $course = $courseRepo->find($courseId);

                /** @var CDocument $document */
                $document = $documentRepo->find($documentId);
                if ($document->hasResourceNode()) {
                    continue;
                }

                $parent = null;
                if ('.' !== \dirname($documentPath)) {
                    $parentId = (int) DocumentManager::get_document_id(
                        [
                            'real_id' => $courseId,
                        ],
                        \dirname($documentPath)
                    );
                    if (!empty($parentId)) {
                        $parent = $documentRepo->find($parentId);
                    }
                }

                if (null === $parent) {
                    $parent = $course;
                }
                $admin = $this->getAdmin();
                $result = $this->fixItemProperty('document', $documentRepo, $course, $admin, $document, $parent);

                if (false === $result) {
                    continue;
                }

                $filePath = $rootPath.'/app/courses/'.$course->getDirectory().'/document/'.$documentPath;
                $this->addLegacyFileToResource($filePath, $documentRepo, $document, $documentId);
                $em->persist($document);

                if (($counter % $batchSize) === 0) {
                    $em->flush();
                    $em->clear();
                }
                $counter++;
            }
            $em->flush();
            $em->clear();
        }

        $em->flush();
        $em->clear();
    }

    public function down(Schema $schema): void
    {
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			/* For licensing terms, see /license.txt */
6
7			namespace Chamilo\CoreBundle\Migrations\Schema\V200;
8
9			use Chamilo\CoreBundle\Entity\Asset;
10			use Chamilo\CoreBundle\Entity\AttemptFile;
11			use Chamilo\CoreBundle\Entity\Course;
12			use Chamilo\CoreBundle\Entity\TrackEAttempt;
13			use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
14			use Chamilo\CoreBundle\Repository\Node\CourseRepository;
15			use Chamilo\CourseBundle\Entity\CDocument;
16			use Chamilo\CourseBundle\Repository\CDocumentRepository;
17			use Chamilo\Kernel;
18			use Doctrine\DBAL\Connection;
19			use Doctrine\DBAL\Schema\Schema;
20			use DocumentManager;
21			use Symfony\Component\HttpFoundation\File\UploadedFile;
22
23			final class Version20201212203625 extends AbstractMigrationChamilo
24			{
25			public function getDescription(): string
26			{
27			return 'Migrate c_document';
28			}
29
30			public function up(Schema $schema): void
31			{
32			$container = $this->getContainer();
33			$doctrine = $container->get('doctrine');
34			$em = $doctrine->getManager();
35			/** @var Connection $connection */
36			$connection = $em->getConnection();
37
38			$documentRepo = $container->get(CDocumentRepository::class);
39			$courseRepo = $container->get(CourseRepository::class);
40			$attemptRepo = $em->getRepository(TrackEAttempt::class);
41
42			/** @var Kernel $kernel */
43			$kernel = $container->get('kernel');
44			$rootPath = $kernel->getProjectDir();
45
46			$batchSize = self::BATCH_SIZE;
47
48			// Migrate teacher exercise audio.
49			$q = $em->createQuery('SELECT c FROM Chamilo\CoreBundle\Entity\Course c');
50			/** @var Course $course */
51			foreach ($q->toIterable() as $course) {
52			$courseId = $course->getId();
53			$sql = "SELECT iid, path
54			FROM c_document
55			WHERE
56			c_id = $courseId AND
57			path LIKE '/../exercises/teacher_audio%'
58			";
59			$result = $connection->executeQuery($sql);
60			$documents = $result->fetchAllAssociative();
61
62			foreach ($documents as $documentData) {
63			$documentId = $documentData['iid'];
64			$path = $documentData['path'];
65
66			$path = str_replace('//', '/', $path);
67			$path = str_replace('/../exercises/teacher_audio/', '', $path);
68
69			$filePath = $rootPath.'/app/courses/'.$course->getDirectory().'/exercises/teacher_audio/'.$path;
70
71			if ($this->fileExists($filePath)) {
72			preg_match('#/(.*)/#', '/'.$path, $matches);
73			if (isset($matches[1]) && !empty($matches[1])) {
74			$attemptId = $matches[1];
75			/** @var TrackEAttempt $attempt */
76			$attempt = $attemptRepo->find($attemptId);
77			if (null !== $attempt) {
78			if ($attempt->getAttemptFeedbacks()->count() > 0) {
79			continue;
80			}
81
82			$fileName = basename($filePath);
83			$mimeType = mime_content_type($filePath);
84			$file = new UploadedFile($filePath, $fileName, $mimeType, null, true);
85			$asset = (new Asset())
86			->setCategory(Asset::EXERCISE_FEEDBACK)
87			->setTitle($fileName)
88			->setFile($file)
89			;
90			$em->persist($asset);
91			$em->flush();
92
93			$attemptFile = (new AttemptFile())
94			->setAsset($asset)
95			;
96			$attempt->addAttemptFile($attemptFile);
97			$em->persist($attemptFile);
98			$em->flush();
99
100			$sql = "UPDATE c_document
101			SET comment = 'skip_migrate'
102			WHERE iid = $documentId
103			";
104			$connection->executeQuery($sql);
105			}
106			}
107			}
108			}
109			$em->flush();
110			$em->clear();
111			}
112
113			$em->flush();
114			$em->clear();
115
116			// Migrate student exercise audio
117			$q = $em->createQuery('SELECT c FROM Chamilo\CoreBundle\Entity\Course c');
118			/** @var Course $course */
119			foreach ($q->toIterable() as $course) {
120			$courseId = $course->getId();
121
122			$sql = "SELECT iid, path
123			FROM c_document
124			WHERE
125			c_id = $courseId AND
126			path NOT LIKE '/../exercises/teacher_audio%' AND
127			path LIKE '/../exercises/%'
128			";
129			$result = $connection->executeQuery($sql);
130			$documents = $result->fetchAllAssociative();
131
132			foreach ($documents as $documentData) {
133			$documentId = $documentData['iid'];
134			$path = $documentData['path'];
135
136			$path = str_replace('//', '/', $path);
137			$path = str_replace('/../exercises/', '', $path);
138
139			$filePath = $rootPath.'/app/courses/'.$course->getDirectory().'/exercises/'.$path;
140			if ($this->fileExists($filePath)) {
141			$fileName = basename($filePath);
142			preg_match('#/(.)/(.)/(.)/(.)/#', '/'.$path, $matches);
143			$sessionId = $matches[1] ?? 0;
144			$exerciseId = $matches[2] ?? 0;
145			$questionId = $matches[3] ?? 0;
146			$userId = $matches[4] ?? 0;
147
148			/** @var TrackEAttempt $attempt */
149			$attempt = $attemptRepo->findOneBy([
150			'user' => $userId,
151			'questionId' => $questionId,
152			'filename' => $fileName
153			]);
154			if (null !== $attempt) {
155			if ($attempt->getAttemptFiles()->count() > 0) {
156			continue;
157			}
158
159			$mimeType = mime_content_type($filePath);
160			$file = new UploadedFile($filePath, $fileName, $mimeType, null, true);
161			$asset = (new Asset())
162			->setCategory(Asset::EXERCISE_ATTEMPT)
163			->setTitle($fileName)
164			->setFile($file)
165			;
166			$em->persist($asset);
167			$em->flush();
168
169			$attemptFile = (new AttemptFile())
170			->setAsset($asset)
171			;
172			$attempt->addAttemptFile($attemptFile);
173			$em->persist($attemptFile);
174			$em->flush();
175
176			$sql = "UPDATE c_document
177			SET comment = 'skip_migrate'
178			WHERE iid = $documentId
179			";
180			$connection->executeQuery($sql);
181			}
182			}
183			}
184			$em->flush();
185			$em->clear();
186			}
187
188			$em->flush();
189			$em->clear();
190
191			// Migrate normal documents.
192			$q = $em->createQuery('SELECT c FROM Chamilo\CoreBundle\Entity\Course c');
193			/** @var Course $course */
194			foreach ($q->toIterable() as $course) {
195			$counter = 1;
196			$courseId = $course->getId();
197
198			$sql = "SELECT iid, path FROM c_document
199			WHERE
200			c_id = {$courseId} AND
201			(comment IS NULL OR comment <> 'skip_migrate')
202			ORDER BY filetype DESC, path";
203			$result = $connection->executeQuery($sql);
204			$documents = $result->fetchAllAssociative();
205			foreach ($documents as $documentData) {
206			$documentId = $documentData['iid'];
207			$documentPath = $documentData['path'];
208			$course = $courseRepo->find($courseId);
209
210			/** @var CDocument $document */
211			$document = $documentRepo->find($documentId);
212			if ($document->hasResourceNode()) {
213			continue;
214			}
215
216			$parent = null;
217			if ('.' !== \dirname($documentPath)) {
218			$parentId = (int) DocumentManager::get_document_id(
219			[
220			'real_id' => $courseId,
221			],
222			\dirname($documentPath)
223			);
224			if (!empty($parentId)) {
225			$parent = $documentRepo->find($parentId);
226			}
227			}
228
229			if (null === $parent) {
230			$parent = $course;
231			}
232			$admin = $this->getAdmin();
233			$result = $this->fixItemProperty('document', $documentRepo, $course, $admin, $document, $parent);
234
235			if (false === $result) {
236			continue;
237			}
238
239			$filePath = $rootPath.'/app/courses/'.$course->getDirectory().'/document/'.$documentPath;
240			$this->addLegacyFileToResource($filePath, $documentRepo, $document, $documentId);
241			$em->persist($document);
242
243			if (($counter % $batchSize) === 0) {
244			$em->flush();
245			$em->clear();
246			}
247			$counter++;
248			}
249			$em->flush();
250			$em->clear();
251			}
252
253			$em->flush();
254			$em->clear();
255			}
256
257			public function down(Schema $schema): void
258			{
259			}
260			}
261

chamilo / chamilo-lms

Push — master ( 2bea51...5a9f1f )

Version20201212203625::up() F

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like