doctrine / orm

    /**

     * @group DDC-2844

     */

    public function testAddCriteriaWhereWithMultipleParametersWithSameField()

    {

        $qb = $this->_em->createQueryBuilder();

        $qb->select('alias1')->from(CmsUser::class, 'alias1');

        $criteria = new Criteria();

        $criteria->where($criteria->expr()->eq('field', 'value1'));

        $criteria->andWhere($criteria->expr()->gt('field', 'value2'));

        $qb->addCriteria($criteria);

        $this->assertEquals('alias1.field = :field AND alias1.field > :field_1', (string) $qb->getDQLPart('where'));

        $this->assertSame('value1', $qb->getParameter('field')->getValue());

        $this->assertSame('value2', $qb->getParameter('field_1')->getValue());

    }

    /**

     * @group DDC-2844

    /**

     * @group DDC-2844

     */

    public function testAddCriteriaWhereWithMultipleParametersWithDifferentFields()

    {

        $qb = $this->_em->createQueryBuilder();

        $qb->select('alias1')->from(CmsUser::class, 'alias1');

        $criteria = new Criteria();

        $criteria->where($criteria->expr()->eq('field1', 'value1'));

        $criteria->andWhere($criteria->expr()->gt('field2', 'value2'));

        $qb->addCriteria($criteria);

        $this->assertEquals('alias1.field1 = :field1 AND alias1.field2 > :field2', (string) $qb->getDQLPart('where'));

        $this->assertSame('value1', $qb->getParameter('field1')->getValue());

        $this->assertSame('value2', $qb->getParameter('field2')->getValue());

    }

    /**

     * @group DDC-2844

    /**

     * @group DDC-2844

     */

    public function testAddCriteriaWhereWithMultipleParametersWithSubpathsAndDifferentProperties()

    {

        $qb = $this->_em->createQueryBuilder();

        $qb->select('alias1')->from(CmsUser::class, 'alias1');

        $criteria = new Criteria();

        $criteria->where($criteria->expr()->eq('field1', 'value1'));

        $criteria->andWhere($criteria->expr()->gt('field2', 'value2'));

        $qb->addCriteria($criteria);

        $this->assertEquals('alias1.field1 = :field1 AND alias1.field2 > :field2', (string) $qb->getDQLPart('where'));

        $this->assertSame('value1', $qb->getParameter('field1')->getValue());

        $this->assertSame('value2', $qb->getParameter('field2')->getValue());

    }

    /**

     * @group DDC-2844

    /**

     * @group DDC-2844

     */

    public function testAddCriteriaWhereWithMultipleParametersWithSubpathsAndSameProperty()

    {

        $qb = $this->_em->createQueryBuilder();

        $qb->select('alias1')->from(CmsUser::class, 'alias1');

        $criteria = new Criteria();

        $criteria->where($criteria->expr()->eq('field1', 'value1'));

        $criteria->andWhere($criteria->expr()->gt('field1', 'value2'));

        $qb->addCriteria($criteria);

        $this->assertEquals('alias1.field1 = :field1 AND alias1.field1 > :field1_1', (string) $qb->getDQLPart('where'));

        $this->assertSame('value1', $qb->getParameter('field1')->getValue());

        $this->assertSame('value2', $qb->getParameter('field1_1')->getValue());

    }

    public function testAddCriteriaOrder()

    {

    /**

     * @group DDC-3108

     */

    public function testAddCriteriaWhereWithJoinAlias()

    {

        $qb = $this->_em->createQueryBuilder();

        $qb->select('alias1')->from(CmsUser::class, 'alias1');

        $qb->join('alias1.articles','alias2');

        $criteria = new Criteria();

        $criteria->where($criteria->expr()->eq('field', 'value1'));

        $criteria->andWhere($criteria->expr()->gt('alias2.field', 'value2'));

        $qb->addCriteria($criteria);

        $this->assertEquals('alias1.field = :field AND alias2.field > :alias2_field', (string) $qb->getDQLPart('where'));

        $this->assertSame('value1', $qb->getParameter('field')->getValue());

        $this->assertSame('value2', $qb->getParameter('alias2_field')->getValue());

    }

    /**

     * @group DDC-3108

    /**

     * @group DDC-3108

     */

    public function testAddCriteriaWhereWithDefaultAndJoinAlias()

    {

        $qb = $this->_em->createQueryBuilder();

        $qb->select('alias1')->from(CmsUser::class, 'alias1');

        $qb->join('alias1.articles','alias2');

        $criteria = new Criteria();

        $criteria->where($criteria->expr()->eq('alias1.field', 'value1'));

        $criteria->andWhere($criteria->expr()->gt('alias2.field', 'value2'));

        $qb->addCriteria($criteria);

        $this->assertEquals('alias1.field = :alias1_field AND alias2.field > :alias2_field', (string) $qb->getDQLPart('where'));

        $this->assertSame('value1', $qb->getParameter('alias1_field')->getValue());

        $this->assertSame('value2', $qb->getParameter('alias2_field')->getValue());

    }

    /**

     * @group DDC-3108