01/03/2025 08:04:55.3467 2387 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 01/03/2025 08:11:16.3947 788 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-01 08:11:14',5,3,42101,0,50,18,900,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+18,5),curAmount=round(curAmount+900,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 ('2025-03-01 08:11:14',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 ('2025-03-01 08:11:14',5,3,42101,0,100,7,700,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+7,5),curAmount=round(curAmount+700,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; 01/03/2025 08:52:00.8043 805 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 144 order by traDateTime desc,traId desc 01/03/2025 09:16:45.8735 910 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 20 order by traDateTime desc,traId desc 01/03/2025 09:28:22.3998 805 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 01/03/2025 09:47:51.1918 752 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 17 order by traDateTime desc,traId desc 01/03/2025 09:55:15.4906 1077 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 01/03/2025 10:12:53.6303 2645 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as 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 = 1 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)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 01/03/2025 10:15:44.2054 502 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 01/03/2025 10:45:46.5886 1217 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 01/03/2025 11:59:14.6930 1320 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 01/03/2025 12:39:18.7630 540 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/03/2025 13:57:43.3767 5859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/03/2025 13:57:48.1269 1611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/03/2025 14:02:38.2968 563 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/03/2025 14:03:48.4113 704 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,'2025-03-01 14:03:47','V',5677065550412120,2025,'2025-03-01 14:03:47','457154707000327001012999',2,2,2,'O','',0,'2025-03-01 14:03:47',1,'','',0) 01/03/2025 14:03:59.8954 575 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 411162 else acvFstPayId end),acvLstPayId = 411162 where acvSftId = 911 and acvCodeId = 3 01/03/2025 14:22:41.9334 805 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4993119009497990,5414620854285890,2025,'2025-03-01 14:22:41',' Date: 3/1/2025 2:21:22 PM Code: 457155031800327005012999 Entry Date: 3/1/2025 1:58:38 PM 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 # 2500402701 ',0) 01/03/2025 15:10:54.4988 574 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 ('2025-03-01 15:10:53',0,'V',5357607521207880,5252539851844030,2025,'2025-03-01 15:10:53',3,1,0,4,'2025-03-01 15:25:53','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 01/03/2025 15:10:56.0579 892 ms. EXEC: update payInventory set invCreation = '2025-03-01 15:10:55',invModify = '2025-03-01 15:10:55',invUseId=0,invStatus='V' where invId = 239101 01/03/2025 15:15:39.9358 708 ms. EXEC: update paycash set casCreation = '2025-03-01 15:15:39',casModify = '2025-03-01 15:15:39',casUseId=0,casStatus='V' where casId = 211417 01/03/2025 17:09:26.7479 501 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/03/2025 17:28:26.3809 556 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4728489038145450,5098549418239650,2025,'2025-03-01 17:28:25',' Data: 3/1/2025 5:27:53 PM Codice: 457156218600327005012999 Ingresso: 3/1/2025 5:16:26 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500601595 ',0) 01/03/2025 18:20:27.6132 1159 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2025-03-01 18:20:26',9999,'open','Send command to entry/exit units: Command OPEN on Device Entry 2 ','') 01/03/2025 20:23:07.0340 539 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-03-01 20:23:06' where payTraUID = 5347403687583320 and payStatus='V' and payEnabled=1 01/03/2025 21:54:59.0911 616 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-03-01 21:54:58',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 ('2025-03-01 21:54:58',3,42101,0,200,-2,-400,1,'O','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';