01/04/2025 04:56:10.7590 556 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4634518780489550,5224172294080060,2025,'2025-04-01 04:56:10','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/1/2025 4:33:42 AM Date : 4/1/2025 4:56:09 AM Code : 457461642200327005012999 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/04/2025 10:34:39.0246 5656 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 01/04/2025 10:59:01.2403 557 ms. EXEC: update payInventory set invCreation = '2025-04-01 10:59:00',invModify = '2025-04-01 10:59:00',invUseId=0,invStatus='V' where invId = 244414 01/04/2025 13:22:24.8630 561 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-01 13:22:24','V',4800369394116460,2025,'2025-04-01 13:22:24','457464814400327005012999',1,2,16,'I','',1,0,1,'','',4) 01/04/2025 14:01:55.4959 514 ms. EXEC: update tabTerminalReceipt set trcProgressive = 2436, trcLastPrinted = '2500602436', trcLastDate = '2025-04-01 14:01:54' where trcStatus='V' and trcTerId = 17 01/04/2025 14:31:31.9908 977 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 01/04/2025 14:53:49.7808 2365 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 01/04/2025 14:53:50.7307 940 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 44 order by traDateTime desc,traId desc 01/04/2025 15:00:45.6351 1859 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 01/04/2025 15:05:43.8455 560 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 125 order by traDateTime desc,traId desc 01/04/2025 15:18:13.5865 1123 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 01/04/2025 15:36:35.4746 1143 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 01/04/2025 15:52:05.2025 1621 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 01/04/2025 16:13:36.7707 605 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-01 16:13:36','V',5730295458985960,2025,'2025-04-01 16:13:35','457465356300327005012999',2,2,2,'O','',0,'2025-04-01 16:13:36',1,'','',0) 01/04/2025 16:14:57.2950 516 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 422685 else acvFstPayId end),acvLstPayId = 422685 where acvSftId = 951 and acvCodeId = 3 01/04/2025 16:19:46.0234 579 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 01/04/2025 16:24:23.2581 621 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 01/04/2025 16:51:52.9886 608 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/04/2025 17:32:01.0686 5852 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