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

cache_buster_redirect();

if (!is_logged_in() && !config()['public_view']) {

    header('Location: login.php');

    exit;

}

$rows = db()->query('SELECT * FROM filaments')->fetchAll();

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

// Filament with no recorded price is valued at a flat DEFAULT_VALUE per full

// spool; the remaining value scales that (or the real price) by how much is

// left. spool_pct() caps at 100, so an over-full spool never exceeds its value.

const DEFAULT_VALUE = 20.0;

$totalSpools    = count($rows);

$remainingG     = 0.0;   // grams still on the spools

$originalG      = 0.0;   // grams originally purchased (nominal)

$remainingValue = 0.0;   // $ worth of filament still on the spools

$purchaseValue  = 0.0;   // $ actually recorded as paid

$pricedCount    = 0;     // spools with a recorded price

$fullCount      = 0;     // spools still at (or above) 100%

$brands         = [];    // lower-cased brand => true

$colors         = [];    // color-name (or hex) key => true

$materials      = [];    // type => remaining grams

foreach ($rows as $r) {

    $orig = (float)($r['original_g'] ?? 0);

    if ($orig <= 0) {

        $orig = 1000.0;

    }

    $rem = max(0.0, (float)$r['remaining_g']);

    $originalG  += $orig;

    $remainingG += $rem;

    $hasPrice = $r['cost'] !== null && $r['cost'] !== '';

    if ($hasPrice) {

        $purchaseValue += (float)$r['cost'];

        $pricedCount++;

    }

    $spoolValue      = $hasPrice ? (float)$r['cost'] : DEFAULT_VALUE;

    $remainingValue += $spoolValue * min(1.0, $rem / $orig);

    $brand = trim((string)$r['brand']);

    if ($brand !== '') {

        $brands[mb_strtolower($brand)] = true;

    }

    // Group colors by name when the spool has one, otherwise by hex, so unnamed

    // spools of the same shade still collapse to a single "color".

    $name = trim((string)($r['color_name'] ?? ''));

    $hex  = mb_strtolower(trim((string)($r['color_hex'] ?? '')));

    if ($name !== '') {

        $colors['n:' . mb_strtolower($name)] = true;

    } elseif ($hex !== '') {

        $colors['h:' . $hex] = true;

    }

    $type = trim((string)$r['type']);

    if ($type !== '') {

        $materials[$type] = ($materials[$type] ?? 0) + $rem;

    }

    if (spool_pct($r) >= 100) {

        $fullCount++;

    }

}

$inUseCount = $totalSpools - $fullCount;

arsort($materials);

$money = fn(float $v): string => $cur . number_format($v, 2);

$kg    = fn(float $g): string => number_format($g / 1000, 2) . ' kg';

$grams = fn(float $g): string => number_format(round($g)) . ' g';

// kg for a kilo or more, grams below — reads better across the range.

$amt   = fn(float $g): string => $g >= 1000 ? number_format($g / 1000, 2) . ' kg' : number_format(round($g)) . ' g';

page_header('Stats');

?>

<h1>Collection stats</h1>

<?php if (!$totalSpools): ?>

<p class="muted">No filaments yet — <a href="index.php">add your first spool</a>.</p>

<?php else: ?>

<div class="statgrid">

  <div class="stat"><b><?= number_format($totalSpools) ?></b><span>Spools owned</span></div>

  <div class="stat"><b><?= e($kg($remainingG)) ?></b><span>Filament remaining · <?= e($grams($remainingG)) ?></span></div>

  <div class="stat"><b><?= e($kg($originalG)) ?></b><span>Originally purchased · <?= e($grams($originalG)) ?></span></div>

  <div class="stat"><b><?= e($money($remainingValue)) ?></b><span>Est. value remaining · <?= $money(DEFAULT_VALUE) ?>/spool if unpriced</span></div>

  <div class="stat"><b><?= e($money($purchaseValue)) ?></b><span>Purchase prices<?= $pricedCount < $totalSpools ? ' · ' . $pricedCount . ' of ' . $totalSpools . ' priced' : '' ?></span></div>

  <div class="stat"><b><?= number_format(count($brands)) ?></b><span>Unique brand<?= count($brands) === 1 ? '' : 's' ?></span></div>

  <div class="stat"><b><?= number_format(count($colors)) ?></b><span>Unique color<?= count($colors) === 1 ? '' : 's' ?></span></div>

  <div class="stat"><b><?= number_format(count($materials)) ?></b><span>Material type<?= count($materials) === 1 ? '' : 's' ?></span></div>

  <div class="stat"><b><?= number_format($inUseCount) ?> <span style="font-size:16px;color:var(--muted)">in use</span></b><span><?= number_format($fullCount) ?> still full</span></div>

</div>

<div class="card">

  <strong>Collection by material</strong>

  <p class="muted" style="margin-top:4px">Share of your remaining filament by weight.</p>

  <?php foreach ($materials as $type => $g):

      $pct = $remainingG > 0 ? round(100 * $g / $remainingG) : 0;

  ?>

  <div class="matrow">

    <div class="row"><span class="grow"><strong><?= e($type) ?></strong></span><span class="muted"><?= $pct ?>% · <?= e($amt($g)) ?></span></div>

    <div class="bar"><i style="width:<?= $pct ?>%"></i></div>

  </div>

  <?php endforeach; ?>

</div>

<div class="actions">

  <a class="btn secondary" href="index.php">Back to inventory</a>

</div>

<?php endif; ?>

<?php

page_footer();