USP_DATAFORMTEMPLATE_WEALTHSUMMARY_GIVING

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	INOUT
@NPHILANTHROPICGIFT	int	INOUT
@C_NPHILANTHROPICGIFT	int	INOUT
@NPOLITICALDONATION	int	INOUT
@C_NPOLITICALDONATION	int	INOUT
@GIFTSTOMYORG	int	INOUT
@ENTERPRISE_FLAG	bit	INOUT
@NEWPHILANTHROPICGIFTS	bit	INOUT
@NEWPOLITICALDONATIONS	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_WEALTHSUMMARY_GIVING
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CURRENTAPPUSERID uniqueidentifier,

  @CONSTITUENTID uniqueidentifier = null output,

    @NPHILANTHROPICGIFT integer = null output,
    @C_NPHILANTHROPICGIFT integer = null output,

    @NPOLITICALDONATION integer = null output,
    @C_NPOLITICALDONATION integer = null output,

    @GIFTSTOMYORG integer = null output,

    @ENTERPRISE_FLAG bit = null output,

    @NEWPHILANTHROPICGIFTS       bit = null output,
    @NEWPOLITICALDONATIONS    bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    declare @CHANGEAGENTID uniqueidentifier;
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    select
        @DATALOADED = 1,
    @CONSTITUENTID = ID
    from
        dbo.CONSTITUENT
    where
        CONSTITUENT.ID = @ID;

    select
        @NPHILANTHROPICGIFT = PHILANTHROPICGIFTNUMBER,
        @C_NPHILANTHROPICGIFT = PHILANTHROPICGIFTNUMBERCONFIRMED,
        @NPOLITICALDONATION = POLITICALDONATIONNUMBER,
        @C_NPOLITICALDONATION = POLITICALDONATIONNUMBERCONFIRMED
    from 
        dbo.WEALTH
    where
        WEALTH.ID = @ID

    select
        @GIFTSTOMYORG = TOTALGIFTSGIVEN
    from
        dbo.RE7INTEGRATIONGIVINGSUMMARY
    where 
        RE7INTEGRATIONGIVINGSUMMARY.ID = @ID

    set @ENTERPRISE_FLAG = 0;
    Select @ENTERPRISE_FLAG = 1 from INSTALLEDPRODUCTLIST where ID='3117D2C8-7F46-42F2-ABEB-B654F2F63046'

    set @NEWPHILANTHROPICGIFTS       = (select count(ID) from dbo.WPPHILANTHROPICGIFT        where WEALTHID=@ID and VIEWED = 0);
    if @NEWPHILANTHROPICGIFTS = 1
          update 
                      dbo.WPPHILANTHROPICGIFT
          set
                      VIEWED = 1,
                      CHANGEDBYID = @CHANGEAGENTID,
                      DATECHANGED = @CURRENTDATE
          where
                      VIEWED = 0 and
                      WEALTHID = @ID;
  set @NEWPOLITICALDONATIONS    = (select count(ID) from dbo.WPPOLITICALDONATION    where WEALTHID=@ID and VIEWED = 0); 
    if @NEWPOLITICALDONATIONS = 1
          update 
                      dbo.WPPOLITICALDONATION
          set
                      VIEWED = 1,
                      CHANGEDBYID = @CHANGEAGENTID,
                      DATECHANGED = @CURRENTDATE
          where
                      VIEWED = 0 and
                      WEALTHID = @ID;

    return 0;