String buildSearchText({
  required NoteType type,
  required String title,
  required String content,
}) {
  switch (type) {
    case NoteType.plain:
      return '$title\n$content';
    case NoteType.markdown:
      return '$title\n${_stripMarkdown(content)}';
    case NoteType.checklist:
      final cl = Checklist.parseContent(content);
      if (cl.items.isEmpty) return title;
      final items = cl.items.map((i) => i.text).join('\n');
      return '$title\n$items';
  }
}

String _stripMarkdown(String s) {
  return s
      // 코드 블록 제거 (```lang ... ```)
      .replaceAll(RegExp(r'```[\s\S]*?```'), ' ')
      // 인라인 코드 — 백틱만 제거, 내부 텍스트는 유지
      .replaceAllMapped(RegExp(r'`([^`]*)`'), (m) => m[1] ?? '')
      // 링크 — [라벨](url) → 라벨만 남김
      .replaceAllMapped(
          RegExp(r'\[([^\]]*)\]\(([^)]*)\)'), (m) => m[1] ?? '')
      // 강조/헤딩/인용/취소선 마커 제거
      .replaceAll(RegExp(r'[*_~#>]+'), '');
}

// content: {"items":[{"id":"1","text":"우유 사기","checked":false,"order":0}, ...]}
// → search_text: "장보기 목록\n우유 사기\n계란 사기\n식빵 사기"

@override
MigrationStrategy get migration => MigrationStrategy(
  onCreate: (m) async {
    await m.createAll();
    await _createFtsAndTriggers(this);
  },
  onUpgrade: (m, from, to) async {
    if (from == 1) {
      await m.addColumn(notes, notes.type);
      await m.addColumn(notes, notes.searchText);
      await customStatement(
        "UPDATE notes SET search_text = title || x'0a' || content",
      );
      await _createFtsAndTriggers(this);
    }
  },
);

@override
Future<List<Note>> search(String query) async {
  final trimmed = query.trim();
  if (trimmed.isEmpty) return const [];

  // 공백으로 분리 → 각 단어를 따옴표로 감쌈 → 공백으로 합침 (AND 의미)
  final escaped = trimmed
      .split(RegExp(r'\s+'))
      .where((w) => w.isNotEmpty)
      .map((w) => '"${w.replaceAll('"', '""')}"')
      .join(' ');

  final rows = await _db.customSelect(
    'SELECT notes.* FROM notes '
    'INNER JOIN notes_fts ON notes_fts.id = notes.id '
    'WHERE notes_fts MATCH ? '
    'ORDER BY notes.updated_at DESC',
    variables: [Variable.withString(escaped)],
    readsFrom: {_db.notes},
  ).get();

  return rows.map((r) => _fromRawRow(r.data)).toList();
}

@override
Future<void> save(Note note) async {
  final searchText = buildSearchText(
    type: note.type,
    title: note.title,
    content: note.content,
  );
  await _db.into(_db.notes).insertOnConflictUpdate(
    NotesCompanion(
      // ...
      searchText: Value(searchText),
      // ...
    ),
  );
}

@riverpod
class SearchController extends _$SearchController {
  Timer? _debounce;
  bool _disposed = false;
  static const _debounceDuration = Duration(milliseconds: 300);

  @override
  AsyncValue<List<Note>> build() {
    ref.onDispose(() {
      _disposed = true;
      _debounce?.cancel();
    });
    return const AsyncData(<Note>[]);
  }

  void query(String raw) {
    _debounce?.cancel();
    final trimmed = raw.trim();
    if (trimmed.isEmpty) {
      state = const AsyncData(<Note>[]);
      return;
    }
    state = const AsyncLoading();
    _debounce = Timer(_debounceDuration, () => _run(trimmed));
  }

  Future<void> _run(String trimmed) async {
    try {
      final repo = ref.read(noteRepositoryProvider);
      final results = await repo.search(trimmed);
      if (_disposed) return;
      state = AsyncData(results);
    } catch (err, st) {
      if (_disposed) return;
      state = AsyncError(err, st);
    }
  }
}

class SearchScreen extends ConsumerStatefulWidget {
  const SearchScreen({super.key});

  @override
  ConsumerState<SearchScreen> createState() => _SearchScreenState();
}

class _SearchScreenState extends ConsumerState<SearchScreen> {
  final _ctrl = TextEditingController();

  @override
  Widget build(BuildContext context) {
    final state = ref.watch(searchControllerProvider);

    return Scaffold(
      appBar: AppBar(
        title: TextField(
          controller: _ctrl,
          autofocus: true,
          decoration: const InputDecoration(
            hintText: '제목 또는 본문 검색',
            border: InputBorder.none,
          ),
          onChanged: (v) =>
              ref.read(searchControllerProvider.notifier).query(v),
        ),
        actions: [
          IconButton(
            tooltip: '지우기',
            icon: const Icon(Icons.clear),
            onPressed: () {
              _ctrl.clear();
              ref.read(searchControllerProvider.notifier).query('');
            },
          ),
        ],
      ),
      body: state.when(
        loading: () => const Center(child: CircularProgressIndicator()),
        error: (e, _) => Center(child: Text('오류: $e')),
        data: (results) {
          if (_ctrl.text.trim().isEmpty) {
            return const _SearchEmptyState();
          }
          if (results.isEmpty) {
            return const _NoResults();
          }
          return ListView.builder(
            itemCount: results.length,
            itemBuilder: (context, i) => _ResultTile(note: results[i]),
          );
        },
      ),
    );
  }
}