UFN_CONFLICTCHECK_GETCONFLICTITEMS

Returns items in conflict for locations, resources, and staff resources

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@START	datetime	IN
@END	datetime	IN
@LOCATIONS	xml	IN
@RESOURCES	xml	IN
@STAFFRESOURCES	xml	IN
@SUPERRECORDID	uniqueidentifier	IN
@RECORDID	uniqueidentifier	IN
@SUBRECORDID	uniqueidentifier	IN
@IGNORESUPERRECORD	bit	IN
@IGNORERECORD	bit	IN
@IGNORESUBRECORD	bit	IN
@IGNORERECORDSUBRECORDS	bit	IN
@OFFSETRESOURCES	xml	IN
@OFFSETSTAFFRESOURCES	xml	IN

Definition

Copy



        create function dbo.UFN_CONFLICTCHECK_GETCONFLICTITEMS
        (
            @START datetime,
            @END datetime,
            @LOCATIONS xml,
            @RESOURCES xml,
            @STAFFRESOURCES xml,
            @SUPERRECORDID uniqueidentifier = null,
            @RECORDID uniqueidentifier = null,
            @SUBRECORDID uniqueidentifier = null,
            @IGNORESUPERRECORD bit = 1,
            @IGNORERECORD bit = 1,
            @IGNORESUBRECORD bit = 1,
            @IGNORERECORDSUBRECORDS bit = 1,
            @OFFSETRESOURCES xml = null,
            @OFFSETSTAFFRESOURCES xml = null
        )
        returns @CONFLICTITEMS table
        (
            EVENTID uniqueidentifier,
            ITINERARYITEMID uniqueidentifier,
            ITINERARYID uniqueidentifier,
            LOCATIONID uniqueidentifier,
            RESOURCEID uniqueidentifier,
            VOLUNTEERTYPEID uniqueidentifier,
            QUANTITYNEEDED int
        )
        as 
        begin
            insert into @CONFLICTITEMS
            (
                EVENTID,
                ITINERARYITEMID,
                LOCATIONID
            )
            select
                EVENTID,
                ITINERARYITEMID,
                LOCATIONID
            from dbo.UFN_CONFLICTCHECK_GETLOCATIONCONFLICTS
                (@START, @END, @LOCATIONS, @SUPERRECORDID, @RECORDID, @SUBRECORDID, 
                @IGNORESUPERRECORD, @IGNORERECORD, @IGNORESUBRECORD, @IGNORERECORDSUBRECORDS)

            insert into @CONFLICTITEMS
            (
                EVENTID,
                ITINERARYITEMID,
                ITINERARYID,
                RESOURCEID,
                QUANTITYNEEDED
            )
            select
                EVENTID,
                ITINERARYITEMID,
                ITINERARYID,
                RESOURCEID,
                QUANTITYNEEDED
            from dbo.UFN_CONFLICTCHECK_GETRESOURCECONFLICTS
                (@START, @END, @RESOURCES, @OFFSETRESOURCES, @SUPERRECORDID, @RECORDID, @SUBRECORDID, 
                @IGNORESUPERRECORD, @IGNORERECORD, @IGNORESUBRECORD, @IGNORERECORDSUBRECORDS)

            insert into @CONFLICTITEMS
            (
                EVENTID,
                ITINERARYITEMID,
                ITINERARYID,
                VOLUNTEERTYPEID,
                QUANTITYNEEDED
            )
            select
                EVENTID,
                ITINERARYITEMID,
                ITINERARYID,
                VOLUNTEERTYPEID,
                QUANTITYNEEDED
            from dbo.UFN_CONFLICTCHECK_GETSTAFFRESOURCECONFLICTS
                (@START, @END, @STAFFRESOURCES, @OFFSETSTAFFRESOURCES, @SUPERRECORDID, @RECORDID, @SUBRECORDID, 
                @IGNORESUPERRECORD, @IGNORERECORD, @IGNORESUBRECORD, @IGNORERECORDSUBRECORDS)


    return;
end