29/09/2024 01:31:03.8076 572 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5298088271271580,5685060690148650,2024,'2024-09-29 01:31:03',' Date: 9/29/2024 1:31:03 AM Code: 455617540200327005012999 Entry Date: 9/28/2024 8:56:42 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 300.00 KES ______________________________ Paid: 300.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400743228 ',0) 29/09/2024 02:07:56.8181 729 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/09/2024 02:16:08.0378 609 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-09-29 02:16:07' where traUID = 5556967765354360 and traStatus='V' and traEnabled=1 29/09/2024 04:21:28.1340 557 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4977642166787160,5546104611281490,2024,'2024-09-29 04:21:27',' Date: 9/29/2024 4:19:50 AM Code: 455621265800327005012999 Entry Date: 9/29/2024 3:30:58 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400413738 ',0) 29/09/2024 09:22:03.0365 517 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-09-29 09:22:02' where payTraUID = 5353712814148040 and payStatus='V' and payEnabled=1 29/09/2024 10:21:27.7862 558 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-09-29 10:21:27',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 29/09/2024 11:07:43.5761 728 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 29/09/2024 11:13:01.8140 2426 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 29/09/2024 13:40:13.0059 647 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-09-29 13:40:12' where payTraUID = 5404258648148830 and payStatus='V' and payEnabled=1 29/09/2024 13:59:36.8189 584 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 29/09/2024 14:55:13.5578 1336 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 29/09/2024 15:02:04.5479 505 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-09-29 15:02:03' where traUID = 5694351585883480 and traStatus='V' and traEnabled=1 29/09/2024 15:03:29.7984 1578 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 29/09/2024 15:34:12.4457 1895 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-09-29 15:34:10',0,'V',5454599264338950,5509816278212040,2024,'2024-09-29 15:34:10',18,1,0,4,'2024-09-29 15:49:10','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 29/09/2024 15:35:40.2913 733 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,'2024-09-29 15:35:39','V',4624775380370010,2024,'2024-09-29 15:35:39','455625237100327005012999',2,2,2,'O','',0,'2024-09-29 15:35:39',1,'','',0) 29/09/2024 16:01:38.8461 1493 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 29/09/2024 16:19:31.3064 614 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 29/09/2024 16:24:09.7765 4422 ms. OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 29/09/2024 16:46:28.4170 750 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-09-29 16:46:27',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 29/09/2024 17:28:46.7282 828 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 29/09/2024 17:44:19.7688 512 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/09/2024 20:04:49.2308 647 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-09-29 20:04:48',0,'V',5257317274847350,4987813622702700,2024,'2024-09-29 20:04:48',18,1,0,4,'2024-09-29 20:19:48','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)