04/08/2025 10:35:27.5580   531 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-08-04 10:35:27','V',4634606325383210,2025,'2025-08-04 10:35:25','458713812500327005012999',1,2,16,'I','',1,0,1,'','',4)
04/08/2025 10:37:50.3009   531 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
04/08/2025 11:48:27.2027   546 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-08-04 11:48:25',1,'V',4693767695471930,5295962734879640,2025,'2025-08-04 11:48:25',4,1,0,4,'2025-08-04 12:03:25','P','KES',100,100,0,'','','',1,100,0,0,'',0,0)
04/08/2025 13:07:07.5549  1031 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-08-04 13:07:04',0,'V',5282360231266260,5606496138988820,2025,'2025-08-04 13:07:04',3,1,0,4,'2025-08-04 13:22:04','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0)
04/08/2025 13:07:08.1330   562 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5606496138988820,5282360231266260,2025,'2025-08-04 13:07:07','----------------------------------
%The Mall P0006032390             


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

POF 

Entry : 8/4/2025 12:37:35 PM

Date : 8/4/2025 1:07:04 PM
Code : 458714545500327005012999

Total           : 50.00 KES

VAT 16%         : 6.90 KES
----------------------------------
   Paid            : 50.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)
04/08/2025 18:08:07.3237   515 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-08-04 18:08:06' where traUID = 4650299813908530 and traStatus='V' and traEnabled=1
04/08/2025 18:59:48.6254   906 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