<?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();