[Koha-patches] [PATCH] Enhancement: [3.4] [2/2] Web-based checkout enhancements

Chris Nighswonger cnighswonger at foundations.edu
Thu Feb 11 20:40:32 CET 2010


Necessary db schema, updatedatabase.pl, and syspref sql updates.

NOTE: This leaves the db minor rev as .XXX and therefore does not
modify kohaversion.pl.
---
 installer/data/mysql/en/mandatory/sysprefs.sql     |    2 ++
 .../1-Obligatoire/unimarc_standard_systemprefs.sql |    3 +++
 installer/data/mysql/pl-PL/mandatory/sysprefs.sql  |    3 +++
 .../ru-RU/mandatory/system_preferences_optimal.sql |    3 +++
 .../uk-UA/mandatory/system_preferences_optimal.sql |    3 +++
 installer/data/mysql/updatedatabase.pl             |    9 +++++++++
 6 files changed, 23 insertions(+), 0 deletions(-)

diff --git a/installer/data/mysql/en/mandatory/sysprefs.sql b/installer/data/mysql/en/mandatory/sysprefs.sql
index 3647715..64a8bc7 100644
--- a/installer/data/mysql/en/mandatory/sysprefs.sql
+++ b/installer/data/mysql/en/mandatory/sysprefs.sql
@@ -282,3 +282,5 @@ INSERT INTO `systempreferences` (variable,value,options,explanation,type) VALUES
 INSERT INTO systempreferences (variable,value,explanation,options,type)VALUES('AutoSelfCheckAllowed', '0', 'For corporate and special libraries which want web-based self-check available from any PC without the need for a manual staff login. Most libraries will want to leave this turned off. If on, requires self-check ID and password to be entered in AutoSelfCheckID and AutoSelfCheckPass sysprefs.', '', 'YesNo');
 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AutoSelfCheckID','','Staff ID with circulation rights to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','','free');
 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AutoSelfCheckPass','','Password to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before session times out (1000 milliseconds/second)','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the header of the web-based self checkout service','Textarea');
diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql b/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql
index 1738d8d..acf7053 100644
--- a/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql
@@ -285,3 +285,6 @@ INSERT INTO `systempreferences` (variable,value,options,explanation,type) VALUES
 INSERT INTO systempreferences (variable,value,explanation,options,type)VALUES('AutoSelfCheckAllowed', '0', 'Pour les bibliothèques d''entreprise qui veulent du prêt auto-contrôlé de n''importe quel PC sans le besoin de recourir à un login de bibliothécaire.', '', 'YesNo');
 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AutoSelfCheckID','','Identifiant Bibliothécaire avec droits de circulation qui sera utilisé pour les prêt auto-contré. Ne s''applique que dans les cas de l''activation de la préférence AutoSelfCheckout.','','free');
 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AutoSelfCheckPass','','Mot de passe utilisé pour le prêt autocontrôlé. Ne s''applique que dans le cas de l''activation de la préférence AutoSelfCheckout.','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before session times out (1000 milliseconds/second)','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the header of the web-based self checkout service','Textarea');
+
diff --git a/installer/data/mysql/pl-PL/mandatory/sysprefs.sql b/installer/data/mysql/pl-PL/mandatory/sysprefs.sql
index c62aad0..568e221 100755
--- a/installer/data/mysql/pl-PL/mandatory/sysprefs.sql
+++ b/installer/data/mysql/pl-PL/mandatory/sysprefs.sql
@@ -274,3 +274,6 @@ INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('
 INSERT INTO systempreferences (variable,value,explanation,options,type)VALUES('ShowPatronImageInWebBasedSelfCheck', '0', 'If ON, displays patron image when a patron uses web-based self-checkout', '', 'YesNo');
 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('EnableOpacSearchHistory', '1', 'Enable or disable opac search history','', 'YesNo');
 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('RoutingListAddReserves','1','If ON the patrons on routing lists are automatically added to holds on the issue.','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before session times out (1000 milliseconds/second)','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the header of the web-based self checkout service','Textarea');
+
diff --git a/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql b/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql
index a33f793..7b56270 100644
--- a/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql
+++ b/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql
@@ -242,3 +242,6 @@ INSERT INTO systempreferences (variable,value,options,explanation,type)VALUES('D
 INSERT INTO systempreferences (variable,value,explanation,options,type)VALUES('AutoSelfCheckAllowed', '0', 'For corporate and special libraries which want web-based self-check available from any PC without the need for a manual staff login. Most libraries will want to leave this turned off. If on, requires self-check ID and password to be entered in AutoSelfCheckID and AutoSelfCheckPass sysprefs.', '', 'YesNo');
 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AutoSelfCheckID','','Staff ID with circulation rights to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','70|10','Textarea');
 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AutoSelfCheckPass','','Password to be used for automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is turned on.','70|10','Textarea');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before session times out (1000 milliseconds/second)','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the header of the web-based self checkout service','Textarea');
+
diff --git a/installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.sql b/installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.sql
index 871fee0..35205b6 100644
--- a/installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.sql
+++ b/installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.sql
@@ -238,3 +238,6 @@ INSERT INTO `systempreferences` (variable,value,options,explanation,type) VALUES
 INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('AllowRenewalLimitOverride', '0', 'if ON, allows renewal limits to be overridden on the circulation screen',NULL,'YesNo');
 INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('MergeAuthoritiesOnUpdate', '1', 'if ON, Updating authorities will automatically updates biblios',NULL,'YesNo');
 INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('AllowNotForLoanOverride', '0', 'if ON, enables the librarian to choose when they want to check out a notForLoan regular item',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before session times out (1000 milliseconds/second)','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the header of the web-based self checkout service','Textarea');
+
diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index 32ad48b..cb3dc11 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -3445,6 +3445,15 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
     SetVersion ($DBversion);
 }
 
+$DBversion = '3.01.00.XXX';
+if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
+    $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before session times out (1000 milliseconds/second)','Integer')");
+    $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the header of the web-based self checkout service','Textarea')");
+    print "Upgrade to $DBversion done (Adding new web-based self checkout system preferences: WebBasedSelfCheckTimeout, WebBasedSelfCheckHeader)\n";
+    SetVersion ($DBversion);
+}
+
+
 =item DropAllForeignKeys($table)
 
   Drop all foreign keys of the table $table
-- 
1.6.0.4




More information about the Koha-patches mailing list