<%- include('../partials/header') %>

<%
function fmtDateRo(v) {
  if (!v) return '-';
  const d = new Date(v);
  if (isNaN(d.getTime())) return v;
  const p = n => String(n).padStart(2,'0');
  return `${p(d.getDate())}.${p(d.getMonth()+1)}.${d.getFullYear()} ${p(d.getHours())}:${p(d.getMinutes())}`;
}
%>


<form class="toolbar" method="get">
  <input name="q" value="<%= q %>" placeholder="SKU / denumire / categorie">
  <select name="page_size" style="width:auto">
    <% [20,50,100,200].forEach(n => { %>
      <option value="<%= n %>" <%= pageSize===n?'selected':'' %>><%= n %>/pagină</option>
    <% }) %>
  </select>
  <button class="btn">Caută</button>
</form>

<div class="card">
<table>
<thead><tr>
<th></th>
<%
const cols=[
  ['sku','SKU'],['name','Produs'],['category','Categorie'],['price','Preț'],
  ['stock','Stoc'],['sold_qty','Vândute'],['order_count','Comenzi'],['last_sold_at','Ultima vânzare']
];
cols.forEach(c => {
  const nd=(sort===c[0] && dir==='asc')?'desc':'asc';
%>
<th>
<a href="?q=<%= encodeURIComponent(q) %>&page_size=<%= pageSize %>&sort=<%= c[0] %>&dir=<%= nd %>">
<%= c[1] %> <%= sort===c[0] ? (dir==='asc'?'▲':'▼') : '' %>
</a>
</th>
<% }) %>
</tr></thead>
<tbody>
<% products.forEach(p => { %>
<tr>
<td>
  <% if (p.display_image_url) { %>
    <img
      class="thumb"
      src="<%= p.display_image_url %>"
      alt="<%= p.name || p.sku %>"
      loading="lazy"
      onerror="this.style.visibility='hidden'"
    >
  <% } %>
</td>
<td><%= p.sku %></td>
<td><%= p.name %></td>
<td><%= p.category || '-' %></td>
<td><%= Number(p.price || 0).toFixed(2) %></td>
<td><%= p.stock %></td>
<td><strong><%= p.sold_qty || 0 %></strong></td>
<td><%= p.order_count || 0 %></td>
<td><%= fmtDateRo(p.last_sold_at) %></td>
</tr>
<% }) %>
</tbody>
</table>

<div class="toolbar" style="margin-top:15px">
<span><strong><%= total %></strong> produse</span>
<% if (page>1) { %>
<a class="btn" href="?q=<%= encodeURIComponent(q) %>&page_size=<%= pageSize %>&sort=<%= sort %>&dir=<%= dir %>&page=1">« Prima</a>
<a class="btn" href="?q=<%= encodeURIComponent(q) %>&page_size=<%= pageSize %>&sort=<%= sort %>&dir=<%= dir %>&page=<%= page-1 %>">← Înapoi</a>
<% } %>
<span>Pagina <strong><%= page %></strong> / <%= totalPages %></span>
<% if (page<totalPages) { %>
<a class="btn" href="?q=<%= encodeURIComponent(q) %>&page_size=<%= pageSize %>&sort=<%= sort %>&dir=<%= dir %>&page=<%= page+1 %>">Înainte →</a>
<a class="btn" href="?q=<%= encodeURIComponent(q) %>&page_size=<%= pageSize %>&sort=<%= sort %>&dir=<%= dir %>&page=<%= totalPages %>">Ultima »</a>
<% } %>
</div>
</div>

<%- include('../partials/footer') %>
