Attachment 24756 Details for Bug 11622 – Bug 11622 [DB Update] - Add ability to pay fees and fines from OPAC via PayPal

[patch] Bug 11622 [DB Update] - Add ability to pay fees and fines from OPAC via PayPal

Bug-11622-DB-Update---Add-ability-to-pay-fees-and-.patch (text/plain), 3.74 KB, created by Kyle M Hall (khall) on 2014-01-27 17:18:31 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2014-01-27 17:18:31 UTC

Size: 3.74 KB

patch

obsolete

>From 4b5e235cdc9461d3e3aec7f7347d375f92c2e9ed Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Mon, 27 Jan 2014 12:17:46 -0500
>Subject: [PATCH] Bug 11622 [DB Update] - Add ability to pay fees and fines from OPAC via PayPal
>
>---
> installer/data/mysql/sysprefs.sql      |    6 ++++++
> installer/data/mysql/updatedatabase.pl |   17 +++++++++++++++++
> 2 files changed, 23 insertions(+), 0 deletions(-)
>
>diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
>index 6ebce00..0abd691 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -299,6 +299,12 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('PatronSelfRegistrationExpireTemporaryAccountsDelay','0',NULL,'If PatronSelfRegistrationDefaultCategory is enabled, this system preference controls how long a patron can have a temporary status before the account is deleted automatically. It is an integer value representing a number of days to wait before deleting a temporary patron account. Setting it to 0 disables the deleting of temporary accounts.','Integer'),
> ('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate his or her account.','YesNo'),
> ('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'),
>+('EnablePayPalOpacPayments',  '0', NULL ,  'Enables the ability to pay fees and fines from  the OPAC via PayPal',  'YesNo' ),
>+('PayPalChargeDescription',  'Koha fee payment', NULL ,  'This preference defines what the user will see the charge listed as in PayPal',  'Free'),
>+('PayPalPwd',  '', NULL ,  'Your PayPal API password',  'Free'),
>+('PayPalSandboxMode',  '1', NULL ,  'If enabled, the system will use PayPal''s sandbox server for testing, rather than the production server.',  'YesNo'),
>+('PayPalSignature',  '', NULL ,  'Your PayPal API signature',  'Free'),
>+('PayPalUser',  '', NULL ,  'Your PayPal API username ( email address )',  'Free'),
> ('Persona','0','','Use Mozilla Persona for login','YesNo'),
> ('PrefillItem','0','','When a new item is added, should it be prefilled with last created item values?','YesNo'),
> ('previousIssuesDefaultSortOrder','asc','asc|desc','Specify the sort order of Previous Issues on the circulation page','Choice'),
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index bbe68a1..c01c206 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -8113,6 +8113,23 @@ if ( CheckVersion($DBversion) ) {
>     SetVersion ($DBversion);
> }
> 
>+$DBversion = "3.15.00.XXX";
>+if ( CheckVersion($DBversion) ) {
>+    $dbh->do(q{
>+        INSERT INTO  systempreferences (variable, value, options, explanation, type )
>+        VALUES 
>+        ( 'EnablePayPalOpacPayments',  '0', NULL ,  'Enables the ability to pay fees and fines from  the OPAC via PayPal',  'YesNo' ),
>+        ( 'PayPalChargeDescription',  'Koha fee payment', NULL ,  'This preference defines what the user will see the charge listed as in PayPal',  'Free' ),
>+        ( 'PayPalPwd',  '', NULL ,  'Your PayPal API password',  'Free' ),
>+        ( 'PayPalSandboxMode',  '1', NULL ,  'If enabled, the system will use PayPal''s sandbox server for testing, rather than the production server.',  'YesNo' ),
>+        ( 'PayPalSignature',  '', NULL ,  'Your PayPal API signature',  'Free' ),
>+        ( 'PayPalUser',  '', NULL ,  'Your PayPal API username ( email address )',  'Free' )
>+    });
>+
>+    print "Upgrade to $DBversion done (Bug 11622 - Add ability to pay fees and fines from OPAC via PayPal)\n";
>+    SetVersion($DBversion);
>+}
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>-- 
>1.7.2.5

Actions: View | Diff | Splinter Review

Attachments on bug 11622: 24753 | 24754 | 24756 | 40520 | 40521 | 40522 | 40523 | 42241 | 42351 | 42352 | 42594 | 42649 | 42702 | 42705 | 42715 | 42733 | 42774 | 42775 | 42777 | 42778 | 42842 | 42843 | 42857 | 42858 | 42859 | 42860 | 42861 | 42862 | 42863 | 42864 | 42865 | 44419 | 44420 | 44421 | 44422 | 44423 | 44424 | 44425 | 44426 | 44427 | 46143 | 46144 | 46145 | 46146 | 46147 | 46148 | 46149 | 46150 | 46151