<?php

namespace App\Repository\Poll;

use Doctrine\ORM\EntityRepository;

/**
 * SummaryRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class SummaryRepository extends EntityRepository
{
    public function findAllByLecturer()
    {
        $results = $this->getEntityManager()
                ->createQuery(
                    "SELECT s,l
                                    FROM App:Poll\Summary s                       
                                    JOIN s.lecturer l     
                                    
                                "
                )
                ->getResult();


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

        return $return;
    }

    public function findByLecturer($lecturer = 0): mixed
    {
        if (empty($lecturer)) {
            $sql = "SELECT s,l
                                    FROM App:Poll\Summary s                        
                                    JOIN s.lecturer l
                                    JOIN l.department d
                                    JOIN d.academicUnit au                           
                                ";
        } else {
            $sql = "SELECT s,l
                                    FROM App:Poll\Summary s                        
                                    JOIN s.lecturer l
                                    JOIN l.department d
                                    JOIN d.academicUnit au      
                                WHERE l.id = '$lecturer'    
                                ";
        }

        return $this->getEntityManager()
                        ->createQuery(
                            $sql
                        )
                        ->getResult();
    }

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