19/08/2024 07:43:22.0076   708 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-19 07:43:21' where traUID = 5232995383392030 and traStatus='V' and traEnabled=1
19/08/2024 08:14:57.2456   588 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-19 08:14:56' where traUID = 4737989664122080 and traStatus='V' and traEnabled=1
19/08/2024 10:36:02.9314  1286 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
19/08/2024 10:46:05.8813  1336 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
19/08/2024 11:03:41.1137   519 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-08-19 11:03:40','V',5461805090185390,2024,'2024-08-19 11:03:40','455213898000327005012999',2,2,2,'O','',0,'2024-08-19 11:03:40',1,'','',0)
19/08/2024 15:25:12.3230   723 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,payVatPercent,payVatAmount) VALUES ('2024-08-19 15:25:11',0,'V',5755980856229270,4850839786077430,2024,'2024-08-19 15:25:11',2,1,0,-1,'2024-08-19 16:25:11','S','KES',0,0,0,'','','',3,0,0)
19/08/2024 16:16:09.7020   506 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4809520441164290,5615478496238470,2024,'2024-08-19 16:16:09','
Date:     8/19/2024 4:16:09 PM

Code:  455215650700327005012999
Entry Date:  8/19/2024 3:41:47 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


# 2400736830
',0)
19/08/2024 16:22:15.5422   660 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-19 16:22:14' where payTraUID = 4951098249416180 and payStatus='V' and payEnabled=1
19/08/2024 16:44:18.8286  1573 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-08-19 16:44:16',0,'V',5146968654242050,5654672574769910,2024,'2024-08-19 16:44:16',3,1,0,4,'2024-08-19 16:59:16','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0)
19/08/2024 16:44:19.7482   909 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5654672574769910,5146968654242050,2024,'2024-08-19 16:44:18','----------------------------------
%The Mall P0006032390             


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

POF 

Entry : 8/19/2024 4:10:30 PM

Date : 8/19/2024 4:44:16 PM
Code : 455215823000327005012999

Total           : 50.00 KES

VAT 16%         : 6.90 KES
----------------------------------
   Paid            : 50.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)
19/08/2024 16:44:20.4194   525 ms.           EXEC: update paycash set casCreation = '2024-08-19 16:44:19',casModify = '2024-08-19 16:44:19',casUseId=0,casStatus='V' where casId = 180142
19/08/2024 16:44:23.6202  3200 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-19 16:44:19',3,42101,0,50,1,50,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N';

19/08/2024 16:44:24.4199   797 ms.           EXEC: update payInventory set invCreation = '2024-08-19 16:44:23',invModify = '2024-08-19 16:44:23',invUseId=0,invStatus='V' where invId = 202278
19/08/2024 17:59:13.8121   522 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-19 17:59:13',0,0,'V',5017686974885480,5643180942942600,2024,'2024-08-19 17:59:13',3,'KES',1,50,50,'N','');

19/08/2024 20:00:21.7969   517 ms.           EXEC: update abbCards set carLastDate = '2024-08-19 20:00:21',carLastDirection='I' where carStatus='V' and carId = 21
19/08/2024 20:11:39.0562   789 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-08-19 20:11:38',0,'V',4843335725534200,5662426244476210,2024,'2024-08-19 20:11:38',18,1,0,4,'2024-08-19 20:26:38','C','KES',100,100,0,'','','',1,100,0,0,'',0,0)
19/08/2024 20:45:14.7281   613 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-19 20:45:14',3,42101,0,50,1,50,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N';