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` ( Link Here
1031
  `cn_source` varchar(10) default NULL,
1031
  `cn_source` varchar(10) default NULL,
1032
  `cn_sort` varchar(30) default NULL,
1032
  `cn_sort` varchar(30) default NULL,
1033
  `ccode` varchar(10) default NULL,
1033
  `ccode` varchar(10) default NULL,
1034
  `materials` varchar(10) default NULL,
1034
  `materials` text default NULL,
1035
  `uri` varchar(255) default NULL,
1035
  `uri` varchar(255) default NULL,
1036
  `itype` varchar(10) default NULL,
1036
  `itype` varchar(10) default NULL,
1037
  `more_subfields_xml` longtext default NULL,
1037
  `more_subfields_xml` longtext default NULL,
(-)a/installer/data/mysql/updatedatabase.pl (+7 lines)
Lines 4564-4569 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
4564
    SetVersion($DBversion);
4564
    SetVersion($DBversion);
4565
}
4565
}
4566
4566
4567
$DBversion = "3.07.00.XXX";
4568
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
4569
    $dbh->do("ALTER TABLE items MODIFY materials text;");
4570
    print "Upgrade to $DBversion done alter items.material from varchar(10) to text \n";
4571
    SetVersion ($DBversion);
4572
}
4573
4567
4574
4568
=head1 FUNCTIONS
4575
=head1 FUNCTIONS
4569
4576
(-)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 57-62 Link Here
57
            <li><span class="label">Item Callnumber:</span> [% ITEM_DAT.itemcallnumber %]&nbsp;</li>
57
            <li><span class="label">Item Callnumber:</span> [% ITEM_DAT.itemcallnumber %]&nbsp;</li>
58
            [% IF ( ITEM_DAT.copyvol ) %]<li><span class="label">Copy / Vol :</span> [% ITEM_DAT.copyvol %]&nbsp;</li> [% END %]
58
            [% IF ( ITEM_DAT.copyvol ) %]<li><span class="label">Copy / Vol :</span> [% ITEM_DAT.copyvol %]&nbsp;</li> [% END %]
59
            [% IF ( ITEM_DAT.replacementprice ) %]<li><span class="label">Replacement Price:</span> [% ITEM_DAT.replacementprice %]&nbsp;</li> [% END %]
59
            [% IF ( ITEM_DAT.replacementprice ) %]<li><span class="label">Replacement Price:</span> [% ITEM_DAT.replacementprice %]&nbsp;</li> [% END %]
60
	    [% IF ITEM_DAT.materials %]<li><span class="label">Materials Specified:</span> [% ITEM_DAT.materials %] </li> [% END %]
60
            </ol></div>
61
            </ol></div>
61
           <div class="listgroup"><h4>Statuses [% IF ( ITEM_DAT.status_advisory ) %](
62
           <div class="listgroup"><h4>Statuses [% IF ( ITEM_DAT.status_advisory ) %](
62
                [% IF ( ITEM_DAT.notforloantext ) %][% ITEM_DAT.notforloantext %] [% END %]
63
                [% IF ( ITEM_DAT.notforloantext ) %][% ITEM_DAT.notforloantext %] [% END %]
63
- 

Return to bug 7278