@Override
public Cursor query(
final Uri uri,
final String[] projection,
final String originalSelection,
final String[] originalSelectionArgs,
final String sortOrder) {
final SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
qb.setTables(DATABASE_TABLE);
final List<String> pathSegments = uri.getPathSegments();
if (pathSegments.size() > 1) throw new IllegalArgumentException(uri.toString());
String selection = null;
String[] selectionArgs = null;
if (pathSegments.size() == 1) {
final String address = uri.getLastPathSegment();
qb.appendWhere(KEY_ADDRESS + "=");
qb.appendWhereEscapeString(address);
} else if (SELECTION_IN.equals(originalSelection)) {
final String[] addresses = originalSelectionArgs[0].trim().split(",");
qb.appendWhere(KEY_ADDRESS + " IN (");
appendAddresses(qb, addresses);
qb.appendWhere(")");
} else if (SELECTION_NOTIN.equals(originalSelection)) {
final String[] addresses = originalSelectionArgs[0].trim().split(",");
qb.appendWhere(KEY_ADDRESS + " NOT IN (");
appendAddresses(qb, addresses);
qb.appendWhere(")");
} else if (SELECTION_QUERY.equals(originalSelection)) {
final String query = '%' + originalSelectionArgs[0].trim() + '%';
selection = KEY_ADDRESS + " LIKE ? OR " + KEY_LABEL + " LIKE ?";
selectionArgs = new String[] {query, query};
}
final Cursor cursor =
qb.query(
helper.getReadableDatabase(),
projection,
selection,
selectionArgs,
null,
null,
sortOrder);
cursor.setNotificationUri(getContext().getContentResolver(), uri);
return cursor;
}
public void ukoncitJizdu(View v) {
setProbihaJizda(false);
// Vyber druhý tab (historie jízd)
tabLayout.getTabAt(1).select();
// Příprava databáze
Helper h = new Helper(this);
SQLiteDatabase rdb = h.getReadableDatabase();
SQLiteDatabase wdb = h.getWritableDatabase();
// Vložit vložit nový záznam s novou jízdou
ContentValues cv = new ContentValues();
cv.put("id_auta", id_auta);
cv.put("od_misto", "");
cv.put("do_misto", "");
cv.put("od_cas", od_cas);
cv.put("do_cas", (int) (System.currentTimeMillis() / 1000L));
cv.put("tankovano", 0);
cv.put("plna_nadrz", 0);
cv.put("litru", 0);
cv.put("soukroma", 0);
try {
id_jizdy = (int) wdb.insertOrThrow("jizdy", null, cv);
} catch (SQLException e) {
Log.d("Výjimka", e.getMessage());
}
Log.d("idecko", String.valueOf(id_jizdy));
wdb.close();
rdb.close();
// Otevři příslušný detail jízdy
DetailJizdyFragment df = new DetailJizdyFragment();
Bundle args = new Bundle();
args.putInt("id_jizdy", id_jizdy);
df.setArguments(args);
df.show(getSupportFragmentManager(), "detail_jizdy");
}
