Attachment 32053 Details for Bug 9303 – Bug 9303 [1] - relative's checkouts in the opac - Database Updates

[patch] Bug 9303 [1] - relative's checkouts in the opac - Database Updates

Bug-9303-1---relatives-checkouts-in-the-opac---Dat.patch (text/plain), 9.16 KB, created by Kyle M Hall (khall) on 2014-10-08 10:06:50 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2014-10-08 10:06:50 UTC

Size: 9.16 KB

patch

obsolete

>From 32fc55916955aa68f9d437750f9d667778e1fda3 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Mon, 21 Jul 2014 11:48:28 -0400
>Subject: [PATCH] Bug 9303 [1] - relative's checkouts in the opac - Database Updates
>
>Signed-off-by: Nick Clemens <nick@quecheelibrary.org>
>---
> installer/data/mysql/kohastructure.sql |    6 +++
> installer/data/mysql/sysprefs.sql      |    2 +
> installer/data/mysql/updatedatabase.pl |   63 ++++++++++++++++++++++++++++++++
> 3 files changed, 71 insertions(+), 0 deletions(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index aeeba17..16c9e57 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -265,6 +265,7 @@ CREATE TABLE `borrowers` ( -- this table includes information about your patrons
>   `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
>   `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
>   `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
>+  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
>   UNIQUE KEY `cardnumber` (`cardnumber`),
>   PRIMARY KEY `borrowernumber` (`borrowernumber`),
>   KEY `categorycode` (`categorycode`),
>@@ -868,6 +869,7 @@ CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
>   `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
>   `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
>   `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
>+  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
>   KEY borrowernumber (borrowernumber),
>   KEY `cardnumber` (`cardnumber`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>@@ -1114,6 +1116,7 @@ CREATE TABLE `import_items` (
> 
> DROP TABLE IF EXISTS `issues`;
> CREATE TABLE `issues` ( -- information related to check outs or issues
>+  `issue_id` int(11) NOT NULL AUTO_INCREMENT, -- primary key for issues table
>   `borrowernumber` int(11), -- foreign key, linking this to the borrowers table for the patron this item was checked out to
>   `itemnumber` int(11), -- foreign key, linking this to the items table for the item that was checked out
>   `date_due` datetime default NULL, -- datetime the item is due (yyyy-mm-dd hh:mm::ss)
>@@ -1126,6 +1129,7 @@ CREATE TABLE `issues` ( -- information related to check outs or issues
>   `auto_renew` BOOLEAN default FALSE, -- automatic renewal
>   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
>   `issuedate` datetime default NULL, -- date the item was checked out or issued
>+  PRIMARY KEY (`issue_id`),
>   KEY `issuesborridx` (`borrowernumber`),
>   KEY `itemnumber_idx` (`itemnumber`),
>   KEY `branchcode_idx` (`branchcode`),
>@@ -1587,6 +1591,7 @@ CREATE TABLE `oai_sets_biblios` (
> 
> DROP TABLE IF EXISTS `old_issues`;
> CREATE TABLE `old_issues` ( -- lists items that were checked out and have been returned
>+  `issue_id` int(11) NOT NULL AUTO_INCREMENT, -- primary key for issues table
>   `borrowernumber` int(11) default NULL, -- foreign key, linking this to the borrowers table for the patron this item was checked out to
>   `itemnumber` int(11) default NULL, -- foreign key, linking this to the items table for the item that was checked out
>   `date_due` datetime default NULL, -- date the item is due (yyyy-mm-dd)
>@@ -1599,6 +1604,7 @@ CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
>   `auto_renew` BOOLEAN default FALSE, -- automatic renewal
>   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
>   `issuedate` datetime default NULL, -- date the item was checked out or issued
>+  PRIMARY KEY (`issue_id`),
>   KEY `old_issuesborridx` (`borrowernumber`),
>   KEY `old_issuesitemidx` (`itemnumber`),
>   KEY `branchcode_idx` (`branchcode`),
>diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
>index b06b163..33fb9ff 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -26,11 +26,13 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('AllowNotForLoanOverride','0','','If ON, Koha will allow the librarian to loan a not for loan item.','YesNo'),
> ('AllowOfflineCirculation','0','','If on, enables HTML5 offline circulation functionality.','YesNo'),
> ('AllowOnShelfHolds','0','','Allow hold requests to be placed on items that are not on loan','YesNo'),
>+('AllowPatronToSetCheckoutsVisibilityForGuarantor',  '0', NULL, 'If enabled, the patron can set checkouts to be visible to his or her guarantor',  'YesNo'),
> ('AllowPKIAuth','None','None|Common Name|emailAddress','Use the field from a client-side SSL certificate to look a user in the Koha database','Choice'),
> ('AllowPurchaseSuggestionBranchChoice','0','1','Allow user to choose branch when making a purchase suggestion','YesNo'),
> ('AllowRenewalLimitOverride','0',NULL,'if ON, allows renewal limits to be overridden on the circulation screen','YesNo'),
> ('AllowReturnToBranch','anywhere','anywhere|homebranch|holdingbranch|homeorholdingbranch','Where an item may be returned','Choice'),
> ('AllowSelfCheckReturns','0','','If enabled, patrons may return items through the Web-based Self Checkout','YesNo'),
>+('AllowStaffToSetCheckoutsVisibilityForGuarantor','0',NULL,'If enabled, library staff can set a patron''s checkouts to be visible to linked patrons from the opac.',  'YesNo'),
> ('AllowTooManyOverride','1','','If on, allow staff to override and check out items when the patron has reached the maximum number of allowed checkouts','YesNo'),
> ('alphabet','A B C D E F G H I J K L M N O P Q R S T U V W X Y Z',NULL,'Alphabet than can be expanded into browse links, e.g. on Home > Patrons','free'),
> ('AlternateHoldingsField','',NULL,'The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).','free'),
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 6ea5911..21a1109 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -37,6 +37,7 @@ use Getopt::Long;
> use C4::Context;
> use C4::Installer;
> use C4::Dates;
>+use Koha::Database;
> 
> use MARC::Record;
> use MARC::File::XML ( BinaryEncoding => 'utf8' );
>@@ -8781,6 +8782,68 @@ if ( CheckVersion($DBversion) ) {
>     SetVersion($DBversion);
> }
> 
>+$DBversion = "3.17.00.XXX";
>+if(CheckVersion($DBversion)) {
>+    $dbh->do(q{
>+        ALTER TABLE borrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'
>+    });
>+    $dbh->do(q{
>+        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'
>+    });
>+    $dbh->do(q{
>+        ALTER TABLE old_issues DROP PRIMARY KEY
>+    });
>+    $dbh->do(q{
>+        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
>+    });
>+    $dbh->do(q{
>+        ALTER TABLE old_issues DROP INDEX itemnumber_idx
>+    });
>+    $dbh->do(q{
>+        ALTER TABLE issues DROP PRIMARY KEY
>+    });
>+    $dbh->do(q{
>+        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
>+    });
>+    $dbh->do(q{
>+        ALTER TABLE issues DROP INDEX itemnumber_idx
>+    });
>+    $dbh->do(q{
>+        ALTER TABLE issues ADD UNIQUE itemnumber_idx (itemnumber)
>+    });
>+    $dbh->do(qq{
>+        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
>+    });
>+
>+    my $schema = Koha::Database->new()->schema();
>+    my $max_issue_id = $schema->resultset('Issue')->get_column('issue_id')->max();
>+    $max_issue_id ||= $schema->resultset('OldIssue')->get_column('issue_id')->max();
>+    $max_issue_id ||= 0;
>+    $max_issue_id++;
>+    $dbh->do(qq{
>+        ALTER TABLE issues AUTO_INCREMENT = $max_issue_id
>+    });
>+
>+    $dbh->do(q{
>+        INSERT INTO systempreferences (variable, value, options, explanation, type )
>+        VALUES (
>+            'AllowStaffToSetCheckoutsVisibilityForGuarantor',  '0', NULL,
>+            'If enabled, library staff can set a patron''s checkouts to be visible to linked patrons from the opac.',  'YesNo'
>+        )
>+    });
>+
>+    $dbh->do(q{
>+        INSERT INTO systempreferences (variable, value, options, explanation, type )
>+        VALUES (
>+            'AllowPatronToSetCheckoutsVisibilityForGuarantor',  '0', NULL,
>+            'If enabled, the patron can set checkouts to be visible to  his or her guarantor',  'YesNo'
>+        )
>+    });
>+
>+    print "Upgrade to $DBversion done (Bug 9303 - relative's checkouts in the opac)\n";
>+    SetVersion($DBversion);
>+}
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>-- 
>1.7.2.5

Actions: View | Diff | Splinter Review

Attachments on bug 9303: 22757 | 22770 | 22771 | 22772 | 22783 | 22789 | 22790 | 22809 | 22966 | 22967 | 22968 | 22974 | 22975 | 23086 | 23087 | 23088 | 23089 | 23090 | 23525 | 23526 | 23527 | 24009 | 24010 | 24011 | 24773 | 24774 | 24775 | 24776 | 25008 | 25584 | 25585 | 25586 | 27537 | 27538 | 27539 | 27540 | 27541 | 27542 | 27543 | 27698 | 27699 | 28153 | 28154 | 28155 | 28156 | 28157 | 28158 | 28159 | 28160 | 28161 | 28912 | 29171 | 29172 | 29215 | 29286 | 29287 | 29288 | 29289 | 29290 | 29299 | 29302 | 29303 | 29304 | 29932 | 29933 | 29934 | 29935 | 29936 | 29937 | 30287 | 30288 | 30289 | 30297 | 30298 | 30299 | 30300 | 32053 | 32054 | 32055 | 33049 | 34629 | 34630 | 34631 | 34632 | 34633 | 35519 | 35520 | 35521 | 35522 | 35523 | 35524 | 35525 | 35526 | 35527 | 35528 | 35529 | 35530 | 35531 | 35532 | 35678 | 35679 | 35680 | 35681 | 35682 | 35683 | 35684 | 35686 | 35687 | 35688 | 35689 | 35690 | 35691 | 35832 | 36287 | 36288 | 36289 | 37110 | 37111 | 37112 | 38264 | 38265 | 38266 | 38267 | 38328 | 38329 | 38330 | 38331 | 38446 | 38447 | 38448 | 38449 | 38450 | 38820 | 38821 | 38822 | 38823 | 38824 | 39042 | 39043 | 39044 | 39045 | 39046 | 39047 | 39048 | 39811 | 39817 | 39818 | 39819 | 39820 | 39821 | 39822 | 39823 | 44430 | 44431 | 44432 | 44433 | 44434 | 44435 | 44436 | 44511 | 44512 | 44513 | 44514 | 44515 | 44516 | 44517 | 46136 | 46137 | 46138 | 46139 | 46140 | 46141 | 46142