<?php
include 'db_connect.php';
session_start();

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $qc_sheet_id = $_POST['qc_sheet_id'];
    $supervisor_id = $_SESSION['user_id'];
    $status = $_POST['status'];
    $feedback = $_POST['feedback'];

    // Insert approval decision into the approvals table
    $stmt = $pdo->prepare("INSERT INTO approvals (qc_sheet_id, supervisor_id, approval_date, status, feedback) VALUES (?, ?, NOW(), ?, ?)");
    $stmt->execute([$qc_sheet_id, $supervisor_id, $status, $feedback]);

    // Update the QC sheet status
    $stmt = $pdo->prepare("UPDATE qc_sheets SET status = ? WHERE id = ?");
    $stmt->execute([$status == 'Approved' ? 'ApprovedL1' : 'Rejected', $qc_sheet_id]);

    echo "QC sheet $status.";
}
?>