USP_DATALIST_CAMPAIGNNAMINGOPPORTUNITY

This datalist returns all of the naming opportunities associated with designations associated with a campaign.

Parameters

Parameter	Parameter Type	Mode	Description
@CAMPAIGNID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@FACILITYID	uniqueidentifier	IN	Facility
@UNITCODEID	uniqueidentifier	IN	Unit
@INCLUDEUNAVAILABLE	bit	IN	Include unavailable
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_CAMPAIGNNAMINGOPPORTUNITY (
                        @CAMPAIGNID uniqueidentifier,
                        @FACILITYID uniqueidentifier = null,
                        @UNITCODEID uniqueidentifier = null,
                        @INCLUDEUNAVAILABLE bit = 0,
                        @CURRENTAPPUSERID uniqueidentifier = null
                    ) as begin

                        select
                            NAMINGOPPORTUNITY.ID,
                            NAMINGOPPORTUNITY.NAME,
                            NAMINGOPPORTUNITY.MINIMUMAMOUNT,
                            dbo.UFN_NAMINGOPPORTUNITYTYPECODE_GETDESCRIPTION(NAMINGOPPORTUNITY.NAMINGOPPORTUNITYTYPECODEID) [TYPE],
                            dbo.UFN_NAMINGOPPORTUNITYAREACODE_GETDESCRIPTION(NAMINGOPPORTUNITYFACILITY.AREACODEID) [AREA],
                            dbo.UFN_NAMINGOPPORTUNITYUNITCODE_GETDESCRIPTION(NAMINGOPPORTUNITYFACILITY.UNITCODEID) [UNIT],
                            NAMINGOPPORTUNITYFACILITY.NAME,
                            NAMINGOPPORTUNITY.QUANTITY,
                            NAMINGOPPORTUNITY.REMAINING,
                            (select count(distinct PROSPECTID) from dbo.UFN_NAMINGOPPORTUNITY_ALLPROSPECTS(NAMINGOPPORTUNITY.ID)) as PROSPECTCOUNT,
                            NAMINGOPPORTUNITY.BASECURRENCYID
                        from
                            dbo.NAMINGOPPORTUNITY
                        left outer join
                            dbo.NAMINGOPPORTUNITYFACILITY on NAMINGOPPORTUNITY.FACILITYID = NAMINGOPPORTUNITYFACILITY.ID
                        where
                            (@CAMPAIGNID = NAMINGOPPORTUNITY.CAMPAIGNID)
                        and
                            (@FACILITYID is null or NAMINGOPPORTUNITY.FACILITYID = @FACILITYID)
                        and
                            (@UNITCODEID is null or NAMINGOPPORTUNITYFACILITY.UNITCODEID = @UNITCODEID)
                        and
                            (@INCLUDEUNAVAILABLE = 1 or NAMINGOPPORTUNITY.REMAINING > 0)
                        and
                            dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, dbo.UFN_SITEID_MAPFROM_NAMINGOPPORTUNITYID(NAMINGOPPORTUNITY.ID)) = 1
                    end