28/07/2024 09:15:30.0134   630 ms.           EXEC: update abbCards set carLastDate = '2024-07-28 09:15:29',carLastDirection='O' where carStatus='V' and carId = 141
28/07/2024 10:26:07.7299   550 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4822271003803010,5350321704057390,2024,'2024-07-28 10:26:07','
Date:    7/28/2024 10:27:57 AM

Code:  454992776500327005012999
Entry Date:  7/28/2024 7:42:45 AM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:              100.00 KES
______________________________
Paid:               100.00 KES
                    __________
Change:               0.00 KES

Type:              Credit Card
Dispozitiv:   Manual Cashier 1


# 2400410716
',0)
28/07/2024 11:20:34.2161   561 ms.           EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-07-28 11:20:33',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','')
28/07/2024 11:57:25.1782   560 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-07-28 11:57:24' where payTraUID = 4618711728333690 and payStatus='V' and payEnabled=1
28/07/2024 13:53:12.1578   590 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4869243370898350,5243848412415350,2024,'2024-07-28 13:53:11','----------------------------------
%The Mall P0006032390             


          End of payment          
----------------------------------

POF 

Entry : 7/28/2024 1:37:38 PM

Date : 7/28/2024 1:53:10 PM
Code : 454994905800327005012999

Total           : 50.00 KES

VAT 16%         : 6.90 KES
----------------------------------
   Paid            : 50.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)
28/07/2024 19:30:01.0387  1030 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