Template::getAccessCheckSql

static function getAccessCheckSql(array $parameters)
{
	$parameters = static::checkParameters($parameters);

	$userId = $parameters['USER_ID'];
	$user = UserModel::createFromId($userId);
	$accessCodes = $user->getAccessCodes();

	if (empty($accessCodes))
	{
		$accessCodes = ['UUU'];
	}

	$q = new EntityQuery(TasksTemplatePermissionTable::getEntity());
	$q->setSelect(['TEMPLATE_ID' => 'TEMPLATE_ID']);
	$q->whereIn('ACCESS_CODE', $accessCodes);
	$q->setGroup(['TEMPLATE_ID']);

	return array(
		'sql' => $q->getQuery(),
	);
}