23/12/2024 00:03:07.2856 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 00:03:07.2866 579 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-12-22 23:03:06') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-12-23 00:03:06' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-12-23 00:03:06' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 49 ms.) 23/12/2024 06:27:25.7907 721 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/12/2024 07:55:58.7705 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 08:05:53.3633 680 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-23 08:05:52','V',5249305915898620,2024,'2024-12-23 08:05:50','456468352400327005012999',2,2,2,'O','',0,'2024-12-23 08:05:52',1,'','0230003944081',15,0) 23/12/2024 08:21:35.8838 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 08:35:09.3316 1398 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 08:40:12.4375 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 08:55:05.6296 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 08:56:11.9384 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 09:07:39.3951 1342 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/12/2024 09:07:39.4551 1119 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-23 09:07:38',0,'V',5042568320696470,5386782391312340,2024,'2024-12-23 09:07:38',18,1,0,4,'2024-12-23 09:22:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 23/12/2024 09:08:42.9992 1461 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/12/2024 09:09:16.1554 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 09:09:37.8202 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 09:10:01.7282 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 09:13:04.1795 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 09:18:37.1581 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 09:19:52.7498 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 09:30:59.4813 812 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 09:33:12.3663 1432 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 386159 else acvFstPayId end),acvLstPayId = 386159 where acvSftId = 862 and acvCodeId = 3 23/12/2024 09:33:14.1815 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 09:34:08.7440 790 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 23/12/2024 09:36:36.8310 1371 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 09:37:15.2498 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 09:37:28.3486 1506 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-23 09:37:26' where payTraUID = 4791745223858140 and payStatus='V' and payEnabled=1 23/12/2024 09:47:51.4445 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 10:03:04.0505 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 315 ms.) 23/12/2024 10:18:36.9041 640 ms. EXEC: update payReceipt set recCreation = '2024-12-23 10:18:36',recModify = '2024-12-23 10:18:36',recUseId=0,recStatus='V' where recId = 335328 23/12/2024 10:40:24.1415 1447 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 10:41:38.9705 590 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 10:41:39.1466 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 10:48:21.8593 848 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/12/2024 10:50:24.7461 1007 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-23 10:50:23','V',5116031889864860,2024,'2024-12-23 10:50:22','456473902200327005012999',1,2,16,'I','',1,0,1,'','',4) 23/12/2024 11:04:40.5047 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 11:05:54.2625 551 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-23 11:05:53','V',5210795903485740,2024,'2024-12-23 11:05:52','456473995200327001012999',1,2,1,'I','',1,0,1,'','',4) 23/12/2024 11:05:58.5834 1051 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 23/12/2024 11:05:58.5954 1075 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 11:05:59.0197 564 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/12/2024 11:05:59.9783 683 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 23/12/2024 11:06:00.7488 770 ms. EXEC: update tabArea set areFreePark = areTotalPark where areStatus='V' and areTotalPark > 0 and areFreePark>areTotalPark 23/12/2024 11:06:05.2078 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 11:08:05.0766 1014 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 11:10:05.0283 893 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 11:12:42.8540 524 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 11:17:58.5840 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 11:28:03.1717 970 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-23 11:28:02','V',4650941485478640,2024,'2024-12-23 11:28:01','456474128100327005012999',1,2,16,'I','',1,0,1,'','',4) 23/12/2024 11:29:53.0080 795 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 11:30:06.2972 504 ms. EXEC: update abbCards set carLastDate = '2024-12-23 11:30:05',carLastDirection='O' where carStatus='V' and carId = 99 23/12/2024 11:33:26.2663 661 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-23 11:33:25' where payTraUID = 4998289914054050 and payStatus='V' and payEnabled=1 23/12/2024 11:36:13.9746 623 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 11:36:13' where traUID = 5758907580316410 and traStatus='V' and traEnabled=1 23/12/2024 11:36:23.9262 912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 11:46:34.0106 698 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-23 11:46:33',0,1,'2024-12-23 11:46:33','','Unauthorized Transit Entry 1') (WAIT TIME 48 ms.) 23/12/2024 11:48:09.5785 576 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 11:48:08' where traUID = 5269428970123330 and traStatus='V' and traEnabled=1 23/12/2024 11:55:23.7429 536 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/12/2024 12:13:19.8785 542 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-23 12:13:19','V',4751668297561880,2024,'2024-12-23 12:13:18','456474399800327005012999',1,2,16,'I','',1,0,1,'','',4) 23/12/2024 12:13:25.7908 647 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 12:13:25' where traUID = 5519991774290600 and traStatus='V' and traEnabled=1 23/12/2024 12:17:34.9096 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 12:25:38.4165 1213 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-23 12:25:37',0,'V',4645070260467600,4912833299559430,2024,'2024-12-23 12:25:37',2,1,0,-1,'2024-12-23 13:25:37','S','KES',0,0,0,'','','',3,0,0) 23/12/2024 12:25:39.6553 920 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 12:25:38' where traUID = 4912833299559430 and traStatus='V' and traEnabled=1 23/12/2024 12:31:01.5713 556 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-23 12:31:00',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'; 23/12/2024 12:34:03.5622 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 12:37:14.8375 1001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 12:37:59.4623 533 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 12:38:09.5741 857 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/12/2024 12:38:09.5791 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 12:39:13.7199 504 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 23/12/2024 12:39:14.4775 758 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-23 12:39:13','V',5417475461450060,2024,'2024-12-23 12:39:11','456474555100327005012999',1,2,16,'I','',1,0,1,'','',4) 23/12/2024 12:44:44.3429 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 12:47:37.4964 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-23 12:47:36','V',4665015501776960,2024,'2024-12-23 12:47:36','456474605600327001012999',1,2,1,'I','',1,0,1,'','',4) 23/12/2024 12:49:02.1807 544 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 23/12/2024 13:19:20.6477 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 13:19:40.6401 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 13:19:43.0787 542 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-23 13:19:41',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 23/12/2024 13:22:45.2707 1168 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-23 13:22:44',0,'V',5547180343828990,4779557863648820,2024,'2024-12-23 13:22:44',18,1,0,4,'2024-12-23 13:37:44','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 23/12/2024 13:23:44.8812 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 13:25:53.7237 1050 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-23 13:25:52' where payTraUID = 4779557863648820 and payStatus='V' and payEnabled=1 23/12/2024 13:26:41.6147 767 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 23/12/2024 13:27:07.6443 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 13:27:59.6748 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 13:28:07.8083 873 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-23 13:28:06',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-23 13:28:06',3,42101,0,500,1,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 23/12/2024 13:31:14.7006 836 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 13:48:48.6881 515 ms. EXEC: update payReceipt set recCreation = '2024-12-23 13:48:48',recModify = '2024-12-23 13:48:48',recUseId=0,recStatus='V' where recId = 335441 (WAIT TIME 53 ms.) 23/12/2024 13:55:09.8439 716 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 13:55:34.9299 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 14:02:49.8833 2180 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-23 14:02:47','V',4808149300249700,2024,'2024-12-23 14:02:47','456474906000327005012999',2,2,2,'O','',0,'2024-12-23 14:02:47',1,'','',0) 23/12/2024 14:02:51.5364 1420 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 14:02:50' where traUID = 5090206691190950 and traStatus='V' and traEnabled=1 23/12/2024 14:07:46.5393 839 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-23 14:07:45','V',5086714287125880,2024,'2024-12-23 14:07:44','456475086400327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 23/12/2024 14:07:49.1720 2629 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/12/2024 14:08:47.5622 805 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-23 14:08:46','V',5183234010024060,2024,'2024-12-23 14:08:46','456474935600327005012999',2,2,2,'O','',0,'2024-12-23 14:08:46',1,'','',0) 23/12/2024 14:12:06.6102 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 14:15:42.8082 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 14:18:26.1438 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 14:19:43.8634 653 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/12/2024 14:21:10.9053 689 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 23/12/2024 14:21:51.8377 992 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4805220112822900,5078556624829140,2024,'2024-12-23 14:21:50','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/23/2024 2:03:35 PM Date : 12/23/2024 2:21:49 PM Code : 456475061500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 23/12/2024 14:25:42.5554 548 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/12/2024 14:26:20.9498 941 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/12/2024 14:28:41.0684 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 14:31:01.7538 501 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-23 14:31:00',0,'V',4738376861011850,4743154894832430,2024,'2024-12-23 14:31:00',3,1,0,4,'2024-12-23 14:46:00','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 23/12/2024 14:33:48.3125 1906 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 14:38:30.3079 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 14:43:39.1462 685 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 14:46:38.5402 1363 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 386341 else acvFstPayId end),acvLstPayId = 386341 where acvSftId = 866 and acvCodeId = 3 23/12/2024 14:46:44.7405 989 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-23 14:46:43' where payTraUID = 5351480393268000 and payStatus='V' and payEnabled=1 23/12/2024 14:47:52.9556 609 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-23 14:47:52','V',4927755400534540,2024,'2024-12-23 14:47:51','456474842000327005012999',2,2,2,'O','',0,'2024-12-23 14:47:52',1,'','',0) 23/12/2024 14:47:57.2195 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 14:52:35.6451 546 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-23 14:52:35','V',5256380313593090,2024,'2024-12-23 14:52:34','456475268200327005012999',2,2,2,'O','',0,'2024-12-23 14:52:35',1,'','',0) 23/12/2024 14:52:36.7048 605 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-23 14:52:36' where payTraUID = 5538270006130940 and payStatus='V' and payEnabled=1 23/12/2024 14:53:57.2306 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 14:55:20.9152 721 ms. EXEC: update payReceipt set recCreation = '2024-12-23 14:55:20',recModify = '2024-12-23 14:55:20',recUseId=0,recStatus='V' where recId = 335488 23/12/2024 15:06:03.3412 569 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4617254847649690,5121097377461180,2024,'2024-12-23 15:06:02',' Date: 12/23/2024 3:06:02 PM Code: 456474927300327005012999 Entry Date: 12/23/2024 1:41:13 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400754728 ',0) 23/12/2024 15:08:29.6180 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 15:09:03.3796 1246 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 15:09:02' where traUID = 4617254847649690 and traStatus='V' and traEnabled=1 23/12/2024 15:10:42.6369 1059 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 15:16:05.5863 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 15:17:30.4965 1130 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/12/2024 15:18:08.3729 1242 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/12/2024 15:18:12.5707 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 15:18:14.2508 1289 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-23 15:18:12','V',4870376637839590,2024,'2024-12-23 15:18:12','456474999200327005012999',2,2,2,'O','',0,'2024-12-23 15:18:12',1,'','',0) 23/12/2024 15:18:43.7666 1167 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/12/2024 15:20:46.2804 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 15:25:42.3615 1251 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 15:26:34.4616 586 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-23 15:26:33','V',5714781279410390,2024,'2024-12-23 15:26:33','456475559300327005012999',1,2,16,'I','',1,0,1,'','',4) 23/12/2024 15:27:54.4742 810 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/12/2024 15:28:07.4758 1180 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 15:28:07.8141 1286 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-23 15:28:06',0,16,'2024-12-23 15:28:06','','Unauthorized Transit Entry 2') 23/12/2024 15:28:16.2047 563 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 15:39:13.0925 716 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/12/2024 15:55:05.0889 519 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-23 15:55:04','0810007130453',0,0,5448394233379730,196,'0000-00-00 00:00:00','0000-00-00 00:00:00') 23/12/2024 16:00:48.2507 652 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-23 16:00:47' where payTraUID = 4744887529112590 and payStatus='V' and payEnabled=1 23/12/2024 16:05:45.2582 527 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-23 16:05:44','V',4671659246025680,2024,'2024-12-23 16:05:43','456473117100327005012999',2,2,2,'O','',0,'2024-12-23 16:05:44',1,'','0230004100104',151,0) 23/12/2024 16:13:19.1038 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 16:15:21.9969 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 16:17:13.7653 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 16:25:03.9290 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 16:29:16.3107 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 16:32:57.2987 1046 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 16:34:08.3810 1130 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-23 16:34:07',0,'V',5188422626633160,4987542960549070,2024,'2024-12-23 16:34:07',2,1,0,-1,'2024-12-23 17:34:07','S','KES',0,0,0,'','','',3,0,0) 23/12/2024 16:42:54.2241 955 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-23 16:42:53','0810007154469',-50,3000,5267740646359580,109,'0000-00-00 00:00:00','0000-00-00 00:00:00') 23/12/2024 16:44:01.2644 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 16:51:24.8677 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 16:52:30.5368 615 ms. EXEC: update payReceipt set recCreation = '2024-12-23 16:52:29',recModify = '2024-12-23 16:52:29',recUseId=0,recStatus='V' where recId = 335564 23/12/2024 16:59:28.6967 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 16:59:29.1560 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 17:06:43.4977 669 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/12/2024 17:06:51.1178 792 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-23 17:06:50','V',4915995911500290,2024,'2024-12-23 17:06:49','456475935200327005012999',2,2,2,'O','',0,'2024-12-23 17:06:50',1,'','',0) 23/12/2024 17:09:37.4387 721 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-23 17:09:36',0,0,'V',5729007722942580,4652786658548780,2024,'2024-12-23 17:09:36',3,'KES',-1,50,-50,'N',''); 23/12/2024 17:10:24.2095 570 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/12/2024 17:11:56.0026 510 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 23/12/2024 17:31:54.4353 1320 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-23 17:31:53','V',5330567637202520,2024,'2024-12-23 17:31:51','456476311100327005012999',1,2,16,'I','',1,0,1,'','',4) 23/12/2024 17:33:04.8208 760 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 23/12/2024 17:34:25.0385 1104 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-23 17:34:23' where payTraUID = 5655611335833700 and payStatus='V' and payEnabled=1 23/12/2024 17:40:04.4824 540 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 23/12/2024 17:41:49.5876 1322 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-12-23 17:41:48',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 23/12/2024 17:41:51.5409 1953 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-23 17:41:49',1,2,'2024-12-23 17:41:49','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 23/12/2024 17:49:00.0113 750 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-23 17:48:59',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'; 23/12/2024 17:49:00.8669 854 ms. EXEC: update payInventory set invCreation = '2024-12-23 17:49:00',invModify = '2024-12-23 17:49:00',invUseId=0,invStatus='V' where invId = 227252 23/12/2024 17:49:39.8790 1227 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 17:50:16.3994 884 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 17:59:18.6547 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 18:00:32.5631 513 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 18:00:31' where traUID = 5474899592296860 and traStatus='V' and traEnabled=1 23/12/2024 18:01:28.5285 667 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-23 18:01:26',0,'V',4761898228285210,4935773718493360,2024,'2024-12-23 18:01:26',3,1,0,4,'2024-12-23 18:16:26','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 23/12/2024 18:02:22.3945 1265 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-23 18:02:21','V',4984028469617210,2024,'2024-12-23 18:02:19','456476263300327005012999',2,2,2,'O','',0,'2024-12-23 18:02:21',1,'','',0) 23/12/2024 18:03:30.6872 756 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-23 18:03:29',0,'V',4611846482661280,5330567637202520,2024,'2024-12-23 18:03:29',18,1,0,4,'2024-12-23 18:18:29','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 23/12/2024 18:03:31.3776 583 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5330567637202520,4611846482661280,2024,'2024-12-23 18:03:30',' Date: 12/23/2024 6:03:29 PM Code: 456476311100327005012999 Entry Date: 12/23/2024 5:31:51 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 # 2400754788 ',0) 23/12/2024 18:05:17.3223 1673 ms. EXEC: update payReceipt set recCreation = '2024-12-23 18:05:15',recModify = '2024-12-23 18:05:15',recUseId=0,recStatus='V' where recId = 335615 23/12/2024 18:05:29.1086 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 18:06:39.2021 553 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-23 18:06:38' where subId = 16 23/12/2024 18:06:45.1300 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-23 18:06:44','V',5496976926983040,2024,'2024-12-23 18:06:37','456476519700327005012999',1,2,16,'I','',1,0,1,'','0560008512164',186,0) 23/12/2024 18:42:20.7386 675 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4915150800269410,5274122558637350,2024,'2024-12-23 18:42:20',' Date: 12/23/2024 6:42:19 PM Code: 456476372800327005012999 Entry Date: 12/23/2024 5:42:08 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 # 2400754799 ',0) 23/12/2024 18:42:29.7792 1926 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-23 18:42:27','V',5507152416451880,2024,'2024-12-23 18:42:26','456476673200327001012999',2,2,2,'O','',0,'2024-12-23 18:42:27',1,'','',0) 23/12/2024 18:44:32.6538 858 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-23 18:44:31' where payTraUID = 5349772417379590 and payStatus='V' and payEnabled=1 23/12/2024 18:44:36.3273 753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 18:45:02.5670 1045 ms. EXEC: update payReceipt set recCreation = '2024-12-23 18:45:01',recModify = '2024-12-23 18:45:01',recUseId=0,recStatus='V' where recId = 335634 23/12/2024 18:46:49.5417 1277 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-23 18:46:48','V',4667669701222130,2024,'2024-12-23 18:46:47','456476168500327005012999',2,2,2,'O','',0,'2024-12-23 18:46:48',1,'','',0) 23/12/2024 18:50:33.6724 1756 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 18:50:39.7414 692 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-23 18:50:38',0,'V',5068796998666610,4971219815986610,2024,'2024-12-23 18:50:38',18,1,0,4,'2024-12-23 19:05:38','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 23/12/2024 19:09:28.3381 568 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 19:09:27' where traUID = 4834828066859140 and traStatus='V' and traEnabled=1 23/12/2024 19:21:45.8586 532 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 19:21:45' where traUID = 5162516960480590 and traStatus='V' and traEnabled=1 23/12/2024 19:22:10.1238 704 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 23/12/2024 19:23:15.0484 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 19:43:24.3647 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 19:47:01.6728 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 19:50:21.2320 891 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-23 19:50:20','V',5321564804594370,2024,'2024-12-23 19:50:19','456476982200327005012999',2,2,2,'O','',0,'2024-12-23 19:50:20',1,'','',0) 23/12/2024 20:02:54.2643 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 20:02:56.6254 546 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/12/2024 20:06:29.1586 821 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 20:16:35.3299 1013 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 20:30:31.2851 551 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 20:30:30' where traUID = 5164621662744710 and traStatus='V' and traEnabled=1 23/12/2024 20:30:37.4342 722 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 20:33:24.2988 702 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 23/12/2024 20:33:37.9930 535 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/12/2024 20:34:33.8943 1159 ms. EXEC: update payReceipt set recCreation = '2024-12-23 20:34:32',recModify = '2024-12-23 20:34:32',recUseId=0,recStatus='V' where recId = 335666 23/12/2024 20:38:49.2454 886 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 20:39:31.1704 1897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 20:42:58.1883 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 20:46:00.5479 895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 20:46:52.7062 554 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 20:46:52' where traUID = 5229265171557540 and traStatus='V' and traEnabled=1 23/12/2024 20:46:55.6102 1196 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 23/12/2024 21:08:19.4098 510 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-23 21:08:18' where payTraUID = 5248663865736190 and payStatus='V' and payEnabled=1 23/12/2024 21:28:30.4826 887 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 21:28:56.8222 535 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/12/2024 21:34:53.5583 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/12/2024 21:35:03.4958 739 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/12/2024 21:59:44.6987 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 22:02:34.0599 1235 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-23 22:02:32' where payTraUID = 5439711772135050 and payStatus='V' and payEnabled=1 23/12/2024 22:03:44.4138 1224 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 386598 else acvFstPayId end),acvLstPayId = 386598 where acvSftId = 867 and acvCodeId = 3 23/12/2024 22:06:25.3928 822 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-23 22:06:24' where traUID = 5067147274107920 and traStatus='V' and traEnabled=1 23/12/2024 22:08:58.3927 1106 ms. EXEC: update payReceipt set recCreation = '2024-12-23 22:08:57',recModify = '2024-12-23 22:08:57',recUseId=0,recStatus='V' where recId = 335701 23/12/2024 22:20:34.1947 1156 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 22:22:55.6519 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 22:48:08.9268 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 22:52:30.7399 680 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/12/2024 23:01:47.3222 534 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/12/2024 23:10:21.0456 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 23:10:54.2928 576 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/12/2024 23:10:54.2938 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/12/2024 23:21:49.5020 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1