public void deleteCategoryById(long id) {
if (id > 0) {
CategoryTree tree = loadCategories();
LongSparseArray<Category> map = tree.asIdMap();
Category category = map.get(id);
if (category != null) {
Category parent = category.parent;
if (parent == null) {
tree.removeRoot(category);
} else {
parent.removeChild(category);
}
saveCategories(tree);
}
}
}
public void saveCategory(Category newCategory) {
CategoryTree tree = loadCategories();
if (newCategory.id > 0) {
LongSparseArray<Category> map = tree.asIdMap();
Category oldCategory = map.get(newCategory.id);
if (oldCategory != null) {
oldCategory.title = newCategory.title;
Category oldParent = map.get(oldCategory.parentId);
Category newParent = map.get(newCategory.parentId);
if (newParent != oldParent) {
if (oldParent != null) {
oldParent.removeChild(oldCategory);
} else {
tree.removeRoot(oldCategory);
}
if (newParent != null) {
newParent.addChild(oldCategory);
} else {
tree.addRoot(oldCategory);
}
}
}
} else {
if (newCategory.parentId > 0) {
LongSparseArray<Category> map = tree.asIdMap();
Category parent = map.get(newCategory.parentId);
if (parent != null) {
parent.addChild(newCategory);
}
} else {
tree.addRoot(newCategory);
}
}
saveCategories(tree);
}
public void saveCategories(CategoryTree tree) {
tree.reIndex();
saveCategoriesInTransaction(tree);
}
public CategoryTree loadCategories() {
List<Category> categories =
db.createQuery(Category.class).where(Expressions.gt("id", 0)).asc("left").list();
CategoryTree tree = CategoryTree.createFromList(categories);
return tree;
}
public void insertInTransaction(CategoryTree tree) {
db.db().delete("category", null, null);
db.reInsertCategory(Category.splitCategory(context));
db.reInsertCategory(Category.noCategory(context));
insertInTransaction(tree.getRoot().children);
}