UFN_MKTNETCOMMUNITYEMAILTEMPLATE_GETLOCKEDSTATUS

CREATE function dbo.[UFN_MKTNETCOMMUNITYEMAILTEMPLATE_GETLOCKEDSTATUS]
(
  @ID integer
)
returns bit
as
begin
  declare @LOCKED bit;

  select @LOCKED = isnull([PAGEMODEL].[LOCKARTIFACTS], 0)
  from dbo.[EmailTemplate]
  left outer join dbo.[PAGEMODELITEM] on [PAGEMODELITEM].[OBJECTGUID] = [EmailTemplate].[Guid]
  left outer join dbo.[PAGEMODEL] on [PAGEMODEL].[ID] = [PAGEMODELITEM].[PAGEMODELID]
  where [EmailTemplate].[ID] = @ID
    -- Check Altru product flags

    and not (dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('bb1c17bc-9e0b-4683-b490-ee40d511fa05') = 1 and -- basic program

            dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('0e85c527-e6e9-4c5f-a8e8-105fd0e18fe7') = 1 and -- basic GL

            dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('42c15648-749e-4859-a56d-3a6474814cc7') = 1 and -- basic development

            dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('e5e0494b-ba0f-4e23-b8fb-a59112dbf3c8') = 1 and -- basic CMS

            dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('5e696818-62ee-4c90-8c28-b1f52d77176e') = 1 and -- membership

            [PAGEMODEL].[MODELID] = '11FDF6FF-4D52-4E36-8AB9-C642898BD236');

  return @LOCKED;
end