From dedda31d064ddcb4f857f2db851c5a8c1e19deba Mon Sep 17 00:00:00 2001
From: Peter Stone <thepeterstone@gmail.com>
Date: Sun, 25 Jan 2026 17:05:49 -1000
Subject: Implement architectural refactors for feature requests #28, #30, #31,
 #33-38

Phase 1: Bugs as First-Class Atoms (#28)
- Add resolved_at column to bugs table (migration 007)
- Add GetUnresolvedBugs(), ResolveBug(), UnresolveBug() store methods
- Include bugs in Tasks tab via BugToAtom() with completion toggle
- Add unit tests for bug resolution

Phase 2: Timeline as Default + Enhancements (#35, #37)
- Change default tab from tasks to timeline
- Add IsCompleted, DaySection, Source fields to TimelineItem
- Group timeline items by today/tomorrow/later sections
- Add completion checkboxes for tasks/cards, grey completed items
- Collapse tomorrow/later sections by default

Phase 3: Shopping Quick-Add (#33)
- Add user_shopping_items table (migration 008)
- Add SaveUserShoppingItem(), GetUserShoppingItems(), ToggleUserShoppingItem()
- Add HandleShoppingQuickAdd() and HandleShoppingToggle() handlers
- Add quick-add form to shopping tab

Phase 4: Mobile Swipe Navigation (#38)
- Add touch event handlers for swipe left/right tab switching
- 50px threshold triggers tab change

Phase 5: Consistent Background Opacity (#30)
- Add CSS variables for panel/card/input/modal backgrounds
- Update templates to use consistent opacity classes

Phase 6: Tab Reorganization (#37)
- Reorganize tabs: Timeline, Shopping, Conditions as main tabs
- Move Tasks, Planning, Meals under Details dropdown

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
---
 internal/store/sqlite.go | 84 +++++++++++++++++++++++++++++++++++++++++++++++-
 1 file changed, 83 insertions(+), 1 deletion(-)

(limited to 'internal/store/sqlite.go')

diff --git a/internal/store/sqlite.go b/internal/store/sqlite.go
index 5b67234..5b95607 100644
--- a/internal/store/sqlite.go
+++ b/internal/store/sqlite.go
@@ -569,6 +569,7 @@ type Bug struct {
 	ID          int64
 	Description string
 	CreatedAt   time.Time
+	ResolvedAt  *time.Time
 }
 
 // SaveBug saves a new bug report
@@ -579,7 +580,30 @@ func (s *Store) SaveBug(description string) error {
 
 // GetBugs retrieves all bugs, newest first
 func (s *Store) GetBugs() ([]Bug, error) {
-	rows, err := s.db.Query(`SELECT id, description, created_at FROM bugs ORDER BY created_at DESC`)
+	rows, err := s.db.Query(`SELECT id, description, created_at, resolved_at FROM bugs ORDER BY created_at DESC`)
+	if err != nil {
+		return nil, err
+	}
+	defer rows.Close()
+
+	var bugs []Bug
+	for rows.Next() {
+		var b Bug
+		var resolvedAt sql.NullTime
+		if err := rows.Scan(&b.ID, &b.Description, &b.CreatedAt, &resolvedAt); err != nil {
+			return nil, err
+		}
+		if resolvedAt.Valid {
+			b.ResolvedAt = &resolvedAt.Time
+		}
+		bugs = append(bugs, b)
+	}
+	return bugs, rows.Err()
+}
+
+// GetUnresolvedBugs retrieves bugs that haven't been resolved yet
+func (s *Store) GetUnresolvedBugs() ([]Bug, error) {
+	rows, err := s.db.Query(`SELECT id, description, created_at FROM bugs WHERE resolved_at IS NULL ORDER BY created_at DESC`)
 	if err != nil {
 		return nil, err
 	}
@@ -596,6 +620,64 @@ func (s *Store) GetBugs() ([]Bug, error) {
 	return bugs, rows.Err()
 }
 
+// ResolveBug marks a bug as resolved
+func (s *Store) ResolveBug(id int64) error {
+	_, err := s.db.Exec(`UPDATE bugs SET resolved_at = CURRENT_TIMESTAMP WHERE id = ?`, id)
+	return err
+}
+
+// UnresolveBug marks a bug as unresolved (reopens it)
+func (s *Store) UnresolveBug(id int64) error {
+	_, err := s.db.Exec(`UPDATE bugs SET resolved_at = NULL WHERE id = ?`, id)
+	return err
+}
+
+// UserShoppingItem represents a user-added shopping item
+type UserShoppingItem struct {
+	ID        int64
+	Name      string
+	Store     string
+	Checked   bool
+	CreatedAt time.Time
+}
+
+// SaveUserShoppingItem saves a new user shopping item
+func (s *Store) SaveUserShoppingItem(name, store string) error {
+	_, err := s.db.Exec(`INSERT INTO user_shopping_items (name, store) VALUES (?, ?)`, name, store)
+	return err
+}
+
+// GetUserShoppingItems retrieves all user shopping items
+func (s *Store) GetUserShoppingItems() ([]UserShoppingItem, error) {
+	rows, err := s.db.Query(`SELECT id, name, store, checked, created_at FROM user_shopping_items ORDER BY store, created_at DESC`)
+	if err != nil {
+		return nil, err
+	}
+	defer rows.Close()
+
+	var items []UserShoppingItem
+	for rows.Next() {
+		var item UserShoppingItem
+		if err := rows.Scan(&item.ID, &item.Name, &item.Store, &item.Checked, &item.CreatedAt); err != nil {
+			return nil, err
+		}
+		items = append(items, item)
+	}
+	return items, rows.Err()
+}
+
+// ToggleUserShoppingItem toggles the checked state of a user shopping item
+func (s *Store) ToggleUserShoppingItem(id int64, checked bool) error {
+	_, err := s.db.Exec(`UPDATE user_shopping_items SET checked = ? WHERE id = ?`, checked, id)
+	return err
+}
+
+// DeleteUserShoppingItem removes a user shopping item
+func (s *Store) DeleteUserShoppingItem(id int64) error {
+	_, err := s.db.Exec(`DELETE FROM user_shopping_items WHERE id = ?`, id)
+	return err
+}
+
 // GetTasksByDateRange retrieves tasks due within a specific date range
 func (s *Store) GetTasksByDateRange(start, end time.Time) ([]models.Task, error) {
 	rows, err := s.db.Query(`
-- 
cgit v1.2.3