文件路径: /mnt/mmcblk2p4/www/traceability/includes/bootstrap.php
────────────────────────────
<?php
defined('TRACE_APP') || define('TRACE_APP', true);

require_once __DIR__ . '/config.php';
require_once __DIR__ . '/db.php';
require_once __DIR__ . '/helpers.php';

if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

文件路径: /mnt/mmcblk2p4/www/traceability/includes/config.php
────────────────────────────
<?php
/**
 * 路径与基础配置（兼容 PHP 7.0+）
 */
defined('TRACE_APP') || define('TRACE_APP', true);

$root = dirname(__DIR__);
define('TRACE_ROOT', $root);
define('TRACE_DATA_DIR', $root . DIRECTORY_SEPARATOR . 'data');
define('TRACE_DB_PATH', TRACE_DATA_DIR . DIRECTORY_SEPARATOR . 'inventory.sqlite');

文件路径: /mnt/mmcblk2p4/www/traceability/includes/db.php
────────────────────────────
<?php
/**
 * SQLite 连接与表结构初始化
 */
if (!defined('TRACE_APP')) {
    exit;
}

require_once __DIR__ . '/config.php';

/**
 * @return PDO
 */
function trace_db()
{
    static $pdo = null;
    if ($pdo instanceof PDO) {
        return $pdo;
    }

    if (!is_dir(TRACE_DATA_DIR)) {
        if (!@mkdir(TRACE_DATA_DIR, 0755, true) && !is_dir(TRACE_DATA_DIR)) {
            throw new RuntimeException('无法创建数据目录: ' . TRACE_DATA_DIR);
        }
    }

    $dsn = 'sqlite:' . TRACE_DB_PATH;
    $pdo = new PDO($dsn, null, null, array(
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    ));
    // SQLite 外键
    $pdo->exec('PRAGMA foreign_keys = ON;');

    trace_db_migrate($pdo);

    return $pdo;
}

/**
 * @param PDO $pdo
 */
function trace_db_migrate($pdo)
{
    $pdo->exec("
        CREATE TABLE IF NOT EXISTS raw_material_batches (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            batch_no TEXT NOT NULL UNIQUE,
            supplier_code TEXT NOT NULL DEFAULT '',
            supplier_name TEXT NOT NULL DEFAULT '',
            material_name TEXT NOT NULL DEFAULT '',
            inbound_date TEXT NOT NULL,
            quantity REAL NOT NULL,
            unit TEXT NOT NULL DEFAULT 'kg',
            inbound_order_no TEXT NOT NULL DEFAULT '',
            created_at TEXT NOT NULL DEFAULT (datetime('now'))
        );
    ");

    trace_db_ensure_column($pdo, 'raw_material_batches', 'inbound_order_no', "TEXT NOT NULL DEFAULT ''");

    $pdo->exec("
        CREATE TABLE IF NOT EXISTS production_batches (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            batch_no TEXT NOT NULL UNIQUE,
            line_type TEXT NOT NULL DEFAULT '',
            note TEXT NOT NULL DEFAULT '',
            created_at TEXT NOT NULL DEFAULT (datetime('now'))
        );
    ");

    trace_db_ensure_column($pdo, 'production_batches', 'line_type', "TEXT NOT NULL DEFAULT ''");

    $pdo->exec("
        CREATE TABLE IF NOT EXISTS production_consumption (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            production_batch_no TEXT NOT NULL,
            material_name TEXT NOT NULL,
            raw_batch_no TEXT NOT NULL,
            quantity REAL NOT NULL,
            unit TEXT NOT NULL DEFAULT 'kg',
            created_at TEXT NOT NULL DEFAULT (datetime('now')),
            FOREIGN KEY (production_batch_no) REFERENCES production_batches(batch_no) ON DELETE CASCADE,
            FOREIGN KEY (raw_batch_no) REFERENCES raw_material_batches(batch_no) ON DELETE RESTRICT
        );
    ");

    $pdo->exec("
        CREATE TABLE IF NOT EXISTS finished_goods (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            batch_no TEXT NOT NULL UNIQUE,
            product_name TEXT NOT NULL,
            quantity REAL NOT NULL,
            unit TEXT NOT NULL DEFAULT 'kg',
            production_date TEXT NOT NULL,
            created_at TEXT NOT NULL DEFAULT (datetime('now')),
            FOREIGN KEY (batch_no) REFERENCES production_batches(batch_no) ON DELETE RESTRICT
        );
    ");

    $pdo->exec("
        CREATE TABLE IF NOT EXISTS sales_outbound (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            outbound_order_no TEXT NOT NULL,
            finished_batch_no TEXT NOT NULL,
            customer TEXT NOT NULL,
            quantity REAL NOT NULL,
            unit TEXT NOT NULL DEFAULT 'kg',
            outbound_date TEXT NOT NULL,
            outbound_type TEXT NOT NULL DEFAULT '出库',
            created_at TEXT NOT NULL DEFAULT (datetime('now')),
            FOREIGN KEY (finished_batch_no) REFERENCES finished_goods(batch_no) ON DELETE RESTRICT
        );
    ");

    trace_db_ensure_column($pdo, 'sales_outbound', 'outbound_type', "TEXT NOT NULL DEFAULT '出库'");

    $pdo->exec("
        CREATE TABLE IF NOT EXISTS small_package_specs (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            spec_code TEXT NOT NULL DEFAULT '',
            spec_name TEXT NOT NULL,
            unit TEXT NOT NULL DEFAULT '袋',
            fg_qty_per_package REAL NOT NULL DEFAULT 0,
            fg_qty_per_package_unit TEXT NOT NULL DEFAULT '',
            note TEXT NOT NULL DEFAULT '',
            created_at TEXT NOT NULL DEFAULT (datetime('now'))
        );
    ");

    trace_db_ensure_column($pdo, 'small_package_specs', 'fg_qty_per_package', 'REAL NOT NULL DEFAULT 0');
    trace_db_ensure_column($pdo, 'small_package_specs', 'fg_qty_per_package_unit', "TEXT NOT NULL DEFAULT ''");

    $pdo->exec("
        CREATE TABLE IF NOT EXISTS small_package_batches (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            package_batch_no TEXT NOT NULL UNIQUE,
            spec_id INTEGER NOT NULL,
            quantity REAL NOT NULL,
            unit TEXT NOT NULL DEFAULT '袋',
            inbound_date TEXT NOT NULL,
            inbound_type TEXT NOT NULL DEFAULT '采购入库',
            source_outbound_order_no TEXT NOT NULL DEFAULT '',
            note TEXT NOT NULL DEFAULT '',
            created_at TEXT NOT NULL DEFAULT (datetime('now')),
            FOREIGN KEY (spec_id) REFERENCES small_package_specs(id) ON DELETE RESTRICT
        );
    ");

    $pdo->exec("
        CREATE TABLE IF NOT EXISTS small_package_outbound (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            outbound_order_no TEXT NOT NULL,
            package_batch_no TEXT NOT NULL,
            spec_id INTEGER NOT NULL,
            quantity REAL NOT NULL,
            unit TEXT NOT NULL DEFAULT '袋',
            customer TEXT NOT NULL,
            outbound_date TEXT NOT NULL,
            created_at TEXT NOT NULL DEFAULT (datetime('now')),
            FOREIGN KEY (package_batch_no) REFERENCES small_package_batches(package_batch_no) ON DELETE RESTRICT,
            FOREIGN KEY (spec_id) REFERENCES small_package_specs(id) ON DELETE RESTRICT
        );
    ");

    $pdo->exec('CREATE INDEX IF NOT EXISTS idx_sp_batch_spec ON small_package_batches(spec_id);');
    $pdo->exec('CREATE INDEX IF NOT EXISTS idx_sp_out_batch ON small_package_outbound(package_batch_no);');
    $pdo->exec('CREATE INDEX IF NOT EXISTS idx_sp_source_order ON small_package_batches(source_outbound_order_no);');

    $pdo->exec('CREATE INDEX IF NOT EXISTS idx_consume_prod ON production_consumption(production_batch_no);');
    $pdo->exec('CREATE INDEX IF NOT EXISTS idx_consume_raw ON production_consumption(raw_batch_no);');
    $pdo->exec('CREATE INDEX IF NOT EXISTS idx_sales_fg ON sales_outbound(finished_batch_no);');

    // 历史数据：出库类型与入库类型命名统一
    $pdo->exec("UPDATE sales_outbound SET outbound_type = '转小包装' WHERE outbound_type = '再加工'");
    $pdo->exec("UPDATE small_package_batches SET inbound_type = '销售转入' WHERE inbound_type = '再加工转入'");
}

/**
 * 旧库升级：列不存在时执行 ALTER TABLE ADD COLUMN（SQLite）
 *
 * @param PDO $pdo
 * @param string $table
 * @param string $column
 * @param string $sqlType e.g. "TEXT NOT NULL DEFAULT ''"
 */
function trace_db_ensure_column($pdo, $table, $column, $sqlType)
{
    $info = $pdo->query('PRAGMA table_info(' . $table . ')')->fetchAll();
    foreach ($info as $col) {
        if (isset($col['name']) && strcasecmp($col['name'], $column) === 0) {
            return;
        }
    }
    $pdo->exec('ALTER TABLE ' . $table . ' ADD COLUMN ' . $column . ' ' . $sqlType);
}

文件路径: /mnt/mmcblk2p4/www/traceability/includes/helpers.php
────────────────────────────
<?php
/**
 * HTML 转义与批次号生成
 */
if (!defined('TRACE_APP')) {
    exit;
}

/**
 * 线别（中文） => 批号中用到的英文段，须为字母数字
 *
 * @return array
 */
function trace_line_types()
{
    return array(
        '原粉发酵' => 'YPFJ',
        '水剂发酵' => 'SJFJ',
        '粉剂填料' => 'FJTL',
        '水剂填料' => 'SJTL',
    );
}

/**
 * 允许「成品入库」下拉出现的线别（填料类）
 *
 * @return array
 */
function trace_finished_goods_line_types()
{
    return array('粉剂填料', '水剂填料');
}

/**
 * @param string $label
 * @return string|null
 */
function trace_line_type_segment($label)
{
    $map = trace_line_types();
    return isset($map[$label]) ? $map[$label] : null;
}

/**
 * @param mixed $s
 * @return string
 */
function h($s)
{
    return htmlspecialchars((string) $s, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8');
}

/**
 * 原料批次：P-YYYYMMDD-供应商代码-当日序号（两位）
 * 若供应商代码为空则用 PYYYYMMDD-序号
 *
 * @param PDO $pdo
 * @param string $inboundDate YYYY-MM-DD
 * @param string $supplierCode
 * @return string
 */
function generate_raw_batch_no($pdo, $inboundDate, $supplierCode)
{
    $d = preg_replace('/[^0-9]/', '', $inboundDate);
    if (strlen($d) !== 8) {
        $d = date('Ymd');
    }

    $code = strtoupper(preg_replace('/[^A-Za-z0-9_-]/', '', $supplierCode));
    if ($code === '') {
        $prefix = 'P' . $d . '-';
    } else {
        $prefix = 'P-' . $d . '-' . $code . '-';
    }

    $stmt = $pdo->prepare(
        'SELECT batch_no FROM raw_material_batches WHERE batch_no LIKE ? ORDER BY batch_no DESC LIMIT 1'
    );
    $stmt->execute(array($prefix . '%'));
    $row = $stmt->fetch();
    $next = 1;
    if ($row && isset($row['batch_no'])) {
        if (preg_match('/-(\d{2})$/', $row['batch_no'], $m)) {
            $next = (int) $m[1] + 1;
        }
    }
    if ($next > 99) {
        $next = 1;
        $prefix .= 'x';
    }

    return $prefix . str_pad((string) $next, 2, '0', STR_PAD_LEFT);
}

/**
 * 原料批次当前剩余可领数量（入库量 − 已记入领料表的合计）。
 * 单位一致时才准确；系统不做单位换算。
 *
 * @param PDO $pdo
 * @param string $rawBatchNo
 * @return float|null 批次不存在返回 null
 */
function trace_raw_available_qty($pdo, $rawBatchNo)
{
    $st = $pdo->prepare('SELECT quantity FROM raw_material_batches WHERE batch_no = ? LIMIT 1');
    $st->execute(array($rawBatchNo));
    $row = $st->fetch();
    if (!$row) {
        return null;
    }
    $inbound = (float) $row['quantity'];
    $st2 = $pdo->prepare(
        'SELECT COALESCE(SUM(quantity), 0) FROM production_consumption WHERE raw_batch_no = ?'
    );
    $st2->execute(array($rawBatchNo));
    $used = (float) $st2->fetchColumn();
    return $inbound - $used;
}

/**
 * 生产批号：YYYYMMDD-线别段-当日序号  例 20260415-FJTL-01（线别段为 trace_line_types 映射值）
 *
 * @param PDO $pdo
 * @param string $lineCode 英文段，如 YPFJ、FJTL
 * @param string|null $prodDate YYYY-MM-DD，默认今天
 * @return string
 */
function generate_production_batch_no($pdo, $lineCode, $prodDate = null)
{
    $line = strtoupper(preg_replace('/[^A-Za-z0-9]/', '', $lineCode));
    if ($line === '') {
        $line = 'YPFJ';
    }

    if ($prodDate === null || $prodDate === '') {
        $prodDate = date('Y-m-d');
    }
    $d = preg_replace('/[^0-9]/', '', $prodDate);
    if (strlen($d) !== 8) {
        $d = date('Ymd');
    }

    $prefix = $d . '-' . $line . '-';

    $stmt = $pdo->prepare(
        'SELECT batch_no FROM production_batches WHERE batch_no LIKE ? ORDER BY batch_no DESC LIMIT 1'
    );
    $stmt->execute(array($prefix . '%'));
    $row = $stmt->fetch();
    $next = 1;
    if ($row && isset($row['batch_no'])) {
        if (preg_match('/-(\d{2})$/', $row['batch_no'], $m)) {
            $next = (int) $m[1] + 1;
        }
    }

    return $prefix . str_pad((string) $next, 2, '0', STR_PAD_LEFT);
}

/**
 * 销售出库单号：O-YYYYMMDD-当日序号（两位）
 *
 * @param PDO $pdo
 * @param string|null $outboundDate YYYY-MM-DD
 * @return string
 */
function generate_outbound_order_no($pdo, $outboundDate = null)
{
    if ($outboundDate === null || $outboundDate === '') {
        $outboundDate = date('Y-m-d');
    }
    $d = preg_replace('/[^0-9]/', '', $outboundDate);
    if (strlen($d) !== 8) {
        $d = date('Ymd');
    }
    $prefix = 'O-' . $d . '-';
    $stmt = $pdo->prepare(
        'SELECT outbound_order_no FROM sales_outbound WHERE outbound_order_no LIKE ? ORDER BY outbound_order_no DESC LIMIT 1'
    );
    $stmt->execute(array($prefix . '%'));
    $row = $stmt->fetch();
    $next = 1;
    if ($row && !empty($row['outbound_order_no'])) {
        if (preg_match('/-(\d{2})$/', $row['outbound_order_no'], $m)) {
            $next = (int) $m[1] + 1;
        }
    }
    if ($next > 99) {
        $next = 1;
        $prefix .= 'x';
    }
    return $prefix . str_pad((string) $next, 2, '0', STR_PAD_LEFT);
}

/**
 * 销售界面大类 => production_batches.line_type
 *
 * @return array
 */
function trace_sales_fg_categories()
{
    return array(
        '粉剂' => '粉剂填料',
        '水剂' => '水剂填料',
    );
}

/**
 * 出库业务类型
 *
 * @return array
 */
function trace_sales_outbound_types()
{
    return array('出库', '转小包装');
}

/**
 * 是否「成品转出并计入小包装库存」类出库（兼容旧库中的「再加工」）
 *
 * @param string $outboundType
 * @return bool
 */
function trace_sales_is_transfer_small_pack($outboundType)
{
    return $outboundType === '转小包装' || $outboundType === '再加工';
}

/**
 * 某成品批次剩余可出数量（成品入库量 − 已销售出库合计）
 *
 * @param PDO $pdo
 * @param string $batchNo
 * @return array|null array('remaining' => float, 'unit' => string)
 */
function trace_finished_goods_remaining($pdo, $batchNo)
{
    $st = $pdo->prepare('SELECT quantity, unit FROM finished_goods WHERE batch_no = ? LIMIT 1');
    $st->execute(array($batchNo));
    $row = $st->fetch();
    if (!$row) {
        return null;
    }
    $inbound = (float) $row['quantity'];
    $st2 = $pdo->prepare(
        'SELECT COALESCE(SUM(quantity), 0) FROM sales_outbound WHERE finished_batch_no = ?'
    );
    $st2->execute(array($batchNo));
    $sold = (float) $st2->fetchColumn();
    return array(
        'remaining' => $inbound - $sold,
        'unit' => $row['unit'],
    );
}

/**
 * 按 FIFO（生产日期早、同日期则批次号序）列出某线别仍有库存的成品批次
 *
 * @param PDO $pdo
 * @param string $lineType 粉剂填料|水剂填料
 * @return array
 */
function trace_sales_fifo_batches($pdo, $lineType)
{
    $sql = "
    SELECT x.id, x.batch_no, x.product_name, x.production_date, x.unit, x.inbound_qty, x.remaining
    FROM (
      SELECT f.id, f.batch_no, f.product_name, f.production_date, f.unit, f.quantity AS inbound_qty,
        (f.quantity - COALESCE((SELECT SUM(s.quantity) FROM sales_outbound s WHERE s.finished_batch_no = f.batch_no), 0)) AS remaining
      FROM finished_goods f
      INNER JOIN production_batches p ON p.batch_no = f.batch_no
      WHERE p.line_type = ?
    ) x
    WHERE x.remaining > 0.0000001
    ORDER BY x.production_date ASC, x.id ASC
    ";
    $st = $pdo->prepare($sql);
    $st->execute(array($lineType));
    return $st->fetchAll();
}

/**
 * FIFO 分配出库数量；每行对应一个成品批次，可追溯
 *
 * @param PDO $pdo
 * @param string $lineType
 * @param float $needQty
 * @return array|false|null 分配列表 [['batch_no','quantity','unit'],...]；null 库存不足；false 单位不一致
 */
function trace_sales_fifo_allocate($pdo, $lineType, $needQty)
{
    if ($needQty <= 0) {
        return array();
    }
    $batches = trace_sales_fifo_batches($pdo, $lineType);
    if (empty($batches)) {
        return null;
    }
    $units = array();
    foreach ($batches as $b) {
        $units[$b['unit']] = true;
    }
    if (count($units) > 1) {
        return false;
    }

    $left = (float) $needQty;
    $alloc = array();
    foreach ($batches as $b) {
        if ($left <= 1e-9) {
            break;
        }
        $rem = (float) $b['remaining'];
        if ($rem <= 0) {
            continue;
        }
        $take = $rem < $left ? $rem : $left;
        if ($take <= 0) {
            continue;
        }
        $alloc[] = array(
            'batch_no' => $b['batch_no'],
            'quantity' => $take,
            'unit' => $b['unit'],
        );
        $left -= $take;
    }
    if ($left > 1e-9) {
        return null;
    }
    return $alloc;
}

/**
 * 小包装批次号：SP-YYYYMMDD-三位序号
 *
 * @param PDO $pdo
 * @param string|null $inboundDate YYYY-MM-DD
 * @return string
 */
function generate_small_package_batch_no($pdo, $inboundDate = null)
{
    if ($inboundDate === null || $inboundDate === '') {
        $inboundDate = date('Y-m-d');
    }
    $d = preg_replace('/[^0-9]/', '', $inboundDate);
    if (strlen($d) !== 8) {
        $d = date('Ymd');
    }
    $prefix = 'SP-' . $d . '-';
    $stmt = $pdo->prepare(
        'SELECT package_batch_no FROM small_package_batches WHERE package_batch_no LIKE ? ORDER BY package_batch_no DESC LIMIT 1'
    );
    $stmt->execute(array($prefix . '%'));
    $row = $stmt->fetch();
    $next = 1;
    if ($row && !empty($row['package_batch_no'])) {
        if (preg_match('/-(\d{3})$/', $row['package_batch_no'], $m)) {
            $next = (int) $m[1] + 1;
        }
    }
    if ($next > 999) {
        $next = 1;
        $prefix .= 'x';
    }
    return $prefix . str_pad((string) $next, 3, '0', STR_PAD_LEFT);
}

/**
 * 小包装销售出库单号：SPO-YYYYMMDD-两位序号
 *
 * @param PDO $pdo
 * @param string|null $outboundDate
 * @return string
 */
function generate_small_package_outbound_order_no($pdo, $outboundDate = null)
{
    if ($outboundDate === null || $outboundDate === '') {
        $outboundDate = date('Y-m-d');
    }
    $d = preg_replace('/[^0-9]/', '', $outboundDate);
    if (strlen($d) !== 8) {
        $d = date('Ymd');
    }
    $prefix = 'SPO-' . $d . '-';
    $stmt = $pdo->prepare(
        'SELECT outbound_order_no FROM small_package_outbound WHERE outbound_order_no LIKE ? ORDER BY outbound_order_no DESC LIMIT 1'
    );
    $stmt->execute(array($prefix . '%'));
    $row = $stmt->fetch();
    $next = 1;
    if ($row && !empty($row['outbound_order_no'])) {
        if (preg_match('/-(\d{2})$/', $row['outbound_order_no'], $m)) {
            $next = (int) $m[1] + 1;
        }
    }
    if ($next > 99) {
        $next = 1;
        $prefix .= 'x';
    }
    return $prefix . str_pad((string) $next, 2, '0', STR_PAD_LEFT);
}

/**
 * 小包装入库类型（仅历史数据；新数据均由销售出库「转小包装」写入「销售转入」）
 *
 * @return array
 */
function trace_small_package_manual_inbound_types()
{
    return array('采购入库', '其他入库', '销售转入');
}

/**
 * 某规格下仍有库存的小包装批次（FIFO：入库日期早优先）
 *
 * @param PDO $pdo
 * @param int $specId
 * @return array
 */
function trace_sp_fifo_batches($pdo, $specId)
{
    $sql = "
    SELECT x.id, x.package_batch_no, x.spec_id, x.inbound_date, x.unit, x.quantity AS inbound_qty, x.remaining,
           s.spec_name, s.spec_code
    FROM (
      SELECT b.id, b.package_batch_no, b.spec_id, b.inbound_date, b.unit, b.quantity,
        (b.quantity - COALESCE((SELECT SUM(o.quantity) FROM small_package_outbound o WHERE o.package_batch_no = b.package_batch_no), 0)) AS remaining
      FROM small_package_batches b
      WHERE b.spec_id = ?
    ) x
    INNER JOIN small_package_specs s ON s.id = x.spec_id
    WHERE x.remaining > 0.0000001
    ORDER BY x.inbound_date ASC, x.id ASC
    ";
    $st = $pdo->prepare($sql);
    $st->execute(array((int) $specId));
    return $st->fetchAll();
}

/**
 * 小包装按规格 FIFO 分配出库
 *
 * @param PDO $pdo
 * @param int $specId
 * @param float $needQty
 * @return array|false|null
 */
function trace_sp_fifo_allocate($pdo, $specId, $needQty)
{
    if ($needQty <= 0) {
        return array();
    }
    $batches = trace_sp_fifo_batches($pdo, $specId);
    if (empty($batches)) {
        return null;
    }
    $units = array();
    foreach ($batches as $b) {
        $units[$b['unit']] = true;
    }
    if (count($units) > 1) {
        return false;
    }
    $left = (float) $needQty;
    $alloc = array();
    foreach ($batches as $b) {
        if ($left <= 1e-9) {
            break;
        }
        $rem = (float) $b['remaining'];
        if ($rem <= 0) {
            continue;
        }
        $take = $rem < $left ? $rem : $left;
        if ($take <= 0) {
            continue;
        }
        $alloc[] = array(
            'package_batch_no' => $b['package_batch_no'],
            'quantity' => $take,
            'unit' => $b['unit'],
            'spec_id' => (int) $b['spec_id'],
        );
        $left -= $take;
    }
    if ($left > 1e-9) {
        return null;
    }
    return $alloc;
}

/**
 * @param string $msg
 * @param string $type success|error|info
 */
function flash_set($msg, $type = 'info')
{
    if (!isset($_SESSION)) {
        return;
    }
    $_SESSION['_flash'] = array('msg' => $msg, 'type' => $type);
}

/**
 * @return array|null
 */
function flash_get()
{
    if (!isset($_SESSION)) {
        return null;
    }
    if (empty($_SESSION['_flash'])) {
        return null;
    }
    $f = $_SESSION['_flash'];
    unset($_SESSION['_flash']);
    return $f;
}

文件路径: /mnt/mmcblk2p4/www/traceability/public/finished_goods.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '成品入库';
$fgLineTypes = trace_finished_goods_line_types();

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $batchNo = isset($_POST['batch_no']) ? trim($_POST['batch_no']) : '';
    $productName = isset($_POST['product_name']) ? trim($_POST['product_name']) : '';
    $quantity = isset($_POST['quantity']) ? $_POST['quantity'] : '';
    $unit = isset($_POST['unit']) ? trim($_POST['unit']) : 'kg';
    $productionDate = isset($_POST['production_date']) ? trim($_POST['production_date']) : '';

    if ($productionDate === '') {
        $productionDate = date('Y-m-d');
    }

    if ($batchNo === '' || $productName === '') {
        flash_set('请选择成品批次号（= 生产批号）并填写成品名称。', 'error');
    } elseif (!is_numeric($quantity) || (float) $quantity <= 0) {
        flash_set('数量须为大于 0 的数字。', 'error');
    } else {
        $chk = $pdo->prepare('SELECT line_type FROM production_batches WHERE batch_no = ? LIMIT 1');
        $chk->execute(array($batchNo));
        $prow = $chk->fetch();
        if (!$prow) {
            flash_set('该批次号在生产任务中不存在，请先创建生产批号。', 'error');
        } elseif (!in_array($prow['line_type'], $fgLineTypes, true)) {
            flash_set('仅「粉剂填料」「水剂填料」线别的生产批号可成品入库。', 'error');
        } else {
            try {
                $stmt = $pdo->prepare(
                    'INSERT INTO finished_goods (batch_no, product_name, quantity, unit, production_date) VALUES (?,?,?,?,?)'
                );
                $stmt->execute(array(
                    $batchNo,
                    $productName,
                    (float) $quantity,
                    $unit !== '' ? $unit : 'kg',
                    $productionDate,
                ));
                flash_set('成品已入库：' . $batchNo, 'success');
                header('Location: finished_goods.php');
                exit;
            } catch (PDOException $e) {
                if (strpos($e->getMessage(), 'UNIQUE') !== false) {
                    flash_set('该成品批次号已入库，不可重复。', 'error');
                } else {
                    flash_set('保存失败：' . $e->getMessage(), 'error');
                }
            }
        }
    }
}

$list = $pdo->query(
    'SELECT * FROM finished_goods ORDER BY production_date DESC, id DESC LIMIT 200'
)->fetchAll();

$ph = implode(',', array_fill(0, count($fgLineTypes), '?'));
$stOpt = $pdo->prepare(
    "SELECT p.batch_no, p.line_type,
        CASE WHEN f.batch_no IS NOT NULL THEN 1 ELSE 0 END AS fg_done
     FROM production_batches p
     LEFT JOIN finished_goods f ON f.batch_no = p.batch_no
     WHERE p.line_type IN ($ph)
     ORDER BY p.id DESC
     LIMIT 300"
);
$stOpt->execute($fgLineTypes);
$prodOptions = $stOpt->fetchAll();

require __DIR__ . '/layout.php';
?>
<h1>成品入库</h1>
<p class="muted">成品批次号与生产批号一致。下拉<strong>仅显示粉剂填料、水剂填料</strong>的生产批号；若该批号已做过成品入库，选择后会提示。数量<strong>默认单位为 kg</strong>。</p>

<form method="post" class="card" id="fg-form">
    <h2>新建成品入库</h2>
    <label>成品批次号（= 生产批号）</label>
    <select name="batch_no" id="fg-batch-select" required>
        <option value="">— 请选择 —</option>
        <?php if (empty($prodOptions)): ?>
        <option value="" disabled>暂无符合条件的生产批号（需线别为粉剂/水剂填料）</option>
        <?php else: ?>
            <?php foreach ($prodOptions as $o): ?>
                <?php
                $done = !empty($o['fg_done']);
                $lbl = $o['batch_no'] . '（' . $o['line_type'] . '）' . ($done ? ' · 已成品入库' : '');
                ?>
            <option value="<?php echo h($o['batch_no']); ?>"
                data-fg-done="<?php echo $done ? '1' : '0'; ?>"><?php echo h($lbl); ?></option>
            <?php endforeach; ?>
        <?php endif; ?>
    </select>
    <div id="fg-batch-warn" class="flash flash-error" style="display:none; margin-top:0.75rem;"></div>

    <div class="row">
        <div>
            <label>成品名称</label>
            <input type="text" name="product_name" required>
        </div>
        <div>
            <label>生产日期</label>
            <input type="date" name="production_date" value="<?php echo h(date('Y-m-d')); ?>">
        </div>
    </div>
    <div class="row">
        <div>
            <label>数量</label>
            <input type="number" name="quantity" step="any" min="0" required>
        </div>
        <div>
            <label>单位</label>
            <input type="text" name="unit" value="kg" placeholder="kg">
        </div>
    </div>
    <p><button type="submit" class="btn">保存</button></p>
</form>

<h2>最近记录</h2>
<table>
    <thead>
        <tr>
            <th>成品批次号</th>
            <th>成品名称</th>
            <th>数量</th>
            <th>生产日期</th>
        </tr>
    </thead>
    <tbody>
    <?php if (empty($list)): ?>
        <tr><td colspan="4" class="muted">暂无数据</td></tr>
    <?php else: ?>
        <?php foreach ($list as $r): ?>
        <tr>
            <td><strong><?php echo h($r['batch_no']); ?></strong></td>
            <td><?php echo h($r['product_name']); ?></td>
            <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
            <td><?php echo h($r['production_date']); ?></td>
        </tr>
        <?php endforeach; ?>
    <?php endif; ?>
    </tbody>
</table>

<script>
(function () {
    var sel = document.getElementById('fg-batch-select');
    var warn = document.getElementById('fg-batch-warn');
    function updateFgWarn() {
        var opt = sel.options[sel.selectedIndex];
        if (!opt || !opt.value) {
            warn.style.display = 'none';
            warn.textContent = '';
            return;
        }
        if (opt.getAttribute('data-fg-done') === '1') {
            warn.style.display = 'block';
            warn.textContent = '该成品批次号已有成品入库记录；若再次保存，系统将因唯一约束拒绝。请改用其他批号或无需重复入库。';
        } else {
            warn.style.display = 'none';
            warn.textContent = '';
        }
    }
    sel.addEventListener('change', updateFgWarn);
    updateFgWarn();
})();
</script>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/index.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pageTitle = '首页';
require __DIR__ . '/layout.php';
?>
<h1>库存与追溯</h1>
<p class="muted">流程：<strong>原料入库</strong> → <strong>生产领料</strong> → <strong>成品入库</strong> → <strong>销售出库</strong>（直出或<strong>转小包装</strong>）→ <strong>小包装出库</strong>。全链路数量<strong>默认 kg</strong>，各页可改单位。</p>
<p class="muted">小包装库存仅通过销售出库类型<strong>转小包装</strong>增加（箱数 × 规格「每箱 kg」扣成品）。统一在 <a href="trace.php">追溯查询</a> 按成品批次号或小包装批次号溯源。</p>

<ul class="home-steps">
    <li><a href="raw_inbound.php">1. 原料采购入库</a> — 多行一单；默认 kg</li>
    <li><a href="production.php">2. 生产领料</a> — 批号与原料 FIFO；默认 kg</li>
    <li><a href="finished_goods.php">3. 成品入库</a> — 填料线别；默认 kg</li>
    <li><a href="sales.php">4. 销售出库</a> — 出库 / 转小包装（箱×每箱 kg）</li>
    <li><a href="small_spec.php">5. 小包装规格</a> — 每箱重量（kg）</li>
    <li><a href="small_outbound.php">6. 小包装出库</a> — FIFO；单号 SPO-…</li>
    <li><a href="small_stock.php">7. 小包装库存</a> — 按规格汇总剩余</li>
    <li><a href="trace.php"><strong>8. 追溯查询</strong></a> — 成品批次 / 小包装批次</li>
</ul>

<h2>查询统计（筛选导出友好）</h2>
<ul class="home-steps">
    <li><a href="report_raw.php">原料查询统计</a></li>
    <li><a href="report_production.php">生产领料查询统计</a></li>
    <li><a href="report_finished.php">成品入库查询统计</a></li>
    <li><a href="report_sales.php">销售出库查询统计</a></li>
    <li><a href="report_small.php">小包装入库批次统计</a></li>
    <li><a href="report_sp_outbound.php">小包装出库统计</a></li>
</ul>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/layout.php
────────────────────────────
<?php
if (!isset($pageTitle)) {
    $pageTitle = '库存追溯';
}
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title><?php echo h($pageTitle); ?></title>
    <link rel="stylesheet" href="style.css">
</head>
<body<?php echo (isset($pageMainClass) && $pageMainClass !== '') ? ' class="' . h($pageMainClass) . '"' : ''; ?>>
<header class="site-header">
    <div class="wrap header-inner">
        <div class="brand-row">
            <strong class="site-title"><a href="index.php">库存追溯</a></strong>
        </div>
        <nav class="nav-block nav-primary" aria-label="业务操作">
            <a href="raw_inbound.php">原料入库</a>
            <a href="production.php">生产领料</a>
            <a href="finished_goods.php">成品入库</a>
            <a href="sales.php">销售出库</a>
            <a href="small_spec.php">小包装规格</a>
            <a href="small_outbound.php">小包装出库</a>
            <a href="small_stock.php">小包装库存</a>
            <a href="trace.php" class="nav-em">追溯</a>
        </nav>
        <nav class="nav-block nav-reports" aria-label="查询统计">
            <span class="nav-reports-label">统计</span>
            <a href="report_raw.php">原料</a>
            <a href="report_production.php">生产</a>
            <a href="report_finished.php">成品</a>
            <a href="report_sales.php">销售</a>
            <a href="report_small.php">小包装入</a>
            <a href="report_sp_outbound.php">小包装出</a>
        </nav>
    </div>
</header>
<main class="wrap main-content">
<?php
$flash = flash_get();
if ($flash && !empty($flash['msg'])) {
    $cls = isset($flash['type']) ? $flash['type'] : 'info';
    echo '<div class="flash flash-' . h($cls) . '">' . h($flash['msg']) . '</div>';
}
?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/layout_end.php
────────────────────────────
</main>
<footer class="site-footer wrap">
    <small>PHP + SQLite · 数据目录：<code>data/inventory.sqlite</code></small>
</footer>
</body>
</html>

文件路径: /mnt/mmcblk2p4/www/traceability/public/production.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '生产领料';
$lineTypeLabels = array_keys(trace_line_types());

// 新建生产批号
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'create_batch') {
    $auto = isset($_POST['auto_prod_batch']) && $_POST['auto_prod_batch'] === '1';
    $batchNo = isset($_POST['production_batch_no']) ? trim($_POST['production_batch_no']) : '';
    $lineType = isset($_POST['line_type']) ? trim($_POST['line_type']) : '';
    $prodDate = isset($_POST['prod_date']) ? trim($_POST['prod_date']) : '';
    $note = isset($_POST['note']) ? trim($_POST['note']) : '';

    $seg = trace_line_type_segment($lineType);
    if ($seg === null) {
        flash_set('请选择线别。', 'error');
        header('Location: production.php');
        exit;
    }

    if ($auto || $batchNo === '') {
        $batchNo = generate_production_batch_no($pdo, $seg, $prodDate !== '' ? $prodDate : null);
    }

    if ($batchNo === '') {
        flash_set('请填写生产批号或勾选自动生成。', 'error');
    } else {
        try {
            $stmt = $pdo->prepare('INSERT INTO production_batches (batch_no, line_type, note) VALUES (?,?,?)');
            $stmt->execute(array($batchNo, $lineType, $note));
            flash_set('已创建生产批号：' . $batchNo . '（' . $lineType . '）', 'success');
        } catch (PDOException $e) {
            if (strpos($e->getMessage(), 'UNIQUE') !== false) {
                flash_set('该生产批号已存在。', 'error');
            } else {
                flash_set('创建失败：' . $e->getMessage(), 'error');
            }
        }
    }
    header('Location: production.php');
    exit;
}

// 添加领料（多行一次保存，校验每批原料剩余库存）
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'add_consumption') {
    $prodBatch = isset($_POST['production_batch_no']) ? trim($_POST['production_batch_no']) : '';
    $names = isset($_POST['material_name']) && is_array($_POST['material_name']) ? $_POST['material_name'] : array();
    $raws = isset($_POST['raw_batch_no']) && is_array($_POST['raw_batch_no']) ? $_POST['raw_batch_no'] : array();
    $qtys = isset($_POST['quantity']) && is_array($_POST['quantity']) ? $_POST['quantity'] : array();
    $units = isset($_POST['unit']) && is_array($_POST['unit']) ? $_POST['unit'] : array();

    if ($prodBatch === '') {
        flash_set('请选择生产批号。', 'error');
    } else {
        $check = $pdo->prepare('SELECT 1 FROM production_batches WHERE batch_no = ? LIMIT 1');
        $check->execute(array($prodBatch));
        if (!$check->fetch()) {
            flash_set('生产批号不存在，请先创建生产批号。', 'error');
        } else {
            $n = max(count($names), count($raws), count($qtys));
            $pending = array();
            $err = '';
            $toInsert = array();
            $chkMat = $pdo->prepare('SELECT material_name FROM raw_material_batches WHERE batch_no = ? LIMIT 1');

            for ($i = 0; $i < $n; $i++) {
                $mn = isset($names[$i]) ? trim($names[$i]) : '';
                $rb = isset($raws[$i]) ? trim($raws[$i]) : '';
                $q = isset($qtys[$i]) ? $qtys[$i] : '';
                $u = isset($units[$i]) && trim($units[$i]) !== '' ? trim($units[$i]) : 'kg';
                if ($mn === '' && $rb === '' && (string) $q === '') {
                    continue;
                }
                if ($mn === '' || $rb === '' || !is_numeric($q) || (float) $q <= 0) {
                    $err = '每一行需选择原料、原料批次并填写有效用量。';
                    break;
                }
                $chkMat->execute(array($rb));
                $rm = $chkMat->fetch();
                if (!$rm) {
                    $err = '原料批次不存在：' . $rb;
                    break;
                }
                if (trim((string) $rm['material_name']) !== $mn) {
                    $err = '第 ' . ($i + 1) . ' 行：原料名称与所选原料批次不匹配。';
                    break;
                }
                $need = (float) $q;
                $availBase = trace_raw_available_qty($pdo, $rb);
                if ($availBase === null) {
                    $err = '原料批次不存在：' . $rb;
                    break;
                }
                $alreadyPending = isset($pending[$rb]) ? $pending[$rb] : 0;
                $avail = $availBase - $alreadyPending;
                if ($need > $avail + 1e-9) {
                    $err = '库存不足：批次 ' . $rb . ' 剩余 ' . $availBase . '（本单已分配 ' . $alreadyPending . '），不能领用 ' . $need . '。';
                    break;
                }
                $pending[$rb] = $alreadyPending + $need;
                $toInsert[] = array($mn, $rb, $need, $u);
            }

            if ($err !== '') {
                flash_set($err, 'error');
            } elseif (empty($toInsert)) {
                flash_set('请至少填写一行有效领料数据。', 'error');
            } else {
                $pdo->beginTransaction();
                try {
                    $ins = $pdo->prepare(
                        'INSERT INTO production_consumption (production_batch_no, material_name, raw_batch_no, quantity, unit) VALUES (?,?,?,?,?)'
                    );
                    foreach ($toInsert as $row) {
                        $ins->execute(array($prodBatch, $row[0], $row[1], $row[2], $row[3]));
                    }
                    $pdo->commit();
                    flash_set('已保存生产批号 ' . $prodBatch . ' 的领料共 ' . count($toInsert) . ' 项。', 'success');
                } catch (PDOException $e) {
                    $pdo->rollBack();
                    flash_set('保存失败：' . $e->getMessage(), 'error');
                }
            }
        }
    }
    header('Location: production.php');
    exit;
}

$batches = $pdo->query(
    'SELECT batch_no, line_type, note, created_at FROM production_batches ORDER BY id DESC LIMIT 200'
)->fetchAll();

$consumeCountByBatch = array();
$ccRows = $pdo->query(
    'SELECT production_batch_no, COUNT(*) AS n FROM production_consumption GROUP BY production_batch_no'
)->fetchAll();
foreach ($ccRows as $cr) {
    $consumeCountByBatch[$cr['production_batch_no']] = (int) $cr['n'];
}

$rawOptions = $pdo->query(
    "SELECT r.batch_no, r.material_name, r.unit, r.inbound_order_no,
      (r.quantity - COALESCE((SELECT SUM(c.quantity) FROM production_consumption c WHERE c.raw_batch_no = r.batch_no), 0)) AS remaining
     FROM raw_material_batches r
     WHERE (r.quantity - COALESCE((SELECT SUM(c.quantity) FROM production_consumption c WHERE c.raw_batch_no = r.batch_no), 0)) > 0
     ORDER BY r.inbound_date DESC, r.id DESC
     LIMIT 500"
)->fetchAll();

$materialChoices = array();
foreach ($rawOptions as $o) {
    $materialChoices[$o['material_name']] = true;
}
$materialChoices = array_keys($materialChoices);
natcasesort($materialChoices);
$materialChoices = array_values($materialChoices);

$rawForJs = array();
foreach ($rawOptions as $o) {
    $rawForJs[] = array(
        'batch_no' => $o['batch_no'],
        'material_name' => $o['material_name'],
        'remaining' => (float) $o['remaining'],
        'unit' => $o['unit'],
        'inbound_order_no' => isset($o['inbound_order_no']) ? $o['inbound_order_no'] : '',
    );
}

$batchKeys = $pdo->query(
    'SELECT production_batch_no FROM production_consumption GROUP BY production_batch_no ORDER BY MAX(id) DESC LIMIT 80'
)->fetchAll(PDO::FETCH_COLUMN);

$lineTypeByBatch = array();
foreach ($pdo->query('SELECT batch_no, line_type FROM production_batches')->fetchAll() as $br) {
    $lineTypeByBatch[$br['batch_no']] = isset($br['line_type']) ? $br['line_type'] : '';
}

$consumptionByBatch = array();
if (!empty($batchKeys)) {
    $placeholders = implode(',', array_fill(0, count($batchKeys), '?'));
    $st = $pdo->prepare(
        'SELECT c.production_batch_no, c.material_name, c.raw_batch_no, c.quantity, c.unit, c.id,
            COALESCE(r.inbound_order_no, \'\') AS inbound_order_no
         FROM production_consumption c
         LEFT JOIN raw_material_batches r ON r.batch_no = c.raw_batch_no
         WHERE c.production_batch_no IN (' . $placeholders . ')
         ORDER BY c.production_batch_no, c.id'
    );
    $st->execute($batchKeys);
    while ($row = $st->fetch()) {
        $pb = $row['production_batch_no'];
        if (!isset($consumptionByBatch[$pb])) {
            $consumptionByBatch[$pb] = array();
        }
        $consumptionByBatch[$pb][] = $row;
    }
}

require __DIR__ . '/layout.php';
?>
<h1>生产领料（追溯核心）</h1>
<p class="muted">领料用量<strong>默认 kg</strong>；与原料入库单位一致时 FIFO 剩余量才准确。</p>

<form method="post" class="card">
    <h2>下达生产任务 — 生成生产批号</h2>
    <input type="hidden" name="action" value="create_batch">
    <label><input type="checkbox" name="auto_prod_batch" value="1" checked> 自动生成生产批号（YYYYMMDD-线别英文段-当日序号，如 20260415-FJTL-01）</label>
    <div class="row">
        <div>
            <label>线别</label>
            <select name="line_type" required>
                <?php foreach ($lineTypeLabels as $lt): ?>
                <option value="<?php echo h($lt); ?>"><?php echo h($lt); ?>（<?php echo h(trace_line_types()[$lt]); ?>）</option>
                <?php endforeach; ?>
            </select>
        </div>
        <div>
            <label>任务日期（用于批号中的日期段）</label>
            <input type="date" name="prod_date" value="<?php echo h(date('Y-m-d')); ?>">
        </div>
    </div>
    <div>
        <label>生产批号（取消自动生成时手工填写，须与线别段一致）</label>
        <input type="text" name="production_batch_no" placeholder="如 20260415-FJTL-01">
    </div>
    <div>
        <label>备注</label>
        <input type="text" name="note" placeholder="可选">
    </div>
    <p><button type="submit" class="btn">创建生产批号</button></p>
</form>

<form method="post" class="card" id="consume-form">
    <h2>记录领料（原料与批次下拉联动，按剩余库存校验）</h2>
    <input type="hidden" name="action" value="add_consumption">
    <label>生产批号</label>
    <select name="production_batch_no" id="consume-prod-batch" required>
        <option value="">— 请选择 —</option>
        <?php foreach ($batches as $b): ?>
            <?php
            $lt = isset($b['line_type']) ? trim($b['line_type']) : '';
            $label = $b['batch_no'] . ($lt !== '' ? '（' . $lt . '）' : '');
            $cn = isset($consumeCountByBatch[$b['batch_no']]) ? $consumeCountByBatch[$b['batch_no']] : 0;
            ?>
        <option value="<?php echo h($b['batch_no']); ?>"
            data-has-consume="<?php echo $cn > 0 ? '1' : '0'; ?>"
            data-consume-count="<?php echo (int) $cn; ?>"><?php echo h($label); ?></option>
        <?php endforeach; ?>
    </select>
    <div id="consume-prod-warn" class="flash flash-info" style="display:none; margin-top:0.75rem;"></div>

    <table id="lines" style="margin-top:1rem;">
        <thead>
            <tr>
                <th>原料名称</th>
                <th>原料批次号</th>
                <th>用量</th>
                <th>单位</th>
                <th></th>
            </tr>
        </thead>
        <tbody>
            <tr class="line-row">
                <td>
                    <select name="material_name[]" class="js-material">
                        <option value="">— 请选择原料 —</option>
                        <?php foreach ($materialChoices as $mc): ?>
                        <option value="<?php echo h($mc); ?>"><?php echo h($mc); ?></option>
                        <?php endforeach; ?>
                    </select>
                </td>
                <td>
                    <select name="raw_batch_no[]" class="js-raw-batch">
                        <option value="">— 请先选原料 —</option>
                    </select>
                </td>
                <td><input type="number" name="quantity[]" step="any" min="0" placeholder="100"></td>
                <td><input type="text" name="unit[]" value="kg" style="max-width:80px;" class="js-unit"></td>
                <td><button type="button" class="btn btn-secondary btn-remove" disabled>删</button></td>
            </tr>
        </tbody>
    </table>
    <p>
        <button type="button" class="btn btn-secondary" id="add-line">加一行</button>
        <button type="submit" class="btn">保存本批领料</button>
    </p>
    <small class="hint">先选原料，再选有库存的原料批次（下拉显示剩余量与入库单号）。若该生产批号已有领料，会在上方提示；保存将追加新行。</small>
</form>

<h2>领料记录（每生产批号一行，点开看原料明细）</h2>
<table>
    <thead>
        <tr>
            <th>生产批号与领料明细</th>
        </tr>
    </thead>
    <tbody>
    <?php if (empty($batchKeys)): ?>
        <tr><td class="muted">暂无数据</td></tr>
    <?php else: ?>
        <?php foreach ($batchKeys as $pb): ?>
            <?php
            $rows = isset($consumptionByBatch[$pb]) ? $consumptionByBatch[$pb] : array();
            $cnt = count($rows);
            $ltShow = isset($lineTypeByBatch[$pb]) ? $lineTypeByBatch[$pb] : '';
            ?>
        <tr>
            <td class="batch-detail-wrap">
                <details class="batch-details">
                    <summary>
                        <strong><?php echo h($pb); ?></strong>
                        <?php if ($ltShow !== ''): ?>
                        <span class="muted"> · <?php echo h($ltShow); ?></span>
                        <?php endif; ?>
                        <span class="muted"> · 共 <?php echo (int) $cnt; ?> 项原料</span>
                    </summary>
                    <div class="batch-details-inner">
                        <table>
                            <thead>
                                <tr>
                                    <th>原料名称</th>
                                    <th>入库单号</th>
                                    <th>原料批次号</th>
                                    <th>用量</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($rows as $r): ?>
                                <tr>
                                    <td><?php echo h($r['material_name']); ?></td>
                                    <td><?php echo h(isset($r['inbound_order_no']) ? $r['inbound_order_no'] : ''); ?></td>
                                    <td><?php echo h($r['raw_batch_no']); ?></td>
                                    <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
                                </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                    </div>
                </details>
            </td>
        </tr>
        <?php endforeach; ?>
    <?php endif; ?>
    </tbody>
</table>

<script>
(function () {
    var RAW_STOCK = <?php echo json_encode($rawForJs, JSON_UNESCAPED_UNICODE); ?>;

    function batchesForMaterial(name) {
        var out = [];
        for (var i = 0; i < RAW_STOCK.length; i++) {
            if (RAW_STOCK[i].material_name === name) out.push(RAW_STOCK[i]);
        }
        return out;
    }

    function fillRawSelect(sel, materialName, selectedBatch) {
        sel.innerHTML = '';
        var opt0 = document.createElement('option');
        opt0.value = '';
        opt0.textContent = materialName ? '— 选择原料批次 —' : '— 请先选原料 —';
        sel.appendChild(opt0);
        if (!materialName) return;
        var list = batchesForMaterial(materialName);
        for (var j = 0; j < list.length; j++) {
            var r = list[j];
            var o = document.createElement('option');
            o.value = r.batch_no;
            var ion = (r.inbound_order_no && String(r.inbound_order_no).trim() !== '') ? ('单' + r.inbound_order_no + ' · ') : '';
            o.textContent = ion + r.batch_no + ' · 剩' + r.remaining + r.unit;
            if (selectedBatch && selectedBatch === r.batch_no) o.selected = true;
            sel.appendChild(o);
        }
    }

    function bindMaterialRow(tr) {
        var mat = tr.querySelector('.js-material');
        var raw = tr.querySelector('.js-raw-batch');
        var unitInp = tr.querySelector('.js-unit');
        mat.addEventListener('change', function () {
            fillRawSelect(raw, mat.value, '');
            unitInp.value = 'kg';
        });
        raw.addEventListener('change', function () {
            var name = mat.value;
            var bn = raw.value;
            if (!name || !bn) return;
            var list = batchesForMaterial(name);
            for (var i = 0; i < list.length; i++) {
                if (list[i].batch_no === bn) {
                    unitInp.value = list[i].unit || 'kg';
                    break;
                }
            }
        });
    }

    var tbody = document.querySelector('#lines tbody');
    var template = tbody.querySelector('.line-row');
    bindMaterialRow(template);

    document.getElementById('add-line').onclick = function () {
        var tr = template.cloneNode(true);
        tr.querySelectorAll('select').forEach(function (s) { s.selectedIndex = 0; });
        tr.querySelector('.js-raw-batch').innerHTML = '<option value=\"\">— 请先选原料 —</option>';
        tr.querySelector('.js-unit').value = 'kg';
        tr.querySelectorAll('input[type=\"number\"]').forEach(function (inp) { inp.value = ''; });
        tr.querySelector('.btn-remove').disabled = false;
        tbody.appendChild(tr);
        bindMaterialRow(tr);
        bindRemove(tr);
    };

    function bindRemove(tr) {
        tr.querySelector('.btn-remove').onclick = function () {
            if (tbody.querySelectorAll('.line-row').length > 1) tr.remove();
        };
    }
    bindRemove(template);

    var prodSel = document.getElementById('consume-prod-batch');
    var warnEl = document.getElementById('consume-prod-warn');
    function updateProdWarn() {
        var opt = prodSel.options[prodSel.selectedIndex];
        if (!opt || !opt.value) {
            warnEl.style.display = 'none';
            warnEl.textContent = '';
            return;
        }
        var has = opt.getAttribute('data-has-consume') === '1';
        var n = parseInt(opt.getAttribute('data-consume-count') || '0', 10);
        if (has) {
            warnEl.style.display = 'block';
            warnEl.className = 'flash flash-info';
            warnEl.textContent = '提示：该生产批号已有 ' + n + ' 条领料记录；本次保存将在原有基础上追加新行。';
        } else {
            warnEl.style.display = 'block';
            warnEl.className = 'flash flash-info';
            warnEl.textContent = '该生产批号尚无领料记录，保存后将首次写入。';
        }
    }
    prodSel.addEventListener('change', updateProdWarn);
    updateProdWarn();
})();
</script>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/raw_inbound.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '原料采购入库';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $auto = isset($_POST['auto_batch']) && $_POST['auto_batch'] === '1';
    $inboundDate = isset($_POST['inbound_date']) ? trim($_POST['inbound_date']) : '';
    if ($inboundDate === '') {
        $inboundDate = date('Y-m-d');
    }
    $inboundOrderNo = isset($_POST['inbound_order_no']) ? trim($_POST['inbound_order_no']) : '';

    $codes = isset($_POST['supplier_code']) && is_array($_POST['supplier_code']) ? $_POST['supplier_code'] : array();
    $names = isset($_POST['supplier_name']) && is_array($_POST['supplier_name']) ? $_POST['supplier_name'] : array();
    $materials = isset($_POST['material_name']) && is_array($_POST['material_name']) ? $_POST['material_name'] : array();
    $qtys = isset($_POST['quantity']) && is_array($_POST['quantity']) ? $_POST['quantity'] : array();
    $units = isset($_POST['unit']) && is_array($_POST['unit']) ? $_POST['unit'] : array();
    $batchNos = isset($_POST['batch_no']) && is_array($_POST['batch_no']) ? $_POST['batch_no'] : array();

    $n = max(count($codes), count($materials), count($qtys));
    $lines = array();
    for ($i = 0; $i < $n; $i++) {
        $sc = isset($codes[$i]) ? trim($codes[$i]) : '';
        $sn = isset($names[$i]) ? trim($names[$i]) : '';
        $mn = isset($materials[$i]) ? trim($materials[$i]) : '';
        $q = isset($qtys[$i]) ? $qtys[$i] : '';
        $u = isset($units[$i]) && trim($units[$i]) !== '' ? trim($units[$i]) : 'kg';
        $bn = isset($batchNos[$i]) ? trim($batchNos[$i]) : '';
        if ($sc === '' && $sn === '' && $mn === '' && (string) $q === '') {
            continue;
        }
        if ($mn === '' || !is_numeric($q) || (float) $q <= 0) {
            flash_set('每一行有数据时，须填写原料名称和有效数量。', 'error');
            $lines = null;
            break;
        }
        if (!$auto && $bn === '') {
            flash_set('未勾选自动生成时，每一行须填写原料批次号。', 'error');
            $lines = null;
            break;
        }
        $lines[] = array('supplier_code' => $sc, 'supplier_name' => $sn, 'material_name' => $mn, 'quantity' => (float) $q, 'unit' => $u, 'batch_no' => $bn);
    }

    if ($lines === null) {
        // flash already set
    } elseif (empty($lines)) {
        flash_set('请至少填写一行入库明细（供应商/原料/数量）。', 'error');
    } else {
        $pdo->beginTransaction();
        try {
            $stmt = $pdo->prepare(
                'INSERT INTO raw_material_batches (batch_no, supplier_code, supplier_name, material_name, inbound_date, quantity, unit, inbound_order_no)
                 VALUES (?,?,?,?,?,?,?,?)'
            );
            $saved = 0;
            foreach ($lines as $line) {
                if ($auto || $line['batch_no'] === '') {
                    $batchNo = generate_raw_batch_no($pdo, $inboundDate, $line['supplier_code']);
                } else {
                    $batchNo = $line['batch_no'];
                }
                $stmt->execute(array(
                    $batchNo,
                    $line['supplier_code'],
                    $line['supplier_name'],
                    $line['material_name'],
                    $inboundDate,
                    $line['quantity'],
                    $line['unit'],
                    $inboundOrderNo,
                ));
                $saved++;
            }
            $pdo->commit();
            flash_set('已入库 ' . $saved . ' 笔原料批次。', 'success');
            header('Location: raw_inbound.php');
            exit;
        } catch (PDOException $e) {
            $pdo->rollBack();
            if (strpos($e->getMessage(), 'UNIQUE') !== false) {
                flash_set('存在重复的原料批次号，请检查手工批次号或分批保存。', 'error');
            } else {
                flash_set('保存失败：' . $e->getMessage(), 'error');
            }
        }
    }
}

$list = $pdo->query(
    "SELECT r.*,
      (r.quantity - COALESCE((SELECT SUM(c.quantity) FROM production_consumption c WHERE c.raw_batch_no = r.batch_no), 0)) AS remaining
     FROM raw_material_batches r
     ORDER BY r.inbound_date DESC, r.id DESC
     LIMIT 200"
)->fetchAll();

require __DIR__ . '/layout.php';
?>
<h1>原料采购入库</h1>
<p class="muted">数量<strong>默认单位为 kg</strong>（单位列可改）。同一笔到货可填一个<strong>入库单号</strong>，本单内多行共用；每行独立原料批次号。</p>

<form method="post" class="card">
    <h2>新建入库（多行）</h2>
    <label><input type="checkbox" name="auto_batch" value="1" checked> 每行自动生成原料批次号（P-YYYYMMDD-该行供应商代码-序号；无代码则为 PYYYYMMDD-序号）</label>
    <div class="row">
        <div>
            <label>入库日期（本单共用）</label>
            <input type="date" name="inbound_date" value="<?php echo h(date('Y-m-d')); ?>">
        </div>
        <div>
            <label>入库单号（本单共用，可选）</label>
            <input type="text" name="inbound_order_no" placeholder="如 RK-20260404-001，多行保存时写入每一行">
        </div>
    </div>

    <table id="lines" class="inbound-lines" style="margin-top:1rem;">
        <thead>
            <tr>
                <th>供应商代码</th>
                <th>供应商名称</th>
                <th>原料名称</th>
                <th>数量</th>
                <th>单位</th>
                <th>批次号（仅手工时填）</th>
                <th></th>
            </tr>
        </thead>
        <tbody>
            <tr class="line-row">
                <td><input type="text" name="supplier_code[]" placeholder="SUP01"></td>
                <td><input type="text" name="supplier_name[]" placeholder="可选"></td>
                <td><input type="text" name="material_name[]" placeholder="不锈钢板"></td>
                <td><input type="number" name="quantity[]" step="any" min="0" placeholder="100"></td>
                <td><input type="text" name="unit[]" value="kg" style="max-width:72px;"></td>
                <td><input type="text" name="batch_no[]" placeholder="自动生成可空"></td>
                <td><button type="button" class="btn btn-secondary btn-remove" disabled>删</button></td>
            </tr>
        </tbody>
    </table>
    <p>
        <button type="button" class="btn btn-secondary" id="add-line">加一行</button>
        <button type="submit" class="btn">保存本单全部行</button>
    </p>
</form>

<h2>最近记录</h2>
<table>
    <thead>
        <tr>
            <th>入库单号</th>
            <th>原料批次号</th>
            <th>供应商</th>
            <th>原料名称</th>
            <th>入库日期</th>
            <th>入库数量</th>
            <th>剩余可领</th>
        </tr>
    </thead>
    <tbody>
    <?php if (empty($list)): ?>
        <tr><td colspan="7" class="muted">暂无数据</td></tr>
    <?php else: ?>
        <?php foreach ($list as $r): ?>
        <tr>
            <td><?php echo h(isset($r['inbound_order_no']) ? $r['inbound_order_no'] : ''); ?></td>
            <td><strong><?php echo h($r['batch_no']); ?></strong></td>
            <td><?php echo h(trim($r['supplier_code'] . ' ' . $r['supplier_name'])); ?></td>
            <td><?php echo h($r['material_name']); ?></td>
            <td><?php echo h($r['inbound_date']); ?></td>
            <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
            <td><?php echo h($r['remaining'] . ' ' . $r['unit']); ?></td>
        </tr>
        <?php endforeach; ?>
    <?php endif; ?>
    </tbody>
</table>

<script>
(function () {
    var tbody = document.querySelector('#lines tbody');
    var template = tbody.querySelector('.line-row');
    document.getElementById('add-line').onclick = function () {
        var tr = template.cloneNode(true);
        tr.querySelectorAll('input').forEach(function (inp) {
            if (inp.name === 'unit[]') inp.value = 'kg';
            else inp.value = '';
        });
        tr.querySelector('.btn-remove').disabled = false;
        tbody.appendChild(tr);
        bindRemove(tr);
    };
    function bindRemove(tr) {
        tr.querySelector('.btn-remove').onclick = function () {
            if (tbody.querySelectorAll('.line-row').length > 1) tr.remove();
        };
    }
    bindRemove(template);
})();
</script>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/report_finished.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '成品入库查询统计';
$pageMainClass = 'page-report page-report--finished';

$df = isset($_GET['df']) ? trim($_GET['df']) : '';
$dt = isset($_GET['dt']) ? trim($_GET['dt']) : '';
$product = isset($_GET['product']) ? trim($_GET['product']) : '';
$batch = isset($_GET['batch']) ? trim($_GET['batch']) : '';

$where = array('1=1');
$params = array();
if ($df !== '') {
    $where[] = 'f.production_date >= ?';
    $params[] = $df;
}
if ($dt !== '') {
    $where[] = 'f.production_date <= ?';
    $params[] = $dt;
}
if ($product !== '') {
    $where[] = 'f.product_name LIKE ?';
    $params[] = '%' . $product . '%';
}
if ($batch !== '') {
    $where[] = 'f.batch_no LIKE ?';
    $params[] = '%' . $batch . '%';
}

$sql = 'SELECT f.*, p.line_type
    FROM finished_goods f
    LEFT JOIN production_batches p ON p.batch_no = f.batch_no
    WHERE ' . implode(' AND ', $where) . '
    ORDER BY f.production_date DESC, f.id DESC
    LIMIT 800';
$st = $pdo->prepare($sql);
$st->execute($params);
$rows = $st->fetchAll();

$sum = 0.0;
foreach ($rows as $r) {
    $sum += (float) $r['quantity'];
}

require __DIR__ . '/layout.php';
?>
<header class="report-page-header">
    <span class="report-badge">成品</span>
    <h1>成品入库查询统计</h1>
    <p class="muted report-lead">默认数量 <strong>kg</strong>；可与线别对照。</p>
</header>

<form method="get" class="card filter-card">
    <h2 class="filter-card-title">筛选条件</h2>
    <div class="row">
        <div><label>生产日期从</label><input type="date" name="df" value="<?php echo h($df); ?>"></div>
        <div><label>到</label><input type="date" name="dt" value="<?php echo h($dt); ?>"></div>
        <div><label>成品名称（模糊）</label><input type="text" name="product" value="<?php echo h($product); ?>"></div>
    </div>
    <div class="row">
        <div><label>成品批次号（模糊）</label><input type="text" name="batch" value="<?php echo h($batch); ?>"></div>
    </div>
    <p class="filter-actions-row"><button type="submit" class="btn btn-report-submit">查询</button></p>
</form>

<div class="card report-results-card">
    <div class="report-stats" role="status">
        <span class="report-stat"><span class="report-stat-label">行数</span><strong><?php echo count($rows); ?></strong></span>
        <span class="report-stat"><span class="report-stat-label">数量合计</span><strong><?php echo h($sum); ?></strong></span>
    </div>
    <p class="report-footnote muted">单位混用时请人工辨别。</p>
    <div class="report-table-shell">
    <div class="table-wrap">
    <table class="table-report">
        <thead>
            <tr>
                <th>成品批次号</th>
                <th>线别</th>
                <th>成品名称</th>
                <th>数量</th>
                <th>生产日期</th>
            </tr>
        </thead>
        <tbody>
        <?php if (empty($rows)): ?>
            <tr><td colspan="5" class="muted">无匹配数据</td></tr>
        <?php else: ?>
            <?php foreach ($rows as $r): ?>
            <tr>
                <td><strong><?php echo h($r['batch_no']); ?></strong></td>
                <td><?php echo h(isset($r['line_type']) ? $r['line_type'] : ''); ?></td>
                <td><?php echo h($r['product_name']); ?></td>
                <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
                <td><?php echo h($r['production_date']); ?></td>
            </tr>
            <?php endforeach; ?>
        <?php endif; ?>
        </tbody>
    </table>
    </div>
    </div>
</div>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/report_production.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '生产领料查询统计';
$pageMainClass = 'page-report page-report--production';

$df = isset($_GET['df']) ? trim($_GET['df']) : '';
$dt = isset($_GET['dt']) ? trim($_GET['dt']) : '';
$lineType = isset($_GET['line_type']) ? trim($_GET['line_type']) : '';
$batch = isset($_GET['batch']) ? trim($_GET['batch']) : '';
$rawBatch = isset($_GET['raw_batch']) ? trim($_GET['raw_batch']) : '';

$where = array('1=1');
$params = array();
if ($df !== '') {
    $where[] = "substr(p.created_at, 1, 10) >= ?";
    $params[] = $df;
}
if ($dt !== '') {
    $where[] = "substr(p.created_at, 1, 10) <= ?";
    $params[] = $dt;
}
if ($lineType !== '') {
    $where[] = 'p.line_type = ?';
    $params[] = $lineType;
}
if ($batch !== '') {
    $where[] = 'p.batch_no LIKE ?';
    $params[] = '%' . $batch . '%';
}
if ($rawBatch !== '') {
    $where[] = 'c.raw_batch_no LIKE ?';
    $params[] = '%' . $rawBatch . '%';
}

$sql = 'SELECT p.batch_no, p.line_type, p.created_at, p.note,
    c.id AS cid, c.material_name, c.raw_batch_no, c.quantity, c.unit
    FROM production_batches p
    LEFT JOIN production_consumption c ON c.production_batch_no = p.batch_no
    WHERE ' . implode(' AND ', $where) . '
    ORDER BY p.id DESC, c.id ASC LIMIT 2000';

$st = $pdo->prepare($sql);
$st->execute($params);
$rows = $st->fetchAll();

$lineTypes = array_keys(trace_line_types());

require __DIR__ . '/layout.php';
?>
<header class="report-page-header">
    <span class="report-badge">生产</span>
    <h1>生产领料查询统计</h1>
    <p class="muted report-lead">按生产批号与领料行展开；领料用量默认 <strong>kg</strong>。</p>
</header>

<form method="get" class="card filter-card">
    <h2 class="filter-card-title">筛选条件</h2>
    <div class="row">
        <div><label>创建日期从</label><input type="date" name="df" value="<?php echo h($df); ?>"></div>
        <div><label>到</label><input type="date" name="dt" value="<?php echo h($dt); ?>"></div>
        <div>
            <label>线别</label>
            <select name="line_type">
                <option value="">全部</option>
                <?php foreach ($lineTypes as $lt): ?>
                <option value="<?php echo h($lt); ?>"<?php if ($lineType === $lt): ?> selected<?php endif; ?>><?php echo h($lt); ?></option>
                <?php endforeach; ?>
            </select>
        </div>
    </div>
    <div class="row">
        <div><label>生产批号（模糊）</label><input type="text" name="batch" value="<?php echo h($batch); ?>"></div>
        <div><label>原料批次号（模糊）</label><input type="text" name="raw_batch" value="<?php echo h($rawBatch); ?>"></div>
    </div>
    <p class="filter-actions-row"><button type="submit" class="btn btn-report-submit">查询</button></p>
</form>

<div class="card report-results-card">
    <div class="report-stats" role="status">
        <span class="report-stat"><span class="report-stat-label">结果行数</span><strong><?php echo count($rows); ?></strong></span>
    </div>
    <p class="report-footnote muted">含无领料的生产批（领料列为空）。</p>
    <div class="report-table-shell">
    <div class="table-wrap">
    <table class="table-report">
        <thead>
            <tr>
                <th>生产批号</th>
                <th>线别</th>
                <th>创建时间</th>
                <th>备注</th>
                <th>原料名称</th>
                <th>原料批次</th>
                <th>领用量</th>
            </tr>
        </thead>
        <tbody>
        <?php if (empty($rows)): ?>
            <tr><td colspan="7" class="muted">无匹配数据</td></tr>
        <?php else: ?>
            <?php foreach ($rows as $r): ?>
            <tr>
                <td><strong><?php echo h($r['batch_no']); ?></strong></td>
                <td><?php echo h($r['line_type']); ?></td>
                <td><?php echo h($r['created_at']); ?></td>
                <td><?php echo h($r['note']); ?></td>
                <td><?php echo h($r['material_name']); ?></td>
                <td><?php echo h($r['raw_batch_no']); ?></td>
                <td><?php echo $r['cid'] ? h($r['quantity'] . ' ' . $r['unit']) : '—'; ?></td>
            </tr>
            <?php endforeach; ?>
        <?php endif; ?>
        </tbody>
    </table>
    </div>
    </div>
</div>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/report_raw.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '原料查询统计';
$pageMainClass = 'page-report page-report--raw';

$df = isset($_GET['df']) ? trim($_GET['df']) : '';
$dt = isset($_GET['dt']) ? trim($_GET['dt']) : '';
$material = isset($_GET['material']) ? trim($_GET['material']) : '';
$supplier = isset($_GET['supplier']) ? trim($_GET['supplier']) : '';
$batch = isset($_GET['batch']) ? trim($_GET['batch']) : '';
$orderNo = isset($_GET['order_no']) ? trim($_GET['order_no']) : '';

$where = array('1=1');
$params = array();
if ($df !== '') {
    $where[] = 'r.inbound_date >= ?';
    $params[] = $df;
}
if ($dt !== '') {
    $where[] = 'r.inbound_date <= ?';
    $params[] = $dt;
}
if ($material !== '') {
    $where[] = 'r.material_name LIKE ?';
    $params[] = '%' . $material . '%';
}
if ($supplier !== '') {
    $where[] = '(r.supplier_code LIKE ? OR r.supplier_name LIKE ?)';
    $params[] = '%' . $supplier . '%';
    $params[] = '%' . $supplier . '%';
}
if ($batch !== '') {
    $where[] = 'r.batch_no LIKE ?';
    $params[] = '%' . $batch . '%';
}
if ($orderNo !== '') {
    $where[] = 'r.inbound_order_no LIKE ?';
    $params[] = '%' . $orderNo . '%';
}

$sql = 'SELECT r.*,
    (r.quantity - COALESCE((SELECT SUM(c.quantity) FROM production_consumption c WHERE c.raw_batch_no = r.batch_no), 0)) AS remaining
    FROM raw_material_batches r
    WHERE ' . implode(' AND ', $where) . '
    ORDER BY r.inbound_date DESC, r.id DESC
    LIMIT 800';
$st = $pdo->prepare($sql);
$st->execute($params);
$rows = $st->fetchAll();

$sumQty = 0.0;
$sumRem = 0.0;
foreach ($rows as $r) {
    $sumQty += (float) $r['quantity'];
    $sumRem += (float) $r['remaining'];
}

require __DIR__ . '/layout.php';
?>
<header class="report-page-header">
    <span class="report-badge">原料</span>
    <h1>原料查询统计</h1>
    <p class="muted report-lead">按条件筛选原料入库明细；默认数量单位为 <strong>kg</strong>。</p>
</header>

<form method="get" class="card filter-card">
    <h2 class="filter-card-title">筛选条件</h2>
    <div class="row">
        <div><label>入库日期从</label><input type="date" name="df" value="<?php echo h($df); ?>"></div>
        <div><label>到</label><input type="date" name="dt" value="<?php echo h($dt); ?>"></div>
        <div><label>原料名称（模糊）</label><input type="text" name="material" value="<?php echo h($material); ?>" placeholder="可选"></div>
    </div>
    <div class="row">
        <div><label>供应商（代码或名称，模糊）</label><input type="text" name="supplier" value="<?php echo h($supplier); ?>"></div>
        <div><label>原料批次号（模糊）</label><input type="text" name="batch" value="<?php echo h($batch); ?>"></div>
        <div><label>入库单号（模糊）</label><input type="text" name="order_no" value="<?php echo h($orderNo); ?>"></div>
    </div>
    <p class="filter-actions-row"><button type="submit" class="btn btn-report-submit">查询</button></p>
</form>

<div class="card report-results-card">
    <div class="report-stats" role="status">
        <span class="report-stat"><span class="report-stat-label">行数</span><strong><?php echo count($rows); ?></strong></span>
        <span class="report-stat"><span class="report-stat-label">入库合计</span><strong><?php echo h($sumQty); ?></strong></span>
        <span class="report-stat"><span class="report-stat-label">剩余可领合计</span><strong><?php echo h($sumRem); ?></strong></span>
    </div>
    <p class="report-footnote muted">入库合计按行相加；若单位混用请人工辨别。</p>
    <div class="report-table-shell">
    <div class="table-wrap">
    <table class="table-report">
        <thead>
            <tr>
                <th>批次号</th>
                <th>入库单号</th>
                <th>供应商</th>
                <th>原料</th>
                <th>入库日期</th>
                <th>入库量</th>
                <th>剩余可领</th>
            </tr>
        </thead>
        <tbody>
        <?php if (empty($rows)): ?>
            <tr><td colspan="7" class="muted">无匹配数据</td></tr>
        <?php else: ?>
            <?php foreach ($rows as $r): ?>
            <tr>
                <td><strong><?php echo h($r['batch_no']); ?></strong></td>
                <td><?php echo h($r['inbound_order_no']); ?></td>
                <td><?php echo h(trim($r['supplier_code'] . ' ' . $r['supplier_name'])); ?></td>
                <td><?php echo h($r['material_name']); ?></td>
                <td><?php echo h($r['inbound_date']); ?></td>
                <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
                <td><?php echo h($r['remaining'] . ' ' . $r['unit']); ?></td>
            </tr>
            <?php endforeach; ?>
        <?php endif; ?>
        </tbody>
    </table>
    </div>
    </div>
</div>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/report_sales.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '销售出库查询统计';
$pageMainClass = 'page-report page-report--sales';

$df = isset($_GET['df']) ? trim($_GET['df']) : '';
$dt = isset($_GET['dt']) ? trim($_GET['dt']) : '';
$customer = isset($_GET['customer']) ? trim($_GET['customer']) : '';
$orderNo = isset($_GET['order_no']) ? trim($_GET['order_no']) : '';
$otype = isset($_GET['otype']) ? trim($_GET['otype']) : '';
$fgBatch = isset($_GET['fg_batch']) ? trim($_GET['fg_batch']) : '';

$where = array('1=1');
$params = array();
if ($df !== '') {
    $where[] = 's.outbound_date >= ?';
    $params[] = $df;
}
if ($dt !== '') {
    $where[] = 's.outbound_date <= ?';
    $params[] = $dt;
}
if ($customer !== '') {
    $where[] = 's.customer LIKE ?';
    $params[] = '%' . $customer . '%';
}
if ($orderNo !== '') {
    $where[] = 's.outbound_order_no LIKE ?';
    $params[] = '%' . $orderNo . '%';
}
if ($otype !== '') {
    $where[] = 'COALESCE(s.outbound_type, \'出库\') = ?';
    $params[] = $otype;
}
if ($fgBatch !== '') {
    $where[] = 's.finished_batch_no LIKE ?';
    $params[] = '%' . $fgBatch . '%';
}

$sql = 'SELECT s.*, p.line_type
    FROM sales_outbound s
    LEFT JOIN finished_goods f ON f.batch_no = s.finished_batch_no
    LEFT JOIN production_batches p ON p.batch_no = s.finished_batch_no
    WHERE ' . implode(' AND ', $where) . '
    ORDER BY s.outbound_date DESC, s.outbound_order_no DESC, s.id DESC
    LIMIT 1200';
$st = $pdo->prepare($sql);
$st->execute($params);
$rows = $st->fetchAll();

$sum = 0.0;
foreach ($rows as $r) {
    $sum += (float) $r['quantity'];
}

require __DIR__ . '/layout.php';
?>
<header class="report-page-header">
    <span class="report-badge">销售</span>
    <h1>销售出库查询统计</h1>
    <p class="muted report-lead">按明细行展示（一单可对应多成品批次）；默认 <strong>kg</strong>。</p>
</header>

<form method="get" class="card filter-card">
    <h2 class="filter-card-title">筛选条件</h2>
    <div class="row">
        <div><label>出库日期从</label><input type="date" name="df" value="<?php echo h($df); ?>"></div>
        <div><label>到</label><input type="date" name="dt" value="<?php echo h($dt); ?>"></div>
        <div><label>出库类型</label>
            <select name="otype">
                <option value=""<?php if ($otype === ''): ?> selected<?php endif; ?>>全部</option>
                <option value="出库"<?php if ($otype === '出库'): ?> selected<?php endif; ?>>出库</option>
                <option value="转小包装"<?php if ($otype === '转小包装'): ?> selected<?php endif; ?>>转小包装</option>
                <option value="再加工"<?php if ($otype === '再加工'): ?> selected<?php endif; ?>>再加工（旧数据）</option>
            </select>
        </div>
    </div>
    <div class="row">
        <div><label>客户（模糊）</label><input type="text" name="customer" value="<?php echo h($customer); ?>"></div>
        <div><label>出库单号（模糊）</label><input type="text" name="order_no" value="<?php echo h($orderNo); ?>"></div>
        <div><label>成品批次号（模糊）</label><input type="text" name="fg_batch" value="<?php echo h($fgBatch); ?>"></div>
    </div>
    <p class="filter-actions-row"><button type="submit" class="btn btn-report-submit">查询</button></p>
</form>

<div class="card report-results-card">
    <div class="report-stats" role="status">
        <span class="report-stat"><span class="report-stat-label">行数</span><strong><?php echo count($rows); ?></strong></span>
        <span class="report-stat"><span class="report-stat-label">出库合计</span><strong><?php echo h($sum); ?></strong></span>
    </div>
    <div class="report-table-shell">
    <div class="table-wrap">
    <table class="table-report">
        <thead>
            <tr>
                <th>出库单号</th>
                <th>类型</th>
                <th>品类</th>
                <th>成品批次</th>
                <th>客户</th>
                <th>数量</th>
                <th>日期</th>
            </tr>
        </thead>
        <tbody>
        <?php if (empty($rows)): ?>
            <tr><td colspan="7" class="muted">无匹配数据</td></tr>
        <?php else: ?>
            <?php foreach ($rows as $r): ?>
                <?php
                $lt = isset($r['line_type']) ? $r['line_type'] : '';
                $catShow = ($lt === '粉剂填料') ? '粉剂' : (($lt === '水剂填料') ? '水剂' : ($lt !== '' ? $lt : '—'));
                $ot = isset($r['outbound_type']) ? $r['outbound_type'] : '出库';
                ?>
            <tr>
                <td><?php echo h($r['outbound_order_no']); ?></td>
                <td><?php echo h($ot); ?></td>
                <td><?php echo h($catShow); ?></td>
                <td><strong><?php echo h($r['finished_batch_no']); ?></strong></td>
                <td><?php echo h($r['customer']); ?></td>
                <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
                <td><?php echo h($r['outbound_date']); ?></td>
            </tr>
            <?php endforeach; ?>
        <?php endif; ?>
        </tbody>
    </table>
    </div>
    </div>
</div>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/report_small.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '小包装查询统计';
$pageMainClass = 'page-report page-report--small';

$df = isset($_GET['df']) ? trim($_GET['df']) : '';
$dt = isset($_GET['dt']) ? trim($_GET['dt']) : '';
$specId = isset($_GET['spec_id']) ? (int) $_GET['spec_id'] : 0;
$inType = isset($_GET['in_type']) ? trim($_GET['in_type']) : '';
$pkg = isset($_GET['pkg']) ? trim($_GET['pkg']) : '';
$srcOrder = isset($_GET['src_order']) ? trim($_GET['src_order']) : '';

$where = array('1=1');
$params = array();
if ($df !== '') {
    $where[] = 'b.inbound_date >= ?';
    $params[] = $df;
}
if ($dt !== '') {
    $where[] = 'b.inbound_date <= ?';
    $params[] = $dt;
}
if ($specId > 0) {
    $where[] = 'b.spec_id = ?';
    $params[] = $specId;
}
if ($inType !== '') {
    $where[] = 'b.inbound_type = ?';
    $params[] = $inType;
}
if ($pkg !== '') {
    $where[] = 'b.package_batch_no LIKE ?';
    $params[] = '%' . $pkg . '%';
}
if ($srcOrder !== '') {
    $where[] = 'b.source_outbound_order_no LIKE ?';
    $params[] = '%' . $srcOrder . '%';
}

$sql = 'SELECT b.*, s.spec_name,
    (b.quantity - COALESCE((SELECT SUM(o.quantity) FROM small_package_outbound o WHERE o.package_batch_no = b.package_batch_no), 0)) AS remaining
    FROM small_package_batches b
    INNER JOIN small_package_specs s ON s.id = b.spec_id
    WHERE ' . implode(' AND ', $where) . '
    ORDER BY b.inbound_date DESC, b.id DESC
    LIMIT 1000';
$st = $pdo->prepare($sql);
$st->execute($params);
$rows = $st->fetchAll();

$specs = $pdo->query('SELECT id, spec_name FROM small_package_specs ORDER BY spec_name')->fetchAll();
$inTypesRows = $pdo->query('SELECT DISTINCT inbound_type FROM small_package_batches ORDER BY inbound_type')->fetchAll();
$inTypeOpts = array();
foreach ($inTypesRows as $ir) {
    $inTypeOpts[] = $ir['inbound_type'];
}

require __DIR__ . '/layout.php';
?>
<header class="report-page-header">
    <span class="report-badge">小包装入</span>
    <h1>小包装查询统计</h1>
    <p class="muted report-lead">入库批次与剩余可出；单批溯源可在 <a href="trace.php">追溯查询</a> 输入小包装批次号。</p>
</header>

<form method="get" class="card filter-card">
    <h2 class="filter-card-title">筛选条件</h2>
    <div class="row">
        <div><label>入库日期从</label><input type="date" name="df" value="<?php echo h($df); ?>"></div>
        <div><label>到</label><input type="date" name="dt" value="<?php echo h($dt); ?>"></div>
        <div>
            <label>规格</label>
            <select name="spec_id">
                <option value="0">全部</option>
                <?php foreach ($specs as $sp): ?>
                <option value="<?php echo (int) $sp['id']; ?>"<?php if ($specId === (int) $sp['id']): ?> selected<?php endif; ?>><?php echo h($sp['spec_name']); ?></option>
                <?php endforeach; ?>
            </select>
        </div>
    </div>
    <div class="row">
        <div>
            <label>入库类型</label>
            <select name="in_type">
                <option value="">全部</option>
                <?php foreach ($inTypeOpts as $it): ?>
                <option value="<?php echo h($it); ?>"<?php if ($inType === $it): ?> selected<?php endif; ?>><?php echo h($it); ?></option>
                <?php endforeach; ?>
            </select>
        </div>
        <div><label>小包装批次号（模糊）</label><input type="text" name="pkg" value="<?php echo h($pkg); ?>"></div>
        <div><label>来源成品出库单号（模糊）</label><input type="text" name="src_order" value="<?php echo h($srcOrder); ?>"></div>
    </div>
    <p class="filter-actions-row"><button type="submit" class="btn btn-report-submit">查询</button></p>
</form>

<div class="card report-results-card">
    <div class="report-stats" role="status">
        <span class="report-stat"><span class="report-stat-label">批次行数</span><strong><?php echo count($rows); ?></strong></span>
    </div>
    <div class="report-table-shell">
    <div class="table-wrap">
    <table class="table-report">
        <thead>
            <tr>
                <th>小包装批次</th>
                <th>规格</th>
                <th>入库类型</th>
                <th>来源出库单</th>
                <th>入库量</th>
                <th>剩余</th>
                <th>日期</th>
                <th>追溯</th>
            </tr>
        </thead>
        <tbody>
        <?php if (empty($rows)): ?>
            <tr><td colspan="8" class="muted">无匹配数据</td></tr>
        <?php else: ?>
            <?php foreach ($rows as $r): ?>
            <tr>
                <td><strong><?php echo h($r['package_batch_no']); ?></strong></td>
                <td><?php echo h($r['spec_name']); ?></td>
                <td><?php echo h($r['inbound_type']); ?></td>
                <td><?php echo h($r['source_outbound_order_no']); ?></td>
                <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
                <td><?php echo h($r['remaining'] . ' ' . $r['unit']); ?></td>
                <td><?php echo h($r['inbound_date']); ?></td>
                <td><a class="report-link" href="trace.php?pkg=<?php echo h(urlencode($r['package_batch_no'])); ?>">追溯</a></td>
            </tr>
            <?php endforeach; ?>
        <?php endif; ?>
        </tbody>
    </table>
    </div>
    </div>
</div>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/report_sp_outbound.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '小包装出库查询统计';
$pageMainClass = 'page-report page-report--sp-out';

$df = isset($_GET['df']) ? trim($_GET['df']) : '';
$dt = isset($_GET['dt']) ? trim($_GET['dt']) : '';
$customer = isset($_GET['customer']) ? trim($_GET['customer']) : '';
$orderNo = isset($_GET['order_no']) ? trim($_GET['order_no']) : '';
$pkg = isset($_GET['pkg']) ? trim($_GET['pkg']) : '';
$specId = isset($_GET['spec_id']) ? (int) $_GET['spec_id'] : 0;

$where = array('1=1');
$params = array();
if ($df !== '') {
    $where[] = 'o.outbound_date >= ?';
    $params[] = $df;
}
if ($dt !== '') {
    $where[] = 'o.outbound_date <= ?';
    $params[] = $dt;
}
if ($customer !== '') {
    $where[] = 'o.customer LIKE ?';
    $params[] = '%' . $customer . '%';
}
if ($orderNo !== '') {
    $where[] = 'o.outbound_order_no LIKE ?';
    $params[] = '%' . $orderNo . '%';
}
if ($pkg !== '') {
    $where[] = 'o.package_batch_no LIKE ?';
    $params[] = '%' . $pkg . '%';
}
if ($specId > 0) {
    $where[] = 'o.spec_id = ?';
    $params[] = $specId;
}

$sql = 'SELECT o.*, s.spec_name
    FROM small_package_outbound o
    INNER JOIN small_package_specs s ON s.id = o.spec_id
    WHERE ' . implode(' AND ', $where) . '
    ORDER BY o.outbound_date DESC, o.outbound_order_no DESC, o.id DESC
    LIMIT 1200';
$st = $pdo->prepare($sql);
$st->execute($params);
$rows = $st->fetchAll();

$sum = 0.0;
foreach ($rows as $r) {
    $sum += (float) $r['quantity'];
}

$specs = $pdo->query('SELECT id, spec_name FROM small_package_specs ORDER BY spec_name')->fetchAll();

require __DIR__ . '/layout.php';
?>
<header class="report-page-header">
    <span class="report-badge">小包装出</span>
    <h1>小包装出库查询统计</h1>
    <p class="muted report-lead">对外发货明细；批次溯源见 <a href="trace.php">追溯查询</a>。</p>
</header>

<form method="get" class="card filter-card">
    <h2 class="filter-card-title">筛选条件</h2>
    <div class="row">
        <div><label>出库日期从</label><input type="date" name="df" value="<?php echo h($df); ?>"></div>
        <div><label>到</label><input type="date" name="dt" value="<?php echo h($dt); ?>"></div>
        <div>
            <label>规格</label>
            <select name="spec_id">
                <option value="0">全部</option>
                <?php foreach ($specs as $sp): ?>
                <option value="<?php echo (int) $sp['id']; ?>"<?php if ($specId === (int) $sp['id']): ?> selected<?php endif; ?>><?php echo h($sp['spec_name']); ?></option>
                <?php endforeach; ?>
            </select>
        </div>
    </div>
    <div class="row">
        <div><label>客户（模糊）</label><input type="text" name="customer" value="<?php echo h($customer); ?>"></div>
        <div><label>小包装出库单号（模糊）</label><input type="text" name="order_no" value="<?php echo h($orderNo); ?>"></div>
        <div><label>小包装批次号（模糊）</label><input type="text" name="pkg" value="<?php echo h($pkg); ?>"></div>
    </div>
    <p class="filter-actions-row"><button type="submit" class="btn btn-report-submit">查询</button></p>
</form>

<div class="card report-results-card">
    <div class="report-stats" role="status">
        <span class="report-stat"><span class="report-stat-label">行数</span><strong><?php echo count($rows); ?></strong></span>
        <span class="report-stat"><span class="report-stat-label">出库合计</span><strong><?php echo h($sum); ?></strong></span>
    </div>
    <div class="report-table-shell">
    <div class="table-wrap">
    <table class="table-report">
        <thead>
            <tr>
                <th>出库单号</th>
                <th>小包装批次</th>
                <th>规格</th>
                <th>客户</th>
                <th>数量</th>
                <th>日期</th>
                <th>追溯</th>
            </tr>
        </thead>
        <tbody>
        <?php if (empty($rows)): ?>
            <tr><td colspan="7" class="muted">无匹配数据</td></tr>
        <?php else: ?>
            <?php foreach ($rows as $r): ?>
            <tr>
                <td><?php echo h($r['outbound_order_no']); ?></td>
                <td><strong><?php echo h($r['package_batch_no']); ?></strong></td>
                <td><?php echo h($r['spec_name']); ?></td>
                <td><?php echo h($r['customer']); ?></td>
                <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
                <td><?php echo h($r['outbound_date']); ?></td>
                <td><a class="report-link" href="trace.php?pkg=<?php echo h(urlencode($r['package_batch_no'])); ?>">追溯</a></td>
            </tr>
            <?php endforeach; ?>
        <?php endif; ?>
        </tbody>
    </table>
    </div>
    </div>
</div>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/router.php
────────────────────────────
<?php
/**
 * 内置服务器（避免根路径落到目录列表）：
 * php -S localhost:8080 -t public public/router.php
 * 工作目录：traceability
 */
$uri = urldecode(parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH));
$path = __DIR__ . $uri;
if ($uri !== '/' && file_exists($path) && !is_dir($path)) {
    return false;
}
require __DIR__ . '/index.php';

文件路径: /mnt/mmcblk2p4/www/traceability/public/sales.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '销售出库';
$fgCats = trace_sales_fg_categories();
$outTypes = trace_sales_outbound_types();
$spSpecsList = $pdo->query(
    'SELECT id, spec_code, spec_name, unit, fg_qty_per_package FROM small_package_specs ORDER BY spec_name'
)->fetchAll();

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $fgCat = isset($_POST['fg_category']) ? trim($_POST['fg_category']) : '';
    $outboundType = isset($_POST['outbound_type']) ? trim($_POST['outbound_type']) : '';
    if ($outboundType === '再加工') {
        $outboundType = '转小包装';
    }
    $customer = isset($_POST['customer']) ? trim($_POST['customer']) : '';
    $quantity = isset($_POST['quantity']) ? $_POST['quantity'] : '';
    $outboundDate = isset($_POST['outbound_date']) ? trim($_POST['outbound_date']) : '';

    $spSpecIds = isset($_POST['sp_spec_id']) && is_array($_POST['sp_spec_id']) ? $_POST['sp_spec_id'] : array();
    $spQtys = isset($_POST['sp_quantity']) && is_array($_POST['sp_quantity']) ? $_POST['sp_quantity'] : array();
    $repackLines = array();
    $need = null;

    if ($outboundDate === '') {
        $outboundDate = date('Y-m-d');
    }

    $lineType = isset($fgCats[$fgCat]) ? $fgCats[$fgCat] : null;

    if ($lineType === null) {
        flash_set('请选择成品类型（粉剂 / 水剂）。', 'error');
    } elseif (!in_array($outboundType, $outTypes, true)) {
        flash_set('请选择有效的出库类型。', 'error');
    } elseif ($customer === '') {
        flash_set('请填写客户（转小包装可填内部单位或仓库）。', 'error');
    } elseif (trace_sales_is_transfer_small_pack($outboundType)) {
        $n = max(count($spSpecIds), count($spQtys));
        for ($i = 0; $i < $n; $i++) {
            $sid = isset($spSpecIds[$i]) ? (int) $spSpecIds[$i] : 0;
            $sq = isset($spQtys[$i]) ? $spQtys[$i] : '';
            if ($sid <= 0 && (string) $sq === '') {
                continue;
            }
            if ($sid <= 0 || !is_numeric($sq) || (float) $sq <= 0) {
                flash_set('转小包装：每一行有数据时须选择规格并填写大于 0 的箱数（或规格单位数量）。', 'error');
                $repackLines = null;
                break;
            }
            $stsp = $pdo->prepare('SELECT id, unit FROM small_package_specs WHERE id = ? LIMIT 1');
            $stsp->execute(array($sid));
            $spRow = $stsp->fetch();
            if (!$spRow) {
                flash_set('转小包装：规格不存在（ID ' . $sid . '）。', 'error');
                $repackLines = null;
                break;
            }
            $repackLines[] = array(
                'spec_id' => $sid,
                'qty' => (float) $sq,
                'unit' => $spRow['unit'],
            );
        }
        if ($repackLines !== null && empty($repackLines)) {
            flash_set('转小包装须至少填写一行（规格 + 箱数）。', 'error');
            $repackLines = null;
        } elseif ($repackLines !== null) {
            $stSpec = $pdo->prepare(
                'SELECT spec_name, fg_qty_per_package FROM small_package_specs WHERE id = ? LIMIT 1'
            );
            $needCalc = 0.0;
            foreach ($repackLines as $rl) {
                $stSpec->execute(array($rl['spec_id']));
                $sr = $stSpec->fetch();
                if (!$sr || (float) $sr['fg_qty_per_package'] <= 0) {
                    flash_set(
                        '转小包装：规格「' . ($sr ? $sr['spec_name'] : '') . '」未设置「每箱重量（kg）」或值为 0。请在「小包装规格」中维护。',
                        'error'
                    );
                    $repackLines = null;
                    break;
                }
                $needCalc += $rl['qty'] * (float) $sr['fg_qty_per_package'];
            }
            if ($repackLines !== null) {
                if ($needCalc <= 0) {
                    flash_set('转小包装：折合成品出库量（箱数×每箱 kg）无效。', 'error');
                    $repackLines = null;
                } else {
                    $need = $needCalc;
                }
            }
        }
    } else {
        if (!is_numeric($quantity) || (float) $quantity <= 0) {
            flash_set('成品出库数量须为大于 0 的数字（默认单位为 kg，不是箱）。', 'error');
        } else {
            $need = (float) $quantity;
        }
    }

    if ($lineType !== null && in_array($outboundType, $outTypes, true) && $customer !== ''
        && $need !== null && $need > 0 && $repackLines !== null
        && (!trace_sales_is_transfer_small_pack($outboundType) || !empty($repackLines))
    ) {
        $alloc = trace_sales_fifo_allocate($pdo, $lineType, $need);

        if ($alloc === false) {
            flash_set('该类别下各成品批次单位不一致，无法按总量合并出库。请统一单位或分次出库。', 'error');
        } elseif ($alloc === null) {
            flash_set('库存不足：当前「' . $fgCat . '」可出数量小于 ' . $need . '。', 'error');
        } else {
            $orderNo = generate_outbound_order_no($pdo, $outboundDate);
            $pdo->beginTransaction();
            try {
                $stmt = $pdo->prepare(
                    'INSERT INTO sales_outbound (outbound_order_no, finished_batch_no, customer, quantity, unit, outbound_date, outbound_type)
                     VALUES (?,?,?,?,?,?,?)'
                );
                foreach ($alloc as $a) {
                    $stmt->execute(array(
                        $orderNo,
                        $a['batch_no'],
                        $customer,
                        $a['quantity'],
                        $a['unit'],
                        $outboundDate,
                        $outboundType,
                    ));
                }

                $spMsgs = array();
                if (trace_sales_is_transfer_small_pack($outboundType) && !empty($repackLines)) {
                    $insPb = $pdo->prepare(
                        'INSERT INTO small_package_batches (package_batch_no, spec_id, quantity, unit, inbound_date, inbound_type, source_outbound_order_no, note)
                         VALUES (?,?,?,?,?,?,?,?)'
                    );
                    foreach ($repackLines as $rl) {
                        $pbn = generate_small_package_batch_no($pdo, $outboundDate);
                        $insPb->execute(array(
                            $pbn,
                            $rl['spec_id'],
                            $rl['qty'],
                            $rl['unit'],
                            $outboundDate,
                            '销售转入',
                            $orderNo,
                            '',
                        ));
                        $spMsgs[] = $pbn . ' × ' . $rl['qty'] . $rl['unit'];
                    }
                }

                $pdo->commit();
                $parts = array();
                foreach ($alloc as $a) {
                    $parts[] = $a['batch_no'] . ' × ' . $a['quantity'] . $a['unit'];
                }
                $msg = '出库已记录，单号 ' . $orderNo . '（' . $outboundType . '）。成品 FIFO：' . implode('；', $parts);
                if (!empty($spMsgs)) {
                    $msg .= '。小包装已入库：' . implode('；', $spMsgs);
                }
                flash_set($msg, 'success');
                header('Location: sales.php');
                exit;
            } catch (PDOException $e) {
                $pdo->rollBack();
                if (strpos($e->getMessage(), 'UNIQUE') !== false) {
                    flash_set('单号冲突，请重试保存。', 'error');
                } else {
                    flash_set('保存失败：' . $e->getMessage(), 'error');
                }
            }
        }
    }
}

$list = $pdo->query(
    'SELECT s.*, p.line_type
     FROM sales_outbound s
     INNER JOIN finished_goods f ON f.batch_no = s.finished_batch_no
     LEFT JOIN production_batches p ON p.batch_no = f.batch_no
     ORDER BY s.outbound_date DESC, s.outbound_order_no DESC, s.id DESC
     LIMIT 200'
)->fetchAll();

$stockPayload = array();
foreach ($fgCats as $label => $lt) {
    $lines = trace_sales_fifo_batches($pdo, $lt);
    $total = 0.0;
    $units = array();
    foreach ($lines as $L) {
        $total += (float) $L['remaining'];
        $units[$L['unit']] = true;
    }
    $stockPayload[$label] = array(
        'lines' => $lines,
        'total' => $total,
        'unit' => count($units) === 1 && !empty($lines) ? $lines[0]['unit'] : (count($units) === 0 ? 'kg' : '—'),
        'unit_conflict' => count($units) > 1,
    );
}

$specFactorsForJs = array();
foreach ($spSpecsList as $sp) {
    $specFactorsForJs[(string) (int) $sp['id']] = array(
        'per' => isset($sp['fg_qty_per_package']) ? (float) $sp['fg_qty_per_package'] : 0.0,
        'spUnit' => isset($sp['unit']) ? $sp['unit'] : '',
    );
}

require __DIR__ . '/layout.php';
?>
<h1>销售出库</h1>
<p class="muted">全链路数量<strong>默认单位为 kg</strong>（各页可改填其他单位）。本页扣<strong>成品（粉/水剂）</strong>库存；选<strong>转小包装</strong>时按「箱数 × 小包装规格中的每箱 kg」折算成品出库量，并<strong>直接写入小包装库存</strong>（不再使用单独的「小包装入库」页）。小包装对外发货请走<strong><a href="small_outbound.php">小包装出库</a></strong>。</p>
<p class="muted"><strong>出库</strong>：手工填写成品 kg 数。<strong>转小包装</strong>：填写各行箱数，成品扣减 = Σ(箱数 × 每箱 kg)，详见「小包装规格」。</p>

<form method="post" class="card" id="sales-form">
    <h2>新建出库</h2>
    <div class="row">
        <div>
            <label>出库日期（生成单号用）</label>
            <input type="date" name="outbound_date" value="<?php echo h(date('Y-m-d')); ?>">
        </div>
        <div>
            <label>成品类型</label>
            <select name="fg_category" id="sales-fg-category" required>
                <option value="">— 请选择 —</option>
                <?php foreach (array_keys($fgCats) as $lab): ?>
                <option value="<?php echo h($lab); ?>"><?php echo h($lab); ?>（<?php echo h($fgCats[$lab]); ?>）</option>
                <?php endforeach; ?>
            </select>
        </div>
        <div>
            <label>出库类型</label>
            <select name="outbound_type" id="sales-out-type" required>
                <?php foreach ($outTypes as $ot): ?>
                <option value="<?php echo h($ot); ?>"><?php echo h($ot); ?></option>
                <?php endforeach; ?>
            </select>
        </div>
    </div>

    <div id="sales-stock-panel" class="sales-stock-panel" aria-live="polite"></div>

    <div class="row">
        <div>
            <label>客户</label>
            <input type="text" name="customer" required placeholder="客户或转入车间/仓库">
        </div>
        <div id="sales-manual-qty-wrap">
            <label>成品出库总数量（FIFO 拆成品批次）</label>
            <input type="number" name="quantity" id="sales-qty" step="any" min="0" required placeholder="kg（非箱数）">
        </div>
        <div id="sales-auto-qty-wrap" style="display:none;">
            <label>成品出库数量（转小包装自动折算）</label>
            <p class="hint" id="sales-repack-sum" style="margin:0;">选择规格并填写箱数后显示合计 kg。</p>
        </div>
    </div>
    <p><small class="hint" id="sales-unit-hint">单位与明细中成品批次一致；多批次合并时须单位相同。</small></p>

    <div id="sales-repack-wrap" class="repack-panel card" style="display:none;">
        <h3 style="margin-top:0;">转小包装（箱数 → 成品 kg × FIFO）</h3>
        <p class="muted">每行：规格 + <strong>箱数</strong>。成品扣减 kg = Σ(箱数 × 每箱 kg)。保存后每行生成<strong>小包装批次</strong>，入库类型为「销售转入」。</p>
        <?php if (empty($spSpecsList)): ?>
        <div class="flash flash-error">尚未维护小包装规格。请先打开「小包装规格」添加并填写每箱 kg。</div>
        <?php else: ?>
        <div class="table-wrap"><table id="sp-repack-table">
            <thead>
                <tr>
                    <th>小包装规格</th>
                    <th>箱数</th>
                    <th></th>
                </tr>
            </thead>
            <tbody id="sp-repack-tbody">
                <tr class="sp-repack-row">
                    <td>
                        <select name="sp_spec_id[]">
                            <option value="">— 请选择 —</option>
                            <?php foreach ($spSpecsList as $sp): ?>
                            <option value="<?php echo (int) $sp['id']; ?>"><?php echo h($sp['spec_name'] . '（' . $sp['unit'] . '）'); ?></option>
                            <?php endforeach; ?>
                        </select>
                    </td>
                    <td><input type="number" name="sp_quantity[]" step="any" min="0" placeholder="箱数"></td>
                    <td><button type="button" class="btn btn-secondary sp-repack-del" disabled>删</button></td>
                </tr>
            </tbody>
        </table></div>
        <p><button type="button" class="btn btn-secondary" id="sp-repack-add">加一行</button></p>
        <?php endif; ?>
    </div>

    <p><button type="submit" class="btn" id="sales-submit">保存并生成出库单号</button></p>
</form>

<h2>最近记录</h2>
<div class="table-wrap"><table>
    <thead>
        <tr>
            <th>出库单号</th>
            <th>类型</th>
            <th>品类</th>
            <th>成品批次号</th>
            <th>客户</th>
            <th>数量</th>
            <th>出库日期</th>
        </tr>
    </thead>
    <tbody>
    <?php if (empty($list)): ?>
        <tr><td colspan="7" class="muted">暂无数据</td></tr>
    <?php else: ?>
        <?php foreach ($list as $r): ?>
            <?php
            $lt = isset($r['line_type']) ? $r['line_type'] : '';
            $catShow = ($lt === '粉剂填料') ? '粉剂' : (($lt === '水剂填料') ? '水剂' : ($lt !== '' ? $lt : '—'));
            $ot = isset($r['outbound_type']) ? $r['outbound_type'] : '出库';
            ?>
        <tr>
            <td><?php echo h($r['outbound_order_no']); ?></td>
            <td><?php echo h($ot); ?></td>
            <td><?php echo h($catShow); ?></td>
            <td><strong><?php echo h($r['finished_batch_no']); ?></strong></td>
            <td><?php echo h($r['customer']); ?></td>
            <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
            <td><?php echo h($r['outbound_date']); ?></td>
        </tr>
        <?php endforeach; ?>
    <?php endif; ?>
    </tbody>
</table></div>

<script>
(function () {
    var STOCK = <?php echo json_encode($stockPayload, JSON_UNESCAPED_UNICODE); ?>;
    var SPEC_FACTORS = <?php echo json_encode($specFactorsForJs, JSON_UNESCAPED_UNICODE); ?>;
    var catSel = document.getElementById('sales-fg-category');
    var panel = document.getElementById('sales-stock-panel');
    var hint = document.getElementById('sales-unit-hint');
    var submitBtn = document.getElementById('sales-submit');
    var outType = document.getElementById('sales-out-type');
    var repackWrap = document.getElementById('sales-repack-wrap');
    var manualQtyWrap = document.getElementById('sales-manual-qty-wrap');
    var autoQtyWrap = document.getElementById('sales-auto-qty-wrap');
    var qtyInp = document.getElementById('sales-qty');
    var repackSumEl = document.getElementById('sales-repack-sum');

    function renderStock() {
        var cat = catSel.value;
        if (!cat || !STOCK[cat]) {
            panel.innerHTML = '';
            hint.textContent = '单位与明细中成品批次一致；多批次合并时须单位相同。';
            submitBtn.disabled = false;
            syncOutboundQtyUi();
            return;
        }
        var d = STOCK[cat];
        if (d.unit_conflict) {
            panel.innerHTML = '<div class="flash flash-error">该类别下成品批次单位不一致，无法使用合并出库，请先统一单位或联系管理员。</div>';
            hint.textContent = '';
            submitBtn.disabled = true;
            syncOutboundQtyUi();
            return;
        }
        submitBtn.disabled = false;
        var rows = '';
        for (var i = 0; i < d.lines.length; i++) {
            var L = d.lines[i];
            rows += '<tr><td>' + escapeHtml(L.batch_no) + '</td><td>' + escapeHtml(L.product_name) + '</td><td>' + escapeHtml(L.production_date) + '</td><td>' + escapeHtml(String(L.inbound_qty)) + '</td><td><strong>' + escapeHtml(String(L.remaining)) + '</strong></td><td>' + escapeHtml(L.unit) + '</td></tr>';
        }
        if (!rows) {
            panel.innerHTML = '<div class="flash flash-info">当前无可用库存（该类型成品已全部出完或未做成品入库）。</div>';
            hint.textContent = '可出合计：0（单位：' + d.unit + '）';
            submitBtn.disabled = true;
            syncOutboundQtyUi();
            return;
        }
        panel.innerHTML =
            '<h3 style="margin:0.75rem 0 0.5rem;font-size:1rem;">「' + escapeHtml(cat) + '」可出库存</h3>' +
            '<p class="muted" style="margin:0 0 0.5rem;">FIFO 顺序：生产日期早的优先（表格自上而下）。<strong>可出合计：' + escapeHtml(String(d.total)) + ' ' + escapeHtml(d.unit) + '</strong></p>' +
            '<table><thead><tr><th>成品批次号</th><th>成品名称</th><th>生产日期</th><th>入库数量</th><th>剩余可出</th><th>单位</th></tr></thead><tbody>' + rows + '</tbody></table>';
        if (traceSalesTransfer()) {
            hint.textContent = '转小包装：成品扣减 kg = Σ(箱数 × 每箱 kg)；显示单位：' + d.unit + '。';
        } else {
            hint.textContent = '请填写不超过「可出合计」的成品数量；默认 kg；不是箱数。';
        }
        syncOutboundQtyUi();
    }

    function escapeHtml(s) {
        var t = document.createTextNode(s);
        var div = document.createElement('div');
        div.appendChild(t);
        return div.innerHTML;
    }

    function updateRepackComputed() {
        if (!repackSumEl || !traceSalesTransfer()) return;
        var cat = catSel.value;
        var fgUnit = (cat && STOCK[cat] && STOCK[cat].unit && !STOCK[cat].unit_conflict) ? STOCK[cat].unit : '';
        var sum = 0;
        var anyLine = false;
        var missingConvert = false;
        document.querySelectorAll('#sp-repack-tbody .sp-repack-row').forEach(function (tr) {
            var sel = tr.querySelector('select[name="sp_spec_id[]"]');
            var inp = tr.querySelector('input[name="sp_quantity[]"]');
            if (!sel || !inp) return;
            var id = sel.value;
            var raw = String(inp.value || '').trim();
            if (!id && raw === '') return;
            anyLine = true;
            var q = parseFloat(raw.replace(',', '.'));
            if (!id || isNaN(q) || q <= 0) return;
            var f = SPEC_FACTORS[id];
            if (!f || f.per <= 0) {
                missingConvert = true;
                return;
            }
            sum += q * f.per;
        });
        if (!anyLine) {
            repackSumEl.textContent = '请至少填写一行小包装规格与数量。';
            return;
        }
        if (missingConvert && sum <= 0) {
            repackSumEl.textContent = '有行规格未设置「每箱 kg」，请到「小包装规格」维护。';
            return;
        }
        var rounded = Math.round(sum * 1e6) / 1e6;
        if (fgUnit) {
            repackSumEl.textContent = '成品出库合计（FIFO）：' + rounded + ' ' + fgUnit;
        } else {
            repackSumEl.textContent = '成品出库合计（FIFO）：' + rounded + '（请先选成品类型）';
        }
    }

    function syncOutboundQtyUi() {
        if (!manualQtyWrap || !autoQtyWrap || !qtyInp) return;
        if (traceSalesTransfer()) {
            manualQtyWrap.style.display = 'none';
            autoQtyWrap.style.display = 'block';
            qtyInp.removeAttribute('required');
            qtyInp.value = '';
            updateRepackComputed();
        } else {
            manualQtyWrap.style.display = 'block';
            autoQtyWrap.style.display = 'none';
            qtyInp.setAttribute('required', 'required');
        }
    }

    function toggleRepack() {
        if (!repackWrap) return;
        repackWrap.style.display = traceSalesTransfer() ? 'block' : 'none';
        syncOutboundQtyUi();
        if (!traceSalesTransfer() && hint && catSel.value && STOCK[catSel.value] && !STOCK[catSel.value].unit_conflict) {
            var d = STOCK[catSel.value];
            hint.textContent = '请填写不超过「可出合计」的成品数量；单位：' + d.unit + '。';
        }
    }

    function traceSalesTransfer() {
        return outType.value === '转小包装' || outType.value === '再加工';
    }

    catSel.addEventListener('change', function () { renderStock(); updateRepackComputed(); });
    outType.addEventListener('change', function () { renderStock(); toggleRepack(); updateRepackComputed(); });
    renderStock();
    toggleRepack();

    var spTbody = document.getElementById('sp-repack-tbody');
    var spAdd = document.getElementById('sp-repack-add');
    if (spTbody) {
        spTbody.addEventListener('change', updateRepackComputed);
        spTbody.addEventListener('input', updateRepackComputed);
    }
    if (spTbody && spAdd) {
        var spTemplate = spTbody.querySelector('.sp-repack-row');
        spAdd.onclick = function () {
            var tr = spTemplate.cloneNode(true);
            tr.querySelectorAll('select').forEach(function (s) { s.selectedIndex = 0; });
            tr.querySelectorAll('input').forEach(function (i) { i.value = ''; });
            tr.querySelector('.sp-repack-del').disabled = false;
            spTbody.appendChild(tr);
            bindSpDel(tr);
            updateRepackComputed();
        };
        function bindSpDel(tr) {
            tr.querySelector('.sp-repack-del').onclick = function () {
                if (spTbody.querySelectorAll('.sp-repack-row').length > 1) {
                    tr.remove();
                    updateRepackComputed();
                }
            };
        }
        bindSpDel(spTemplate);
    }
})();
</script>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/small_inbound.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '小包装入库';
$inTypes = trace_small_package_manual_inbound_types();

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $inDate = isset($_POST['inbound_date']) ? trim($_POST['inbound_date']) : '';
    $inType = isset($_POST['inbound_type']) ? trim($_POST['inbound_type']) : '';
    $specIds = isset($_POST['spec_id']) && is_array($_POST['spec_id']) ? $_POST['spec_id'] : array();
    $qtys = isset($_POST['quantity']) && is_array($_POST['quantity']) ? $_POST['quantity'] : array();
    $units = isset($_POST['unit']) && is_array($_POST['unit']) ? $_POST['unit'] : array();
    $notes = isset($_POST['line_note']) && is_array($_POST['line_note']) ? $_POST['line_note'] : array();

    if ($inDate === '') {
        $inDate = date('Y-m-d');
    }

    if (!in_array($inType, $inTypes, true)) {
        flash_set('请选择入库类型。', 'error');
    } else {
        $n = max(count($specIds), count($qtys));
        $lines = array();
        $stsp = $pdo->prepare('SELECT id, unit FROM small_package_specs WHERE id = ? LIMIT 1');

        for ($i = 0; $i < $n; $i++) {
            $sid = isset($specIds[$i]) ? (int) $specIds[$i] : 0;
            $q = isset($qtys[$i]) ? $qtys[$i] : '';
            $uIn = isset($units[$i]) ? trim($units[$i]) : '';
            $lnote = isset($notes[$i]) ? trim($notes[$i]) : '';

            if ($sid <= 0 && (string) $q === '') {
                continue;
            }
            if ($sid <= 0 || !is_numeric($q) || (float) $q <= 0) {
                flash_set('每一行有数据时须选择规格并填写大于 0 的数量。', 'error');
                $lines = null;
                break;
            }
            $stsp->execute(array($sid));
            $sp = $stsp->fetch();
            if (!$sp) {
                flash_set('存在无效的规格。', 'error');
                $lines = null;
                break;
            }
            $u = $uIn !== '' ? $uIn : $sp['unit'];
            $lines[] = array('spec_id' => $sid, 'qty' => (float) $q, 'unit' => $u, 'note' => $lnote);
        }

        if ($lines === null) {
            // flash set above
        } elseif (empty($lines)) {
            flash_set('请至少填写一行（规格 + 数量）。', 'error');
        } else {
            $pdo->beginTransaction();
            try {
                $ins = $pdo->prepare(
                    'INSERT INTO small_package_batches (package_batch_no, spec_id, quantity, unit, inbound_date, inbound_type, source_outbound_order_no, note)
                     VALUES (?,?,?,?,?,?,?,?)'
                );
                $saved = array();
                foreach ($lines as $line) {
                    $pb = generate_small_package_batch_no($pdo, $inDate);
                    $ins->execute(array(
                        $pb,
                        $line['spec_id'],
                        $line['qty'],
                        $line['unit'],
                        $inDate,
                        $inType,
                        '',
                        $line['note'],
                    ));
                    $saved[] = $pb;
                }
                $pdo->commit();
                flash_set('已入库 ' . count($saved) . ' 笔小包装批次：' . implode('、', $saved), 'success');
                header('Location: small_inbound.php');
                exit;
            } catch (PDOException $e) {
                $pdo->rollBack();
                flash_set('保存失败：' . $e->getMessage(), 'error');
            }
        }
    }
}

$specs = $pdo->query('SELECT id, spec_code, spec_name, unit FROM small_package_specs ORDER BY spec_name')->fetchAll();

$list = $pdo->query(
    'SELECT b.*, s.spec_name, s.spec_code
     FROM small_package_batches b
     INNER JOIN small_package_specs s ON s.id = b.spec_id
     ORDER BY b.inbound_date DESC, b.id DESC
     LIMIT 150'
)->fetchAll();

require __DIR__ . '/layout.php';
?>
<h1>小包装入库（采购 / 其他）</h1>
<p class="muted"><strong>再加工</strong>产生的小包装由「销售出库」自动入库。此处可<strong>一次录入多行</strong>，每行可为<strong>不同规格</strong>；入库日期与入库类型本单共用，每行生成独立小包装批次号。此类库存出库请使用<strong><a href="small_outbound.php">小包装出库</a></strong>（「销售出库」只扣成品，不会动小包装）。批次溯源见<strong><a href="small_trace.php">小包装溯源</a></strong>。</p>

<form method="post" class="card">
    <h2>新建入库（多行）</h2>
    <div class="row">
        <div>
            <label>入库类型（本单共用）</label>
            <select name="inbound_type" required>
                <?php foreach ($inTypes as $t): ?>
                <option value="<?php echo h($t); ?>"><?php echo h($t); ?></option>
                <?php endforeach; ?>
            </select>
        </div>
        <div>
            <label>入库日期（本单共用）</label>
            <input type="date" name="inbound_date" value="<?php echo h(date('Y-m-d')); ?>">
        </div>
    </div>

    <table id="sp-in-lines" style="margin-top:1rem;">
        <thead>
            <tr>
                <th>规格</th>
                <th>数量</th>
                <th>单位（可空）</th>
                <th>行备注</th>
                <th></th>
            </tr>
        </thead>
        <tbody>
            <tr class="sp-in-row">
                <td>
                    <select name="spec_id[]">
                        <option value="">— 请选择 —</option>
                        <?php foreach ($specs as $s): ?>
                        <option value="<?php echo (int) $s['id']; ?>"><?php echo h($s['spec_name'] . '（' . $s['unit'] . '）'); ?></option>
                        <?php endforeach; ?>
                    </select>
                </td>
                <td><input type="number" name="quantity[]" step="any" min="0" placeholder="数量"></td>
                <td><input type="text" name="unit[]" placeholder="默认规格单位" style="max-width:100px;"></td>
                <td><input type="text" name="line_note[]" placeholder="可选"></td>
                <td><button type="button" class="btn btn-secondary sp-in-remove" disabled>删</button></td>
            </tr>
        </tbody>
    </table>
    <p>
        <button type="button" class="btn btn-secondary" id="sp-in-add">加一行</button>
        <button type="submit" class="btn">保存本单全部行</button>
    </p>
</form>

<?php if (empty($specs)): ?>
<div class="flash flash-info">请先在「小包装规格」中维护规格。</div>
<?php endif; ?>

<h2>最近入库记录</h2>
<table>
    <thead>
        <tr>
            <th>小包装批次号</th>
            <th>规格</th>
            <th>入库类型</th>
            <th>数量</th>
            <th>入库日期</th>
            <th>来源成品出库单</th>
            <th>溯源</th>
        </tr>
    </thead>
    <tbody>
    <?php if (empty($list)): ?>
        <tr><td colspan="7" class="muted">暂无数据</td></tr>
    <?php else: ?>
        <?php foreach ($list as $r): ?>
        <tr>
            <td><strong><?php echo h($r['package_batch_no']); ?></strong></td>
            <td><?php echo h($r['spec_name']); ?></td>
            <td><?php echo h($r['inbound_type']); ?></td>
            <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
            <td><?php echo h($r['inbound_date']); ?></td>
            <td><?php echo h($r['source_outbound_order_no']); ?></td>
            <td><a href="small_trace.php?pkg=<?php echo h(urlencode($r['package_batch_no'])); ?>">查看</a></td>
        </tr>
        <?php endforeach; ?>
    <?php endif; ?>
    </tbody>
</table>

<script>
(function () {
    var tbody = document.querySelector('#sp-in-lines tbody');
    if (!tbody) return;
    var template = tbody.querySelector('.sp-in-row');
    document.getElementById('sp-in-add').onclick = function () {
        var tr = template.cloneNode(true);
        tr.querySelectorAll('select').forEach(function (s) { s.selectedIndex = 0; });
        tr.querySelectorAll('input').forEach(function (i) { i.value = ''; });
        tr.querySelector('.sp-in-remove').disabled = false;
        tbody.appendChild(tr);
        bindRemove(tr);
    };
    function bindRemove(tr) {
        tr.querySelector('.sp-in-remove').onclick = function () {
            if (tbody.querySelectorAll('.sp-in-row').length > 1) tr.remove();
        };
    }
    bindRemove(template);
})();
</script>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/small_outbound.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '小包装出库';

$specs = $pdo->query('SELECT id, spec_code, spec_name, unit FROM small_package_specs ORDER BY spec_name')->fetchAll();

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $customer = isset($_POST['customer']) ? trim($_POST['customer']) : '';
    $outDate = isset($_POST['outbound_date']) ? trim($_POST['outbound_date']) : '';
    $specIds = isset($_POST['spec_id']) && is_array($_POST['spec_id']) ? $_POST['spec_id'] : array();
    $qtys = isset($_POST['quantity']) && is_array($_POST['quantity']) ? $_POST['quantity'] : array();

    if ($outDate === '') {
        $outDate = date('Y-m-d');
    }

    if ($customer === '') {
        flash_set('请填写客户。', 'error');
    } else {
        $n = max(count($specIds), count($qtys));
        $lines = array();
        $specNameById = array();
        foreach ($specs as $sx) {
            $specNameById[(int) $sx['id']] = $sx['spec_name'];
        }

        for ($i = 0; $i < $n; $i++) {
            $sid = isset($specIds[$i]) ? (int) $specIds[$i] : 0;
            $q = isset($qtys[$i]) ? $qtys[$i] : '';
            if ($sid <= 0 && (string) $q === '') {
                continue;
            }
            if ($sid <= 0 || !is_numeric($q) || (float) $q <= 0) {
                flash_set('每一行有数据时须选择规格并填写大于 0 的数量。', 'error');
                $lines = null;
                break;
            }
            if (!isset($specNameById[$sid])) {
                flash_set('存在无效的规格。', 'error');
                $lines = null;
                break;
            }
            $lines[] = array('spec_id' => $sid, 'qty' => (float) $q);
        }

        if ($lines === null) {
            // flash above
        } elseif (empty($lines)) {
            flash_set('请至少填写一行（规格 + 出库数量）。', 'error');
        } else {
            $pdo->beginTransaction();
            try {
                $orderNo = generate_small_package_outbound_order_no($pdo, $outDate);
                $ins = $pdo->prepare(
                    'INSERT INTO small_package_outbound (outbound_order_no, package_batch_no, spec_id, quantity, unit, customer, outbound_date)
                     VALUES (?,?,?,?,?,?,?)'
                );
                $summaryParts = array();

                foreach ($lines as $idx => $line) {
                    $alloc = trace_sp_fifo_allocate($pdo, $line['spec_id'], $line['qty']);
                    $sname = $specNameById[$line['spec_id']];
                    if ($alloc === false) {
                        throw new RuntimeException('规格「' . $sname . '」下各批次单位不一致，无法出库。');
                    }
                    if ($alloc === null) {
                        throw new RuntimeException('规格「' . $sname . '」库存不足，需要 ' . $line['qty'] . '。');
                    }
                    foreach ($alloc as $a) {
                        $ins->execute(array(
                            $orderNo,
                            $a['package_batch_no'],
                            $a['spec_id'],
                            $a['quantity'],
                            $a['unit'],
                            $customer,
                            $outDate,
                        ));
                    }
                    $sub = array();
                    foreach ($alloc as $a) {
                        $sub[] = $a['package_batch_no'] . '×' . $a['quantity'] . $a['unit'];
                    }
                    $summaryParts[] = $sname . '：' . implode('；', $sub);
                }

                $pdo->commit();
                flash_set('小包装出库已记录，单号 ' . $orderNo . '。' . implode(' | ', $summaryParts), 'success');
                header('Location: small_outbound.php');
                exit;
            } catch (RuntimeException $e) {
                $pdo->rollBack();
                flash_set($e->getMessage(), 'error');
            } catch (PDOException $e) {
                $pdo->rollBack();
                flash_set('保存失败：' . $e->getMessage(), 'error');
            }
        }
    }
}

$list = $pdo->query(
    'SELECT o.*, s.spec_name
     FROM small_package_outbound o
     INNER JOIN small_package_specs s ON s.id = o.spec_id
     ORDER BY o.outbound_date DESC, o.outbound_order_no DESC, o.id DESC
     LIMIT 200'
)->fetchAll();

$stockBySpec = array();
foreach ($specs as $s) {
    $lines = trace_sp_fifo_batches($pdo, (int) $s['id']);
    $total = 0.0;
    $units = array();
    foreach ($lines as $L) {
        $total += (float) $L['remaining'];
        $units[$L['unit']] = true;
    }
    $stockBySpec[(string) $s['id']] = array(
        'spec_name' => $s['spec_name'],
        'unit' => $s['unit'],
        'lines' => $lines,
        'total' => $total,
        'unit_conflict' => count($units) > 1,
    );
}

require __DIR__ . '/layout.php';
?>
<h1>小包装出库</h1>
<p class="muted">可<strong>一次多行</strong>：每行选规格并填本行出库数量；系统按行依次<strong>FIFO</strong>扣减库存。<strong>同一出库单号</strong>（SPO-…）下多行明细。扣减后在<strong><a href="trace.php">追溯查询</a></strong>输入小包装批次号查看记录。</p>

<form method="post" class="card" id="sp-out-form">
    <h2>新建出库（多行）</h2>
    <div class="row">
        <div>
            <label>出库日期（本单共用）</label>
            <input type="date" name="outbound_date" value="<?php echo h(date('Y-m-d')); ?>">
        </div>
        <div>
            <label>客户</label>
            <input type="text" name="customer" required>
        </div>
    </div>

    <p class="muted" style="margin-top:0.75rem;">点击下方表格中某一行的「规格」后，此处显示该规格当前可出库存（页面加载时的快照；保存时以服务器实时库存为准）。</p>
    <div id="sp-out-stock-panel" class="sales-stock-panel"></div>

    <table id="sp-out-lines" style="margin-top:1rem;">
        <thead>
            <tr>
                <th>规格</th>
                <th>本行出库数量</th>
                <th></th>
            </tr>
        </thead>
        <tbody id="sp-out-tbody">
            <tr class="sp-out-row">
                <td>
                    <select name="spec_id[]" class="js-sp-out-spec">
                        <option value="">— 请选择 —</option>
                        <?php foreach ($specs as $s): ?>
                        <option value="<?php echo (int) $s['id']; ?>"><?php echo h($s['spec_name'] . '（' . $s['unit'] . '）'); ?></option>
                        <?php endforeach; ?>
                    </select>
                </td>
                <td><input type="number" name="quantity[]" class="sp-out-qty" step="any" min="0" placeholder="数量"></td>
                <td><button type="button" class="btn btn-secondary sp-out-remove" disabled>删</button></td>
            </tr>
        </tbody>
    </table>
    <p>
        <button type="button" class="btn btn-secondary" id="sp-out-add">加一行</button>
        <button type="submit" class="btn" id="sp-out-submit">保存（生成一个出库单号）</button>
    </p>
    <p><small class="hint" id="sp-out-hint">在规格下拉中选择一行即可查看对应库存明细。</small></p>
</form>

<h2>最近出库记录</h2>
<table>
    <thead>
        <tr>
            <th>出库单号</th>
            <th>规格</th>
            <th>小包装批次号</th>
            <th>客户</th>
            <th>数量</th>
            <th>日期</th>
        </tr>
    </thead>
    <tbody>
    <?php if (empty($list)): ?>
        <tr><td colspan="6" class="muted">暂无数据</td></tr>
    <?php else: ?>
        <?php foreach ($list as $r): ?>
        <tr>
            <td><?php echo h($r['outbound_order_no']); ?></td>
            <td><?php echo h($r['spec_name']); ?></td>
            <td><strong><a href="trace.php?pkg=<?php echo h(urlencode($r['package_batch_no'])); ?>"><?php echo h($r['package_batch_no']); ?></a></strong></td>
            <td><?php echo h($r['customer']); ?></td>
            <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
            <td><?php echo h($r['outbound_date']); ?></td>
        </tr>
        <?php endforeach; ?>
    <?php endif; ?>
    </tbody>
</table>

<script>
(function () {
    var STOCK = <?php echo json_encode($stockBySpec, JSON_UNESCAPED_UNICODE); ?>;
    var panel = document.getElementById('sp-out-stock-panel');
    var hint = document.getElementById('sp-out-hint');
    var tbody = document.getElementById('sp-out-tbody');
    var template = tbody.querySelector('.sp-out-row');

    function renderForSpecId(id) {
        if (!id || !STOCK[id]) {
            panel.innerHTML = '';
            hint.textContent = '在规格下拉中选择一行即可查看对应库存明细。';
            return;
        }
        var d = STOCK[id];
        if (d.unit_conflict) {
            panel.innerHTML = '<div class="flash flash-error">该规格下批次单位不一致（列表仅供参考）。</div>';
            hint.textContent = '';
            return;
        }
        var rows = '';
        for (var i = 0; i < d.lines.length; i++) {
            var L = d.lines[i];
            rows += '<tr><td>' + esc(L.package_batch_no) + '</td><td>' + esc(L.inbound_date) + '</td><td>' + esc(String(L.inbound_qty)) + '</td><td><strong>' + esc(String(L.remaining)) + '</strong></td><td>' + esc(L.unit) + '</td></tr>';
        }
        if (!rows) {
            panel.innerHTML = '<div class="flash flash-info">该规格当前无可用库存（列表为打开页面时的快照）。</div>';
            hint.textContent = '可出合计：0 ' + d.unit;
            return;
        }
        panel.innerHTML =
            '<h3 style="margin:0.75rem 0 0.5rem;font-size:1rem;">「' + esc(d.spec_name) + '」可出库存（参考）</h3>' +
            '<p class="muted">FIFO 自上而下。<strong>可出合计：' + esc(String(d.total)) + ' ' + esc(d.unit) + '</strong></p>' +
            '<table><thead><tr><th>小包装批次号</th><th>入库日期</th><th>入库数量</th><th>剩余可出</th><th>单位</th></tr></thead><tbody>' + rows + '</tbody></table>';
        hint.textContent = '单位：' + d.unit + '。多行出库时按表格从上到下的顺序扣库存。';
    }

    function esc(s) {
        var t = document.createTextNode(s);
        var div = document.createElement('div');
        div.appendChild(t);
        return div.innerHTML;
    }

    function bindSpecSelect(sel) {
        sel.addEventListener('change', function () {
            renderForSpecId(sel.value);
        });
    }

    function syncRemoveState() {
        var n = tbody.querySelectorAll('.sp-out-row').length;
        tbody.querySelectorAll('.sp-out-remove').forEach(function (btn) {
            btn.disabled = n <= 1;
        });
    }

    function bindRemove(tr) {
        tr.querySelector('.sp-out-remove').onclick = function () {
            if (tbody.querySelectorAll('.sp-out-row').length > 1) {
                tr.remove();
                syncRemoveState();
            }
        };
    }

    tbody.querySelectorAll('.js-sp-out-spec').forEach(bindSpecSelect);
    bindRemove(template);
    syncRemoveState();

    document.getElementById('sp-out-add').onclick = function () {
        var tr = template.cloneNode(true);
        tr.querySelectorAll('select').forEach(function (s) { s.selectedIndex = 0; });
        tr.querySelectorAll('input').forEach(function (i) { i.value = ''; });
        tbody.appendChild(tr);
        bindSpecSelect(tr.querySelector('.js-sp-out-spec'));
        bindRemove(tr);
        syncRemoveState();
    };
})();
</script>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/small_spec.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '小包装规格';

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'add') {
    $code = isset($_POST['spec_code']) ? trim($_POST['spec_code']) : '';
    $name = isset($_POST['spec_name']) ? trim($_POST['spec_name']) : '';
    $unit = isset($_POST['unit']) ? trim($_POST['unit']) : '箱';
    $kgPerBox = isset($_POST['kg_per_box']) ? $_POST['kg_per_box'] : '0';
    $note = isset($_POST['note']) ? trim($_POST['note']) : '';
    if ($name === '') {
        flash_set('请填写规格名称。', 'error');
    } else {
        try {
            $st = $pdo->prepare(
                'INSERT INTO small_package_specs (spec_code, spec_name, unit, fg_qty_per_package, fg_qty_per_package_unit, note) VALUES (?,?,?,?,?,?)'
            );
            $st->execute(array(
                $code,
                $name,
                $unit !== '' ? $unit : '箱',
                is_numeric($kgPerBox) ? (float) $kgPerBox : 0,
                'kg',
                $note,
            ));
            flash_set('规格已添加。', 'success');
        } catch (PDOException $e) {
            flash_set('保存失败：' . $e->getMessage(), 'error');
        }
    }
    header('Location: small_spec.php');
    exit;
}

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'update_convert') {
    $id = isset($_POST['id']) ? (int) $_POST['id'] : 0;
    $kgPerBox = isset($_POST['kg_per_box']) ? $_POST['kg_per_box'] : '0';
    if ($id <= 0) {
        flash_set('无效记录。', 'error');
    } else {
        try {
            $st = $pdo->prepare(
                'UPDATE small_package_specs SET fg_qty_per_package = ?, fg_qty_per_package_unit = ? WHERE id = ?'
            );
            $st->execute(array(is_numeric($kgPerBox) ? (float) $kgPerBox : 0, 'kg', $id));
            flash_set('每箱 kg 已更新。', 'success');
        } catch (PDOException $e) {
            flash_set('更新失败：' . $e->getMessage(), 'error');
        }
    }
    header('Location: small_spec.php');
    exit;
}

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'delete') {
    $id = isset($_POST['id']) ? (int) $_POST['id'] : 0;
    if ($id > 0) {
        try {
            $pdo->prepare('DELETE FROM small_package_specs WHERE id = ?')->execute(array($id));
            flash_set('已删除。', 'success');
        } catch (PDOException $e) {
            flash_set('删除失败（可能已有小包装批次引用该规格）。', 'error');
        }
    }
    header('Location: small_spec.php');
    exit;
}

$list = $pdo->query('SELECT * FROM small_package_specs ORDER BY spec_name')->fetchAll();

require __DIR__ . '/layout.php';
?>
<h1>小包装规格</h1>
<p class="muted">点数单位一般为<strong>箱</strong>。请维护<strong>每箱对应的成品重量（kg）</strong>：销售出库选「转小包装」时，<strong>成品扣减 kg = 箱数 × 每箱 kg</strong>。全系统成品/原料默认 kg。</p>

<form method="post" class="card">
    <h2>新增规格</h2>
    <input type="hidden" name="action" value="add">
    <div class="row">
        <div>
            <label>规格代码（可选）</label>
            <input type="text" name="spec_code" placeholder="内部编码">
        </div>
        <div>
            <label>规格名称</label>
            <input type="text" name="spec_name" required placeholder="如 300g×30袋/箱">
        </div>
        <div>
            <label>点数单位</label>
            <input type="text" name="unit" value="箱" placeholder="箱">
        </div>
    </div>
    <div class="row">
        <div>
            <label>每箱重量（kg）</label>
            <input type="number" name="kg_per_box" step="any" min="0" value="0" required placeholder="转小包装必填">
            <small class="hint">例：1 箱净重 300kg 则填 300</small>
        </div>
    </div>
    <div>
        <label>备注</label>
        <input type="text" name="note" placeholder="可选">
    </div>
    <p><button type="submit" class="btn">保存</button></p>
</form>

<h2>规格列表</h2>
<div class="table-wrap">
<table>
    <thead>
        <tr>
            <th>ID</th>
            <th>规格名称</th>
            <th>单位</th>
            <th>每箱 kg</th>
            <th>备注</th>
            <th></th>
        </tr>
    </thead>
    <tbody>
    <?php if (empty($list)): ?>
        <tr><td colspan="6" class="muted">暂无规格，请先新增。</td></tr>
    <?php else: ?>
        <?php foreach ($list as $r): ?>
        <tr>
            <td><?php echo (int) $r['id']; ?></td>
            <td><strong><?php echo h($r['spec_name']); ?></strong></td>
            <td><?php echo h($r['unit']); ?></td>
            <td>
                <form method="post" class="inline-form form-inline-kv">
                    <input type="hidden" name="action" value="update_convert">
                    <input type="hidden" name="id" value="<?php echo (int) $r['id']; ?>">
                    <input type="number" name="kg_per_box" step="any" min="0" class="input-narrow"
                        value="<?php echo h(isset($r['fg_qty_per_package']) ? $r['fg_qty_per_package'] : '0'); ?>">
                    <span class="muted">kg / <?php echo h($r['unit']); ?></span>
                    <button type="submit" class="btn btn-secondary">保存</button>
                </form>
            </td>
            <td><?php echo h($r['note']); ?></td>
            <td>
                <form method="post" class="inline-form" onsubmit="return confirm('确定删除？');">
                    <input type="hidden" name="action" value="delete">
                    <input type="hidden" name="id" value="<?php echo (int) $r['id']; ?>">
                    <button type="submit" class="btn btn-secondary">删除</button>
                </form>
            </td>
        </tr>
        <?php endforeach; ?>
    <?php endif; ?>
    </tbody>
</table>
</div>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/small_stock.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '小包装库存';

$rows = $pdo->query(
    'SELECT b.package_batch_no, b.spec_id, s.spec_name, s.spec_code, b.quantity AS inbound_qty, b.unit,
            b.inbound_date, b.inbound_type, b.source_outbound_order_no,
            (b.quantity - COALESCE((SELECT SUM(o.quantity) FROM small_package_outbound o WHERE o.package_batch_no = b.package_batch_no), 0)) AS remaining
     FROM small_package_batches b
     INNER JOIN small_package_specs s ON s.id = b.spec_id
     ORDER BY s.spec_name, b.inbound_date ASC, b.id ASC'
)->fetchAll();

$bySpec = array();
foreach ($rows as $r) {
    $rem = (float) $r['remaining'];
    if ($rem <= 1e-9) {
        continue;
    }
    $sid = (int) $r['spec_id'];
    if (!isset($bySpec[$sid])) {
        $bySpec[$sid] = array(
            'name' => $r['spec_name'],
            'unit' => $r['unit'],
            'total' => 0.0,
            'lines' => array(),
        );
    }
    $bySpec[$sid]['total'] += $rem;
    $r['remaining'] = $rem;
    $bySpec[$sid]['lines'][] = $r;
}

require __DIR__ . '/layout.php';
?>
<h1>小包装库存（按规格汇总）</h1>
<p class="muted">仅列出<strong>剩余可出 &gt; 0</strong>的批次。新数据由<strong>销售出库 → 转小包装</strong>写入。批次溯源在<strong><a href="trace.php">追溯查询</a></strong>输入小包装批次号。</p>

<?php if (empty($bySpec)): ?>
<div class="flash flash-info">当前无在库小包装。请通过销售出库「转小包装」生成库存（历史「采购入库」数据仍可查）。</div>
<?php else: ?>
    <?php foreach ($bySpec as $sid => $grp): ?>
<div class="card" style="margin-bottom:1.25rem;">
    <h2 style="margin-top:0;"><?php echo h($grp['name']); ?> <span class="muted">· 可出合计 <strong><?php echo h($grp['total']); ?></strong> <?php echo h($grp['unit']); ?></span></h2>
    <div class="table-wrap"><table>
        <thead>
            <tr>
                <th>小包装批次号</th>
                <th>入库类型</th>
                <th>入库日期</th>
                <th>入库数量</th>
                <th>剩余可出</th>
                <th>来源成品出库单</th>
                <th>溯源</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($grp['lines'] as $r): ?>
            <tr>
                <td><strong><a href="trace.php?pkg=<?php echo h(urlencode($r['package_batch_no'])); ?>"><?php echo h($r['package_batch_no']); ?></a></strong></td>
                <td><?php echo h($r['inbound_type']); ?></td>
                <td><?php echo h($r['inbound_date']); ?></td>
                <td><?php echo h($r['inbound_qty'] . ' ' . $r['unit']); ?></td>
                <td><?php echo h($r['remaining'] . ' ' . $r['unit']); ?></td>
                <td><?php echo h($r['source_outbound_order_no']); ?></td>
                <td><a href="trace.php?pkg=<?php echo h(urlencode($r['package_batch_no'])); ?>">追溯</a></td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table></div>
</div>
    <?php endforeach; ?>
<?php endif; ?>
<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/small_trace.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '小包装溯源';

$pkg = isset($_GET['pkg']) ? trim($_GET['pkg']) : '';

$batch = null;
$outbounds = array();
$salesFromSource = array();
$remaining = null;

if ($pkg !== '') {
    $st = $pdo->prepare(
        'SELECT b.*, s.spec_name, s.spec_code, s.unit AS spec_unit,
                s.fg_qty_per_package, s.fg_qty_per_package_unit
         FROM small_package_batches b
         INNER JOIN small_package_specs s ON s.id = b.spec_id
         WHERE b.package_batch_no = ?
         LIMIT 1'
    );
    $st->execute(array($pkg));
    $batch = $st->fetch();

    if ($batch) {
        $stO = $pdo->prepare(
            'SELECT o.outbound_order_no, o.customer, o.quantity, o.unit, o.outbound_date,
                    s.spec_name
             FROM small_package_outbound o
             INNER JOIN small_package_specs s ON s.id = o.spec_id
             WHERE o.package_batch_no = ?
             ORDER BY o.outbound_date DESC, o.id DESC'
        );
        $stO->execute(array($pkg));
        $outbounds = $stO->fetchAll();

        $src = isset($batch['source_outbound_order_no']) ? trim($batch['source_outbound_order_no']) : '';
        if ($src !== '') {
            $stS = $pdo->prepare(
                'SELECT outbound_order_no, finished_batch_no, customer, quantity, unit, outbound_date, outbound_type
                 FROM sales_outbound
                 WHERE outbound_order_no = ?
                 ORDER BY id'
            );
            $stS->execute(array($src));
            $salesFromSource = $stS->fetchAll();
        }

        $stRem = $pdo->prepare(
            'SELECT (b.quantity - COALESCE((SELECT SUM(o.quantity) FROM small_package_outbound o WHERE o.package_batch_no = b.package_batch_no), 0)) AS rem
             FROM small_package_batches b WHERE b.package_batch_no = ? LIMIT 1'
        );
        $stRem->execute(array($pkg));
        $rrow = $stRem->fetch();
        if ($rrow) {
            $remaining = (float) $rrow['rem'];
        }
    }
}

require __DIR__ . '/layout.php';
?>
<h1>小包装溯源</h1>
<p class="muted">按<strong>小包装批次号</strong>查看入库信息、关联的成品出库单（再加工来源）及<strong>小包装出库</strong>记录。采购/其他入库的小包装须在「小包装出库」扣账。</p>

<form method="get" class="card" style="padding:1rem;">
    <label>小包装批次号</label>
    <div class="row" style="align-items:flex-end;">
        <div>
            <input type="text" name="pkg" value="<?php echo h($pkg); ?>" placeholder="如 SP-…" style="max-width:360px;">
        </div>
        <div>
            <button type="submit" class="btn">查询</button>
        </div>
    </div>
</form>

<?php if ($pkg !== ''): ?>

<?php if (!$batch): ?>
<div class="flash flash-error">未找到该小包装批次。请从「小包装库存」或入库记录中复制批次号。</div>
<?php else: ?>
<div class="trace-section card">
    <h3>小包装入库</h3>
    <table>
        <tr><th>小包装批次号</th><td><strong><?php echo h($batch['package_batch_no']); ?></strong></td></tr>
        <tr><th>规格</th><td><?php echo h($batch['spec_name']); ?><?php if (!empty($batch['spec_code'])): ?>（<?php echo h($batch['spec_code']); ?>）<?php endif; ?></td></tr>
        <tr><th>入库数量</th><td><?php echo h($batch['quantity'] . ' ' . $batch['unit']); ?></td></tr>
        <tr><th>入库类型</th><td><?php echo h($batch['inbound_type']); ?></td></tr>
        <tr><th>入库日期</th><td><?php echo h($batch['inbound_date']); ?></td></tr>
        <tr><th>备注</th><td><?php echo h($batch['note']); ?></td></tr>
        <tr><th>来源成品出库单</th><td>
            <?php if (!empty($batch['source_outbound_order_no'])): ?>
                <strong><?php echo h($batch['source_outbound_order_no']); ?></strong>
                <span class="muted">（再加工自成品出库）</span>
            <?php else: ?>
                <span class="muted">—（采购/其他入库无关联成品出库单）</span>
            <?php endif; ?>
        </td></tr>
        <?php if ((float) $batch['fg_qty_per_package'] > 0): ?>
        <tr><th>规格折算（参考）</th><td>每 1 <?php echo h($batch['spec_unit']); ?> ≈ <?php echo h($batch['fg_qty_per_package']); ?> <?php echo h($batch['fg_qty_per_package_unit']); ?> 成品</td></tr>
        <?php endif; ?>
        <tr><th>当前剩余可出</th><td><strong><?php echo h($remaining !== null ? $remaining : '—'); ?></strong> <?php echo h($batch['unit']); ?></td></tr>
    </table>
</div>

<?php if (!empty($salesFromSource)): ?>
<div class="trace-section card">
    <h3>关联成品出库明细（同一单号）</h3>
    <p class="muted">再加工时，小包装批次会挂到对应的成品出库单号；可点击成品批次号在「追溯查询」中继续向上游查原料。</p>
    <table>
        <thead>
            <tr>
                <th>成品出库单号</th>
                <th>类型</th>
                <th>成品批次号</th>
                <th>客户</th>
                <th>数量</th>
                <th>日期</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($salesFromSource as $s): ?>
            <tr>
                <td><?php echo h($s['outbound_order_no']); ?></td>
                <td><?php echo h($s['outbound_type']); ?></td>
                <td><a href="trace.php?batch=<?php echo h(urlencode($s['finished_batch_no'])); ?>"><?php echo h($s['finished_batch_no']); ?></a></td>
                <td><?php echo h($s['customer']); ?></td>
                <td><?php echo h($s['quantity'] . ' ' . $s['unit']); ?></td>
                <td><?php echo h($s['outbound_date']); ?></td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
</div>
<?php endif; ?>

<div class="trace-section card">
    <h3>小包装出库记录</h3>
    <?php if (empty($outbounds)): ?>
        <p class="muted">尚无小包装出库记录；库存仍按入库减已出库计算。</p>
    <?php else: ?>
    <table>
        <thead>
            <tr>
                <th>小包装出库单号</th>
                <th>客户</th>
                <th>规格</th>
                <th>数量</th>
                <th>日期</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($outbounds as $o): ?>
            <tr>
                <td><?php echo h($o['outbound_order_no']); ?></td>
                <td><?php echo h($o['customer']); ?></td>
                <td><?php echo h($o['spec_name']); ?></td>
                <td><?php echo h($o['quantity'] . ' ' . $o['unit']); ?></td>
                <td><?php echo h($o['outbound_date']); ?></td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
    <?php endif; ?>
</div>
<?php endif; ?>

<?php endif; ?>

<?php require __DIR__ . '/layout_end.php'; ?>

文件路径: /mnt/mmcblk2p4/www/traceability/public/trace.php
────────────────────────────
<?php
require_once dirname(__DIR__) . '/includes/bootstrap.php';
$pdo = trace_db();
$pageTitle = '追溯查询';
$pageMainClass = 'page-report page-report--trace';

$q = isset($_GET['batch']) ? trim($_GET['batch']) : '';
$pkg = isset($_GET['pkg']) ? trim($_GET['pkg']) : '';

$fg = null;
$consumption = array();
$rawDetails = array();
$sales = array();
$smallPackFromTransfer = array();

$spBatch = null;
$spOutbounds = array();
$spSalesFromSource = array();
$spRemaining = null;

if ($q !== '') {
    $st = $pdo->prepare('SELECT * FROM finished_goods WHERE batch_no = ? LIMIT 1');
    $st->execute(array($q));
    $fg = $st->fetch();

    $st2 = $pdo->prepare(
        'SELECT c.material_name, c.raw_batch_no, c.quantity, c.unit,
            COALESCE(r.inbound_order_no, \'\') AS inbound_order_no
         FROM production_consumption c
         LEFT JOIN raw_material_batches r ON r.batch_no = c.raw_batch_no
         WHERE c.production_batch_no = ?
         ORDER BY c.id'
    );
    $st2->execute(array($q));
    $consumption = $st2->fetchAll();

    $rawNos = array();
    foreach ($consumption as $c) {
        if (!empty($c['raw_batch_no'])) {
            $rawNos[$c['raw_batch_no']] = true;
        }
    }
    if (!empty($rawNos)) {
        $placeholders = implode(',', array_fill(0, count($rawNos), '?'));
        $st3 = $pdo->prepare(
            'SELECT batch_no, supplier_code, supplier_name, material_name, inbound_date, quantity, unit, inbound_order_no
             FROM raw_material_batches WHERE batch_no IN (' . $placeholders . ')'
        );
        $st3->execute(array_keys($rawNos));
        while ($row = $st3->fetch()) {
            $rawDetails[$row['batch_no']] = $row;
        }
    }

    $st4 = $pdo->prepare(
        'SELECT outbound_order_no, customer, quantity, unit, outbound_date,
            COALESCE(outbound_type, \'出库\') AS outbound_type
         FROM sales_outbound WHERE finished_batch_no = ? ORDER BY id'
    );
    $st4->execute(array($q));
    $sales = $st4->fetchAll();

    $types = array('转小包装', '再加工');
    $ph = implode(',', array_fill(0, count($types), '?'));
    $ordStmt = $pdo->prepare(
        "SELECT DISTINCT outbound_order_no FROM sales_outbound WHERE finished_batch_no = ? AND outbound_type IN ($ph)"
    );
    $ordStmt->execute(array_merge(array($q), $types));
    $transferOrderNos = $ordStmt->fetchAll(PDO::FETCH_COLUMN);
    if (!empty($transferOrderNos)) {
        $ph2 = implode(',', array_fill(0, count($transferOrderNos), '?'));
        $spStmt = $pdo->prepare(
            'SELECT b.package_batch_no, b.quantity, b.unit, b.inbound_date, b.inbound_type, b.source_outbound_order_no, s.spec_name
             FROM small_package_batches b
             INNER JOIN small_package_specs s ON s.id = b.spec_id
             WHERE b.source_outbound_order_no IN (' . $ph2 . ')
             ORDER BY b.source_outbound_order_no, b.package_batch_no'
        );
        $spStmt->execute($transferOrderNos);
        $smallPackFromTransfer = $spStmt->fetchAll();
    }
}

if ($pkg !== '') {
    $st = $pdo->prepare(
        'SELECT b.*, s.spec_name, s.spec_code, s.unit AS spec_unit,
                s.fg_qty_per_package
         FROM small_package_batches b
         INNER JOIN small_package_specs s ON s.id = b.spec_id
         WHERE b.package_batch_no = ?
         LIMIT 1'
    );
    $st->execute(array($pkg));
    $spBatch = $st->fetch();

    if ($spBatch) {
        $stO = $pdo->prepare(
            'SELECT o.outbound_order_no, o.customer, o.quantity, o.unit, o.outbound_date, s.spec_name
             FROM small_package_outbound o
             INNER JOIN small_package_specs s ON s.id = o.spec_id
             WHERE o.package_batch_no = ?
             ORDER BY o.outbound_date DESC, o.id DESC'
        );
        $stO->execute(array($pkg));
        $spOutbounds = $stO->fetchAll();

        $src = isset($spBatch['source_outbound_order_no']) ? trim($spBatch['source_outbound_order_no']) : '';
        if ($src !== '') {
            $stS = $pdo->prepare(
                'SELECT outbound_order_no, finished_batch_no, customer, quantity, unit, outbound_date, outbound_type
                 FROM sales_outbound WHERE outbound_order_no = ? ORDER BY id'
            );
            $stS->execute(array($src));
            $spSalesFromSource = $stS->fetchAll();
        }

        $stRem = $pdo->prepare(
            'SELECT (b.quantity - COALESCE((SELECT SUM(o.quantity) FROM small_package_outbound o WHERE o.package_batch_no = b.package_batch_no), 0)) AS rem
             FROM small_package_batches b WHERE b.package_batch_no = ? LIMIT 1'
        );
        $stRem->execute(array($pkg));
        $rrow = $stRem->fetch();
        if ($rrow) {
            $spRemaining = (float) $rrow['rem'];
        }
    }
}

require __DIR__ . '/layout.php';
?>
<header class="report-page-header">
    <span class="report-badge">溯源</span>
    <h1>追溯查询</h1>
    <p class="muted report-lead">默认 <strong>kg</strong>。成品批次：原料 → 生产 → 销售 → 小包装；小包装批次：入库、出库与关联成品单。</p>
</header>

<form method="get" class="card filter-card trace-filter-form">
    <h2 class="filter-card-title">查询条件</h2>
    <div class="row">
        <div>
            <label>成品批次号（= 生产批号）</label>
            <input type="text" name="batch" value="<?php echo h($q); ?>" placeholder="成品批次号" autocomplete="off">
        </div>
        <div>
            <label>小包装批次号</label>
            <input type="text" name="pkg" value="<?php echo h($pkg); ?>" placeholder="如 SP-…" autocomplete="off">
        </div>
        <div class="filter-actions">
            <label class="filter-actions-label">&nbsp;</label>
            <button type="submit" class="btn btn-report-submit">查询</button>
        </div>
    </div>
</form>

<?php if ($pkg !== ''): ?>

<?php if (!$spBatch): ?>
<div class="flash flash-error">未找到该小包装批次。</div>
<?php else: ?>
<div class="trace-section card">
    <h3>小包装入库</h3>
    <table>
        <tr><th>小包装批次号</th><td><strong><?php echo h($spBatch['package_batch_no']); ?></strong></td></tr>
        <tr><th>规格</th><td><?php echo h($spBatch['spec_name']); ?><?php if (!empty($spBatch['spec_code'])): ?>（<?php echo h($spBatch['spec_code']); ?>）<?php endif; ?></td></tr>
        <tr><th>入库数量</th><td><?php echo h($spBatch['quantity'] . ' ' . $spBatch['unit']); ?></td></tr>
        <tr><th>入库类型</th><td><?php echo h($spBatch['inbound_type']); ?></td></tr>
        <tr><th>入库日期</th><td><?php echo h($spBatch['inbound_date']); ?></td></tr>
        <tr><th>备注</th><td><?php echo h($spBatch['note']); ?></td></tr>
        <tr><th>来源成品出库单</th><td>
            <?php if (!empty($spBatch['source_outbound_order_no'])): ?>
                <strong><?php echo h($spBatch['source_outbound_order_no']); ?></strong>
                <span class="muted">（销售出库「转小包装」）</span>
            <?php else: ?>
                <span class="muted">—</span>
            <?php endif; ?>
        </td></tr>
        <?php if ((float) $spBatch['fg_qty_per_package'] > 0): ?>
        <tr><th>规格：每箱 kg（参考）</th><td><?php echo h($spBatch['fg_qty_per_package']); ?> kg / <?php echo h($spBatch['spec_unit']); ?></td></tr>
        <?php endif; ?>
        <tr><th>当前剩余可出</th><td><strong><?php echo h($spRemaining !== null ? $spRemaining : '—'); ?></strong> <?php echo h($spBatch['unit']); ?></td></tr>
    </table>
</div>

<?php if (!empty($spSalesFromSource)): ?>
<div class="trace-section card">
    <h3>关联成品出库（同一单号）</h3>
    <div class="table-wrap">
    <table>
        <thead>
            <tr>
                <th>成品出库单号</th>
                <th>类型</th>
                <th>成品批次号</th>
                <th>客户</th>
                <th>数量</th>
                <th>日期</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($spSalesFromSource as $s): ?>
            <tr>
                <td><?php echo h($s['outbound_order_no']); ?></td>
                <td><?php echo h($s['outbound_type']); ?></td>
                <td><a href="trace.php?batch=<?php echo h(urlencode($s['finished_batch_no'])); ?>"><?php echo h($s['finished_batch_no']); ?></a></td>
                <td><?php echo h($s['customer']); ?></td>
                <td><?php echo h($s['quantity'] . ' ' . $s['unit']); ?></td>
                <td><?php echo h($s['outbound_date']); ?></td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
    </div>
</div>
<?php endif; ?>

<div class="trace-section card">
    <h3>小包装出库记录</h3>
    <?php if (empty($spOutbounds)): ?>
        <p class="muted">暂无小包装出库记录。</p>
    <?php else: ?>
    <div class="table-wrap">
    <table>
        <thead>
            <tr>
                <th>小包装出库单号</th>
                <th>客户</th>
                <th>规格</th>
                <th>数量</th>
                <th>日期</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($spOutbounds as $o): ?>
            <tr>
                <td><?php echo h($o['outbound_order_no']); ?></td>
                <td><?php echo h($o['customer']); ?></td>
                <td><?php echo h($o['spec_name']); ?></td>
                <td><?php echo h($o['quantity'] . ' ' . $o['unit']); ?></td>
                <td><?php echo h($o['outbound_date']); ?></td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
    </div>
    <?php endif; ?>
</div>
<?php endif; ?>

<?php endif; ?>

<?php if ($q !== ''): ?>

<?php if (!$fg): ?>
<div class="flash flash-error">未找到该成品批次入库记录。若仅有生产未入库，仍可查看下方领料。</div>
<?php else: ?>
<div class="trace-section card">
    <h3>成品入库</h3>
    <table>
        <tr><th>成品批次号 / 生产批号</th><td><strong><?php echo h($fg['batch_no']); ?></strong></td></tr>
        <tr><th>成品名称</th><td><?php echo h($fg['product_name']); ?></td></tr>
        <tr><th>数量</th><td><?php echo h($fg['quantity'] . ' ' . $fg['unit']); ?></td></tr>
        <tr><th>生产日期</th><td><?php echo h($fg['production_date']); ?></td></tr>
    </table>
</div>
<?php endif; ?>

<div class="trace-section card">
    <h3>生产领料</h3>
    <?php if (empty($consumption)): ?>
        <p class="muted">该批号下暂无领料记录。</p>
    <?php else: ?>
    <div class="table-wrap">
    <table>
        <thead>
            <tr>
                <th>生产批号</th>
                <th>原料名称</th>
                <th>入库单号</th>
                <th>原料批次号</th>
                <th>用量</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($consumption as $c): ?>
            <tr>
                <td><?php echo h($q); ?></td>
                <td><?php echo h($c['material_name']); ?></td>
                <td><?php echo h(isset($c['inbound_order_no']) ? $c['inbound_order_no'] : ''); ?></td>
                <td><strong><?php echo h($c['raw_batch_no']); ?></strong></td>
                <td><?php echo h($c['quantity'] . ' ' . $c['unit']); ?></td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
    </div>
    <?php endif; ?>
</div>

<div class="trace-section card">
    <h3>原料批次 → 采购</h3>
    <?php if (empty($consumption)): ?>
        <p class="muted">无领料行。</p>
    <?php elseif (empty($rawDetails)): ?>
        <p class="muted">原料批次在库中无匹配记录。</p>
    <?php else: ?>
    <div class="table-wrap">
    <table>
        <thead>
            <tr>
                <th>入库单号</th>
                <th>原料批次号</th>
                <th>供应商</th>
                <th>原料名称</th>
                <th>入库日期</th>
                <th>入库数量</th>
            </tr>
        </thead>
        <tbody>
            <?php
            $seenRaw = array();
            foreach ($consumption as $c) {
                $rb = $c['raw_batch_no'];
                if (isset($seenRaw[$rb]) || !isset($rawDetails[$rb])) {
                    continue;
                }
                $seenRaw[$rb] = true;
                $r = $rawDetails[$rb];
            ?>
            <tr>
                <td><?php echo h(isset($r['inbound_order_no']) ? $r['inbound_order_no'] : ''); ?></td>
                <td><strong><?php echo h($r['batch_no']); ?></strong></td>
                <td><?php echo h(trim($r['supplier_code'] . ' ' . $r['supplier_name'])); ?></td>
                <td><?php echo h($r['material_name']); ?></td>
                <td><?php echo h($r['inbound_date']); ?></td>
                <td><?php echo h($r['quantity'] . ' ' . $r['unit']); ?></td>
            </tr>
            <?php } ?>
        </tbody>
    </table>
    </div>
    <?php endif; ?>
</div>

<div class="trace-section card">
    <h3>销售出库</h3>
    <?php if (empty($sales)): ?>
        <p class="muted">暂无该批次的出库记录。</p>
    <?php else: ?>
    <div class="table-wrap">
    <table>
        <thead>
            <tr>
                <th>出库单号</th>
                <th>类型</th>
                <th>成品批次号</th>
                <th>客户</th>
                <th>数量</th>
                <th>出库日期</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($sales as $s): ?>
            <tr>
                <td><?php echo h($s['outbound_order_no']); ?></td>
                <td><?php echo h(isset($s['outbound_type']) ? $s['outbound_type'] : '出库'); ?></td>
                <td><?php echo h($q); ?></td>
                <td><?php echo h($s['customer']); ?></td>
                <td><?php echo h($s['quantity'] . ' ' . $s['unit']); ?></td>
                <td><?php echo h($s['outbound_date']); ?></td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
    </div>
    <?php endif; ?>
</div>

<div class="trace-section card">
    <h3>转小包装 → 生成的小包装批次</h3>
    <?php if (empty($smallPackFromTransfer)): ?>
        <p class="muted">无「转小包装」出库或未生成小包装批次。</p>
    <?php else: ?>
    <div class="table-wrap">
    <table>
        <thead>
            <tr>
                <th>成品出库单号</th>
                <th>小包装批次号</th>
                <th>规格</th>
                <th>数量</th>
                <th>入库日期</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($smallPackFromTransfer as $sp): ?>
            <tr>
                <td><?php echo h($sp['source_outbound_order_no']); ?></td>
                <td><a href="trace.php?pkg=<?php echo h(urlencode($sp['package_batch_no'])); ?>"><?php echo h($sp['package_batch_no']); ?></a></td>
                <td><?php echo h($sp['spec_name']); ?></td>
                <td><?php echo h($sp['quantity'] . ' ' . $sp['unit']); ?></td>
                <td><?php echo h($sp['inbound_date']); ?></td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
    </div>
    <?php endif; ?>
</div>

<?php endif; ?>

<?php require __DIR__ . '/layout_end.php'; ?>