30/07/2024 11:54:07.5143   620 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-07-30 11:54:06','V',4773802341833590,2024,'2024-07-30 11:54:06','455014284600327001012999',1,2,1,'I','',1,0,1,'','',4)
30/07/2024 11:54:55.1712  1290 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
30/07/2024 12:12:24.7723   570 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-07-30 12:12:24' where payTraUID = 5558401673385430 and payStatus='V' and payEnabled=1
30/07/2024 14:50:48.3351   537 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-07-30 14:50:47','V',5309703229722570,2024,'2024-07-30 14:50:46','455015344600327005012999',1,2,16,'I','',1,0,1,'','',4)
30/07/2024 15:31:26.0010   990 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 ('2024-07-30 15:31:24',0,'V',5011170363811730,5068786095543300,2024,'2024-07-30 15:31:24',18,1,0,4,'2024-07-30 15:46:24','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
30/07/2024 15:31:26.6410   620 ms.           EXEC: update tabTerminalReceipt set trcProgressive = 33648, trcLastPrinted = '2400733648', trcLastDate = '2024-07-30 15:31:26' where trcStatus='V' and trcTerId = 18
30/07/2024 15:31:27.8110  1170 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5068786095543300,5011170363811730,2024,'2024-07-30 15:31:26','
Date:     7/30/2024 3:31:24 PM

Code:  455015465000327001012999
Entry Date:  7/30/2024 3:10:50 PM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 1
______________________________
Total:               50.00 KES
______________________________
Paid:                50.00 KES
                    __________
Change:               0.00 KES

Type:                     Cash
Dispozitiv:              MPESA


# 2400733648
',0)
30/07/2024 15:31:28.6610   850 ms.           EXEC: update payReceipt set recCreation = '2024-07-30 15:31:27',recModify = '2024-07-30 15:31:27',recUseId=0,recStatus='V' where recId = 287230
30/07/2024 15:40:13.8444   510 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-07-30 15:40:13' where payTraUID = 5121719710864790 and payStatus='V' and payEnabled=1
30/07/2024 19:40:07.6144   663 ms.           EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-07-30 19:40:06',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','')