Problem: Loading all orders at once (even filtered by status) can become slow as the database grows. Currently there is no LIMIT or OFFSET on any order list query.
Solution: Add pagination with LIMIT + OFFSET to order queries, with a "Karre tan" button at the bottom of the LazyColumn.
Scope:
- Add DAO queries:
getOrdersWithCakesByStatusPaged(status, limit, offset)
- Expose in OrderRepository
- Add page tracking state to OrderViewModel/OrderUiState (
currentPage, hasMore, isLoadingMore)
- Add "Karre tan" button at the bottom of OrderListScreen's LazyColumn
- Handle loading more on tap
- No schema changes needed
Note: Can be implemented independently or combined with Option A (date range filter).
Problem: Loading all orders at once (even filtered by status) can become slow as the database grows. Currently there is no LIMIT or OFFSET on any order list query.
Solution: Add pagination with LIMIT + OFFSET to order queries, with a "Karre tan" button at the bottom of the LazyColumn.
Scope:
getOrdersWithCakesByStatusPaged(status, limit, offset)currentPage,hasMore,isLoadingMore)Note: Can be implemented independently or combined with Option A (date range filter).