Subversion Repositories PEEPS

Rev

Rev 12 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 12 Rev 16
Line 559... Line 559...
559 
  return $name;
 559 
  return $name;
560 
}
 560 
}
Line 561... Line 561...
561 
 
 561 
 
562 
sub getLeagues {
 562 
sub getLeagues {
563 
  my $exclude_id = shift // 0;
 563 
  my $exclude_id = shift // 0;
564 
  return $dbh->selectall_arrayref ("select id, concat_ws(' - ', league_name, type, status) as league from organization where status in ('Active', 'Voluntary Inactive')  and id not in (select member_org_id from role where person_id = ?) order by league_name", undef, $exclude_id);
 564 
  return $dbh->selectall_arrayref ("select id, concat_ws(' - ', league_name, type, status) as league from organization where status in ('Active', 'Voluntary Inactive') and visible = 1 and id not in (select member_org_id from role where person_id = ?) order by league_name", undef, $exclude_id);
Line 565... Line 565...
565 
}
 565 
}
566 
 
 566 
 
567 
sub getDepartments {
 567 
sub getDepartments {