From b87916216e4aa4b56cb7bddf4ef2b6cb85796eda Mon Sep 17 00:00:00 2001 From: pines Date: Thu, 14 Sep 2006 16:50:18 +0000 Subject: [PATCH] updating total_owed git-svn-id: svn://svn.open-ils.org/ILS/trunk@6099 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm index 02bbeaed4a..1db2c33c9a 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm @@ -32,7 +32,7 @@ sub usr_total_owed { SUM(COALESCE((SELECT SUM(b.amount) FROM money.billing b WHERE b.voided IS FALSE AND b.xact = x.id),0.0)) - SUM(COALESCE((SELECT SUM(p.amount) FROM money.payment p WHERE p.voided IS FALSE AND p.xact = x.id),0.0)) FROM money.billable_xact x - WHERE x.usr = ? + WHERE x.usr = ? AND x.xact_finish IS NULL GROUP BY 1 SQL -- 2.11.0