<?php

namespace PotageBundle\Repository;
use Symfony\Bridge\Doctrine\Security\User\UserLoaderInterface;
use Symfony\Component\Security\Core\User\UserInterface;

/**
 * UserRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class UserRepository extends \Doctrine\ORM\EntityRepository implements UserLoaderInterface
{
    
    /**
     * Dans security, je ne peux me référer à une propriété, puisque token_key est un array sérialisé
     * cfr. https://symfony.com/doc/3.4/security/entity_provider.html#using-a-custom-query-to-load-the-user
     * TODO vérifier si y a pas mieux que le LIKE
     *
     * @param $tokenkey
     * @return UserInterface|null
     * @throws \Doctrine\ORM\NonUniqueResultException
     */
    public function loadUserByUsername($tokenkey)
    {
        return $this->createQueryBuilder('u')
            ->where('u.tokenKey LIKE :tokenkey')
            ->setParameter('tokenkey', '%'.$tokenkey.'%')
            ->getQuery()
            ->getOneOrNullResult();
    }
    
    
    /**
     * Retourne la colonne des token_keys de tous les users
     * @return array
     */
    public function findAllTokenKeys()
    {
        return $this->createQueryBuilder('u')
            ->select('u.id', 'u.tokenKey')
            ->getQuery()
            ->getResult();
        
    }
    
}