Index: openacs-4/packages/invoices/www/invoice-send.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/www/invoice-send.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/invoices/www/invoice-send.xql 14 Dec 2005 16:24:22 -0000 1.3
+++ openacs-4/packages/invoices/www/invoice-send.xql 27 Dec 2005 16:39:35 -0000 1.4
@@ -5,12 +5,22 @@
select i.invoice_nr, i.organization_id, i.parent_invoice_id, i.invoice_nr,
- i.total_amount, i.recipient_id, i.organization_id
+ i.total_amount, i.recipient_id, i.contact_id, i.organization_id
from iv_invoices i, cr_items ii
where ii.latest_revision = i.invoice_id
and ii.item_id = :invoice_id
+
+
+
+ update cr_items
+ set publish_status = 'expired'
+ where item_id = (select item_id from cr_revisions where revision_id = :file_id)
+
+
+
+