Index: openacs-4/packages/invoices/tcl/offer-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/tcl/offer-procs.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/invoices/tcl/offer-procs.xql 16 Aug 2005 20:04:32 -0000 1.1 +++ openacs-4/packages/invoices/tcl/offer-procs.xql 6 Sep 2005 22:59:05 -0000 1.2 @@ -1,6 +1,18 @@ + + + + update iv_offers + set accepted_date = (select accepted_date + from iv_offers + where offer_id = :old_rev_id) + where offer_id = :new_rev_id + + + + @@ -11,7 +23,7 @@ o.creation_user, p.first_names, p.last_name, to_char(o.creation_date, :timestamp_format) as creation_date, to_char(t.accepted_date, :timestamp_format) as accepted_date, - t.amount_sum as amount_sum_, t.payment_days, + t.amount_sum as amount_sum_, t.payment_days, t.date_comment, t.currency, t.organization_id, t.amount_sum from iv_offers t, cr_revisions r, cr_items i, acs_objects o, persons p @@ -34,7 +46,7 @@ o.creation_user, p.first_names, p.last_name, to_char(o.creation_date, :timestamp_format) as creation_date, to_char(t.accepted_date, :timestamp_format) as accepted_date, - t.amount_sum as amount_sum_, t.payment_days, + t.amount_sum as amount_sum_, t.payment_days, t.date_comment, t.currency, t.organization_id, t.amount_sum from iv_offers t, cr_revisions r, cr_items i, acs_objects o, persons p