16/04/2025 15:16:27.0619 1123 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 428241 else acvFstPayId end),acvLstPayId = 428241 where acvSftId = 968 and acvCodeId = 3 16/04/2025 15:16:27.7927 720 ms. EXEC: update tabTerminalReceipt set trcProgressive = 2767, trcLastPrinted = '2500602767', trcLastDate = '2025-04-16 15:16:27' where trcStatus='V' and trcTerId = 17 16/04/2025 15:18:19.3135 530 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5643291182661640,5297506015552120,2025,'2025-04-16 15:18:18',' Date: 4/16/2025 3:18:18 PM Code: 457615377800327005012999 Entry Date: 4/16/2025 2:56:18 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 # 2500715338 ',0) 16/04/2025 16:07:23.1336 1160 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-04-16 16:07:21','V',4700712262504080,2025,'2025-04-16 16:07:21','457615641200327005012999',2,2,2,'O','',0,'2025-04-16 16:07:21',1,'','',0) 16/04/2025 16:07:25.0858 1947 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 16/04/2025 17:08:25.0702 530 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-16 17:08:24' where payTraUID = 5580151794715340 and payStatus='V' and payEnabled=1 16/04/2025 18:40:13.4749 744 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 = 10 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 16/04/2025 23:35:14.9473 548 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 16/04/2025 23:39:38.0795 549 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc