17/12/2024 00:33:19.8853 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 00:49:48.5063 704 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 17/12/2024 00:53:14.6285 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 00:54:53.1716 921 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 02:05:24.0689 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 02:23:22.8667 922 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 17/12/2024 02:25:00.7784 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 02:26:20.8923 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 02:26:52.4289 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 02:33:41.4265 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 02:48:05.7087 1074 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 03:15:10.5687 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 03:16:32.5955 573 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 17/12/2024 03:22:36.8950 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 04:18:50.0512 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 04:21:50.3083 2300 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 04:24:04.3194 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 04:30:22.5816 603 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-17 04:30:21' where payTraUID = 5221529476332280 and payStatus='V' and payEnabled=1 17/12/2024 04:30:27.1578 1196 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 04:31:31.0212 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 04:32:04.2933 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 04:40:02.1045 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 04:45:32.7594 817 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 17/12/2024 04:46:24.3916 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 04:46:47.1784 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 04:51:56.9253 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:13:27.3089 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:21:50.9122 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:26:19.1948 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:27:23.7666 885 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:40:55.0842 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:45:52.1680 1353 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:50:37.7565 897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:53:19.9743 948 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:54:44.2592 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:55:32.1202 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:56:28.0822 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:57:49.6822 1353 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 05:58:41.2373 735 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5685070166321540,5425519565112380,2024,'2024-12-17 05:58:40',' Date: 12/17/2024 5:53:15 AM Code: 456412118200327005012999 Entry Date: 12/17/2024 5:53:02 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 # 2400417946 ',0) 17/12/2024 06:35:56.5227 1130 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 06:37:15.9963 1104 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 17/12/2024 06:37:34.8816 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 06:58:11.4879 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:02:55.7240 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:06:33.5784 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:09:15.8115 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:11:16.2333 816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:11:18.7345 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:11:24.9535 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:11:26.4933 1013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:11:29.8983 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:11:39.8996 742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:20:56.6079 1115 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:25:54.0168 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:25:57.1904 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:29:44.7191 772 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 17/12/2024 07:39:23.1926 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 07:53:21.5863 877 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 08:11:09.7570 612 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 17/12/2024 08:12:59.0103 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 08:18:04.9241 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 08:23:20.4835 1170 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 08:27:11.1289 619 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 17/12/2024 08:29:19.7328 915 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 17/12/2024 08:29:50.5755 1428 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 17/12/2024 08:30:22.4525 1014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 08:32:33.2829 1551 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 17/12/2024 08:32:39.3938 767 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 17/12/2024 08:36:25.3404 1277 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 17/12/2024 08:37:00.4673 827 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,'2024-12-17 08:36:59','V',5664183789376450,2024,'2024-12-17 08:36:58','456413101800327005012999',1,2,16,'I','',1,0,1,'','0230003941812',181,0) 17/12/2024 09:07:00.8651 695 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 17/12/2024 09:17:08.9860 711 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 17/12/2024 09:25:11.9960 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 09:28:31.5162 541 ms. EXEC: update abbCards set carLastDate = '2024-12-17 09:28:30',carLastDirection='I' where carStatus='V' and carId = 25 17/12/2024 09:37:55.2146 705 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-17 09:37:54' where payTraUID = 5754490609811340 and payStatus='V' and payEnabled=1 17/12/2024 09:40:32.0902 663 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-17 09:40:27',5,3,42101,0,50,-18,-900,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-17 09:40:27',5,3,42101,0,100,-41,-4100,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-17 09:40:27',5,3,42101,0,200,-10,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-17 09:40:27',5,3,42101,0,500,-4,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-17 09:40:27',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-17 09:40:27',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 17/12/2024 09:50:40.3918 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 09:52:55.5288 799 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-17 09:52:54',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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-17 09:52:54',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 17/12/2024 09:54:21.5176 1375 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 10:03:31.0296 754 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 17/12/2024 10:10:32.1453 878 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 10:10:31' where traUID = 4731601641534780 and traStatus='V' and traEnabled=1 17/12/2024 10:14:31.9096 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 10:16:53.0567 630 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 17/12/2024 10:23:17.6826 1311 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 17/12/2024 10:32:10.6681 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 10:33:28.7631 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 10:35:50.4114 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 10:36:34.0706 1189 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 10:41:21.4674 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 10:45:48.8126 640 ms. EXEC: update abbCards set carLastDate = '2024-12-17 10:45:48',carLastDirection='I' where carStatus='V' and carId = 111 17/12/2024 10:45:59.5948 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 10:50:20.5028 511 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 17/12/2024 11:00:38.0472 561 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 11:00:37',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'; 17/12/2024 11:03:11.3665 1807 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 11:03:09' where traUID = 4655783599175600 and traStatus='V' and traEnabled=1 17/12/2024 11:03:14.3618 610 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 17/12/2024 11:04:00.4289 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 11:05:07.9334 1112 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 17/12/2024 11:05:11.5595 905 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 17/12/2024 11:07:48.5452 557 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 17/12/2024 11:12:32.7244 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 11:12:58.0459 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 11:16:33.2142 584 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5075346764903450,5377689358676370,2024,'2024-12-17 11:16:32','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/17/2024 10:48:56 AM Date : 12/17/2024 11:16:30 AM Code : 456413893600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 17/12/2024 11:16:34.0882 513 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 11:16:33',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'; 17/12/2024 11:43:22.2941 661 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-12-17 11:43:21','V',5519227850057030,2024,'2024-12-17 11:43:21','456414220100327005012999',1,2,16,'I','',1,0,1,'','',4) 17/12/2024 11:49:28.3078 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 11:50:46.5123 562 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 17/12/2024 11:52:42.8644 885 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-12-17 11:52:41','V',5157772184821700,2024,'2024-12-17 11:52:41','456414276100327001012999',1,2,1,'I','',1,0,1,'','',4) 17/12/2024 11:53:13.9505 704 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 17/12/2024 11:55:23.3723 959 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 ('2024-12-17 11:55:22',0,'V',5555733768505410,5293892759976360,2024,'2024-12-17 11:55:22',2,1,0,-1,'2024-12-17 12:55:22','S','KES',0,0,0,'','','',3,0,0) 17/12/2024 11:59:46.9392 813 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 17/12/2024 12:12:04.3452 522 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 17/12/2024 12:12:10.3840 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 12:24:22.6754 1677 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 17/12/2024 12:24:57.7821 959 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 ('2024-12-17 12:24:56',0,'V',5597194642349140,5032160116550640,2024,'2024-12-17 12:24:56',2,1,0,-1,'2024-12-17 13:24:56','S','KES',0,0,0,'','','',3,0,0) 17/12/2024 12:25:26.5764 515 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 17/12/2024 12:26:12.3179 526 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 17/12/2024 12:29:51.0892 751 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4675165062496670,5192227723866480,2024,'2024-12-17 12:29:50',' Date: 12/17/2024 12:29:50 PM Code: 456414178000327005012999 Entry Date: 12/17/2024 11:36:20 AM 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 # 2400753813 ',0) 17/12/2024 12:46:24.2719 720 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 17/12/2024 12:53:39.3515 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 12:55:35.1330 524 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 12:55:34' where traUID = 5138671550768790 and traStatus='V' and traEnabled=1 17/12/2024 12:59:33.3565 543 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5017412490135820,5111041392203760,2024,'2024-12-17 12:59:32',' Date: 12/17/2024 12:59:32 PM Code: 456414408500327005012999 Entry Date: 12/17/2024 12:14:45 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 # 2400753820 ',0) 17/12/2024 12:59:45.4891 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 13:04:39.6945 913 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-12-17 13:04:37',0,'V',4699973727619130,4787435619118510,2024,'2024-12-17 13:04:37',3,1,0,4,'2024-12-17 13:19:37','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 17/12/2024 13:06:16.6430 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 13:10:46.9406 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 13:11:19.7732 1488 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 13:13:43.8938 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 13:14:03.1585 1061 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53823, trcLastPrinted = '2400753823', trcLastDate = '2024-12-17 13:14:02' where trcStatus='V' and trcTerId = 18 17/12/2024 13:14:16.9741 1006 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 13:14:17.6348 531 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 17/12/2024 13:15:12.4005 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 13:15:56.3653 836 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-12-17 13:15:55','V',5149447877545390,2024,'2024-12-17 13:15:55','456414775500327005012999',1,2,16,'I','',1,0,1,'','',4) 17/12/2024 13:19:20.7937 815 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 17/12/2024 13:21:13.1157 1487 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 13:23:47.7150 1280 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 13:24:06.5001 829 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-12-17 13:24:05','V',4699329023802070,2024,'2024-12-17 13:24:05','456414824500327005012999',1,2,16,'I','',1,0,1,'','',4) 17/12/2024 13:24:12.6280 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 13:26:31.6437 576 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 13:26:30' where traUID = 5029609820502290 and traStatus='V' and traEnabled=1 17/12/2024 13:27:01.4122 623 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 17/12/2024 13:27:29.1915 1748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 13:27:33.4614 974 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 17/12/2024 13:33:59.9907 541 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-12-17 13:33:59','V',5202220200654290,2024,'2024-12-17 13:33:58','456414672800327005012999',2,2,2,'O','',0,'2024-12-17 13:33:59',1,'','',0) 17/12/2024 13:34:15.3944 606 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 17/12/2024 13:34:34.7622 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 13:36:10.5872 1863 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 13:38:40.0877 1114 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 17/12/2024 13:46:41.6196 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 13:47:40.7454 1972 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-12-17 13:47:38','V',5319123504397530,2024,'2024-12-17 13:47:37','456414875600327005012999',2,2,2,'O','',0,'2024-12-17 13:47:38',1,'','',0) 17/12/2024 13:47:42.9218 1547 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 13:47:41' where traUID = 5540309636781630 and traStatus='V' and traEnabled=1 17/12/2024 13:49:14.8394 1038 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 17/12/2024 13:49:53.8614 804 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-12-17 13:49:51',0,'V',5439413956761500,4730582079008110,2024,'2024-12-17 13:49:51',3,1,0,4,'2024-12-17 14:04:51','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 17/12/2024 13:49:54.5592 543 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4730582079008110,5439413956761500,2024,'2024-12-17 13:49:54','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/17/2024 1:10:36 PM Date : 12/17/2024 1:49:51 PM Code : 456414743600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 17/12/2024 13:50:08.3587 1647 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-12-17 13:50:06','V',4856941531718710,2024,'2024-12-17 13:50:05','456414980500327005012999',1,2,16,'I','',1,0,1,'','',4) 17/12/2024 13:52:26.7297 1117 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 13:52:25' where traUID = 5615142237024930 and traStatus='V' and traEnabled=1 17/12/2024 13:53:43.4996 815 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 13:53:42',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'; 17/12/2024 13:53:44.2264 725 ms. EXEC: update payInventory set invCreation = '2024-12-17 13:53:43',invModify = '2024-12-17 13:53:43',invUseId=0,invStatus='V' where invId = 225860 17/12/2024 13:54:43.6380 643 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-17 13:54:42','0230003944064',0,0,5705417633553630,14,'0000-00-00 00:00:00','0000-00-00 00:00:00') 17/12/2024 13:55:47.1836 582 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-12-17 13:55:46','V',4919266779687900,2024,'2024-12-17 13:55:45','456415014500327005012999',1,2,16,'I','',1,0,1,'','',4) 17/12/2024 13:55:58.1596 686 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 13:55:57',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'; 17/12/2024 13:58:18.4602 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 14:09:51.0500 816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 14:30:07.1363 536 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-12-17 14:30:06','V',5382069883248630,2024,'2024-12-17 14:30:05','456414838900327005012999',2,2,2,'O','',0,'2024-12-17 14:30:06',1,'','',0) 17/12/2024 14:30:11.5472 558 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 17/12/2024 14:34:18.5148 1222 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-12-17 14:28:37',6,'V',5752111499769760,5234195742433090,2024,'2024-12-17 14:28:37',4,1,0,4,'2024-12-17 14:43:37','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 17/12/2024 14:34:20.4700 1789 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 383819 else acvFstPayId end),acvLstPayId = 383819 where acvSftId = 836 and acvCodeId = 3 17/12/2024 14:40:54.3613 961 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 14:41:01.8278 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 14:41:08.8226 538 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 17/12/2024 14:54:43.9622 506 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 17/12/2024 14:57:06.3336 646 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 17/12/2024 14:58:18.4529 862 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17981, trcLastPrinted = '2400417981', trcLastDate = '2024-12-17 14:58:17' where trcStatus='V' and trcTerId = 4 (WAIT TIME 1 ms.) 17/12/2024 15:04:53.5215 553 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-12-17 15:04:52',0,'V',5263934968211160,4710130234665970,2024,'2024-12-17 15:04:52',18,1,0,4,'2024-12-17 15:19:52','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 17/12/2024 15:06:12.2124 764 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 15:06:11',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'; 17/12/2024 15:06:12.7229 509 ms. EXEC: update payInventory set invCreation = '2024-12-17 15:06:12',invModify = '2024-12-17 15:06:12',invUseId=0,invStatus='V' where invId = 225884 17/12/2024 15:07:11.0393 1119 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-17 15:07:09' where payTraUID = 5216707091971550 and payStatus='V' and payEnabled=1 17/12/2024 15:08:58.1595 832 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 15:08:57' where traUID = 4774283067879290 and traStatus='V' and traEnabled=1 17/12/2024 15:11:59.8245 1474 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 15:12:09.4153 543 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-17 15:12:08',0,16,'2024-12-17 15:12:08','','Unauthorized Transit Entry 2') 17/12/2024 15:27:46.5177 920 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 15:27:45' where traUID = 5072283753955400 and traStatus='V' and traEnabled=1 17/12/2024 15:29:54.1712 584 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 15:29:53',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 17/12/2024 15:29:55.8381 1467 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 15:29:54',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 15:29:54',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'; 17/12/2024 15:30:09.1508 576 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 17/12/2024 15:36:41.8312 560 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-17 15:36:41' where subId = 178 17/12/2024 15:37:03.5036 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 15:37:39.3870 1344 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-17 15:37:38' where payTraUID = 5475633030768800 and payStatus='V' and payEnabled=1 17/12/2024 15:38:45.1912 781 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 17/12/2024 15:40:28.2173 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 15:42:46.1147 794 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 15:42:46.7034 587 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); 17/12/2024 15:44:26.2607 651 ms. EXEC: update payInventory set invCreation = '2024-12-17 15:44:25',invModify = '2024-12-17 15:44:25',invUseId=0,invStatus='V' where invId = 225892 17/12/2024 15:45:30.0367 530 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 17/12/2024 15:45:30.1228 789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 15:46:39.3545 1278 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 15:46:37' where traUID = 5477585985239340 and traStatus='V' and traEnabled=1 17/12/2024 15:48:17.0006 615 ms. EXEC: update payReceipt set recCreation = '2024-12-17 15:48:16',recModify = '2024-12-17 15:48:16',recUseId=0,recStatus='V' where recId = 333364 17/12/2024 15:48:44.5927 638 ms. EXEC: update payReceipt set recCreation = '2024-12-17 15:48:43',recModify = '2024-12-17 15:48:43',recUseId=0,recStatus='V' where recId = 333365 17/12/2024 15:49:09.7730 1374 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 15:51:45.9918 1721 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-17 15:51:44' where payTraUID = 5353460170722510 and payStatus='V' and payEnabled=1 17/12/2024 15:52:23.1229 935 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 17/12/2024 15:55:13.3782 1367 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 15:57:59.1410 1556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:00:20.9708 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:01:39.8657 616 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,'2024-12-17 16:01:39','V',5339603552311390,2024,'2024-12-17 16:01:36','456415769600327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 17/12/2024 16:02:06.2437 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:07:24.8347 1266 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:09:39.3013 530 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-12-17 16:09:38',0,'V',4898705117164670,5009069409701290,2024,'2024-12-17 16:09:38',18,1,0,4,'2024-12-17 16:24:38','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 17/12/2024 16:10:50.9710 521 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-12-17 16:10:50','V',5642257999833590,2024,'2024-12-17 16:10:50','456415146400327001012999',2,2,2,'O','',0,'2024-12-17 16:10:50',1,'','',0) 17/12/2024 16:16:52.6630 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:17:13.8939 804 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:17:23.2345 611 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 17/12/2024 16:17:24.4759 1161 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-17 16:17:23' where payTraUID = 4952576963602590 and payStatus='V' and payEnabled=1 17/12/2024 16:17:36.7047 666 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17993, trcLastPrinted = '2400417993', trcLastDate = '2024-12-17 16:17:36' where trcStatus='V' and trcTerId = 4 17/12/2024 16:19:54.3458 1467 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 17/12/2024 16:24:43.7473 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:24:51.5581 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:25:39.6893 840 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 17/12/2024 16:26:22.3869 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:27:07.6278 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:27:23.0782 1040 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:28:12.8518 1060 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 16:28:11' where traUID = 5516731317074510 and traStatus='V' and traEnabled=1 17/12/2024 16:29:06.3051 952 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 16:29: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'; 17/12/2024 16:30:27.2033 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:36:29.2573 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:38:02.3853 1130 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 16:39:59.4552 981 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-17 16:39:58' where payTraUID = 5748839137096160 and payStatus='V' and payEnabled=1 17/12/2024 16:41:22.2875 619 ms. EXEC: update payReceipt set recCreation = '2024-12-17 16:41:21',recModify = '2024-12-17 16:41:21',recUseId=0,recStatus='V' where recId = 333395 17/12/2024 16:52:29.0887 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 17:12:18.9200 1002 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 17:20:11.5826 770 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 17/12/2024 17:20:12.9171 1141 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 17:20:11' where traUID = 5548120591669780 and traStatus='V' and traEnabled=1 17/12/2024 17:21:06.9219 2000 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-17 17:21:04' where subId = 12 17/12/2024 17:21:07.5607 638 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-17 17:21:06','0230004101223',0,0,5432227390853830,11,'0000-00-00 00:00:00','0000-00-00 00:00:00') 17/12/2024 17:21:08.4186 796 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,'2024-12-17 17:21:07','V',5028748263526170,2024,'2024-12-17 17:21:04','456413630200327005012999',2,2,2,'O','',0,'2024-12-17 17:21:07',1,'','0230004101223',11,0) 17/12/2024 17:23:39.5043 999 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 17/12/2024 17:27:47.0390 726 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-12-17 17:27:45',0,'V',5573670243340090,4805413818526730,2024,'2024-12-17 17:27:45',3,1,0,4,'2024-12-17 17:42:45','C','KES',50,200,0,'',' ',' ',2,50,0,0,'',0,0) 17/12/2024 17:27:47.9352 524 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 17:27:47',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 17/12/2024 17:27:48.5930 542 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-17 17:27:48',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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-17 17:27:48',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 17/12/2024 17:41:13.0407 567 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 17/12/2024 17:41:58.8137 1167 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 17:41:57' where traUID = 5261863836167860 and traStatus='V' and traEnabled=1 17/12/2024 17:43:17.7893 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 17:44:39.7002 1141 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 17:45:02.2088 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 17:46:19.2056 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 17:46:45.0119 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 17:53:30.3215 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 17:58:58.0314 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 17:58:59.1736 1216 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 17/12/2024 18:02:11.0170 987 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-17 18:02:10' where payTraUID = 4935569162323220 and payStatus='V' and payEnabled=1 17/12/2024 18:02:20.3998 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:04:32.4639 991 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-12-17 18:04:31','V',4826582453684580,2024,'2024-12-17 18:04:27','456416506700327005012999',1,2,16,'I','',1,0,1,'','',4) 17/12/2024 18:11:39.6158 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:23:31.6508 2191 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 18:23:29',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'; 17/12/2024 18:24:40.8520 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:24:46.5825 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:33:39.1098 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:34:24.2497 1042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:37:01.6197 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:37:16.2061 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:39:47.5086 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:41:51.2796 1196 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:42:17.4141 1018 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:44:05.4969 2413 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:46:45.9617 1262 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:59:24.0365 1633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 18:59:39.6290 504 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53894, trcLastPrinted = '2400753894', trcLastDate = '2024-12-17 18:59:39' where trcStatus='V' and trcTerId = 18 17/12/2024 19:00:37.0718 641 ms. EXECSCALAR: select count(rulId) from tabTicketRules where rulStatus='V' and rulTerId = 2 and rulDevId = 5 and rulTicId = 1 nr: 0 17/12/2024 19:06:05.1160 1440 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 19:07:59.7883 1300 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 19:09:58.1366 751 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 19:10:25.7638 978 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-12-17 19:10:24',0,'V',5526739571029770,5419982499215240,2024,'2024-12-17 19:10:24',18,1,0,4,'2024-12-17 19:25:24','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 17/12/2024 19:11:29.0491 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 19:12:25.1713 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/12/2024 19:13:48.3370 895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 19:15:52.2760 983 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-12-17 19:15:51','V',5015632403695980,2024,'2024-12-17 19:15:50','456416935000327005012999',1,2,16,'I','',1,0,1,'','',4) 17/12/2024 19:18:53.2905 920 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-17 19:18:52' where traUID = 4657645975861210 and traStatus='V' and traEnabled=1 17/12/2024 19:18:53.4166 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 19:18:53.5267 884 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-12-17 19:13:06',6,'V',4645707569067190,5637459026937730,2024,'2024-12-17 19:13:06',4,1,0,4,'2024-12-17 19:28:06','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 17/12/2024 19:50:32.8513 1111 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 19:50:31',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 19:50:31',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'; 17/12/2024 19:52:42.4402 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 19:53:35.0995 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 19:54:36.6289 1464 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-12-17 19:54:35','V',5617297609462240,2024,'2024-12-17 19:54:34','456416816300327001012999',2,2,2,'O','',0,'2024-12-17 19:54:35',1,'','',0) 17/12/2024 19:59:54.4004 532 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 17/12/2024 20:00:38.6354 863 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 20:11:10.6279 643 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53902, trcLastPrinted = '2400753902', trcLastDate = '2024-12-17 20:11:09' where trcStatus='V' and trcTerId = 18 17/12/2024 20:20:58.4128 697 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-17 20:20:57' where payTraUID = 5244016982651300 and payStatus='V' and payEnabled=1 17/12/2024 20:24:39.7665 1056 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 20:27:15.6560 1158 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-17 20:27:14',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'; 17/12/2024 20:35:23.1917 1407 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 17/12/2024 20:35:47.1101 1099 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-17 20:35:46',4,6,'2024-12-17 20:35:46','456414122500327005012999','Payed (Credit Card ) Ticket ') 17/12/2024 20:40:32.5297 1067 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 20:40:50.4481 1889 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-17 20:40:48' where payTraUID = 5193015912218580 and payStatus='V' and payEnabled=1 17/12/2024 20:41:36.1593 1040 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 20:56:49.8772 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 21:14:44.2102 566 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-17 21:14:43' where payTraUID = 4624194635330950 and payStatus='V' and payEnabled=1 17/12/2024 21:22:50.4355 735 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-12-17 21:22:49','V',4996256795170230,2024,'2024-12-17 21:22:48','456417610700327005012999',2,2,2,'O','',0,'2024-12-17 21:22:49',1,'','',0) 17/12/2024 22:35:16.1389 977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 22:35:59.5788 1252 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 22:39:23.5145 2160 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 23:00:07.3856 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 23:04:53.3880 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 23:07:50.7832 1420 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 17/12/2024 23:10:46.7708 772 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/12/2024 23:15:14.9670 1199 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 17/12/2024 23:52:23.6583 734 ms. EXEC: update payReceipt set recCreation = '2024-12-17 23:52:22',recModify = '2024-12-17 23:52:22',recUseId=0,recStatus='V' where recId = 333468