summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-11-07 16:19:09 +0100
committerYorhel <git@yorhel.nl>2009-11-07 16:19:09 +0100
commite745c48e897c580af7c2841832ce0e9786e647c3 (patch)
treec82cda62b491b535598073b93375f2a34f20d925
parenta418f879fc377c64e2acbbf5d54f97ad524f3302 (diff)
API: Added vn and producers info flags to the get release command
-rw-r--r--data/docs/1125
-rw-r--r--lib/Multi/API.pm46
2 files changed, 65 insertions, 6 deletions
diff --git a/data/docs/11 b/data/docs/11
index 99c727d7..7a863959 100644
--- a/data/docs/11
+++ b/data/docs/11
@@ -530,6 +530,31 @@ however still required.<br />
An empty array is returned when the media are unknown.
</td>
</tr>
+ <tr class="odd">
+ <td>vn</td>
+ <td>vn</td>
+ <td>array of objects</td>
+ <td>no</td>
+ <td>
+ Array of visual novels linked to this release. Objects have the following members:
+ id, title and original. These are the same as the members of the "get vn" command.
+ </td>
+ </tr>
+ <tr>
+ <td>producers</td>
+ <td>producers</td>
+ <td>array of objects</td>
+ <td>no</td>
+ <td>
+ (Possibly empty) list of producers involved in this release. Objects have the following members:<br />
+ "id", integer<br />
+ "developer", boolean,<br />
+ "publisher", boolean,<br />
+ "name", string, romaji name<br />
+ "original", string, official/original name, can be <b>null</b><br />
+ "type", string, producer type
+ </td>
+ </tr>
</table>
<b>Accepted filters for the 'release' type:</b>
diff --git a/lib/Multi/API.pm b/lib/Multi/API.pm
index 20b89778..741400dc 100644
--- a/lib/Multi/API.pm
+++ b/lib/Multi/API.pm
@@ -475,7 +475,7 @@ sub get_vn_res {
sub get_release {
my($c, $info, $filters) = @_[ARG0..$#_];
- return cerr $c, getinfo => "Unkown info flag '$_'", flag => $_ for (grep !/^(basic|details)$/, @$info);
+ return cerr $c, getinfo => "Unkown info flag '$_'", flag => $_ for (grep !/^(basic|details|vn|producers)$/, @$info);
my $select = 'r.id, r.latest';
$select .= ', rr.title, rr.original, rr.released, rr.type, rr.patch, rr.freeware, rr.doujin' if grep /basic/, @$info;
@@ -514,11 +514,11 @@ sub get_release_res {
$_->{doujin} = $_->{doujin} ? TRUE : FALSE;
}
if(grep /details/, @{$get->{info}}) {
- $_->{website} ||= undef;
- $_->{notes} ||= undef;
- $_->{minage} = $_->{minage} < 0 ? undef : $_->{minage}*1;
- $_->{gtin} ||= undef;
- $_->{catalog} ||= undef;
+ $_->{website} ||= undef;
+ $_->{notes} ||= undef;
+ $_->{minage} = $_->{minage} < 0 ? undef : $_->{minage}*1;
+ $_->{gtin} ||= undef;
+ $_->{catalog} ||= undef;
}
}
$get->{list} = $res;
@@ -545,6 +545,30 @@ sub get_release_res {
}
$get->{media} = 1;
}
+ elsif($get->{type} eq 'vn') {
+ for my $i (@{$get->{list}}) {
+ $i->{vn} = [ grep $i->{latest} == $_->{rid}, @$res ];
+ }
+ for (@$res) {
+ $_->{id}*=1;
+ $_->{original} ||= undef;
+ delete $_->{rid};
+ }
+ $get->{vn} = 1;
+ }
+ elsif($get->{type} eq 'producers') {
+ for my $i (@{$get->{list}}) {
+ $i->{producers} = [ grep $i->{latest} == $_->{rid}, @$res ];
+ }
+ for (@$res) {
+ $_->{id}*=1;
+ $_->{original} ||= undef;
+ $_->{developer} = $_->{developer} ? TRUE : FALSE;
+ $_->{publisher} = $_->{publisher} ? TRUE : FALSE;
+ delete $_->{rid};
+ }
+ $get->{producers} = 1;
+ }
# get more info
my @ids = map $_->{latest}, @{$get->{list}};
@@ -562,6 +586,16 @@ sub get_release_res {
qq|SELECT rid, medium, qty FROM releases_media WHERE rid IN($ids)|,
\@ids, 'get_release_res', { %$get, type => 'media' });
+ !$get->{vn} && grep(/vn/, @{$get->{info}}) && return $_[KERNEL]->post(pg => query => qq|
+ SELECT rv.rid, v.id, vr.title, vr.original FROM releases_vn rv JOIN vn v ON v.id = rv.vid
+ JOIN vn_rev vr ON vr.id = v.latest WHERE NOT v.hidden AND rv.rid IN($ids)|,
+ \@ids, 'get_release_res', { %$get, type => 'vn' });
+
+ !$get->{producers} && grep(/producers/, @{$get->{info}}) && return $_[KERNEL]->post(pg => query => qq|
+ SELECT rp.rid, rp.developer, rp.publisher, p.id, pr.type, pr.name, pr.original FROM releases_producers rp
+ JOIN producers p ON p.id = rp.pid JOIN producers_rev pr ON pr.id = p.latest WHERE NOT p.hidden AND rp.rid IN($ids)|,
+ \@ids, 'get_release_res', { %$get, type => 'producers' });
+
# send results
delete $_->{latest} for @{$get->{list}};
$_[KERNEL]->yield(get_results => { %$get, type => 'release' });