USP_DATALIST_CREDITCARDPROCESSING

Returns a list of saved parameter sets for the Credit Card Processing business process.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEFILTERMODE	tinyint	IN
@SITESSELECTED	xml	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



CREATE procedure dbo.USP_DATALIST_CREDITCARDPROCESSING
(
        @CURRENTAPPUSERID uniqueidentifier,
        @SITEFILTERMODE tinyint = 0,
        @SITESSELECTED xml = null,
        @SECURITYFEATUREID uniqueidentifier = null,
        @SECURITYFEATURETYPE tinyint = null
)
as
set nocount on

declare @BASICGL bit
set @BASICGL = dbo.UFN_VALID_BASICGL_INSTALLED()

select
    [PROCESS].ID,
    [PROCESS].NAME,
    [PROCESS].DESCRIPTION,
    BATCH.BATCHNUMBER,
    BPI.OWNERID,
    case 
        when exists (select * from dbo.UFN_CREDITCARDPROCESSING_GETRESUMEINFO(BATCH.ID)) then cast(1 as bit)
        else cast(0 as bit)
    end WILLRESUME,
    coalesce(SITE.NAME,'All Sites') SITES
from dbo.CREDITCARDPROCESSING as [PROCESS]
left join dbo.BATCH on BATCH.ID = [PROCESS].BATCHID
left join dbo.BUSINESSPROCESSINSTANCE BPI on [PROCESS].ID = BPI.BUSINESSPROCESSPARAMETERSETID
left join dbo.SITE on SITE.ID = BPI.SITEID
where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, [PROCESS].ID) = 1)
    and (@BASICGL=0 or [PROCESS].PDACCOUNTSYSTEMID is null or [PROCESS].PDACCOUNTSYSTEMID in (select ID from dbo.UFN_PDACCOUNTSYSTEM_GETSYSTEMIDSFORUSER(@CurrentAppUserID)))
    and (
                                        (
                                             (--Check site security

                                                         select count(1) 
                                                         from dbo.UFN_BUSINESSPROCESSPARAMETERSET_GETSITES([PROCESS].ID) as CREDITCARDPROCESSSITE 
                                                         where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[CREDITCARDPROCESSSITE].[SITEID] or (SITEID is null and [CREDITCARDPROCESSSITE].[SITEID] is null)))
                                        ) > 0
                                )
                                and (--Apply site filter

                                        @SITEFILTERMODE = 0
                                                or BPI.SITEID in (
                                                        select SITEID
                                                        from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED) 
                                                )
                                )
                        )
    order by [PROCESS].NAME