21/12/2022 08:15:44.9766 546 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-12-21 08:15:41',4,3,42101,0,50,-47,-2350,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-12-21 08:15:41',4,3,42101,0,100,-95,-9500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-12-21 08:15:41',4,3,42101,0,200,-15,-3000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-12-21 08:15:41',4,3,42101,0,500,-6,-3000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-12-21 08:15:41',4,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-12-21 08:15:41',4,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 21/12/2022 13:02:25.6351 705 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2022-12-21 13:02:24',0,0,'V',4765019663867360,4721945783067390,2022,'2022-12-21 13:02:24',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 ('2022-12-21 13:02:24',0,0,'V',4765019663867360,4721945783067390,2022,'2022-12-21 13:02:24',3,'KES',-1,100,-100,'N',''); 21/12/2022 15:48:57.4786 571 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/12/2022 18:09:40.6004 549 ms. EXEC: update payReceipt set recCreation = '2022-12-21 18:09:40',recModify = '2022-12-21 18:09:40',recUseId=0,recStatus='V' where recId = 46409 21/12/2022 18:14:35.4128 1104 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2022-12-21 18:14:34',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 ('2022-12-21 18:14:34',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'; 21/12/2022 18:43:46.1250 736 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,'2022-12-21 18:43:45','V',4663186152781700,2022,'2022-12-21 18:43:45','449146516700327005012999',2,2,2,'O','',0,'2022-12-21 18:43:45',1,'','',0) 21/12/2022 18:58:13.1379 613 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 21/12/2022 19:12:16.0788 557 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5751510190425590,5580848527141480,2022,'2022-12-21 19:12:15',' Date: 12/21/2022 7:09:29 PM Code: 449146034600327005012999 Entry Date: 12/21/2022 4:45:46 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2200404967 ',0) 21/12/2022 19:47:56.8410 564 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1