fetch_revenues_trans.php

<?php
// Include the GoBrik server connection credentials
require_once '../gobrikconn_env.php';

// Fetch data for revenues
$sql = "SELECT cash_tran_id,
               transaction_date_dt,
               sender_for_display,
               type_of_transaction,
               tran_name_desc,
               usd_amount,
               idr_amount, -- Include amount_idr in the query
               revenue_accounting_type
        FROM tb_cash_transaction
        WHERE revenue_accounting_type IS NOT NULL";

$result = $gobrik_conn->query($sql);

// Check for query execution errors
if (!$result) {
    http_response_code(500);
    echo json_encode(["error" => "Database query failed: " . $gobrik_conn->error]);
    exit;
}

$data = [];
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $data[] = [
            "ID" => $row["cash_tran_id"], // Return raw ID (no HTML or JS)
            "Date" => $row["transaction_date_dt"],
            "Sender" => $row["sender_for_display"],
            "Category" => $row["type_of_transaction"],
            "Transaction" => $row["tran_name_desc"],
            "AmountUSD" => number_format((float)$row["usd_amount"], 2, '.', ','), // Format Amount USD
            "AmountIDR" => number_format((int)$row["idr_amount"], 0, '.', ','),  // Format Amount IDR
            "Type" => $row["revenue_accounting_type"],
        ];
    }
}

// Return JSON response
header('Content-Type: application/json');
echo json_encode(["data" => $data]);

$gobrik_conn->close();
?>