29/11/2024 00:35:37.2008 30341 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 29/11/2024 00:35:37.9593 509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9593 506 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9613 509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9623 514 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9623 505 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9633 508 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9653 508 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9653 512 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9663 515 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9673 509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9693 520 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9713 512 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9713 523 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9723 522 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9733 516 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9743 519 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:37.9743 518 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/11/2024 00:35:56.5982 17744 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 29/11/2024 00:35:57.1246 526 ms. EXEC: update payCurInventory set curType='C' where curType<>'C' and curValue = 5 and curDevCode in (41003,41002,41001,41101,41102,41103); 29/11/2024 00:36:02.7644 5636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/11/2024 00:36:07.2844 4520 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 29/11/2024 00:38:38.8662 1241 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '788146' and traDirection='I' order by traId DESC LIMIT 1 29/11/2024 00:38:40.0440 638 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456228480600327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 29/11/2024 07:06:38.8310 2519 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 29/11/2024 07:38:26.5610 785 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-11-29 07:38:25','V',4635962883393230,2024,'2024-11-29 07:38:24','456232750400327005012999',1,2,16,'I','',1,0,1,'','',4) 29/11/2024 07:48:39.7819 2093 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 29 order by traDateTime desc,traId desc 29/11/2024 07:49:36.9952 2308 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 18 order by traDateTime desc,traId desc 29/11/2024 07:55:45.8111 2391 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc 29/11/2024 08:02:59.3832 705 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 29/11/2024 08:03:19.2668 6224 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 29/11/2024 08:03:20.3756 524 ms. OPEN: show columns from abbPayment where Field = 'payCarId' 29/11/2024 08:11:42.2261 512 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 29/11/2024 08:31:29.6248 1942 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:27:39',5,3,42101,0,50,-24,-1200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:27:39',5,3,42101,0,50,24,1200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:27:39',5,3,42101,0,100,-44,-4400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:27:39',5,3,42101,0,100,44,4400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:27:39',5,3,42101,0,200,-9,-1800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:27:39',5,3,42101,0,200,9,1800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:27:39',5,3,42101,0,500,-4,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:27:39',5,3,42101,0,500,4,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:27:39',5,3,42101,0,1000,-2,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:27:39',5,3,42101,0,1000,2,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:27:39',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 29/11/2024 08:31:30.6084 608 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:31:25',5,3,42101,0,50,-27,-1350,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:31:25',5,3,42101,0,100,-44,-4400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:31:25',5,3,42101,0,200,-9,-1800,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:31:25',5,3,42101,0,500,-4,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:31:25',5,3,42101,0,1000,-2,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-29 08:31:25',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 29/11/2024 08:34:13.6976 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/11/2024 08:37:49.5332 597 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-11-29 08:37:48','V',4957093880121030,2024,'2024-11-29 08:37:48','456233106800327001012999',1,2,1,'I','',1,0,1,'','',4) 29/11/2024 08:48:55.7392 18486 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 29/11/2024 09:29:39.6928 965 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/11/2024 09:31:50.5274 1537 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 29/11/2024 09:32:11.4334 619 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 29/11/2024 09:33:00.3201 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/11/2024 09:35:05.8261 539 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-11-29 09:35:05','V',4854788006480130,2024,'2024-11-29 09:35:05','456233307600327005012999',2,2,2,'O','',0,'2024-11-29 09:35:05',1,'','',0) 29/11/2024 09:47:43.4393 687 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 29/11/2024 10:20:42.6678 1128 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/11/2024 10:20:43.9987 1284 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-29 10:20:42' where payTraUID = 5390342529709480 and payStatus='V' and payEnabled=1 29/11/2024 10:31:04.6492 515 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 29/11/2024 10:42:48.2489 2488 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 = 12 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 29/11/2024 11:17:49.2338 1041 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-11-29 11:17:47',0,'V',5732813986477400,4798266806017120,2024,'2024-11-29 11:17:47',3,1,0,4,'2024-11-29 11:32:47','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 29/11/2024 11:18:12.1451 592 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-11-29 11:18:11','V',5571284256894580,2024,'2024-11-29 11:18:10','456234069000327005012999',1,2,16,'I','',1,0,1,'','0230003939927',164,0) 29/11/2024 11:21:21.6238 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/11/2024 11:34:04.5771 1104 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-29 11:34:03',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-11-29 11:34:03',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 29/11/2024 11:34:31.4821 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/11/2024 11:36:11.4844 587 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-29 11:36:10' where traUID = 5544655739265250 and traStatus='V' and traEnabled=1 29/11/2024 12:20:44.7623 570 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/11/2024 12:51:28.0903 717 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-11-29 12:51:27','V',4934608896033650,2024,'2024-11-29 12:51:34','456234431600327005012999',2,2,2,'O','',0,'2024-11-29 12:51:27',1,'','',0) 29/11/2024 12:59:18.0109 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-11-29 12:59:17',0,'V',5689974079004650,4992687332425590,2024,'2024-11-29 12:59:17',18,1,0,4,'2024-11-29 13:14:17','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 29/11/2024 13:22:05.6280 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/11/2024 13:23:45.2903 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/11/2024 13:33:38.4319 657 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/11/2024 14:03:43.9452 521 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 29/11/2024 14:32:44.1800 597 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/11/2024 14:37:44.1328 651 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5105332935134380,5421204935023950,2024,'2024-11-29 14:37:43',' Data: 11/29/2024 2:35:21 PM Codice: 456234849100327005012999 Ingresso: 11/29/2024 1:28:11 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400607581 ',0) (WAIT TIME 28 ms.) 29/11/2024 14:38:14.2490 963 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/11/2024 15:34:16.4623 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/11/2024 15:43:37.1768 649 ms. EXEC: update payInventory set invCreation = '2024-11-29 15:43:36',invModify = '2024-11-29 15:43:36',invUseId=0,invStatus='V' where invId = 222200 29/11/2024 16:16:51.7249 948 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-29 16:16:50' where payTraUID = 5524662883348080 and payStatus='V' and payEnabled=1 29/11/2024 16:16:54.3076 847 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/11/2024 16:21:56.4462 516 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/11/2024 16:21:57.2297 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/11/2024 16:21:57.3048 676 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-29 16:21:56' where traUID = 5614856005730660 and traStatus='V' and traEnabled=1 29/11/2024 16:34:56.7411 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/11/2024 16:52:17.7836 524 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/11/2024 17:21:34.4420 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/11/2024 17:34:15.0518 975 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/11/2024 17:34:21.8243 526 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 29/11/2024 18:27:57.4228 624 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-29 18:27:56',0,0,'V',5169541347921190,5248400259847880,2024,'2024-11-29 18:27:56',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-11-29 18:27:56',0,0,'V',5169541347921190,5248400259847880,2024,'2024-11-29 18:27:56',3,'KES',-1,100,-100,'N',''); 29/11/2024 19:39:20.8097 621 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-29 19:39:20',0,0,'V',5433096657895130,5376940704304320,2024,'2024-11-29 19:39:20',3,'KES',1,200,200,'N',''); 29/11/2024 20:18:43.8654 2084 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 = 10 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 29/11/2024 20:37:47.8590 593 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-29 20:37:47' where traUID = 5681690390624930 and traStatus='V' and traEnabled=1 29/11/2024 20:47:13.6630 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/11/2024 21:16:41.1093 580 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-29 21:16:40' where traUID = 4995101524117500 and traStatus='V' and traEnabled=1 29/11/2024 22:23:21.8823 578 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-29 22:23:21' where traUID = 5272191852845280 and traStatus='V' and traEnabled=1 29/11/2024 22:56:41.6422 565 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-11-29 22:56:41',0,'V',5304108123203230,5177902420480310,2024,'2024-11-29 22:56:41',2,1,0,-1,'2024-11-29 23:56:41','S','KES',0,0,0,'','','',3,0,0) 29/11/2024 23:56:46.6387 628 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-29 23:56:46',0,16,'2024-11-29 23:56:46','','Unauthorized Transit Entry 2')