Lines 561-574
sub GetBudgetHierarchy {
Link Here
|
561 |
# Get all the budgets totals in as few queries as possible |
561 |
# Get all the budgets totals in as few queries as possible |
562 |
my $hr_budget_spent = $dbh->selectall_hashref(q| |
562 |
my $hr_budget_spent = $dbh->selectall_hashref(q| |
563 |
SELECT aqorders.budget_id, aqbudgets.budget_parent_id, |
563 |
SELECT aqorders.budget_id, aqbudgets.budget_parent_id, |
564 |
SUM( COALESCE(unitprice_tax_included, ecost_tax_included) * quantity ) AS budget_spent |
564 |
SUM( | . _get_rounding_sql(qq|COALESCE(unitprice_tax_included, ecost_tax_included)|) . q| * quantity ) AS budget_spent |
565 |
FROM aqorders JOIN aqbudgets USING (budget_id) |
565 |
FROM aqorders JOIN aqbudgets USING (budget_id) |
566 |
WHERE quantityreceived > 0 AND datecancellationprinted IS NULL |
566 |
WHERE quantityreceived > 0 AND datecancellationprinted IS NULL |
567 |
GROUP BY budget_id, budget_parent_id |
567 |
GROUP BY budget_id, budget_parent_id |
568 |
|, 'budget_id'); |
568 |
|, 'budget_id'); |
569 |
my $hr_budget_ordered = $dbh->selectall_hashref(q| |
569 |
my $hr_budget_ordered = $dbh->selectall_hashref(q| |
570 |
SELECT aqorders.budget_id, aqbudgets.budget_parent_id, |
570 |
SELECT aqorders.budget_id, aqbudgets.budget_parent_id, |
571 |
SUM(ecost_tax_included * quantity) AS budget_ordered |
571 |
SUM( | . _get_rounding_sql(qq|ecost_tax_included|) . q| * quantity) AS budget_ordered |
572 |
FROM aqorders JOIN aqbudgets USING (budget_id) |
572 |
FROM aqorders JOIN aqbudgets USING (budget_id) |
573 |
WHERE quantityreceived = 0 AND datecancellationprinted IS NULL |
573 |
WHERE quantityreceived = 0 AND datecancellationprinted IS NULL |
574 |
GROUP BY budget_id, budget_parent_id |
574 |
GROUP BY budget_id, budget_parent_id |