28/09/2023 07:56:36.4058 625 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-28 07:56:32',5,3,42101,0,50,-20,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-28 07:56:32',5,3,42101,0,100,-100,-10000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-28 07:56:32',5,3,42101,0,200,-17,-3400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-28 07:56:32',5,3,42101,0,500,-13,-6500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-28 07:56:32',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-09-28 07:56:32',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 28/09/2023 08:05:45.8553 578 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-28 08:05:40',5,3,42101,0,50,4,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+4,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-28 08:05:40',5,3,42101,0,200,2,400,1,'I','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'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-28 08:05:40',5,3,42101,0,100,12,1200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+12,5),curAmount=round(curAmount+1200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 28/09/2023 09:33:20.7181 671 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,'2023-09-28 09:33:20','V',4716532464400920,2023,'2023-09-28 09:33:19','451953101600327005012999',2,2,2,'O','',0,'2023-09-28 09:33:20',1,'','',0) 28/09/2023 09:42:07.0265 515 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-09-28 09:42:06',3,42101,0,50,1,50,1,'I','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'; 28/09/2023 10:53:23.0529 609 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,'2023-09-28 10:53:22','V',4780285263997610,2023,'2023-09-28 10:53:21','451953920100327005012999',1,2,16,'I','',1,0,1,'','',4) 28/09/2023 13:26:29.7238 593 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5094435447745990,5219984937119620,2023,'2023-09-28 13:26:29',' Date: 9/28/2023 1:26:28 PM Code: 451954754300327005012999 Entry Date: 9/28/2023 1:12:23 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2300745170 ',0) 28/09/2023 13:38:35.0849 703 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-09-28 13:38:34' where payTraUID = 4638091961532680 and payStatus='V' and payEnabled=1 28/09/2023 13:55:00.3574 578 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,'2023-09-28 13:54:59','V',5521386964200750,2023,'2023-09-28 13:54:58','451954612600327005012999',2,2,2,'O','',0,'2023-09-28 13:54:59',1,'','',0) 28/09/2023 14:50:30.5474 515 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2023-09-28 14:50:30','0230003944081',0,0,4761917127877280,15,'0000-00-00 00:00:00','0000-00-00 00:00:00') 28/09/2023 14:53:31.2164 578 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 ('2023-09-28 14:53:30',0,'V',4848529414333180,5449081426940720,2023,'2023-09-28 14:53:30',18,1,0,4,'2023-09-28 15:08:30','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/09/2023 15:00:43.6492 750 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,'2023-09-28 15:00:42','V',5482513514022840,2023,'2023-09-28 15:00:42','451955404200327005012999',1,2,16,'I','',1,0,1,'','',4) 28/09/2023 18:59:30.5559 516 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,'2023-09-28 18:59:30','V',5081452226218380,2023,'2023-09-28 18:59:29','451956836900327005012999',1,2,16,'I','',1,0,1,'','',4) 28/09/2023 20:58:52.9373 531 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 ('2023-09-28 20:58:52',0,'V',5208506580503500,4918584288894140,2023,'2023-09-28 20:58:52',18,1,0,4,'2023-09-28 21:13:52','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)