21/08/2024 12:22:51.4820   535 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5571489509495960,4681722988654660,2024,'2024-08-21 12:22:50','
Date:    8/21/2024 12:22:50 PM

Code:  455233479300327005012999
Entry Date:  8/21/2024 9:39:53 AM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:              100.00 KES
______________________________
Paid:               100.00 KES
                    __________
Change:               0.00 KES

Type:                     Cash
Dispozitiv:              MPESA


# 2400737042
',0)
21/08/2024 13:12:55.5881   546 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5680573033011240,5113373778494230,2024,'2024-08-21 13:12:55','
Date:     8/21/2024 1:12:15 PM

Code:  455234669000327005012999
Entry Date:  8/21/2024 12:58:10 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


# 2400411789
',0)
21/08/2024 13:54:33.2990   622 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5462169733015510,4745353860456910,2024,'2024-08-21 13:54:32','
Date:     8/21/2024 1:54:32 PM

Code:  455234850500327005012999
Entry Date:  8/21/2024 1:28:25 PM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:               50.00 KES
______________________________
Paid:                50.00 KES
                    __________
Change:               0.00 KES

Type:                     Cash
Dispozitiv:              MPESA


# 2400737064
',0)
21/08/2024 16:40:53.9501   554 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-21 16:40:53' where payTraUID = 5636278659460130 and payStatus='V' and payEnabled=1
21/08/2024 17:06:05.7898   579 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-21 17:06:05' where traUID = 5180749620272320 and traStatus='V' and traEnabled=1
21/08/2024 17:57:19.6565   600 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-21 17:57:19' where payTraUID = 5074308067316890 and payStatus='V' and payEnabled=1
21/08/2024 19:18:37.6105   728 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