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 -N -r1.5 -r1.6
--- openacs-4/packages/invoices/www/invoice-send.xql	31 Dec 2005 07:36:24 -0000	1.5
+++ openacs-4/packages/invoices/www/invoice-send.xql	29 Jan 2006 15:43:16 -0000	1.6
@@ -5,22 +5,42 @@
       <querytext>
 
     select i.invoice_nr, i.organization_id, i.parent_invoice_id, i.invoice_nr,
-           i.total_amount, i.recipient_id, i.contact_id, i.organization_id
+           i.total_amount, i.recipient_id, i.contact_id, i.organization_id, i.status
     from iv_invoices i, cr_items ii
     where ii.latest_revision = i.invoice_id
     and ii.item_id = :invoice_id
 
       </querytext>
 </fullquery>
 
+<fullquery name="set_invoice_nr">
+      <querytext>
+
+    update iv_invoices
+    set invoice_nr = :invoice_nr
+    where invoice_id = (select latest_revision from cr_items where item_id = :invoice_id)
+
+      </querytext>
+</fullquery>
+
 <fullquery name="set_publish_status">
       <querytext>
 
     update cr_items
-    set publish_status = 'expired'
-    where item_id = :file_id
+    set publish_status = 'live'
+    where item_id = :one_file
 
       </querytext>
 </fullquery>
 
+<fullquery name="set_context_id">
+      <querytext>
+
+    update acs_objects
+    set context_id = :invoice_folder_id
+    where object_id = :one_file
+
+      </querytext>
+</fullquery>
+
 </queryset>