public int hapusRenunganBerwaktuSentuhSebelum(Date date) {
SQLiteDatabase db = helper.getWritableDatabase();
return db.delete(
Db.TABEL_Renungan,
Db.Renungan.waktuSentuh + "<?",
new String[] {String.valueOf(Sqlitil.toInt(date))}); // $NON-NLS-1$
}
/** @return null when not found */
public TLongList listLabelIds(long bukmak2_id) {
TLongList res = null;
Cursor cursor =
helper
.getReadableDatabase()
.rawQuery(
"select "
+ Db.TABEL_Bukmak2_Label
+ "."
+ Db.Bukmak2_Label.label_id
+ " from "
+ Db.TABEL_Bukmak2_Label
+ " where "
+ Db.TABEL_Bukmak2_Label
+ "."
+ Db.Bukmak2_Label.bukmak2_id
+ "=?",
new String[] {
String.valueOf(bukmak2_id)
}); //$NON-NLS-1$//$NON-NLS-2$//$NON-NLS-3$//$NON-NLS-4$//$NON-NLS-5$//$NON-NLS-6$
try {
int col_label_id = cursor.getColumnIndexOrThrow(Db.Bukmak2_Label.label_id);
while (cursor.moveToNext()) {
if (res == null) res = new TLongArrayList();
res.add(cursor.getLong(col_label_id));
}
} finally {
cursor.close();
}
return res;
}
public void hapusBukmakByAri(int ari, int jenis) {
SQLiteDatabase db = helper.getWritableDatabase();
db.beginTransaction();
try {
long _id;
SQLiteStatement stmt =
db.compileStatement(
"select _id from "
+ Db.TABEL_Bukmak2
+ " where "
+ Db.Bukmak2.jenis
+ "=? and "
+ Db.Bukmak2.ari
+ "=?"); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
try {
stmt.bindLong(1, jenis);
stmt.bindLong(2, ari);
_id = stmt.simpleQueryForLong();
} finally {
stmt.close();
}
String[] params = {String.valueOf(_id)};
db.delete(Db.TABEL_Bukmak2_Label, Db.Bukmak2_Label.bukmak2_id + "=?", params); // $NON-NLS-1$
db.delete(Db.TABEL_Bukmak2, "_id=?", params); // $NON-NLS-1$
db.setTransactionSuccessful();
} finally {
db.endTransaction();
}
}
public int getWarnaRgbStabilo(int ari) {
// cek dulu ada ato ga
Cursor c =
helper
.getReadableDatabase()
.query(
Db.TABEL_Bukmak2,
null,
Db.Bukmak2.ari + "=? and " + Db.Bukmak2.jenis + "=?",
new String[] {String.valueOf(ari), String.valueOf(Db.Bukmak2.jenis_stabilo)},
null,
null,
null); //$NON-NLS-1$ //$NON-NLS-2$
try {
if (c.moveToNext()) {
// sudah ada!
Bookmark2 bukmak = Bookmark2.dariCursor(c);
return U.decodeHighlight(bukmak.tulisan);
} else {
return -1;
}
} finally {
c.close();
}
}
public int updateBukmak(Bookmark2 bukmak) {
return helper
.getWritableDatabase()
.update(
Db.TABEL_Bukmak2,
bukmak.toContentValues(),
"_id=?",
new String[] {String.valueOf(bukmak._id)}); // $NON-NLS-1$
}
/**
* @param map_0 adalah ayat, basis 0
* @return null kalau ga ada warna stabilo, atau int[] kalau ada, sesuai offset map_0.
*/
public int[] putAtribut(int ari_kitabpasal, int[] map_0) {
int ariMin = ari_kitabpasal & 0x00ffff00;
int ariMax = ari_kitabpasal | 0x000000ff;
int[] res = null;
sql_getCatatan_params[0] = String.valueOf(ariMin);
sql_getCatatan_params[1] = String.valueOf(ariMax);
Cursor cursor =
helper
.getReadableDatabase()
.rawQuery(
"select * from "
+ Db.TABEL_Bukmak2
+ " where "
+ Db.Bukmak2.ari
+ ">=? and "
+ Db.Bukmak2.ari
+ "<?",
sql_getCatatan_params); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
try {
int kolom_jenis = cursor.getColumnIndexOrThrow(Db.Bukmak2.jenis);
int kolom_ari = cursor.getColumnIndexOrThrow(Db.Bukmak2.ari);
int kolom_tulisan = cursor.getColumnIndexOrThrow(Db.Bukmak2.tulisan);
while (cursor.moveToNext()) {
int ari = cursor.getInt(kolom_ari);
int jenis = cursor.getInt(kolom_jenis);
int ofsetMap = Ari.toVerse(ari) - 1; // dari basis1 ke basis 0
if (ofsetMap >= map_0.length) {
Log.e(
TAG,
"ofsetMap kebanyakan "
+ ofsetMap
+ " terjadi pada ari 0x"
+ Integer.toHexString(ari)); // $NON-NLS-1$ //$NON-NLS-2$
} else {
if (jenis == Db.Bukmak2.kind_bookmark) {
map_0[ofsetMap] |= 0x1;
} else if (jenis == Db.Bukmak2.kind_note) {
map_0[ofsetMap] |= 0x2;
} else if (jenis == Db.Bukmak2.jenis_stabilo) {
map_0[ofsetMap] |= 0x4;
String tulisan = cursor.getString(kolom_tulisan);
int warnaRgb = U.decodeHighlight(tulisan);
if (res == null) res = new int[map_0.length];
res[ofsetMap] = warnaRgb;
}
}
}
} finally {
cursor.close();
}
return res;
}
public void setEdisiYesAktif(String namafile, boolean aktif) {
SQLiteDatabase db = helper.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(Db.Edisi.aktif, aktif ? 1 : 0);
db.update(
Db.TABEL_Edisi,
cv,
Db.Edisi.jenis + "=? and " + Db.Edisi.namafile + "=?",
new String[] {String.valueOf(Db.Edisi.jenis_yes), namafile}); // $NON-NLS-1$ //$NON-NLS-2$
}
public Label tambahLabel(String judul, String warnaLatar) {
Label res = new Label(-1, judul, getUrutanTerbesarLabel() + 1, warnaLatar);
SQLiteDatabase db = helper.getWritableDatabase();
long _id = db.insert(Db.TABEL_Label, null, res.toContentValues());
if (_id == -1) {
return null;
} else {
res._id = _id;
return res;
}
}
public int getWarnaRgbStabilo(int ariKp, IntArrayList terpilih) {
int ariMin = ariKp;
int ariMax = ariKp | 0xff;
int[] xwarna = new int[256];
int res = -2;
for (int i = 0; i < xwarna.length; i++) xwarna[i] = -1;
// cek dulu ada ato ga
Cursor c =
helper
.getReadableDatabase()
.query(
Db.TABEL_Bukmak2,
null,
Db.Bukmak2.ari + ">? and " + Db.Bukmak2.ari + "<=? and " + Db.Bukmak2.jenis + "=?",
new String[] {
String.valueOf(ariMin),
String.valueOf(ariMax),
String.valueOf(Db.Bukmak2.jenis_stabilo)
},
null,
null,
null); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
try {
int ari_col = c.getColumnIndexOrThrow(Db.Bukmak2.ari);
int tulisan_col = c.getColumnIndexOrThrow(Db.Bukmak2.tulisan);
// masukin aja ke array dulu
while (c.moveToNext()) {
int ari = c.getInt(ari_col);
int index = ari & 0xff;
int warna = U.decodeHighlight(c.getString(tulisan_col));
xwarna[index] = warna;
}
// tentukan warna default. Kalau semua berwarna x, maka jadi x. Kalau ada salah satu yang
// bukan x, jadi -1;
for (int i = 0; i < terpilih.size(); i++) {
int ayat_1 = terpilih.get(i);
int warna = xwarna[ayat_1];
if (res == -2) {
res = warna;
} else if (warna != res) {
return -1;
}
}
if (res == -2) return -1;
return res;
} finally {
c.close();
}
}
public void hapusLabelById(long id) {
SQLiteDatabase db = helper.getWritableDatabase();
db.beginTransaction();
try {
String[] params = new String[] {String.valueOf(id)};
db.delete(Db.TABEL_Bukmak2_Label, Db.Bukmak2_Label.label_id + "=?", params); // $NON-NLS-1$
db.delete(Db.TABEL_Label, "_id=?", params); // $NON-NLS-1$
db.setTransactionSuccessful();
} finally {
db.endTransaction();
}
}
public Bookmark2 insertBukmak(
int ari, int jenis, String tulisan, Date waktuTambah, Date waktuUbah) {
Bookmark2 res = new Bookmark2(ari, jenis, tulisan, waktuTambah, waktuUbah);
SQLiteDatabase db = helper.getWritableDatabase();
long _id = db.insert(Db.TABEL_Bukmak2, null, res.toContentValues());
if (_id == -1) {
return null;
} else {
res._id = _id;
return res;
}
}
public void tambahEdisiYesDenganAktif(MVersionYes edisi, boolean aktif) {
SQLiteDatabase db = helper.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(Db.Edisi.aktif, aktif);
cv.put(Db.Edisi.jenis, Db.Edisi.jenis_yes);
cv.put(Db.Edisi.shortName, edisi.shortName);
cv.put(Db.Edisi.judul, edisi.longName);
cv.put(Db.Edisi.keterangan, edisi.description);
cv.put(Db.Edisi.namafile, edisi.filename);
cv.put(Db.Edisi.namafile_pdbasal, edisi.originalPdbFilename);
cv.put(Db.Edisi.urutan, edisi.ordering);
Log.d(TAG, "tambah edisi yes: " + cv.toString()); // $NON-NLS-1$
db.insert(Db.TABEL_Edisi, null, cv);
}
public int getUrutanTerbesarLabel() {
SQLiteDatabase db = helper.getReadableDatabase();
SQLiteStatement stmt =
db.compileStatement(
"select max("
+ Db.Label.urutan
+ ") from "
+ Db.TABEL_Label); // $NON-NLS-1$//$NON-NLS-2$
try {
return (int) stmt.simpleQueryForLong();
} finally {
stmt.close();
}
}
public int countBukmakDenganLabel(Label label) {
SQLiteDatabase db = helper.getReadableDatabase();
SQLiteStatement stmt =
db.compileStatement(
"select count(*) from "
+ Db.TABEL_Bukmak2_Label
+ " where "
+ Db.Bukmak2_Label.label_id
+ "=?"); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
try {
stmt.bindLong(1, label._id);
return (int) stmt.simpleQueryForLong();
} finally {
stmt.close();
}
}
/** @return null when not found */
public List<Label> listLabels(long bukmak2_id) {
List<Label> res = null;
Cursor cursor =
helper
.getReadableDatabase()
.rawQuery(
"select "
+ Db.TABEL_Label
+ ".* from "
+ Db.TABEL_Label
+ ", "
+ Db.TABEL_Bukmak2_Label
+ " where "
+ Db.TABEL_Bukmak2_Label
+ "."
+ Db.Bukmak2_Label.label_id
+ " = "
+ Db.TABEL_Label
+ "."
+ BaseColumns._ID
+ " and "
+ Db.TABEL_Bukmak2_Label
+ "."
+ Db.Bukmak2_Label.bukmak2_id
+ " = ? order by "
+ Db.TABEL_Label
+ "."
+ Db.Label.urutan
+ " asc",
new String[] {
String.valueOf(bukmak2_id)
}); //$NON-NLS-1$//$NON-NLS-2$//$NON-NLS-3$//$NON-NLS-4$//$NON-NLS-5$//$NON-NLS-6$//$NON-NLS-7$ //$NON-NLS-8$ //$NON-NLS-9$ //$NON-NLS-10$ //$NON-NLS-11$ //$NON-NLS-12$
try {
while (cursor.moveToNext()) {
if (res == null) res = new ArrayList<Label>();
res.add(Label.fromCursor(cursor));
}
} finally {
cursor.close();
}
return res;
}
public boolean adakahEdisiYesDenganNamafile(String namafile) {
SQLiteDatabase db = helper.getReadableDatabase();
SQLiteStatement stmt =
db.compileStatement(
"select count(*) from "
+ Db.TABEL_Edisi
+ " where "
+ Db.Edisi.jenis
+ "=? and "
+ Db.Edisi.namafile
+ "=?"); //$NON-NLS-1$//$NON-NLS-2$//$NON-NLS-3$//$NON-NLS-4$
try {
stmt.clearBindings();
stmt.bindLong(1, Db.Edisi.jenis_yes);
stmt.bindString(2, namafile);
return stmt.simpleQueryForLong() > 0;
} finally {
stmt.close();
}
}
/** Coba ambil artikel dari db lokal. Artikel ga siap pakai pun akan direturn. */
public IArtikel cobaAmbilRenungan(String nama, String tgl) {
Cursor c =
helper
.getReadableDatabase()
.query(
Db.TABEL_Renungan,
null,
Db.Renungan.nama + "=? and " + Db.Renungan.tgl + "=?",
new String[] {nama, tgl},
null,
null,
null); //$NON-NLS-1$ //$NON-NLS-2$
try {
if (c.moveToNext()) {
IArtikel res = null;
if (nama.equals("rh")) { // $NON-NLS-1$
res =
new ArtikelRenunganHarian(
tgl,
c.getString(c.getColumnIndexOrThrow(Db.Renungan.judul)),
c.getString(c.getColumnIndexOrThrow(Db.Renungan.header)),
c.getString(c.getColumnIndexOrThrow(Db.Renungan.isi)),
c.getInt(c.getColumnIndexOrThrow(Db.Renungan.siapPakai)) > 0);
} else if (nama.equals("sh")) { // $NON-NLS-1$
res =
new ArtikelSantapanHarian(
tgl,
c.getString(c.getColumnIndexOrThrow(Db.Renungan.judul)),
c.getString(c.getColumnIndexOrThrow(Db.Renungan.header)),
c.getString(c.getColumnIndexOrThrow(Db.Renungan.isi)),
c.getInt(c.getColumnIndexOrThrow(Db.Renungan.siapPakai)) > 0);
}
return res;
} else {
return null;
}
} finally {
c.close();
}
}
public boolean simpanArtikelKeRenungan(IArtikel artikel) {
boolean res = false;
SQLiteDatabase db = helper.getWritableDatabase();
db.beginTransaction();
try {
// hapus dulu yang lama.
db.delete(
Db.TABEL_Renungan,
Db.Renungan.nama + "=? and " + Db.Renungan.tgl + "=?",
new String[] {artikel.getNama(), artikel.getTgl()}); // $NON-NLS-1$ //$NON-NLS-2$
ContentValues values = new ContentValues();
values.put(Db.Renungan.nama, artikel.getNama());
values.put(Db.Renungan.tgl, artikel.getTgl());
values.put(Db.Renungan.siapPakai, artikel.getSiapPakai() ? 1 : 0);
if (artikel.getSiapPakai()) {
values.put(Db.Renungan.judul, artikel.getJudul().toString());
values.put(Db.Renungan.isi, artikel.getIsiHtml());
values.put(Db.Renungan.header, artikel.getHeaderHtml());
} else {
values.put(Db.Renungan.judul, (String) null);
values.put(Db.Renungan.isi, (String) null);
values.put(Db.Renungan.header, (String) null);
}
values.put(Db.Renungan.waktuSentuh, Sqlitil.nowDateTime());
db.insert(Db.TABEL_Renungan, null, values);
db.setTransactionSuccessful();
res = true;
Log.d(TAG, "TukangDonlot donlot selesai dengan sukses dan uda masuk ke db"); // $NON-NLS-1$
} finally {
db.endTransaction();
}
return res;
}
public Label getLabelById(long labelId) {
SQLiteDatabase db = helper.getReadableDatabase();
Cursor cursor =
db.query(
Db.TABEL_Label,
null,
BaseColumns._ID + "=?",
new String[] {String.valueOf(labelId)},
null,
null,
null); //$NON-NLS-1$
try {
if (cursor.moveToNext()) {
return Label.fromCursor(cursor);
} else {
return null;
}
} finally {
cursor.close();
}
}
public Bookmark2 getBukmakById(long id) {
Cursor cursor =
helper
.getReadableDatabase()
.query(
Db.TABEL_Bukmak2,
null,
"_id=?", //$NON-NLS-1$
new String[] {String.valueOf(id)},
null,
null,
null);
try {
if (!cursor.moveToNext()) return null;
return Bookmark2.dariCursor(cursor);
} finally {
cursor.close();
}
}
public List<MVersionYes> listAllVersions() {
List<MVersionYes> res = new ArrayList<MVersionYes>();
Cursor cursor =
helper
.getReadableDatabase()
.query(
Db.TABEL_Edisi,
null,
null,
null,
null,
null,
Db.Edisi.urutan + " asc"); // $NON-NLS-1$
try {
int col_aktif = cursor.getColumnIndexOrThrow(Db.Edisi.aktif);
int col_shortName = cursor.getColumnIndexOrThrow(Db.Edisi.shortName);
int col_judul = cursor.getColumnIndexOrThrow(Db.Edisi.judul);
int col_keterangan = cursor.getColumnIndexOrThrow(Db.Edisi.keterangan);
int col_namafile = cursor.getColumnIndexOrThrow(Db.Edisi.namafile);
int col_namafile_pdbasal = cursor.getColumnIndexOrThrow(Db.Edisi.namafile_pdbasal);
int col_urutan = cursor.getColumnIndexOrThrow(Db.Edisi.urutan);
while (cursor.moveToNext()) {
MVersionYes yes = new MVersionYes();
yes.cache_active = cursor.getInt(col_aktif) != 0;
yes.type = Db.Edisi.jenis_yes;
yes.description = cursor.getString(col_keterangan);
yes.shortName = cursor.getString(col_shortName);
yes.longName = cursor.getString(col_judul);
yes.filename = cursor.getString(col_namafile);
yes.originalPdbFilename = cursor.getString(col_namafile_pdbasal);
yes.ordering = cursor.getInt(col_urutan);
res.add(yes);
}
} finally {
cursor.close();
}
return res;
}
public List<Label> listSemuaLabel() {
List<Label> res = new ArrayList<Label>();
Cursor cursor =
helper
.getReadableDatabase()
.query(
Db.TABEL_Label,
null,
null,
null,
null,
null,
Db.Label.urutan + " asc"); // $NON-NLS-1$
try {
while (cursor.moveToNext()) {
res.add(Label.fromCursor(cursor));
}
} finally {
cursor.close();
}
return res;
}
public Bookmark2 getBukmakByAri(int ari, int jenis) {
Cursor cursor =
helper
.getReadableDatabase()
.query(
Db.TABEL_Bukmak2,
new String[] {
BaseColumns._ID, Db.Bukmak2.tulisan, Db.Bukmak2.waktuTambah, Db.Bukmak2.waktuUbah
},
Db.Bukmak2.ari + "=? and " + Db.Bukmak2.jenis + "=?", // $NON-NLS-1$ //$NON-NLS-2$
new String[] {String.valueOf(ari), String.valueOf(jenis)},
null,
null,
null);
try {
if (!cursor.moveToNext()) return null;
return Bookmark2.dariCursor(cursor, ari, jenis);
} finally {
cursor.close();
}
}
public void updateLabels(Bookmark2 bukmak, Set<Label> labels) {
SQLiteDatabase db = helper.getWritableDatabase();
db.beginTransaction();
try {
// hapus semua
db.delete(
Db.TABEL_Bukmak2_Label,
Db.Bukmak2_Label.bukmak2_id + "=?",
new String[] {String.valueOf(bukmak._id)}); // $NON-NLS-1$
// tambah semua
ContentValues cv = new ContentValues();
for (Label label : labels) {
cv.put(Db.Bukmak2_Label.bukmak2_id, bukmak._id);
cv.put(Db.Bukmak2_Label.label_id, label._id);
db.insert(Db.TABEL_Bukmak2_Label, null, cv);
}
db.setTransactionSuccessful();
} finally {
db.endTransaction();
}
}
public int countAtribut(int ari_kitabpasal) {
int ariMin = ari_kitabpasal & 0x00ffff00;
int ariMax = ari_kitabpasal | 0x000000ff;
if (stmt_countAtribut == null) {
stmt_countAtribut =
helper
.getReadableDatabase()
.compileStatement(
"select count(*) from "
+ Db.TABEL_Bukmak2
+ " where "
+ Db.Bukmak2.ari
+ ">=? and "
+ Db.Bukmak2.ari
+ "<?"); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
}
stmt_countAtribut.clearBindings();
stmt_countAtribut.bindLong(1, ariMin);
stmt_countAtribut.bindLong(2, ariMax);
return (int) stmt_countAtribut.simpleQueryForLong();
}
public int deleteDevotionsWithLessThanInTitle() {
SQLiteDatabase db = helper.getWritableDatabase();
return db.delete(Db.TABEL_Renungan, Db.Renungan.judul + " like '%<%'", null);
}
public void updateLabel(Label label) {
SQLiteDatabase db = helper.getWritableDatabase();
ContentValues cv = label.toContentValues();
db.update(Db.TABEL_Label, cv, "_id=?", new String[] {String.valueOf(label._id)}); // $NON-NLS-1$
}
public void updateAtauInsertStabilo(int ariKp, IntArrayList ayatTerpilih, int warnaRgb) {
SQLiteDatabase db = helper.getWritableDatabase();
String[] params = {null /* buat ari */, String.valueOf(Db.Bukmak2.jenis_stabilo)};
db.beginTransaction();
try {
// setiap ayat yang diminta
for (int i = 0; i < ayatTerpilih.size(); i++) {
int ayat_1 = ayatTerpilih.get(i);
int ari = Ari.encodeWithKp(ariKp, ayat_1);
params[0] = String.valueOf(ari);
Cursor c =
db.query(
Db.TABEL_Bukmak2,
null,
Db.Bukmak2.ari + "=? and " + Db.Bukmak2.jenis + "=?",
params,
null,
null,
null); //$NON-NLS-1$ //$NON-NLS-2$
try {
if (c.moveToNext()) { // cek dulu ada ato ga
// sudah ada!
Bookmark2 bukmak = Bookmark2.dariCursor(c);
bukmak.waktuUbah = new Date();
if (warnaRgb != -1) {
bukmak.tulisan = U.encodeHighlight(warnaRgb);
db.update(
Db.TABEL_Bukmak2,
bukmak.toContentValues(),
"_id=?",
new String[] {String.valueOf(bukmak._id)}); // $NON-NLS-1$
} else {
// delete
db.delete(
Db.TABEL_Bukmak2,
"_id=?",
new String[] {String.valueOf(bukmak._id)}); // $NON-NLS-1$
}
} else {
// belum ada!
if (warnaRgb == -1) {
// ga usa ngapa2in, dari belum ada jadi tetep ga ada
} else {
Date kini = new Date();
Bookmark2 bukmak =
new Bookmark2(
ari, Db.Bukmak2.jenis_stabilo, U.encodeHighlight(warnaRgb), kini, kini);
db.insert(Db.TABEL_Bukmak2, null, bukmak.toContentValues());
}
}
} finally {
c.close();
}
}
db.setTransactionSuccessful();
} finally {
db.endTransaction();
}
}
public Cursor listSemuaBukmak() {
return helper.getReadableDatabase().query(Db.TABEL_Bukmak2, null, null, null, null, null, null);
}
public void hapusEdisiYes(MVersionYes edisi) {
SQLiteDatabase db = helper.getWritableDatabase();
db.delete(
Db.TABEL_Edisi, Db.Edisi.namafile + "=?", new String[] {edisi.filename}); // $NON-NLS-1$
}
