21/12/2024 00:15:33.2592 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 00:40:52.5656 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 01:02:14.7892 1210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 01:10:52.3864 1064 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 01:11:33.9422 877 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/12/2024 01:12:34.6312 532 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4773397420986930,4726664570154060,2024,'2024-12-21 01:12:34','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/21/2024 12:01:12 AM Date : 12/21/2024 1:12:32 AM Code : 456450007200327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 21/12/2024 01:12:38.6809 1029 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 01:12:48.5245 540 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/12/2024 01:12:49.5182 930 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/12/2024 01:21:24.1959 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 01:33:50.4976 731 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 02:00:24.2804 958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 02:12:56.5334 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 03:03:23.0963 680 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 03:04:36.4973 594 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/12/2024 03:05:01.4670 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 03:09:54.7983 968 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/12/2024 03:40:32.1041 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 04:32:07.3982 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 05:12:29.9786 789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 05:38:00.2189 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 05:38:18.1299 805 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/12/2024 05:38:30.4671 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 05:38:39.9120 603 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/12/2024 05:47:56.9866 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 05:49:16.3312 887 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-21 05:49:15','V',5244720185438180,2024,'2024-12-21 05:49:14','456452095400327005012999',1,2,16,'I','',1,0,1,'','',4) 21/12/2024 06:43:38.7742 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 06:52:16.2546 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 07:58:05.5306 711 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456451872900327001012999' 21/12/2024 08:11:56.5743 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 08:13:55.1112 832 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/12/2024 08:24:31.2430 923 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:19',5,3,42101,0,50,-21,-1050,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:19',5,3,42101,0,50,21,1050,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:19',5,3,42101,0,100,-42,-4200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:19',5,3,42101,0,100,42,4200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:19',5,3,42101,0,200,-11,-2200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:19',5,3,42101,0,200,11,2200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:19',5,3,42101,0,500,-2,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:19',5,3,42101,0,500,2,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:19',5,3,42101,0,1000,-2,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:19',5,3,42101,0,1000,2,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:19',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 21/12/2024 08:24:32.0085 508 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:25',5,3,42101,0,50,-29,-1450,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:25',5,3,42101,0,100,-47,-4700,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:25',5,3,42101,0,200,-13,-2600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:25',5,3,42101,0,500,-5,-2500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:25',5,3,42101,0,1000,-2,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:24:25',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 21/12/2024 08:27:44.1660 552 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 21/12/2024 08:27:44.2330 1079 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/12/2024 08:39:46.8055 539 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-21 08:39:46',0,0,'V',5034556520751150,4909834723385330,2024,'2024-12-21 08:39:46',3,'KES',-1,100,-100,'N',''); 21/12/2024 08:39:48.0113 732 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 08:39:46',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-21 08:39:46',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-21 08:39:46',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'; 21/12/2024 08:40:48.6818 795 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-21 08:40:47','V',4794978807148670,2024,'2024-12-21 08:40:47','456453124700327005012999',1,2,16,'I','',1,0,1,'','',4) 21/12/2024 08:41:08.5721 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 09:23:50.0758 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 09:25:48.7799 650 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-21 09:25:47' where traUID = 5080002532235610 and traStatus='V' and traEnabled=1 21/12/2024 09:29:58.7314 529 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-21 09:29:58','V',5020820366640930,2024,'2024-12-21 09:29:57','456453419700327005012999',1,2,16,'I','',1,0,1,'','',4) 21/12/2024 09:45:48.9445 539 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 09:45:48',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-21 09:45:48',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'; 21/12/2024 09:58:50.8899 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 10:01:14.3633 593 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 10:01:45.8904 505 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-21 10:01:45',0,0,'V',4709460274498390,4655104791478970,2024,'2024-12-21 10:01:45',3,'KES',1,50,50,'N',''); 21/12/2024 10:01:46.5109 520 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-21 10:01:45',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'; 21/12/2024 10:03:45.3095 1013 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 10:09:26.8732 672 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/12/2024 10:12:49.9929 643 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 10:21:48.5808 701 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/12/2024 10:34:42.8925 1095 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 3 ms.) 21/12/2024 10:36:21.3139 716 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-21 10:36:20',0,0,'V',5127512168280730,5576445594581730,2024,'2024-12-21 10:36:20',3,'KES',1,200,200,'N',''); 21/12/2024 10:40:47.0659 568 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-21 10:40:46','V',5444729009442190,2024,'2024-12-21 10:40:45','456453656200327005012999',2,2,2,'O','',0,'2024-12-21 10:40:46',1,'','0230003957444',26,0) 21/12/2024 10:47:38.9903 698 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/12/2024 10:49:50.7874 740 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-21 10:49:49',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'; 21/12/2024 10:51:21.6051 886 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-21 10:51:20' where traUID = 4794978807148670 and traStatus='V' and traEnabled=1 21/12/2024 10:51:51.0237 1662 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-21 10:51:49','V',5601430877430620,2024,'2024-12-21 10:51:48','456453818900327005012999',2,2,2,'O','',0,'2024-12-21 10:51:49',1,'','',0) 21/12/2024 10:52:04.9430 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 ('2024-12-21 10:52:03',0,'V',5331744756134280,4764982058950690,2024,'2024-12-21 10:52:03',18,1,0,4,'2024-12-21 11:07:03','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 21/12/2024 10:56:15.3001 1241 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 10:56:14',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-21 10:56:14',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'; 21/12/2024 10:57:33.3853 842 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/12/2024 10:58:07.1158 643 ms. EXEC: update paycash set casCreation = '2024-12-21 10:58:06',casModify = '2024-12-21 10:58:06',casUseId=0,casStatus='V' where casId = 201166 21/12/2024 10:58:43.2950 511 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-21 10:58:42','V',5008000532731150,2024,'2024-12-21 10:58:41','456453828100327005012999',2,2,2,'O','',0,'2024-12-21 10:58:42',1,'','',0) 21/12/2024 10:58:44.7260 1313 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/12/2024 10:59:26.4058 918 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/12/2024 10:59:44.8512 907 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-21 10:59:43' where subId = 16 21/12/2024 10:59:46.3822 606 ms. EXEC: update abbCards set carLastDate = '2024-12-21 10:59:45',carLastDirection='O' where carStatus='V' and carId = 15 21/12/2024 10:59:47.4889 582 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-21 10:59:46' where payTraUID = 4832368125184740 and payStatus='V' and payEnabled=1 21/12/2024 11:01:28.5526 1072 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 11:01:28.5526 1089 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-21 11:01:27','V',5100551950301220,2024,'2024-12-21 11:01:26','456453712900327005012999',2,2,2,'O','',0,'2024-12-21 11:01:27',1,'','',0) 21/12/2024 11:01:56.4313 743 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/12/2024 11:06:34.5511 967 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-21 11:06:33','V',5734609590577600,2024,'2024-12-21 11:06:30','456453999000327005012999',1,2,16,'I','',1,0,1,'','0230003939927',164,0) 21/12/2024 11:08:42.6597 1160 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-21 11:08:41',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-21 11:08:41',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'; 21/12/2024 11:08:43.0500 844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 11:11:00.2287 862 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-21 11:10:59','V',5542543581620400,2024,'2024-12-21 11:10:57','456454025700327001012999',1,2,1,'I','',1,0,1,'','',4) 21/12/2024 11:12:32.8005 600 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/12/2024 11:13:55.9381 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 11:19:02.2602 572 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-21 11:19:01','V',5574971598394740,2024,'2024-12-21 11:19:01','456454074100327005012999',1,2,16,'I','',1,0,1,'','',4) 21/12/2024 11:31:02.5244 783 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-21 11:31:01' where payTraUID = 4865108121107860 and payStatus='V' and payEnabled=1 21/12/2024 11:46:18.4010 684 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/12/2024 11:50:20.5148 1000 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 11:51:58.3773 529 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4655838774904390,4693549431324930,2024,'2024-12-21 11:51:57',' Date: 12/21/2024 11:51:57 AM Code: 456454177200327005012999 Entry Date: 12/21/2024 11:36:12 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 # 2400754398 ',0) 21/12/2024 11:53:21.8851 764 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/12/2024 11:57:52.3214 1605 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-21 11:57:50','V',4656512093834110,2024,'2024-12-21 11:57:49','456454306900327001012999',1,2,1,'I','',1,0,1,'','',4) 21/12/2024 12:04:30.1194 686 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4962681536268650,4630699869723020,2024,'2024-12-21 12:04:29','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/21/2024 11:22:28 AM Date : 12/21/2024 12:04:28 PM Code : 456454094800327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 50.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',0) 21/12/2024 12:04:30.6328 513 ms. EXEC: update payReceipt set recCreation = '2024-12-21 12:04:30',recModify = '2024-12-21 12:04:30',recUseId=0,recStatus='V' where recId = 334686 21/12/2024 12:06:55.2595 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 12:08:30.6402 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 12:09:57.8322 526 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 12:11:15.0733 613 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-21 12:11:14',17,6,'2024-12-21 12:11:14','456453332200327005012999','Pagato (Contanti ) Biglietto ') 21/12/2024 12:12:34.5634 551 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-21 12:12:33' where traUID = 4635592490788810 and traStatus='V' and traEnabled=1 21/12/2024 12:14:14.1377 535 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 12:15:29.0220 752 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-21 12:15:28',0,'V',5760724419602530,5089902083845480,2024,'2024-12-21 12:15:28',18,1,0,4,'2024-12-21 12:30:28','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 21/12/2024 12:26:44.9943 581 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/12/2024 12:30:56.4227 569 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 12:40:47.8284 646 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 12:53:56.3392 691 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-21 12:53:55','V',5180956310123870,2024,'2024-12-21 12:53:54','456454600400327005012999',2,2,2,'O','',0,'2024-12-21 12:53:55',1,'','',0) 21/12/2024 12:57:05.2958 525 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/12/2024 12:57:23.7643 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-21 12:57:23','V',4850477477533520,2024,'2024-12-21 12:57:22','456454549600327005012999',2,2,2,'O','',0,'2024-12-21 12:57:23',1,'','',0) 21/12/2024 13:02:21.5609 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 13:04:08.1596 911 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 13:04:29.4432 623 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-21 13:04:28' where payTraUID = 5473265821860330 and payStatus='V' and payEnabled=1 21/12/2024 13:04:54.3538 907 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-21 13:04:53','V',5135307077585570,2024,'2024-12-21 13:04:52','456454530400327005012999',2,2,2,'O','',0,'2024-12-21 13:04:53',1,'','',0) 21/12/2024 13:05:44.9376 692 ms. EXEC: update payReceipt set recCreation = '2024-12-21 13:05:44',recModify = '2024-12-21 13:05:44',recUseId=0,recStatus='V' where recId = 334722 21/12/2024 13:05:59.1972 1350 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 13:06:18.5715 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 13:06:56.6561 1323 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-21 13:06:54',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'; 21/12/2024 13:09:39.8856 1422 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/12/2024 13:10:37.0929 912 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/12/2024 13:13:41.3304 819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 13:16:12.0206 1683 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 13:19:46.2278 586 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/12/2024 13:21:40.9695 561 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 385505 else acvFstPayId end),acvLstPayId = 385505 where acvSftId = 862 and acvCodeId = 3 21/12/2024 13:21:41.6659 538 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4679817606287770,5006342567700970,2024,'2024-12-21 13:21:41',' Date: 12/21/2024 1:18:08 PM Code: 456454501600327005012999 Entry Date: 12/21/2024 12:30:16 PM 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 # 2400418248 ',0) 21/12/2024 13:24:51.2931 734 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/12/2024 13:33:53.9178 714 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-21 13:33:53',0,'V',4818164997436580,5537329772318090,2024,'2024-12-21 13:33:53',18,1,0,4,'2024-12-21 13:48:53','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 21/12/2024 13:38:28.7854 548 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/12/2024 13:45:16.1846 1090 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 14:02:21.2635 609 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-21 14:02:20','V',4988012990150660,2024,'2024-12-21 14:02:19','456455053900327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 21/12/2024 14:16:18.9817 801 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-21 14:16:18' where traUID = 5221846597535670 and traStatus='V' and traEnabled=1 21/12/2024 14:17:32.5125 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 14:20:06.1590 1315 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 14:22:18.9007 671 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-21 14:22:18',4,1,'2024-12-21 14:22:18','456455099200327005012999','Payed (Credit Card ) Ticket ') 21/12/2024 14:24:33.8640 1012 ms. EXEC: update payReceipt set recCreation = '2024-12-21 14:24:32',recModify = '2024-12-21 14:24:32',recUseId=0,recStatus='V' where recId = 334764 21/12/2024 14:27:29.8359 889 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 14:27:32.0624 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 14:27:47.2276 648 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-21 14:27:46','V',4938212814848400,2024,'2024-12-21 14:27:45','456454547900327005012999',2,2,2,'O','',0,'2024-12-21 14:27:46',1,'','',0) 21/12/2024 14:28:37.2352 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 14:39:55.4823 1404 ms. EXEC: update payReceipt set recCreation = '2024-12-21 14:39:54',recModify = '2024-12-21 14:39:54',recUseId=0,recStatus='V' where recId = 334770 21/12/2024 14:40:41.3011 593 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4990810253916540,4828971635734080,2024,'2024-12-21 14:40:40',' Date: 12/21/2024 2:40:40 PM Code: 456455212000327005012999 Entry Date: 12/21/2024 2:28:40 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 # 2400754434 ',0) 21/12/2024 14:41:45.6291 1407 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-21 14:41:44','V',5685198642585400,2024,'2024-12-21 14:41:43','456455290300327005012999',1,2,16,'I','',1,0,1,'','',4) 21/12/2024 14:47:20.9008 991 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 14:53:29.0718 760 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 385552 else acvFstPayId end),acvLstPayId = 385552 where acvSftId = 863 and acvCodeId = 3 21/12/2024 14:57:23.2034 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 15:07:07.3561 716 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 15:15:39.2532 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 15:35:29.6070 934 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 15:38:40.1341 1243 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 15:39:11.9783 1592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 15:41:47.9947 819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 15:44:54.6696 663 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 15:47:00.8380 525 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/12/2024 15:53:07.3874 857 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 15:57:15.8695 1682 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-21 15:57:14' where payTraUID = 5685198642585400 and payStatus='V' and payEnabled=1 21/12/2024 15:57:17.2424 1370 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-21 15:57:14' where traUID = 5685198642585400 and traStatus='V' and traEnabled=1 21/12/2024 15:58:17.1014 1844 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-21 15:58:15','V',5192084907330890,2024,'2024-12-21 15:58:14','456455697300327005012999',2,2,2,'O','',0,'2024-12-21 15:58:15',1,'','',0) 21/12/2024 15:58:20.9169 1248 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 15:58:25.6731 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 15:59:29.9691 917 ms. EXEC: update paycash set casCreation = '2024-12-21 15:59:29',casModify = '2024-12-21 15:59:29',casUseId=0,casStatus='V' where casId = 201243 21/12/2024 15:59:39.4965 1243 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/12/2024 15:59:57.2673 1129 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/12/2024 16:03:44.7391 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 16:04:39.1555 1041 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5250100095497300,5095022867906060,2024,'2024-12-21 16:04:38','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/21/2024 3:50:26 PM Date : 12/21/2024 4:04:36 PM Code : 456455702600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 21/12/2024 16:06:24.9082 1164 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); 21/12/2024 16:08:08.0719 505 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 16:10:17.1333 611 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/12/2024 16:10:17.1383 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 16:11:36.7505 1229 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-21 16:11:35','V',4830315655371910,2024,'2024-12-21 16:11:34','456455829400327005012999',1,2,16,'I','',1,0,1,'','',4) 21/12/2024 16:11:46.2589 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 16:13:43.1270 644 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-21 16:13:42','V',5237042279070240,2024,'2024-12-21 16:13:41','456455429800327005012999',2,2,2,'O','',0,'2024-12-21 16:13:42',1,'','',0) 21/12/2024 16:15:10.0819 1223 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 21/12/2024 16:15:28.0750 1337 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 16:15:41.3803 557 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-21 16:15:40',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'; 21/12/2024 16:18:30.9743 954 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 16:48:30.0047 620 ms. EXEC: update payInventory set invCreation = '2024-12-21 16:48:29',invModify = '2024-12-21 16:48:29',invUseId=0,invStatus='V' where invId = 226785 21/12/2024 16:53:54.5274 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 17:08:11.5474 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 17:13:00.0187 552 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 17:21:26.6246 926 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-21 17:21:25',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'; 21/12/2024 17:47:10.6191 1484 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 17:51:06.9839 765 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-21 17:51:06',0,16,'2024-12-21 17:51:06','','Unauthorized Transit Entry 2') 21/12/2024 18:00:26.9611 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 18:03:19.6676 877 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 18:08:03.6417 904 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/12/2024 18:21:21.4784 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 18:23:36.0053 611 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-21 18:23:35','V',5067316961200560,2024,'2024-12-21 18:23:34','456456621400327005012999',1,2,16,'I','',1,0,1,'','',4) 21/12/2024 18:25:13.9887 1311 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-21 18:25:12' where traUID = 5501659391866790 and traStatus='V' and traEnabled=1 21/12/2024 18:28:38.3594 576 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-21 18:28:37','V',5140990415703200,2024,'2024-12-21 18:28:36','456456197800327005012999',2,2,2,'O','',0,'2024-12-21 18:28:37',1,'','',0) 21/12/2024 18:47:44.5716 1898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 18:48:23.1454 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 18:49:15.4692 946 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 21/12/2024 18:49:49.4748 788 ms. EXEC: update payInventory set invCreation = '2024-12-21 18:49:48',invModify = '2024-12-21 18:49:48',invUseId=0,invStatus='V' where invId = 226812 21/12/2024 19:22:58.0008 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 19:27:03.8868 666 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 21/12/2024 19:28:07.7502 674 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/12/2024 19:29:36.6625 532 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/12/2024 19:36:01.1145 637 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-21 19:36:00' where traUID = 4838378083355620 and traStatus='V' and traEnabled=1 21/12/2024 19:39:38.3133 694 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 19:50:24.2500 536 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 19:56:35.8759 529 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/12/2024 19:58:09.9896 803 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-21 19:58:09' where payTraUID = 5575941901649740 and payStatus='V' and payEnabled=1 21/12/2024 20:18:11.0951 1189 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 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)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 21/12/2024 20:23:31.7994 668 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-21 20:23:30' where traUID = 5005189512028940 and traStatus='V' and traEnabled=1 21/12/2024 20:25:31.5361 566 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/12/2024 20:33:35.6840 1112 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/12/2024 20:36:01.8283 826 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 20:41:51.1978 1292 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); (WAIT TIME 27 ms.) 21/12/2024 20:46:00.4122 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 20:47:10.2384 841 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/12/2024 20:49:45.4994 960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 20:49:46.2959 533 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-21 20:49:45',0,0,'V',5573521478354630,5205473491531020,2024,'2024-12-21 20:49:45',3,'KES',1,100,100,'N',''); 21/12/2024 20:51:25.8981 848 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 20:53:37.2171 618 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/12/2024 21:01:55.2634 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 21:12:23.7797 544 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 21:14:09.2742 545 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-21 21:14:08',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'; 21/12/2024 21:19:11.5925 556 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5688192214929980,5097424798044270,2024,'2024-12-21 21:19:11','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/21/2024 7:50:22 PM Date : 12/21/2024 9:19:10 PM Code : 456457142200327001012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 21/12/2024 21:19:33.7143 618 ms. EXEC: update tabTerminalReceipt set trcProgressive = 18265, trcLastPrinted = '2400418265', trcLastDate = '2024-12-21 21:19:33' where trcStatus='V' and trcTerId = 4 21/12/2024 21:20:32.3598 951 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5694833656199410,5666585251744120,2024,'2024-12-21 21:20:31','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/21/2024 8:58:57 PM Date : 12/21/2024 9:20:30 PM Code : 456457553700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',0) 21/12/2024 21:21:50.1582 756 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-21 21:21:49' where traUID = 5280350195866420 and traStatus='V' and traEnabled=1 21/12/2024 21:42:39.0654 606 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-21 21:42:38' where payTraUID = 5121398347392750 and payStatus='V' and payEnabled=1 21/12/2024 21:44:47.0915 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 22:01:54.0992 562 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/12/2024 22:23:37.9047 564 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2024 22:23:42.8269 962 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-21 22:23:35',0,'V',5209333713012510,5353112857032320,2024,'2024-12-21 22:23:35',3,1,0,4,'2024-12-21 22:38:35','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 21/12/2024 22:23:47.4630 1637 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 22:23:51.4377 899 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 22:25:33.5681 906 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 22:38:08.8439 782 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 22:54:21.0905 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 23:16:42.9025 1138 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-21 23:16:41',3,42101,0,50,2,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 21/12/2024 23:18:14.8436 2122 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 23:18:21.7272 760 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-21 23:18:20',0,'V',4972670469984950,5453634713604400,2024,'2024-12-21 23:18:20',18,1,0,4,'2024-12-21 23:33:20','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 21/12/2024 23:20:25.3399 1766 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-21 23:20:23','V',5286694198557290,2024,'2024-12-21 23:20:22','456458223400327005012999',2,2,2,'O','',0,'2024-12-21 23:20:23',1,'','',0) 21/12/2024 23:31:52.8383 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/12/2024 23:37:13.6098 582 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/12/2024 23:43:13.3843 1569 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/12/2024 23:46:24.5171 537 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/12/2024 23:50:07.1068 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1