<?php

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

namespace App\Infrastructure\Repository;

use App\Domain\Adapter\AuthorizationRepositoryInterface;
use Psr\Container\ContainerInterface;

class AuthorizationRepository implements AuthorizationRepositoryInterface
{
    /** @var ContainerInterface */
    private $container;

    public function __construct(ContainerInterface $container)
    {
        $this->container = $container;
    }

    /**
     * @return mixed
     */
    private function connection()
    {
        return $this->container->get('doctrine.dbal.user_connection');
    }

    /**
     * @return mixed
     */
    public function list()
    {
        $qb = $this->connection();

        $sql = '
            SELECT au.profile_id, au.enabled, au.access, a.code
            FROM authorization au
            INNER JOIN authorization_action a ON a.id = au.action_id
            ';

        $stmt = $qb->prepare($sql);
        $stmt->execute();

        return $stmt->fetchAll();
    }
}