USP_DATAFORMTEMPLATE_DATALIST_FUNDRAISERSUMMARYFUTURE

Fetches summary information for a fundraiser's outstanding asks.

Parameters

Parameter	Parameter Type	Mode	Description
@DATEFILTER	tinyint	IN
@FUNDRAISERID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_DATALIST_FUNDRAISERSUMMARYFUTURE(@DATEFILTER tinyint, @FUNDRAISERID uniqueidentifier)
                as begin
                    set nocount on;

                    declare @STARTDATE datetime;
                    declare @ENDDATE datetime;

                    exec dbo.USP_RESOLVEDATEFILTER @DATEFILTER, @STARTDATE output, @ENDDATE output;

                    declare @OUTSTANDINGASKSCOUNT int;
                    declare @OUTSTANDINGASKSAMOUNT money;

                    select
                        @OUTSTANDINGASKSCOUNT = count(*),
                        @OUTSTANDINGASKSAMOUNT = coalesce(sum(O.AMOUNT), 0)
                    from 
                        dbo.OPPORTUNITY O
                        inner join dbo.PROSPECTPLAN PP on PP.ID=O.PROSPECTPLANID
                    where
                        O.STATUSCODE=2 
                        and PP.PRIMARYMANAGERFUNDRAISERID=@FUNDRAISERID
                        and (O.RESPONSEDATE is null
                            or (O.RESPONSEDATE>=convert(nvarchar(8), getdate(), 112)
                            and O.RESPONSEDATE>=convert(nvarchar(8), @STARTDATE, 112) 
                            and O.RESPONSEDATE<=convert(nvarchar(8), @ENDDATE, 112))
                        );

                    select 
                        @OUTSTANDINGASKSCOUNT,
                        @OUTSTANDINGASKSAMOUNT

                    return 0;
                end