Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2920' AND TIME>='2024-09-03 02:16:34'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2920' AND TIME>='2024-08-04 06:16:34'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2920'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2920' AND TIME>='2024-09-03 02:19:46'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2920' AND TIME>='2024-08-04 06:19:46'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2920'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2763' AND TIME>='2024-09-03 02:21:46'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2763' AND TIME>='2024-09-03 02:21:52'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2763' AND TIME>='2024-09-03 02:21:56'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2848' AND TIME>='2024-09-03 02:46:08'  ORDER BY TIME DESC LIMIT 1