Index: openacs-4/packages/invoices/lib/report-month-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/lib/report-month-postgresql.xql,v diff -u -N --- openacs-4/packages/invoices/lib/report-month-postgresql.xql 13 Sep 2005 20:56:48 -0000 1.3 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,42 +0,0 @@ - - - - - - select - distinct to_char(iv.due_date, 'MM') as iv_month - from - iv_invoices iv, - acs_objects o - where - iv.recipient_id = o.object_id - $extra_query - [template::list::filter_where_clauses -and -name iv_months] - - - - - - select - count(invoice_id) - from - iv_invoices - where - to_char(due_date, 'MM') = :iv_month - $extra_query - - - - - - select - sum(total_amount) - from - iv_invoices - where - to_char(due_date, 'MM') = :iv_month - $extra_query - - - -