Kunstmaan / KunstmaanBundlesCMS

src/Kunstmaan/AdminListBundle/Tests/AdminList/FilterType/DBAL/DateFilterTypeTest.php

<?php

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

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

class DateFilterTypeTest extends BaseDbalFilterTest
{
    /**
     * @var DateFilterType
     */
    protected $object;

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

    public function testBindRequest()
    {
        $request = new Request(['filter_comparator_date' => 'before', 'filter_value_date' => '01/01/2012']);

        $data = [];
        $uniqueId = 'date';
        $this->object->bindRequest($request, $data, $uniqueId);

        $this->assertEquals(['comparator' => 'before', 'value' => '01/01/2012'], $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(['comparator' => $comparator, 'value' => $value], 'date');

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

    /**
     * @return array
     */
    public static function applyDataProvider()
    {
        return [
            ['before', '<= :var_date', '20/12/2012', '2012-12-20'],
            ['after', '> :var_date', '21/12/2012', '2012-12-21'],
        ];
    }

    public function testGetTemplate()
    {
        $this->assertEquals('@KunstmaanAdminList/FilterType/dateFilter.html.twig', $this->object->getTemplate());
    }

    /**
     * @throws \ReflectionException
     */
    public function testApplyReturnsNull()

This method seems to be duplicated in your project.

    {
        $queryBuilder = $this->createMock(QueryBuilder::class);
        $queryBuilder->expects($this->never())->method('setParameter');
        $mirror = new ReflectionClass(DateFilterType::class);
        $property = $mirror->getProperty('queryBuilder');
        $property->setAccessible(true);
        $property->setValue($this->object, $queryBuilder);
        $badData = [
            'value' => 'oopsNotADate',
            'comparator' => 'true',
        ];
        $this->object->apply($badData, uniqid());
    }
}