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 4089-4094 CREATE TABLE IF NOT EXISTS club_fields ( Link Here
4089
  CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE
4089
  CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE
4090
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4090
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4091
4091
4092
--
4093
-- Table structure for table `stockrotationrotas`
4094
--
4095
4096
CREATE TABLE IF NOT EXISTS stockrotationrotas (
4097
    rota_id int(11) auto_increment,          -- Stockrotation rota ID
4098
    title varchar(100) NOT NULL,            -- Title for this rota
4099
    description text NOT NULL default '',   -- Description for this rota
4100
    cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
4101
    active tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
4102
    PRIMARY KEY (`rota_id`)
4103
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4104
4105
--
4106
-- Table structure for table `stockrotationstages`
4107
--
4108
4109
CREATE TABLE IF NOT EXISTS stockrotationstages (
4110
    stage_id int(11) auto_increment,     -- Unique stage ID
4111
    position int(11) NOT NULL,           -- The position of this stage within its rota
4112
    rota_id int(11) NOT NULL,            -- The rota this stage belongs to
4113
    branchcode_id varchar(10) NOT NULL,  -- Branch this stage relates to
4114
    duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
4115
    PRIMARY KEY (`stage_id`),
4116
    CONSTRAINT `stockrotationstages_rifk`
4117
      FOREIGN KEY (`rota_id`)
4118
      REFERENCES `stockrotationrotas` (`rota_id`)
4119
      ON UPDATE CASCADE ON DELETE CASCADE,
4120
    CONSTRAINT `stockrotationstages_bifk`
4121
      FOREIGN KEY (`branchcode_id`)
4122
      REFERENCES `branches` (`branchcode`)
4123
      ON UPDATE CASCADE ON DELETE CASCADE
4124
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4125
4126
--
4127
-- Table structure for table `stockrotationitems`
4128
--
4129
4130
CREATE TABLE IF NOT EXISTS stockrotationitems (
4131
    itemnumber_id int(11) NOT NULL,         -- Itemnumber to link to a stage & rota
4132
    stage_id int(11) NOT NULL,              -- stage ID to link the item to
4133
    indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
4134
    fresh tinyint(1) NOT NULL default 0,    -- Flag showing item is only just added to rota
4135
    PRIMARY KEY (itemnumber_id),
4136
    CONSTRAINT `stockrotationitems_iifk`
4137
      FOREIGN KEY (`itemnumber_id`)
4138
      REFERENCES `items` (`itemnumber`)
4139
      ON UPDATE CASCADE ON DELETE CASCADE,
4140
    CONSTRAINT `stockrotationitems_sifk`
4141
      FOREIGN KEY (`stage_id`)
4142
      REFERENCES `stockrotationstages` (`stage_id`)
4143
      ON UPDATE CASCADE ON DELETE CASCADE
4144
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4145
4092
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4146
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4093
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4147
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4094
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4148
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/sysprefs.sql (-1 / +3 lines)
Lines 579-583 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
579
('XSLTListsDisplay','default','','Enable XSLT stylesheet control over lists pages display on intranet','Free'),
579
('XSLTListsDisplay','default','','Enable XSLT stylesheet control over lists pages display on intranet','Free'),
580
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
580
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
581
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
581
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
582
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo')
582
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'),
583
('StockRotation','0',NULL,'If ON, enables the stock rotation module','YesNo'),
584
('RotationPreventTransfers','0',NULL,'If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','YesNo')
583
;
585
;
(-)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 813-818 Circulation: Link Here
813
                  yes: Enable
813
                  yes: Enable
814
                  no: Disable
814
                  no: Disable
815
            - "housebound module"
815
            - "housebound module"
816
    Stockrotation module:
817
        -
818
            - pref: StockRotation
819
              choices:
820
                  yes: Enable
821
                  no: Disable
822
            - "Enable the stock rotation module"
823
        -
824
            - pref: RotationPreventTransfers
825
              choices:
826
                  yes: Enable
827
                  no: Disable
828
            - "Prevent branchtransfers on items in stockrotation rotas"
816
    Article Requests:
829
    Article Requests:
817
        -
830
        -
818
            - pref: ArticleRequests
831
            - pref: ArticleRequests
819
- 

Return to bug 11897