Knp\Bundle\KnpBundlesBundle\Repository\OrganizationRepository::queryAllWithBundlesSortedBy PHP Метод

    public function queryAllWithBundlesSortedBy($field)
    {
        $qb = $this->createQueryBuilder('u')->select('u')->leftJoin('u.bundles', 'b');
        switch ($field) {
            case 'name':
                $qb->orderBy('u.name', 'asc');
                break;
            case 'bundles':
                $qb->addSelect('SIZE(u.bundles) bundles')->orderBy('bundles', 'desc');
                break;
            case 'developers':
                $qb->addSelect('SIZE(u.members) members')->orderBy('members', 'desc');
                break;
        }
        return $qb->getQuery();
    }