repository.php

<?php

interface QueryBuilderInterface
{
    public function getConfig(): array;
}

class UserQueryBuilder implements QueryBuilderInterface
{
    private $config = [];

    public function __construct(array $config = [])
    {
        $this->config = $config;
    }

    public function fields(array $fields = [])
    {
        $this->config['fields'] = $fields;
        return $this;
    }

    public function active(bool $isAtive = true)
    {
        $this->config['where']['active'] = $isAtive;
        return $this;
    }

    public function getConfig(): array
    {
        return $this->config;
    }
}


class UserRepository
{
    public function query(QueryBuilderInterface $queryBuilder)
    {
        $queryConfig = $queryBuilder->getConfig();

        $fields = join(', ', $queryConfig['fields']);

        $SQL = <<<SQL
            SELECT
                {$fields}
            FROM 
                `user`
SQL;

        $criterias = [];
        if (count($queryConfig['where'])) {
            foreach ($queryConfig['where'] as $criteria => $value) {
                $criterias[] = "`{$criteria}` = '{$value}'";
            }

            $where = join(' AND', $criterias);

            $SQL .= $where;
        }

        return $this->em->query($SQL);
    }
}

class UserReport
{
    private $repository;

    public function __construct(
      UserRepository $repository
    ) {
        $this->repository = $repository;
    }

    public function getActives()
    {
        $userQueryBuilder = new UserQueryBuilder();

        $userQueryBuilder
            ->fields(['*'])
            ->active()
        ;

        return $this->repository->query($userQueryBuilder);
    }
}