spTransactions_GetUnprocessedIDs

Parameters

Parameter	Parameter Type	Mode
@ClientID	int	IN
@Signups	int	INOUT
@EventRegs	int	INOUT
@ProfileUpdates	int	INOUT
@Donations	int	INOUT
@PollResults	int	INOUT
@Memberships	int	INOUT
@CapWizTrans	int	INOUT
@FundRaiserTrans	int	INOUT
@CarePageTrans	int	INOUT
Definition

Copy

                CREATE   PROCEDURE [dbo].[spTransactions_GetUnprocessedIDs](@ClientID int, @Signups int out ,@EventRegs int out,@ProfileUpdates int out, @Donations int out, @PollResults int out, @Memberships int out, @CapWizTrans int out, @FundRaiserTrans int out, @CarePageTrans int out)
                    as

                    select SignupTransactionsID 'TransID' from dbo.SignupTransactions where processed_date is null
                    and ClientsID=@ClientID and IsDeleted=0

                    select ProfileUpdateTransactionsID 'TransID' from dbo.ProfileUpdateTransactions where processed_date is null
                    and ClientsID=@ClientID  and IsDeleted=0 And Not BackOfficeID is null

                    select EventTransactionsID 'TransID' from fnTransactions_GetUnprocessedEventRegsForClient(@ClientID)

                    select DonationTransactionsID 'TransID' from fnTransactions_GetUnprocessedGiftsForClient(@ClientID)

                    select spr.ID 'TransID' from dbo.SitePollResults spr
                    inner join dbo.SitePollAnswers [spa] on [spr].SitePollAnswersID=[spa].ID
                    inner join dbo.SitePolls [sp] on [spa].SitePollsID=[sp].ID
                    inner join dbo.SiteContent [sc] on [sp].ID=[sc].ID
                    inner join dbo.ClientSites [cs] on [sc].ClientSitesID=[cs].ID
                    where spr.processed_date is null --and sp.Closed=0 and sc.ExpireDate > getutcdate()
                    and cs.ClientsID=@ClientID  

                    Select mt.ID 'TransID' from dbo.MembershipTransactions mt
                    inner join dbo.ClientMemberships cm on mt.ClientMembershipsID=cm.ID
                    inner join dbo.SiteContent [sc] on [cm].SiteContentID=[sc].ID
                    inner join dbo.ClientSites [cs] on [sc].ClientSitesID=[cs].ID
                    where mt.processed_date is null and mt.IsDeleted=0 and mt.Status = 1
                    and cs.ClientsID=@ClientID 

                    select CapWizTransactionsID 'TransID'  from dbo.CapWizTransactions where ProcessedDate is null
                    and ClientsID=@ClientID and IsDeleted=0

                    select ID 'TransID' from dbo.fnTransactions_GetUnprocessedFundRaisers(@ClientID)

                    select ID 'TransID' from dbo.fnTransactions_GetUnprocessedCarePages(@ClientID)