110 |
my $where1 = $show_just ? "AND (dlits.status = '$show_just ') " : ""; |
my $where1 = $show_just ? "AND (dlits.status = '$show_just ') " : ""; |
111 |
my $where2 = $curator ? "AND (curr_role.curator = '$curator' AND curr_role.role = hash_role.role) " : ""; |
my $where2 = $curator ? "AND (curr_role.curator = '$curator' AND curr_role.role = hash_role.role) " : ""; |
112 |
|
|
113 |
my @roles = map { $_->[0] } @{$rdbH->SQL("select DISTINCT hash_role.role from hash_role,dlits,curr_role WHERE hash_role.md5_hash = dlits.md5_hash $where1 $where2")}; |
my @roles = sort map { $_->[0] } @{$rdbH->SQL("select DISTINCT hash_role.role from hash_role,dlits,curr_role WHERE hash_role.md5_hash = dlits.md5_hash $where1 $where2")}; |
114 |
push(@$html, $cgi->start_form(-action => "get_dlits.cgi", -method => 'post'), |
push(@$html, $cgi->start_form(-action => "get_dlits.cgi", -method => 'post'), |
115 |
$cgi->hidden(-name => 'user', -value=>$user), |
$cgi->hidden(-name => 'user', -value=>$user), |
116 |
$cgi->hidden(-name => 'show_just', -value=>$show_just), |
$cgi->hidden(-name => 'show_just', -value=>$show_just), |