UFN_RECURRINGGIFT_GETMISSEDINSTALLMENTSCOUNT

Returns the number of missed installments for a given recurring gift as of the given date.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN
@ASOFDATE	datetime	IN

Definition

Copy



            CREATE function dbo.UFN_RECURRINGGIFT_GETMISSEDINSTALLMENTSCOUNT(
                @REVENUEID uniqueidentifier, 
                @ASOFDATE datetime
            ) 
            returns int
            begin

                declare @RETVAL int = 0;

                declare @ENDDATE datetime=dbo.UFN_DATE_GETEARLIESTTIME(
                    case
                        when @ASOFDATE < getdate()
                            then @ASOFDATE
                        else getdate()
                    end
                );

                select @RETVAL = count(ID) 
                from RECURRINGGIFTINSTALLMENT
                where REVENUEID=@REVENUEID
                    and DATE <= @ENDDATE
                    and dbo.UFN_RECURRINGGIFTINSTALLMENT_GETINSTALLMENTBALANCE(ID) = TRANSACTIONAMOUNT;

        select @RETVAL = @RETVAL + count(ID)
        from REVENUE R
        cross apply dbo.UFN_RECURRINGGIFT_GETMISSINGINSTALLMENTS(R.ID) I
        where R.ID = @REVENUEID
        and I.DATE <= @ENDDATE;

                return @RETVAL;
            end