DisallowedCountryRepository.php

<?php

declare(strict_types=1);

namespace App\Repository;

use App\Entity\DisallowCountry;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\Persistence\ManagerRegistry;
use Exception;
use Psr\Log\LoggerInterface;

/**
 * @method DisallowCountry|null find($id, $lockMode = null, $lockVersion = null)
 * @method DisallowCountry|null findOneBy(array $criteria, array $orderBy = null)
 * @method DisallowCountry[]    findAll()
 * @method DisallowCountry[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
 */
class DisallowCountryRepository extends ServiceEntityRepository
{
    private LoggerInterface $logger;

    /**
     * DisallowCountryRepository constructor.
     * @param ManagerRegistry $registry
     * @param LoggerInterface $logger
     * @author bernard-ng <[email protected]>
     */
    public function __construct(ManagerRegistry $registry, LoggerInterface $logger)
    {
        parent::__construct($registry, DisallowCountry::class);
        $this->logger = $logger;
    }

    /**
     * @return array
     * @author bernard-ng <[email protected]>
     */
    public function getDisallowedCountries(): array
    {
        $sql = <<< SQL
            SELECT iso2 FROM disallow_country
            WHERE has_access = '0'
            ORDER BY name
        SQL;

        try {
            $connexion = $this->_em->getConnection();
            $statement = $connexion->prepare($sql);
            $statement->execute();
          
            // important nous avons d'un tableau contenant unique la list de pays
            // ['CD', 'CA', 'FR', 'US'] par exemple
            return $statement->fetchFirstColumn();
        } catch (Exception | \Doctrine\DBAL\Driver\Exception $e) {
            $this->logger->error($e->getMessage(), $e->getTrace());
            return [];
        }
    }
}