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