<?php
include 'db.php'; // Database connection

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $vename = $_POST['vename'];
    $vephone = $_POST['vephone'];
    $biadress = $_POST['biadress'];
    $bicity = $_POST['bicity'];
    $bipincode = $_POST['bipincode'];
    $bestate = $_POST['bestate'];
    $veemail = $_POST['veemail'];
    $vegstnum = $_POST['vegstnum'];

    // Check for duplicate vendor name
    $checkStmt = $con->prepare("SELECT * FROM vendor WHERE vename = ?");
    $checkStmt->bind_param("s", $vename);
    $checkStmt->execute();
    $checkStmt->store_result();

    if ($checkStmt->num_rows > 0) {
        echo json_encode(['status' => 'error', 'message' => 'Vendor name already exists.']);
    } else {
        $stmt = $con->prepare("INSERT INTO vendor (vename, vephone, biadress, bicity, bipincode, bestate, veemail, vegstnum) VALUES (? , ? , ? , ? , ? , ? , ? , ?)");
        $stmt->bind_param("ssssssss", $vename, $vephone, $biadress, $bicity, $bipincode, $bestate, $veemail, $vegstnum);

        if ($stmt->execute()) {
            echo json_encode(['status' => 'success', 'message' => 'Vendor added successfully.']);
        } else {
            echo json_encode(['status' => 'error', 'message' => 'Insert failed.']);
        }

        $stmt->close();
    }

    $checkStmt->close();
    $con->close();
}
?>