04/12/2024 01:10:45.6285 530 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-04 01:10:45' where payTraUID = 5162326596123510 and payStatus='V' and payEnabled=1 04/12/2024 01:43:20.7330 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/12/2024 02:46:09.8813 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/12/2024 04:33:39.8263 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/12/2024 06:02:32.9611 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/12/2024 08:11:28.0012 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/12/2024 09:45:29.9284 1041 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/12/2024 10:30:20.7560 814 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/12/2024 10:44:14.5759 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/12/2024 10:44:55.2842 812 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/12/2024 10:44:59.1678 1101 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/12/2024 10:56:30.9758 525 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/12/2024 12:06:58.6533 527 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/12/2024 12:48:03.0055 786 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/12/2024 12:48:04.1822 815 ms. EXEC: update abbCards set carLastDate = '2024-12-04 12:48:03',carLastDirection='I' where carStatus='V' and carId = 106 04/12/2024 13:18:48.5606 558 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-04 13:18:47' where traUID = 4756882930405200 and traStatus='V' and traEnabled=1 04/12/2024 13:27:45.1297 617 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-04 13:27:44' where traUID = 5146423377023750 and traStatus='V' and traEnabled=1 04/12/2024 13:46:57.6229 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/12/2024 13:57:05.6355 651 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/12/2024 14:12:56.6332 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/12/2024 14:33:50.4095 636 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-04 14:33:49','V',5430648536542770,2024,'2024-12-04 14:33:49','456285242900327005012999',1,2,16,'I','',1,0,1,'','',4) 04/12/2024 15:47:35.6533 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/12/2024 15:48:12.1497 921 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-04 15:48:11',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 04/12/2024 16:06:34.6924 840 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-04 16:06:33' where traUID = 5520145161624340 and traStatus='V' and traEnabled=1 04/12/2024 16:06:37.2601 551 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/12/2024 16:20:51.8684 501 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-04 16:20:51' where payTraUID = 5167287969278670 and payStatus='V' and payEnabled=1 04/12/2024 16:48:16.9412 673 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/12/2024 17:03:57.5414 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/12/2024 17:31:36.6544 551 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-04 17:31:36','V',5676526535441490,2024,'2024-12-04 17:31:35','456286309500327005012999',1,2,16,'I','',1,0,1,'','',4) 04/12/2024 17:46:33.7862 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/12/2024 18:34:03.8378 522 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5661903339550820,5261227799656680,2024,'2024-12-04 18:34:03',' Date: 12/4/2024 6:30:58 PM Code: 456285437600327005012999 Entry Date: 12/4/2024 3:06:16 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 200.00 KES ______________________________ Paid: 200.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400417175 ',0) 04/12/2024 18:34:48.3576 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/12/2024 19:08:55.0211 552 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/12/2024 21:58:08.1688 516 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5391612498051810,5337420950878700,2024,'2024-12-04 21:58:07',' Date: 12/4/2024 9:58:07 PM Code: 456287444100327005012999 Entry Date: 12/4/2024 8:40:41 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 # 2400752233 ',0) 04/12/2024 22:49:25.7802 709 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-04 22:49:24' where traUID = 4691983910234160 and traStatus='V' and traEnabled=1