USP_REPORT_DESIGNATIONLEVELREVENUE

Returns the data necessary for the Designation Level Revenue report.

Parameters

Parameter	Parameter Type	Mode
@IDSETID	uniqueidentifier	IN
@START	datetime	IN
@END	datetime	IN
@CATEGORYCODEID	uniqueidentifier	IN
@DESIGNATIONLEVELTYPEID	uniqueidentifier	IN
@GROUPBY	tinyint	IN
@CAMPAIGNID	uniqueidentifier	IN
@REPORTUSERID	nvarchar(128)	IN
@CURRENCYCODE	tinyint	IN
@ALTREPORTUSERID	nvarchar(128)	IN

Definition

Copy



            CREATE procedure dbo.USP_REPORT_DESIGNATIONLEVELREVENUE
                (
                    @IDSETID uniqueidentifier = null,
                    @START datetime = null,
                    @END datetime = null,
                    @CATEGORYCODEID uniqueidentifier = null,
                    @DESIGNATIONLEVELTYPEID uniqueidentifier = null,
                    @GROUPBY tinyint = 0,
                    @CAMPAIGNID uniqueidentifier = null,
                    @REPORTUSERID nvarchar(128) = null,
                    @CURRENCYCODE tinyint = 0,
                    @ALTREPORTUSERID nvarchar(128) = null
                )
            as    
                begin
                    set @START = dbo.UFN_DATE_GETEARLIESTTIME(@START);
                    set @END = dbo.UFN_DATE_GETLATESTTIME(@END);

                    if @END < @START
                        raiserror('The start date must be on or before the end date.',13,1);                        

                    set @GROUPBY = @GROUPBY - 1

                    declare @CAMPAIGNHIERARCHYPATH hierarchyid
                    select @CAMPAIGNHIERARCHYPATH = HIERARCHYPATH
                    from CAMPAIGN
                    where ID=@CAMPAIGNID;

                    declare @CURRENTAPPUSERID uniqueidentifier = dbo.UFN_APPUSER_GETREPORTAPPUSERID(@REPORTUSERID, @ALTREPORTUSERID);

                    if @GROUPBY = 0
                        exec dbo.USP_REPORT_DESIGNATIONLEVELREVENUE_BYPURPOSE_2 @START, @END, @CATEGORYCODEID, @DESIGNATIONLEVELTYPEID, @GROUPBY, @IDSETID,@CAMPAIGNHIERARCHYPATH, @CURRENTAPPUSERID, @CURRENCYCODE;
                    else
                        if @GROUPBY > 3 
                            begin
                            set @GROUPBY = @GROUPBY - 4;
                            exec dbo.USP_REPORT_DESIGNATIONLEVELREVENUE_BYAPPEAL_2 @START, @END, @CATEGORYCODEID, @DESIGNATIONLEVELTYPEID, @GROUPBY, @IDSETID    ,@CAMPAIGNHIERARCHYPATH, @CURRENTAPPUSERID, @CURRENCYCODE;
                            end
                        else
                            exec dbo.USP_REPORT_DESIGNATIONLEVELREVENUE_BYDATE_2 @START, @END, @CATEGORYCODEID, @DESIGNATIONLEVELTYPEID, @GROUPBY, @IDSETID,@CAMPAIGNHIERARCHYPATH, @CURRENTAPPUSERID, @CURRENCYCODE;
                end