06/04/2025 05:05:39.0411 532 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 06/04/2025 05:05:39.9610 917 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/04/2025 05:05:41.0467 1083 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); 06/04/2025 05:42:21.3194 4524 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-04-06 05:42:15',0,'V',5582760495522160,5752821753561010,2025,'2025-04-06 05:42:15',3,1,0,4,'2025-04-06 05:57:15','C','KES',100,200,100,'',' ',' ',1,100,0,0,'',0,0) 06/04/2025 05:42:23.9606 2576 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5752821753561010,5582760495522160,2025,'2025-04-06 05:42:21','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/6/2025 5:08:49 AM Date : 4/6/2025 5:42:15 AM Code : 457511852900327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 100.00 KES',0) 06/04/2025 08:26:03.5763 6083 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 06/04/2025 08:35:26.7276 1031 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 06/04/2025 10:11:33.7757 1373 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 06/04/2025 11:13:39.3033 587 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5140580107986760,4810494448022050,2025,'2025-04-06 11:13:38',' Date: 4/6/2025 11:13:38 AM Code: 457513934900327001012999 Entry Date: 4/6/2025 10:55:49 AM 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 # 2500713936 ',0) 06/04/2025 11:17:54.7394 765 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 06/04/2025 11:41:32.3978 4596 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 = 12 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 06/04/2025 12:27:49.2769 670 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 06/04/2025 13:07:32.9146 506 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-04-06 13:07:32','V',4734365252153590,2025,'2025-04-06 13:07:32','457514725200327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 2 ms.) 06/04/2025 15:25:10.2139 674 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5743289996812840,5036391012463230,2025,'2025-04-06 15:25:09',' Data: 4/6/2025 3:23:48 PM Codice: 457514808000327005012999 Ingresso: 4/6/2025 1:21:20 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500602540 ',0) 06/04/2025 17:09:50.3363 546 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-04-06 17:09:49',0,'V',4747208575204980,5252820869058050,2025,'2025-04-06 17:09:49',3,1,0,4,'2025-04-06 17:24:49','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 06/04/2025 17:27:51.6124 600 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/04/2025 17:28:02.8703 876 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-06 17:28:01',0,16,'2025-04-06 17:28:01','','Unauthorized Transit Entry 2') 06/04/2025 19:29:04.7292 642 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-06 19:29:03',3,42101,0,50,-1,-50,1,'O','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';