Kunstmaan / KunstmaanBundlesCMS

src/Kunstmaan/AdminListBundle/Tests/unit/AdminList/FilterType/DBAL/DateTimeFilterTypeTest.php

<?php

namespace Kunstmaan\AdminListBundle\Tests\AdminList\FilterType\DBAL;

use Doctrine\DBAL\Query\QueryBuilder;
use Kunstmaan\AdminListBundle\AdminList\FilterType\DBAL\DateTimeFilterType;
use ReflectionClass;
use Symfony\Component\HttpFoundation\Request;

class DateTimeFilterTypeTest extends BaseDbalFilterTest

This class seems to be duplicated in your project.

{
    /**
     * @var \UnitTester
     */
    protected $tester;

    /**
     * @var DateTimeFilterType
     */
    protected $object;

    protected function setUp()
    {
        $this->object = new DateTimeFilterType('datetime', 'e');
    }

    /**
     * @return array
     */
    public static function applyDataProvider()
    {
        return array(
            array('before', '<= :var_datetime', array('date' => '14/04/2014', 'time' => '09:00'), '2014-04-14 09:00'),
            array('after', '> :var_datetime', array('date' => '14/04/2014', 'time' => '10:00'), '2014-04-14 10:00'),
        );
    }

    public function testBindRequest()
    {
        $request = new Request(array(
            'filter_comparator_datetime' => 'before',
            'filter_value_datetime' => array('date' => '14/04/2014', 'time' => '09:00'),
        ));

        $data = array();
        $uniqueId = 'datetime';
        $this->object->bindRequest($request, $data, $uniqueId);

        $this->assertEquals(
            array('comparator' => 'before', 'value' => array('date' => '14/04/2014', 'time' => '09:00')),
            $data
        );
    }

    /**
     * @param string $comparator  The comparator
     * @param string $whereClause The where clause
     * @param mixed  $value       The value
     * @param mixed  $testValue   The test value
     *
     * @dataProvider applyDataProvider
     */
    public function testApply($comparator, $whereClause, $value, $testValue)
    {
        $qb = $this->getQueryBuilder();
        $qb->select('*')
            ->from('entity', 'e');
        $this->object->setQueryBuilder($qb);
        $this->object->apply(array('comparator' => $comparator, 'value' => $value), 'datetime');

        $this->assertEquals("SELECT * FROM entity e WHERE e.datetime $whereClause", $qb->getSQL());
        $this->assertEquals($testValue, $qb->getParameter('var_datetime'));
    }

    public function testGetTemplate()
    {
        $this->assertEquals(
            'KunstmaanAdminListBundle:FilterType:dateTimeFilter.html.twig',
            $this->object->getTemplate()
        );
    }

    /**
     * @throws \ReflectionException
     */
    public function testApplyReturnsNull()
    {
        $queryBuilder = $this->createMock(QueryBuilder::class);
        $queryBuilder->expects($this->never())->method('setParameter');
        $mirror = new ReflectionClass(DateTimeFilterType::class);
        $property = $mirror->getProperty('queryBuilder');
        $property->setAccessible(true);
        $property->setValue($this->object, $queryBuilder);

        $badData = [
            'value' => [
                'date' => 'oopsNotADate',
                'time' => 'oopsNotATime',
            ],
            'comparator' => 'true',
        ];
        $this->object->apply($badData, uniqid());
    }
}