24/06/2024 10:06:00.1412  1350 ms.           OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType
24/06/2024 10:21:30.7468   620 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-06-24 10:21:30' where payTraUID = 4899148082680080 and payStatus='V' and payEnabled=1
24/06/2024 11:14:00.7884   586 ms.           EXEC: update paycash set casCreation = '2024-06-24 11:14:00',casModify = '2024-06-24 11:14:00',casUseId=0,casStatus='V' where casId = 170575
24/06/2024 11:30:30.9800   670 ms.           EXEC: update payReceipt set recCreation = '2024-06-24 11:30:30',recModify = '2024-06-24 11:30:30',recUseId=0,recStatus='V' where recId = 275576
24/06/2024 12:52:34.7901   670 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5007007833948600,5518454442050110,2024,'2024-06-24 12:52:34','
Data:    6/24/2024 12:49:06 PM

Codice:  454654075500327005012999
Ingresso:  6/24/2024 11:19:15 AM
Targa:                        
Categoria:                Cars
Area:                 The Mall
Varco:                 Entry 2
______________________________
Da Pagare:          100.00 KES
______________________________
Pagato:             100.00 KES
                    __________
Resto:                0.00 KES

Tipo:                 Contanti
Pagato su:    Manual Cashier 2


# 2400604249
',0)
24/06/2024 13:35:35.4423   640 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4755303912623730,4685721931636500,2024,'2024-06-24 13:35:34','
Date:     6/24/2024 1:35:34 PM

Code:  454654802600327005012999
Entry Date:  6/24/2024 1:20:26 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


# 2400728356
',0)
24/06/2024 14:41:54.9495   513 ms.           EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-06-24 14:41:54','0230003944406',0,0,5284163319625750,17,'0000-00-00 00:00:00','0000-00-00 00:00:00')
24/06/2024 15:24:39.0002   660 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-06-24 15:24:37',3,42101,0,50,-1,-50,1,'O','N');
update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N';

24/06/2024 15:24:50.1010   520 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 (WAIT TIME 9 ms.)
24/06/2024 17:26:40.5737   570 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
24/06/2024 19:32:04.4754   650 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