20/04/2024 11:05:22.8389  1187 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 = 12 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
20/04/2024 11:05:38.8720  1234 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
20/04/2024 11:08:38.2885   546 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
20/04/2024 12:53:39.5764   593 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-20 12:53:38','V',5121286566385100,2024,'2024-04-20 12:53:37','454004641700327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0)
20/04/2024 13:41:34.3577   531 ms.           EXEC: update payInventory set invCreation = '2024-04-20 13:41:33',invModify = '2024-04-20 13:41:33',invUseId=0,invStatus='V' where invId = 179686
20/04/2024 14:15:49.2201   781 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-04-20 14:15:48' where traUID = 5150345644772420 and traStatus='V' and traEnabled=1
20/04/2024 14:33:59.7762   562 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
20/04/2024 15:34:36.5735   609 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-04-20 15:34:35',0,0,'V',5063583474052830,5588780447598780,2024,'2024-04-20 15:34:35',3,'KES',1,100,100,'N','');

20/04/2024 15:36:04.6328   546 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5153221302263970,4746945556001100,2024,'2024-04-20 15:36:04','
Date:     4/20/2024 3:36:03 PM

Code:  454005260400327005012999
Entry Date:  4/20/2024 2:36:44 PM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:               50.00 KES
______________________________
Paid:                50.00 KES
                    __________
Change:               0.00 KES

Type:                     Cash
Dispozitiv:              MPESA


# 2400717516
',0)
20/04/2024 15:51:41.9404   578 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
20/04/2024 17:22:01.7261   578 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
20/04/2024 20:46:47.0903   734 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-04-20 20:46:46' where payTraUID = 4795239044987790 and payStatus='V' and payEnabled=1
20/04/2024 22:05:51.4377   578 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 = 9 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