1 package OpenILS::Application::Storage::Publisher::asset;
2 use base qw/OpenILS::Application::Storage/;
3 #use OpenILS::Application::Storage::CDBI::asset;
4 #use OpenSRF::Utils::Logger qw/:level/;
5 #use OpenILS::Utils::Fieldmapper;
7 #my $log = 'OpenSRF::Utils::Logger';
9 sub asset_copy_location_all {
13 for my $rec ( asset::copy_location->retrieve_all ) {
14 $client->respond( $rec->to_fieldmapper );
19 __PACKAGE__->register_method(
20 method => 'asset_copy_location_all',
21 api_name => 'open-ils.storage.direct.asset.copy_location.retrieve.all',
31 return undef unless (@ids);
33 @ids = ($ids[0]) unless ($self->api_name =~ /batch/o);
37 my $cp = asset::copy->retrieve($id);
39 my $cp_fm = $cp->to_fieldmapper;
40 $cp_fm->circ_lib( $cp->circ_lib->to_fieldmapper );
41 $cp_fm->location( $cp->location->to_fieldmapper );
42 $cp_fm->status( $cp->status->to_fieldmapper );
43 $cp_fm->stat_cat_entries( [ map { $_->to_fieldmapper } $cp->stat_cat_entries ] );
45 $client->respond( $cp_fm );
50 __PACKAGE__->register_method(
51 api_name => 'open-ils.storage.fleshed.asset.copy.batch.retrieve',
52 method => 'fleshed_copy',
56 __PACKAGE__->register_method(
57 api_name => 'open-ils.storage.fleshed.asset.copy.retrieve',
58 method => 'fleshed_copy',
62 sub fleshed_copy_by_barcode {
67 my ($cp) = asset::copy->search( { barcode => $bc } );
69 my $cp_fm = $cp->to_fieldmapper;
70 $cp_fm->circ_lib( $cp->circ_lib->to_fieldmapper );
71 $cp_fm->location( $cp->location->to_fieldmapper );
72 $cp_fm->status( $cp->status->to_fieldmapper );
76 __PACKAGE__->register_method(
77 api_name => 'open-ils.storage.fleshed.asset.copy.search.barcode',
78 method => 'fleshed_copy_by_barcode',
83 #XXX Fix stored proc calls
84 sub ranged_asset_stat_cat {
89 return undef unless ($ou);
90 my $s_table = asset::stat_cat->table;
92 my $select = <<" SQL";
95 JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner)
100 $fleshed = 1 if ($self->api_name =~ /fleshed/o);
102 my $sth = asset::stat_cat->db_Main->prepare_cached($select);
105 for my $sc ( map { asset::stat_cat->construct($_) } $sth->fetchall_hash ) {
106 my $sc_fm = $sc->to_fieldmapper;
108 [ $self->method_lookup( 'open-ils.storage.ranged.asset.stat_cat_entry.search.stat_cat' )->run($ou,$sc->id) ]
110 $client->respond( $sc_fm );
115 __PACKAGE__->register_method(
116 api_name => 'open-ils.storage.ranged.fleshed.asset.stat_cat.all',
119 method => 'ranged_asset_stat_cat',
122 __PACKAGE__->register_method(
123 api_name => 'open-ils.storage.ranged.asset.stat_cat.all',
126 method => 'ranged_asset_stat_cat',
130 #XXX Fix stored proc calls
131 sub multiranged_asset_stat_cat {
136 return undef unless (defined($ous) and @$ous);
137 my $s_table = asset::stat_cat->table;
139 my $select = <<" SQL";
142 WHERE s.owner IN ( XXX )
146 my $binds = join(' INTERSECT ', map { 'SELECT id FROM actor.org_unit_full_path(?)' } grep {defined} @$ous);
147 $select =~ s/XXX/$binds/so;
150 $fleshed = 1 if ($self->api_name =~ /fleshed/o);
152 my $sth = asset::stat_cat->db_Main->prepare_cached($select);
153 $sth->execute(map { "$_" } grep {defined} @$ous);
155 for my $sc ( map { asset::stat_cat->construct($_) } $sth->fetchall_hash ) {
156 my $sc_fm = $sc->to_fieldmapper;
158 [ $self->method_lookup( 'open-ils.storage.multiranged.asset.stat_cat_entry.search.stat_cat' )->run($ous, $sc->id) ]
160 $client->respond( $sc_fm );
165 __PACKAGE__->register_method(
166 api_name => 'open-ils.storage.multiranged.fleshed.asset.stat_cat.all',
169 method => 'multiranged_asset_stat_cat',
172 #XXX Fix stored proc calls
173 sub ranged_asset_stat_cat_entry {
179 return undef unless ($ou);
180 my $s_table = asset::stat_cat_entry->table;
182 my $select = <<" SQL";
185 JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner)
190 my $sth = asset::stat_cat->db_Main->prepare_cached($select);
191 $sth->execute($ou,$sc);
193 for my $sce ( map { asset::stat_cat_entry->construct($_) } $sth->fetchall_hash ) {
194 $client->respond( $sce->to_fieldmapper );
199 __PACKAGE__->register_method(
200 api_name => 'open-ils.storage.ranged.asset.stat_cat_entry.search.stat_cat',
203 method => 'ranged_asset_stat_cat_entry',
206 #XXX Fix stored proc calls
207 sub multiranged_asset_stat_cat_entry {
213 return undef unless (defined($ous) and @$ous);
214 my $s_table = asset::stat_cat_entry->table;
216 my $select = <<" SQL";
219 WHERE s.owner IN ( XXX ) and s.stat_cat = ?
223 my $binds = join(' INTERSECT ', map { 'SELECT id FROM actor.org_unit_full_path(?)' } grep {defined} @$ous);
224 $select =~ s/XXX/$binds/so;
226 my $sth = asset::stat_cat->db_Main->prepare_cached($select);
227 $sth->execute(map {"$_"} @$ous,$sc);
229 for my $sce ( map { asset::stat_cat_entry->construct($_) } $sth->fetchall_hash ) {
230 $client->respond( $sce->to_fieldmapper );
235 __PACKAGE__->register_method(
236 api_name => 'open-ils.storage.multiranged.asset.stat_cat_entry.search.stat_cat',
239 method => 'multiranged_asset_stat_cat_entry',