02/05/2025 08:04:13.5358   686 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 ('2025-05-02 08:03:58',9,'V',5289239929654730,4823100465225520,2025,'2025-05-02 08:03:58',4,1,0,4,'2025-05-02 08:18:58','P','KES',50,50,0,'','','',1,50,0,0,'',0,0)
02/05/2025 09:59:05.8990   589 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,'2025-05-02 09:59:05','V',5392139407051080,2025,'2025-05-02 09:59:05','457773527900327005012999',2,2,2,'O','',0,'2025-05-02 09:59:05',1,'','',0)
02/05/2025 11:13:05.1140   516 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-05-02 11:13:04' where traUID = 5335102019095230 and traStatus='V' and traEnabled=1
02/05/2025 12:11:38.2744   504 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,'2025-05-02 12:11:37','V',5027631731424760,2025,'2025-05-02 12:11:37','457774389700327005012999',1,2,16,'I','',1,0,1,'','',4)
02/05/2025 12:25:29.8535   521 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,'2025-05-02 12:25:29','V',5454193472061700,2025,'2025-05-02 12:25:29','457774472900327005012999',1,2,16,'I','',1,0,1,'','',4)
02/05/2025 14:37:23.9124   509 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,'2025-05-02 14:37:23','V',5303251545442350,2025,'2025-05-02 14:37:23','457775264300327005012999',1,2,16,'I','',1,0,1,'','',4)
02/05/2025 16:17:32.2623   529 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5748992931913450,5041375988364620,2025,'2025-05-02 16:17:31','
Date:      5/2/2025 4:17:17 PM

Code:  457775312200327005012999
Entry Date:  5/2/2025 2:45:22 PM
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


# 2500405533
',0)
02/05/2025 17:10:34.3018   522 ms.           EXEC: update abbCards set carLastDate = '2025-05-02 17:10:33',carLastDirection='O' where carStatus='V' and carId = 11
02/05/2025 17:40:31.3080   650 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 ('2025-05-02 17:40:30',0,'V',5186018702077060,5220513079542550,2025,'2025-05-02 17:40:30',18,1,0,4,'2025-05-02 17:55:30','C','KES',100,100,0,'','','',1,100,0,0,'',0,0)
02/05/2025 19:30:36.8614   567 ms.           OPEN: select * from movTransit where traStatus = 'V' and traCode='457756638300327005012999' and traBadge = '0230003944059' order by traId desc limit 1
02/05/2025 19:53:50.9935   675 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-05-02 19:53:50',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';

02/05/2025 20:38:49.3951   549 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 ('2025-05-02 20:38:48',0,'V',5338648392465190,4939093288933920,2025,'2025-05-02 20:38:48',18,1,0,4,'2025-05-02 20:53:48','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
02/05/2025 23:30:06.9603  7157 ms.           OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1
02/05/2025 23:30:06.9653  7123 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 31 ms.)
02/05/2025 23:30:08.6904   610 ms.           EXEC: CREATE TABLE IF NOT EXISTS tabTimeZones(timId int(11) not null auto_increment,timCreation DATETIME not null default '0000-00-00',timModify TIMESTAMP not null,timUseId int(11) not null default 0,timStatus varchar(1) not null default 'V',timRegion varchar(5) not null default '',timIdWindows varchar(100) not null default '',timIdLinux varchar(100) not null default '', PRIMARY KEY (timId)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
02/05/2025 23:30:12.4450  3566 ms.     EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0
02/05/2025 23:30:15.9595  3509 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
02/05/2025 23:30:18.3386  2378 ms.           EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103);
02/05/2025 23:33:25.8610 17936 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 = 9 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
02/05/2025 23:33:58.9262  2964 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc