{% extends "base.html" %}
{% block title %}Deleted & Carved — chat4n6{% endblock %}
{% block content %}
<h2>Deleted & Carved Messages</h2>
<p>Messages recovered from freelist, WAL, FTS shadow tables, or unallocated space.</p>
<div class="search-bar">
  <input type="text" id="del-search" placeholder="Search deleted messages..." onkeyup="filterDeleted()">
</div>
<table id="del-table">
<tr><th>Chat</th><th>Timestamp</th><th>Dir</th><th>Content</th><th>Source</th></tr>
{% for msg in deleted_messages %}
<tr>
  <td>{{ msg.chat_id }}</td>
  <td>{{ msg.timestamp_utc }}</td>
  <td>{% if msg.from_me %}Out{% else %}In{% endif %}</td>
  <td>{{ msg.content }}</td>
  <td><span class="badge badge-{{ msg.source_class }}">{{ msg.source }}</span></td>
</tr>
{% endfor %}
</table>
<script>
function filterDeleted(){var f=document.getElementById('del-search').value.toLowerCase();var rows=document.getElementById('del-table').getElementsByTagName('tr');for(var i=1;i<rows.length;i++){rows[i].style.display=rows[i].textContent.toLowerCase().indexOf(f)>-1?'':'none';}}
</script>

{% if wal_deltas %}
<h2>WAL Delta Records</h2>
<p>Schema changes detected between WAL frames and the main database file.</p>
<table id="wal-delta-table">
<tr><th>Table</th><th>Row ID</th><th>Status</th></tr>
{% for w in wal_deltas %}
<tr class="wal-delta">
  <td>{{ w.table }}</td>
  <td>{{ w.row_id }}</td>
  <td><span class="badge badge-wal-pending">{{ w.status }}</span></td>
</tr>
{% endfor %}
</table>
{% endif %}
{% endblock %}