Project

General

Profile

Deployment Guide - qiwi-billManagement » History » Version 16

Soh Keong, 02/05/2013 08:31 AM

1 6 Soh Keong
h1. Deployment Guide - qiwi-billManagement
2 1 Soh Keong
3 12 Soh Keong
!ADBillCreation.jpg!
4
!cancelBill.jpg!
5
6 11 Soh Keong
h2. Steps-By-Steps:
7
8 6 Soh Keong
# checkout the [[wiki#SCM|qiwi-billManagement]] project into <code>Eclipse</code>
9
# upload application.properties to /data/qiwi-provider/application.properties</code> (\\cwyrnd2-server\src\sohkeong\QIWI\Qiwi_billManagement_Properties)
10
# Jar file (\\cwyrnd2-server\src\sohkeong\QIWI\Qiwi_billManagement_Jar)
11 7 Soh Keong
# By calling below methods will get the result code.
12 8 Soh Keong
13 1 Soh Keong
<pre>
14 7 Soh Keong
main.java.com.ecosway.service.IShopServerService service = new main.java.com.ecosway.service.impl.IShopServerServiceImpl();
15 1 Soh Keong
</pre>
16 8 Soh Keong
17 11 Soh Keong
h2. Create Bill
18 8 Soh Keong
19 1 Soh Keong
<pre>
20 8 Soh Keong
int result = service.createBill(Connection conn, String user, double amount,
21
			String comment, String transaction, String transactionType,
22
			int shopperRefNo, String currency, String lifetime, int alarm,
23
			boolean create);
24
25
               > > > > > > > > > > OR < < < < < < < < < < 
26
27
int result = service.createBill(Connection conn, String user, double amount,
28
			String comment, String transaction, String transactionType,
29
			int shopperRefNo, String currency, String lifetime, int alarm,
30
			boolean create, boolean split, double maxAmount);
31 1 Soh Keong
</pre>
32 9 Soh Keong
33 10 Soh Keong
# conn         - java.sql.Connection.
34
# user         - user ID. (MSISDN)
35
# amount       - amount of bill.
36
# comment      - comment to the bill displayed to the user.
37
# transaction  - unique bill ID / Order ID.
38
# transactionType - type of transaction.
39
# shopperRefNo - Shopper Reference No.
40 1 Soh Keong
# currency     - The currency of the order expressed as an ISO 4217 alpha code.
41 10 Soh Keong
# lifetime     - bill lifetime. (in dd.MM.yyyy HH:mm:ss format)
42 13 Soh Keong
# alarm        - send a notification to the user. (main.java.com.ecosway.qiwi.commons.ALARM_NO, ALARM_SMS, ALARM_CALL)
43
# create       - flag to create a new user. (if he’s not registered in the system yet) (main.java.com.ecosway.qiwi.commons.CREATE_NEW_USER_NO, CREATE_NEW_USER_YES)
44 10 Soh Keong
# split        - flag to split bill.
45 1 Soh Keong
# maxAmount    - maximum amount in single bill. (will ignore if NOT split)
46
47 11 Soh Keong
h2. Development Server:
48 1 Soh Keong
49
<pre>
50 16 Soh Keong
http://192.168.2.68:8080/TestPage/page/qiwi/createBill.jsp
51
http://192.168.2.68:8080/TestPage/page/qiwi/cancelBill.jsp
52
http://192.168.2.68:8080/TestPage/page/qiwi/cancelPayedAmtBill.jsp
53 11 Soh Keong
</pre>
54
55
h2. Database Tables (ECOS.QIWI_INTERFACE & ECOS.QIWI_INTERFACE_SUB)
56
57
h3. ECOS.QIWI_INTERFACE
58
59
<pre>
60
CREATE TABLE ECOS.QIWI_INTERFACE (
61
	ORDER_ID VARCHAR(15) NOT NULL, 
62
	TRX_TYPE VARCHAR(5),
63
	SHOPPER_REF_NO INTEGER,
64
	CURRENCY VARCHAR(3),
65
	CHARGE_AMT DECIMAL(15,2), 
66
	STATUS VARCHAR(5),
67
	MOBILE VARCHAR(30),
68
	CREATE_DATETIME TIMESTAMP,
69
	MODIFY_DATETIME TIMESTAMP,
70
	ERROR_MSG VARCHAR(155),
71
	IS_VALID VARCHAR(5),
72
	PRIMARY KEY (ORDER_ID));
73
</pre>
74
75
h3. ECOS.QIWI_INTERFACE_SUB
76
77
<pre>
78
CREATE TABLE ECOS.QIWI_INTERFACE_SUB (
79
	SUB_ORDER_ID VARCHAR(18) NOT NULL, 
80
	ORDER_ID VARCHAR(15) NOT NULL, 
81
	SUB_AMT DECIMAL(15,2), 
82
	STATUS VARCHAR(5),
83
	ERROR_MSG VARCHAR(155),
84 14 Soh Keong
	RU_PAYMENT_DATETIME TIMESTAMP,
85 11 Soh Keong
	CREATE_DATETIME TIMESTAMP,
86
	MODIFY_DATETIME TIMESTAMP, 
87 15 Soh Keong
	PRIMARY KEY (SUB_ORDER_ID));
88 1 Soh Keong
</pre>