<?php

/*
 * This file is part of the Syspad Templates project.
 * Copyright (C) Compos Juliot
 */

namespace App\Infrastructure\Repository;

use App\Domain\Adapter\VariableRepositoryInterface;
use App\Domain\Entity\Twig;
use App\Domain\Entity\Variable;
use Doctrine\ORM\EntityManagerInterface;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\Persistence\ManagerRegistry;
use Exception;

class VariableRepository extends ServiceEntityRepository implements VariableRepositoryInterface
{
    /** @var EntityManagerInterface */
    private $entityManager;

    public function __construct(
        EntityManagerInterface $entityManager,
        ManagerRegistry $registry
    ) {
        parent::__construct($registry, Variable::class);
        $this->entityManager = $entityManager;
    }

    /**
     * @param array $variables
     * @param bool $flush
     *
     * @return void
     */
    public function saveMultiple(array $variables, bool $flush = true): void
    {
        foreach ($variables as $variable) {
            $this->entityManager->persist($variable);
        }

        if ($flush) {
            $this->entityManager->flush();
        }
    }

    /**
     * @param array $variables
     * 
     * @return void
     */
    public function removeMultiple(array $variables): void
    {
        foreach ($variables as $variable) {
            $this->entityManager->remove($variable);
        }

        $this->entityManager->flush();
    }

    public function findByTwigId(int $twigId)
    {
        try {
            $result = $this->entityManager->createQueryBuilder()
                ->select('v')
                ->from(Variable::class, 'v')
                ->innerJoin('v.twig', 't')
                ->where("t.id = :twigId")
                ->andWhere('v.deletedAt is null')
                ->setParameter('twigId', $twigId)
                ->getQuery()
                ->getResult();
        } catch (\Exception $e) {
            $result = $e;
        }

        return $result;
    }

    public function findById(int $id)
    {
        try {
            $result = $this->entityManager->createQueryBuilder();

            return $result->select('v')
                ->from(Variable::class, 'v')
                ->where('v.id = :id')
                ->andWhere('v.deletedAt is null')
                ->setParameter('id', $id)
                ->getQuery()
                ->getOneOrNullResult();
        } catch (Exception $e) {
            $result = $e;
        }

        return $result;
    }

    public function delete(Variable $variable)
    {
        try{
            $this->entityManager->remove($variable);
            $this->entityManager->flush();
            return true;
        } catch(Exception $e){
            return $e->getMessage();
        }
    }

    public function findWithoutVarProject()
    {
        try {
            $result = $this->entityManager->createQueryBuilder();

            return $result->select('v')
                ->from(Variable::class, 'v')
                ->where('v.variableProject is not null')
                ->getQuery()
                ->getResult();
        } catch (Exception $e) {
            $result = $e;
        }

        return $result;
    }
}