UFN_TICKET_GETSCANCOUNTBYDATEANDPROGRAM

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode
@FROMDATE	date	IN
@TODATE	date	IN
@PROGRAMID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN
@PRICETYPECODEID	uniqueidentifier	IN
@DATEADDED	date	IN

Definition

Copy



CREATE function dbo.UFN_TICKET_GETSCANCOUNTBYDATEANDPROGRAM(@FROMDATE date, @TODATE date, @PROGRAMID uniqueidentifier, @EVENTID uniqueidentifier, @PRICETYPECODEID uniqueidentifier, @DATEADDED date)
returns integer
with execute as caller
as
begin

return
( 
    select 
        count(TICKET.ID) as TICKETCOUNT
    from
        dbo.TICKET
    inner join 
        dbo.SALESORDERITEM on TICKET.SALESORDERITEMTICKETID = SALESORDERITEM.ID
    where 
        convert(date, TICKET.SCANDATEWITHTIMEOFFSET) between @FROMDATE and @TODATE
        and 
        (
            (TICKET.PROGRAMID = @PROGRAMID and @EVENTID is null)
            or (TICKET.EVENTID = @EVENTID and @PROGRAMID is null)  
        ) 
        and TICKET.PRICETYPECODEID = @PRICETYPECODEID
        and (convert(date, SALESORDERITEM.DATEADDED) = @DATEADDED or @DATEADDED is null)
        and TICKET.STATUSCODE <> 2
)
end