27/08/2024 04:29:24.5541 574 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-27 04:29:23' where traUID = 4947881137850370 and traStatus='V' and traEnabled=1 27/08/2024 07:45:53.7340 557 ms. EXEC: update payInventory set invCreation = '2024-08-27 07:45:53',invModify = '2024-08-27 07:45:53',invUseId=0,invStatus='V' where invId = 203694 27/08/2024 08:49:50.9473 524 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-27 08:49:50' where traUID = 5526424723680890 and traStatus='V' and traEnabled=1 27/08/2024 09:46:41.0501 531 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-08-27 09:46:40','V',5541243070048520,2024,'2024-08-27 09:46:40','455293297900327005012999',2,2,2,'O','',0,'2024-08-27 09:46:40',1,'','',0) 27/08/2024 12:03:44.8277 738 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-08-27 12:03:44','V',5339711086190680,2024,'2024-08-27 12:03:43','455294342300327005012999',1,2,16,'I','',1,0,1,'','',4) 27/08/2024 12:19:48.7098 523 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4977855234010320,4829175991357720,2024,'2024-08-27 12:19:48',' Date: 8/27/2024 12:19:47 PM Code: 455293519400327005012999 Entry Date: 8/27/2024 9:46:34 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400738010 ',0) 27/08/2024 13:15:00.1129 618 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-27 13:14:59' where payTraUID = 5114748446343450 and payStatus='V' and payEnabled=1 27/08/2024 13:25:50.9302 566 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-27 13:25:50' where traUID = 5562712035224530 and traStatus='V' and traEnabled=1 27/08/2024 14:14:07.3558 617 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-27 14:14:06',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'; 27/08/2024 14:35:35.1736 607 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-27 14:35:34',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'; 27/08/2024 17:12:20.9011 593 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 27/08/2024 17:26:17.9684 561 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-27 17:26:17',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'; 27/08/2024 17:37:09.1483 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-08-27 17:37:08','V',5226548149227500,2024,'2024-08-27 17:37:08','455296157400327001012999',2,2,2,'O','',0,'2024-08-27 17:37:08',1,'','',0) 27/08/2024 18:39:07.5780 543 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-27 18:39:07',0,0,'V',5369333145481630,4867937286350680,2024,'2024-08-27 18:39:07',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-08-27 18:39:07',0,0,'V',5369333145481630,4867937286350680,2024,'2024-08-27 18:39:07',3,'KES',-1,100,-100,'N',''); 27/08/2024 20:50:59.7687 639 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1