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';
10 # see /home/miker/cn_browse-test.sql for page up and down sql ...
13 sub cn_browse_pagedown {
19 my $cn = uc($args{label});
20 my $org = $args{org_unit};
21 my $depth = $args{depth};
22 my $boundry_id = $args{boundry_id};
23 my $size = $args{page_size} || 20;
26 my $table = asset::call_number->table;
28 my $descendants = "actor.org_unit_descendants($org)";
30 $descendants = "actor.org_unit_descendants($org,$depth)";
43 on (d.id = cn.owning_lib)
46 or ( cn.id > ? and upper(label) = ? )
54 my $sth = asset::call_number->db_Main->prepare($sql);
55 $sth->execute($cn, $boundry_id, $cn);
56 while ( my @row = $sth->fetchrow_array ) {
57 $client->respond([@row]);
63 __PACKAGE__->register_method(
64 method => 'cn_browse_pagedown',
65 api_name => 'open-ils.storage.asset.call_number.browse.page_down',
70 sub cn_browse_pageup {
76 my $cn = uc($args{label});
77 my $org = $args{org_unit};
78 my $depth = $args{depth};
79 my $boundry_id = $args{boundry_id};
80 my $size = $args{page_size} || 20;
83 my $table = asset::call_number->table;
85 my $descendants = "actor.org_unit_descendants($org)";
87 $descendants = "actor.org_unit_descendants($org,$depth)";
101 on (d.id = cn.owning_lib)
104 or ( cn.id < ? and upper(label) = ? )
105 order by upper(label) desc
108 order by 1 desc, 4 desc
114 my $sth = asset::call_number->db_Main->prepare($sql);
115 $sth->execute($cn, $boundry_id, $cn);
116 while ( my @row = $sth->fetchrow_array ) {
117 $client->respond([@row]);
123 __PACKAGE__->register_method(
124 method => 'cn_browse_pageup',
125 api_name => 'open-ils.storage.asset.call_number.browse.page_up',
130 sub cn_browse_target {
136 my $cn = uc($args{label});
137 my $org = $args{org_unit};
138 my $depth = $args{depth};
139 my $size = $args{page_size} || 20;
140 my $topsize = $size / 2;
141 $topsize = int($topsize);
142 $bottomsize = $size - $topsize;
144 my $table = asset::call_number->table;
146 my $descendants = "actor.org_unit_descendants($org)";
147 if (defined $depth) {
148 $descendants = "actor.org_unit_descendants($org,$depth)";
151 my $top_sql = <<" SQL";
162 on (d.id = cn.owning_lib)
165 order by upper(label) desc
168 order by 1 desc, 4 desc
174 my $bottom_sql = <<" SQL";
184 on (d.id = cn.owning_lib)
187 order by upper(label)
194 my $sth = asset::call_number->db_Main->prepare($top_sql);
196 while ( my @row = $sth->fetchrow_array ) {
197 $client->respond([@row]);
201 $sth = asset::call_number->db_Main->prepare($bottom_sql);
203 while ( my @row = $sth->fetchrow_array ) {
204 $client->respond([@row]);
210 __PACKAGE__->register_method(
211 method => 'cn_browse_target',
212 api_name => 'open-ils.storage.asset.call_number.browse.target',
225 return unless ($cp && $org);
227 $cp = $cp->id if (ref $cp);
228 $cp = asset::copy->retrieve($cp);
229 return 999 unless $copy;
230 my $ol = $cp->call_number->owning_lib;
232 return asset::copy->db_Main->selectcol_arrayref('SELECT actor.org_unit_proximity(?,?)',{},"$ol","$org")->[0];
234 __PACKAGE__->register_method(
235 method => 'copy_proximity',
236 api_name => 'open-ils.storage.asset.copy.proximity',
241 sub asset_copy_location_all {
245 for my $rec ( asset::copy_location->retrieve_all ) {
246 $client->respond( $rec->to_fieldmapper );
251 __PACKAGE__->register_method(
252 method => 'asset_copy_location_all',
253 api_name => 'open-ils.storage.direct.asset.copy_location.retrieve.all',
263 return undef unless (@ids);
265 @ids = ($ids[0]) unless ($self->api_name =~ /batch/o);
267 for my $id ( @ids ) {
269 my $cp = asset::copy->retrieve($id);
271 my $cp_fm = $cp->to_fieldmapper;
272 $cp_fm->circ_lib( $cp->circ_lib->to_fieldmapper );
273 $cp_fm->location( $cp->location->to_fieldmapper );
274 $cp_fm->status( $cp->status->to_fieldmapper );
275 $cp_fm->stat_cat_entries( [ map { $_->to_fieldmapper } $cp->stat_cat_entries ] );
277 $client->respond( $cp_fm );
282 __PACKAGE__->register_method(
283 api_name => 'open-ils.storage.fleshed.asset.copy.batch.retrieve',
284 method => 'fleshed_copy',
288 __PACKAGE__->register_method(
289 api_name => 'open-ils.storage.fleshed.asset.copy.retrieve',
290 method => 'fleshed_copy',
294 sub fleshed_copy_by_barcode {
299 my ($cp) = asset::copy->search( { barcode => $bc } );
301 return undef unless ($cp);
303 my $cp_fm = $cp->to_fieldmapper;
304 $cp_fm->circ_lib( $cp->circ_lib->to_fieldmapper );
305 $cp_fm->location( $cp->location->to_fieldmapper );
306 $cp_fm->status( $cp->status->to_fieldmapper );
310 __PACKAGE__->register_method(
311 api_name => 'open-ils.storage.fleshed.asset.copy.search.barcode',
312 method => 'fleshed_copy_by_barcode',
317 #XXX Fix stored proc calls
318 sub ranged_asset_stat_cat {
323 return undef unless ($ou);
324 my $s_table = asset::stat_cat->table;
326 my $select = <<" SQL";
329 JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner)
334 $fleshed = 1 if ($self->api_name =~ /fleshed/o);
336 my $sth = asset::stat_cat->db_Main->prepare_cached($select);
339 for my $sc ( map { asset::stat_cat->construct($_) } $sth->fetchall_hash ) {
340 my $sc_fm = $sc->to_fieldmapper;
342 [ $self->method_lookup( 'open-ils.storage.ranged.asset.stat_cat_entry.search.stat_cat' )->run($ou,$sc->id) ]
344 $client->respond( $sc_fm );
349 __PACKAGE__->register_method(
350 api_name => 'open-ils.storage.ranged.fleshed.asset.stat_cat.all',
353 method => 'ranged_asset_stat_cat',
356 __PACKAGE__->register_method(
357 api_name => 'open-ils.storage.ranged.asset.stat_cat.all',
360 method => 'ranged_asset_stat_cat',
364 #XXX Fix stored proc calls
365 sub multiranged_asset_stat_cat {
370 return undef unless (defined($ous) and @$ous);
371 my $s_table = asset::stat_cat->table;
373 my $select = <<" SQL";
376 WHERE s.owner IN ( XXX )
380 my $collector = ' INTERSECT ';
381 my $entry_method = 'open-ils.storage.multiranged.intersect.asset.stat_cat_entry.search.stat_cat';
382 if ($self->api_name =~ /union/o) {
383 $collector = ' UNION ';
384 $entry_method = 'open-ils.storage.multiranged.union.asset.stat_cat_entry.search.stat_cat';
387 my $binds = join($collector, map { 'SELECT id FROM actor.org_unit_full_path(?)' } grep {defined} @$ous);
388 $select =~ s/XXX/$binds/so;
391 $fleshed = 1 if ($self->api_name =~ /fleshed/o);
393 my $sth = asset::stat_cat->db_Main->prepare_cached($select);
394 $sth->execute(map { "$_" } grep {defined} @$ous);
396 for my $sc ( map { asset::stat_cat->construct($_) } $sth->fetchall_hash ) {
397 my $sc_fm = $sc->to_fieldmapper;
399 [ $self->method_lookup( $entry_method )->run($ous, $sc->id) ]
401 $client->respond( $sc_fm );
406 __PACKAGE__->register_method(
407 api_name => 'open-ils.storage.multiranged.intersect.fleshed.asset.stat_cat.all',
410 method => 'multiranged_asset_stat_cat',
412 __PACKAGE__->register_method(
413 api_name => 'open-ils.storage.multiranged.union.fleshed.asset.stat_cat.all',
416 method => 'multiranged_asset_stat_cat',
419 #XXX Fix stored proc calls
420 sub ranged_asset_stat_cat_entry {
426 return undef unless ($ou);
427 my $s_table = asset::stat_cat_entry->table;
429 my $select = <<" SQL";
432 JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner)
437 my $sth = asset::stat_cat->db_Main->prepare_cached($select);
438 $sth->execute($ou,$sc);
440 for my $sce ( map { asset::stat_cat_entry->construct($_) } $sth->fetchall_hash ) {
441 $client->respond( $sce->to_fieldmapper );
446 __PACKAGE__->register_method(
447 api_name => 'open-ils.storage.ranged.asset.stat_cat_entry.search.stat_cat',
450 method => 'ranged_asset_stat_cat_entry',
453 #XXX Fix stored proc calls
454 sub multiranged_asset_stat_cat_entry {
460 return undef unless (defined($ous) and @$ous);
461 my $s_table = asset::stat_cat_entry->table;
463 my $collector = ' INTERSECT ';
464 $collector = ' UNION ' if ($self->api_name =~ /union/o);
466 my $select = <<" SQL";
469 WHERE s.owner IN ( XXX ) and s.stat_cat = ?
473 my $binds = join($collector, map { 'SELECT id FROM actor.org_unit_full_path(?)' } grep {defined} @$ous);
474 $select =~ s/XXX/$binds/so;
476 my $sth = asset::stat_cat->db_Main->prepare_cached($select);
477 $sth->execute(map {"$_"} @$ous,$sc);
479 for my $sce ( map { asset::stat_cat_entry->construct($_) } $sth->fetchall_hash ) {
480 $client->respond( $sce->to_fieldmapper );
485 __PACKAGE__->register_method(
486 api_name => 'open-ils.storage.multiranged.intersect.asset.stat_cat_entry.search.stat_cat',
489 method => 'multiranged_asset_stat_cat_entry',
491 __PACKAGE__->register_method(
492 api_name => 'open-ils.storage.multiranged.union.asset.stat_cat_entry.search.stat_cat',
495 method => 'multiranged_asset_stat_cat_entry',