22/04/2024 09:23:15.1781   609 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5458079627211800,5141523134430830,2024,'2024-04-22 09:23:14','
Date:     4/22/2024 9:24:59 AM

Code:  454023247700327005012999
Entry Date:  4/22/2024 9:01:17 AM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:               50.00 KES
______________________________
Paid:                50.00 KES
                    __________
Change:               0.00 KES

Type:              Credit Card
Dispozitiv:   Manual Cashier 1


# 2400405787
',0)
22/04/2024 11:07:32.8777   953 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-04-22 11:07:31','V',4628909076878260,2024,'2024-04-22 11:07:32','454023873600327005012999',2,2,2,'O','',0,'2024-04-22 11:07:31',1,'','',0)
22/04/2024 12:47:40.9586   531 ms.           EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-04-22 12:49:26',9,'V',4928769170747420,5446532800405830,2024,'2024-04-22 12:49:26',4,1,0,4,'2024-04-22 13:04:26','P','KES',100,100,0,'','','',1,100,0,0,'',0,0)
22/04/2024 14:28:13.3600   562 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-04-22 14:28:12' where traUID = 5209658311194450 and traStatus='V' and traEnabled=1
22/04/2024 16:15:52.8106  3203 ms.           EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-04-22 16:15:49',0,'V',5687696476243010,5361446243444390,2024,'2024-04-22 16:15:49',18,1,0,4,'2024-04-22 16:30:49','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
22/04/2024 16:35:10.2100  1031 ms.           OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType
22/04/2024 19:35:02.5165  3031 ms.           OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal
22/04/2024 20:39:48.4514   609 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-04-22 20:39:47','V',5490321191824910,2024,'2024-04-22 20:39:46','454026700300327005012999',2,2,2,'O','',0,'2024-04-22 20:39:47',1,'','0230003944081',15,0)
22/04/2024 20:58:35.5342   734 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 125 ms.)