UFN_ORDER_GETTICKETSTOPRINT

Gets all generated non refunded tickets on an order to print or reprint.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ORDERID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_ORDER_GETTICKETSTOPRINT(@ORDERID uniqueidentifier)
                returns table
                as return
                    select T.ID, 
                        T.[PRINT],
                        T.NAME,
                        T.EVENTDATE,
                        T.EVENTTIME,
                        T.PRINTCOUNT,
                        T.PRINTCOUNT HIDDENPRINTCOUNT,
                        T.BARCODE                        
                    from dbo.UFN_ORDER_GETTICKETS(@ORDERID) T inner join dbo.TICKET on
            T.ID = TICKET.ID
          where
            TICKET.STATUSCODE not in (2 , 3)  --refunded, exchanged