<?php
include 'db.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $customer_id = intval($_POST['customer_id']);
    $month = $_POST['month'];

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

    // Select archived transactions for the given month
    $stmt = $conn->prepare("
        SELECT item_name, quantity, price, taxable, original_date
        FROM archived_transactions
        WHERE customer_id = ? AND DATE_FORMAT(archived_on, '%Y-%m') = ?
    ");
    $stmt->bind_param("is", $customer_id, $month);
    $stmt->execute();
    $result = $stmt->get_result();

    $transactions = [];
    while ($row = $result->fetch_assoc()) {
        $transactions[] = $row;
    }

    // Insert each back into the active transactions table
    $insert = $conn->prepare("
        INSERT INTO transactions (customer_id, item_name, quantity, price, taxable, date)
        VALUES (?, ?, ?, ?, ?, ?)
    ");

    foreach ($transactions as $t) {
        $insert->bind_param(
            "isidis",
            $customer_id,
            $t['item_name'],
            $t['quantity'],
            $t['price'],
            $t['taxable'],
            $t['original_date']
        );
        $insert->execute();
    }

    // Delete the archived transactions
    $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;
} else {
    echo "Invalid request.";
}