Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2927' AND TIME>='2024-05-20 03:59:42'  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-04-20 07:59:42'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3032' AND TIME>='2024-05-20 07:07:57'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3032' AND TIME>='2024-04-20 11:07:57'  ORDER BY TIME DESC LIMIT 1