60 |
final String SQL = "SELECT * FROM ( "+ |
final String SQL = "SELECT * FROM ( "+ |
61 |
" SELECT imei,handle,groupname,latitude,longitude, " + |
" SELECT imei,handle,groupname,latitude,longitude, " + |
62 |
" extract(epoch from now())::int - extract(epoch from updated)::int AS lastupdate, " + |
" extract(epoch from now())::int - extract(epoch from updated)::int AS lastupdate, " + |
63 |
" earth_distance( ll_to_earth(latitude,longitude), ll_to_earth(56,9))::int AS calcdist " + |
" earth_distance( ll_to_earth(latitude,longitude), ll_to_earth(?,?))::int AS calcdist " + |
64 |
" FROM droidradar " + |
" FROM droidradar " + |
65 |
" WHERE imei <> ? AND updated > now() - interval '15 minutes' " + |
" WHERE imei <> ? AND updated > now() - interval '15 minutes' " + |
66 |
" ) AS droidradar2 " + |
" ) AS droidradar2 " + |
93 |
buff.append("<latitude>").append(res.getString(4) ) .append("</latitude>\n"); |
buff.append("<latitude>").append(res.getString(4) ) .append("</latitude>\n"); |
94 |
buff.append("<longitude>").append(res.getString(5) ) .append("</longitude>\n"); |
buff.append("<longitude>").append(res.getString(5) ) .append("</longitude>\n"); |
95 |
buff.append("<lastupdate>").append(res.getInt(6) ) .append("</lastupdate>\n"); |
buff.append("<lastupdate>").append(res.getInt(6) ) .append("</lastupdate>\n"); |
|
buff.append("<distance>").append(res.getDouble(7) ) .append("</distance>\n"); |
|
96 |
|
|
97 |
buff.append("</droid>\n"); |
buff.append("</droid>\n"); |
98 |
} |
} |