Lines 735-741
sub GetBudgetHierarchy {
Link Here
|
735 |
SELECT aqorders.budget_id, aqbudgets.budget_parent_id, |
735 |
SELECT aqorders.budget_id, aqbudgets.budget_parent_id, |
736 |
SUM( | |
736 |
SUM( | |
737 |
. C4::Acquisition::get_rounding_sql(qq|COALESCE($unitprice_field, $ecost_field)|) |
737 |
. C4::Acquisition::get_rounding_sql(qq|COALESCE($unitprice_field, $ecost_field)|) |
738 |
. q| * quantity ) AS budget_spent |
738 |
. q| * quantityreceived ) AS budget_spent |
739 |
FROM aqorders JOIN aqbudgets USING (budget_id) |
739 |
FROM aqorders JOIN aqbudgets USING (budget_id) |
740 |
WHERE quantityreceived > 0 AND datecancellationprinted IS NULL |
740 |
WHERE quantityreceived > 0 AND datecancellationprinted IS NULL |
741 |
GROUP BY budget_id, budget_parent_id |
741 |
GROUP BY budget_id, budget_parent_id |
742 |
- |
|
|