Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2927' AND TIME>='2024-05-31 02:27:01'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2927' AND TIME>='2024-05-01 06:27:01'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3129' AND TIME>='2024-05-31 02:27:01'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-31 02:28:19'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-01 06:28:19'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-31 02:28:59'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-01 06:28:59'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-31 02:29:14'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-01 06:29:14'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-31 02:40:19'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-01 06:40:19'  ORDER BY TIME DESC LIMIT 1