Project

General

Profile

Specification » History » Version 1

Soh Keong, 11/25/2020 03:29 PM

1 1 Soh Keong
{{toc}}
2
3
h1. Specification
4
5
h1. Activity Diagram
6
!express_checkout.png!
7
8
h1. Programming Guide
9
10
h3. Jar version 
11
12
|_. version |_. Description  |
13
| 1.0       | Init           |
14
15
h3. Jar File Download
16
17
"Jar":/redmine/attachments/download/524/Paypal_Connector-1.8.jar
18
"Properties":/redmine/attachments/download/525/paypal_Aces.properties
19
20
* *mol.properties*
21
22
# *PP_USER_MALL*                  - Provided by PayPal
23
# *PP_PASSWORD_MALL*              - Provided by PayPal
24
# *PP_SIGNATURE_MALL*             - Provided by PayPal
25
# *PP_CHECKOUT_URL_MALL*          - Provided by PayPal
26
# *PP_NVP_ENDPOINT_MALL*          - Provided by PayPal
27
# *PP_ALLOW_STATUS_PENDING_MALL*  - Provided by PayPal
28
# *API_VERSION*                   - Provided by PayPal
29
# *LOGO_IMG*                      - Logo @payment page
30
# *SOLUTIONTYPE*                  - Sole (no need Paypal account) / Mark (Must have Paypal account)
31
# *CONNECTION_TIMEOUT*            - Set connection timeout
32
# *READ_TIMEOUT*                  - Set connection read timeout
33
34
h3. Database Table
35
36
<pre>
37
CREATE TABLE PAYPAL_INTERFACE (
38
	ORDER_ID VARCHAR(15) NOT NULL, 
39
	TRX_TYPE VARCHAR(5),
40
	SHOPPER_REF_NO INTEGER,
41
	CHARGE_AMT DECIMAL(15,2), 
42
	CURRENCY_CODE VARCHAR(3),
43
	STATUS VARCHAR(2), 
44
	RESPONSE_CODE VARCHAR(20),
45
	RESPONSE_MESSAGE VARCHAR(100),
46
	IS_VALID CHARACTER NOT NULL, 
47
	PAY_DATE TIMESTAMP,
48
	CREATE_DATETIME TIMESTAMP NOT NULL,
49
	MODIFY_DATETIME TIMESTAMP, 
50
	PRIMARY KEY (ORDER_ID));
51
</pre>