05/08/2025 09:40:09.2606 657 ms. EXEC: update abbCards set carLastDate = '2025-08-05 09:40:08',carLastDirection='O' where carStatus='V' and carId = 44 05/08/2025 10:35:17.1053 1531 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 = 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)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 05/08/2025 12:18:55.7952 515 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4715616285682180,5714675056680100,2025,'2025-08-05 12:18:55',' Data: 8/5/2025 12:17:30 PM Codice: 458724154600327005012999 Ingresso: 8/5/2025 11:32:26 AM 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 # 2500605867 ',0) 05/08/2025 14:45:58.0273 510 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-08-05 14:45:57',0,'V',5660970394969000,5091781981197770,2025,'2025-08-05 14:45:57',18,1,0,4,'2025-08-05 15:00:57','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 05/08/2025 17:38:10.2784 560 ms. EXEC: update abbCards set carLastDate = '2025-08-05 17:38:09',carLastDirection='O' where carStatus='V' and carId = 142 05/08/2025 19:33:45.6472 530 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-08-05 19:33:45','0230003944064',0,0,5740880208045680,14,'0000-00-00 00:00:00','0000-00-00 00:00:00')