Attachment #80087 for bug #11897

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




-- 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`),
    CONSTRAINT `stockrotationrotas_title`
      UNIQUE (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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=utf8mb4 COLLATE=utf8mb4_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?
    fresh tinyint(1) NOT NULL default 0,    -- Flag showing item is only just added to rota
    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=utf8mb4 COLLATE=utf8mb4_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
       (24, 'stockrotation', 'Manage stockrotation operations', 0);

INSERT IGNORE INTO permissions (module_bit, code, description) VALUES
       (24, 'manage_rotas', 'Create, edit and delete rotas'),
       (24, 'manage_rota_items', 'Add and remove items from rotas');

-- Notices

INSERT IGNORE INTO letter (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
       ('circulation', 'SR_SLIP', '', 'Stock Rotation Slip', 0, 'Stockrotation Report', 'Stockrotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason ne \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent Library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');

Lines 176-183 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here

(-)a/installer/data/mysql/en/mandatory/sample_notices.sql (-1 / +2 lines)
176	('circulation', 'AR_SLIP', '', 'Article request - print slip', 0, 'Article request', 'Article request:\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nTitle: <<biblio.title>>\r\nBarcode: <<items.barcode>>\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n', 'print'),	176	('circulation', 'AR_SLIP', '', 'Article request - print slip', 0, 'Article request', 'Article request:\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nTitle: <<biblio.title>>\r\nBarcode: <<items.barcode>>\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n', 'print'),
177	('circulation', 'AR_PROCESSING', '', 'Article request - processing', 0, 'Article request processing', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nWe are now processing your request for an article from <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n\r\nThank you!', 'email'),	177	('circulation', 'AR_PROCESSING', '', 'Article request - processing', 0, 'Article request processing', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nWe are now processing your request for an article from <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n\r\nThank you!', 'email'),
178	('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<<borrowers.firstname>> <<borrowers.surname>> has added a note to the item <<biblio.title>> - <<biblio.author>> (<<biblio.biblionumber>>).','email');	178	('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<<borrowers.firstname>> <<borrowers.surname>> has added a note to the item <<biblio.title>> - <<biblio.author>> (<<biblio.biblionumber>>).','email');
179
180	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`)	179	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`)
181	VALUES	180	VALUES
182	('circulation', 'ACCOUNT_PAYMENT', '', 'Account payment', 0, 'Account payment', '[%- USE Price -%]\r\nA payment of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis payment affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default'),	181	('circulation', 'ACCOUNT_PAYMENT', '', 'Account payment', 0, 'Account payment', '[%- USE Price -%]\r\nA payment of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis payment affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default'),
183	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');	182	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');
		183	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
		184	('circulation', 'SR_SLIP', '', 'Stock Rotation Slip', 0, 'Stockrotation Report', 'Stockrotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason ne \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent Library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');




    description MEDIUMTEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary
    ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group
    ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups
     ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups
    created_on TIMESTAMP NULL,             -- Date and time of creation
    updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last
    PRIMARY KEY id ( id ),

    PRIMARY KEY (`access_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `stockrotationrotas`
--

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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `stockrotationstages`
--

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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `stockrotationitems`
--

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?
    fresh tinyint(1) NOT NULL default 0,    -- Flag showing item is only just added to rota
    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=utf8mb4 COLLATE=utf8mb4_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 */;

Lines 20-23 INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES Link Here

(-)a/installer/data/mysql/userflags.sql (+1 lines)
20	(21, 'clubs', 'Patron clubs', '0'),	20	(21, 'clubs', 'Patron clubs', '0'),
21	(22,'ill','The Interlibrary Loans Module',0),	21	(22,'ill','The Interlibrary Loans Module',0),
22	(23,'self_check','Self check modules',0)	22	(23,'self_check','Self check modules',0)
		23	(24, 'stockrotation', 'Manage stockrotation operations', 0)
23	;	24	;

Lines 89-92 INSERT INTO permissions (module_bit, code, description) VALUES Link Here

(-)a/installer/data/mysql/userpermissions.sql (+2 lines)
89	(21, 'enroll', 'Enroll patrons in clubs'),	89	(21, 'enroll', 'Enroll patrons in clubs'),
90	(23, 'self_checkin_module', 'Log into the self check-in module'),	90	(23, 'self_checkin_module', 'Log into the self check-in module'),
91	(23, 'self_checkout_module', 'Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID')	91	(23, 'self_checkout_module', 'Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID')
		92	(24, 'manage_rotas', 'Create, edit and delete rotas'),
		93	(24, 'manage_rota_items', 'Add and remove items from rotas')
92	;	94	;

Lines 21-26 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/permissions.inc (+4 lines)
21	[%- CASE 'clubs' -%]<span>Patron clubs</span>	21	[%- CASE 'clubs' -%]<span>Patron clubs</span>
22	[%- CASE 'ill' -%]<span>Create and modify Interlibrary loan requests</span>	22	[%- CASE 'ill' -%]<span>Create and modify Interlibrary loan requests</span>
23	[%- CASE 'self_check' -%]<span>Self check modules</span>	23	[%- CASE 'self_check' -%]<span>Self check modules</span>
		24	[%- CASE 'stockrotation' -%]<span>Manage stockrotation operations</span>
24	[%- END -%]	25	[%- END -%]
25	[%- END -%]	26	[%- END -%]
26		27
Lines 118-121 Link Here
118	[%- CASE 'self_checkin_module' -%]<span>Log into the self check-in module. Note: this permission prevents the patron from using any other OPAC functionality</span>	119	[%- CASE 'self_checkin_module' -%]<span>Log into the self check-in module. Note: this permission prevents the patron from using any other OPAC functionality</span>
119	[%- CASE 'self_checkout_module' -%]<span>Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID</span>	120	[%- CASE 'self_checkout_module' -%]<span>Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID</span>
120	[%- END -%]	121	[%- END -%]
		122	[%- CASE 'can_add_items_rotas' -%]<span>Add and remove items from rotas</span>
		123	[%- CASE 'can_edit_rotas' -%]<span>Create, edit and delete rotas</span>
		124	[%- END -%]
121	[%- END -%]	125	[%- END -%]




                  yes: Enable
                  no: Disable
            - "housebound module"
    Stockrotation module:
        -
            - pref: StockRotation
              choices:
                  yes: Enable
                  no: Disable
            - "the stock rotation module"
        -
            - pref: RotationPreventTransfers
              choices:
                  yes: Disallow
                  no: Allow
            - "library transfers on items in stockrotation rotas"
    Article Requests:
        -
            - pref: ArticleRequests
- 

Return to bug 11897

Lines 4187-4193 CREATE TABLE library_groups ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +55 lines)
4187	description MEDIUMTEXT NULL DEFAULT NULL, -- Longer explanation of the group, if necessary	4187	description MEDIUMTEXT NULL DEFAULT NULL, -- Longer explanation of the group, if necessary
4188	ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group	4188	ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group
4189	ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups	4189	ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups
4190	ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups	4190	ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups
4191	created_on TIMESTAMP NULL, -- Date and time of creation	4191	created_on TIMESTAMP NULL, -- Date and time of creation
4192	updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last	4192	updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last
4193	PRIMARY KEY id ( id ),	4193	PRIMARY KEY id ( id ),
Lines 4208-4213 CREATE TABLE `oauth_access_tokens` ( Link Here
4208	PRIMARY KEY (`access_token`)	4208	PRIMARY KEY (`access_token`)
4209	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	4209	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4210		4210
		4211	--
		4212	-- Table structure for table `stockrotationrotas`
		4213	--
		4214
		4215	CREATE TABLE IF NOT EXISTS stockrotationrotas (
		4216	rota_id int(11) auto_increment, -- Stockrotation rota ID
		4217	title varchar(100) NOT NULL, -- Title for this rota
		4218	description text NOT NULL default '', -- Description for this rota
		4219	cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
		4220	active tinyint(1) NOT NULL default 0, -- Is this rota currently active?
		4221	PRIMARY KEY (`rota_id`)
		4222	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		4223
		4224	--
		4225	-- Table structure for table `stockrotationstages`
		4226	--
		4227
		4228	CREATE TABLE IF NOT EXISTS stockrotationstages (
		4229	stage_id int(11) auto_increment, -- Unique stage ID
		4230	position int(11) NOT NULL, -- The position of this stage within its rota
		4231	rota_id int(11) NOT NULL, -- The rota this stage belongs to
		4232	branchcode_id varchar(10) NOT NULL, -- Branch this stage relates to
		4233	duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
		4234	PRIMARY KEY (`stage_id`),
		4235	CONSTRAINT `stockrotationstages_rifk`
		4236	FOREIGN KEY (`rota_id`)
		4237	REFERENCES `stockrotationrotas` (`rota_id`)
		4238	ON UPDATE CASCADE ON DELETE CASCADE,
		4239	CONSTRAINT `stockrotationstages_bifk`
		4240	FOREIGN KEY (`branchcode_id`)
		4241	REFERENCES `branches` (`branchcode`)
		4242	ON UPDATE CASCADE ON DELETE CASCADE
		4243	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		4244
		4245	--
		4246	-- Table structure for table `stockrotationitems`
		4247	--
		4248
		4249	CREATE TABLE IF NOT EXISTS stockrotationitems (
		4250	itemnumber_id int(11) NOT NULL, -- Itemnumber to link to a stage & rota
		4251	stage_id int(11) NOT NULL, -- stage ID to link the item to
		4252	indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
		4253	fresh tinyint(1) NOT NULL default 0, -- Flag showing item is only just added to rota
		4254	PRIMARY KEY (itemnumber_id),
		4255	CONSTRAINT `stockrotationitems_iifk`
		4256	FOREIGN KEY (`itemnumber_id`)
		4257	REFERENCES `items` (`itemnumber`)
		4258	ON UPDATE CASCADE ON DELETE CASCADE,
		4259	CONSTRAINT `stockrotationitems_sifk`
		4260	FOREIGN KEY (`stage_id`)
		4261	REFERENCES `stockrotationstages` (`stage_id`)
		4262	ON UPDATE CASCADE ON DELETE CASCADE
		4263	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		4264
4211	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;	4265	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
4212	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;	4266	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
4213	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;	4267	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;

Lines 950-955 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +13 lines)
950	yes: Enable	950	yes: Enable
951	no: Disable	951	no: Disable
952	- "housebound module"	952	- "housebound module"
		953	Stockrotation module:
		954	-
		955	- pref: StockRotation
		956	choices:
		957	yes: Enable
		958	no: Disable
		959	- "the stock rotation module"
		960	-
		961	- pref: RotationPreventTransfers
		962	choices:
		963	yes: Disallow
		964	no: Allow
		965	- "library transfers on items in stockrotation rotas"
953	Article Requests:	966	Article Requests:
954	-	967	-
955	- pref: ArticleRequests	968	- pref: ArticleRequests
956	-

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/stockrot_tables.sql (+69 lines)
		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	CONSTRAINT `stockrotationrotas_title`
		11	UNIQUE (`title`)
		12	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		13
		14	-- Stock Rotation Stages
		15
		16	CREATE TABLE IF NOT EXISTS stockrotationstages (
		17	stage_id int(11) auto_increment, -- Unique stage ID
		18	position int(11) NOT NULL, -- The position of this stage within its rota
		19	rota_id int(11) NOT NULL, -- The rota this stage belongs to
		20	branchcode_id varchar(10) NOT NULL, -- Branch this stage relates to
		21	duration int(11) NOT NULL default 4, -- The number of days items shoud occupy this stage
		22	PRIMARY KEY (`stage_id`),
		23	CONSTRAINT `stockrotationstages_rifk`
		24	FOREIGN KEY (`rota_id`)
		25	REFERENCES `stockrotationrotas` (`rota_id`)
		26	ON UPDATE CASCADE ON DELETE CASCADE,
		27	CONSTRAINT `stockrotationstages_bifk`
		28	FOREIGN KEY (`branchcode_id`)
		29	REFERENCES `branches` (`branchcode`)
		30	ON UPDATE CASCADE ON DELETE CASCADE
		31	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		32
		33	-- Stock Rotation Items
		34
		35	CREATE TABLE IF NOT EXISTS stockrotationitems (
		36	itemnumber_id int(11) NOT NULL, -- Itemnumber to link to a stage & rota
		37	stage_id int(11) NOT NULL, -- stage ID to link the item to
		38	indemand tinyint(1) NOT NULL default 0, -- Should this item be skipped for rotation?
		39	fresh tinyint(1) NOT NULL default 0, -- Flag showing item is only just added to rota
		40	PRIMARY KEY (itemnumber_id),
		41	CONSTRAINT `stockrotationitems_iifk`
		42	FOREIGN KEY (`itemnumber_id`)
		43	REFERENCES `items` (`itemnumber`)
		44	ON UPDATE CASCADE ON DELETE CASCADE,
		45	CONSTRAINT `stockrotationitems_sifk`
		46	FOREIGN KEY (`stage_id`)
		47	REFERENCES `stockrotationstages` (`stage_id`)
		48	ON UPDATE CASCADE ON DELETE CASCADE
		49	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		50
		51	-- System preferences
		52
		53	INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES
		54	('StockRotation','0','If ON, enables the stock rotation module','','YesNo'),
		55	('RotationPreventTransfers','0','If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','','YesNo');
		56
		57	-- Permissions
		58
		59	INSERT IGNORE INTO userflags (bit, flag, flagdesc, defaulton) VALUES
		60	(24, 'stockrotation', 'Manage stockrotation operations', 0);
		61
		62	INSERT IGNORE INTO permissions (module_bit, code, description) VALUES
		63	(24, 'manage_rotas', 'Create, edit and delete rotas'),
		64	(24, 'manage_rota_items', 'Add and remove items from rotas');
65
66	-- Notices
67
68	INSERT IGNORE INTO letter (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
69	('circulation', 'SR_SLIP', '', 'Stock Rotation Slip', 0, 'Stockrotation Report', 'Stockrotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason ne \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent Library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');

Lines 485-490 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (+3 lines)
485	('reviewson','1','','If ON, enables patron reviews of bibliographic records in the OPAC','YesNo'),	485	('reviewson','1','','If ON, enables patron reviews of bibliographic records in the OPAC','YesNo'),
486	('RisExportAdditionalFields', '', NULL , 'Define additional RIS tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.', 'textarea'),	486	('RisExportAdditionalFields', '', NULL , 'Define additional RIS tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.', 'textarea'),
487	('RoutingListAddReserves','0','','If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),	487	('RoutingListAddReserves','0','','If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),
		488	('RotationPreventTransfers','0',NULL,'If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','YesNo'),
		489	('RoutingListAddReserves','1','','If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),
488	('RoutingListNote','To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference.','70\|10','Define a note to be shown on all routing lists','Textarea'),	490	('RoutingListNote','To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference.','70\|10','Define a note to be shown on all routing lists','Textarea'),
489	('RoutingSerials','1',NULL,'If ON, serials routing is enabled','YesNo'),	491	('RoutingSerials','1',NULL,'If ON, serials routing is enabled','YesNo'),
490	('SCOMainUserBlock','','70\|10','Add a block of HTML that will display on the self checkout screen','Textarea'),	492	('SCOMainUserBlock','','70\|10','Add a block of HTML that will display on the self checkout screen','Textarea'),
Lines 531-536 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
531	('StaffSerialIssueDisplayCount','3','','Number of serial issues to display per subscription in the Staff client','Integer'),	533	('StaffSerialIssueDisplayCount','3','','Number of serial issues to display per subscription in the Staff client','Integer'),
532	('StaticHoldsQueueWeight','0',NULL,'Specify a list of library location codes separated by commas -- the list of codes will be traversed and weighted with first values given higher weight for holds fulfillment -- alternatively, if RandomizeHoldsQueueWeight is set, the list will be randomly selective','Integer'),	534	('StaticHoldsQueueWeight','0',NULL,'Specify a list of library location codes separated by commas -- the list of codes will be traversed and weighted with first values given higher weight for holds fulfillment -- alternatively, if RandomizeHoldsQueueWeight is set, the list will be randomly selective','Integer'),
533	('StatisticsFields','location\|itype\|ccode', NULL, 'Define Fields (from the items table) used for statistics members','Free'),	535	('StatisticsFields','location\|itype\|ccode', NULL, 'Define Fields (from the items table) used for statistics members','Free'),
		536	('StockRotation','0',NULL,'If ON, enables the stock rotation module','YesNo'),
534	('StoreLastBorrower','0','','If ON, the last borrower to return an item will be stored in items.last_returned_by','YesNo'),	537	('StoreLastBorrower','0','','If ON, the last borrower to return an item will be stored in items.last_returned_by','YesNo'),
535	('SubfieldsToAllowForRestrictedBatchmod','','Define a list of subfields for which edition is authorized when items_batchmod_restricted permission is enabled, separated by spaces. Example: 995\$f 995\$h 995\$j',NULL,'Free'),	538	('SubfieldsToAllowForRestrictedBatchmod','','Define a list of subfields for which edition is authorized when items_batchmod_restricted permission is enabled, separated by spaces. Example: 995\$f 995\$h 995\$j',NULL,'Free'),
536	('SubfieldsToAllowForRestrictedEditing','','Define a list of subfields for which edition is authorized when edit_items_restricted permission is enabled, separated by spaces. Example: 995\$f 995\$h 995\$j',NULL,'Free'),	539	('SubfieldsToAllowForRestrictedEditing','','Define a list of subfields for which edition is authorized when edit_items_restricted permission is enabled, separated by spaces. Example: 995\$f 995\$h 995\$j',NULL,'Free'),