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

(-)a/Koha/Database/Columns.pm (+1 lines)
Lines 242-247 sub columns { Link Here
242
            "new_status"                        => __("New status"),
242
            "new_status"                        => __("New status"),
243
            "notforloan"                        => __("Not for loan"),
243
            "notforloan"                        => __("Not for loan"),
244
            "onloan"                            => __("Due date"),
244
            "onloan"                            => __("Due date"),
245
            "other"                             => __("Other"),
245
            "permanent_location"                => __("Permanent shelving location"),
246
            "permanent_location"                => __("Permanent shelving location"),
246
            "price"                             => __("Price"),
247
            "price"                             => __("Price"),
247
            "renewals"                          => __("Total renewals"),
248
            "renewals"                          => __("Total renewals"),
(-)a/Koha/Item.pm (-1 / +2 lines)
Lines 1930-1936 sub public_read_list { Link Here
1930
        'barcode',        'dateaccessioned', 'itemnotes',
1930
        'barcode',        'dateaccessioned', 'itemnotes',
1931
        'onloan',         'uri',             'itype',
1931
        'onloan',         'uri',             'itype',
1932
        'notforloan',     'damaged',         'itemlost',
1932
        'notforloan',     'damaged',         'itemlost',
1933
        'withdrawn',      'restricted'
1933
        'withdrawn',      'restricted',      'other'
1934
    ];
1934
    ];
1935
}
1935
}
1936
1936
Lines 1989-1994 sub to_api_mapping { Link Here
1989
        restricted               => 'restricted_status',
1989
        restricted               => 'restricted_status',
1990
        itemnotes                => 'public_notes',
1990
        itemnotes                => 'public_notes',
1991
        itemnotes_nonpublic      => 'internal_notes',
1991
        itemnotes_nonpublic      => 'internal_notes',
1992
        other                    => 'other',
1992
        holdingbranch            => 'holding_library_id',
1993
        holdingbranch            => 'holding_library_id',
1993
        permanent_location       => 'permanent_location',
1994
        permanent_location       => 'permanent_location',
1994
        onloan                   => 'checked_out_date',
1995
        onloan                   => 'checked_out_date',
(-)a/Koha/Schema/Result/Deleteditem.pm (+10 lines)
Lines 385-390 inventory number (MARC21 952$i) Link Here
385
385
386
'new' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.
386
'new' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.
387
387
388
=head2 other
389
390
  data_type: 'varchar'
391
  is_nullable: 1
392
  size: 32
393
394
this field can be used to map any marc data and use with OpacHiddenItems calculation
395
388
=head2 exclude_from_local_holds_priority
396
=head2 exclude_from_local_holds_priority
389
397
390
  data_type: 'tinyint'
398
  data_type: 'tinyint'
Lines 514-519 __PACKAGE__->add_columns( Link Here
514
  { data_type => "varchar", is_nullable => 1, size => 80 },
522
  { data_type => "varchar", is_nullable => 1, size => 80 },
515
  "new_status",
523
  "new_status",
516
  { data_type => "varchar", is_nullable => 1, size => 32 },
524
  { data_type => "varchar", is_nullable => 1, size => 32 },
525
  "other",
526
  { data_type => "varchar", is_nullable => 1, size => 32 },
517
  "exclude_from_local_holds_priority",
527
  "exclude_from_local_holds_priority",
518
  { data_type => "tinyint", is_nullable => 1 },
528
  { data_type => "tinyint", is_nullable => 1 },
519
);
529
);
(-)a/Koha/Schema/Result/Item.pm (+10 lines)
Lines 389-394 inventory number (MARC21 952$i) Link Here
389
389
390
'new' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.
390
'new' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.
391
391
392
=head2 other
393
394
  data_type: 'varchar'
395
  is_nullable: 1
396
  size: 32
397
398
this field can be used to map any marc data and use with OpacHiddenItems calculation
399
392
=head2 exclude_from_local_holds_priority
400
=head2 exclude_from_local_holds_priority
393
401
394
  data_type: 'tinyint'
402
  data_type: 'tinyint'
Lines 528-533 __PACKAGE__->add_columns( Link Here
528
  { data_type => "varchar", is_nullable => 1, size => 80 },
536
  { data_type => "varchar", is_nullable => 1, size => 80 },
529
  "new_status",
537
  "new_status",
530
  { data_type => "varchar", is_nullable => 1, size => 32 },
538
  { data_type => "varchar", is_nullable => 1, size => 32 },
539
  "other",
540
  { data_type => "varchar", is_nullable => 1, size => 32 },
531
  "exclude_from_local_holds_priority",
541
  "exclude_from_local_holds_priority",
532
  { data_type => "tinyint", is_nullable => 1 },
542
  { data_type => "tinyint", is_nullable => 1 },
533
);
543
);
(-)a/api/v1/swagger/definitions/item.yaml (+6 lines)
Lines 251-256 properties: Link Here
251
      - "null"
251
      - "null"
252
    description: "'new' value, whatever free-text information."
252
    description: "'new' value, whatever free-text information."
253
    maxLength: 32
253
    maxLength: 32
254
  other:
255
    type:
256
      - string
257
      - "null"
258
    description: Other
259
    maxLength: 32
254
  exclude_from_local_holds_priority:
260
  exclude_from_local_holds_priority:
255
    type: boolean
261
    type: boolean
256
    description: Exclude this item from local holds priority.
262
    description: Exclude this item from local holds priority.
(-)a/installer/data/mysql/atomicupdate/bug_36261.pl (+15 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "BUG_36261",
5
    description => "Add a column to store if item should be hidden from OPAC",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
        unless ( column_exists( 'items', 'other' ) ) {
10
            $dbh->do(q{ALTER TABLE items ADD IF NOT EXISTS other VARCHAR(32)});
11
            $dbh->do(q{ALTER TABLE deleteditems ADD IF NOT EXISTS other VARCHAR(32)});
12
            say $out "Added column 'items.other'";
13
        }
14
    },
15
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 2837-2842 CREATE TABLE `deleteditems` ( Link Here
2837
  `copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)',
2837
  `copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)',
2838
  `stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)',
2838
  `stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)',
2839
  `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.',
2839
  `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.',
2840
  `other` varchar(32) DEFAULT NULL COMMENT 'this field can be used to map any marc data and use with OpacHiddenItems calculation',
2840
  `exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority',
2841
  `exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority',
2841
  PRIMARY KEY (`itemnumber`),
2842
  PRIMARY KEY (`itemnumber`),
2842
  KEY `delitembarcodeidx` (`barcode`),
2843
  KEY `delitembarcodeidx` (`barcode`),
Lines 4224-4229 CREATE TABLE `items` ( Link Here
4224
  `copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)',
4225
  `copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)',
4225
  `stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)',
4226
  `stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)',
4226
  `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.',
4227
  `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.',
4228
  `other` varchar(32) DEFAULT NULL COMMENT 'this field can be used to map any marc data and use with OpacHiddenItems calculation',
4227
  `exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority',
4229
  `exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority',
4228
  PRIMARY KEY (`itemnumber`),
4230
  PRIMARY KEY (`itemnumber`),
4229
  UNIQUE KEY `itembarcodeidx` (`barcode`),
4231
  UNIQUE KEY `itembarcodeidx` (`barcode`),
4230
- 

Return to bug 36261