DoctrineMigrations\Version20161108095350

Complexity

Total Complexity

9

Size/Duplication

Total Lines	97
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Importance

Changes	3
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	5	1
C	up()	0	82	8

<?php

namespace DoctrineMigrations;

use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;
use Eccube\Application;
use Eccube\Entity\Master\ProductListOrderBy;
use Symfony\Component\Filesystem\Filesystem;
use Symfony\Component\Yaml\Yaml;

/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20161108095350 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        $app = Application::getInstance();
        $repository = $app['orm.em']->getRepository('Eccube\Entity\Master\ProductListOrderBy');

        $isDefault = true;
        $default = array(
            array(
                'id' => 1,
                'name' => '価格順',
                'rank' => 0,
            ),
            array(
                'id' => 2,
                'name' => '新着順',
                'rank' => 1,
            ),
        );

        // mtb_product_list_orderbyが初期状態から変更がないかどうかの判定
        $entities = $repository->findBy(array(), array('id' => 'ASC'));
        foreach ($entities as $entity) {
            if (!in_array($entity->toArray(), $default, true)) {
                $isDefault = false;
            }
        }

        // 価格が高い順ソートの追加
        $id = $repository->createQueryBuilder('pl')
            ->select('MAX(pl.id) + 1')
            ->getQuery()
            ->getSingleScalarResult();

        $rank = $repository->createQueryBuilder('pl')
            ->select('MAX(pl.rank) + 1')
            ->getQuery()
            ->getSingleScalarResult();

        $ProductListOrderBy = new ProductListOrderBy();
        $ProductListOrderBy->setId($id);
        $ProductListOrderBy->setName('価格が高い順');
        $ProductListOrderBy->setRank($rank);
        $app['orm.em']->persist($ProductListOrderBy);
        $app['orm.em']->flush($ProductListOrderBy);

        // constant.ymlへ価格が高い順のIDを記録.
        if ($id !== $app['config']['product_order_price_higher']) {
            $file = $app['config']['root_dir'].'/app/config/eccube/constant.yml';
            $fs = new Filesystem();

            $constant = $fs->exists($file)
                ? Yaml::parse(file_get_contents($file))
                : array();

            $constant['product_order_price_higher'] = $id;
            $yaml = Yaml::dump($constant);
            $fs->dumpFile($file, $yaml);
        }

        // "価格順"の名称を"価格が低い順"へ変更
        $ProductListOrderBy = $repository->find(1);
        if (!is_null($ProductListOrderBy) && $ProductListOrderBy->getName() === '価格順') {
            $ProductListOrderBy->setName('価格が低い順');
            $app['orm.em']->persist($ProductListOrderBy);
            $app['orm.em']->flush($ProductListOrderBy);
        }

        // mtb_product_list_orderbyが初期状態から変更がなければ、価格が低い順->価格が高い順->新着順の順にrankを振り直す
        if ($isDefault) {
            $entity = $repository->find(1);
            $entity->setRank(0);
            $app['orm.em']->flush($entity);

            $entity = $repository->find(2);
            $entity->setRank(2);
            $app['orm.em']->flush($entity);

            $entity = $repository->find($id);
            $entity->setRank(1);
            $app['orm.em']->flush($entity);
        }
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs

    }
}