01/07/2025 08:49:15.7892   641 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
01/07/2025 10:53:40.3760   657 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-07-01 10:53:39' where traUID = 5307770939139140 and traStatus='V' and traEnabled=1
01/07/2025 11:02:06.7764  2062 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
01/07/2025 12:46:15.2190   604 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-07-01 12:46:14' where traUID = 4970786180093960 and traStatus='V' and traEnabled=1
01/07/2025 12:54:40.1629   558 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,'2025-07-01 12:54:39','V',5703688688594800,2025,'2025-07-01 12:54:38','458374517400327001012999',2,2,2,'O','',0,'2025-07-01 12:54:39',1,'','',0)
01/07/2025 14:00:09.4217   549 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,'2025-07-01 14:00:08','V',4816406834171980,2025,'2025-07-01 14:00:08','458375040800327005012999',1,2,16,'I','',1,0,1,'','',4)
01/07/2025 14:00:44.5864   715 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4786145946915490,4673656308165150,2025,'2025-07-01 14:00:43','----------------------------------
%The Mall P0006032390             


          End of payment          
----------------------------------

POF 

Entry : 7/1/2025 12:46:11 PM

Date : 7/1/2025 2:00:43 PM
Code : 458374597100327005012999

Total           : 100.00 KES

VAT 16%         : 13.79 KES
----------------------------------
   Paid            : 100.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)
01/07/2025 14:12:12.1586   625 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-07-01 14:12:11',0,0,'V',5276890361420860,4994153893183700,2025,'2025-07-01 14:12:11',3,'KES',1,50,50,'N','');

01/07/2025 15:22:21.0266   538 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 ('2025-07-01 15:22:20',0,'V',5335646806057480,4847392872904060,2025,'2025-07-01 15:22:20',18,1,0,4,'2025-07-01 15:37:20','C','KES',100,100,0,'','','',1,100,0,0,'',0,0)
01/07/2025 16:21:23.2316   505 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-07-01 16:21:22' where traUID = 4937367506404270 and traStatus='V' and traEnabled=1
01/07/2025 21:27:25.0546   642 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc