<?php
require_once __DIR__ . '/inc/layout.php';
require_once __DIR__ . '/inc/report.php';

header('Cache-Control: no-store, no-cache, must-revalidate, max-age=0');
header('Pragma: no-cache');
header('Expires: 0');

// The cache-buster redirect must not swallow bulk-edit POSTs.
cache_buster_redirect();

// Fallback scheduler for the daily email report: if one is due and no cron
// job fired it, the first inventory view of the day sends it.
maybe_send_daily_report();

if ($_SERVER['REQUEST_METHOD'] === 'POST' && ($_POST['action'] ?? '') === 'bulk') {
    require_login();
    check_csrf();

    $ids = array_values(array_filter(array_map('intval', (array)($_POST['ids'] ?? []))));

    // Only fields the user actually filled in become part of the UPDATE;
    // everything left at "keep" is untouched on the selected spools.
    $set = [];
    $vals = [];
    $type = trim((string)($_POST['type'] ?? ''));
    if ($type !== '') {
        $set[] = 'type=?';
        $vals[] = $type;
    }
    $brand = trim((string)($_POST['brand'] ?? ''));
    if ($brand !== '') {
        $set[] = 'brand=?';
        $vals[] = $brand;
    }
    $cost = trim((string)($_POST['cost'] ?? ''));
    if ($cost !== '') {
        $set[] = 'cost=?';
        $vals[] = (float)$cost;
    }
    if (isset($_POST['set_color']) && preg_match('/^#[0-9a-fA-F]{6}$/', (string)($_POST['color_hex'] ?? ''))) {
        $set[] = 'color_hex=?';
        $vals[] = (string)$_POST['color_hex'];
    }
    foreach (['abrasive', 'highflow', 'silk', 'matte', 'rainbow', 'transparent', 'twotone', 'sparkle'] as $flag) {
        $v = (string)($_POST['f_' . $flag] ?? '');
        if ($v === '0' || $v === '1') {
            $set[] = "$flag=?";
            $vals[] = (int)$v;
        }
    }

    if (!$ids) {
        flash('Select at least one spool to bulk edit.');
        header('Location: index.php?bulk=1');
        exit;
    }
    if (!$set) {
        flash('Set at least one field to change.');
        header('Location: index.php?bulk=1');
        exit;
    }

    $ph = implode(',', array_fill(0, count($ids), '?'));
    backup_db();
    db()->prepare(
        'UPDATE filaments SET ' . implode(', ', $set) . ", updated_at=datetime('now') WHERE id IN ($ph)"
    )->execute(array_merge($vals, $ids));
    flash('Updated ' . count($ids) . ' spool' . (count($ids) === 1 ? '' : 's') . '.');
    header('Location: index.php');
    exit;
}

if (!is_logged_in() && !config()['public_view']) {
    header('Location: login.php');
    exit;
}

// hex_hsl(), hue_key(), pie_color() and spool_pct() live in inc/layout.php —
// use.php renders the same swatch.

$sorts = [
    'used'  => '(last_used_at IS NULL), last_used_at DESC, brand COLLATE NOCASE, type COLLATE NOCASE',
    'type'  => 'type COLLATE NOCASE, color_name COLLATE NOCASE, brand COLLATE NOCASE',
    'color' => 'id', // real ordering happens in PHP below (hue needs math SQLite can't do)
    'name'  => "(color_name IS NULL OR color_name = ''), color_name COLLATE NOCASE, brand COLLATE NOCASE",
    'brand' => "(brand IS NULL OR brand = ''), brand COLLATE NOCASE, type COLLATE NOCASE",
    'left'  => 'remaining_g DESC, type COLLATE NOCASE',
    'added' => 'created_at DESC, id DESC',
];
$sortLabels = [
    'used'  => 'Recently used', 'type' => 'Type', 'color' => 'Color', 'name' => 'Color name',
    'brand' => 'Manufacturer', 'left' => 'Amount left', 'added' => 'Recently added',
];

$sort = $_GET['sort'] ?? $_SESSION['sort'] ?? 'used';
if (!is_string($sort) || !isset($sorts[$sort])) {
    $sort = 'used';
}
$_SESSION['sort'] = $sort;

// List or color-grid view, remembered in the session like the sort.
$view = $_GET['view'] ?? $_SESSION['view'] ?? 'list';
if (!is_string($view) || !in_array($view, ['list', 'grid'], true)) {
    $view = 'list';
}
$_SESSION['view'] = $view;

$rows = db()->query('SELECT * FROM filaments ORDER BY ' . $sorts[$sort])->fetchAll();
if ($sort === 'color') {
    // Rainbow spools have no single hue — group them ahead of the hue wheel.
    $colorKey = fn(array $r) => !empty($r['rainbow']) ? [-1, 0.0, 0.0] : hue_key($r['color_hex']);
    usort($rows, fn($a, $b) => $colorKey($a) <=> $colorKey($b));
}

$cur = config()['currency'];

// ---- filters: AND across the groups, OR within a group ----
$flagDefs = ['abrasive' => 'Abrasive', 'highflow' => 'High-flow', 'silk' => 'Silk', 'matte' => 'Matte',
             'rainbow' => 'Rainbow', 'twotone' => 'Two-tone', 'transparent' => 'Clear', 'sparkle' => 'Sparkle'];
$remDefs  = ['full' => 'Nearly full (85%+)', 'partial' => 'Partly used', 'low' => 'Low (under 15%)'];

$clean   = fn($v) => array_values(array_unique(array_filter((array)$v, fn($s) => is_string($s) && $s !== '')));
$lc      = fn(?string $s) => mb_strtolower(trim((string)$s));
$fTypes  = $clean($_GET['ft'] ?? []);
$fBrands = $clean($_GET['fb'] ?? []);
$fBrandKeys = array_map($lc, $fBrands);
$fRem    = array_values(array_intersect(array_keys($remDefs), $clean($_GET['fr'] ?? [])));
$fProps  = array_values(array_intersect(array_keys($flagDefs), $clean($_GET['fp'] ?? [])));
$q       = trim((string)($_GET['q'] ?? ''));
$nFilters = count($fTypes) + count($fBrands) + count($fRem) + count($fProps) + ($q !== '' ? 1 : 0);
$filterOpen = isset($_GET['filter']) || $nFilters > 0;

$allCount = count($rows);
if ($nFilters) {
    $rows = array_values(array_filter($rows, function (array $r) use ($fTypes, $fBrandKeys, $fRem, $fProps, $q, $lc) {
        if ($fTypes && !in_array($r['type'], $fTypes, true)) {
            return false;
        }
        if ($fBrandKeys && !in_array($lc($r['brand']), $fBrandKeys, true)) {
            return false;
        }
        if ($fRem) {
            $pct = spool_pct($r);
            $bucket = $pct >= 85 ? 'full' : ($pct < 15 ? 'low' : 'partial');
            if (!in_array($bucket, $fRem, true)) {
                return false;
            }
        }
        if ($fProps) {
            $any = false;
            foreach ($fProps as $f) {
                if (!empty($r[$f])) {
                    $any = true;
                    break;
                }
            }
            if (!$any) {
                return false;
            }
        }
        if ($q !== '' && !str_contains($lc($r['type'] . ' ' . $r['brand'] . ' ' . $r['color_name'] . ' ' . $r['notes']), $lc($q))) {
            return false;
        }
        return true;
    }));
}

// index.php URL keeping the current bulk/filter query; null drops a key.
// sort is left out — the session remembers it.
function index_url(array $overrides = []): string
{
    $params = $_GET;
    unset($params['cb'], $params['sort']);
    foreach ($overrides as $k => $v) {
        if ($v === null) {
            unset($params[$k]);
        } else {
            $params[$k] = $v;
        }
    }
    $qs = http_build_query($params);
    return 'index.php' . ($qs === '' ? '' : '?' . $qs);
}

// One spool's full card: list view renders it directly (optionally with the
// bulk-edit checkbox), the color grid renders it hidden with a DOM id so
// tapping the spool's mini swatch can reveal it.
function spool_card(array $r, bool $bulk = false, ?string $domId = null): void
{
    $cur = config()['currency'];
    $pct = spool_pct($r);
    $details = [round((float)$r['remaining_g']) . ' g left (' . $pct . '%)'];
    if ($r['cost'] !== null && $r['cost'] !== '') {
        $details[] = $cur . number_format((float)$r['cost'], 2);
    }
    // A part-used spool with no logged usage has an unknown history —
    // "never used" would be wrong, so the label is only shown when there is
    // a usage date or the spool is still full.
    if ($r['last_used_at'] || $pct >= 100) {
        $details[] = rel_time($r['last_used_at']);
    }
?>
<div class="card row"<?= $domId !== null ? ' id="' . e($domId) . '" hidden' : '' ?>>
<?php if ($bulk): ?>
  <label class="bulkpick"><input type="checkbox" name="ids[]" value="<?= (int)$r['id'] ?>" aria-label="Select <?= e(spool_label($r)) ?>"></label>
<?php endif; ?>
  <?= swatch_html($r) ?>
  <div class="grow">
    <strong><?= e($r['type']) ?></strong><?php if (!empty($r['color_name'])): ?> <?= e($r['color_name']) ?><?php endif; ?><?php if ($r['brand']): ?> · <?= e($r['brand']) ?><?php endif; ?>
    <?php if ($r['abrasive']): ?><span class="badge">Abrasive</span><?php endif; ?>
    <?php if ($r['highflow']): ?><span class="badge">High-flow</span><?php endif; ?>
    <?php if ($r['silk']): ?><span class="badge">Silk</span><?php endif; ?>
    <?php if ($r['matte']): ?><span class="badge">Matte</span><?php endif; ?>
    <?php if ($r['transparent']): ?><span class="badge">Clear</span><?php endif; ?>
    <?php if ($r['sparkle']): ?><span class="badge">Sparkle</span><?php endif; ?>
    <div class="muted"><?= e(implode(' · ', $details)) ?></div>
    <?php if ($r['notes']): ?><div class="muted"><?= e($r['notes']) ?></div><?php endif; ?>
    <div class="bar"><i style="width:<?= $pct ?>%"></i></div>
  </div>
<?php if (is_logged_in() && !$bulk): ?>
  <div class="rowlinks">
    <a href="use.php?id=<?= (int)$r['id'] ?>">Use</a>
    <a href="spool.php?id=<?= (int)$r['id'] ?>">Edit</a>
  </div>
<?php endif; ?>
</div>
<?php
}

$bulk = is_logged_in() && isset($_GET['bulk']) && $rows;
if ($bulk) {
    $view = 'list'; // bulk edit needs the per-row checkboxes of the list view
}

// Types and brands actually in the inventory: the filter checkbox lists,
// plus brand autocomplete for the bulk-edit form.
$allTypes = db()->query('SELECT type FROM filaments GROUP BY type COLLATE NOCASE ORDER BY type COLLATE NOCASE')->fetchAll(PDO::FETCH_COLUMN);
$brands = db()->query(
    "SELECT brand FROM filaments WHERE brand IS NOT NULL AND brand <> ''
     GROUP BY brand COLLATE NOCASE ORDER BY brand COLLATE NOCASE"
)->fetchAll(PDO::FETCH_COLUMN);

page_header('Inventory');

?>
<h1>Inventory</h1>
<?php if (is_logged_in() && !$bulk): ?>
<div class="actions">
  <a class="btn" href="spool.php">+ Add spool</a>
  <a class="btn secondary" href="use.php">Use filament</a>
  <?php if ($rows): ?><a class="btn secondary" href="<?= e(index_url(['bulk' => 1])) ?>">Bulk edit</a><?php endif; ?>
</div>
<?php endif; ?>
<?php if (!$allCount): ?>
<p class="muted">No filaments yet<?= is_logged_in() ? ' — add your first spool above.' : '.' ?></p>
<?php else: ?>
<form method="get" id="listCtl">
  <div class="sortbar">
    <label for="sortSel">Sort</label>
    <select id="sortSel" name="sort">
      <?php foreach ($sortLabels as $k => $label): ?>
      <option value="<?= e($k) ?>" <?= $k === $sort ? 'selected' : '' ?>><?= e($label) ?></option>
      <?php endforeach; ?>
    </select>
    <?php if ($bulk): ?><input type="hidden" name="bulk" value="1"><?php endif; ?>
    <?php if (!$bulk): ?>
    <a class="btn secondary btn-sm" href="<?= e(index_url(['view' => $view === 'grid' ? 'list' : 'grid'])) ?>"><?= $view === 'grid' ? 'List' : 'Grid' ?></a>
    <?php endif; ?>
    <?php if ($filterOpen): ?>
    <input type="hidden" name="filter" value="1">
    <?php else: ?>
    <a class="btn secondary btn-sm" href="<?= e(index_url(['filter' => 1])) ?>">Filters</a>
    <?php endif; ?>
    <noscript><button>Apply</button></noscript>
  </div>
<?php if ($filterOpen): ?>
  <div class="card filterpanel">
    <div class="filtersec"><strong>Type</strong>
      <div class="check-row">
        <?php foreach ($allTypes as $t): ?>
        <label class="check"><input type="checkbox" name="ft[]" value="<?= e($t) ?>" <?= in_array($t, $fTypes, true) ? 'checked' : '' ?>> <?= e($t) ?></label>
        <?php endforeach; ?>
      </div>
    </div>
    <?php if ($brands): ?>
    <div class="filtersec"><strong>Manufacturer</strong>
      <div class="check-row">
        <?php foreach ($brands as $b): ?>
        <label class="check"><input type="checkbox" name="fb[]" value="<?= e($b) ?>" <?= in_array($lc($b), $fBrandKeys, true) ? 'checked' : '' ?>> <?= e($b) ?></label>
        <?php endforeach; ?>
      </div>
    </div>
    <?php endif; ?>
    <div class="filtersec"><strong>Amount left</strong>
      <div class="check-row">
        <?php foreach ($remDefs as $k => $label): ?>
        <label class="check"><input type="checkbox" name="fr[]" value="<?= e($k) ?>" <?= in_array($k, $fRem, true) ? 'checked' : '' ?>> <?= e($label) ?></label>
        <?php endforeach; ?>
      </div>
    </div>
    <div class="filtersec"><strong>Properties</strong>
      <div class="check-row">
        <?php foreach ($flagDefs as $k => $label): ?>
        <label class="check"><input type="checkbox" name="fp[]" value="<?= e($k) ?>" <?= in_array($k, $fProps, true) ? 'checked' : '' ?>> <?= e($label) ?></label>
        <?php endforeach; ?>
      </div>
    </div>
    <div class="filtersec"><strong>Search</strong>
      <input type="search" name="q" value="<?= e($q) ?>" placeholder="Color name, notes, brand…" enterkeyhint="search">
    </div>
    <div class="actions" style="margin:10px 0 0">
      <noscript><button>Apply filters</button></noscript>
      <a class="btn secondary" href="<?= e(index_url(['ft' => null, 'fb' => null, 'fr' => null, 'fp' => null, 'q' => null, 'filter' => null])) ?>"><?= $nFilters ? 'Clear filters' : 'Close' ?></a>
      <?php if ($nFilters): ?><span class="muted" style="align-self:center">Showing <?= count($rows) ?> of <?= $allCount ?> spools</span><?php endif; ?>
    </div>
  </div>
<?php endif; ?>
</form>
<?php if (!$rows): ?>
<p class="muted">No spools match the filters.</p>
<?php endif; ?>
<?php endif; ?>
<?php if ($bulk): ?>
<form method="post" action="index.php">
  <?= csrf_field() ?>
  <input type="hidden" name="action" value="bulk">
  <div class="card">
    <strong>Bulk edit</strong>
    <p class="muted">Tick the spools below, set only the fields you want to change (everything on "keep" stays as is), then apply.</p>
    <div class="bulkgrid">
      <label>Type
        <select name="type">
          <option value="">— keep —</option>
          <?php foreach (filament_types() as $t): ?><option value="<?= e($t) ?>"><?= e($t) ?></option><?php endforeach; ?>
        </select>
      </label>
      <label>Brand
        <input name="brand" list="brandList" placeholder="— keep —">
        <datalist id="brandList">
          <?php foreach ($brands as $b): ?><option value="<?= e($b) ?>"></option><?php endforeach; ?>
        </datalist>
      </label>
      <label>Cost (<?= e($cur) ?>)
        <input type="number" name="cost" step="0.01" min="0" inputmode="decimal" placeholder="— keep —">
      </label>
      <div>
        <label for="bulkColor">Color</label>
        <div class="row">
          <label class="check" style="margin:0;flex-shrink:0"><input type="checkbox" name="set_color"> Set to</label>
          <input type="color" id="bulkColor" name="color_hex" value="#da6019">
        </div>
      </div>
      <?php foreach (['abrasive' => 'Abrasive', 'highflow' => 'High-flow', 'silk' => 'Silk', 'matte' => 'Matte', 'rainbow' => 'Rainbow', 'transparent' => 'Transparent', 'twotone' => 'Two-tone', 'sparkle' => 'Sparkle'] as $flag => $label): ?>
      <label><?= e($label) ?>
        <select name="f_<?= e($flag) ?>">
          <option value="">— keep —</option>
          <option value="1">Yes</option>
          <option value="0">No</option>
        </select>
      </label>
      <?php endforeach; ?>
    </div>
    <div class="actions" style="margin-bottom:0">
      <button>Apply to selected</button>
      <a class="btn secondary" href="<?= e(index_url(['bulk' => null])) ?>">Done</a>
      <label class="check" style="margin:0"><input type="checkbox" id="bulkAll"> Select all</label>
    </div>
  </div>
<?php endif; ?>
<?php if ($view === 'grid'): ?>
<?php
// Bucket the (already sorted and filtered) rows by type: groups are
// alphabetical, spools inside a group keep the active sort order.
$byType = [];
foreach ($rows as $r) {
    $byType[$r['type']][] = $r;
}
uksort($byType, 'strcasecmp');
foreach ($byType as $t => $group):
?>
<section class="typegroup">
  <h2 class="typehead"><?= e($t) ?> <span class="muted"><?= count($group) ?></span></h2>
  <div class="colorgrid">
    <?php foreach ($group as $r): ?>
    <button type="button" class="gswatch" data-id="<?= (int)$r['id'] ?>" aria-expanded="false" aria-controls="gc<?= (int)$r['id'] ?>"
            title="<?= e(spool_label($r)) ?> — <?= spool_pct($r) ?>% left" aria-label="<?= e(spool_label($r)) ?> — <?= spool_pct($r) ?>% left">
      <?= swatch_html($r, true) ?>
    </button>
    <?php endforeach; ?>
  </div>
  <?php foreach ($group as $r) {
      spool_card($r, false, 'gc' . (int)$r['id']);
  } ?>
</section>
<?php endforeach; ?>
<?php else: ?>
<?php foreach ($rows as $r) {
    spool_card($r, $bulk);
} ?>
<?php endif; ?>
<?php if ($bulk): ?>
</form>
<?php endif; ?>
<?php if ($allCount): ?>
<p class="statline"><?= number_format($allCount) ?> spool<?= $allCount === 1 ? '' : 's' ?> · <a href="stats.php">View stats</a></p>
<?php endif; ?>
<?php
page_footer();