<?php

/*
 * This file is part of the Maestro Project.
 * Copyright (C) Compos Juliot
 */

namespace App\Infrastructure\Repository;

use App\Domain\Adapter\GroupProjectRepositoryInterface;
use App\Domain\Entity\GroupProject;
use Doctrine\ORM\EntityManagerInterface;
use Exception;

class GroupProjectRepository implements GroupProjectRepositoryInterface
{
    /** @var EntityManagerInterface */
    private $entityManager;

    // public const GROUP_GRANT = [
    //     'ON_PROJECT_PROJECT_READ',
    //     'ON_PROJECT_PROJECT_EDIT',
    //     // 'ON_PROJECT_PRODUCT_READ',
    //     // 'ON_PROJECT_PRODUCT_EDIT',
    //     // 'ON_PROJECT_EXPORT_READ',
    //     'ON_PROJECT_EXPORT_EDIT',
    //     // 'ON_PROJECT_EXPORT_ADD',
    //     // 'ON_PROJECT_EXPORT_DELETE',
    //     // 'ON_PROJECT_WORKFLOW_READ',
    //     // 'ON_PROJECT_WORKFLOW_EDIT',
    //     // 'ON_PROJECT_TEMPLATE_READ',
    //     // 'ON_PROJECT_TEMPLATE_EDIT',
    //     'ON_PROJECT_EXPORT_USE',
    //     'ON_PROJECT_EXPORT_VERSION',
    // ]; 

    public function __construct(
        EntityManagerInterface $entityManager
    ) {
        $this->entityManager = $entityManager;
    }

    /**
     * @param array $groupProject [description]
     * 
     * @return array [description]
     */
    public function saveMultiple(array $groupProjects)
    {
        try {
            foreach ($groupProjects as $groupProject) {
                $this->entityManager->persist($groupProject);
            }
            $this->entityManager->flush();

            return true;
        } catch (Exception $e) {
            return $e;
        }
    }

    /**
     * @param array $groupProject [description]
     * 
     * @return array [description]
     */
    public function removeMultiple($groupProjects)
    {
        try {
            foreach ($groupProjects as $groupProject) {
                $this->entityManager->remove($groupProject);
            }
            $this->entityManager->flush();

            return true;
        } catch (Exception $e) {
            return $e;
        }
    }

    /**
     * @param int $projectId [description]
     * @param array $groupIds [description]
     * 
     * @return array [description]
     */
    public function findByProjectAndGroups(int $projectId, array $groupIds)
    {
        $qb = $this->entityManager->createQueryBuilder();

        return $qb->select('gp')
            ->from(GroupProject::class, 'gp')
            ->innerJoin('gp.project', 'p')
            ->where('p.id = :projectId')
            ->andWhere($qb->expr()->in('gp.group', $groupIds))
            ->setParameter('projectId', $projectId)
            ->getQuery()
            ->getResult();
    }
}