diff --git a/app/src/main/java/de/apps4ics/mountainnavigation/DatabaseHandler.java b/app/src/main/java/de/apps4ics/mountainnavigation/DatabaseHandler.java index f407725..5fa77bf 100644 --- a/app/src/main/java/de/apps4ics/mountainnavigation/DatabaseHandler.java +++ b/app/src/main/java/de/apps4ics/mountainnavigation/DatabaseHandler.java @@ -156,6 +156,32 @@ new String[]{String.valueOf(poi.getId())}); } + public List getPoiByType(int _type){ + List poiList = new ArrayList<>(); + SQLiteDatabase db = this.getReadableDatabase(); + Cursor cursor = db.query(TABLE_POI, + new String[]{KEY_POI_ID, KEY_POI_LAT, KEY_POI_LON, KEY_POI_ALT, KEY_POI_TYPE, KEY_POI_TIME, KEY_POI_EXT_POI_ID}, + KEY_POI_TYPE + "=?", + new String[]{String.valueOf(_type)}, null, null, null, null); + if(cursor.moveToFirst()){ + do { + int _id = Integer.parseInt(cursor.getString(0)); + double _lat = Double.parseDouble(cursor.getString(1)); + double _lon = Double.parseDouble(cursor.getString(2)); + double _alt = Double.parseDouble(cursor.getString(3)); + //int _type = Integer.parseInt(cursor.getString(4)); + long _time = Long.parseLong(cursor.getString(5)); + int _ext_poi_id = Integer.parseInt(cursor.getString(6)); + poiList.add(new Poi(_id, _lat, _lon, _alt, _type, _time, _ext_poi_id)); + } while(cursor.moveToNext()); + } + + db.close(); + cursor.close(); + + return poiList; + } + public void addPoiOptions(long _poi_id, int... options){ SQLiteDatabase db = this.getWritableDatabase(); for(int i=0; i