| {$i} |
{$row['bill_no']} |
{$row['bill_date']} |
{$row['party_name']} |
{$row['payment_by']} |
{$row['total_amt']} |
{$row['balance']} |
|
";
$i++;
}
/*
$sql = "SELECT
SUM(CASE WHEN payment_by = 'Cash' THEN total_amt ELSE 0 END) AS paid,
SUM(CASE WHEN payment_by = 'Cheque' THEN total_amt ELSE 0 END) AS unpaid
FROM ah_purchase_details";
$summary_result = mysqli_query($conn, $sql);
$summary_row = mysqli_fetch_assoc($summary_result);
$paid = isset($summary_row['paid']) ? (float) $summary_row['paid'] : 0;
$unpaid = isset($summary_row['unpaid']) ? (float) $summary_row['unpaid'] : 0;
$total = $paid + $unpaid;*/
// ** Return JSON Response **
echo json_encode([
'table_data' => $table_data,
'paid' => number_format($paid_total, 2),
'unpaid' => number_format($unpaid_total, 2),
'total' => number_format($total, 2)
]);
?>