Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-07-10 21:00:00' AND g.time<='2024-07-11 06:04:46' AND g.DeviceLoginName='2519'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2519' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-10 21:00:00' AND e.date<='2024-07-11 06:04:46'
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 9:27:18' AND e.date<='2024-07-11 9:27:18' AND e.DeviceLoginName='5046' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-10 06:27:18' AND g.time<='2024-07-11 06:27:18' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:3329
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-01 0:27:18' AND e.date<='2024-07-01 23:27:18' AND e.DeviceLoginName='5046' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-30 21:27:18' AND g.time<='2024-07-01 20:27:18' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:3797
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-02 0:27:18' AND e.date<='2024-07-02 23:27:18' AND e.DeviceLoginName='5046' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-01 21:27:18' AND g.time<='2024-07-02 20:27:18' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:1978
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-03 0:27:18' AND e.date<='2024-07-03 23:27:18' AND e.DeviceLoginName='5046' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-02 21:27:18' AND g.time<='2024-07-03 20:27:18' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:4242
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-04 0:27:18' AND e.date<='2024-07-04 23:27:18' AND e.DeviceLoginName='5046' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-03 21:27:18' AND g.time<='2024-07-04 20:27:18' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:3243
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-05 0:27:18' AND e.date<='2024-07-07 23:27:18' AND e.DeviceLoginName='5046' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-04 21:27:18' AND g.time<='2024-07-07 20:27:18' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:1187
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-06 0:27:18' AND e.date<='2024-07-07 23:27:18' AND e.DeviceLoginName='5046' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-05 21:27:18' AND g.time<='2024-07-07 20:27:18' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:1187
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 0:27:18' AND e.date<='2024-07-11 23:27:18' AND e.DeviceLoginName='5046' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-07 21:27:18' AND g.time<='2024-07-11 20:27:18' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:6792
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 21:27:18' AND e.date<='2024-07-11 5:27:18' AND e.DeviceLoginName='3092' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-10 18:27:18' AND g.time<='2024-07-11 02:27:18' AND g.DeviceLoginName='3092' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 19:27:18' AND e.date<='2024-07-11 5:27:18' AND e.DeviceLoginName='3092' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-10 16:27:18' AND g.time<='2024-07-11 02:27:18' AND g.DeviceLoginName='3092' GROUP BY  g.time, g.Distance;
CountAzimuth:238
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 9:37:11' AND e.date<='2024-07-10 23:37:11' AND e.DeviceLoginName='356078116278207' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-10 06:37:11' AND g.time<='2024-07-10 20:37:11' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:1161
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 2:42:38' AND e.date<='2024-07-11 9:42:38' AND e.DeviceLoginName='356078116278207' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-10 23:42:38' AND g.time<='2024-07-11 06:42:38' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:263
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 6:59:24' AND e.date<='2024-07-11 9:59:24' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-11 03:59:24' AND g.time<='2024-07-11 06:59:24' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-01 0:0:4' AND e.date<='2024-07-01 23:0:4' AND e.DeviceLoginName='2762' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-30 21:00:04' AND g.time<='2024-07-01 20:00:04' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-03 0:0:4' AND e.date<='2024-07-03 23:0:4' AND e.DeviceLoginName='2762' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-02 21:00:04' AND g.time<='2024-07-03 20:00:04' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:3745
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-04 0:0:4' AND e.date<='2024-07-04 23:0:4' AND e.DeviceLoginName='2762' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-03 21:00:04' AND g.time<='2024-07-04 20:00:04' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:3793
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-05 0:0:4' AND e.date<='2024-07-07 23:0:4' AND e.DeviceLoginName='2762' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-04 21:00:04' AND g.time<='2024-07-07 20:00:04' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:3325
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-01 0:0:4' AND e.date<='2024-07-01 23:0:4' AND e.DeviceLoginName='2762' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-30 21:00:04' AND g.time<='2024-07-01 20:00:04' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 0:0:4' AND e.date<='2024-07-08 23:0:4' AND e.DeviceLoginName='2762' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-07 21:00:04' AND g.time<='2024-07-08 20:00:04' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:2109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-09 0:0:4' AND e.date<='2024-07-09 23:0:4' AND e.DeviceLoginName='2762' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-08 21:00:04' AND g.time<='2024-07-09 20:00:04' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:1981
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 0:0:4' AND e.date<='2024-07-10 23:0:4' AND e.DeviceLoginName='2762' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-09 21:00:04' AND g.time<='2024-07-10 20:00:04' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:2519
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 0:0:4' AND e.date<='2024-07-11 23:0:4' AND e.DeviceLoginName='2762' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-10 21:00:04' AND g.time<='2024-07-11 20:00:04' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:403
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-01 0:0:4' AND e.date<='2024-07-01 23:0:4' AND e.DeviceLoginName='2762' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-30 21:00:04' AND g.time<='2024-07-01 20:00:04' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-02 0:0:4' AND e.date<='2024-07-02 23:0:4' AND e.DeviceLoginName='2762' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-01 21:00:04' AND g.time<='2024-07-02 20:00:04' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:717
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 5:44:35' AND e.date<='2024-07-11 11:44:35' AND e.DeviceLoginName='354836080167561' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-11 02:44:35' AND g.time<='2024-07-11 08:44:35' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:783
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 8:44:59' AND e.date<='2024-07-11 11:44:59' AND e.DeviceLoginName='356078116278207' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-11 05:44:59' AND g.time<='2024-07-11 08:44:59' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:542
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 0:4:18' AND e.date<='2024-07-11 12:4:18' AND e.DeviceLoginName='356078116278207' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-10 21:04:18' AND g.time<='2024-07-11 09:04:18' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:634
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 4:4:36' AND e.date<='2024-07-10 23:4:36' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-10 01:04:36' AND g.time<='2024-07-10 20:04:36' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1539
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-07 0:0:4' AND e.date<='2024-07-07 23:0:4' AND e.DeviceLoginName='862531041054447' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-06 21:00:04' AND g.time<='2024-07-07 20:00:04' AND g.DeviceLoginName='862531041054447' GROUP BY  g.time, g.Distance;
CountAzimuth:266
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 11:46:17' AND e.date<='2024-07-11 15:46:17' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-11 08:46:17' AND g.time<='2024-07-11 12:46:17' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 0:0:25' AND e.date<='2024-07-11 16:0:25' AND e.DeviceLoginName='4884' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-10 21:00:25' AND g.time<='2024-07-11 13:00:25' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:2809