UFN_PLANNEDGIFT_GETTOTALAMOUNT

Returns the total amount of a planned gift with additions.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@PLANNEDGIFTID	uniqueidentifier	IN
@CURRENCYCODE	int	IN
@CURRENCYID	uniqueidentifier	IN

Definition

Copy



          CREATE function dbo.UFN_PLANNEDGIFT_GETTOTALAMOUNT
          (
            @PLANNEDGIFTID uniqueidentifier,
            @CURRENCYCODE int = 2,
            @CURRENCYID uniqueidentifier = null
          )
          returns money
          with execute as caller
          as begin 
            declare @AMOUNT as money

            select @AMOUNT = 
              case @CURRENCYCODE
                when 2 then PG.TRANSACTIONGIFTAMOUNT + sum(coalesce(PGA.TRANSACTIONGIFTAMOUNT,0))
                when 1 then PG.ORGANIZATIONGIFTAMOUNT + sum(coalesce(PGA.ORGANIZATIONGIFTAMOUNT,0))
                when 3 then  dbo.UFN_PLANNEDGIFTDESIGNATION_AMOUNTINCURRENCY(PG.ID, @CURRENCYID) + sum(coalesce(dbo.UFN_PLANNEDGIFTADDITIONDESIGNATION_AMOUNTINCURRENCY(PGA.ID, @CURRENCYID),0))
                else PG.GIFTAMOUNT + sum(coalesce(PGA.GIFTAMOUNT,0))
              end
            from dbo.PLANNEDGIFT PG
            left join dbo.PLANNEDGIFTADDITION PGA on PG.ID = PGA.PLANNEDGIFTID
            where PG.ID = @PLANNEDGIFTID
            group by PG.ID, PG.TRANSACTIONGIFTAMOUNT, PG.ORGANIZATIONGIFTAMOUNT, PG.GIFTAMOUNT

            return @AMOUNT
          end