USP_DATAFORMTEMPLATE_VIEW_BATCHTICKETPRINTJOBSUMMARY

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BATCHTICKETPRINTJOBSUMMARY
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @PRINTDATE datetime = null output,
    @TICKETCOUNT int = null output,
    @PRINTERNAME nvarchar(255) = null output,
    @DOCUMENTNAME nvarchar(100) = null output,
    @APPUSERDISPLAYNAME nvarchar(255) = null output,
    @ISPRINTED bit = null output,
    @USERGRANTEDBATCHTICKETPRINTJOBMARKASPRINTED bit = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @PRINTDATE = BATCHTICKETPRINTJOB.PRINTDATEWITHTIMEOFFSET,
        @TICKETCOUNT = (select count(*) from dbo.BATCHTICKETPRINTJOBTICKETLINK where BATCHTICKETPRINTJOBTICKETLINK.BATCHTICKETPRINTJOBID = BATCHTICKETPRINTJOB.ID),
        @PRINTERNAME = BATCHTICKETPRINTJOB.PRINTERNAME,
        @DOCUMENTNAME = DOCUMENT.NAME,
        @APPUSERDISPLAYNAME = APPUSER.DISPLAYNAME,
        @ISPRINTED = BATCHTICKETPRINTJOB.ISPRINTED
    from
        dbo.BATCHTICKETPRINTJOB
    left outer join
        dbo.DOCUMENT on DOCUMENT.ID = BATCHTICKETPRINTJOB.DOCUMENTID
    left outer join
        dbo.APPUSER on APPUSER.ID = BATCHTICKETPRINTJOB.APPUSERID
    where
        BATCHTICKETPRINTJOB.ID = @ID;

    if @DATALOADED = 1
    begin
        if dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1
            set @USERGRANTEDBATCHTICKETPRINTJOBMARKASPRINTED = 1;
        else
            set @USERGRANTEDBATCHTICKETPRINTJOBMARKASPRINTED = dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID, 'a62f91cb-1e0b-4673-a59c-155eaa8fdb4f');
    end

    return 0;