31/12/2024 00:00:46.6863 768 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/12/2024 00:02:12.6808 765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 00:02:50.0745 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 00:10:00.5725 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 00:15:59.0141 1027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 00:40:51.3169 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 00:44:39.2806 1625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 00:58:04.7931 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 01:42:40.5028 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 01:47:14.9326 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 01:47:57.1188 993 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 01:51:55.3115 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 02:12:29.7322 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 02:14:22.5376 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 02:17:36.6176 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 02:26:31.3415 789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 02:33:46.7225 963 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 31/12/2024 02:47:31.2396 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 03:11:46.3713 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 03:11:52.0411 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 03:20:34.3409 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 03:20:46.1098 1557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 03:23:00.8238 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 03:23:42.1615 1502 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 31/12/2024 03:28:33.0800 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 03:37:42.4923 1177 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 03:42:08.8143 664 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 03:42:08' where payTraUID = 5309642901445900 and payStatus='V' and payEnabled=1 31/12/2024 03:50:47.3933 1301 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 03:51:25.0735 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 04:06:28.9257 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 04:09:29.1852 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 04:18:04.0173 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 04:20:19.0256 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 04:20:20.3174 661 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 31/12/2024 04:30:46.9509 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 04:59:52.6567 1091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 05:12:39.3214 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 05:18:51.0606 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 05:24:19.4198 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 05:37:05.7891 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 05:37:22.4462 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 05:37:22.4492 533 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 31/12/2024 05:55:07.4089 991 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 05:58:21.4900 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 05:58:56.0826 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 06:02:46.6139 1397 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/12/2024 06:11:35.4265 512 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-31 06:11:34','V',5185889337464420,2024,'2024-12-31 06:11:34','456552229400327005012999',1,2,16,'I','',1,0,1,'','',4) 31/12/2024 06:18:59.5810 801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 06:42:43.7886 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 06:42:54.2588 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 06:42:54.7982 522 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 31/12/2024 06:42:55.3926 594 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/12/2024 06:43:28.3926 832 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 31/12/2024 06:44:02.0261 952 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 06:44:22.9541 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 06:45:52.0996 923 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 06:46:20.4036 1021 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/12/2024 07:00:36.8330 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 07:14:45.6690 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 07:34:20.7811 1497 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 07:35:24.5957 558 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-31 07:35:24',0,16,'2024-12-31 07:35:24','','Unauthorized Transit Entry 2') 31/12/2024 07:38:07.6597 1008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 07:42:37.2539 512 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 07:42:41.3147 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 07:53:40.8633 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 08:12:54.3094 520 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-31 08:12:53',0,16,'2024-12-31 08:12:53','','Unauthorized Transit Entry 2') 31/12/2024 08:16:09.8718 773 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-31 08:16:05',5,3,42101,0,50,14,700,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+14,5),curAmount=round(curAmount+700,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-31 08:16:05',5,3,42101,0,100,3,300,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+3,5),curAmount=round(curAmount+300,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; 31/12/2024 08:28:05.1638 1398 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 08:29:17.3410 879 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 08:29:16',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'; 31/12/2024 08:31:41.0421 1205 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 31/12/2024 08:32:48.3971 937 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 08:32:50.6526 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-31 08:32:50','V',5683078870761960,2024,'2024-12-31 08:32:49','456552999300327005012999',2,2,2,'O','',0,'2024-12-31 08:32:50',1,'','',0) 31/12/2024 08:33:33.5203 539 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 08:33:32',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'; 31/12/2024 08:38:19.9696 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 08:44:59.3781 914 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-31 08:44:58',0,0,'V',4761887613608430,5130684518918230,2024,'2024-12-31 08:44:58',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-31 08:44:58',0,0,'V',4761887613608430,5130684518918230,2024,'2024-12-31 08:44:58',3,'KES',-1,100,-100,'N',''); 31/12/2024 08:51:42.2261 1274 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 09:03:25.1683 627 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-31 09:03:23',0,'V',4905475954463020,5582979263438740,2024,'2024-12-31 09:03:23',3,1,0,4,'2024-12-31 09:18:23','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 31/12/2024 09:04:58.4279 1790 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 09:08:15.3347 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:08:30.2171 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:11:47.0805 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:14:05.1034 848 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 09:14:04' where payTraUID = 5355467864753820 and payStatus='V' and payEnabled=1 31/12/2024 09:14:05.8629 758 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 09:14:04' where traUID = 5355467864753820 and traStatus='V' and traEnabled=1 31/12/2024 09:18:53.1702 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:20:19.0987 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:26:07.0515 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:26:34.8891 1057 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:27:03.8504 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:27:23.5226 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 09:27:24.4242 1118 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:27:50.0313 1452 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 09:27:48',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 09:27:48',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 31/12/2024 09:29:58.3514 2761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:32:29.1845 723 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 09:37:22.2368 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:37:31.4510 1173 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:48:14.7759 780 ms. EXEC: update paycash set casCreation = '2024-12-31 09:48:13',casModify = '2024-12-31 09:48:13',casUseId=0,casStatus='V' where casId = 202614 31/12/2024 09:48:25.2909 960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:49:10.3880 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 09:57:38.8804 798 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-31 09:57:38',1,2,'2024-12-31 09:57:38','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 31/12/2024 10:05:29.7112 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 10:08:13.4927 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 10:17:01.9562 865 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-31 10:17:01','V',5526943853487350,2024,'2024-12-31 10:16:59','456553701900327005012999',1,2,16,'I','',1,0,1,'','0230003944064',14,0) 31/12/2024 10:22:03.6178 1111 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 10:22:02' where payTraUID = 4684471181848050 and payStatus='V' and payEnabled=1 31/12/2024 10:22:04.2162 597 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 10:22:02' where traUID = 4684471181848050 and traStatus='V' and traEnabled=1 31/12/2024 10:23:33.1466 819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 10:23:35.7464 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 10:29:54.2256 935 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/12/2024 10:34:02.0541 632 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 10:36:43.6781 1267 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 10:37:16.3890 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 10:39:20.3258 670 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 10:39:19' where payTraUID = 5707646888427250 and payStatus='V' and payEnabled=1 31/12/2024 10:45:31.6796 561 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/12/2024 10:45:32.4661 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 10:46:48.4159 723 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 10:48:42.7057 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 10:49:28.7365 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 10:51:16.0362 734 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 31/12/2024 10:53:07.6838 2425 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/12/2024 10:53:20.4514 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 10:57:02.1446 584 ms. EXEC: update payInventory set invCreation = '2024-12-31 10:57:01',invModify = '2024-12-31 10:57:01',invUseId=0,invStatus='V' where invId = 228448 31/12/2024 10:57:26.9772 781 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 31/12/2024 10:57:38.7480 784 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 31/12/2024 10:58:38.3939 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 10:59:57.5768 1060 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '456553959500327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount<0 31/12/2024 11:00:01.1882 728 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 31/12/2024 11:02:20.8986 1282 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-31 11:02:19','V',5021838953738040,2024,'2024-12-31 11:02:18','456553942200327005012999',2,2,2,'O','',0,'2024-12-31 11:02:19',1,'','',0) 31/12/2024 11:02:22.2976 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 11:02:28.5718 2186 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 11:04:40.7641 711 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '456553911900327005012999' 31/12/2024 11:05:32.2445 560 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 11:05:43.6231 5110 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 11:05:44.8259 827 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 11:05:50.6578 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 11:06:22.6552 1737 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 11:06:25.7493 2325 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 11:06:25.7553 851 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-31 11:06:24','V',5376928936336430,2024,'2024-12-31 11:06:23','456553998300327005012999',1,2,16,'I','',1,0,1,'','',4) 31/12/2024 11:06:26.4808 564 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 11:06:25' where payTraUID = 5487545100148010 and payStatus='V' and payEnabled=1 31/12/2024 11:06:26.4968 545 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/12/2024 11:06:42.2293 3122 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/12/2024 11:07:00.6566 933 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 11:08:55.1742 1026 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 125 order by traDateTime desc,traId desc 31/12/2024 11:09:43.2111 727 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 11:14:13.6459 33404 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 31/12/2024 11:14:25.4128 642 ms. OPEN: select 1 as Tot,payUID,payPayed,payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 31/12/2024 11:26:45.9289 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 11:27:18.2095 775 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 11:28:24.4928 570 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 11:40:18.4734 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 11:44:28.3815 825 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-31 11:44:27','V',5230918163324540,2024,'2024-12-31 11:44:26','456554226600327001012999',1,2,1,'I','',1,0,1,'','',4) 31/12/2024 11:50:19.4300 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 11:51:44.9261 739 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 11:51:44',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'; 31/12/2024 11:51:46.3431 1410 ms. EXEC: update payInventory set invCreation = '2024-12-31 11:51:44',invModify = '2024-12-31 11:51:44',invUseId=0,invStatus='V' where invId = 228464 31/12/2024 11:51:46.8524 505 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-31 11:51:46',0,0,'V',5606288798147600,5659466297582040,2024,'2024-12-31 11:51:46',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-31 11:51:46',0,0,'V',5606288798147600,5659466297582040,2024,'2024-12-31 11:51:46',3,'KES',-1,100,-100,'N',''); 31/12/2024 11:52:29.3478 1081 ms. EXEC: update payReceipt set recCreation = '2024-12-31 11:52:28',recModify = '2024-12-31 11:52:28',recUseId=0,recStatus='V' where recId = 337684 31/12/2024 11:56:04.5827 888 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 11:56:05.2712 677 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 11:57:09.9694 600 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 31/12/2024 11:57:42.1159 553 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 11:57:46.2266 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 11:58:05.9228 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 11:59:19.5790 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 12:01:37.7369 730 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/12/2024 12:04:47.0093 640 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 12:11:10.2757 612 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 12:13:56.4558 692 ms. EXEC: update paycash set casCreation = '2024-12-31 12:13:55',casModify = '2024-12-31 12:13:55',casUseId=0,casStatus='V' where casId = 202648 31/12/2024 12:16:19.5054 649 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5605442939060700,4619709222215900,2024,'2024-12-31 12:16:18','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/31/2024 10:30:08 AM Date : 12/31/2024 12:16:17 PM Code : 456553780800327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 1000.00 KES Coin changed : 0.00 KES Note changed : 900.00 KES',0) 31/12/2024 12:18:00.3428 1214 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 12:18:11.2571 571 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-31 12:18:10',0,0,'V',5205117981542560,4731600065011520,2024,'2024-12-31 12:18:10',3,'KES',1,100,100,'N',''); 31/12/2024 12:18:41.5513 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 12:25:12.7108 950 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456554411100327005012999' 31/12/2024 12:27:28.5406 1098 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-31 12:27:22',0,'V',5177512247688270,5632427928734790,2024,'2024-12-31 12:27:22',3,1,0,4,'2024-12-31 12:42:22','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 31/12/2024 12:27:43.1163 515 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 12:27:42' where traUID = 4707494861223020 and traStatus='V' and traEnabled=1 31/12/2024 12:27:53.2221 616 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55800, trcLastPrinted = '2400755800', trcLastDate = '2024-12-31 12:27:52' where trcStatus='V' and trcTerId = 18 31/12/2024 12:28:52.6108 1095 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 12:29:19.4287 762 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-31 12:29:18',0,1,'2024-12-31 12:29:18','','Unauthorized Transit Entry 1') 31/12/2024 12:30:58.4298 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 12:33:26.8918 1136 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 12:39:50.2071 695 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-31 12:39:49','V',5137269569558630,2024,'2024-12-31 12:39:48','456554285900327001012999',2,2,2,'O','',0,'2024-12-31 12:39:49',1,'','',0) 31/12/2024 12:39:56.1180 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 12:41:37.6372 958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 12:42:04.2080 938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 12:42:08.9161 1094 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 9 order by traDateTime desc,traId desc 31/12/2024 12:42:14.6019 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 12:44:15.1659 1097 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 12:45:08.7285 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 12:51:50.5062 581 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 13:00:08.2035 843 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 13:00:32.4476 770 ms. EXEC: update payReceipt set recCreation = '2024-12-31 13:00:31',recModify = '2024-12-31 13:00:31',recUseId=0,recStatus='V' where recId = 337713 31/12/2024 13:00:33.6944 1121 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 13:00:32',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'; 31/12/2024 13:01:03.4523 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:01:45.1532 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 13:01:53.0484 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:02:11.7589 1420 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5380512851169340,5697875964830150,2024,'2024-12-31 13:02:10','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/31/2024 12:45:17 PM Date : 12/31/2024 1:02:09 PM Code : 456554591700327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 31/12/2024 13:02:14.2676 1815 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 13:02:12',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'; 31/12/2024 13:02:42.4224 1265 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 13:02:59.0154 1489 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:05:10.8626 537 ms. EXEC: update payReceipt set recCreation = '2024-12-31 13:05:10',recModify = '2024-12-31 13:05:10',recUseId=0,recStatus='V' where recId = 337716 31/12/2024 13:05:12.2045 715 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 13:05:11' where traUID = 5705214763491910 and traStatus='V' and traEnabled=1 31/12/2024 13:05:46.6634 2645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 13:06:00.4806 790 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 13:12:02.6207 704 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 13:12:01' where traUID = 5623237126737500 and traStatus='V' and traEnabled=1 31/12/2024 13:12:11.5987 889 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 13:14:07.0648 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 13:14:08.1886 1093 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/12/2024 13:14:08.9561 854 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5564724035342740,4829573477934470,2024,'2024-12-31 13:14:08',' Date: 12/31/2024 1:14:07 PM Code: 456553392900327005012999 Entry Date: 12/31/2024 9:25:29 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 200.00 KES ______________________________ Paid: 200.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400755811 ',0) 31/12/2024 13:15:30.8609 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:18:40.2995 695 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 13:19:51.3975 974 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-31 13:19:50',0,'V',5553835733330650,5086400213741250,2024,'2024-12-31 13:19:50',2,1,0,-1,'2024-12-31 14:19:50','S','KES',0,0,0,'','','',3,0,0) 31/12/2024 13:20:06.7538 585 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-31 13:20:06','V',5248343959238920,2024,'2024-12-31 13:20:05','456553392900327005012999',2,2,2,'O','',0,'2024-12-31 13:20:06',1,'','',0) 31/12/2024 13:22:06.7941 758 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 13:22:08.0199 1386 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/12/2024 13:29:56.3610 543 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456554630700327005012999' 31/12/2024 13:30:09.7170 618 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/12/2024 13:30:11.8874 815 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-31 13:30:11','0230003944081',0,0,5465826665448820,15,'0000-00-00 00:00:00','0000-00-00 00:00:00') 31/12/2024 13:31:24.2398 1362 ms. EXEC: update tabTerminalReceipt set trcProgressive = 18644, trcLastPrinted = '2400418644', trcLastDate = '2024-12-31 13:31:22' where trcStatus='V' and trcTerId = 4 31/12/2024 13:31:48.1137 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:32:06.4910 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:34:20.9675 644 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 13:38:13.8654 1104 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:40:50.6248 1562 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-31 13:40:49','V',4767403881910230,2024,'2024-12-31 13:40:47','456554777500327005012999',2,2,2,'O','',0,'2024-12-31 13:40:49',1,'','',0) 31/12/2024 13:40:58.0508 769 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 13:41:07.5962 1294 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-31 13:38:06',6,'V',4756387589427170,5683286686097620,2024,'2024-12-31 13:38:06',17,1,0,4,'2024-12-31 13:53:06','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/12/2024 13:41:32.0055 683 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 31/12/2024 13:41:34.2029 996 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:42:54.3655 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:43:21.6197 1445 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:43:38.5981 573 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 31/12/2024 13:43:39.5277 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 13:43:56.0347 1109 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 13:44:08.9444 2184 ms. OPEN: select parVatShowMode from tabParameters where parStatus='V' order by parId desc limit 1 31/12/2024 13:44:09.6799 727 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-31 13:44:05',0,'V',5062024159142750,4682112054968470,2024,'2024-12-31 13:44:05',3,1,0,4,'2024-12-31 13:59:05','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 31/12/2024 13:44:10.6055 865 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4682112054968470,5062024159142750,2024,'2024-12-31 13:44:09','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/31/2024 12:36:01 PM Date : 12/31/2024 1:44:05 PM Code : 456554536100327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 31/12/2024 13:44:12.1385 653 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 13:44:11',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'; 31/12/2024 13:45:02.6593 855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:48:09.9845 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:48:39.3471 1175 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:48:39.3491 1732 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 13:48:37',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'; 31/12/2024 13:50:08.2656 909 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 13:52:17.0926 966 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 13:55:15.9661 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:55:37.9908 2539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 13:55:43.7066 1700 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 13:55:56.2660 1201 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 13:55:55' where payTraUID = 4836124973538050 and payStatus='V' and payEnabled=1 31/12/2024 14:03:36.6671 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 14:03:37.4366 721 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/12/2024 14:03:38.2161 572 ms. EXEC: update paycash set casCreation = '2024-12-31 14:03:37',casModify = '2024-12-31 14:03:37',casUseId=0,casStatus='V' where casId = 202682 31/12/2024 14:03:38.7365 520 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 14:03:37',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'; 31/12/2024 14:04:18.5251 523 ms. EXEC: update paycash set casCreation = '2024-12-31 14:04:18',casModify = '2024-12-31 14:04:18',casUseId=0,casStatus='V' where casId = 202684 31/12/2024 14:05:25.0866 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 14:06:16.8892 528 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 31/12/2024 14:07:27.1402 1129 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/12/2024 14:10:52.4004 562 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-31 14:10:51','0230003944064',0,0,5152246793314100,14,'0000-00-00 00:00:00','0000-00-00 00:00:00') 31/12/2024 14:11:22.1383 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 14:11:27.9311 507 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 31/12/2024 14:11:53.6603 660 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-31 14:11:52','V',5363215203738650,2024,'2024-12-31 14:11:51','456555111100327005012999',1,2,16,'I','',1,0,1,'','',4) 31/12/2024 14:12:44.0170 1946 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 31/12/2024 14:12:44.7245 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 14:15:58.4420 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 14:16:05.0834 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 14:21:49.6117 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 14:22:01.2355 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 14:23:19.4418 1087 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 14:26:28.3671 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 14:27:41.7411 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 14:27:42.5026 732 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/12/2024 14:28:10.1871 749 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5444469238479080,4687999158250290,2024,'2024-12-31 14:28:09','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/31/2024 1:13:43 PM Date : 12/31/2024 2:28:07 PM Code : 456554762300327001012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 31/12/2024 14:28:57.3066 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 14:29:26.1969 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 14:30:17.9425 718 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 1 ms.) 31/12/2024 14:30:42.2698 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 14:31:18.6221 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 14:31:19.9770 1325 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/12/2024 14:32:18.9514 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 14:38:07.8130 696 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 31/12/2024 14:38:52.7610 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 14:45:22.5356 538 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/12/2024 14:45:23.0149 1054 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 1 ms.) 31/12/2024 15:02:19.9040 768 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 15:02:20.1011 519 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/12/2024 15:08:21.3036 5753 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 31/12/2024 15:13:39.2344 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 15:15:24.2256 1123 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 15:17:06.0957 666 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 15:17:05' where traUID = 4969331338477340 and traStatus='V' and traEnabled=1 31/12/2024 15:17:57.1758 716 ms. EXEC: update abbCards set carLastDate = '2024-12-31 15:17:56',carLastDirection='I' where carStatus='V' and carId = 14 31/12/2024 15:22:04.2233 919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 15:25:46.0031 1346 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/12/2024 15:27:39.0903 750 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 15:29:44.6364 772 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 15:32:49.4640 618 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/12/2024 15:36:19.1944 638 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-31 15:36:18','V',5663137398111050,2024,'2024-12-31 15:36:17','456555262800327001012999',2,2,2,'O','',0,'2024-12-31 15:36:18',1,'','',0) 31/12/2024 15:39:55.1357 2802 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 15:39:52' where traUID = 5037344547536060 and traStatus='V' and traEnabled=1 31/12/2024 15:40:25.1078 1513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 15:42:48.4506 617 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-31 15:42:47','V',5351124735997640,2024,'2024-12-31 15:42:46','456555656600327005012999',1,2,16,'I','',1,0,1,'','',4) 31/12/2024 15:47:20.4334 706 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/12/2024 15:47:37.9911 581 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 15:47:37' where traUID = 4948309795785300 and traStatus='V' and traEnabled=1 31/12/2024 15:47:42.5922 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 15:47:47.8567 509 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/12/2024 15:47:59.2193 595 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 15:50:34.6322 613 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 15:50:43.1418 895 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 15:53:34.0461 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 15:53:55.8400 695 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 31/12/2024 15:54:09.5152 680 ms. EXEC: update payReceipt set recCreation = '2024-12-31 15:54:08',recModify = '2024-12-31 15:54:08',recUseId=0,recStatus='V' where recId = 337804 31/12/2024 15:54:12.3471 1264 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/12/2024 16:01:03.3929 2145 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 16:01:01' where payTraUID = 5657466080874040 and payStatus='V' and payEnabled=1 31/12/2024 16:01:04.0193 625 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 16:01:01' where traUID = 5657466080874040 and traStatus='V' and traEnabled=1 31/12/2024 16:07:46.5509 873 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 16:07:45',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 31/12/2024 16:10:11.5525 938 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 16:10:10' where traUID = 5017451636332780 and traStatus='V' and traEnabled=1 31/12/2024 16:10:16.6039 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 16:10:31.4028 1444 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 16:10:36.5122 1834 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 16:10:34' where payTraUID = 5233973449436800 and payStatus='V' and payEnabled=1 31/12/2024 16:10:39.4121 1672 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 31/12/2024 16:10:51.7314 1253 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5600972166012170,4672051854499780,2024,'2024-12-31 16:10:50','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/31/2024 3:58:44 PM Date : 12/31/2024 4:10:49 PM Code : 456555752400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 31/12/2024 16:13:24.4752 1032 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/12/2024 16:14:21.0370 1395 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 16:15:06.0780 2174 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 16:15:21.3903 856 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 16:15:36.5755 697 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 16:19:02.3206 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 1 ms.) 31/12/2024 16:21:17.0437 649 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/12/2024 16:23:44.2414 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 16:25:59.4374 659 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 16:25:58' where traUID = 4902371251289280 and traStatus='V' and traEnabled=1 31/12/2024 16:26:59.6286 587 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 16:30:25.5382 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 16:30:54.6286 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 16:31:10.2991 1433 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 31/12/2024 16:31:46.3562 1764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 16:33:06.9160 2399 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 16:33:51.8663 2014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 16:34:08.4354 876 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 16:34:09.4561 1017 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 16:34:08' where payTraUID = 5622751622422330 and payStatus='V' and payEnabled=1 31/12/2024 16:34:53.4705 1193 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 16:34:56.0532 544 ms. EXEC: update paycash set casCreation = '2024-12-31 16:34:55',casModify = '2024-12-31 16:34:55',casUseId=0,casStatus='V' where casId = 202715 31/12/2024 16:39:29.1276 1060 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 16:41:38.7322 1226 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/12/2024 16:45:22.5181 532 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-31 16:45:21',0,'V',4980036117002430,5557240937118670,2024,'2024-12-31 16:45:21',18,1,0,4,'2024-12-31 17:00:21','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/12/2024 16:48:04.6895 1001 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 16:51:18.4465 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 16:52:25.8244 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:00:21.2514 1292 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 17:00:23.2967 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:03:13.7784 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 17:04:43.5354 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:09:28.6800 1342 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 17:09:30.5242 1003 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:12:44.9001 1005 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:18:21.1253 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:20:18.8071 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 17:22:18.9675 748 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-31 17:22:18',0,'V',5342335277846740,5665253475956880,2024,'2024-12-31 17:22:18',2,1,0,-1,'2024-12-31 18:22:18','S','KES',0,0,0,'','','',3,0,0) 31/12/2024 17:24:50.7040 680 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-31 17:24:50',0,1,'2024-12-31 17:24:50','','Manual Open Barrier Entry 1') 31/12/2024 17:27:27.1125 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:39:16.4847 2477 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:43:39.1453 1679 ms. EXEC: update payInventory set invCreation = '2024-12-31 17:43:37',invModify = '2024-12-31 17:43:37',invUseId=0,invStatus='V' where invId = 228566 31/12/2024 17:43:43.8474 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:45:24.9730 952 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:46:27.2606 2226 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:46:39.8731 3474 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 17:46:36' where payTraUID = 5699661414038380 and payStatus='V' and payEnabled=1 31/12/2024 17:49:18.1038 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:49:18.5591 507 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55887, trcLastPrinted = '2400755887', trcLastDate = '2024-12-31 17:49:18' where trcStatus='V' and trcTerId = 18 31/12/2024 17:50:04.4450 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:50:45.3893 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 17:50:57.9327 1615 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 17:50:56' where traUID = 5509410461527250 and traStatus='V' and traEnabled=1 31/12/2024 17:51:24.5175 1310 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/12/2024 17:52:55.6273 676 ms. EXEC: update abbCards set carLastDate = '2024-12-31 17:52:54',carLastDirection='I' where carStatus='V' and carId = 15 31/12/2024 18:08:14.0941 677 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 18:08:14.8276 715 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 31/12/2024 18:12:15.3794 577 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 18:12:14' where traUID = 4905645604998100 and traStatus='V' and traEnabled=1 31/12/2024 18:13:05.5219 586 ms. EXEC: update payReceipt set recCreation = '2024-12-31 18:13:04',recModify = '2024-12-31 18:13:04',recUseId=0,recStatus='V' where recId = 337876 31/12/2024 18:13:29.2678 888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 18:15:45.5095 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 18:25:37.6380 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 18:31:39.2217 687 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 18:35:44.2918 512 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-31 18:35:43',0,'V',4645068540879490,5521749740366270,2024,'2024-12-31 18:35:43',18,1,0,4,'2024-12-31 18:50:43','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) (WAIT TIME 1 ms.) 31/12/2024 18:36:36.9430 1797 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 18:38:22.7177 624 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-31 18:38:22',0,0,'V',5580509835623790,5714287160082750,2024,'2024-12-31 18:38:22',3,'KES',1,500,500,'N',''); 31/12/2024 18:38:28.9799 581 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-31 18:38:28','V',5061997742956210,2024,'2024-12-31 18:38:26','456556285600327001012999',2,2,2,'O','',0,'2024-12-31 18:38:28',1,'','',0) 31/12/2024 18:38:56.5313 1470 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 18:43:06.0912 2778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 18:43:45.2363 1663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 18:45:46.6996 2716 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/12/2024 18:47:17.9478 1711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 18:47:49.6530 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 18:49:12.7813 675 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-31 18:49:12','V',5074193513416910,2024,'2024-12-31 18:49:10','456556572900327005012999',2,2,2,'O','',0,'2024-12-31 18:49:12',1,'','',0) 31/12/2024 18:49:14.0361 1177 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 18:49:18.6212 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 19:00:26.9761 785 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/12/2024 19:00:57.7557 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:02:31.9416 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:03:40.1272 1314 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:05:33.7322 1449 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 19:06:35.5225 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 19:06:48.8524 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:09:19.5591 754 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 19:09:24.3663 930 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 19:13:45.3594 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:13:49.6602 637 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 19:14:17.9011 1769 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-31 19:14:16','V',5044143485065030,2024,'2024-12-31 19:14:14','456556524600327005012999',2,2,2,'O','',0,'2024-12-31 19:14:16',1,'','',0) 31/12/2024 19:14:51.2334 1005 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:15:05.4849 853 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 31/12/2024 19:17:40.1362 668 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/12/2024 19:23:34.0400 595 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 31/12/2024 19:24:03.2075 811 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 19:24:53.5942 1221 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 19:31:01.0310 1246 ms. EXEC: update paycash set casCreation = '2024-12-31 19:30:59',casModify = '2024-12-31 19:30:59',casUseId=0,casStatus='V' where casId = 202747 31/12/2024 19:38:16.0422 957 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-31 19:38:15',0,'V',5046203370276370,5306109199397660,2024,'2024-12-31 19:38:15',18,1,0,4,'2024-12-31 19:53:15','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 31/12/2024 19:39:16.9895 914 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 19:44:06.1259 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:46:07.5822 527 ms. OPEN: show columns from payPayment where Field = 'payClosePeriod' 31/12/2024 19:48:09.3535 561 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 31/12/2024 19:49:15.3146 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 19:50:00.2896 1060 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 31/12/2024 19:54:27.0894 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:55:33.3387 637 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 19:56:53.1380 1854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:58:00.1281 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:58:26.3836 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 19:59:46.8024 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:59:47.8281 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 19:59:47.8281 856 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/12/2024 19:59:49.7674 895 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 20:05:41.1073 1002 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/12/2024 20:08:07.6327 1252 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 20:08:06' where traUID = 5466199892649270 and traStatus='V' and traEnabled=1 31/12/2024 20:08:29.9797 845 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/12/2024 20:10:45.3271 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 20:11:16.2058 1059 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:19:23.9878 742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:20:17.0493 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:20:20.9359 1222 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:27:17.1385 887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:29:37.5334 1434 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:36:23.7799 1178 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:40:21.0655 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:40:24.7379 1614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:43:19.0795 614 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-31 20:43:18','V',5050500609579090,2024,'2024-12-31 20:43:17','456557459700327005012999',1,2,16,'I','',1,0,1,'','',4) 31/12/2024 20:44:14.4920 1878 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:46:00.2377 1755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:46:45.3918 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:47:05.6614 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 20:50:29.5527 699 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-31 20:50:28','V',5208998129765210,2024,'2024-12-31 20:50:27','456557502700327005012999',1,2,16,'I','',1,0,1,'','',4) 31/12/2024 20:50:30.5443 976 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 20:50:46.6441 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 20:51:55.7213 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 20:56:19.1093 539 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 20:56:18' where payTraUID = 5572537228964540 and payStatus='V' and payEnabled=1 31/12/2024 20:58:54.4682 545 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCarID = 15 31/12/2024 20:59:36.7885 590 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 31/12/2024 21:01:05.8610 547 ms. EXEC: update tabTerminalReceipt set trcProgressive = 8413, trcLastPrinted = '2400608413', trcLastDate = '2024-12-31 21:01:05' where trcStatus='V' and trcTerId = 17 31/12/2024 21:03:01.3592 1140 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 389161 else acvFstPayId end),acvLstPayId = 389161 where acvSftId = 872 and acvCodeId = 3 31/12/2024 21:03:02.2008 709 ms. EXEC: update payReceipt set recCreation = '2024-12-31 21:03:01',recModify = '2024-12-31 21:03:01',recUseId=0,recStatus='V' where recId = 337933 31/12/2024 21:03:57.0865 514 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 21:03:56' where payTraUID = 5068062129097940 and payStatus='V' and payEnabled=1 31/12/2024 21:04:36.9982 1690 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-31 21:04:35','V',5295619343769020,2024,'2024-12-31 21:04:33','456556944200327005012999',2,2,2,'O','',0,'2024-12-31 21:04:35',1,'','',0) 31/12/2024 21:04:41.5042 674 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 21:07:40.3307 961 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 31/12/2024 21:07:55.6509 968 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-31 21:07:54','V',5318888695929270,2024,'2024-12-31 21:07:52','456556929000327005012999',2,2,2,'O','',0,'2024-12-31 21:07:54',1,'','',0) 31/12/2024 21:08:00.8324 710 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/12/2024 21:10:52.6883 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 21:12:12.5407 1630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 21:12:47.3209 769 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-31 21:12:46','V',4703934506486420,2024,'2024-12-31 21:12:44','456557284700327001012999',2,2,2,'O','',0,'2024-12-31 21:12:46',1,'','',0) 31/12/2024 21:15:18.8032 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 21:53:51.3733 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 22:04:49.7577 621 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 31/12/2024 22:06:58.6834 1450 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 22:06:57' where traUID = 5208365293500540 and traStatus='V' and traEnabled=1 31/12/2024 22:07:07.3682 1612 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/12/2024 22:07:09.9810 2309 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-31 22:07:07',0,'V',4942755169867600,5529824928380720,2024,'2024-12-31 22:07:07',18,1,0,4,'2024-12-31 22:22:07','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 31/12/2024 22:07:10.7585 527 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5529824928380720,4942755169867600,2024,'2024-12-31 22:07:10',' Date: 12/31/2024 10:07:07 PM Code: 456557468400327005012999 Entry Date: 12/31/2024 8:44:44 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 # 2400755935 ',0) 31/12/2024 22:07:59.4360 1019 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 22:09:15.0864 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 22:11:41.0395 920 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 22:12:58.4848 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 22:16:25.2944 507 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/12/2024 22:18:21.8885 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 22:18:35.0183 659 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-31 22:18:34',0,'V',5223723561827520,5463432149768920,2024,'2024-12-31 22:18:34',18,1,0,4,'2024-12-31 22:33:34','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 31/12/2024 22:21:07.3425 638 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-31 22:21:06','V',5630308946746230,2024,'2024-12-31 22:21:06','456557774200327001012999',2,2,2,'O','',0,'2024-12-31 22:21:06',1,'','',0) 31/12/2024 22:21:08.3681 627 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 22:21:07' where traUID = 5536987050476020 and traStatus='V' and traEnabled=1 31/12/2024 22:21:40.1664 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 22:22:49.7699 600 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55940, trcLastPrinted = '2400755940', trcLastDate = '2024-12-31 22:22:49' where trcStatus='V' and trcTerId = 18 31/12/2024 22:25:35.7829 581 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 31/12/2024 22:31:13.9889 817 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-31 22:31:13',0,0,'V',5599664401882010,4887769478561880,2024,'2024-12-31 22:31:13',3,'KES',1,50,50,'N',''); 31/12/2024 22:31:14.6373 607 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 22:31:13',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'; 31/12/2024 22:31:15.1687 526 ms. EXEC: update payInventory set invCreation = '2024-12-31 22:31:14',invModify = '2024-12-31 22:31:14',invUseId=0,invStatus='V' where invId = 228605 31/12/2024 22:31:20.5763 795 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 22:31:33.5380 825 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-31 22:31:32',0,'V',4861961003391200,5050500609579090,2024,'2024-12-31 22:31:32',18,1,0,4,'2024-12-31 22:46:32','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 31/12/2024 22:33:40.6394 1718 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 22:37:19.0850 845 ms. EXEC: update tabTerminalReceipt set trcProgressive = 18670, trcLastPrinted = '2400418670', trcLastDate = '2024-12-31 22:37:18' where trcStatus='V' and trcTerId = 4 31/12/2024 22:37:32.2268 2259 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/12/2024 22:39:49.3755 570 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 22:39:48' where traUID = 5439998898037110 and traStatus='V' and traEnabled=1 31/12/2024 22:44:39.6702 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 22:44:43.2877 586 ms. EXEC: update abbCards set carLastDate = '2024-12-31 22:44:42',carLastDirection='I' where carStatus='V' and carId = 194 31/12/2024 22:44:43.9311 623 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/12/2024 22:47:41.4532 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 22:47:49.7668 945 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 22:53:12.9785 820 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/12/2024 22:55:06.0789 850 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-31 21:55:05') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-12-31 22:55:05' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-12-31 22:55:05' and (resAreId = 1 or resAreId <= 0) nr: 0 31/12/2024 22:55:35.5466 872 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-31 22:55:42',9,'V',5558548202840340,4843845850245050,2024,'2024-12-31 22:55:42',4,1,0,4,'2024-12-31 23:10:42','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 31/12/2024 22:55:41.7017 1319 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 22:56:18.9786 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 23:01:18.1678 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 23:05:12.4142 2110 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 23:06:42.3934 1076 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 23:06:41' where traUID = 5550920790795060 and traStatus='V' and traEnabled=1 31/12/2024 23:09:25.4420 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-31 23:09:24','V',5420415365461560,2024,'2024-12-31 23:09:23','456558170000327005012999',2,2,2,'O','',0,'2024-12-31 23:09:24',1,'','',0) 31/12/2024 23:09:26.9821 1514 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 23:09:27.6175 619 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 31/12/2024 23:15:26.0370 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 23:22:39.5305 1246 ms. EXEC: update payReceipt set recCreation = '2024-12-31 23:22:38',recModify = '2024-12-31 23:22:38',recUseId=0,recStatus='V' where recId = 337974 31/12/2024 23:24:55.7415 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 23:30:35.5302 528 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 23:30:34' where traUID = 5361049361324480 and traStatus='V' and traEnabled=1 31/12/2024 23:31:44.4122 688 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-31 23:31:43' where subId = 206 31/12/2024 23:31:45.0466 621 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 23:31:46.1384 610 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 23:31:49.1074 2810 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 23:31:46' where payTraUID = 5423408220220640 and payStatus='V' and payEnabled=1 31/12/2024 23:31:55.1154 666 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 23:31:58.1584 1516 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 31/12/2024 23:31:58.1594 1518 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 31/12/2024 23:33:39.0328 796 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 23:33:44.2693 588 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/12/2024 23:37:08.8401 775 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 23:37:09.8107 936 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 31/12/2024 23:37:21.8698 736 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/12/2024 23:37:22.6143 639 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-31 23:37:21' where payTraUID = 5078315536545900 and payStatus='V' and payEnabled=1 31/12/2024 23:37:28.9455 504 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/12/2024 23:37:28.9505 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 23:37:37.2030 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 23:38:40.3944 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 23:38:46.0842 1240 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 23:39:10.9198 775 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 23:40:20.4403 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 23:42:08.2377 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/12/2024 23:43:39.1465 744 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 31/12/2024 23:52:29.8562 891 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-31 23:52:28',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'; 31/12/2024 23:55:35.5314 1563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/12/2024 23:56:10.8810 1301 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-31 23:56:09' where traUID = 4912892029518010 and traStatus='V' and traEnabled=1 31/12/2024 23:57:02.1282 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1