0 AND clientregno = '$clientregno'"; $result = mysqli_query($conn, $query); // Get the name of the client from the customer table $query2 = "SELECT custname FROM customer WHERE clientregno = '$clientregno'"; $result2 = mysqli_query($conn, $query2); $row2 = mysqli_fetch_assoc($result2); $clientname = $row2['custname']; // Initialize variables to hold the totals for each aging category $aging_0_30 = 0; $aging_31_60 = 0; $aging_61_90 = 0; $aging_91_120 = 0; $aging_121_180 = 0; $aging_180_plus = 0; // Generate the HTML table echo '
'; echo '

Open Invoices for ' . $clientname . '

'; echo ''; echo ''; echo ''; while ($row = mysqli_fetch_assoc($result)) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; // Update totals for each aging category if ($row['age'] <= 30) { $aging_0_30 += ($row['totamt'] - $row['totrec']); } elseif ($row['age'] <= 60) { $aging_31_60 += ($row['totamt'] - $row['totrec']); } elseif ($row['age'] <= 90){ $aging_61_90 += ($row['totamt'] - $row['totrec']); } elseif ($row['age'] <= 120) { $aging_61_90 += ($row['totamt'] - $row['totrec']); } elseif ($row['age'] <= 180) { $aging_91_120 += ($row['totamt'] - $row['totrec']); } elseif ($row['age'] <= 180) { $aging_121_180 += ($row['totamt'] - $row['totrec']); } else { $aging_180_plus += ($row['totamt'] - $row['totrec']); } } // Add a row for the subtotals for each aging category echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
Invoice No.Invoice DateDue DateAge (Days)Total AmountTotal ReceivedBalance
' . $row['invno'] . '' . $row['invdate'] . '' . $row['invduedate'] . '' . $row['age'] . '' . number_format($row['totamt'], 2) . '' . number_format($row['totrec'], 2) . '' . number_format($row['totamt'] - $row['totrec'], 2) . '

Aging Summary

0-30 Days:' . number_format($aging_0_30, 2) . '
31-60 Days:' . number_format($aging_31_60, 2) . '
61-90 Days:' . number_format($aging_61_90, 2) . '
91-120 Days:' . number_format($aging_91_120, 2) . '
121-180 Days:' . number_format($aging_121_180, 2) . '
180+ Days:' . number_format($aging_180_plus, 2) . '
'; echo '
'; // Close database connection mysqli_close($conn);