Classes/Repository/RedirectRepository.php
protected function getQueryBuilderForDemand(): QueryBuilder
    {
        $queryBuilder = $this->getQueryBuilder();
        $queryBuilder
            ->select('*')
            ->from('sys_redirect')
            ->orderBy('source_host')
            ->addOrderBy('source_path');

        $constraints = [];
        if ($this->demand->hasSourceHost()) {
            $constraints[] =$queryBuilder->expr()->eq(
                'source_host',
                $queryBuilder->createNamedParameter($this->demand->getSourceHost(), \PDO::PARAM_STR)
            );
        }

        if ($this->demand->hasSourcePath()) {
            $escapedLikeString = '%' . $queryBuilder->escapeLikeWildcards($this->demand->getSourcePath()) . '%';
            $constraints[] = $queryBuilder->expr()->like(
                'source_path',
                $queryBuilder->createNamedParameter($escapedLikeString, \PDO::PARAM_STR)
            );
        }

        if ($this->demand->hasTarget()) {
            $escapedLikeString = '%' . $queryBuilder->escapeLikeWildcards($this->demand->getTarget()) . '%';
            $constraints[] = $queryBuilder->expr()->like(
                'target',
                $queryBuilder->createNamedParameter($escapedLikeString, \PDO::PARAM_STR)
            );
        }

        if ($this->demand->hasStatusCode()) {
            $constraints[] =$queryBuilder->expr()->eq(
                'target_statuscode',
                $queryBuilder->createNamedParameter($this->demand->getStatusCode(), \PDO::PARAM_INT)
            );
        }

        if (!empty($constraints)) {
            $queryBuilder->where(...$constraints);
        }
        return $queryBuilder;
    }
protected function getQueryBuilderForDemand(): QueryBuilder
    {
        $queryBuilder = $this->getQueryBuilder();
        $queryBuilder
            ->select('*')
            ->from('sys_redirect')
            ->orderBy('source_host')
            ->addOrderBy('source_path');

        $constraints = [];
        if ($this->demand->hasSourceHost()) {
            $constraints[] =$queryBuilder->expr()->eq(
                'source_host',
                $queryBuilder->createNamedParameter($this->demand->getSourceHost(), \PDO::PARAM_STR)
            );
        }

        if ($this->demand->hasSourcePath()) {
            $escapedLikeString = '%' . $queryBuilder->escapeLikeWildcards($this->demand->getSourcePath()) . '%';
            $constraints[] = $queryBuilder->expr()->like(
                'source_path',
                $queryBuilder->createNamedParameter($escapedLikeString, \PDO::PARAM_STR)
            );
        }

        if ($this->demand->hasTarget()) {
            $escapedLikeString = '%' . $queryBuilder->escapeLikeWildcards($this->demand->getTarget()) . '%';
            $constraints[] = $queryBuilder->expr()->like(
                'target',
                $queryBuilder->createNamedParameter($escapedLikeString, \PDO::PARAM_STR)
            );
        }

        if ($this->demand->hasStatusCode()) {
            $constraints[] =$queryBuilder->expr()->eq(
                'target_statuscode',
                $queryBuilder->createNamedParameter($this->demand->getStatusCode(), \PDO::PARAM_INT)
            );
        }

        if (!empty($constraints)) {
            $queryBuilder->where(...$constraints);
        }
        return $queryBuilder;
    }
protected function getQueryBuilderForDemand ( ) : QueryBuilder { $ queryBuilder = $ this -> getQueryBuilder ( ) ; $ queryBuilder -> select ( '*' ) -> from ( 'sys_redirect' ) -> orderBy ( 'source_host' ) -> addOrderBy ( 'source_path' ) ; $ constraints = [ ] ; if ( $ this -> demand -> hasSourceHost ( ) ) { $ constraints [ ] = $ queryBuilder -> expr ( ) -> eq ( 'source_host' , $ queryBuilder -> createNamedParameter ( $ this -> demand -> getSourceHost ( ) , \ PDO :: PARAM_STR ) ) ; } if ( $ this -> demand -> hasSourcePath ( ) ) { $ escapedLikeString = '%' . $ queryBuilder -> escapeLikeWildcards ( $ this -> demand -> getSourcePath ( ) ) . '%' ; $ constraints [ ] = $ queryBuilder -> expr ( ) -> like ( 'source_path' , $ queryBuilder -> createNamedParameter ( $ escapedLikeString , \ PDO :: PARAM_STR ) ) ; } if ( $ this -> demand -> hasTarget ( ) ) { $ escapedLikeString = '%' . $ queryBuilder -> escapeLikeWildcards ( $ this -> demand -> getTarget ( ) ) . '%' ; $ constraints [ ] = $ queryBuilder -> expr ( ) -> like ( 'target' , $ queryBuilder -> createNamedParameter ( $ escapedLikeString , \ PDO :: PARAM_STR ) ) ; } if ( $ this -> demand -> hasStatusCode ( ) ) { $ constraints [ ] = $ queryBuilder -> expr ( ) -> eq ( 'target_statuscode' , $ queryBuilder -> createNamedParameter ( $ this -> demand -> getStatusCode ( ) , \ PDO :: PARAM_INT ) ) ; } if ( ! empty ( $ constraints ) ) { $ queryBuilder -> where ( ... $ constraints ) ; } return $ queryBuilder ; }
Prepares the QueryBuilder with Constraints from the Demand

@return QueryBuilder
Prepares the QueryBuilder with Constraints from the Demand