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

(-)a/Koha/Schema/Result/Branchtransfer.pm (-3 / +4 lines)
Lines 72-78 __PACKAGE__->table("branchtransfers"); Link Here
72
=head2 reason
72
=head2 reason
73
73
74
  data_type: 'enum'
74
  data_type: 'enum'
75
  extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding"]}
75
  extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection"]}
76
  is_nullable: 1
76
  is_nullable: 1
77
77
78
=cut
78
=cut
Lines 127-132 __PACKAGE__->add_columns( Link Here
127
        "StockrotationRepatriation",
127
        "StockrotationRepatriation",
128
        "ReturnToHome",
128
        "ReturnToHome",
129
        "ReturnToHolding",
129
        "ReturnToHolding",
130
        "RotatingCollection",
130
      ],
131
      ],
131
    },
132
    },
132
    is_nullable => 1,
133
    is_nullable => 1,
Lines 193-200 __PACKAGE__->belongs_to( Link Here
193
);
194
);
194
195
195
196
196
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-19 09:20:20
197
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-20 10:50:34
197
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PLfyg+VMkwXhVqkTeTdGWw
198
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Z5PcwyW+X3XM1CeO6CZKBw
198
199
199
sub koha_object_class {
200
sub koha_object_class {
200
    'Koha::Item::Transfer';
201
    'Koha::Item::Transfer';
(-)a/installer/data/mysql/atomicupdate/bug_24299.perl (+24 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    # Add rotating collection states to reason enum
5
    $dbh->do(
6
        qq{
7
            ALTER TABLE
8
                `branchtransfers`
9
            MODIFY COLUMN
10
                `reason` enum(
11
                    'Manual',
12
                    'StockrotationAdvance',
13
                    'StockrotationRepatriation',
14
                    'ReturnToHome',
15
                    'ReturnToHolding',
16
                    'RotatingCollection'
17
                )
18
            AFTER `comments`
19
          }
20
    );
21
22
    SetVersion( $DBversion );
23
    print "Upgrade to $DBversion done (Bug 24299 - Add 'collection' reasons to branchtransfers enum)\n";
24
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 906-912 CREATE TABLE `branchtransfers` ( -- information for items that are in transit be Link Here
906
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
906
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
907
  `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
907
  `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
908
  `comments` LONGTEXT, -- any comments related to the transfer
908
  `comments` LONGTEXT, -- any comments related to the transfer
909
  `reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding'), -- what triggered the transfer
909
  `reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection'), -- what triggered the transfer
910
  PRIMARY KEY (`branchtransfer_id`),
910
  PRIMARY KEY (`branchtransfer_id`),
911
  KEY `frombranch` (`frombranch`),
911
  KEY `frombranch` (`frombranch`),
912
  KEY `tobranch` (`tobranch`),
912
  KEY `tobranch` (`tobranch`),
913
- 

Return to bug 24299