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

(-)a/installer/data/mysql/atomicupdate/stockrot_tables.sql (+62 lines)
Line 0 Link Here
1
-- Stock Rotation Rotas
2
3
CREATE TABLE IF NOT EXISTS stockrotationrotas (
4
    rota_id int(11) auto_increment,          -- Stockrotation rota ID
5
    title varchar(100) NOT NULL,            -- Title for this rota
6
    description text NOT NULL default '',   -- Description for this rota
7
    cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
8
    active tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
9
    PRIMARY KEY (`rota_id`)
10
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
11
12
-- Stock Rotation Stages
13
14
CREATE TABLE IF NOT EXISTS stockrotationstages (
15
    stage_id int(11) auto_increment,     -- Unique stage ID
16
    position int(11) NOT NULL,           -- The position of this stage within its rota
17
    rota_id int(11) NOT NULL,            -- The rota this stage belongs to
18
    branchcode_id varchar(10) NOT NULL,  -- Branch this stage relates to
19
    duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
20
    PRIMARY KEY (`stage_id`),
21
    CONSTRAINT `stockrotationstages_rifk`
22
      FOREIGN KEY (`rota_id`)
23
      REFERENCES `stockrotationrotas` (`rota_id`)
24
      ON UPDATE CASCADE ON DELETE CASCADE,
25
    CONSTRAINT `stockrotationstages_bifk`
26
      FOREIGN KEY (`branchcode_id`)
27
      REFERENCES `branches` (`branchcode`)
28
      ON UPDATE CASCADE ON DELETE CASCADE
29
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
30
31
-- Stock Rotation Items
32
33
CREATE TABLE IF NOT EXISTS stockrotationitems (
34
    itemnumber_id int(11) NOT NULL,         -- Itemnumber to link to a stage & rota
35
    stage_id int(11) NOT NULL,              -- stage ID to link the item to
36
    indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
37
    fresh tinyint(1) NOT NULL default 0,    -- Flag showing item is only just added to rota
38
    PRIMARY KEY (itemnumber_id),
39
    CONSTRAINT `stockrotationitems_iifk`
40
      FOREIGN KEY (`itemnumber_id`)
41
      REFERENCES `items` (`itemnumber`)
42
      ON UPDATE CASCADE ON DELETE CASCADE,
43
    CONSTRAINT `stockrotationitems_sifk`
44
      FOREIGN KEY (`stage_id`)
45
      REFERENCES `stockrotationstages` (`stage_id`)
46
      ON UPDATE CASCADE ON DELETE CASCADE
47
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
48
49
-- System preferences
50
51
INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES
52
       ('StockRotation','0','If ON, enables the stock rotation module','','YesNo'),
53
       ('RotationPreventTransfers','0','If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','','YesNo');
54
55
-- Permissions
56
57
INSERT IGNORE INTO userflags (bit, flag, flagdesc, defaulton) VALUES
58
       (21, 'stockrotation', 'Manage stockrotation operations', 0);
59
60
INSERT IGNORE INTO permissions (module_bit, code, description) VALUES
61
       (21, 'can_edit_rotas', 'Create, edit and delete rotas'),
62
       (21, 'can_add_items_rotas', 'Add and remove items from rotas');
(-)a/installer/data/mysql/kohastructure.sql (+54 lines)
Lines 4099-4104 CREATE TABLE IF NOT EXISTS club_fields ( Link Here
4099
  CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE
4099
  CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE
4100
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4100
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4101
4101
4102
--
4103
-- Table structure for table `stockrotationrotas`
4104
--
4105
4106
CREATE TABLE IF NOT EXISTS stockrotationrotas (
4107
    rota_id int(11) auto_increment,          -- Stockrotation rota ID
4108
    title varchar(100) NOT NULL,            -- Title for this rota
4109
    description text NOT NULL default '',   -- Description for this rota
4110
    cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
4111
    active tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
4112
    PRIMARY KEY (`rota_id`)
4113
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4114
4115
--
4116
-- Table structure for table `stockrotationstages`
4117
--
4118
4119
CREATE TABLE IF NOT EXISTS stockrotationstages (
4120
    stage_id int(11) auto_increment,     -- Unique stage ID
4121
    position int(11) NOT NULL,           -- The position of this stage within its rota
4122
    rota_id int(11) NOT NULL,            -- The rota this stage belongs to
4123
    branchcode_id varchar(10) NOT NULL,  -- Branch this stage relates to
4124
    duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
4125
    PRIMARY KEY (`stage_id`),
4126
    CONSTRAINT `stockrotationstages_rifk`
4127
      FOREIGN KEY (`rota_id`)
4128
      REFERENCES `stockrotationrotas` (`rota_id`)
4129
      ON UPDATE CASCADE ON DELETE CASCADE,
4130
    CONSTRAINT `stockrotationstages_bifk`
4131
      FOREIGN KEY (`branchcode_id`)
4132
      REFERENCES `branches` (`branchcode`)
4133
      ON UPDATE CASCADE ON DELETE CASCADE
4134
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4135
4136
--
4137
-- Table structure for table `stockrotationitems`
4138
--
4139
4140
CREATE TABLE IF NOT EXISTS stockrotationitems (
4141
    itemnumber_id int(11) NOT NULL,         -- Itemnumber to link to a stage & rota
4142
    stage_id int(11) NOT NULL,              -- stage ID to link the item to
4143
    indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
4144
    fresh tinyint(1) NOT NULL default 0,    -- Flag showing item is only just added to rota
4145
    PRIMARY KEY (itemnumber_id),
4146
    CONSTRAINT `stockrotationitems_iifk`
4147
      FOREIGN KEY (`itemnumber_id`)
4148
      REFERENCES `items` (`itemnumber`)
4149
      ON UPDATE CASCADE ON DELETE CASCADE,
4150
    CONSTRAINT `stockrotationitems_sifk`
4151
      FOREIGN KEY (`stage_id`)
4152
      REFERENCES `stockrotationstages` (`stage_id`)
4153
      ON UPDATE CASCADE ON DELETE CASCADE
4154
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4155
4102
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4156
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4103
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4157
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4104
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4158
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/sysprefs.sql (-1 / +3 lines)
Lines 585-589 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
585
('XSLTListsDisplay','default','','Enable XSLT stylesheet control over lists pages display on intranet','Free'),
585
('XSLTListsDisplay','default','','Enable XSLT stylesheet control over lists pages display on intranet','Free'),
586
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
586
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
587
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
587
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
588
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo')
588
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'),
589
('StockRotation','0',NULL,'If ON, enables the stock rotation module','YesNo'),
590
('RotationPreventTransfers','0',NULL,'If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','YesNo')
589
;
591
;
(-)a/installer/data/mysql/userflags.sql (-1 / +2 lines)
Lines 18-22 INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES Link Here
18
(18,'coursereserves','Course reserves',0),
18
(18,'coursereserves','Course reserves',0),
19
(19, 'plugins', 'Koha plugins', '0'),
19
(19, 'plugins', 'Koha plugins', '0'),
20
(20, 'lists', 'Lists', 0),
20
(20, 'lists', 'Lists', 0),
21
(21, 'clubs', 'Patron clubs', '0')
21
(21, 'clubs', 'Patron clubs', '0'),
22
(22, 'stockrotation', 'Manage stockrotation operations', 0)
22
;
23
;
(-)a/installer/data/mysql/userpermissions.sql (-1 / +3 lines)
Lines 81-85 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
81
   (20, 'delete_public_lists', 'Delete public lists'),
81
   (20, 'delete_public_lists', 'Delete public lists'),
82
   (21, 'edit_templates', 'Create and update club templates'),
82
   (21, 'edit_templates', 'Create and update club templates'),
83
   (21, 'edit_clubs', 'Create and update clubs'),
83
   (21, 'edit_clubs', 'Create and update clubs'),
84
   (21, 'enroll', 'Enroll patrons in clubs')
84
   (21, 'enroll', 'Enroll patrons in clubs'),
85
   (22, 'can_edit_rotas', 'Create, edit and delete rotas'),
86
   (22, 'can_add_items_rotas', 'Add and remove items from rotas')
85
;
87
;
(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/permissions.inc (+1 lines)
Lines 20-25 Link Here
20
    [%- CASE 'plugins' -%]<span>Koha plugins</span>
20
    [%- CASE 'plugins' -%]<span>Koha plugins</span>
21
    [%- CASE 'lists' -%]<span>Lists</span>
21
    [%- CASE 'lists' -%]<span>Lists</span>
22
    [%- CASE 'clubs' -%]<span>Patron clubs</span>
22
    [%- CASE 'clubs' -%]<span>Patron clubs</span>
23
    [%- CASE 'stockrotation' -%]<span>Manage stockrotation operations</span>
23
    [%- END -%]
24
    [%- END -%]
24
[%- END -%]
25
[%- END -%]
25
26
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +13 lines)
Lines 826-831 Circulation: Link Here
826
                  yes: Enable
826
                  yes: Enable
827
                  no: Disable
827
                  no: Disable
828
            - "housebound module"
828
            - "housebound module"
829
    Stockrotation module:
830
        -
831
            - pref: StockRotation
832
              choices:
833
                  yes: Enable
834
                  no: Disable
835
            - "Enable the stock rotation module"
836
        -
837
            - pref: RotationPreventTransfers
838
              choices:
839
                  yes: Enable
840
                  no: Disable
841
            - "Prevent branchtransfers on items in stockrotation rotas"
829
    Article Requests:
842
    Article Requests:
830
        -
843
        -
831
            - pref: ArticleRequests
844
            - pref: ArticleRequests
832
- 

Return to bug 11897