2024/09/23 23:57:41 - Connected to MQTT Broker. 2024/09/23 23:57:41 - Received message from topic: parking/20002/spaceCounter/status 2024/09/23 23:57:41 - Payload: {"UpdateTime":"2024/09/23 23:57:22","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:57:41 - Successfully subscribed to topics. 2024/09/23 23:57:41 - Data added for topic parking/20002/spaceCounter/status: {"UpdateTime":"2024/09/23 23:57:22","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:57:41 - Received message from topic: parking/20001_3/spaceCounter/status 2024/09/23 23:57:41 - Payload: {"UpdateTime":"2024/09/23 23:57:28","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]} 2024/09/23 23:57:41 - Data added for topic parking/20001_3/spaceCounter/status: {"UpdateTime":"2024/09/23 23:57:28","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]} 2024/09/23 23:57:41 - Received message from topic: parking/20001_1/spaceCounter/status 2024/09/23 23:57:41 - Payload: {"UpdateTime":"2024/09/23 23:57:22","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":61},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:57:41 - Data added for topic parking/20001_1/spaceCounter/status: {"UpdateTime":"2024/09/23 23:57:22","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":61},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:57:41 - Received message from topic: parking/20001_2/spaceCounter/status 2024/09/23 23:57:41 - Payload: {"UpdateTime":"2024/09/23 23:57:18","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:57:41 - Data added for topic parking/20001_2/spaceCounter/status: {"UpdateTime":"2024/09/23 23:57:18","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:57:41 - Loc20_UploadData Receive¡G{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20001', 'E68628', '2024/09/23 23:57:35', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/09/23 23:57:41 - Loc20_UploadData Response¡G{"errCode":"000000","errMsg":"¥¿±`","responseData":{}} 2024/09/23 23:57:45 - Received message from topic: parking/20001_2/spaceCounter/status 2024/09/23 23:57:45 - Payload: {"UpdateTime":"2024/09/23 23:57:48","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:57:45 - Data added for topic parking/20001_2/spaceCounter/status: {"UpdateTime":"2024/09/23 23:57:48","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:57:46 - Loc20_UploadData Receive¡G{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20001', 'E68628', '2024/09/23 23:57:35', '', '', '0', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')"}} 2024/09/23 23:57:52 - Received message from topic: parking/20001_1/spaceCounter/status 2024/09/23 23:57:52 - Payload: {"UpdateTime":"2024/09/23 23:57:52","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":60},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:57:52 - Data added for topic parking/20001_1/spaceCounter/status: {"UpdateTime":"2024/09/23 23:57:52","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":60},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:57:52 - Received message from topic: parking/20002/spaceCounter/status 2024/09/23 23:57:52 - Payload: {"UpdateTime":"2024/09/23 23:57:52","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:57:52 - Data added for topic parking/20002/spaceCounter/status: {"UpdateTime":"2024/09/23 23:57:52","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:57:57 - Received message from topic: parking/20001_3/spaceCounter/status 2024/09/23 23:57:57 - Payload: {"UpdateTime":"2024/09/23 23:57:58","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]} 2024/09/23 23:57:57 - Data added for topic parking/20001_3/spaceCounter/status: {"UpdateTime":"2024/09/23 23:57:58","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]} 2024/09/23 23:58:15 - Received message from topic: parking/20001_2/spaceCounter/status 2024/09/23 23:58:15 - Payload: {"UpdateTime":"2024/09/23 23:58:18","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:58:15 - Data added for topic parking/20001_2/spaceCounter/status: {"UpdateTime":"2024/09/23 23:58:18","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:58:22 - Received message from topic: parking/20001_1/spaceCounter/status 2024/09/23 23:58:22 - Payload: {"UpdateTime":"2024/09/23 23:58:22","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":60},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:58:22 - Data added for topic parking/20001_1/spaceCounter/status: {"UpdateTime":"2024/09/23 23:58:22","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":60},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:58:22 - Received message from topic: parking/20002/spaceCounter/status 2024/09/23 23:58:22 - Payload: {"UpdateTime":"2024/09/23 23:58:22","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:58:22 - Data added for topic parking/20002/spaceCounter/status: {"UpdateTime":"2024/09/23 23:58:22","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:58:25 - Loc20_UploadData Receive¡G{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'E68628' AND EntryDatetime = '2024/09/23 23:57:35')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/09/23 23:58:23', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'E68628' AND EntryDatetime = '2024/09/23 23:57:35'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'E68628', '2024/09/23 23:57:35', '', '2024/09/23 23:58:23', '2', '1', '2', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/09/23 23:58:25 - Loc20_UploadData Response¡G{"errCode":"000000","errMsg":"¥¿±`","responseData":{}} 2024/09/23 23:58:27 - Received message from topic: parking/20001_3/spaceCounter/status 2024/09/23 23:58:27 - Payload: {"UpdateTime":"2024/09/23 23:58:28","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]} 2024/09/23 23:58:27 - Data added for topic parking/20001_3/spaceCounter/status: {"UpdateTime":"2024/09/23 23:58:28","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]} 2024/09/23 23:58:45 - Received message from topic: parking/20001_2/spaceCounter/status 2024/09/23 23:58:45 - Payload: {"UpdateTime":"2024/09/23 23:58:48","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:58:45 - Data added for topic parking/20001_2/spaceCounter/status: {"UpdateTime":"2024/09/23 23:58:48","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:58:52 - Received message from topic: parking/20001_1/spaceCounter/status 2024/09/23 23:58:52 - Payload: {"UpdateTime":"2024/09/23 23:58:52","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":61},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:58:52 - Data added for topic parking/20001_1/spaceCounter/status: {"UpdateTime":"2024/09/23 23:58:52","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":61},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:58:52 - Received message from topic: parking/20002/spaceCounter/status 2024/09/23 23:58:52 - Payload: {"UpdateTime":"2024/09/23 23:58:52","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:58:52 - Data added for topic parking/20002/spaceCounter/status: {"UpdateTime":"2024/09/23 23:58:52","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:58:57 - Received message from topic: parking/20001_3/spaceCounter/status 2024/09/23 23:58:57 - Payload: {"UpdateTime":"2024/09/23 23:58:58","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]} 2024/09/23 23:58:57 - Data added for topic parking/20001_3/spaceCounter/status: {"UpdateTime":"2024/09/23 23:58:58","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]} 2024/09/23 23:59:15 - Received message from topic: parking/20001_2/spaceCounter/status 2024/09/23 23:59:15 - Payload: {"UpdateTime":"2024/09/23 23:59:18","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:59:15 - Data added for topic parking/20001_2/spaceCounter/status: {"UpdateTime":"2024/09/23 23:59:18","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:59:22 - Received message from topic: parking/20001_1/spaceCounter/status 2024/09/23 23:59:22 - Payload: {"UpdateTime":"2024/09/23 23:59:22","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":61},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:59:22 - Data added for topic parking/20001_1/spaceCounter/status: {"UpdateTime":"2024/09/23 23:59:22","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":61},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:59:22 - Received message from topic: parking/20002/spaceCounter/status 2024/09/23 23:59:22 - Payload: {"UpdateTime":"2024/09/23 23:59:22","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:59:22 - Data added for topic parking/20002/spaceCounter/status: {"UpdateTime":"2024/09/23 23:59:22","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:59:27 - Received message from topic: parking/20001_3/spaceCounter/status 2024/09/23 23:59:27 - Payload: {"UpdateTime":"2024/09/23 23:59:28","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]} 2024/09/23 23:59:27 - Data added for topic parking/20001_3/spaceCounter/status: {"UpdateTime":"2024/09/23 23:59:28","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]} 2024/09/23 23:59:45 - Received message from topic: parking/20001_2/spaceCounter/status 2024/09/23 23:59:45 - Payload: {"UpdateTime":"2024/09/23 23:59:48","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:59:45 - Data added for topic parking/20001_2/spaceCounter/status: {"UpdateTime":"2024/09/23 23:59:48","SpaceValue":[{"VehicleType":0,"TotalSpace":0,"RemainSpace":0},{"VehicleType":1,"TotalSpace":200,"RemainSpace":200},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:59:52 - Received message from topic: parking/20001_1/spaceCounter/status 2024/09/23 23:59:52 - Payload: {"UpdateTime":"2024/09/23 23:59:52","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":61},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:59:52 - Data added for topic parking/20001_1/spaceCounter/status: {"UpdateTime":"2024/09/23 23:59:52","SpaceValue":[{"VehicleType":0,"TotalSpace":63,"RemainSpace":61},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":0,"RemainSpace":0}]} 2024/09/23 23:59:52 - Received message from topic: parking/20002/spaceCounter/status 2024/09/23 23:59:52 - Payload: {"UpdateTime":"2024/09/23 23:59:52","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:59:52 - Data added for topic parking/20002/spaceCounter/status: {"UpdateTime":"2024/09/23 23:59:52","SpaceValue":[{"VehicleType":0,"TotalSpace":38,"RemainSpace":0},{"VehicleType":1,"TotalSpace":132,"RemainSpace":0},{"VehicleType":2,"TotalSpace":3,"RemainSpace":2}]} 2024/09/23 23:59:57 - Received message from topic: parking/20001_3/spaceCounter/status 2024/09/23 23:59:57 - Payload: {"UpdateTime":"2024/09/23 23:59:58","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]} 2024/09/23 23:59:57 - Data added for topic parking/20001_3/spaceCounter/status: {"UpdateTime":"2024/09/23 23:59:58","SpaceValue":[{"VehicleType":0,"TotalSpace":18,"RemainSpace":14},{"VehicleType":1,"TotalSpace":0,"RemainSpace":0},{"VehicleType":2,"TotalSpace":30,"RemainSpace":25}]}