Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-09 9:27:54' AND e.date<='2024-12-10 9:27:54' AND e.DeviceLoginName='3162' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-09 07:27:54' AND g.time<='2024-12-10 07:27:54' AND g.DeviceLoginName='3162' GROUP BY  g.time, g.Distance;
CountAzimuth:2553
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 0:27:54' AND e.date<='2024-12-05 23:27:54' AND e.DeviceLoginName='3162' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-04 22:27:54' AND g.time<='2024-12-05 21:27:54' AND g.DeviceLoginName='3162' GROUP BY  g.time, g.Distance;
CountAzimuth:3984
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 0:27:54' AND e.date<='2024-12-06 23:27:54' AND e.DeviceLoginName='3162' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-05 22:27:54' AND g.time<='2024-12-06 21:27:54' AND g.DeviceLoginName='3162' GROUP BY  g.time, g.Distance;
CountAzimuth:4058
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-10 4:22:1' AND e.date<='2024-12-10 13:22:1' AND e.DeviceLoginName='354836080167561' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-10 02:22:01' AND g.time<='2024-12-10 11:22:01' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:521
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-10 6:31:9' AND e.date<='2024-12-10 13:31:9' AND e.DeviceLoginName='356078116278207' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-10 04:31:09' AND g.time<='2024-12-10 11:31:09' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:575
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 0:30:1' AND e.date<='2024-12-08 23:30:1' AND e.DeviceLoginName='2743' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-06 22:30:01' AND g.time<='2024-12-08 21:30:01' AND g.DeviceLoginName='2743' GROUP BY  g.time, g.Distance;
CountAzimuth:50
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 0:30:1' AND e.date<='2024-12-06 23:30:1' AND e.DeviceLoginName='2743' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-01 22:30:01' AND g.time<='2024-12-06 21:30:01' AND g.DeviceLoginName='2743' GROUP BY  g.time, g.Distance;
CountAzimuth:2413
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 0:45:17' AND e.date<='2024-12-08 23:45:17' AND e.DeviceLoginName='2743' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-07 22:45:17' AND g.time<='2024-12-08 21:45:17' AND g.DeviceLoginName='2743' GROUP BY  g.time, g.Distance;
CountAzimuth:47