Gan dan Sist tanya dong... Ni ane bikin TA tentang location-based reminder. Tapi setelah ane coba koding reminder-nya g aktip. Padahal db sqlite-nya ada isinya dan muncul. Query-nya juga uda bener.
Ni kode query-nya
Spoiler for kode:
public ArrayList<Task> postCheck(String addr) {
openConn();
ArrayList<Task> tugas = new ArrayList<Task>();
Cursor curs = db.rawQuery("select * from " + TableName + " where " + ALAMAT + " = " + addr, null);
if (curs.moveToFirst()) {
do {
Task task = new Task();
task.setAlamat(curs.getString(curs.getColumnIndex(ALAMAT)));
tugas.add(task);
if(task.getAlamat() == addr) {
Toast.makeText(konteks, "Anda ada tugas di:\n" + task.getAlamat(), Toast.LENGTH_LONG).show();
} else {
Toast.makeText(konteks, "Anda tidak ada tugas di lokasi sekarang", Toast.LENGTH_LONG).show();
}
} while (curs.moveToNext());
}
closeConn();
return tugas;
}
Nah trus ane masukin di fungsi buat LBS-nya
Spoiler for kode:
public void navigateToLocation(double latitude, double longitude) {
String alamat = "";
GeoPoint p = new GeoPoint((int) (latitude * 1E6), (int) (1E6 * longitude));
userLat = p.getLatitudeE6();
userLon = p.getLongitudeE6();
//menggambar penanda lokasi
List<Overlay> mapOverlay = mapview.getOverlays();
Drawable draw = this.getResources().getDrawable(R.drawable.map_pin);
MapMarker mapMarker = new MapMarker(draw, this);
OverlayItem overlayItem = new OverlayItem(p, "", "Posisi anda sekarang");
mapMarker.AddOverlay(overlayItem);
mapOverlay.add(mapMarker);
alamat = convertToAddress(p);
//tampilkan lokasi pengguna
mapcontrol.animateTo(p);
Toast.makeText(getApplicationContext(),
"Lokasi Anda " + alamat + "\n" + "lat = " + userLat + "\n" + "long = "
+ userLon, Toast.LENGTH_LONG).show();
//cek tugas
dbHandler.postCheck(alamat);
Mohon pencerahannya gan dan sist sekalian...
Trims...