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

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

// Same stale-cache defense as index.php; save/delete POSTs pass through.
cache_buster_redirect();

require_login();

$types = filament_types();

// Brands already in the inventory, deduplicated case-insensitively,
// offered as autocomplete suggestions on the brand field.
$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);

$id = (int)($_POST['id'] ?? $_GET['id'] ?? 0);

// Manufacturers tend to reuse one spool design, so when adding a spool the
// empty-spool weight is pre-filled from the brand's most common value.
// Keyed by lowercased brand; ties go to the most recently added spool.
$spoolWeights = [];
if (!$id) {
    $wrows = db()->query(
        "SELECT brand, spool_weight_g AS w, COUNT(*) AS n FROM filaments
         WHERE brand IS NOT NULL AND brand <> '' AND spool_weight_g > 0
         GROUP BY brand COLLATE NOCASE, spool_weight_g
         ORDER BY n, MAX(id)"
    )->fetchAll();
    foreach ($wrows as $r) {
        $spoolWeights[mb_strtolower(trim($r['brand']))] = ['w' => (float)$r['w'], 'n' => (int)$r['n'], 'brand' => $r['brand']];
    }
}
$spool = null;
if ($id) {
    $st = db()->prepare('SELECT * FROM filaments WHERE id = ?');
    $st->execute([$id]);
    $spool = $st->fetch();
    if (!$spool) {
        flash('Spool not found.');
        header('Location: index.php');
        exit;
    }
}

$error = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    check_csrf();

    if (($_POST['action'] ?? '') === 'delete' && $spool) {
        backup_db();
        db()->prepare('DELETE FROM filaments WHERE id = ?')->execute([$id]);
        flash('Deleted ' . spool_label($spool) . '.');
        header('Location: index.php');
        exit;
    }

    $type   = trim((string)($_POST['type'] ?? ''));
    $brand  = trim((string)($_POST['brand'] ?? ''));
    $colorName = trim((string)($_POST['color_name'] ?? ''));
    $color  = (string)($_POST['color_hex'] ?? '');
    $color2 = (string)($_POST['color_hex2'] ?? '');
    $total  = (float)($_POST['total_weight_g'] ?? 0);
    $sw     = (float)($_POST['spool_weight_g'] ?? 0);
    $origRaw = trim((string)($_POST['original_g'] ?? ''));
    $orig   = $origRaw === '' ? 1000.0 : (float)$origRaw;
    $cost   = trim((string)($_POST['cost'] ?? ''));
    $cost   = $cost === '' ? null : (float)$cost;
    $notes  = trim((string)($_POST['notes'] ?? ''));
    $abrasive = isset($_POST['abrasive']) ? 1 : 0;
    $highflow = isset($_POST['highflow']) ? 1 : 0;
    $silk     = isset($_POST['silk']) ? 1 : 0;
    $matte    = isset($_POST['matte']) ? 1 : 0;
    $rainbow  = isset($_POST['rainbow']) ? 1 : 0;
    $transparent = isset($_POST['transparent']) ? 1 : 0;
    $twotone  = isset($_POST['twotone']) ? 1 : 0;
    $sparkle  = isset($_POST['sparkle']) ? 1 : 0;
    $small    = isset($_POST['small_spool']) ? 1 : 0;

    if (!preg_match('/^#[0-9a-fA-F]{6}$/', $color)) {
        $color = '#888888';
    }
    if (!preg_match('/^#[0-9a-fA-F]{6}$/', $color2)) {
        $color2 = $twotone ? '#888888' : null;
    }
    if ($type === '') {
        $error = 'Filament type is required.';
    } elseif ($total <= 0 || $sw < 0 || $total <= $sw) {
        $error = 'Total weight must be greater than the spool weight.';
    } elseif ($orig <= 0) {
        $error = 'Original spool amount must be greater than zero.';
    } else {
        $net = $total - $sw;
        backup_db();
        if ($spool) {
            // A changed weight means the spool was re-weighed: reset remaining
            // to total - spool. Otherwise keep remaining (usage already deducted).
            $weightsChanged = abs($total - (float)$spool['total_weight_g']) > 0.001
                           || abs($sw - (float)$spool['spool_weight_g']) > 0.001;
            $remaining = $weightsChanged ? $net : (float)$spool['remaining_g'];
            db()->prepare(
                'UPDATE filaments SET type=?, brand=?, color_name=?, color_hex=?, color_hex2=?, total_weight_g=?, spool_weight_g=?,
                 original_g=?, remaining_g=?, abrasive=?, highflow=?, silk=?, matte=?, rainbow=?, transparent=?, twotone=?, sparkle=?, small_spool=?, cost=?, notes=?, updated_at=datetime(\'now\') WHERE id=?'
            )->execute([$type, $brand, $colorName, $color, $color2, $total, $sw, $orig, $remaining, $abrasive, $highflow, $silk, $matte, $rainbow, $transparent, $twotone, $sparkle, $small, $cost, $notes, $id]);
            flash('Saved ' . spool_label(['brand' => $brand, 'type' => $type, 'color_name' => $colorName]) . '.');
            $dest = 'index.php';
        } else {
            db()->prepare(
                'INSERT INTO filaments (type, brand, color_name, color_hex, color_hex2, total_weight_g, spool_weight_g,
                 original_g, remaining_g, abrasive, highflow, silk, matte, rainbow, transparent, twotone, sparkle, small_spool, cost, notes) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)'
            )->execute([$type, $brand, $colorName, $color, $color2, $total, $sw, $orig, $net, $abrasive, $highflow, $silk, $matte, $rainbow, $transparent, $twotone, $sparkle, $small, $cost, $notes]);
            flash('Added ' . spool_label(['brand' => $brand, 'type' => $type, 'color_name' => $colorName]) . '.');
            // Land on the "recently added" sort so the new spool is at the top.
            $dest = 'index.php?sort=added';
        }
        header('Location: index.php');
        exit;
    }
    // Validation failed: re-show submitted values.
    $spool = array_merge($spool ?? [], [
        'type' => $type, 'brand' => $brand, 'color_name' => $colorName, 'color_hex' => $color,
        'color_hex2' => $color2, 'total_weight_g' => $total, 'spool_weight_g' => $sw,
        'original_g' => $orig, 'cost' => $cost,
        'abrasive' => $abrasive, 'highflow' => $highflow, 'silk' => $silk, 'matte' => $matte,
        'rainbow' => $rainbow, 'transparent' => $transparent, 'twotone' => $twotone, 'sparkle' => $sparkle,
        'small_spool' => $small, 'notes' => $notes,
    ]);
}

page_header($id ? 'Edit spool' : 'Add spool');
?>
<h1><?= $id ? 'Edit spool' : 'Add spool' ?></h1>
<?php if ($error): ?>
<p class="error"><?= e($error) ?></p>
<?php endif; ?>
<form method="post" id="spoolForm">
  <?= csrf_field() ?>
  <?php if ($id): ?><input type="hidden" name="id" value="<?= $id ?>"><?php endif; ?>

  <label for="type">Type</label>
  <?php
  $curType = (string)($spool['type'] ?? '');
  // A spool saved with a type outside the list must stay selectable.
  $typeOptions = in_array($curType, $types, true) || $curType === '' ? $types : array_merge($types, [$curType]);
  ?>
  <select id="type" name="type" required>
    <option value="" disabled <?= $curType === '' ? 'selected' : '' ?>>Select type…</option>
    <?php foreach ($typeOptions as $t): ?>
    <option value="<?= e($t) ?>" <?= $t === $curType ? 'selected' : '' ?>><?= e($t) ?></option>
    <?php endforeach; ?>
  </select>

  <label for="color_name">Color name (optional)</label>
  <input id="color_name" name="color_name" value="<?= e($spool['color_name'] ?? '') ?>" placeholder="Galaxy Black, Signal White…">

  <label for="brand">Manufacturer / brand</label>
  <input id="brand" name="brand" list="brandList" value="<?= e($spool['brand'] ?? '') ?>" placeholder="Prusament, Polymaker…">
  <datalist id="brandList">
    <?php foreach ($brands as $b): ?><option value="<?= e($b) ?>"></option><?php endforeach; ?>
  </datalist>

  <label for="color">Color</label>
  <div class="row">
    <input type="color" id="color" name="color_hex" value="<?= e($spool['color_hex'] ?? '#da6019') ?>">
    <input type="color" id="color2" name="color_hex2" aria-label="Second color" value="<?= e(!empty($spool['color_hex2']) ? $spool['color_hex2'] : '#3355ff') ?>" <?= empty($spool['twotone']) ? 'hidden' : '' ?>>
    <button type="button" class="secondary" id="camBtn" hidden>&#128247; Camera</button>
    <label class="btn secondary" style="margin:0">&#128444; Photo<input type="file" id="photoIn" accept="image/*" capture="environment" hidden></label>
  </div>
  <div id="camPanel" hidden>
    <video id="camVideo" autoplay playsinline muted></video>
    <div class="actions">
      <button type="button" id="sampleBtn">Sample color</button>
      <button type="button" class="secondary" id="camClose">Close</button>
    </div>
  </div>
  <p class="muted" id="colorMsg">Point the camera at the filament — the average color of the center of the frame is sampled.</p>
  <label class="check"><input type="checkbox" name="rainbow" <?= !empty($spool['rainbow']) ? 'checked' : '' ?>> Rainbow / multicolor (shows an animated all-hue swatch)</label>
  <label class="check"><input type="checkbox" name="twotone" id="twotoneChk" <?= !empty($spool['twotone']) ? 'checked' : '' ?>> Color-shifting / two-tone (pick a second color; a moving gradient blends them)</label>
  <label class="check"><input type="checkbox" name="transparent" <?= !empty($spool['transparent']) ? 'checked' : '' ?>> Transparent / clear (a checkerboard shows through the swatch)</label>
  <label class="check"><input type="checkbox" name="sparkle" <?= !empty($spool['sparkle']) ? 'checked' : '' ?>> Sparkle / glitter (galaxy-style flecks twinkle on the swatch)</label>

  <label for="total_weight_g">Total weight (g) — spool + filament</label>
  <input type="number" id="total_weight_g" name="total_weight_g" step="0.1" min="0" inputmode="decimal" required value="<?= e(isset($spool['total_weight_g']) ? (string)(float)$spool['total_weight_g'] : '') ?>">

  <label for="spool_weight_g">Empty spool weight (g)</label>
  <input type="number" id="spool_weight_g" name="spool_weight_g" step="0.1" min="0" inputmode="decimal" required value="<?= e(isset($spool['spool_weight_g']) ? (string)(float)$spool['spool_weight_g'] : '') ?>">
  <p class="muted" id="swMsg"></p>
  <p class="muted" id="netMsg"></p>

  <label for="original_g">Original spool amount (g) — filament when new</label>
  <input type="number" id="original_g" name="original_g" step="0.1" min="0" inputmode="decimal" required value="<?= e(isset($spool['original_g']) && $spool['original_g'] !== null ? (string)(float)$spool['original_g'] : '1000') ?>">
  <div class="chips" id="origPresets" role="group" aria-label="Common spool amounts">
    <button type="button" class="chip" data-g="1000">1 kg</button>
    <button type="button" class="chip" data-g="500">500 g</button>
    <button type="button" class="chip" data-g="250">250 g</button>
    <button type="button" class="chip" data-g="100">100 g</button>
  </div>
  <label class="check"><input type="checkbox" name="small_spool" <?= !empty($spool['small_spool']) ? 'checked' : '' ?>> Small spool (draws a smaller swatch — 250 g and under are small automatically)</label>

  <label for="cost">Cost (<?= e(config()['currency']) ?>)</label>
  <input type="number" id="cost" name="cost" step="0.01" min="0" inputmode="decimal" value="<?= e(isset($spool['cost']) && $spool['cost'] !== null ? (string)(float)$spool['cost'] : '') ?>">

  <div class="check-row">
    <label class="check"><input type="checkbox" name="abrasive" <?= !empty($spool['abrasive']) ? 'checked' : '' ?>> Abrasive (CF, GF, glow…)</label>
    <label class="check"><input type="checkbox" name="highflow" <?= !empty($spool['highflow']) ? 'checked' : '' ?>> High-flow</label>
    <label class="check"><input type="checkbox" name="silk" <?= !empty($spool['silk']) ? 'checked' : '' ?>> Silk</label>
    <label class="check"><input type="checkbox" name="matte" <?= !empty($spool['matte']) ? 'checked' : '' ?>> Matte</label>
  </div>

  <label for="notes">Notes</label>
  <textarea id="notes" name="notes" rows="1"><?= e($spool['notes'] ?? '') ?></textarea>

  <div class="actions">
    <button>Save</button>
    <a class="btn secondary" href="index.php">Cancel</a>
  </div>
</form>
<?php if ($spoolWeights): ?>
<script type="application/json" id="spoolWeights"><?= json_encode($spoolWeights, JSON_HEX_TAG | JSON_HEX_AMP | JSON_UNESCAPED_UNICODE) ?></script>
<?php endif; ?>
<?php if ($id): ?>
<form method="post" onsubmit="return confirm('Delete this spool and its usage history?')">
  <?= csrf_field() ?>
  <input type="hidden" name="id" value="<?= $id ?>">
  <input type="hidden" name="action" value="delete">
  <div class="actions"><button class="danger">Delete spool</button></div>
</form>
<?php endif; ?>
<?php
page_footer();