USP_DATALIST_CONSTITUENTPROFILEDASHBOARDRECOGNITIONSUMMARY

This datalist returns recognition summary information that is used by the constituent profile dashboard.
Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@ISVISIBLE	bit	IN	Visible
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SELECTEDCURRENCYID	uniqueidentifier	IN	Selected currency ID
Definition

Copy


                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDRECOGNITIONSUMMARY
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1,
                        @CURRENTAPPUSERID uniqueidentifier = null,
                        @SELECTEDCURRENCYID uniqueidentifier = null
                    )
                    as
                        set nocount on;

                        if @ISVISIBLE = 1
                        begin
                            declare    @TOTALNUMBER int
                            declare    @TOTALAMOUNT money
                            declare    @AVERAGEAMOUNT money 
                            declare    @MOSTFREQUENTAMOUNT money 
                            declare    @TOTALYEARS int 
                            declare    @CONSECUTIVEYEARS int 
                            declare    @GIVENSINCEFISCALYEAR datetime
                            declare @TOTALRECOGNITIONWITHGIFTAID money

                            -- Only applicable for groups

                            declare @TOTALGROUPAMOUNT money
                            declare @TOTALGROUPMEMBERAMOUNT money

                            declare @ISGROUP bit
                            select @ISGROUP = ISGROUP
                            from dbo.CONSTITUENT where ID = @CONSTITUENTID;

                            if @ISGROUP = 1
                            begin
                                exec dbo.USP_GROUP_RECOGNITIONSUMMARYGET
                                    @CONSTITUENTID,
                                    @RECOGNITIONTOTALNUMBER = @TOTALNUMBER output,
                                    @RECOGNITIONTOTALAMOUNT = @TOTALAMOUNT output,
                                    @RECOGNITIONTOTALGROUPAMOUNT = @TOTALGROUPAMOUNT output,
                                    @RECOGNITIONTOTALGROUPMEMBERAMOUNT = @TOTALGROUPMEMBERAMOUNT output,
                                    @RECOGNITIONAVERAGEAMOUNT = @AVERAGEAMOUNT output,
                                    @RECOGNITIONMOSTFREQUENTAMOUNT = @MOSTFREQUENTAMOUNT output,
                                    @RECOGNITIONTOTALYEARS = @TOTALYEARS output,
                                    @RECOGNITIONCONSECUTIVEYEARS = @CONSECUTIVEYEARS output,
                                    @RECOGNITIONGIVENSINCEFISCALYEAR = @GIVENSINCEFISCALYEAR output,
                                    @CURRENTAPPUSERID = @CURRENTAPPUSERID,
                                    @CURRENCYID = @SELECTEDCURRENCYID;                                
                            end
                            else
                            begin
                                exec dbo.USP_CONSTITUENT_RECOGNITIONSUMMARYGET
                                    @CONSTITUENTID,
                                    @RECOGNITIONTOTALNUMBER = @TOTALNUMBER output,
                                    @RECOGNITIONTOTALAMOUNT = @TOTALAMOUNT output,
                                    @RECOGNITIONAVERAGEAMOUNT = @AVERAGEAMOUNT output,
                                    @RECOGNITIONMOSTFREQUENTAMOUNT = @MOSTFREQUENTAMOUNT output,
                                    @RECOGNITIONTOTALYEARS = @TOTALYEARS output,
                                    @RECOGNITIONCONSECUTIVEYEARS = @CONSECUTIVEYEARS output,
                                    @RECOGNITIONGIVENSINCEFISCALYEAR = @GIVENSINCEFISCALYEAR output,
                                    @CURRENTAPPUSERID = @CURRENTAPPUSERID,
                                    @TOTALRECOGNITIONWITHGIFTAID = @TOTALRECOGNITIONWITHGIFTAID output,
                                    @CURRENCYID = @SELECTEDCURRENCYID;
                            end

                            select 
                                @TOTALNUMBER TOTALNUMBER,
                                @TOTALAMOUNT TOTALAMOUNT,
                                @AVERAGEAMOUNT AVERAGEAMOUNT,
                                @MOSTFREQUENTAMOUNT MOSTFREQUENTAMOUNT,
                                @TOTALYEARS TOTALYEARS,
                                @CONSECUTIVEYEARS CONSECUTIVEYEARS,
                                @GIVENSINCEFISCALYEAR GIVENSINCEFISCALYEAR,
                                @TOTALGROUPAMOUNT TOTALGROUPAMOUNT,
                                @TOTALGROUPMEMBERAMOUNT TOTALGROUPMEMBERAMOUNT,
                                @TOTALRECOGNITIONWITHGIFTAID TOTALRECOGNITIONWITHGIFTAID
                        end