Livestream Recipe SPROC

USE [MinistryPlatform]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/*=================================
== Displays Livestream link
== based on time/day
== Version 1.0
== --------------------------------
== alex@pocketplatform.io
== --------------------------------
=================================*/

IF NOT EXISTS (
  SELECT *
  FROM sys.objects
  WHERE type = 'P'
  AND OBJECT_ID = OBJECT_ID('dbo.api_PocketPlatform_GetLivestream_SunWed')
)
BEGIN
   EXEC('CREATE PROC [dbo].[api_PocketPlatform_GetLivestream_SunWed] AS BEGIN SET NOCOUNT ON; END')
END
GO

ALTER PROCEDURE [dbo].[api_PocketPlatform_GetLivestream_SunWed]
  @ID NVARCHAR(75)
  ,@Title NVARCHAR(75)
  ,@DomainID INT
  ,@DayNumber INT
  ,@Dayhour INT
  ,@DayMin INT
  ,@DayTime DATETIME
AS
BEGIN

  SET DATEFIRST 7;


  -- #ATT Please build a new configuration entry for the Livestream URL.
  -- #ATT The required key is POCKETPLATFORM > LiveStreamURL
  DECLARE @LiveStreamURL nvarchar(MAX) = (SELECT Value FROM dp_Configuration_Settings WHERE Application_Code = 'POCKETPLATFORM' AND Key_Name='LiveStreamURL')



  /* -- == TEST DATA
   */
  -- SET @dayNumber = 4;
  -- SET @dayTime = '11:50:01';

  DECLARE @Items TABLE (
    ID NVARCHAR(50)
    ,Parent_ID NVARCHAR(50)
    ,[Type] NVARCHAR(50)
    ,Data NTEXT
    ,URL NVARCHAR(255)
  );


  IF ( @LiveStreamURL IS NOT NULL )
  BEGIN
    IF ( @dayNumber = 1 AND ( (@dayTime > '07:00:00' AND @dayTime < '13:30:00' ) ) )
    BEGIN
      INSERT INTO @Items (ID, Parent_ID, [Type], Data, URL) VALUES
      (@ID, NULL, 'card', NULL, @LivestreamURL),
      (@ID + 'arrow', @ID, 'arrow-action', NULL, NULL),
      (@ID + 'heading', @ID + 'arrow', 'heading', @Title, NULL);
    END
  ELSE IF ( @dayNumber = 4 AND ( ( @dayTime > '17:00:00' AND @dayTime < '20:30:00' )  ) )
  BEGIN
    INSERT INTO @Items (ID, Parent_ID, [Type], Data, URL) VALUES
      (@ID, NULL, 'card', NULL, @LivestreamURL),
      (@ID + 'arrow', @ID, 'arrow-action', NULL, NULL),
      (@ID + 'heading', @ID + 'arrow', 'heading', @Title, NULL);
  END
  --Enable the below block to send to archives if not streaming.
  /*ELSE
    BEGIN
      INSERT INTO @Items (ID, Parent_ID, [Type], Data, URL) VALUES
        (@ID, NULL, 'card', NULL, @LivestreamURL),
        (@ID + 'arrow', @ID, 'arrow-action', NULL, NULL),
        (@ID + 'heading', @ID + 'arrow', 'heading', 'Watch Archived Services' , NULL);
    END*/
  END

  DECLARE @OperationCount INT = ( SELECT COUNT(*) FROM @Items )
  IF @OperationCount > 0
    SELECT * FROM @Items;

END