diff options
Diffstat (limited to 'lib/VNWeb/Staff/Page.pm')
-rw-r--r-- | lib/VNWeb/Staff/Page.pm | 7 |
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}}; |