<?php




include("inc/config.php");
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['builty_id'])) {
    $builty_id = intval($_POST['builty_id']);
    $upload_folder = "../vendor/buimg/";
    $messages = [];

    // ✅ Upload GR Image (varify_gr)
    if (isset($_FILES['varify_gr']) && $_FILES['varify_gr']['error'] === 0) {
        $ext = pathinfo($_FILES['varify_gr']['name'], PATHINFO_EXTENSION);
        $filename = "gr_" . $builty_id . "." . strtolower($ext);
        $target_file = $upload_folder . $filename;

        if (move_uploaded_file($_FILES['varify_gr']['tmp_name'], $target_file)) {
            $query = "UPDATE builties SET varify_gr = '$filename' WHERE id = '$builty_id'";
            if (mysqli_query($conn, $query)) {
                $messages[] = "GR image uploaded.";
            } else {
                $messages[] = "Database update failed for GR image.";
            }
        } 
        // else {
        //     $messages[] = "Failed to upload GR image.";
        // }
    }

    // ✅ Upload Invoice Image (verify_image)
    if (isset($_FILES['verify_image']) && $_FILES['verify_image']['error'] === 0) {
        $ext = pathinfo($_FILES['verify_image']['name'], PATHINFO_EXTENSION);
        $filename = "invoice_" . $builty_id . "." . strtolower($ext);
        $target_file = $upload_folder . $filename;

        if (move_uploaded_file($_FILES['verify_image']['tmp_name'], $target_file)) {
            $query = "UPDATE builties SET verify_image = '$filename' WHERE id = '$builty_id'";
            if (mysqli_query($conn, $query)) {
                $messages[] = "Invoice image uploaded.";
            } else {
                $messages[] = "Database update failed for Invoice image.";
            }
        } 
        // else {
        //     $messages[] = "Failed to upload Invoice image.";
        // }
    }

    // ✅ Upload PDF (builty_pdf)
    if (isset($_FILES['builty_pdf']) && $_FILES['builty_pdf']['error'] === 0) {
        $ext = pathinfo($_FILES['builty_pdf']['name'], PATHINFO_EXTENSION);
        if (strtolower($ext) === 'pdf') {
            $filename = "builty_" . $builty_id . ".pdf";
            $target_file = $upload_folder . $filename;

            if (move_uploaded_file($_FILES['builty_pdf']['tmp_name'], $target_file)) {
                $query = "UPDATE builties SET builty_pdf = '$filename' WHERE id = '$builty_id'";
                if (mysqli_query($conn, $query)) {
                    $messages[] = "PDF uploaded.";
                } else {
                    $messages[] = "Database update failed for PDF.";
                }
            } else {
                $messages[] = "Failed to upload PDF.";
            }
        } 
        // else {
        //     $messages[] = "Only PDF files are allowed for builty PDF.";
        // }
    }

    // ✅ Show alert and redirect
    if (empty($messages)) {
        $messages[] = "No file was uploaded.";
    }

    $msg = implode("\\n", $messages);
    echo "<script>alert('$msg'); window.location.href='view-assign_builty.php';</script>";
}



if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['builty_id'])) {
    $builty_id = intval($_POST['builty_id']);
    $upload_folder = "../vendor/sublier/";
    $messages = [];

    if (isset($_FILES['supplier_file']) && $_FILES['supplier_file']['error'] === 0) {
        $allowed_extensions = ['jpg', 'jpeg', 'png', 'gif', 'pdf'];
        $original_name = $_FILES['supplier_file']['name'];
        $file_tmp = $_FILES['supplier_file']['tmp_name'];
        $file_ext = strtolower(pathinfo($original_name, PATHINFO_EXTENSION));

        if (in_array($file_ext, $allowed_extensions)) {
            $new_filename = "supplier_" . $builty_id . "." . $file_ext;
            $target_file = $upload_folder . $new_filename;

            if (move_uploaded_file($file_tmp, $target_file)) {
                // ✅ Update the supplier_file column now
                $query = "UPDATE builties SET supplier_file = '$new_filename' WHERE id = $builty_id";
                if (mysqli_query($conn, $query)) {
                    $messages[] = "File uploaded successfully.";
                } else {
                    $messages[] = "Database update failed.";
                }
            } else {
                $messages[] = "File upload failed.";
            }
        } else {
            $messages[] = "Invalid file type. Only JPG, PNG, GIF, and PDF are allowed.";
        }
    } else {
        $messages[] = "No file selected or upload error.";
    }

    $msg = implode("\\n", $messages);
    echo "<script>alert('$msg'); window.location.href='view-assign_builty.php';</script>";
} else {
    echo "<script>alert('Invalid request.'); window.location.href='view-assign_builty.php';</script>";
}

?>