<?php

// include("inc/config.php");


// if (isset($_POST['complete_status'])) {

//     $invoice_id = $_POST['invoice_id'];

//     $update_query = "UPDATE invoices SET status='Complete' WHERE id='$invoice_id'";

//     if (mysqli_query($conn, $update_query)) {

//         header("Location: view-invoice.php"); 
//         exit();
//     } else {
 
//         echo "Error updating record: " . mysqli_error($conn);
//     }
// }


session_start();
include("inc/config.php");

if (isset($_POST['complete_status'])) {
    $invoice_id = $_POST['invoice_id'];
    $current_date = date('Y-m-d H:i:s'); // Get current date and time

    // Update status and set complete_date
    $update_query = "UPDATE invoices SET status = 'Complete', complete_date = '$current_date' WHERE id = '$invoice_id'";
    
    if (mysqli_query($conn, $update_query)) {
        $_SESSION['success'] = "Invoice status updated successfully!";
    } else {
        $_SESSION['error'] = "Error updating status: " . mysqli_error($conn);
    }

    header("Location: view-invoice.php"); // Redirect back to the invoice page
    exit();
}
?>