USP_DATALIST_FAFEVENTDONATION

CREATE procedure dbo.USP_DATALIST_FAFEVENTDONATION
        ( @EVENTID uniqueidentifier,
          @REGISTRANTID uniqueidentifier = NULL,
          @TEAMFUNDRAISINGTEAMID uniqueidentifier = NULL,
          @ROLETYPE tinyint = 0 -- 0: ind / TM 1:Team 2:Company 3:Household

        )WITH EXECUTE AS CALLER
        as
        BEGIN
            SET NOCOUNT ON;

            DECLARE @TOTALDONATION money
            DECLARE @REGISTRANTRAISED money
            DECLARE @TEAMRAISED money
            DECLARE @TEAMMEMBERSRAISED money
            DECLARE @REGISTRANTDONATION money
            DECLARE @REGISTRANTREGISTRATION money
            DECLARE @GOAL money
            DECLARE @MINIMIMUMFUNDRAISINGGOAL money
            DECLARE @REGISTRANTCONSTITUENTID uniqueidentifier
            DECLARE @TEAMCONSTITUENTID uniqueidentifier
            DECLARE @APPEALID uniqueidentifier
      DECLARE @TARGETFUNDRAISINGGOAL money

            SELECT @APPEALID = APPEALID from dbo.EVENT (NOLOCK) WHERE ID = @EVENTID

            IF @ROLETYPE = 0 AND @REGISTRANTID IS NOT NULL
            BEGIN

                SELECT @REGISTRANTCONSTITUENTID = CONSTITUENTID from dbo.REGISTRANT WHERE ID = @REGISTRANTID

                SELECT @GOAL = FUNDRAISINGGOAL from dbo.REGISTRANTEXTENSION WHERE REGISTRANTID = @REGISTRANTID
        SELECT @TARGETFUNDRAISINGGOAL= TARGETFUNDRAISINGGOAL from dbo.REGISTRANTEXTENSION WHERE REGISTRANTID = @REGISTRANTID


                SELECT    @MINIMIMUMFUNDRAISINGGOAL= FUNDRAISINGGOAL    
                FROM    REGISTRANT R  (NOLOCK)
                JOIN    REGISTRANTEXTENSION RE (NOLOCK) ON R.ID= RE.REGISTRANTID 
                WHERE    EVENTID= @EVENTID AND CONSTITUENTID= @REGISTRANTCONSTITUENTID

        SELECT @TOTALDONATION= DBO.UFN_REVENUE_GETPARTICIPANTRAISEDTOTAL (@REGISTRANTID, @EVENTID)
        SET @REGISTRANTRAISED= @TOTALDONATION
            END

            IF (@ROLETYPE <> 0) AND @TEAMFUNDRAISINGTEAMID IS NOT NULL
            BEGIN

                SELECT @GOAL = GOAL from dbo.TEAMFUNDRAISINGTEAM WHERE ID = @TEAMFUNDRAISINGTEAMID       
                select @TEAMCONSTITUENTID = TEAMCONSTITUENTID from dbo.TEAMEXTENSION (NOLOCK) WHERE TEAMFUNDRAISINGTEAMID = @TEAMFUNDRAISINGTEAMID

        ---just added roletype 2 (company). The exclusion was causing an issue where the target goal amount was set t

        IF @ROLETYPE= 1 OR @ROLETYPE= 2 OR @ROLETYPE= 3
          SELECT @TARGETFUNDRAISINGGOAL = GOAL from dbo.TEAMFUNDRAISINGTEAM WHERE ID = @TEAMFUNDRAISINGTEAMID   

          SELECT @TOTALDONATION = AMOUNTRAISED from dbo.UFN_FAF_GROUPTOTALSROLLUP(@EVENTID,@TEAMFUNDRAISINGTEAMID)

          SET @TEAMRAISED= @TOTALDONATION

                /*IF (@ROLETYPE= 3)
          select    @MINIMIMUMFUNDRAISINGGOAL= T.[GOAL] 
                  from    dbo.TEAMEXTENSION TE        (NOLOCK)  
                  JOIN      dbo.TEAMFUNDRAISINGTEAM T    (NOLOCK)    ON TE.TEAMFUNDRAISINGTEAMID = T.ID  
                  WHERE      EVENTID= @EVENTID  AND TE.TEAMFUNDRAISINGTEAMID = @TEAMFUNDRAISINGTEAMID AND TE.TYPECODE= 3
          */
            END

            /*IF (@ROLETYPE= 2) AND @TEAMFUNDRAISINGTEAMID IS NOT NULL
            BEGIN

                SELECT @GOAL = GOAL from dbo.TEAMFUNDRAISINGTEAM WHERE ID = @TEAMFUNDRAISINGTEAMID         
                select @TEAMCONSTITUENTID = TEAMCONSTITUENTID from dbo.TEAMEXTENSION (NOLOCK) WHERE TEAMFUNDRAISINGTEAMID = @TEAMFUNDRAISINGTEAMID

        SELECT @TARGETFUNDRAISINGGOAL = GOAL from dbo.TEAMFUNDRAISINGTEAM WHERE ID = @TEAMFUNDRAISINGTEAMID                 


        SELECT @TOTALDONATION= DBO.UFN_REVENUE_GETCOMPANYRAISEDTOTAL (@TEAMFUNDRAISINGTEAMID, @EVENTID)
        SET @TEAMRAISED= @TOTALDONATION
            END*/

            SELECT    
            ISNULL(@TOTALDONATION,0) AS TOTALDONATION, 
                      ISNULL(@GOAL,0) as FUNDRAISINGGOAL,
                    ISNULL(@REGISTRANTRAISED,0) as REGISTRANTRAISED, 
                      ISNULL(@TEAMRAISED,0) AS TEAMRAISED,
                    ISNULL(@MINIMIMUMFUNDRAISINGGOAL,0) as MINIMIMUMFUNDRAISINGGOAL,
            ISNULL(@TARGETFUNDRAISINGGOAL,0) as TARGETFUNDRAISINGGOAL

        END