Attachment 58207 Details for Bug 11897 – Bug 11897: Add Stock Rotation atomic update schema.

[patch] Bug 11897: Add Stock Rotation atomic update schema.

Bug-11897-Add-Stock-Rotation-atomic-update-schema.patch (text/plain), 9.95 KB, created by Andrew Isherwood on 2016-12-15 16:51:05 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Andrew Isherwood

Created: 2016-12-15 16:51:05 UTC

Size: 9.95 KB

patch

obsolete

>From d671335db5b07c2e29643695a7b856a86477303d Mon Sep 17 00:00:00 2001
>From: Alex Sassmannshausen <alex.sassmannshausen@ptfs-europe.com>
>Date: Mon, 17 Oct 2016 18:20:44 +0200
>Subject: [PATCH] Bug 11897: Add Stock Rotation atomic update schema.
>
>* installer/data/mysql/atomicupdate/stockrot_tables.sql: New file.
>* installer/data/mysql/kohastructure.sql (stockrotationrotas)
>  (stockrotationstages, stockrotationitems): New tables.
>* installer/data/mysql/sysprefs.sql: Add Stockrotation sysprefs.
>* installer/data/mysql/userflags.sql: Add Stockrotaiton userflag.
>* installer/data/mysql/userpermissions.sql: Add Stockrotation
>  userpermissions.
>* koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref:
>  Add Stockrotation menu.
>---
> .../data/mysql/atomicupdate/stockrot_tables.sql    | 61 ++++++++++++++++++++++
> installer/data/mysql/kohastructure.sql             | 47 +++++++++++++++++
> installer/data/mysql/sysprefs.sql                  |  2 +
> installer/data/mysql/userflags.sql                 |  1 +
> installer/data/mysql/userpermissions.sql           |  2 +
> .../en/modules/admin/preferences/circulation.pref  | 13 +++++
> 6 files changed, 126 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/stockrot_tables.sql
>
>diff --git a/installer/data/mysql/atomicupdate/stockrot_tables.sql b/installer/data/mysql/atomicupdate/stockrot_tables.sql
>new file mode 100644
>index 0000000..ee8cee1
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/stockrot_tables.sql
>@@ -0,0 +1,61 @@
>+-- Stock Rotation Rotas
>+
>+CREATE TABLE IF NOT EXISTS stockrotationrotas (
>+    rota_id int(11) auto_increment,          -- Stockrotation rota ID
>+    title varchar(100) NOT NULL,            -- Title for this rota
>+    description text NOT NULL default '',   -- Description for this rota
>+    cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
>+    active tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
>+    PRIMARY KEY (`rota_id`)
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>+
>+-- Stock Rotation Stages
>+
>+CREATE TABLE IF NOT EXISTS stockrotationstages (
>+    stage_id int(11) auto_increment,     -- Unique stage ID
>+    position int(11) NOT NULL,           -- The position of this stage within its rota
>+    rota_id int(11) NOT NULL,            -- The rota this stage belongs to
>+    branchcode_id varchar(10) NOT NULL,  -- Branch this stage relates to
>+    duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
>+    PRIMARY KEY (`stage_id`),
>+    CONSTRAINT `stockrotationstages_rifk`
>+      FOREIGN KEY (`rota_id`)
>+      REFERENCES `stockrotationrotas` (`rota_id`)
>+      ON UPDATE CASCADE ON DELETE CASCADE,
>+    CONSTRAINT `stockrotationstages_bifk`
>+      FOREIGN KEY (`branchcode_id`)
>+      REFERENCES `branches` (`branchcode`)
>+      ON UPDATE CASCADE ON DELETE CASCADE
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>+
>+-- Stock Rotation Items
>+
>+CREATE TABLE IF NOT EXISTS stockrotationitems (
>+    itemnumber_id int(11) NOT NULL,         -- Itemnumber to link to a stage & rota
>+    stage_id int(11) NOT NULL,              -- stage ID to link the item to
>+    indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
>+    PRIMARY KEY (itemnumber_id),
>+    CONSTRAINT `stockrotationitems_iifk`
>+      FOREIGN KEY (`itemnumber_id`)
>+      REFERENCES `items` (`itemnumber`)
>+      ON UPDATE CASCADE ON DELETE CASCADE,
>+    CONSTRAINT `stockrotationitems_sifk`
>+      FOREIGN KEY (`stage_id`)
>+      REFERENCES `stockrotationstages` (`stage_id`)
>+      ON UPDATE CASCADE ON DELETE CASCADE
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>+
>+-- System preferences
>+
>+INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES
>+       ('StockRotation','0','If ON, enables the stock rotation module','','YesNo'),
>+       ('RotationPreventTransfers','0','If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','','YesNo');
>+
>+-- Permissions
>+
>+INSERT IGNORE INTO userflags (bit, flag, flagdesc, defaulton) VALUES
>+       (21, 'stockrotation', 'Manage stockrotation operations', 0);
>+
>+INSERT IGNORE INTO permissions (module_bit, code, description) VALUES
>+       (21, 'can_edit_rotas', 'Create, edit and delete rotas'),
>+       (21, 'can_add_items_rotas', 'Add and remove items from rotas');
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 514c13d..52eb7c6 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -3921,6 +3921,53 @@ CREATE TABLE `article_requests` (
>   CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
> 
>+-- Stock Rotation Rotas
>+
>+CREATE TABLE IF NOT EXISTS stockrotationrotas (
>+    rota_id int(11) auto_increment,          -- Stockrotation rota ID
>+    title varchar(100) NOT NULL,            -- Title for this rota
>+    description text NOT NULL default '',   -- Description for this rota
>+    cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
>+    active tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
>+    PRIMARY KEY (`rota_id`)
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>+
>+-- Stock Rotation Stages
>+
>+CREATE TABLE IF NOT EXISTS stockrotationstages (
>+    stage_id int(11) auto_increment,     -- Unique stage ID
>+    position int(11) NOT NULL,           -- The position of this stage within its rota
>+    rota_id int(11) NOT NULL,            -- The rota this stage belongs to
>+    branchcode_id varchar(10) NOT NULL,  -- Branch this stage relates to
>+    duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
>+    PRIMARY KEY (`stage_id`),
>+    CONSTRAINT `stockrotationstages_rifk`
>+      FOREIGN KEY (`rota_id`)
>+      REFERENCES `stockrotationrotas` (`rota_id`)
>+      ON UPDATE CASCADE ON DELETE CASCADE,
>+    CONSTRAINT `stockrotationstages_bifk`
>+      FOREIGN KEY (`branchcode_id`)
>+      REFERENCES `branches` (`branchcode`)
>+      ON UPDATE CASCADE ON DELETE CASCADE
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>+
>+-- Stock Rotation Items
>+
>+CREATE TABLE IF NOT EXISTS stockrotationitems (
>+    itemnumber_id int(11) NOT NULL,         -- Itemnumber to link to a stage & rota
>+    stage_id int(11) NOT NULL,              -- stage ID to link the item to
>+    indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
>+    PRIMARY KEY (itemnumber_id),
>+    CONSTRAINT `stockrotationitems_iifk`
>+      FOREIGN KEY (`itemnumber_id`)
>+      REFERENCES `items` (`itemnumber`)
>+      ON UPDATE CASCADE ON DELETE CASCADE,
>+    CONSTRAINT `stockrotationitems_sifk`
>+      FOREIGN KEY (`stage_id`)
>+      REFERENCES `stockrotationstages` (`stage_id`)
>+      ON UPDATE CASCADE ON DELETE CASCADE
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>+
> /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
> /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
>diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
>index ef83c3d..89792d9 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -564,4 +564,6 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
> ('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
> ('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo')
>+('StockRotation','0','If ON, enables the stock rotation module','','YesNo')
>+('RotationPreventTransfers','0','If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','','YesNo')
> ;
>diff --git a/installer/data/mysql/userflags.sql b/installer/data/mysql/userflags.sql
>index d8e3626..a66243c 100644
>--- a/installer/data/mysql/userflags.sql
>+++ b/installer/data/mysql/userflags.sql
>@@ -18,4 +18,5 @@ INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES
> (18,'coursereserves','Course reserves',0),
> (19, 'plugins', 'Koha plugins', '0'),
> (20, 'lists', 'Lists', 0)
>+(21, 'stockrotation', 'Manage stockrotation operations', 0)
> ;
>diff --git a/installer/data/mysql/userpermissions.sql b/installer/data/mysql/userpermissions.sql
>index 6b72278..b9f36c6 100644
>--- a/installer/data/mysql/userpermissions.sql
>+++ b/installer/data/mysql/userpermissions.sql
>@@ -79,4 +79,6 @@ INSERT INTO permissions (module_bit, code, description) VALUES
>    (19, 'report', 'Use report plugins'),
>    (19, 'configure', 'Configure plugins'),
>    (20, 'delete_public_lists', 'Delete public lists')
>+   (21, 'can_edit_rotas', 'Create, edit and delete rotas')
>+   (21, 'can_add_items_rotas', 'Add and remove items from rotas')
> ;
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
>index e69e37f..1bd4998 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
>@@ -782,6 +782,19 @@ Circulation:
>                   yes: Enable
>                   no: Disable
>             - "housebound module"
>+    Stockrotation module:
>+        -
>+            - pref: StockRotation
>+              choices:
>+                  yes: Enable
>+                  no: Disable
>+            - "Enable the stock rotation module"
>+        -
>+            - pref: RotationPreventTransfers
>+              choices:
>+                  yes: Enable
>+                  no: Disable
>+            - "Prevent branchtransfers on items in stockrotation rotas"
>     Article Requests:
>         -
>             - pref: ArticleRequests
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 11897: 25887 | 58207 | 58208 | 58209 | 58210 | 58211 | 58212 | 58213 | 58214 | 58215 | 58216 | 58217 | 58218 | 58219 | 58280 | 58281 | 58687 | 58692 | 58693 | 58694 | 58695 | 58696 | 60175 | 60715 | 61825 | 61826 | 61827 | 61828 | 61829 | 61830 | 61831 | 61832 | 61833 | 61834 | 61835 | 61836 | 61837 | 61838 | 61839 | 61885 | 62730 | 62750 | 62751 | 62752 | 62753 | 62754 | 62755 | 62756 | 62757 | 62758 | 62759 | 62760 | 62761 | 62762 | 62763 | 62764 | 62765 | 62766 | 62767 | 63063 | 63064 | 63065 | 63066 | 63067 | 63068 | 63069 | 63070 | 63071 | 63072 | 63073 | 63074 | 63075 | 63076 | 63077 | 63078 | 63079 | 63080 | 63114 | 64850 | 64851 | 65715 | 65716 | 65717 | 65718 | 65719 | 65720 | 65721 | 65722 | 65723 | 65724 | 65725 | 65726 | 65727 | 65728 | 65729 | 65730 | 65731 | 65732 | 65733 | 65734 | 65735 | 65736 | 65737 | 65738 | 65739 | 65740 | 65741 | 65742 | 65743 | 65744 | 65745 | 65746 | 65747 | 65748 | 65749 | 65750 | 65751 | 65752 | 65753 | 65754 | 65755 | 65756 | 65757 | 65758 | 66381 | 70496 | 70497 | 70498 | 70499 | 70500 | 70501 | 70502 | 70503 | 70504 | 70505 | 70506 | 70507 | 70508 | 70509 | 70510 | 70511 | 70512 | 70513 | 70514 | 70515 | 70516 | 70517 | 70518 | 70519 | 70520 | 70521 | 70522 | 70523 | 70524 | 72124 | 72125 | 72126 | 72127 | 72128 | 74003 | 74004 | 74005 | 74006 | 74007 | 74008 | 74010 | 74011 | 74012 | 74013 | 74014 | 74015 | 74016 | 74017 | 74197 | 74198 | 74199 | 74200 | 74201 | 74202 | 74203 | 74204 | 74205 | 74206 | 74319 | 74320 | 74360 | 74459 | 74460 | 74461 | 74462 | 74463 | 74464 | 74465 | 74466 | 74467 | 74468 | 74469 | 74470 | 75409 | 75410 | 75411 | 75412 | 75413 | 75414 | 75415 | 75416 | 75417 | 75418 | 75419 | 75420 | 76121 | 76122 | 76123 | 76124 | 76125 | 76126 | 76127 | 76128 | 76129 | 76130 | 76131 | 76132 | 76133 | 76134 | 76135 | 76144 | 76706 | 76707 | 76708 | 76709 | 76710 | 77623 | 77624 | 77625 | 77626 | 78387 | 78388 | 78389 | 78390 | 78391 | 78392 | 78393 | 78394 | 78404 | 78405 | 78406 | 78407 | 78408 | 79040 | 79041 | 79042 | 79043 | 79044 | 79738 | 79739 | 79740 | 79741 | 79742 | 79746 | 79747 | 79748 | 79749 | 79750 | 79964 | 79965 | 79966 | 79967 | 79968 | 79969 | 79970 | 79971 | 79972 | 79973 | 79974 | 79975 | 80068 | 80087 | 80088 | 80089 | 80090 | 80091 | 80092 | 80093 | 80094 | 80095 | 80096 | 80097 | 80098 | 80099 | 80100 | 80118 | 80260 | 80261 | 80262 | 80263 | 80264 | 80265 | 80266 | 80267 | 80268 | 80269 | 80270 | 80271 | 80272 | 80273 | 80274 | 80275 | 80289 | 80298 | 80299 | 80300