projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 8c3fab3) | patch
Repair acq.fund_combined_balance for encumbered + spent user/berick/acq-fund-combined-balance-fix
authorBill Erickson <berick@esilibrary.com>
Tue, 13 Sep 2011 20:41:06 +0000 (16:41 -0400)
committerBill Erickson <berick@esilibrary.com>
Tue, 13 Sep 2011 20:51:55 +0000 (16:51 -0400)
commit47a339c07d52b4ebea02440b419e1ad3b0727653
treec8f8640a416a0b808e97189d3d28186cdf3a1445tree
parent8c3fab3c4a25a9b8a439882f154736a79396f46ecommit | diff
Repair acq.fund_combined_balance for encumbered + spent

acq.fund_debit_total, which is used by acq.fund_combined_balance, can
return 2 values, the total encumbered and total spent for a fund.  This
patch updates acq.fund_combined_balance to SUM the two so that only 1
row per fund is returned from acq.fund_combined_balance

Signed-off-by: Bill Erickson <berick@esilibrary.com>
Open-ILS/src/sql/Pg/200.schema.acq.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq.fund-combined-balance.sql.sql [new file with mode: 0644] blob
Evergreen ILS