|
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 |
- |
|
|