<?php

namespace App\Repository;

use Doctrine\ORM\EntityRepository;

class FinanceSourceRepository extends EntityRepository
{
    public function getAllByShortName()
    {
        return $this->getEntityManager()
                        ->createQuery(
                            "SELECT sp 
                                    FROM App:FinanceSource sp INDEX BY sp.shortName
                                ORDER BY sp.shortName ASC"
                        )
                        ->getResult();
    }
}