UFN_EVENTCONFLICT_GETSTAFFRESOURCECONFLICTS

Get all of the events that are in conflict with the given event conflict by staff resource.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@START	datetime	IN
@END	datetime	IN
@STAFFRESOURCES	xml	IN
@IGNORERECORDID	uniqueidentifier	IN
@IGNORESUBRECORDID	uniqueidentifier	IN
@INCLUDEEVENTCONFLICTS	bit	IN
@INCLUDEITINERARYITEMCONFLICTS	bit	IN
@INCLUDEITINERARYCONFLICTS	bit	IN

Definition

Copy



            CREATE function dbo.UFN_EVENTCONFLICT_GETSTAFFRESOURCECONFLICTS
            (
                @START datetime,
                @END datetime,
                @STAFFRESOURCES xml,
                @IGNORERECORDID uniqueidentifier = null,
                @IGNORESUBRECORDID uniqueidentifier = null,
                @INCLUDEEVENTCONFLICTS bit = 1,
                @INCLUDEITINERARYITEMCONFLICTS bit = 1,
                @INCLUDEITINERARYCONFLICTS bit = 1
            )
            returns @CONFLICTS TABLE
            (
                EVENTID uniqueidentifier,
                ITINERARYITEMID uniqueidentifier,
                ITINERARYID uniqueidentifier,
                STAFFRESOURCES nvarchar(500)
            )
            as
            begin 

                insert into @CONFLICTS
                    (EVENTID, ITINERARYITEMID, ITINERARYID, STAFFRESOURCES)
                select STAFFRESOURCECONFLICTDETAILS.EVENTID, STAFFRESOURCECONFLICTDETAILS.ITINERARYITEMID, STAFFRESOURCECONFLICTDETAILS.ITINERARYID, dbo.UDA_BUILDLIST(VOLUNTEERTYPE.NAME) + ': ' + cast(sum(STAFFRESOURCECONFLICTDETAILS.QUANTITYNEEDED) as nvarchar(20))
                from dbo.UFN_EVENTCONFLICT_GETSTAFFRESOURCECONFLICTDETAILS(@START, @END, @STAFFRESOURCES, @IGNORERECORDID, @IGNORESUBRECORDID, null, @INCLUDEEVENTCONFLICTS, @INCLUDEITINERARYITEMCONFLICTS, @INCLUDEITINERARYCONFLICTS, null) as STAFFRESOURCECONFLICTDETAILS
                    inner join dbo.VOLUNTEERTYPE
                        on STAFFRESOURCECONFLICTDETAILS.VOLUNTEERTYPEID = VOLUNTEERTYPE.ID
                group by STAFFRESOURCECONFLICTDETAILS.EVENTID, STAFFRESOURCECONFLICTDETAILS.ITINERARYITEMID, STAFFRESOURCECONFLICTDETAILS.ITINERARYID

                return;
            end