<?php include 'protect.php'; ?>

<?php
include 'db.php';

$customer_id = isset($_POST['customer_id']) ? intval($_POST['customer_id']) : 0;
$month = $_POST['month'] ?? '';

if (!$customer_id || !$month) {
    echo "Missing data.";
    exit;
}

// Fetch archived transactions for that month
$stmt = $conn->prepare("
    SELECT * FROM archived_transactions
    WHERE customer_id = ? AND DATE_FORMAT(archived_on, '%Y-%m') = ?
");
$stmt->bind_param("is", $customer_id, $month);
$stmt->execute();
$transactions = $stmt->get_result();

// Prepare insert into live transactions
$insert = $conn->prepare("
    INSERT INTO transactions (customer_id, item_name, quantity, price, taxable, notes, date)
    VALUES (?, ?, ?, ?, ?, ?, ?)
");

// Loop and insert each record back
while ($row = $transactions->fetch_assoc()) {
    $insert->bind_param(
        "isidiss",
        $row['customer_id'],
        $row['item_name'],
        $row['quantity'],
        $row['price'],
        $row['taxable'],
        $row['notes'],
        $row['original_date']
    );
    $insert->execute();
}

// Delete them from archive
$delete = $conn->prepare("
    DELETE FROM archived_transactions
    WHERE customer_id = ? AND DATE_FORMAT(archived_on, '%Y-%m') = ?
");
$delete->bind_param("is", $customer_id, $month);
$delete->execute();

// Redirect
header("Location: view_account.php?customer_id=$customer_id");
exit;
?>