Open Billing

= 180 THEN totamt - totpay ELSE 0 END) AS aging_180_plus FROM sup_invhead WHERE totamt - totpay > 0 GROUP BY supregno HAVING SUM(totamt - totpay) > 0"; $result = mysqli_query($conn, $query); // Initialize column subtotals $aging_0_30_subtotal = 0; $aging_30_60_subtotal = 0; $aging_60_90_subtotal = 0; $aging_90_120_subtotal = 0; $aging_120_180_subtotal = 0; $aging_180_plus_subtotal = 0; // Generate the HTML table echo ''; echo ''; while ($row = mysqli_fetch_assoc($result)) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; // Add column subtotals $aging_0_30_subtotal += $row['aging_0_30']; $aging_30_60_subtotal += $row['aging_30_60']; $aging_60_90_subtotal += $row['aging_60_90']; $aging_90_120_subtotal += $row['aging_90_120']; $aging_120_180_subtotal += $row['aging_120_180']; $aging_180_plus_subtotal += $row['aging_180_plus']; } // Add column subtotals row echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

Supplier	0-30 Days	31-60 Days	61-90 Days	91-120 Days	121-180 Days	180+ Days
' . $row['supregno'] . '	' . number_format($row['aging_0_30'], 2) . '	' . number_format($row['aging_30_60'], 2) . '	' . number_format($row['aging_60_90'], 2) . '	' . number_format($row['aging_90_120'], 2) . '	' . number_format($row['aging_120_180'], 2) . '	' . number_format($row['aging_180_plus'], 2) . '
Subtotal	' . number_format($aging_0_30_subtotal, 2) . '	' . number_format($aging_30_60_subtotal, 2) . '	' . number_format($aging_60_90_subtotal, 2) . '	' . number_format($aging_90_120_subtotal, 2) . '	' . number_format($aging_120_180_subtotal, 2) . '	' . number_format($aging_180_plus_subtotal, 2) . '

'; ?>