12/06/2024 12:45:45.5633 734 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 12/06/2024 13:33:25.0830 515 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,'2024-06-12 13:33:24','V',5652287674426850,2024,'2024-06-12 13:33:24','454534766000327005012999',2,2,2,'O','',0,'2024-06-12 13:33:24',1,'','',0) 12/06/2024 14:16:23.8228 765 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,'2024-06-12 14:16:23','V',4890367599014960,2024,'2024-06-12 14:16:22','454534921800327005012999',2,2,2,'O','',0,'2024-06-12 14:16:23',1,'','',0) 12/06/2024 14:27:10.7753 515 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,'2024-06-12 14:27:10','V',5351841331493200,2024,'2024-06-12 14:27:09','454535202900327001012999',1,2,1,'I','',1,0,1,'','',4) 12/06/2024 14:28:16.7645 562 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4876068325024660,4644770013779050,2024,'2024-06-12 14:28:16',' Data: 6/12/2024 2:24:58 PM Codice: 454534519600327005012999 Ingresso: 6/12/2024 12:33:16 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400603891 ',0) 12/06/2024 15:12:11.6883 1328 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 12/06/2024 15:19:01.8910 549 ms. EXEC: update payReceipt set recCreation = '2024-06-12 15:19:01',recModify = '2024-06-12 15:19:01',recUseId=0,recStatus='V' where recId = 271519