Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111279432' AND TIME>='2024-04-22 03:04:56'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111279432' AND TIME>='2024-03-23 06:04:56'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111279432'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078118085311' AND TIME>='2024-04-22 03:05:04'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078118085311' AND TIME>='2024-04-22 05:45:49'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3037' AND TIME>='2024-04-22 06:10:06'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3037' AND TIME>='2024-03-23 09:10:06'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4884' AND TIME>='2024-04-22 06:56: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='4884' AND TIME>='2024-03-23 09:56:57'  ORDER BY TIME DESC LIMIT 1