query($sql);
if ($result->num_rows > 0) {
$output = '';
$count = 1;
$total_sale = 0;
$total_profit = 0;
while ($row = $result->fetch_assoc()) {
$party_id = $row['customer_id'];
$party_name = "Unknown";
$party_query = "SELECT party_name FROM ah_party WHERE id = '$party_id'";
$party_result = $conn->query($party_query);
if ($party_result->num_rows > 0) {
$party_row = $party_result->fetch_assoc();
$party_name = $party_row['party_name'];
}
$sale_amount = $row['total_amt'];
$profit_loss = $sale_amount - ($row['received_amount'] ?? 0);
$total_sale += $sale_amount;
$total_profit += $profit_loss;
$profit_color = ($profit_loss >= 0) ? "green" : "red";
$output .= "
| {$count}. |
{$row['bill_date']} |
{$row['bill_no']} |
{$party_name} |
₹ " . number_format($sale_amount, 2) . " |
₹ " . number_format($profit_loss, 2) . " |
|
";
$count++;
}
$output .= "
| Summary |
Total Sale Amount: ₹ " . number_format($total_sale, 2) . " |
Total Profit(+)/Loss(-): ₹ " . number_format($total_profit, 2) . " |
";
echo $output;
} else {
echo "| No records found |
";
}
?>