21/09/2023 09:36:25.9534   888 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-21 09:36:20',5,3,42101,0,200,2,400,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-21 09:36:20',5,3,42101,0,100,2,200,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

21/09/2023 10:19:48.3902   538 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5491574608492380,4626287900481640,2023,'2023-09-21 10:19:47','
Date:    9/21/2023 10:19:47 AM

Code:  451883550000327005012999
Entry Date:  9/21/2023 9:51:40 AM
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


# 2300743953
',0)
21/09/2023 11:36:07.3783   729 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,'2023-09-21 11:36:06','V',5192117523001650,2023,'2023-09-21 11:36:06','451884023000327005012999',2,2,2,'O','',0,'2023-09-21 11:36:06',1,'','',0)
21/09/2023 14:19:36.3260   685 ms.           EXEC: update payReceipt set recCreation = '2023-09-21 14:19:35',recModify = '2023-09-21 14:19:35',recUseId=0,recStatus='V' where recId = 168935
21/09/2023 14:53:48.2397   528 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
21/09/2023 14:53:48.8053   549 ms.           EXEC: update abbCards set carLastDate = '2023-09-21 14:53:48',carLastDirection='O' where carStatus='V' and carId = 13
21/09/2023 14:55:48.3490   530 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-09-21 14:55:47',0,0,'V',4928644209076450,5642430546693980,2023,'2023-09-21 14:55:47',3,'KES',-1,50,-50,'N','');
insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-09-21 14:55:47',0,0,'V',4928644209076450,5642430546693980,2023,'2023-09-21 14:55:47',3,'KES',-1,100,-100,'N','');

21/09/2023 16:15:50.1242   783 ms.           EXEC: update abbCards set carLastDate = '2023-09-21 16:15:49',carLastDirection='O' where carStatus='V' and carId = 102
21/09/2023 16:15:51.0992   845 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-09-21 16:15:50' where traUID = 4679519914697840 and traStatus='V' and traEnabled=1
21/09/2023 16:15:53.1570   594 ms.           EXEC: update tabTerminalReceipt set trcProgressive = 44018, trcLastPrinted = '2300744018', trcLastDate = '2023-09-21 16:15:52' where trcStatus='V' and trcTerId = 18
21/09/2023 17:03:40.5869   582 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
21/09/2023 18:04:25.8340   589 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-09-21 18:04:25',0,0,'V',5151183000642720,5711690928073800,2023,'2023-09-21 18:04:25',3,'KES',1,100,100,'N','');

21/09/2023 19:02:18.5648  1681 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