+ public List<LedgerAccount> loadChildAccountsOf(LedgerAccount acc) {
+ List<LedgerAccount> result = new ArrayList<>();
+ SQLiteDatabase db = MLDB.getDatabase();
+ try (Cursor c = db.rawQuery(
+ "SELECT a.name FROM accounts a WHERE a.profile = ? and a.name like ?||':%'",
+ new String[]{uuid, acc.getName()}))
+ {
+ while (c.moveToNext()) {
+ LedgerAccount a = loadAccount(db, c.getString(0));
+ result.add(a);
+ }
+ }
+
+ return result;
+ }
+ public List<LedgerAccount> loadVisibleChildAccountsOf(LedgerAccount acc) {
+ List<LedgerAccount> result = new ArrayList<>();
+ ArrayList<LedgerAccount> visibleList = new ArrayList<>();
+ visibleList.add(acc);
+
+ SQLiteDatabase db = MLDB.getDatabase();
+ try (Cursor c = db.rawQuery(
+ "SELECT a.name FROM accounts a WHERE a.profile = ? and a.name like ?||':%'",
+ new String[]{uuid, acc.getName()}))
+ {
+ while (c.moveToNext()) {
+ LedgerAccount a = loadAccount(db, c.getString(0));
+ if (a.isVisible(visibleList)) {
+ result.add(a);
+ visibleList.add(a);
+ }
+ }
+ }
+
+ return result;
+ }