<?php

namespace Test\Pager\Subscriber\Paginate\Doctrine\ORM;

use Test\Tool\BaseTestCaseORM;
use Knp\Component\Pager\Paginator;
use Knp\Component\Pager\Pagination\SlidingPagination;
use Symfony\Component\EventDispatcher\EventDispatcher;
use Knp\Component\Pager\Pagination\PaginationInterface;
use Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber;
use Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber;
use Test\Fixture\Entity\Shop\Product;
use Test\Fixture\Entity\Shop\Tag;
use Doctrine\ORM\Query;

class AdvancedQueryTest extends BaseTestCaseORM
{
    /**
     * Its not possible to make distinction and predict
     * count of such query
     *
     * @test
     * @expectedException RuntimeException
     */
    function shouldFailToPaginateMultiRootQuery()
    {
        $this->populate();

        $dql = <<<___SQL
    SELECT p FROM
      Test\Fixture\Entity\Shop\Product p,
      Test\Fixture\Entity\Shop\Tag t
___SQL;
        $q = $this->em->createQuery($dql);

        $p = new Paginator;
        $this->startQueryLog();
        $view = $p->paginate($q, 1, 2);
    }

    /**
     * @test
     */
    function shouldBeAbleToPaginateWithHavingClause()
    {
        $this->populate();

        $dql = <<<___SQL
        SELECT p, t
        FROM Test\Fixture\Entity\Shop\Product p
        INNER JOIN p.tags t
        GROUP BY p.id
        HAVING p.numTags = COUNT(t)
___SQL;
        $q = $this->em->createQuery($dql);
        $q->setHydrationMode(Query::HYDRATE_ARRAY);
        $p = new Paginator;
        $view = $p->paginate($q, 1, 10, array('wrap-queries' => true));
        $this->assertEquals(3, count($view));
    }

    /**
     * @test
     */
    function shouldBeAbleToPaginateMixedKeyArray()
    {
        $this->populate();

        $dql = <<<___SQL
        SELECT p, t, p.title FROM
          Test\Fixture\Entity\Shop\Product p
        LEFT JOIN
          p.tags t
___SQL;
        $q = $this->em->createQuery($dql);
        $p = new Paginator;
        $view = $p->paginate($q, 1, 10);
        $this->assertEquals(3, count($view));
        $items = $view->getItems();
        // and should be hydrated as array
        $this->assertTrue(isset($items[0]['title']));
    }

    /**
     * @test
     */
    function shouldBeAbleToPaginateCaseBasedQuery()
    {
        if (version_compare(\Doctrine\ORM\Version::VERSION, '2.2.0-DEV', '<')) {
            $this->markTestSkipped('Only recent orm version can test against this query.');
        }
        $this->populate();

        $dql = <<<___SQL
            SELECT p,
              CASE
                WHEN p.title LIKE :keyword
                  AND p.description LIKE :keyword
                THEN 0

                WHEN p.title LIKE :keyword
                THEN 1

                WHEN p.description LIKE :keyword
                THEN 2

                ELSE 3
              END AS relevance
            FROM Test\Fixture\Entity\Shop\Product p
            WHERE (
              p.title LIKE :keyword
              OR p.description LIKE :keyword
            )
            GROUP BY p.id
            ORDER BY relevance ASC, p.id DESC
___SQL;
        $q = $this->em->createQuery($dql);
        $q->setParameter('keyword', '%Star%');
        $q->setHydrationMode(\Doctrine\ORM\Query::HYDRATE_ARRAY);
        $p = new Paginator;
        $view = $p->paginate($q, 1, 10);
        $this->assertEquals(1, count($view));
        $items = $view->getItems();
        // and should be hydrated as array
        $this->assertEquals('Starship', $items[0][0]['title']);
        $this->assertEquals(1, $items[0]['relevance']);
    }

    /**
     * @test
     */
    function shouldUseOutputWalkersIfHinted()
    {
        $this->populate();

        $dql = <<<___SQL
        SELECT p, t
        FROM Test\Fixture\Entity\Shop\Product p
        INNER JOIN p.tags t
        GROUP BY p.id
        HAVING p.numTags = COUNT(t)
___SQL;
        $q = $this->em->createQuery($dql);
        $q->setHydrationMode(Query::HYDRATE_ARRAY);
        $p = new Paginator;
        $view = $p->paginate($q, 1, 10, array('wrap-queries' => true));
        $this->assertEquals(3, count($view));
    }

    protected function getUsedEntityFixtures()
    {
        return array(
            'Test\Fixture\Entity\Shop\Product',
            'Test\Fixture\Entity\Shop\Tag'
        );
    }

    private function populate()
    {
        $em = $this->getMockSqliteEntityManager();
        $cheep = new Tag;
        $cheep->setName('Cheep');

        $new = new Tag;
        $new->setName('New');

        $special = new Tag;
        $special->setName('Special');

        $starship = new Product;
        $starship->setTitle('Starship');
        $starship->setPrice(277.66);
        $starship->addTag($new);
        $starship->addTag($special);

        $cheese = new Product;
        $cheese->setTitle('Cheese');
        $cheese->setPrice(7.66);
        $cheese->addTag($cheep);

        $shoe = new Product;
        $shoe->setTitle('Shoe');
        $shoe->setPrice(2.66);
        $shoe->addTag($special);

        $em->persist($special);
        $em->persist($cheep);
        $em->persist($new);
        $em->persist($starship);
        $em->persist($cheese);
        $em->persist($shoe);
        $em->flush();
    }
}