Index: openacs-4/packages/invoices/lib/invoice-list.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/lib/invoice-list.xql,v diff -u -N --- openacs-4/packages/invoices/lib/invoice-list.xql 27 Oct 2005 19:30:16 -0000 1.4 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,48 +0,0 @@ - - - - - - - select cr.item_id as invoice_id, cr.title, cr.description, - t.invoice_nr, t.total_amount, t.currency, t.paid_amount, - t.paid_currency, p.first_names, p.last_name, o.creation_user, - to_char(o.creation_date, :timestamp_format) as creation_date, - to_char(t.due_date, :date_format) as due_date, t.parent_invoice_id, - t.invoice_id as invoice_rev_id, t.cancelled_p, t.status, t.recipient_id - from cr_folders cf, cr_items ci, cr_revisions cr, iv_invoices t, - acs_objects o, persons p - where cr.revision_id = ci.latest_revision - and t.invoice_id = cr.revision_id - and ci.parent_id = cf.folder_id - and cf.package_id = :package_id - and o.object_id = t.invoice_id - and p.person_id = o.creation_user - [template::list::filter_where_clauses -and -name iv_invoice] - [template::list::page_where_clause -and -name iv_invoice -key cr.item_id] - [template::list::orderby_clause -name iv_invoice -orderby] - - - - - - - - select cr.item_id as invoice_id - from cr_folders cf, cr_items ci, cr_revisions cr, iv_invoices t, - acs_objects o, persons p - where cr.revision_id = ci.latest_revision - and t.invoice_id = cr.revision_id - and t.organization_id = :organization_id - and ci.parent_id = cf.folder_id - and cf.package_id = :package_id - and o.object_id = t.invoice_id - and p.person_id = o.creation_user - [template::list::filter_where_clauses -and -name iv_invoice] - [template::list::orderby_clause -name iv_invoice -orderby] - - - - - -