diff options
| author | arf20 <aruizfernandez05@gmail.com> | 2024-04-28 02:13:03 +0200 |
|---|---|---|
| committer | arf20 <aruizfernandez05@gmail.com> | 2024-04-28 02:13:03 +0200 |
| commit | 006c02b6b9e96f09f69d94d016f5405a3f3f0abe (patch) | |
| tree | 7682abfffd8ebfaa368cca97875687d2af999c87 | |
| parent | 32f2aeed68a8c4ac92ec294afde7e00f78050db9 (diff) | |
| download | arfnet2-cstims-006c02b6b9e96f09f69d94d016f5405a3f3f0abe.tar.gz arfnet2-cstims-006c02b6b9e96f09f69d94d016f5405a3f3f0abe.zip | |
Invoices only for active services
| -rw-r--r-- | makeinvoices.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/makeinvoices.php b/makeinvoices.php index e20b0e5..de16c4b 100644 --- a/makeinvoices.php +++ b/makeinvoices.php @@ -81,7 +81,7 @@ $result = mysqli_stmt_get_result($stmt); $clients = $result->fetch_all(MYSQLI_ASSOC); // Get due orders -$sql = "SELECT id, service, name, client, billing, date FROM orders"; +$sql = "SELECT id, service, name, client, billing, date FROM orders WHERE status = 'active'""; $stmt = mysqli_prepare($link, $sql); mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); @@ -295,4 +295,5 @@ function generate_pdf($client, $dueorders, $desc = null, $manualqty = null) { return array($pdf->Output('invoice.pdf', 'S'), $subtotal, $nextid); } -?>
\ No newline at end of file +?> + |