Lines 506-513
sub GetBudgetHierarchy {
Link Here
|
506 |
# show only budgets owned by me, my branch or everyone |
506 |
# show only budgets owned by me, my branch or everyone |
507 |
if ($owner) { |
507 |
if ($owner) { |
508 |
if ($branchcode) { |
508 |
if ($branchcode) { |
509 |
push @where_strings,qq{ (budget_owner_id = ? OR budget_branchcode = ? OR (budget_branchcode IS NULL or budget_branchcode="" AND (budget_owner_id IS NULL OR budget_owner_id="")))}; |
509 |
push @where_strings, |
510 |
push @bind_params, ($owner, $branchcode); |
510 |
qq{ (budget_owner_id = ? OR budget_branchcode = ? OR ((budget_branchcode IS NULL or budget_branchcode="") AND (budget_owner_id IS NULL OR budget_owner_id="")))}; |
|
|
511 |
push @bind_params, ( $owner, $branchcode ); |
511 |
} else { |
512 |
} else { |
512 |
push @where_strings, ' (budget_owner_id = ? OR budget_owner_id IS NULL or budget_owner_id ="") '; |
513 |
push @where_strings, ' (budget_owner_id = ? OR budget_owner_id IS NULL or budget_owner_id ="") '; |
513 |
push @bind_params, $owner; |
514 |
push @bind_params, $owner; |
514 |
- |
|
|