Attachment 55499 Details for Bug 16276 – Bug 16276: Add a new pref TrackLastPatronActivity and new column borrowers.lastseen

[patch] Bug 16276: Add a new pref TrackLastPatronActivity and new column borrowers.lastseen

Bug-16276-Add-a-new-pref-TrackLastPatronActivity-a.patch (text/plain), 5.36 KB, created by Jonathan Druart on 2016-09-12 15:07:36 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2016-09-12 15:07:36 UTC

Size: 5.36 KB

patch

obsolete

>From dcc1a63b86471928f28b060574dde22e35d53c25 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Sun, 24 Apr 2016 16:03:49 +0100
>Subject: [PATCH] Bug 16276: Add a new pref TrackLastPatronActivity and new
> column borrowers.lastseen
>
>Sponsored-by: BULAC - http://www.bulac.fr/
>Signed-off-by: Nicolas Legrand <nicolas.legrand@bulac.fr>
>
>https://bugs.koha-community.org/show_bug.cgi?id=12276
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> installer/data/mysql/atomicupdate/bug_16276.sql                   | 3 +++
> installer/data/mysql/kohastructure.sql                            | 2 ++
> installer/data/mysql/sysprefs.sql                                 | 1 +
> .../intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref  | 8 +++++++-
> 4 files changed, 13 insertions(+), 1 deletion(-)
> create mode 100644 installer/data/mysql/atomicupdate/bug_16276.sql
>
>diff --git a/installer/data/mysql/atomicupdate/bug_16276.sql b/installer/data/mysql/atomicupdate/bug_16276.sql
>new file mode 100644
>index 0000000..eeecbe3
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_16276.sql
>@@ -0,0 +1,3 @@
>+ALTER IGNORE TABLE borrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on;
>+ALTER IGNORE TABLE deletedborrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on;
>+INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('TrackLastPatronActivity', '0', 'If set, the field borrowers.lastseen will be updated everytime a patron is seen', NULL, 'YesNo');
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index e72edaf..e38efc5 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -621,6 +621,7 @@ CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
>   `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
>   `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
>   `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
>+  `lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
>   KEY borrowernumber (borrowernumber),
>   KEY `cardnumber` (`cardnumber`),
>   KEY `sms_provider_id` (`sms_provider_id`)
>@@ -1640,6 +1641,7 @@ CREATE TABLE `borrowers` ( -- this table includes information about your patrons
>   `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
>   `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
>   `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
>+  `lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
>   UNIQUE KEY `cardnumber` (`cardnumber`),
>   PRIMARY KEY `borrowernumber` (`borrowernumber`),
>   KEY `categorycode` (`categorycode`),
>diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
>index de6456c..147f530 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -507,6 +507,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('TraceCompleteSubfields','0','0','Force subject tracings to only match complete subfields.','YesNo'),
> ('TraceSubjectSubdivisions','0','1','Create searches on all subdivisions for subject tracings.','YesNo'),
> ('TrackClicks','0',NULL,'Track links clicked','Integer'),
>+('TrackLastPatronActivity','0',NULL,'If set, the field borrowers.lastseen will be updated everytime a patron is seen','YesNo'),
> ('TransfersMaxDaysWarning','3',NULL,'Define the days before a transfer is suspected of having a problem','Integer'),
> ('TransferWhenCancelAllWaitingHolds','0',NULL,'Transfer items when cancelling all waiting holds','YesNo'),
> ('UNIMARCAuthorityField100','afrey50      ba0',NULL,'Define the contents of UNIMARC authority control field 100 position 08-35','Textarea'),
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref
>index 54d13fc..2f2faa0 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref
>@@ -179,7 +179,13 @@ Patrons:
>                yes: Show
>                no: "Don't show"
>          - "patron messaging setting on the OPAC (note: EnhancedMessagingPreferences must be enabled)."
>-
>+     -
>+         - pref: TrackLastPatronActivity
>+           choices:
>+               yes: Do
>+               no: "Don't"
>+         - track last patron activity.
>+         - Everytime a patron will connect, the borrowers.lastseen will be updated with the current time.
>     "Norwegian patron database":
>      -
>          - pref: NorwegianPatronDBEnable
>-- 
>2.8.1

Actions: View | Diff | Splinter Review

Attachments on bug 16276: 50615 | 50616 | 50617 | 50618 | 50619 | 50620 | 51191 | 51407 | 51408 | 51409 | 51410 | 51411 | 51412 | 54588 | 54589 | 54590 | 54591 | 54592 | 54612 | 54613 | 54614 | 54615 | 54616 | 54617 | 54618 | 54619 | 54620 | 54621 | 54622 | 54623 | 54624 | 54625 | 55495 | 55496 | 55497 | 55498 | 55499 | 55500 | 55501