30/06/2024 11:25:59.9531  1040 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 = 1 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
30/06/2024 11:26:48.8459  4020 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
30/06/2024 11:54:10.6323   540 ms.           EXEC: update abbCards set carLastDate = '2024-06-30 11:54:10',carLastDirection='O' where carStatus='V' and carId = 13
30/06/2024 14:05:42.0274   520 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5437927524553950,4927414887495380,2024,'2024-06-30 14:05:41','----------------------------------
%The Mall P0006032390             


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

POF 

Entry : 6/30/2024 12:54:25 PM

Date : 6/30/2024 2:05:40 PM
Code : 454714646500327005012999

Total           : 100.00 KES

VAT 16%         : 13.79 KES
----------------------------------
   Paid            : 100.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)
30/06/2024 14:31:26.1652   660 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-06-30 14:31:25' where payTraUID = 4951008003777190 and payStatus='V' and payEnabled=1
30/06/2024 14:34:21.2871   520 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 ('2024-06-30 14:34:20',0,'V',4757418372788760,5426003108634620,2024,'2024-06-30 14:34:20',18,1,0,4,'2024-06-30 14:49:20','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
30/06/2024 15:30:07.7994   600 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-06-30 15:30:07',3,42101,0,100,1,100,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';

30/06/2024 18:00:09.9236   600 ms.           EXEC: update tabTerminalReceipt set trcProgressive = 9479, trcLastPrinted = '2400409479', trcLastDate = '2024-06-30 18:00:09' where trcStatus='V' and trcTerId = 4