From a1fa857a2f5ab163ffe5abbdeeb0eba8fc9508e9 Mon Sep 17 00:00:00 2001
From: Peter Stone <thepeterstone@gmail.com>
Date: Tue, 13 Jan 2026 13:36:09 -1000
Subject: Implement Phase 2 Steps 3-5: Sorting and Search improvements

Step 3 - Trello Smart Sorting:
- Update GetBoards SQL with LEFT JOIN and MAX(c.id) for activity sorting
- Update GetBoardsWithCards to find max card ID per board
- Sort by: 1) Has cards, 2) Newest card activity, 3) Board name
- Trello IDs are chronologically sortable (newer > older)

Step 4 - Todoist Due-First Sorting:
- Update GetTasks ORDER BY with CASE WHEN due_date IS NULL
- Sort by: 1) Incomplete, 2) Has due date, 3) Earliest date, 4) Priority
- Tasks with due dates appear before tasks without due dates

Step 5 - Obsidian Search:
- Add SearchNotes method with LIKE queries on title/content
- Update HandleNotes to check 'q' query param and HX-Target header
- Implement smart partial rendering (obsidian-notes vs notes-tab)
- Add search input with 300ms debounce and HTMX integration
- Real-time search without page reload

Mark Steps 1-5 as complete in PHASE_2_SURGICAL_PLAN.md
All tests passing

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

(limited to 'internal/store')

diff --git a/internal/store/sqlite.go b/internal/store/sqlite.go
index fa8f2b1..c97d0af 100644
--- a/internal/store/sqlite.go
+++ b/internal/store/sqlite.go
@@ -126,7 +126,7 @@ func (s *Store) GetTasks() ([]models.Task, error) {
 	rows, err := s.db.Query(`
 		SELECT id, content, description, project_id, project_name, due_date, priority, completed, labels, url, created_at
 		FROM tasks
-		ORDER BY completed ASC, due_date ASC, priority DESC
+		ORDER BY completed ASC, CASE WHEN due_date IS NULL THEN 1 ELSE 0 END, due_date ASC, priority DESC
 	`)
 	if err != nil {
 		return nil, err
@@ -248,6 +248,44 @@ func (s *Store) GetNotes(limit int) ([]models.Note, error) {
 	return notes, rows.Err()
 }
 
+// SearchNotes searches notes by title or content
+func (s *Store) SearchNotes(query string) ([]models.Note, error) {
+	searchPattern := "%" + query + "%"
+	rows, err := s.db.Query(`
+		SELECT filename, title, content, modified, path, tags
+		FROM notes
+		WHERE title LIKE ? OR content LIKE ?
+		ORDER BY modified DESC
+	`, searchPattern, searchPattern)
+	if err != nil {
+		return nil, err
+	}
+	defer rows.Close()
+
+	var notes []models.Note
+	for rows.Next() {
+		var note models.Note
+		var tagsJSON string
+
+		err := rows.Scan(
+			&note.Filename,
+			&note.Title,
+			&note.Content,
+			&note.Modified,
+			&note.Path,
+			&tagsJSON,
+		)
+		if err != nil {
+			return nil, err
+		}
+
+		json.Unmarshal([]byte(tagsJSON), &note.Tags)
+		notes = append(notes, note)
+	}
+
+	return notes, rows.Err()
+}
+
 // Meals operations
 
 // SaveMeals saves multiple meals to the database
-- 
cgit v1.2.3