<?php
require_once('includes/connection.php');

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $company_name = $_POST['company_name'] ?? '';
    $customer_name = $_POST['customer_name'] ?? '';

    if ($company_name && $customer_name) {
        $stmt = $conn->prepare("SELECT `po_no`, `rate`, `po_date` FROM `purchase_order_master` WHERE `company_name` = ? AND `customer_name` = ?");
        $stmt->bind_param("ss", $company_name, $customer_name);
        $stmt->execute();
        $result = $stmt->get_result();

        $data = [];
        while ($row = $result->fetch_assoc()) {
            $data[] = [
                'po_no' => $row['po_no'],
                'po_date' => $row['po_date'],
                'rate' => $row['rate']
            ];
        }

        echo json_encode($data);
        exit;
    }
}