16/12/2024 00:06:50.9841 1051 ms. EXEC: update payInventory set invCreation = '2024-12-16 00:06:49',invModify = '2024-12-16 00:06:49',invUseId=0,invStatus='V' where invId = 225556 16/12/2024 00:09:23.9365 670 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/12/2024 00:09:23.9476 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 00:36:08.5867 819 ms. EXEC: update payReceipt set recCreation = '2024-12-16 00:36:07',recModify = '2024-12-16 00:36:07',recUseId=0,recStatus='V' where recId = 332814 16/12/2024 00:37:02.3393 528 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-16 00:37:01',0,'V',4635541850667940,5044111887308900,2024,'2024-12-16 00:37:01',18,1,0,4,'2024-12-16 00:52:01','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 16/12/2024 00:38:16.0376 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 00:59:27.1170 1955 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 01:04:19.2289 1144 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 01:05:02.6398 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 01:50:02.8397 553 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 01:51:29.2651 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 01:53:12.6780 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 02:06:19.5096 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 02:31:31.0708 917 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 03:12:16.9930 789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 03:27:46.3336 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 03:37:35.2108 1417 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 05:55:05.7641 1064 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 05:55:42.3403 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 06:02:49.9407 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 06:10:34.3727 752 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17887, trcLastPrinted = '2400417887', trcLastDate = '2024-12-16 06:10:33' where trcStatus='V' and trcTerId = 4 (WAIT TIME 1 ms.) 16/12/2024 06:13:08.2761 770 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-16 06:13:07','V',4873881521748040,2024,'2024-12-16 06:13:06','456402115900327005012999',2,2,2,'O','',0,'2024-12-16 06:13:07',1,'','',0) 16/12/2024 06:47:47.7961 886 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 06:49:44.3475 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 06:50:22.7418 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 06:53:15.0143 1407 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 06:56:55.7867 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 07:11:24.3716 856 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-16 07:11:23','V',5481942935109400,2024,'2024-12-16 07:11:22','456402588200327005012999',1,2,16,'I','',1,0,1,'','',4) 16/12/2024 07:14:02.0252 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 07:26:54.1684 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 08:06:11.0936 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 08:07:26.6150 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 08:20:12.7535 1344 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 08:20:02',5,3,42101,0,50,-2,-100,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 08:20:02',5,3,42101,0,50,2,100,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 08:20:02',5,3,42101,0,100,-39,-3900,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 08:20:02',5,3,42101,0,100,39,3900,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 08:20:02',5,3,42101,0,200,-3,-600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 08:20:02',5,3,42101,0,200,3,600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 08:20:02',5,3,42101,0,500,-5,-2500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 08:20:02',5,3,42101,0,500,5,2500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 08:20:02',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 16/12/2024 08:20:57.0935 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 08:24:22.4929 643 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 08:24:16',5,3,42101,0,50,12,600,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+12,5),curAmount=round(curAmount+600,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 08:24:16',5,3,42101,0,100,4,400,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+4,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 16/12/2024 08:31:49.6926 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 08:40:19.4796 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 08:41:02.6310 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 08:51:10.2314 575 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-16 08:51:09','V',5655151417266590,2024,'2024-12-16 08:51:08','456403186800327001012999',1,2,1,'I','',1,0,1,'','',4) 16/12/2024 08:52:15.4564 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 09:22:43.6967 878 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-16 09:22:42' where payTraUID = 5749652089714760 and payStatus='V' and payEnabled=1 16/12/2024 09:22:47.4089 715 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 09:26:42.2510 776 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 16/12/2024 09:46:09.5393 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 09:46:09.8396 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 09:49:59.2256 665 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 09:53:57.2148 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 09:54:42.8419 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 10:04:33.8707 1066 ms. EXEC: update abbCards set carLastDate = '2024-12-16 10:04:32',carLastDirection='I' where carStatus='V' and carId = 14 16/12/2024 10:06:32.9595 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 10:10:46.9900 1411 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5336352830053900,5204556895346940,2024,'2024-12-16 10:10:45',' Date: 12/16/2024 10:05:50 AM Code: 456403592800327005012999 Entry Date: 12/16/2024 9:58:48 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400417895 ',0) 16/12/2024 10:16:39.5955 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 10:20:39.3305 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 10:20:52.7126 693 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/12/2024 10:48:33.7809 543 ms. EXEC: update abbCards set carLastDate = '2024-12-16 10:48:33',carLastDirection='O' where carStatus='V' and carId = 185 16/12/2024 10:48:35.0363 1197 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 10:48:41.2803 2255 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 10:55:32.6387 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 10:59:42.8286 647 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 16/12/2024 11:02:08.9813 976 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-16 11:02:08','V',4712893242978160,2024,'2024-12-16 11:02:05','456403972500327005012999',1,2,16,'I','',1,0,1,'','',4) 16/12/2024 11:07:10.4020 858 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-16 11:07:09','V',5600007852749390,2024,'2024-12-16 11:07:08','456403757100327005012999',2,2,2,'O','',0,'2024-12-16 11:07:09',1,'','',0) 16/12/2024 11:07:34.3940 644 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 11:16:39.6487 1142 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 11:21:42.4837 666 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-16 11:21:41' where payTraUID = 5194875400756160 and payStatus='V' and payEnabled=1 16/12/2024 11:22:26.3601 1597 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 11:27:23.9170 2114 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-16 11:27:21',0,'V',5354631582608660,5080810031685210,2024,'2024-12-16 11:27:21',2,1,0,-1,'2024-12-16 12:27:21','S','KES',0,0,0,'','','',3,0,0) 16/12/2024 11:32:50.2687 619 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/12/2024 11:34:50.9686 935 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-16 11:34:50','V',5336697499174070,2024,'2024-12-16 11:34:48','456404168800327005012999',1,2,16,'I','',1,0,1,'','',4) 16/12/2024 11:34:51.9066 834 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 16/12/2024 11:51:38.8223 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-16 11:51:38','V',5542522097084190,2024,'2024-12-16 11:51:37','456403964400327005012999',2,2,2,'O','',0,'2024-12-16 11:51:38',1,'','',0) 16/12/2024 11:51:41.9237 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 11:56:59.1278 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 12:09:11.8998 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 12:12:01.5059 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 12:19:24.2682 526 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-16 12:19:23','V',5094679881053370,2024,'2024-12-16 12:19:22','456404436200327001012999',1,2,1,'I','',1,0,1,'','',4) 16/12/2024 12:30:48.3635 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 12:33:05.0048 946 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-16 12:33:04' where traUID = 5348147815814740 and traStatus='V' and traEnabled=1 16/12/2024 12:51:01.1572 549 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-16 12:51:00','V',5247377798426080,2024,'2024-12-16 12:51:00','456404626000327005012999',1,2,16,'I','',1,0,1,'','',4) 16/12/2024 13:00:46.5621 1754 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-16 13:00:44','V',5707256703642180,2024,'2024-12-16 13:00:44','456404684400327005012999',1,2,16,'I','',1,0,1,'','',4) 16/12/2024 13:09:27.0019 1363 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 13:09:36.2223 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 13:09:46.7912 560 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-16 13:04:46',6,'V',5080407476822710,5469928426284510,2024,'2024-12-16 13:04:46',4,1,0,4,'2024-12-16 13:19:46','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 16/12/2024 13:09:47.6001 619 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 383376 else acvFstPayId end),acvLstPayId = 383376 where acvSftId = 836 and acvCodeId = 3 16/12/2024 13:14:04.7207 805 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 13:22:52.2285 844 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 16/12/2024 13:22:53.7191 855 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 13:22:54.3849 665 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 16/12/2024 13:22:54.5531 988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 13:24:44.7729 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 13:44:41.8049 846 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-16 13:44:40',0,0,'V',5657369001361090,4697367126044170,2024,'2024-12-16 13:44:40',3,'KES',1,200,200,'N',''); 16/12/2024 13:51:10.9094 881 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/12/2024 13:51:10.9154 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 13:56:21.4108 845 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-16 13:56:20',0,'V',5582926412298720,4969043402216470,2024,'2024-12-16 13:56:20',18,1,0,4,'2024-12-16 14:11:20','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 16/12/2024 13:57:23.1105 1117 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/12/2024 14:00:00.3577 1297 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-16 13:59:59',0,'V',5762934218696550,4987405526526400,2024,'2024-12-16 13:59:59',18,1,0,4,'2024-12-16 14:14:59','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 16/12/2024 14:00:01.2077 610 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4987405526526400,5762934218696550,2024,'2024-12-16 14:00:00',' Date: 12/16/2024 1:59:59 PM Code: 456404062300327005012999 Entry Date: 12/16/2024 11:17:03 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400753699 ',0) 16/12/2024 14:00:19.2750 923 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5461891695623790,5028779363519320,2024,'2024-12-16 14:00:18',' Date: 12/16/2024 1:55:17 PM Code: 456404873700327005012999 Entry Date: 12/16/2024 1:32:17 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 # 2400417914 ',0) 16/12/2024 14:00:20.1020 824 ms. EXEC: update payReceipt set recCreation = '2024-12-16 14:00:19',recModify = '2024-12-16 14:00:19',recUseId=0,recStatus='V' where recId = 332955 16/12/2024 14:00:57.7984 1535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 14:01:08.2432 1109 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-16 14:01:07','0810007108790',2000,6050,5467849854846940,194,'2024-01-01 00:00:00','2024-12-31 23:59:59') 16/12/2024 14:01:10.5128 1988 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-16 14:01:07',0,'V',5467849854846940,0,2024,'2024-12-16 14:01:07',15,0,'2024-12-16 14:01:08',-1,'2024-12-16 15:01:07','C','KES',2000,2000,0,'','','',8,2000,0,0,'',0,0) 16/12/2024 14:01:19.7271 946 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-16 14:01:18',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'; 16/12/2024 14:01:52.3950 622 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 16/12/2024 14:02:49.7996 608 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-16 14:02:49','V',5662433529765440,2024,'2024-12-16 14:02:48','456404873700327005012999',2,2,2,'O','',0,'2024-12-16 14:02:49',1,'','',0) 16/12/2024 14:09:51.9724 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 14:10:13.5217 965 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-16 14:10:12','V',5368440892034680,2024,'2024-12-16 14:10:12','456405101200327005012999',1,2,16,'I','',1,0,1,'','',4) 16/12/2024 14:10:14.4968 532 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 16/12/2024 14:11:13.2230 1708 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-16 14:11:11',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 14:11:11',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 14:11:11',3,42101,0,200,1,200,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N'; 16/12/2024 14:11:23.7658 1264 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 14:11:49.5679 1076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 14:12:58.1602 1130 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 14:15:11.6607 615 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 16/12/2024 14:15:34.6085 568 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 14:15:54.2256 589 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/12/2024 14:15:57.6515 957 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-16 14:15:56' where traUID = 4867160253451770 and traStatus='V' and traEnabled=1 16/12/2024 14:18:42.4762 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 14:21:06.2853 897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 14:23:55.7047 643 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5247377798426080,5517679873893740,2024,'2024-12-16 14:23:55',' Date: 12/16/2024 2:23:54 PM Code: 456404626000327005012999 Entry Date: 12/16/2024 12:51:00 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 # 2400753709 ',0) 16/12/2024 14:42:20.9635 517 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-16 14:42:20' where payTraUID = 5044676018170650 and payStatus='V' and payEnabled=1 16/12/2024 14:55:58.9002 509 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 383444 else acvFstPayId end),acvLstPayId = 383444 where acvSftId = 836 and acvCodeId = 3 16/12/2024 14:55:59.7511 848 ms. EXECSCALAR: select terAddress from tabTerminal where terId = 16 nr: 5 16/12/2024 15:16:05.5219 781 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 15:24:45.9075 1011 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 16/12/2024 15:24:46.1648 864 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 15:25:44.5565 683 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 15:25:44.7056 603 ms. OPEN: show columns from tabArea where Field = 'areType' 16/12/2024 15:25:52.5101 686 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 16/12/2024 15:25:55.8058 694 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-16 15:25:55','V',4861032048482490,2024,'2024-12-16 15:25:54','456405555400327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 16/12/2024 15:32:25.8445 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 15:42:16.9301 571 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-16 15:42:16','V',5698807436770670,2024,'2024-12-16 15:42:15','456405447400327005012999',2,2,2,'O','',0,'2024-12-16 15:42:16',1,'','',0) 16/12/2024 15:45:14.5374 558 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-16 15:45:13','V',5486991719746980,2024,'2024-12-16 15:45:13','456405671300327005012999',1,2,16,'I','',1,0,1,'','',4) 16/12/2024 15:51:48.0489 540 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-16 15:51:47','V',5574144424542660,2024,'2024-12-16 15:51:47','456405424500327005012999',2,2,2,'O','',0,'2024-12-16 15:51:47',1,'','',0) 16/12/2024 16:04:37.5856 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 16:20:10.6793 585 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/12/2024 16:21:10.2178 1548 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 16/12/2024 16:21:10.2638 1072 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 16:21:47.3263 661 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-16 16:21:46',0,0,'V',4870791220135610,4647650087059460,2024,'2024-12-16 16:21:46',3,'KES',1,100,100,'N',''); 16/12/2024 16:21:48.1793 646 ms. EXEC: update payInventory set invCreation = '2024-12-16 16:21:47',invModify = '2024-12-16 16:21:47',invUseId=0,invStatus='V' where invId = 225692 16/12/2024 16:23:44.1112 589 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 16:26:01.0070 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 16:26:41.3545 1207 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-16 16:26:40' where payTraUID = 5715245647243050 and payStatus='V' and payEnabled=1 16/12/2024 16:28:07.1401 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 16:28:17.4027 750 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/12/2024 16:28:23.8500 542 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/12/2024 16:36:15.9870 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 16:36:24.8250 1118 ms. OPEN: show columns from tabTariff where Field = 'tarEnableTimeControl' 16/12/2024 16:36:41.4457 1008 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 16/12/2024 16:41:21.1348 757 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 16/12/2024 16:41:52.1268 542 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 16:43:39.6089 962 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/12/2024 16:44:16.1941 1800 ms. EXEC: update abbCards set carLastDate = '2024-12-16 16:44:14',carLastDirection='O' where carStatus='V' and carId = 111 16/12/2024 16:45:12.8460 920 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 16:45:22.6921 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 16:49:03.5797 911 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 16:51:20.3456 789 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/12/2024 16:55:35.6176 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 16:58:28.5098 917 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 16:59:11.5537 729 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53740, trcLastPrinted = '2400753740', trcLastDate = '2024-12-16 16:59:10' where trcStatus='V' and trcTerId = 18 16/12/2024 17:01:00.7967 786 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 17:01:26.0483 770 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 17:15:30.7118 1182 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 17:34:42.1902 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 17:42:10.9266 948 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-16 17:42:09' where payTraUID = 5533577615205080 and payStatus='V' and payEnabled=1 16/12/2024 17:43:14.5441 736 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-16 17:43:13',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'; 16/12/2024 17:53:19.3999 518 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-16 17:53:18' where payTraUID = 5571161746613520 and payStatus='V' and payEnabled=1 16/12/2024 17:53:41.7808 605 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-16 17:53:41','V',5351809563828420,2024,'2024-12-16 17:53:40','456403266300327005012999',2,2,2,'O','',0,'2024-12-16 17:53:41',1,'','0810007103066',82,0) 16/12/2024 18:05:39.8666 1403 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-16 18:05:38','V',5503073440504270,2024,'2024-12-16 18:05:38','456406513800327005012999',1,2,16,'I','',1,0,1,'','',4) 16/12/2024 18:05:41.1395 1266 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/12/2024 18:09:07.6958 1185 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 16/12/2024 18:12:48.1146 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/12/2024 18:12:48.5121 815 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 16/12/2024 18:14:00.3050 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 18:17:23.9195 762 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 16/12/2024 18:18:21.5943 859 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/12/2024 18:25:05.2776 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 18:30:04.8443 1746 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 18:31:38.4166 1099 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-16 18:31:37','V',5014220476519070,2024,'2024-12-16 18:31:36','456405991300327005012999',2,2,2,'O','',0,'2024-12-16 18:31:37',1,'','',0) 16/12/2024 18:31:57.1697 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 18:33:29.5962 962 ms. EXEC: update abbCards set carLastDate = '2024-12-16 18:33:28',carLastDirection='O' where carStatus='V' and carId = 31 16/12/2024 18:33:30.6334 638 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-16 18:33:29' where traUID = 5201690552420050 and traStatus='V' and traEnabled=1 16/12/2024 18:37:18.1344 749 ms. EXEC: update payCurInventory set curType='C' where curType<>'C' and curValue = 10 and curDevCode in (41003,41002,41001,41101,41102,41103); 16/12/2024 18:42:09.0113 771 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-16 18:42:08',0,'V',5055624297911400,5705812231082060,2024,'2024-12-16 18:42:08',2,1,0,-1,'2024-12-16 19:42:08','S','KES',0,0,0,'','','',3,0,0) 16/12/2024 18:42:10.2928 785 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 16/12/2024 18:45:51.5409 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 18:52:34.4205 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 19:02:51.6058 1001 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-16 19:02:50',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'; 16/12/2024 19:03:01.5860 840 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-16 19:03:00' where payTraUID = 5441723424111970 and payStatus='V' and payEnabled=1 16/12/2024 19:08:54.0183 545 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-16 19:08:53',0,16,'2024-12-16 19:08:53','','Unauthorized Transit Entry 2') 16/12/2024 19:24:59.1729 994 ms. EXEC: update payInventory set invCreation = '2024-12-16 19:24:58',invModify = '2024-12-16 19:24:58',invUseId=0,invStatus='V' where invId = 225723 16/12/2024 19:27:15.9501 1150 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 16/12/2024 19:27:19.2648 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 19:27:20.9848 1894 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/12/2024 19:27:21.0348 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 19:31:23.2227 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 19:31:25.5143 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 19:31:39.8404 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 19:35:24.4545 1052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 19:35:26.7331 1517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 19:36:21.8632 728 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-16 19:36:21' where traUID = 5460638368594600 and traStatus='V' and traEnabled=1 16/12/2024 19:36:44.1734 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 20:20:40.2039 646 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-16 20:20:39' where traUID = 5337491897758770 and traStatus='V' and traEnabled=1 16/12/2024 20:24:32.5130 1302 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 20:28:10.9932 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 20:37:56.2791 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 20:48:09.9079 561 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-16 20:48:09',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 16/12/2024 20:52:04.9499 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 20:58:26.4608 514 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 16/12/2024 20:58:45.7422 854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 20:59:57.4312 1531 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-16 19:59:55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-12-16 20:59:55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-12-16 20:59:55' and (resAreId = 1 or resAreId <= 0) nr: 0 16/12/2024 21:04:48.5402 1138 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 21:07:16.4551 565 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 16/12/2024 21:20:59.6267 779 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-16 21:20:58' where payTraUID = 4921641449505850 and payStatus='V' and payEnabled=1 16/12/2024 21:22:41.9740 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 21:23:47.1180 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 21:25:26.3452 758 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/12/2024 21:25:27.6577 666 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-16 21:25:26' where traUID = 5581784113201500 and traStatus='V' and traEnabled=1 16/12/2024 21:29:00.1367 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 21:42:29.8851 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 21:46:49.8786 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 21:46:49.9197 1074 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-16 21:46:48' where payTraUID = 5233760710627330 and payStatus='V' and payEnabled=1 16/12/2024 21:47:31.9460 717 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-16 21:47:30',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'; 16/12/2024 21:49:48.3708 737 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53773, trcLastPrinted = '2400753773', trcLastDate = '2024-12-16 21:49:47' where trcStatus='V' and trcTerId = 18 16/12/2024 21:49:53.4195 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 22:13:19.4139 815 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-16 22:13:18',17,9,'2024-12-16 22:13:18','456406958100327005012999','Pagato (Contanti ) Biglietto ') 16/12/2024 22:14:22.0976 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 22:14:39.9147 1184 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 22:15:18.4731 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 22:15:21.1521 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 22:15:35.9158 915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 22:16:31.8208 525 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-16 21:16:31') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-12-16 22:16:31' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-12-16 22:16:31' and (resAreId = 1 or resAreId <= 0) nr: 0 16/12/2024 22:17:03.3012 509 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 16/12/2024 22:17:03.9770 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 22:17:04.0020 567 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 16/12/2024 22:18:36.9888 1095 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 22:19:55.8998 1589 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 383623 else acvFstPayId end),acvLstPayId = 383623 where acvSftId = 854 and acvCodeId = 3 16/12/2024 22:21:01.3946 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 22:21:48.2924 572 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 22:21:47',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-16 22:21:47',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 16/12/2024 22:33:48.7498 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 22:37:59.3093 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 16/12/2024 22:55:53.6627 529 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-12-16 22:55:53','V',4997118791998740,2024,'2024-12-16 22:55:51','456408255100327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 16/12/2024 23:31:12.5463 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1