ncu-cc / door-service Goto Github PK

-- InternetEntityRepository#findUnauthorizedByUser
SELECT internet_entity.*, FALSE as authorized FROM internet_entity
LEFT JOIN entity_authorization on internet_entity.id = entity_authorization.entity_id AND entity_authorization.authorizee_id = :user_id
WHERE entity_authorization.authorizee_id IS NULL;
-- InternetEntityRepository#findIsAuthorizedByUser
SELECT internet_entity.*, entity_authorization.authorizee_id IS NOT NULL as authorized FROM internet_entity
LEFT JOIN entity_authorization on internet_entity.id = entity_authorization.entity_id AND entity_authorization.authorizee_id = :user_id;