<?php

namespace App\Repository;

use Doctrine\ORM\EntityRepository;

/**
 * StudiesProgramPostFinanceRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class StudiesProgramPostFinanceRepository extends EntityRepository
{
    public function getAllByHash()
    {
        $results = $this->getEntityManager()
                ->createQuery(
                    "SELECT sppf 
                                    FROM App:StudiesProgramPostFinance sppf
                                ORDER BY sppf.studiesProgram ASC"
                )
                ->getResult();
        $return = [];
        foreach ($results as $result) {
            $studiesProgram = $result->getStudiesProgram()->getShortName();
            $financeSource = $result->getFinanceSource()->getShortName();
            $return[md5($studiesProgram . "_" . $financeSource)] = $result;
        }

        return $return;
    }

    public function deleteAll()
    {
        return $this->getEntityManager()
                        ->createQuery(
                            "DELETE App:StudiesProgramPostFinance t"
                        )
                        ->execute();
    }
}