12/10/2024 03:27:38.8870 1800 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 12/10/2024 03:27:39.5054 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 12/10/2024 07:39:41.9884 550 ms. EXEC: update paycash set casCreation = '2024-10-12 07:39:41',casModify = '2024-10-12 07:39:41',casUseId=0,casStatus='V' where casId = 189129 12/10/2024 09:56:28.4553 583 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-12 09:56:27' where traUID = 5671236457985030 and traStatus='V' and traEnabled=1 12/10/2024 10:43:16.4986 537 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-12 10:43:15',4,6,'2024-10-12 10:43:15','455753744200327005012999','Payed (Credit Card ) Ticket ') (WAIT TIME 5 ms.) 12/10/2024 10:55:27.5165 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,'2024-10-12 10:55:26','V',4719931523388730,2024,'2024-10-12 10:55:25','455753932500327005012999',1,2,16,'I','',1,0,1,'','',4) 12/10/2024 11:00:49.2956 533 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-10-12 11:00:48','V',5425127813324890,2024,'2024-10-12 11:00:48','455753648300327001012999',2,2,2,'O','',0,'2024-10-12 11:00:48',1,'','',0) 12/10/2024 11:42:01.6032 585 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-10-12 11:42:01','V',4930225008599920,2024,'2024-10-12 11:41:59','455754097500327005012999',2,2,2,'O','',0,'2024-10-12 11:42:01',1,'','',0) 12/10/2024 12:09:09.6529 565 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5442349866907170,5299420770203650,2024,'2024-10-12 12:09:09',' Date: 10/12/2024 12:09:08 PM Code: 455753978700327001012999 Entry Date: 10/12/2024 11:03:07 AM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400745197 ',0) 12/10/2024 13:05:08.6551 622 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-12 13:05:08',0,16,'2024-10-12 13:05:08','','Manual Open Barrier Entry 2') 12/10/2024 13:41:34.7157 556 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-10-12 13:41:33',0,'V',5622637711851650,4967358151018680,2024,'2024-10-12 13:41:33',3,1,0,4,'2024-10-12 13:56:33','C','KES',100,200,100,'',' ',' ',1,100,0,0,'',0,0) 12/10/2024 14:39:29.8013 558 ms. EXEC: update payInventory set invCreation = '2024-10-12 14:39:29',invModify = '2024-10-12 14:39:29',invUseId=0,invStatus='V' where invId = 212617 12/10/2024 15:34:05.3815 536 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-10-12 15:34:04',0,'V',4941865782554740,4745713306310030,2024,'2024-10-12 15:34:04',18,1,0,4,'2024-10-12 15:49:04','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 12/10/2024 15:58:53.8317 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,'2024-10-12 15:58:53','V',5191986201020670,2024,'2024-10-12 15:58:53','455755519200327005012999',2,2,2,'O','',0,'2024-10-12 15:58:53',1,'','',0) 12/10/2024 19:16:16.3671 608 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-10-12 19:16:15','V',5492980399527030,2024,'2024-10-12 19:16:15','455756546100327005012999',2,2,2,'O','',0,'2024-10-12 19:16:15',1,'','',0) 12/10/2024 19:52:26.5757 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/10/2024 19:53:15.8500 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 12/10/2024 19:53:39.1706 827 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 12/10/2024 20:24:07.5322 1099 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-10-12 20:24:06',9999,'open','Send command to entry/exit units: Command OPEN on Device Entry 2 ','') 12/10/2024 20:24:45.3398 1186 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-10-12 20:23:07',1,'V',4703173063305980,5448747964738550,2024,'2024-10-12 20:23:07',17,1,0,4,'2024-10-12 20:38:07','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 12/10/2024 20:24:45.9811 552 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 358818 else acvFstPayId end),acvLstPayId = 358818 where acvSftId = 787 and acvCodeId = 3 12/10/2024 20:24:46.5975 606 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6365, trcLastPrinted = '2400606365', trcLastDate = '2024-10-12 20:24:45' where trcStatus='V' and trcTerId = 17 12/10/2024 20:43:47.9353 588 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4961802620963140,5362852384270090,2024,'2024-10-12 20:43:47',' Date: 10/12/2024 8:43:47 PM Code: 455756922900327005012999 Entry Date: 10/12/2024 7:13:49 PM 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 # 2400745301 ',0) 12/10/2024 21:23:43.8588 525 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-12 21:23:43' where traUID = 4862599617223870 and traStatus='V' and traEnabled=1 12/10/2024 22:37:59.9219 522 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-12 22:37:59' where traUID = 4720493797318120 and traStatus='V' and traEnabled=1 12/10/2024 23:03:10.9028 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,'2024-10-12 23:03:10','V',4654345064085170,2024,'2024-10-12 23:03:10','455756690600327005012999',2,2,2,'O','',0,'2024-10-12 23:03:10',1,'','',0) 12/10/2024 23:50:12.6004 627 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5230488642465310,4761989380131720,2024,'2024-10-12 23:50:11',' Date: 10/12/2024 11:48:27 PM Code: 455758489100327005012999 Entry Date: 10/12/2024 11:34:51 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 # 2400414464 ',0)