View | Details | Raw Unified | Return to bug 4438
Collapse All | Expand All

(-)a/admin/check_parent_total.pl (-4 / +2 lines)
Lines 75-81 if ($parent) { Link Here
75
# ELSE , IF NO PARENT PASSED, THEN CHECK UNALLOCATED FOR PERIOD, IF NOT THEN RETURN 2
75
# ELSE , IF NO PARENT PASSED, THEN CHECK UNALLOCATED FOR PERIOD, IF NOT THEN RETURN 2
76
else {
76
else {
77
    my $query = qq| SELECT SUM(budget_amount) as sum
77
    my $query = qq| SELECT SUM(budget_amount) as sum
78
                FROM aqbudgets WHERE budget_period_id = ?|;
78
                FROM aqbudgets WHERE budget_period_id = ? and budget_parent_id IS NULL|;
79
79
80
    my $sth   = $dbh->prepare($query);
80
    my $sth   = $dbh->prepare($query);
81
    $sth->execute(  $period_id  ); 
81
    $sth->execute(  $period_id  ); 
Lines 95-101 if ( $parent_id) { Link Here
95
    $returncode = 0;
95
    $returncode = 0;
96
}
96
}
97
97
98
$template->param( return => $returncode );
99
98
100
output_html_with_http_headers $input, $cookie, $template->output;
99
output_html_with_http_headers $input, $cookie, $returncode;
101
1;
100
1;
102
- 

Return to bug 4438