Attachment #120635 for bug #23215

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




$DBversion = 'XXX';
if( CheckVersion( $DBversion ) ) {

    $dbh->do(q{
        DELETE FROM systempreferences
        WHERE variable IN
            ('EnablePayPalOpacPayments',
             'PayPalChargeDescription',
             'PayPalPwd',
             'PayPalReturnURL',
             'PayPalSandboxMode',
             'PayPalSignature',
             'PayPalUser');
    });

    NewVersion( $DBversion, 23215, "Remove core PayPal support in favor of the use of plugins");
}




('PatronSelfRegistrationPrefillForm','1',NULL,'Display password and prefill login form after a patron has self registered','YesNo'),
('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate their 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' ),
('PatronQuickAddFields',  '', NULL ,  'A list of fields separated by "|" to be displayed along with mandatory fields in the patron quick add form if chosen at patron entry',  'Free' ),
('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'),
('PayPalReturnURL','BaseURL','BaseURL|OPACAlias','Specify whether PayPal will return to the url specified in the OPACBaseURL option or to the OPAC\'s alias url.','Choice'),
('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'),
('PhoneNotification','0',NULL,'If ON, enables generation of phone notifications to be sent by plugins','YesNo'),
('PrefillGuaranteeField', 'phone,email,streetnumber,address,city,state,zipcode,country', NULL, 'Prefill these fields in guarantee member entry form from guarantor patron record', 'Multiple'),
('PrefillItem','0','','When a new item is added, should it be prefilled with last created item values?','YesNo'),




                subtype: Subtypes
                sorting: Sorting
                location: Location and availability
    Payments:
        -
            - pref: EnablePayPalOpacPayments
              default: 1
              choices:
                  1: Allow
                  0: "Don't allow"
            - "patrons to make payments from the OPAC via PayPal in"
            - pref: PayPalSandboxMode
              default: 1
              choices:
                  1: "sandbox"
                  0: "production"
            - "mode."
            - "<br/><strong>Warning</strong>: this functionality has been deprecated in favor of using payment plugins that can implement different payment services."
        -
            - "The email address to receive PayPal payments is "
            - pref: PayPalUser
              class: email
            - "."
        -
            - "The password for the PayPal account to receive payments is "
            - pref: PayPalPwd
              class: long
            - "."
        -
            - "The signature for the PayPal account to receive payments is "
            - pref: PayPalSignature
              class: long
            - "."
        -
            - "The patron should see the charge description as "
            - pref: PayPalChargeDescription
              class: long
            - "."
        -
            - "After payment or cancellation, PayPal should return to the "
            - pref: PayPalReturnURL
              default: BaseURL
              choices:
                  BaseURL: "OPACBaseURL"
                  OPACAlias: "configured return URL"
            - "."
    Authentication:
        -
            - pref: OPACShibOnly
- 

Return to bug 23215

Lines 523-536 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/mandatory/sysprefs.sql (-7 lines)
523	('PatronSelfRegistrationPrefillForm','1',NULL,'Display password and prefill login form after a patron has self registered','YesNo'),	523	('PatronSelfRegistrationPrefillForm','1',NULL,'Display password and prefill login form after a patron has self registered','YesNo'),
524	('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate their account.','YesNo'),	524	('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate their account.','YesNo'),
525	('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'),	525	('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'),
526	('EnablePayPalOpacPayments', '0', NULL , 'Enables the ability to pay fees and fines from the OPAC via PayPal', 'YesNo' ),
527	('PatronQuickAddFields', '', NULL , 'A list of fields separated by "\|" to be displayed along with mandatory fields in the patron quick add form if chosen at patron entry', 'Free' ),	526	('PatronQuickAddFields', '', NULL , 'A list of fields separated by "\|" to be displayed along with mandatory fields in the patron quick add form if chosen at patron entry', 'Free' ),
528	('PayPalChargeDescription', 'Koha fee payment', NULL , 'This preference defines what the user will see the charge listed as in PayPal', 'Free'),
529	('PayPalPwd', '', NULL , 'Your PayPal API password', 'Free'),
530	('PayPalReturnURL','BaseURL','BaseURL\|OPACAlias','Specify whether PayPal will return to the url specified in the OPACBaseURL option or to the OPAC\'s alias url.','Choice'),
531	('PayPalSandboxMode', '1', NULL , 'If enabled, the system will use PayPal''s sandbox server for testing, rather than the production server.', 'YesNo'),
532	('PayPalSignature', '', NULL , 'Your PayPal API signature', 'Free'),
533	('PayPalUser', '', NULL , 'Your PayPal API username ( email address )', 'Free'),
534	('PhoneNotification','0',NULL,'If ON, enables generation of phone notifications to be sent by plugins','YesNo'),	527	('PhoneNotification','0',NULL,'If ON, enables generation of phone notifications to be sent by plugins','YesNo'),
535	('PrefillGuaranteeField', 'phone,email,streetnumber,address,city,state,zipcode,country', NULL, 'Prefill these fields in guarantee member entry form from guarantor patron record', 'Multiple'),	528	('PrefillGuaranteeField', 'phone,email,streetnumber,address,city,state,zipcode,country', NULL, 'Prefill these fields in guarantee member entry form from guarantor patron record', 'Multiple'),
536	('PrefillItem','0','','When a new item is added, should it be prefilled with last created item values?','YesNo'),	529	('PrefillItem','0','','When a new item is added, should it be prefilled with last created item values?','YesNo'),

Lines 893-941 OPAC: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref (-44 lines)
893	subtype: Subtypes	893	subtype: Subtypes
894	sorting: Sorting	894	sorting: Sorting
895	location: Location and availability	895	location: Location and availability
896	Payments:
897	-
898	- pref: EnablePayPalOpacPayments
899	default: 1
900	choices:
901	1: Allow
902	0: "Don't allow"
903	- "patrons to make payments from the OPAC via PayPal in"
904	- pref: PayPalSandboxMode
905	default: 1
906	choices:
907	1: "sandbox"
908	0: "production"
909	- "mode."
910	- "<br/><strong>Warning</strong>: this functionality has been deprecated in favor of using payment plugins that can implement different payment services."
911	-
912	- "The email address to receive PayPal payments is "
913	- pref: PayPalUser
914	class: email
915	- "."
916	-
917	- "The password for the PayPal account to receive payments is "
918	- pref: PayPalPwd
919	class: long
920	- "."
921	-
922	- "The signature for the PayPal account to receive payments is "
923	- pref: PayPalSignature
924	class: long
925	- "."
926	-
927	- "The patron should see the charge description as "
928	- pref: PayPalChargeDescription
929	class: long
930	- "."
931	-
932	- "After payment or cancellation, PayPal should return to the "
933	- pref: PayPalReturnURL
934	default: BaseURL
935	choices:
936	BaseURL: "OPACBaseURL"
937	OPACAlias: "configured return URL"
938	- "."
939	Authentication:	896	Authentication:
940	-	897	-
941	- pref: OPACShibOnly	898	- pref: OPACShibOnly
942	-

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_23215.perl (+17 lines)
	1	$DBversion = 'XXX';
	2	if( CheckVersion( $DBversion ) ) {
	3
	4	$dbh->do(q{
	5	DELETE FROM systempreferences
	6	WHERE variable IN
	7	('EnablePayPalOpacPayments',
	8	'PayPalChargeDescription',
	9	'PayPalPwd',
	10	'PayPalReturnURL',
	11	'PayPalSandboxMode',
	12	'PayPalSignature',
	13	'PayPalUser');
	14	});
	15
	16	NewVersion( $DBversion, 23215, "Remove core PayPal support in favor of the use of plugins");
	17	}