diff options
author | morkt <> | 2015-02-16 17:22:24 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-02-16 17:22:24 +0100 |
commit | 4b1b212bd1f9b01ed101795c93f20a6c6c6eb78b (patch) | |
tree | a29c7680146d08315937fb688b5269e618174725 /lib/VNDB/DB | |
parent | 430e17b85c65b54d5a24292a7182701b232574bf (diff) |
Various staff improvements
(Quoting mail:)
- character list is sorted by name in cast edit form (managing of the
huge lists like v6458 becomes slightly easier);
- display number of characters voiced on seiyuu page;
- display a notice in staff edit form when primary name could be
changed.
Diffstat (limited to 'lib/VNDB/DB')
-rw-r--r-- | lib/VNDB/DB/Staff.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/VNDB/DB/Staff.pm b/lib/VNDB/DB/Staff.pm index 73be2f41..1b9a10da 100644 --- a/lib/VNDB/DB/Staff.pm +++ b/lib/VNDB/DB/Staff.pm @@ -7,7 +7,7 @@ use Exporter 'import'; our @EXPORT = qw|dbStaffGet dbStaffRevisionInsert dbStaffAliasIds|; -# options: results, page, id, aid, search, rev, truename, role, gender +# options: results, page, id, aid, search, exact, rev, truename, role, gender # what: extended changes roles aliases sub dbStaffGet { my $self = shift; @@ -42,6 +42,7 @@ sub dbStaffGet { $seiyuu ? ( 'EXISTS(SELECT 1 FROM vn_seiyuu vsy JOIN vn v ON v.latest = vsy.vid WHERE vsy.aid = sa.id AND NOT v.hidden)' ) : () ).')' => ( @roles ? [ \@roles ] : 1 ), ) : (), + $o{exact} ? ( '(sa.name = ? OR sa.original = ?)' => [ ($o{exact}) x 2 ] ) : (), $o{search} ? $o{search} =~ /[\x{3000}-\x{9fff}\x{ff00}-\x{ff9f}]/ ? # match against 'original' column only if search string contains any |