Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8997' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-30 21:44:01' AND e.date<='2024-07-31 20:44:01'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8997' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-30 21:44:01' AND e.date<='2024-07-31 20:44:01'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-16 12:09:36' AND e.date<='2024-07-16 15:09:36'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-16 12:09:36' AND e.date<='2024-07-16 15:09:36'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-16 12:51:27' AND e.date<='2024-07-16 14:51:27'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-16 12:51:27' AND e.date<='2024-07-16 14:51:27'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116302726' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-28 21:21:11' AND e.date<='2024-08-02 11:21:11'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116302726' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-28 21:21:11' AND e.date<='2024-08-02 11:21:11'