27/06/2023 07:51:07.1230 534 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-27 07:51:02',5,3,42101,0,50,-21,-1050,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-27 07:51:02',5,3,42101,0,100,-60,-6000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-27 07:51:02',5,3,42101,0,200,-18,-3600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-27 07:51:02',5,3,42101,0,500,-8,-4000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-27 07:51:02',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 27/06/2023 07:51:12.2539 619 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/06/2023 10:03:43.0984 1282 ms. OPEN: select 1 as Tot,payUID,payPayed,payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 27/06/2023 10:06:56.7942 751 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-06-27 10:06:56','V',5449852503749750,2023,'2023-06-27 10:06:55','451023641500327005012999',1,2,16,'I','',1,0,1,'','',4) 27/06/2023 10:55:44.9064 795 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2023-06-27 10:55:44','V',4783395375715120,2023,'2023-06-27 10:55:43','451013503700327005012999',2,2,2,'O','',0,'2023-06-27 10:55:44',1,'','0230003950896',20,0) 27/06/2023 13:45:50.6311 619 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-06-27 13:45:50',0,0,'V',5497561086464080,4762484280972330,2023,'2023-06-27 13:45:50',3,'KES',-1,50,-50,'N',''); 27/06/2023 15:50:26.5861 658 ms. EXEC: update paycash set casCreation = '2023-06-27 15:50:25',casModify = '2023-06-27 15:50:25',casUseId=0,casStatus='V' where casId = 89197 27/06/2023 16:55:42.9976 536 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-06-27 16:55:42',0,'V',5546803418719730,4855963751155460,2023,'2023-06-27 16:55:42',3,1,0,4,'2023-06-27 17:10:42','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 27/06/2023 16:55:43.7478 517 ms. EXEC: update paycash set casCreation = '2023-06-27 16:55:43',casModify = '2023-06-27 16:55:43',casUseId=0,casStatus='V' where casId = 89218 27/06/2023 19:04:21.3308 630 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-06-27 19:04:20',0,0,'V',5346934148566270,5555545112629060,2023,'2023-06-27 19:04:20',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 ('2023-06-27 19:04:20',0,0,'V',5346934148566270,5555545112629060,2023,'2023-06-27 19:04:20',3,'KES',-2,200,-400,'N',''); 27/06/2023 20:17:51.7127 577 ms. EXEC: update payInventory set invCreation = '2023-06-27 20:17:51',invModify = '2023-06-27 20:17:51',invUseId=0,invStatus='V' where invId = 99468 27/06/2023 20:50:55.1865 524 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-06-27 20:50:54' where traUID = 5528718176519730 and traStatus='V' and traEnabled=1 27/06/2023 20:51:16.8774 630 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-27 20:51:16',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N';