31/07/2023 08:15:10.0975 566 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-31 08:15:05',5,3,42101,0,50,-49,-2450,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-31 08:15:05',5,3,42101,0,100,-27,-2700,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-31 08:15:05',5,3,42101,0,200,-8,-1600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-31 08:15:05',5,3,42101,0,500,-5,-2500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-31 08:15:05',5,3,42101,0,1000,-4,-4000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-31 08:15:05',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 31/07/2023 10:48:30.2451 1834 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2023-07-31 10:48:28',4,6,'2023-07-31 10:48:28','451363800800327005012999','Payed (Credit Card ) Ticket ') 31/07/2023 10:48:30.9456 580 ms. EXEC: update tabTerminalReceipt set trcProgressive = 14258, trcLastPrinted = '2300414258', trcLastDate = '2023-07-31 10:48:30' where trcStatus='V' and trcTerId = 4 31/07/2023 10:48:31.6121 664 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5708957610850300,5621826865941280,2023,'2023-07-31 10:48:30',' Date: 7/31/2023 10:47:50 PM Code: 451363800800327005012999 Entry Date: 7/31/2023 10:33:28 AM 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 # 2300414258 ',0) 31/07/2023 10:48:32.9620 648 ms. EXEC: update payReceipt set recCreation = '2023-07-31 10:48:32',recModify = '2023-07-31 10:48:32',recUseId=0,recStatus='V' where recId = 146626 31/07/2023 12:12:54.0571 563 ms. EXEC: update abbCards set carLastDate = '2023-07-31 12:12:53',carLastDirection='O' where carStatus='V' and carId = 88 31/07/2023 14:24:09.5012 578 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-31 14:24:08',0,0,'V',5016038590080800,5756210180986860,2023,'2023-07-31 14:24:08',3,'KES',-1,50,-50,'N',''); 31/07/2023 16:18:31.0597 535 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/07/2023 16:37:52.8923 504 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 31/07/2023 17:27:13.4251 501 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2023-07-31 17:27:12',0,2,'2023-07-31 17:27:12','','Unauthorized Transit Exit 1') 31/07/2023 17:38:50.2305 605 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2023-07-31 17:38:49',1,2,'2023-07-31 17:38:49','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 31/07/2023 19:23:47.3496 566 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-31 19:23:46',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/07/2023 21:57:43.4924 591 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-07-31 21:57:42' where traUID = 5131351803312790 and traStatus='V' and traEnabled=1