From 654e74d0ee51800bffcadc963ebaa4fd69f6c463 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Wed, 14 Sep 2016 17:33:35 +0000 Subject: [PATCH] [PASSED QA] Bug 17301 - Add callnumber to label-edit-batch.pl To test: 1 - Create a label batch 2 - Add some items 3 - Note you do not see callnumber 4 - Apply patch 5 - Verify callnumber displays correctly 6 - Verify batch functions (adding, exporting, removing, etc) work as before Signed-off-by: Owen Leonard Signed-off-by: Katrin Fischer --- C4/Creators/Lib.pm | 3 ++- labels/label-edit-batch.pl | 1 + 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/C4/Creators/Lib.pm b/C4/Creators/Lib.pm index 2063d5d..bdf712e 100644 --- a/C4/Creators/Lib.pm +++ b/C4/Creators/Lib.pm @@ -298,7 +298,7 @@ sub get_label_summary { my %params = @_; my $label_number = 0; my @label_summaries = (); - my $query = " SELECT b.title, b.author, bi.itemtype, i.barcode, i.biblionumber, i.itype + my $query = " SELECT b.title, b.author, bi.itemtype, i.barcode, i.itemcallnumber, i.biblionumber, i.itype FROM creator_batches AS c LEFT JOIN items AS i ON (c.item_number=i.itemnumber) LEFT JOIN biblioitems AS bi ON (i.biblioitemnumber=bi.biblioitemnumber) LEFT JOIN biblio AS b ON (bi.biblionumber=b.biblionumber) @@ -324,6 +324,7 @@ sub get_label_summary { $label_summary->{'_item_type'} = C4::Context->preference("item-level_itypes") ? $record->{'itype'} : $record->{'itemtype'}; $label_summary->{'_barcode'} = $record->{'barcode'}; $label_summary->{'_item_number'} = $item->{'item_number'}; + $label_summary->{'_item_cn'} = $record->{'itemcallnumber'}; $label_summary->{'_label_id'} = $item->{'label_id'}; push (@label_summaries, $label_summary); } diff --git a/labels/label-edit-batch.pl b/labels/label-edit-batch.pl index 004087c..9d9eb2c 100755 --- a/labels/label-edit-batch.pl +++ b/labels/label-edit-batch.pl @@ -51,6 +51,7 @@ my $batch = undef; my $display_columns = [ {_label_number => {label => 'Label Number', link_field => 0}}, {_summary => {label => 'Summary', link_field => 0}}, {_item_type => {label => 'Item Type', link_field => 0}}, + {_item_cn => {label => 'Item Callnumber', link_field => 0}}, {_barcode => {label => 'Barcode', link_field => 0}}, {_delete => {label => 'Actions', link_field => 0}}, {select => {label => 'Select', value => '_label_id'}}, -- 2.7.4