<?php
require_once('includes/connection.php');

header('Content-Type: application/json');

if (isset($_GET['po_no'])) {
    $po_no = $_GET['po_no'];

    $stmt = $conn->prepare("SELECT `rate` FROM purchase_order_master WHERE po_no = ?");
    $stmt->bind_param("s", $po_no);
    $stmt->execute();
    $result = $stmt->get_result();

    if ($row = $result->fetch_assoc()) {
        echo json_encode(['success' => true, 'rate' => $row['rate']]);
    } else {
        echo json_encode(['success' => false]);
    }
} else {
    echo json_encode(['success' => false]);
}