01/12/2024 00:05:29.7577 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 01:06:14.5229 642 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-01 01:06:13' where payTraUID = 5367827945691660 and payStatus='V' and payEnabled=1 01/12/2024 01:07:42.0562 1223 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-01 01:07:40',0,'V',4785663015536970,5059486182336630,2024,'2024-12-01 01:07:40',18,1,0,4,'2024-12-01 01:22:40','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 01/12/2024 02:08:44.7652 533 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/12/2024 02:23:45.0878 668 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 01/12/2024 03:37:48.8726 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 04:13:41.2128 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 04:48:52.6043 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 05:29:21.8322 2253 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 05:32:45.2525 755 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-01 05:32:44' where payTraUID = 5439305148439950 and payStatus='V' and payEnabled=1 01/12/2024 06:29:11.9112 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 06:58:32.0383 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 08:14:23.8082 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 08:16:47.8237 590 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-01 08:16:47',0,'V',5521543818300390,5034076280157990,2024,'2024-12-01 08:16:47',18,1,0,4,'2024-12-01 08:31:47','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/12/2024 08:20:20.1840 1021 ms. EXEC: update paycash set casCreation = '2024-12-01 08:20:19',casModify = '2024-12-01 08:20:19',casUseId=0,casStatus='V' where casId = 197802 01/12/2024 08:20:21.4218 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 08:26:35.0291 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 08:45:47.6133 771 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-01 08:45:46','V',4990235081379530,2024,'2024-12-01 08:45:46','456252979300327001012999',2,2,2,'O','',0,'2024-12-01 08:45:46',1,'','',0) 01/12/2024 09:11:04.9084 1708 ms. EXEC: update abbCards set carLastDate = '2024-12-01 09:11:03',carLastDirection='I' where carStatus='V' and carId = 10 01/12/2024 09:42:12.2440 786 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-01 09:42:11',5,3,0,3,0,0,0,0,'3','') 01/12/2024 09:42:23.6817 556 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-01 09:42:23','V',5002504027348830,2024,'2024-12-01 09:42:21','456250000200327003229999',22,22,3,'I','',1,0,1,'','',2) 01/12/2024 09:42:24.7244 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 10:11:30.8450 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 10:12:48.7783 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 10:13:37.4341 878 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-01 10:13:36',0,0,'V',5544878591472770,5553952023537240,2024,'2024-12-01 10:13:36',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-01 10:13:36',0,0,'V',5544878591472770,5553952023537240,2024,'2024-12-01 10:13:36',3,'KES',-1,100,-100,'N',''); 01/12/2024 10:24:43.6200 624 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/12/2024 10:24:54.6574 1240 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 10:42:42.2512 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 10:42:49.2409 733 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-01 10:42:48','V',5161014362853420,2024,'2024-12-01 10:42:48','456253563600327005012999',2,2,2,'O','',0,'2024-12-01 10:42:48',1,'','',0) 01/12/2024 10:43:59.0761 2088 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 01/12/2024 10:45:42.8558 521 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-01 10:42:40',6,'V',5455321817158290,5103046770538010,2024,'2024-12-01 10:42:40',4,1,0,4,'2024-12-01 10:57:40','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 01/12/2024 10:56:20.7772 728 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-01 10:56:19' where traUID = 4954777531219860 and traStatus='V' and traEnabled=1 01/12/2024 11:12:56.3197 1151 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 11:17:24.5151 780 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 11:26:37.0092 1282 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 11:30:15.8819 516 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/12/2024 11:30:41.6271 620 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-01 11:30:39',0,'V',5421063369983090,4615800148280980,2024,'2024-12-01 11:30:39',3,1,0,4,'2024-12-01 11:45:39','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 01/12/2024 11:30:43.0831 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 11:51:43.4867 621 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-01 11:51:42','V',4778506401512330,2024,'2024-12-01 11:51:42','456254270200327005012999',1,2,16,'I','',1,0,1,'','',4) 01/12/2024 11:58:06.9876 580 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-01 11:58:06',0,'V',5247985155520370,5025310896792150,2024,'2024-12-01 11:58:06',18,1,0,4,'2024-12-01 12:13:06','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/12/2024 12:11:29.5696 763 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 12:11:30.7504 661 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 377439 else acvFstPayId end),acvLstPayId = 377439 where acvSftId = 836 and acvCodeId = 3 01/12/2024 12:24:09.8786 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 12:26:51.7851 543 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-01 12:23:47',6,'V',4726862374509650,4994506375342200,2024,'2024-12-01 12:23:47',4,1,0,4,'2024-12-01 12:38:47','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/12/2024 12:26:53.8274 505 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-01 12:26:52',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'; 01/12/2024 12:29:32.7619 555 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/12/2024 12:29:35.1175 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 12:29:54.4404 1215 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/12/2024 12:30:48.0864 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 12:51:16.0687 880 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/12/2024 13:13:58.2956 929 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4804897907069680,5079139260851750,2024,'2024-12-01 13:13:57',' Date: 12/1/2024 1:10:55 PM Code: 456254482500327005012999 Entry Date: 12/1/2024 12:27:05 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400416980 ',0) 01/12/2024 13:25:39.3846 594 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-01 13:23:12',1,'V',5558448334322630,4669220693834010,2024,'2024-12-01 13:23:12',17,1,0,4,'2024-12-01 13:38:12','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 01/12/2024 13:25:47.9524 869 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-01 13:25:46',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'; 01/12/2024 13:26:36.6410 952 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-01 13:26:35' where traUID = 5566508243407590 and traStatus='V' and traEnabled=1 01/12/2024 13:26:42.4319 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 13:42:58.3422 621 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-01 13:42:57' where payTraUID = 4673274350921930 and payStatus='V' and payEnabled=1 01/12/2024 13:43:13.2482 533 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-01 13:43:11',0,'V',5666596252486670,5523933280810000,2024,'2024-12-01 13:43:11',3,1,0,4,'2024-12-01 13:58:11','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 01/12/2024 13:51:15.9791 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 13:51:50.5617 676 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-01 13:51:49' where traUID = 4989892836693680 and traStatus='V' and traEnabled=1 01/12/2024 14:12:38.7847 689 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5125353323993500,5090813526550330,2024,'2024-12-01 14:12:38',' Date: 12/1/2024 2:12:37 PM Code: 456254824200327005012999 Entry Date: 12/1/2024 1:24:02 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400751721 ',0) 01/12/2024 14:14:39.4736 1021 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-01 14:14:38','V',5280825324694660,2024,'2024-12-01 14:14:37','456254824200327005012999',2,2,2,'O','',0,'2024-12-01 14:14:38',1,'','',0) 01/12/2024 14:27:06.9711 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 14:27:47.6114 518 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 01/12/2024 14:33:45.5390 549 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4879957205922400,5443015213840490,2024,'2024-12-01 14:33:44',' Date: 12/1/2024 2:33:44 PM Code: 456255062100327005012999 Entry Date: 12/1/2024 2:03:41 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400751726 ',0) 01/12/2024 14:41:02.7799 535 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/12/2024 15:08:19.0774 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 15:12:58.8520 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 15:26:43.0858 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 15:28:12.3646 532 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-01 15:28:11',0,0,'V',5300191514974840,5500741965124360,2024,'2024-12-01 15:28:11',3,'KES',-1,50,-50,'N',''); 01/12/2024 15:40:45.0559 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 15:40:51.8815 727 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-01 15:40:51','V',4710190388538780,2024,'2024-12-01 15:40:50','456255373000327005012999',2,2,2,'O','',0,'2024-12-01 15:40:51',1,'','',0) 01/12/2024 15:44:43.2245 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 15:51:07.9740 595 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-01 15:51:07','V',5254081590294580,2024,'2024-12-01 15:51:05','456254749200327005012999',2,2,2,'O','',0,'2024-12-01 15:51:07',1,'','',0) 01/12/2024 16:12:22.8511 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 16:13:44.5358 764 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/12/2024 16:14:06.3854 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 16:14:27.6287 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 16:21:01.8815 514 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 01/12/2024 17:03:25.4940 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 17:12:42.4576 688 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 17:24:57.2569 1079 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-01 17:24:56',3,42101,0,100,-3,-300,1,'O','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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-01 17:24:56',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-01 17:24:56',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 01/12/2024 17:27:17.2757 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 18:14:57.5939 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 18:19:02.6396 777 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 18:30:26.9643 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 18:51:10.2271 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 18:52:17.1576 548 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-01 18:52:16',0,'V',5485869277389640,5469757930814230,2024,'2024-12-01 18:52:16',18,1,0,4,'2024-12-01 19:07:16','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 01/12/2024 18:58:26.6366 719 ms. EXEC: update payReceipt set recCreation = '2024-12-01 18:58:25',recModify = '2024-12-01 18:58:25',recUseId=0,recStatus='V' where recId = 328014 01/12/2024 19:13:46.8772 1098 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/12/2024 19:14:02.7489 893 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 19:14:02.8339 633 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-01 19:14:02' where payTraUID = 4889283818020080 and payStatus='V' and payEnabled=1 01/12/2024 19:14:17.9070 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 20:14:27.2689 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 20:15:19.9805 675 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 20:15:20.5419 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 20:26:28.4909 1337 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 01/12/2024 20:26:36.9246 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 20:26:42.9486 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 21:01:26.1746 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/12/2024 21:13:50.3030 877 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/12/2024 22:08:35.0351 711 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 44 order by traDateTime desc,traId desc 01/12/2024 22:21:23.8604 618 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 01/12/2024 23:14:27.7607 1102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/12/2024 23:47:18.7814 647 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1