USP_DATALIST_GETCONTACTMONEYRAISED

CREATE procedure dbo.USP_DATALIST_GETCONTACTMONEYRAISED
(
    @EVENTID uniqueidentIFier = NULL,
    @ADDRESSBOOKID uniqueidentIFier = NULL
)
as
  set nocount on;
 -- get goal and money

  Select
        Goal =  IsNull(RT.TARGETFUNDRAISINGGOAL, 0),
        REGISTRANTRAISED = 
           Case TS.TypeCode
              When 3 then 
                   Case When IsNull(TRC.ID, '00000000-0000-0000-0000-000000000000') = '00000000-0000-0000-0000-000000000000'  then IsNull(dbo.UFN_REVENUE_GETPARTICIPANTRAISEDTOTAL(R.ID, @EVENTID), 0)
                   Else Isnull(dbo.UFN_REVENUE_GETHOUSEHOLDRAISEDTOTAL(TS.TEAMFUNDRAISINGTEAMID, @EVENTID), 0)
                 End
              Else IsNull(dbo.UFN_REVENUE_GETPARTICIPANTRAISEDTOTAL(R.ID, @EVENTID), 0)
           End
   FROM 
        [dbo].AddressbookFAF A
              INNER JOIN [dbo].REGISTRANT R (NOLOCK) ON A.ConstituentID = R.ConstituentID
              INNER JOIN [dbo].TEAMFUNDRAISER TR
                 ON TR.ConstituentID = R.CONSTITUENTID
              INNER JOIN dbo.TEAMFUNDRAISINGTEAMMEMBER TM
                 ON TR.ID = TM.TEAMFUNDRAISERID
              INNER JOIN dbo.TEAMFUNDRAISINGTEAM T
                 ON TM.TEAMFUNDRAISINGTEAMID = T.ID
              INNER JOIN [dbo].TEAMEXTENSION TS
                 ON TS.TEAMFUNDRAISINGTEAMID = T.ID
              INNER JOIN [dbo].REGISTRANTEXTENSION RT
                 ON RT.RegistrantID = R.ID
              LEFT JOIN [dbo].TEAMFUNDRAISINGTEAMCAPTAIN TRC
                 ON TRC.CONSTITUENTID = R.CONSTITUENTID
    WHERE A.ID = @ADDRESSBOOKID