summaryrefslogtreecommitdiff
path: root/lib/VNWeb/Staff/Page.pm
diff options
context:
space:
mode:
Diffstat (limited to 'lib/VNWeb/Staff/Page.pm')
-rw-r--r--lib/VNWeb/Staff/Page.pm7
1 files changed, 5 insertions, 2 deletions
diff --git a/lib/VNWeb/Staff/Page.pm b/lib/VNWeb/Staff/Page.pm
index 8d143fcc..d1ee5bf3 100644
--- a/lib/VNWeb/Staff/Page.pm
+++ b/lib/VNWeb/Staff/Page.pm
@@ -74,12 +74,13 @@ sub _roles_ {
my %alias = map +($_->{aid}, $_), $s->{alias}->@*;
my $roles = tuwf->dbAlli(q{
- SELECT v.id, vs.aid, vs.role, vs.note, v.c_released, v.title, v.alttitle
+ SELECT v.id, vs.aid, vs.role, vs.note, ve.name, ve.official, v.c_released, v.title, v.alttitle
FROM vn_staff vs
JOIN vnt v ON v.id = vs.id
+ LEFT JOIN vn_editions ve ON ve.id = vs.id AND ve.eid = vs.eid
WHERE vs.aid IN}, [ keys %alias ], q{
AND NOT v.hidden
- ORDER BY v.c_released ASC, v.title ASC, vs.role ASC
+ ORDER BY v.c_released ASC, v.title ASC, ve.lang NULLS FIRST, ve.name NULLS FIRST, vs.role ASC
});
return if !@$roles;
enrich_ulists_widget $roles;
@@ -101,6 +102,8 @@ sub _roles_ {
td_ class => 'tc_ulist', sub { ulists_widget_ $v if !$vns{$v->{id}}++ } if auth;
td_ class => 'tc1', sub {
a_ href => "/$v->{id}", title => $v->{alttitle}||$v->{title}, shorten $v->{title}, 60;
+ txt_ " $v->{name}" if $v->{name} && $v->{official};
+ b_ class => 'grayedout', " $v->{name}" if $v->{name} && !$v->{official};
};
td_ class => 'tc2', sub { rdate_ $v->{c_released} };
td_ class => 'tc3', $CREDIT_TYPE{$v->{role}};