USP_DATALIST_CONSTITUENTPROFILEDASHBOARDGROUPGOALS

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

    if @ISVISIBLE = 1
    begin
        declare @CURRENTDATE datetime;
        set @CURRENTDATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate())

        select
            case
                when ISFUNDRAISINGGOAL = 1 then
                    FUNDRAISERTYPE
                else 
                    GGUC.DESCRIPTION
                end as UNIT, 
            GG.AMOUNT as GOAL,
            case 
                when ISFUNDRAISINGGOAL = 1 then
                    -- we no longer track progress for committee fundraising type goals outside of their respective KPI's 

                    null -- dbo.UFN_COMMITTEEPROFILE_FUNDRAISINGGOAL_GETPROGRESS(@CONSTITUENTID,GG.ID,GG.STARTDATE,GG.GOALDATE,GG.FUNDRAISERTYPE)

                else 
                    PROGRESS
                end PROGRESS, 
            GG.STARTDATE as STARTDATE,
            GG.GOALDATE as DATE,
            cast(GG.ISFUNDRAISINGGOAL as bit) as ISFUNDRAISINGGOAL,
            GG.DESCRIPTION as DESCRIPTION,
            GG.NAME as NAME
        from dbo.UFN_GROUPGOAL_DATALIST_WITHCURRENCY(@CONSTITUENTID, null, @SELECTEDCURRENCYID) GG
        left outer join dbo.GROUPGOALUNITCODE as GGUC on GG.GROUPGOALUNITCODEID = GGUC.ID
        order by GG.ISFUNDRAISINGGOAL desc, GG.GOALDATE, GG.AMOUNT
    end