Chamilo\CoreBundle\Migrations\Schema\V200\Version20201216132000::up()

Complexity

Conditions	7
Paths	8

Size

Total Lines	68
Code Lines	42

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

        $lpItemRepo = $container->get(CLpItemRepository::class);

        $batchSize = self::BATCH_SIZE;
        //$q = $em->createQuery('SELECT lp FROM Chamilo\CourseBundle\Entity\CLp lp WHERE lp.iid = 263 ORDER BY lp.iid');
        $q = $em->createQuery('SELECT lp FROM Chamilo\CourseBundle\Entity\CLp lp');
        $counter = 1;
        /** @var CLp $lp */
        foreach ($q->toIterable() as $lp) {
            $lpId = $lp->getIid();
            error_log("LP #$lpId");

            /** @var CLp $resource */
            //$resource = $lpRepo->find($lpId);
            if (!$lp->hasResourceNode()) {
                error_log("no resource node");
                continue;
            }

            // Root item is created in the previous Migration.
            $rootItem = $lpItemRepo->getRootItem($lpId);

            if (null === $rootItem) {
                error_log("no root item");
                continue;
            }

            // Migrate c_lp_item
            $sql = "SELECT * FROM c_lp_item WHERE lp_id = $lpId AND path <> 'root'
                    ORDER BY display_order";
            $resultItems = $connection->executeQuery($sql);
            $lpItems = $resultItems->fetchAllAssociative();

            if (empty($lpItems)) {
                error_log("no items");
                continue;
            }

            $orderList = [];
            foreach ($lpItems as $item) {
                $object = new \stdClass();
                $object->id = $item['iid'];
                $object->parent_id = (int) $item['parent_item_id'];
                $orderList[] = $object;
            }

            echo '<pre>';
            var_dump($lpId, $lpItems);

var_dump($lpId, $lpItems) looks like debug code. Are you sure you do not want to remove it?

            echo '</pre>';
            error_log("save new order");
            \learnpath::sortItemByOrderList($rootItem, $orderList, true);
            if (($counter % $batchSize) === 0) {
                $em->flush();
                $em->clear(); // Detaches all objects from Doctrine!
            }
            $counter++;
            $em->flush();
        }

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