View | Details | Raw Unified | Return to bug 7278
Collapse All | Expand All

(-)a/catalogue/detail.pl (-1 / +5 lines)
Lines 174-179 my $authvalcode_items_itemlost = GetAuthValCode('items.itemlost',$fw); Link Here
174
my $authvalcode_items_damaged  = GetAuthValCode('items.damaged', $fw);
174
my $authvalcode_items_damaged  = GetAuthValCode('items.damaged', $fw);
175
175
176
my $analytics_flag;
176
my $analytics_flag;
177
my $materials_flag; # set this if the items have anything in the materials field
177
foreach my $item (@items) {
178
foreach my $item (@items) {
178
179
179
    $item->{homebranch}        = GetBranchName($item->{homebranch});
180
    $item->{homebranch}        = GetBranchName($item->{homebranch});
Lines 251-257 foreach my $item (@items) { Link Here
251
		$analytics_flag=1;
252
		$analytics_flag=1;
252
		$item->{countanalytics} = $countanalytics;
253
		$item->{countanalytics} = $countanalytics;
253
	}
254
	}
254
255
    if ($item->{'materials'} ne ''){
256
	$materials_flag = 1;
257
    }
255
    push @itemloop, $item;
258
    push @itemloop, $item;
256
}
259
}
257
260
Lines 276-281 $template->param( Link Here
276
        hostrecords         => $hostrecords,
279
        hostrecords         => $hostrecords,
277
	analytics_flag	=> $analytics_flag,
280
	analytics_flag	=> $analytics_flag,
278
	C4::Search::enabled_staff_search_views,
281
	C4::Search::enabled_staff_search_views,
282
        materials       => $materials_flag,
279
);
283
);
280
284
281
if (C4::Context->preference("AlternateHoldingsField") && scalar @items == 0) {
285
if (C4::Context->preference("AlternateHoldingsField") && scalar @items == 0) {
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1031-1037 CREATE TABLE `items` ( -- holdings/item information Link Here
1031
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
1031
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
1032
  `cn_sort` varchar(30) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
1032
  `cn_sort` varchar(30) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
1033
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
1033
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
1034
  `materials` varchar(10) default NULL, -- materials specified (MARC21 952$3)
1034
  `materials` text default NULL, -- materials specified (MARC21 952$3)
1035
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
1035
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
1036
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
1036
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
1037
  `more_subfields_xml` longtext default NULL, -- additional 952 subfields in XML format
1037
  `more_subfields_xml` longtext default NULL, -- additional 952 subfields in XML format
(-)a/installer/data/mysql/updatedatabase.pl (+8 lines)
Lines 4578-4583 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
4578
    SetVersion($DBversion);
4578
    SetVersion($DBversion);
4579
}
4579
}
4580
4580
4581
$DBversion = "3.07.00.XXX";
4582
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
4583
    $dbh->do("ALTER TABLE items MODIFY materials text;");
4584
    print "Upgrade to $DBversion done alter items.material from varchar(10) to text \n";
4585
    SetVersion ($DBversion);
4586
}
4587
4588
4581
=head1 FUNCTIONS
4589
=head1 FUNCTIONS
4582
4590
4583
=head2 DropAllForeignKeys($table)
4591
=head2 DropAllForeignKeys($table)
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt (+4 lines)
Lines 243-248 function verify_images() { Link Here
243
                <th>Status</th>
243
                <th>Status</th>
244
                <th>Last seen</th>
244
                <th>Last seen</th>
245
                <th>Barcode</th>
245
                <th>Barcode</th>
246
		[% IF materials %]<th>Materials Specified</th>[% END %]
246
                [% IF ( volinfo ) %]<th>Publication Details</th>[% END %]
247
                [% IF ( volinfo ) %]<th>Publication Details</th>[% END %]
247
                [% IF ( itemdata_uri ) %]<th>url</th>[% END %]
248
                [% IF ( itemdata_uri ) %]<th>url</th>[% END %]
248
                [% IF ( itemdata_copynumber ) %]<th>Copy No.</th>[% END %]
249
                [% IF ( itemdata_copynumber ) %]<th>Copy No.</th>[% END %]
Lines 372-377 function verify_images() { Link Here
372
				[% IF ( itemdata_copynumber ) %]
373
				[% IF ( itemdata_copynumber ) %]
373
					<td class="copynumber">[% itemloo.copynumber %]</td>
374
					<td class="copynumber">[% itemloo.copynumber %]</td>
374
				[% END %]
375
				[% END %]
376
	        [% IF itemloo.materials %]
377
		    <td> [% itemloo.materials %] </td>
378
		[% END %]
375
                [% IF ( itemdata_itemnotes ) %]<td><div class="itemnotes">[% itemloo.itemnotes %]</div></td>[% END %]
379
                [% IF ( itemdata_itemnotes ) %]<td><div class="itemnotes">[% itemloo.itemnotes %]</div></td>[% END %]
376
		[% IF ( SpineLabelShowPrintOnBibDetails ) %]
380
		[% IF ( SpineLabelShowPrintOnBibDetails ) %]
377
			<td><a href="/cgi-bin/koha/labels/spinelabel-print.pl?barcode=[% itemloo.barcode %]" >Print Label</a></td>
381
			<td><a href="/cgi-bin/koha/labels/spinelabel-print.pl?barcode=[% itemloo.barcode %]" >Print Label</a></td>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/moredetail.tt (-1 / +1 lines)
Lines 58-63 Link Here
58
            <li><span class="label">Item Callnumber:</span> [% ITEM_DAT.itemcallnumber %]&nbsp;</li>
58
            <li><span class="label">Item Callnumber:</span> [% ITEM_DAT.itemcallnumber %]&nbsp;</li>
59
            [% IF ( ITEM_DAT.copyvol ) %]<li><span class="label">Copy / Vol :</span> [% ITEM_DAT.copyvol %]&nbsp;</li> [% END %]
59
            [% IF ( ITEM_DAT.copyvol ) %]<li><span class="label">Copy / Vol :</span> [% ITEM_DAT.copyvol %]&nbsp;</li> [% END %]
60
            [% IF ( ITEM_DAT.replacementprice ) %]<li><span class="label">Replacement Price:</span> [% ITEM_DAT.replacementprice %]&nbsp;</li> [% END %]
60
            [% IF ( ITEM_DAT.replacementprice ) %]<li><span class="label">Replacement Price:</span> [% ITEM_DAT.replacementprice %]&nbsp;</li> [% END %]
61
	    [% IF ITEM_DAT.materials %]<li><span class="label">Materials Specified:</span> [% ITEM_DAT.materials %] </li> [% END %]
61
            </ol></div>
62
            </ol></div>
62
           <div class="listgroup"><h4>Statuses [% IF ( ITEM_DAT.status_advisory ) %](
63
           <div class="listgroup"><h4>Statuses [% IF ( ITEM_DAT.status_advisory ) %](
63
                [% IF ( ITEM_DAT.notforloantext ) %][% ITEM_DAT.notforloantext %] [% END %]
64
                [% IF ( ITEM_DAT.notforloantext ) %][% ITEM_DAT.notforloantext %] [% END %]
64
- 

Return to bug 7278