USP_DATAFORMTEMPLATE_VIEW_FAFEVENT_WEBSITE

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_FAFEVENT_WEBSITE
(
    @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier = null,
    @DATALOADED bit = 0 output,
  @WEBSITEHELPTEXT nvarchar(25) = null output,
  @EVENTNAME as nvarchar(200) = null output,
  @CLIENTSITESID int = null output,
  @CLIENTSITESNAME nvarchar(510) = null output,
  @EVENTWEBSITEAPPURL UDT_WEBADDRESS = null output,
  @BASESITEAPPURL nvarchar(2048) = null output,
  @PUBLISHED bit = null output,

  @REGISTRATIONFORMENDDATE datetime = null output,
    @DONATIONFORMENDDATE datetime = null output,
    @SPONSORSHIPFORMENDDATE datetime = null output,
    @SITEDISABLEDATE datetime = null output,

  @REGISTRATIONREDIRECTLINK UDT_WEBADDRESS = null output,
  @DONATIONREDIRECTLINK UDT_WEBADDRESS = null output,
  @SPONSORSHIPREDIRECTLINK UDT_WEBADDRESS = null output,
  @SITEREDIRECTLINK UDT_WEBADDRESS = null output,

  @REGLINKPAGEID int = null output,
  @REGLINKPAGENAME nvarchar(500) = null output,
  @DONLINKPAGEID int = null output,
  @DONLINKPAGENAME nvarchar(500) = null output,
  @SPONLINKPAGEID int = null output,
  @SPONLINKPAGENAME nvarchar(500) = null output,

  @REGPAGEVANITYURL nvarchar(500) = null output,
  @DONPAGEVANITYURL nvarchar(500) = null output,
  @SPONPAGEVANITYURL nvarchar(500) = null output,
  @GLSETUP bit = null output,
  @UN_MAPPEDAPPTYPES nvarchar(250) = null output,
  @UN_MAPPEDNAMEIDS nvarcHar(150) = null output,
  @MERCHANTACCOUNTISMAPPED bit = null output,
  @ISMAPBBNCUSER bit = null output,
  @EVENTID uniqueidentifier = null output,
  @AID int = null output,
  @ALLOWGL bit = null output,
  @ISMANAGETHEMEENABLED bit = null output

)
as
    set nocount on;

  declare @PUBLISHEDDATE datetime,
          @UNPUBLISHEDDATE datetime,
          @PHPAGEID nvarchar(10),
          @dACCOUNTNUMBER nvarchar(200),
          @eACCOUNTNUMBER nvarchar(200),
          @dPROJECTCODE nvarchar(200),
          @ePROJECTCODE nvarchar(200)
  declare @FAFEventAdminRoleId int,
          @IsFAFEventAdmin bit,
          @ClientUserId int

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.

  set @PUBLISHED = dbo.UFN_CLIENTSITES_GETEVENTWEBSITESTATUS(@ID)

    select @DATALOADED = 1,
    @EVENTID = @ID,
    @WEBSITEHELPTEXT = '',
    @EVENTNAME = E.NAME,
    @CLIENTSITESID = EE.CLIENTSITESID,
    @CLIENTSITESNAME = isnull(CS.Name,E.NAME),
    @EVENTWEBSITEAPPURL = ISNULL(CMSS.Value, ''),
    @REGISTRATIONFORMENDDATE = EA.REGISTRATIONFORMENDDATE,
        @DONATIONFORMENDDATE = EA.DONATIONFORMENDDATE,
        @SPONSORSHIPFORMENDDATE = EA.SPONSORSHIPFORMENDDATE,
        @SITEDISABLEDATE = NULLIF(CMSS33.Value, ''),
        @REGISTRATIONREDIRECTLINK     = EA.REGISTRATIONREDIRECTLINK,
        @DONATIONREDIRECTLINK     = EA.DONATIONREDIRECTLINK,
        @SPONSORSHIPREDIRECTLINK = EA.SPONSORSHIPREDIRECTLINK,
        @SITEREDIRECTLINK    = ISNULL(CMSS34.Value, ''),
    @BASESITEAPPURL = dbo.UFN_BBNC_URL(),
    @ISMANAGETHEMEENABLED = case when ISNULL(CMSS35.Value, 'False') = 'False' then 1 else 0 end
  from dbo.EVENT E
  left join dbo.EVENTEXTENSION EE on EE.EVENTID = E.ID
  left join dbo.EVENTATTRIBUTES EA on EE.EVENTID = EA.EVENTID
  left join dbo.ClientSites CS on EE.CLIENTSITESID = CS.ID
  left join dbo.CMSSITESETTING CMSS on EE.CLIENTSITESID = CMSS.CLIENTSITESID and CMSS.ENUMID = 11
  left join dbo.CMSSITESETTING CMSS33 on EE.CLIENTSITESID = CMSS33.CLIENTSITESID and CMSS33.ENUMID = 33
  left join dbo.CMSSITESETTING CMSS34 on EE.CLIENTSITESID = CMSS34.CLIENTSITESID and CMSS34.ENUMID = 34
  left join dbo.CMSSITESETTING CMSS35 on EE.CLIENTSITESID = CMSS35.CLIENTSITESID and CMSS35.ENUMID = 35
  where E.ID = @ID  

  /*select @BASESITEAPPURL = value from dbo.CMSSITESETTING where ClientSitesID = 1 and ENUMID = 11*/



  if (select count(*) from dbo.GLACCOUNT) > 0 and (select count(*) from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B') > 0
      set @GLSETUP = 1
  else
    set @GLSETUP = 0

  -- Check GL business rule for this account system and set bypass validation if needed.    
        set @ALLOWGL = dbo.UFN_PDACCOUNTSYSTEM_ALLOWGLDISTRIBUTIONS('4B121C2C-CCE6-440D-894C-EA0DEF80D50B')


  exec dbo.USP_PDACCOUNTCODEMAPPING_GETFAF_UPMAPPEDAPPLICATIONTYPES 
    @NAMEIDSTOCHECK='1,2,4,8,32,512,65536,131072', @OFFICEID=3,
    @APPLICATIONTYPES=@UN_MAPPEDAPPTYPES output, @NAMEIDS=@UN_MAPPEDNAMEIDS output

  select @MERCHANTACCOUNTISMAPPED = case when EX.MERCHANTACCOUNTID is not null then 1 else 0 end from dbo.EVENTEXTENSION EX where EX.EVENTID = @ID
  if @MERCHANTACCOUNTISMAPPED = 0
    select @MERCHANTACCOUNTISMAPPED=1 from dbo.MERCHANTACCOUNT where ISDEFAULTAUTHORIZATIONACCOUNT = 1 

  set @REGLINKPAGEID = 0
  set @REGLINKPAGENAME = ''
  set @REGPAGEVANITYURL = ''
  if @REGISTRATIONREDIRECTLINK <> ''
    begin try
      select @PHPAGEID=item from dbo.UFN_STRING_PARSER('/',@REGISTRATIONREDIRECTLINK) where id = 2  
      set @REGLINKPAGEID = CAST(@PHPAGEID as int)

      select @REGLINKPAGENAME=PageName, @REGPAGEVANITYURL=VanityURL.VanityURL from dbo.SitePages 
      left join dbo.VanityURL on SitePages.ID = VanityURL.PageID
      where SitePages.ID = @REGLINKPAGEID   

    end try
    begin catch
      set @REGLINKPAGEID = 0
      set @REGLINKPAGENAME = ''
      set @REGPAGEVANITYURL = ''
    end catch

  set @DONLINKPAGEID = 0
  set @DONLINKPAGENAME = ''
  set @DONPAGEVANITYURL = ''
  if @DONATIONREDIRECTLINK <> ''
    begin try
      select @PHPAGEID=item from dbo.UFN_STRING_PARSER('/',@DONATIONREDIRECTLINK) where id = 2  
      set @DONLINKPAGEID = CAST(@PHPAGEID as int)    

      select @DONLINKPAGENAME=PageName, @DONPAGEVANITYURL=VanityURL.VanityURL from dbo.SitePages 
      left join dbo.VanityURL on SitePages.ID = VanityURL.PageID
      where SitePages.ID = @DONLINKPAGEID   

    end try
    begin catch
      set @DONLINKPAGEID = 0
      set @DONLINKPAGENAME = ''
      set @DONPAGEVANITYURL = ''
    end catch

  set @SPONLINKPAGEID = 0
  set @SPONLINKPAGENAME = ''
  set @SPONPAGEVANITYURL  = ''
  if @SPONSORSHIPREDIRECTLINK <> ''
    begin try
      select @PHPAGEID=item from dbo.UFN_STRING_PARSER('/',@SPONSORSHIPREDIRECTLINK) where id = 2  
      set @SPONLINKPAGEID = CAST(@PHPAGEID as int)      

      select @SPONLINKPAGENAME=PageName, @SPONPAGEVANITYURL=VanityURL.VanityURL from dbo.SitePages 
      left join dbo.VanityURL on SitePages.ID = VanityURL.PageID
      where SitePages.ID = @SPONLINKPAGEID   

    end try
    begin catch
      set @SPONLINKPAGEID = 0
      set @SPONLINKPAGENAME = ''
      set @SPONPAGEVANITYURL  = ''
    end catch

  select @ClientUserId=cu.ID,@AID=cu.ID from dbo.BBNCUSERMAP map
    join dbo.ClientUsers cu on cu.UserName=map.BBNCUSERNAME
    where map.ID=@CURRENTAPPUSERID
  if @ClientUserId is null
      set @ISMAPBBNCUSER = 0
  else
      begin
          select @FAFEventAdminRoleId=cr.ID from dbo.ClientRoles cr where cr.Guid='4625EB3C-1673-4D8C-95D8-BD0B1AD201A6';

          if @FAFEventAdminRoleId is null
        set @ISMAPBBNCUSER = 1
          else
              begin
                  select @IsFAFEventAdmin = case when count(0)=0 then 0 else 1 end
                  from UserRoles ur
                  where ur.ClientUsersID=@ClientUserId and ur.ClientRolesID=@FAFEventAdminRoleId

                  if @IsFAFEventAdmin = 0
                      insert into UserRoles (ClientUsersID, ClientRolesID, ManuallyAdded) values (@ClientUserId, @FAFEventAdminRoleId, 1)

                  set @ISMAPBBNCUSER = 1
              end
      end

  if @ISMAPBBNCUSER = 0
    set @ISMANAGETHEMEENABLED = 0

    return 0;