23/04/2025 00:37:33.3509 1906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 00:37:36.0457 1621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 00:37:45.7572 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 00:37:52.6648 1381 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 00:39:44.9820 887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 00:41:38.5833 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 00:43:56.6057 754 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/04/2025 00:58:03.2015 877 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 01:01:46.2538 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 01:38:57.8211 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 01:51:21.4381 1863 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 02:04:36.8559 1822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 02:11:17.1950 895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 02:11:27.9001 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 02:14:10.4699 848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 02:21:40.7543 1051 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 23/04/2025 02:37:02.8384 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 02:53:46.8194 2466 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 23/04/2025 03:11:40.7612 1558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 03:55:11.2789 682 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 23/04/2025 04:03:46.7449 1215 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:03:59.3023 1056 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:09:27.4471 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:13:44.5242 1260 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:14:01.2684 1383 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:21:57.3984 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:22:28.7634 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:24:05.0258 2098 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:24:17.8574 1068 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 23/04/2025 04:24:58.3845 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:27:19.5510 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:27:39.9217 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:30:42.8441 1034 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:33:11.0883 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 04:53:50.9560 1771 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 23/04/2025 05:01:48.1035 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 05:10:29.7747 1568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 05:13:01.6383 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 05:16:44.2333 1429 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 05:16:55.3858 1067 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 05:17:12.6013 1360 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 05:21:18.3498 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 05:27:07.5445 2702 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 23/04/2025 05:28:45.9303 1648 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/04/2025 05:33:30.8930 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 05:35:32.2876 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 05:38:25.4196 727 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 05:54:41.3670 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 05:57:52.0920 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 06:02:48.8771 718 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-23 06:02:48' where traUID = 5082135351532380 and traStatus='V' and traEnabled=1 23/04/2025 06:38:19.2895 1088 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 06:40:31.9633 762 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/04/2025 06:41:54.4164 1683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 07:10:43.9417 1090 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4928283205581440,5685957079745870,2025,'2025-04-23 07:10:42',' Date: 4/23/2025 7:10:30 AM Code: 457682314400327005012999 Entry Date: 4/23/2025 6:25:44 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500404995 ',0) 23/04/2025 07:12:02.0570 711 ms. EXEC: update abbCards set carLastDate = '2025-04-23 07:12:01',carLastDirection='I' where carStatus='V' and carId = 21 23/04/2025 07:12:05.8496 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 07:12:38.3413 526 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-23 07:12:37','V',5243024173982380,2025,'2025-04-23 07:12:32','457682595200327005012999',1,2,16,'I','',1,0,1,'','',4) 23/04/2025 07:19:15.3080 1071 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 07:38:13.4419 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 07:42:56.2672 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 07:45:51.3105 629 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-04-23 07:45:50',0,'V',5295711924350750,5761905431599770,2025,'2025-04-23 07:45:50',18,1,0,4,'2025-04-23 08:00:50','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 23/04/2025 07:46:41.2699 724 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-23 07:46:40',0,16,'2025-04-23 07:46:40','','Unauthorized Transit Entry 2') 23/04/2025 07:48:00.8832 1436 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 07:49:23.1573 1867 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 07:51:30.4975 1441 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 07:51:51.7508 771 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/04/2025 07:51:54.3065 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 07:51:55.7434 967 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 23/04/2025 07:58:58.1781 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 07:59:52.6616 1016 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 08:01:38.6676 862 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/04/2025 08:03:21.3002 552 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/04/2025 08:20:14.2442 527 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 23/04/2025 08:23:37.9095 529 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-04-23 08:23:37','V',5282543587888810,2025,'2025-04-23 08:23:36','457683021600327005012999',1,2,16,'I','',1,0,1,'','0230003943861',31,0) 23/04/2025 08:35:58.3845 1144 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '457683095600327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 23/04/2025 08:37:53.6397 1123 ms. EXEC: update abbCards set carLastDate = '2025-04-23 08:37:52',carLastDirection='I' where carStatus='V' and carId = 195 23/04/2025 08:40:57.7169 4108 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 = 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 23/04/2025 08:42:03.6300 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 08:47:27.3466 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 08:48:26.0669 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 08:51:39.4464 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 08:51:43.6852 533 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 1 ms.) 23/04/2025 08:51:48.0881 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 08:59:29.6882 668 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4803893848888760,5392760908189160,2025,'2025-04-23 08:59:29','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/23/2025 8:51:11 AM Date : 4/23/2025 8:59:27 AM Code : 457683187100327001031999 Total : 1.00 KES VAT 16% : 0.14 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 49.00 KES',0) 23/04/2025 08:59:31.7856 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 09:24:43.7597 570 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-23 09:24:43' where payTraUID = 5126444008238670 and payStatus='V' and payEnabled=1 23/04/2025 09:25:16.0963 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 09:27:52.4360 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 09:33:23.3945 658 ms. EXEC: update payReceipt set recCreation = '2025-04-23 09:33:22',recModify = '2025-04-23 09:33:22',recUseId=0,recStatus='V' where recId = 372737 23/04/2025 09:33:24.1820 618 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-23 09:33:23',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'; 23/04/2025 09:34:02.9199 878 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 23/04/2025 09:39:49.7787 1201 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 09:41:55.5489 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 09:42:32.8869 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 09:51:30.9549 1608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 09:54:42.9794 1407 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 09:54:43.1275 1024 ms. EXEC: update payInventory set invCreation = '2025-04-23 09:54:42',invModify = '2025-04-23 09:54:42',invUseId=0,invStatus='V' where invId = 248067 23/04/2025 09:56:17.6458 871 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-04-23 09:56:14',0,'V',5153968967622920,5276152602583030,2025,'2025-04-23 09:56:14',3,1,0,4,'2025-04-23 10:11:14','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 23/04/2025 09:56:18.6595 694 ms. EXEC: update payInventory set invCreation = '2025-04-23 09:56:17',invModify = '2025-04-23 09:56:17',invUseId=0,invStatus='V' where invId = 248069 23/04/2025 10:00:50.0021 956 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-23 10.00.49' where payTraUID = 5677080679533130 and payStatus='V' and payEnabled=1 23/04/2025 10:01:45.6093 2115 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5379069248908360,5618821853797610,2025,'2025-04-23 10:01:43',' Date: 4/23/2025 10:01:43 AM Code: 457682804100327005012999 Entry Date: 4/23/2025 7:47:21 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500716083 ',0) 23/04/2025 10:03:17.8390 939 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 10:06:26.2337 1223 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 10:06:29.1427 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 10:08:07.0442 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 10:09:06.8312 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 10:26:46.1364 607 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/04/2025 10:40:03.2651 526 ms. EXEC: update payReceipt set recCreation = '2025-04-23 10:40:02',recModify = '2025-04-23 10:40:02',recUseId=0,recStatus='V' where recId = 372753 23/04/2025 10:42:57.4517 513 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-23 10.42.56','V',5475867557126890,2025,'2025-04-23 10.42.27','457683854700327005031999',1,2,16,'I','',1,0,1,'','',4) 23/04/2025 10:45:04.8652 515 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-23 10.45.04' where traUID = 5311536771592560 and traStatus='V' and traEnabled=1 23/04/2025 10:48:54.7701 1329 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 10:56:16.1305 641 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/04/2025 10:59:36.3715 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 10:59:37.7124 501 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-23 10:59:37','V',5206175954157160,2025,'2025-04-23 10:59:36','457683957600327005012999',1,2,16,'I','',1,0,1,'','',4) 23/04/2025 11:03:48.4072 825 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 23/04/2025 11:03:57.3451 1454 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 11:05:15.3744 2504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 11:05:24.6466 5348 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/04/2025 11:05:41.0816 1310 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 11:09:08.7826 1398 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 11:17:57.8678 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 11:21:55.1727 696 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 11:30:27.8888 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 11:35:03.1990 594 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5658986807397650,4773812257543090,2025,'2025-04-23 11:35:02','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/23/2025 9:20:37 AM Date : 4/23/2025 11:35:00 AM Code : 457683363700327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 23/04/2025 11:43:49.3602 1755 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-23 11:43:47','V',4991081537280660,2025,'2025-04-23 11:43:45','457684222500327005012999',1,2,16,'I','',1,0,1,'','',4) 23/04/2025 11:43:50.9612 1068 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 23/04/2025 11:45:29.9255 1363 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5158474858123850,5250220010917020,2025,'2025-04-23 11:45:28','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/23/2025 11:20:20 AM Date : 4/23/2025 11:45:27 AM Code : 457684082000327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 23/04/2025 11:49:06.2665 515 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-23 11:49:05' where payTraUID = 4616873706081620 and payStatus='V' and payEnabled=1 23/04/2025 11:49:07.1170 849 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-23 11:49:05' where traUID = 4616873706081620 and traStatus='V' and traEnabled=1 23/04/2025 11:50:52.7487 1333 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 11:52:47.1713 2678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 11:54:28.4371 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 11:54:39.8161 997 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16094, trcLastPrinted = '2500716094', trcLastDate = '2025-04-23 11.54.38' where trcStatus='V' and trcTerId = 18 23/04/2025 11:55:19.4947 775 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-04-23 11.55.07',9,'V',4704767067041370,5694651565965940,2025,'2025-04-23 11.55.07',4,1,0,4,'2025-04-23 12.10.07','P','EUR',50,50,0,'','','',1,50,0,0,'',0,0) 23/04/2025 11:55:21.4030 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 11:55:42.5161 541 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 23/04/2025 11:55:42.6622 1316 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5667682926669050,4687781241025950,2025,'2025-04-23 11.55.41',' Date: 23/04/2025 11.55.27 Code: 457683196600327005012999 Entry Date: 23/04/2025 8.52.46 Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 200.00 EUR ______________________________ Paid: 200.00 EUR __________ Change: 0.00 EUR Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500405015 ',0) 23/04/2025 11:56:40.6610 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 11:56:52.8882 978 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 23/04/2025 11:57:01.8012 579 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-23 11:57:01','V',5152274387037560,2025,'2025-04-23 11:56:59','457684301900327005012999',1,2,16,'I','',1,0,1,'','',4) 23/04/2025 11:58:35.5859 526 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/04/2025 11:58:44.5980 3389 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 11:58:55.2711 4347 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/04/2025 11:58:55.3091 1372 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:00:00.9090 5887 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 23/04/2025 12:00:01.7646 774 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-23 12:00:00' where traUID = 5518920917864890 and traStatus='V' and traEnabled=1 23/04/2025 12:00:03.1315 1609 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/04/2025 12:00:07.1752 3061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:12:00.0628 686 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-23 12:11:59' where payTraUID = 5152274387037560 and payStatus='V' and payEnabled=1 23/04/2025 12:12:00.7963 732 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-23 12:11:59' where traUID = 5152274387037560 and traStatus='V' and traEnabled=1 23/04/2025 12:12:04.5038 609 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 23/04/2025 12:15:05.9052 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:15:08.4219 1131 ms. EXEC: update payReceipt set recCreation = '2025-04-23 12:15:07',recModify = '2025-04-23 12:15:07',recUseId=0,recStatus='V' where recId = 372788 23/04/2025 12:15:14.2078 1483 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:18:26.6155 1351 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:18:37.8921 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:18:40.6899 2089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:18:47.9578 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:20:08.8620 688 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 430185 else acvFstPayId end),acvLstPayId = 430185 where acvSftId = 977 and acvCodeId = 3 23/04/2025 12:20:10.2069 801 ms. EXEC: update payReceipt set recCreation = '2025-04-23 12:20:09',recModify = '2025-04-23 12:20:09',recUseId=0,recStatus='V' where recId = 372789 23/04/2025 12:24:16.5027 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:29:18.4948 851 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 23/04/2025 12:29:19.3244 619 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-23 12:29:18' where traUID = 4968581612636110 and traStatus='V' and traEnabled=1 23/04/2025 12:29:27.3487 551 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/04/2025 12:40:42.9477 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 12:40:51.8567 903 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/04/2025 12:40:53.3016 1919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:40:57.2142 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:42:59.7092 858 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 23/04/2025 12:43:07.1712 721 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-23 12:43:06' where traUID = 4734762703111230 and traStatus='V' and traEnabled=1 23/04/2025 12:43:17.3781 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 12:44:05.4302 589 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/04/2025 12:44:05.8425 903 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 12:47:58.7567 1068 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-23 12.47.57',3,42101,0,100,-1,-100,1,'O','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'; 23/04/2025 12:48:00.1036 1245 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 23/04/2025 12:53:38.6712 1293 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16110, trcLastPrinted = '2500716110', trcLastDate = '2025-04-23 12.53.37' where trcStatus='V' and trcTerId = 18 23/04/2025 12:55:15.5260 578 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-23 12.55.14' where traUID = 4827696177244370 and traStatus='V' and traEnabled=1 23/04/2025 12:57:12.9676 1594 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-23 12.57.11','V',4678940022857630,2025,'2025-04-23 12.57.10','457684432000327005012999',2,2,2,'O','',0,'2025-04-23 12.57.11',1,'','',0) 23/04/2025 12:57:14.1704 1089 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/04/2025 13:03:40.3044 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 13:03:40.7147 692 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/04/2025 13:03:40.9068 802 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 23/04/2025 13:04:09.9232 605 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/04/2025 13:13:17.0446 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 13:13:21.1804 627 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-23 13:13:20','V',5072130427882540,2025,'2025-04-23 13:13:20','457684760000327005012999',1,2,16,'I','',1,0,1,'','',4) 23/04/2025 13:13:53.4580 755 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 430213 else acvFstPayId end),acvLstPayId = 430213 where acvSftId = 977 and acvCodeId = 3 23/04/2025 13:15:34.6657 869 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-23 13:15:33','V',5273221735379700,2025,'2025-04-23 13:15:33','457684603600327005012999',2,2,2,'O','',0,'2025-04-23 13:15:33',1,'','',0) 23/04/2025 13:32:25.2056 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 13:34:36.2237 1120 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 13:35:22.5297 1596 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-04-23 13:35:20','0230003944059',0,0,5302495798692600,13,'0000-00-00 00:00:00','0000-00-00 00:00:00') 23/04/2025 13:35:24.5050 1952 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,payVatPercent,payVatAmount) VALUES ('2025-04-23 13:35:22',0,'V',5302495798692600,4684706826957560,2025,'2025-04-23 13:35:22',2,1,0,-1,'2025-04-23 14:35:22','S','KES',0,0,0,'','','',3,0,0) 23/04/2025 13:35:28.6298 3822 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 23/04/2025 13:35:34.1535 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 13:37:24.1721 867 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 23/04/2025 13:37:25.5971 1093 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/04/2025 13:39:13.3372 1305 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 13:39:25.6144 2617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 13:39:32.4089 2516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 13:39:39.3746 3214 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 13:39:43.7856 880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 13:39:48.8379 2732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 13:42:48.6040 3331 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 13:47:12.0324 673 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4990443550014790,4848953904572770,2025,'2025-04-23 13:47:11','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/23/2025 11:54:09 AM Date : 4/23/2025 1:47:10 PM Code : 457684284900327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 23/04/2025 13:50:21.2511 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 13:55:48.8193 1979 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 23/04/2025 13:57:51.6515 1792 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-23 13:57:49',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'; 23/04/2025 14:01:34.6067 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 14:04:58.1329 625 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 23/04/2025 14:05:22.9067 936 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/04/2025 14:06:27.2927 543 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-23 14:06:26' where traUID = 4747373688641230 and traStatus='V' and traEnabled=1 23/04/2025 14:07:02.1020 967 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-04-23 14:06:49',9,'V',5697085008390920,4866457050543120,2025,'2025-04-23 14:06:49',4,1,0,4,'2025-04-23 14:21:49','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 23/04/2025 14:07:11.6875 1328 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 4 nr: 1 23/04/2025 14:08:36.4462 1446 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 14:08:39.7264 1255 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 23/04/2025 14:13:54.4530 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 14:14:17.0091 590 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/04/2025 14:15:46.8242 1324 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 14:21:12.7344 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 14:21:18.0979 664 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 23/04/2025 14:28:38.2046 795 ms. EXEC: update payReceipt set recCreation = '2025-04-23 14:28:37',recModify = '2025-04-23 14:28:37',recUseId=0,recStatus='V' where recId = 372849 23/04/2025 14:32:26.5574 1415 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 14:38:21.6504 518 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 23/04/2025 14:41:25.4974 590 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/04/2025 14:41:36.0965 675 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/04/2025 14:41:43.6025 559 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-23 14:41:43',0,16,'2025-04-23 14:41:43','','Unauthorized Transit Entry 2') 23/04/2025 14:43:27.2659 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 14:45:23.9770 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 14:51:09.1620 1092 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '457685292600327005012999' 23/04/2025 14:54:11.5821 887 ms. EXEC: update payReceipt set recCreation = '2025-04-23 14:54:10',recModify = '2025-04-23 14:54:10',recUseId=0,recStatus='V' where recId = 372857 23/04/2025 14:56:39.5829 683 ms. EXEC: update payReceipt set recCreation = '2025-04-23 14:56:38',recModify = '2025-04-23 14:56:38',recUseId=0,recStatus='V' where recId = 372862 23/04/2025 14:57:49.2255 1840 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/04/2025 15:05:06.3651 798 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 23/04/2025 15:09:06.0355 596 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-23 15:09:05',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'; 23/04/2025 15:18:11.4619 679 ms. EXEC: update payReceipt set recCreation = '2025-04-23 15:18:10',recModify = '2025-04-23 15:18:10',recUseId=0,recStatus='V' where recId = 372871 23/04/2025 15:29:07.6321 1921 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-23 15.29.05','V',5456253413036160,2025,'2025-04-23 15.29.04','457685574400327005012999',1,2,16,'I','',1,0,1,'','',4) 23/04/2025 15:29:19.0207 738 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-23 15.29.18',0,16,'2025-04-23 15.29.18','','Unauthorized Transit Entry 2') 23/04/2025 15:36:39.9348 507 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 23/04/2025 15:38:13.7636 577 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 23/04/2025 15:38:24.2826 677 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-23 15.38.23' where payTraUID = 5011965070013500 and payStatus='V' and payEnabled=1 23/04/2025 15:42:14.9200 1763 ms. EXEC: update payReceipt set recCreation = '2025-04-23 15:42:13',recModify = '2025-04-23 15:42:13',recUseId=0,recStatus='V' where recId = 372881 23/04/2025 15:43:41.2528 690 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16143, trcLastPrinted = '2500716143', trcLastDate = '2025-04-23 15:43:40' where trcStatus='V' and trcTerId = 18 23/04/2025 15:43:41.8152 559 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5093406262397340,5607965292779360,2025,'2025-04-23 15:43:41',' Date: 4/23/2025 3:43:40 PM Code: 457685608900327005012999 Entry Date: 4/23/2025 3:34:49 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 # 2500716143 ',0) 23/04/2025 15:43:42.4946 679 ms. EXEC: update payReceipt set recCreation = '2025-04-23 15:43:41',recModify = '2025-04-23 15:43:41',recUseId=0,recStatus='V' where recId = 372882 23/04/2025 15:47:31.8581 964 ms. EXEC: update payReceipt set recCreation = '2025-04-23 15.47.30',recModify = '2025-04-23 15.47.30',recUseId=0,recStatus='V' where recId = 372883 23/04/2025 16:06:01.3639 695 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 23/04/2025 16:06:04.1177 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 16:24:00.5812 924 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-04-23 16:23:59',0,'V',5362709826621160,4903970626641720,2025,'2025-04-23 16:23:59',18,1,0,4,'2025-04-23 16:38:59','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 23/04/2025 16:24:01.8340 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 16:24:03.2830 2570 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4903970626641720,5362709826621160,2025,'2025-04-23 16:24:00',' Date: 4/23/2025 4:23:59 PM Code: 457685613300327005012999 Entry Date: 4/23/2025 3:35:33 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 # 2500716150 ',0) 23/04/2025 16:26:09.8037 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/04/2025 16:33:12.1554 852 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 23/04/2025 16:49:48.7370 1311 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-23 16:49:47',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'; 23/04/2025 16:49:48.7971 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 16:51:46.0425 771 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-23 16:51:45' where payTraUID = 5082005522151380 and payStatus='V' and payEnabled=1 23/04/2025 16:59:05.5033 1649 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 23/04/2025 16:59:08.9686 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 17:06:23.6005 766 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,payVatPercent,payVatAmount) VALUES ('2025-04-23 17:06:22',0,'V',4939583853877030,4762522055745760,2025,'2025-04-23 17:06:22',2,1,0,-1,'2025-04-23 18:06:22','S','KES',0,0,0,'','','',3,0,0) 23/04/2025 17:13:42.5102 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/04/2025 17:17:10.3924 598 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-04-23 17.17.09','V',5704345742604710,2025,'2025-04-23 17.16.58','457686093400327005029999',2,2,16,'I','',1,0,1,'','0532370677371',13,0) 23/04/2025 17:48:17.5354 1055 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-23 17.48.16' where payTraUID = 5557013186917510 and payStatus='V' and payEnabled=1 23/04/2025 18:03:07.5271 938 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-23 18:03:06','V',4725714824094950,2025,'2025-04-23 18:03:05','457686325500327005012999',2,2,2,'O','',0,'2025-04-23 18:03:06',1,'','',0) 23/04/2025 18:17:39.1820 726 ms. EXEC: update abbCards set carLastDate = '2025-04-23 18.17.38',carLastDirection='O' where carStatus='V' and carId = 11 23/04/2025 18:17:40.0416 765 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-23 18.17.39' where payTraUID = 4992444525093650 and payStatus='V' and payEnabled=1 23/04/2025 18:17:51.1811 656 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/04/2025 18:30:40.6981 530 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/04/2025 18:34:11.1339 1406 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/04/2025 18:54:33.2129 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);