projects
/
koha_gimpoz
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Bug 4032 XSLT systempreference takes a path to file rather than YesNo
[koha_gimpoz]
/
C4
/
Budgets.pm
diff --git
a/C4/Budgets.pm
b/C4/Budgets.pm
index
888b4fd
..
7c867e0
100644
(file)
--- a/
C4/Budgets.pm
+++ b/
C4/Budgets.pm
@@
-304,7
+304,7
@@
sub GetBudgetSpent {
my ($budget_id) = @_;
my $dbh = C4::Context->dbh;
my $sth = $dbh->prepare(qq|
my ($budget_id) = @_;
my $dbh = C4::Context->dbh;
my $sth = $dbh->prepare(qq|
- SELECT SUM(
ecost * quantity
) AS sum FROM aqorders
+ SELECT SUM(
COALESCE(unitprice, ecost) * quantity
) AS sum FROM aqorders
WHERE budget_id = ? AND
quantityreceived > 0 AND
datecancellationprinted IS NULL
WHERE budget_id = ? AND
quantityreceived > 0 AND
datecancellationprinted IS NULL