<?php

namespace App\Repository;

use Doctrine\ORM\EntityRepository;

/**
 * LecturerApprovedActivitiesRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class LecturerApprovedActivitiesRepository extends EntityRepository
{
    public function getListByLecturerId()
    {
        $results =  $this
            ->createQueryBuilder('a')
            ->join('a.lecturer', 'l')
            ->getQuery()
            ->getResult();


        $return = [];
        foreach ($results as $result) {
            $return[$result->getLecturer()->getId()] = $result;
        }

        return $return;
    }

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