A Query Provider for Updating a Source

QueryProvider.md

namespace DbApi\Query\Provider\Source;

use ZF\Rest\ResourceEvent;
use DbApi\Query\Provider\AbstractQueryProvider;
use Db\Fixture\RoleFixture;

final class Patch extends AbstractQueryProvider
{
    public function createQuery(ResourceEvent $event, $entityClass, $parameters)
    {
        $queryBuilder = parent::createQuery($event, $entityClass, $parameters);

        if ($this->getAuthentication()->getIdentity()->getUser()->hasRole(RoleFixture::$ADMIN)) {
            return $queryBuilder;
        }

        // The source admin must be an admin for this source artist
        $queryBuilder
            ->innerJoin('row.performance', 'performance')
            ->innerJoin('performance.artist', 'artist')
            ->innerJoin('artist.artistGroup', 'artistGroup')
            ->andWhere($queryBuilder->expr()->isMemberOf(':user', 'artistGroup.user'))
            ->setParameter('user', $this->getAuthentication()->getIdentity()->getUser())
            ;

        return $queryBuilder;
    }
}