<?php

namespace FileManagerBundle\Repository;

use FileManagerBundle\Entity\FolderOwner;
use FileManagerBundle\Entity\FolderItem;
use FileManagerBundle\Interfaces\UserFileOwnerInterface;

/**
 * FolderOwnerRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class FolderOwnerRepository extends \Doctrine\ORM\EntityRepository
{
    public function getPermissionFor(UserFileOwnerInterface $user, FolderItem $folderItem)
    {
        $query = $this->createQueryBuilder('o')
            ->where('o.folder = :folder')
            ->andWhere('o.userFileOwnerInterface = :user')
            ->setParameter('folder', $folderItem)
            ->setParameter('user', $user);

        return $query->orderBy('o.id', 'ASC')
            ->getQuery()
            ->getResult()
            ;
    }
}