Project

General

Profile

Edit History

Deployment Guide - qiwi-billManagement » History » Version 11

Soh Keong, 06/14/2012 10:04 AM

1 6 Soh Keong 
h1. Deployment Guide - qiwi-billManagement
2 1 Soh Keong 





    3
    11
    Soh Keong
    
h2. Steps-By-Steps:





    4
    
    
    





    5
    6
    Soh Keong
    
# checkout the [[wiki#SCM|qiwi-billManagement]] project into <code>Eclipse</code>





    6
    
    
    
# upload application.properties to /data/qiwi-provider/application.properties</code> (\\cwyrnd2-server\src\sohkeong\QIWI\Qiwi_billManagement_Properties)





    7
    
    
    
# Jar file (\\cwyrnd2-server\src\sohkeong\QIWI\Qiwi_billManagement_Jar)





    8
    7
    Soh Keong
    
# By calling below methods will get the result code.





    9
    8
    Soh Keong
    





    10
    1
    Soh Keong
    
<pre>





    11
    7
    Soh Keong
    
main.java.com.ecosway.service.IShopServerService service = new main.java.com.ecosway.service.impl.IShopServerServiceImpl();





    12
    1
    Soh Keong
    
</pre>





    13
    8
    Soh Keong
    





    14
    11
    Soh Keong
    
h2. Create Bill





    15
    8
    Soh Keong
    





    16
    1
    Soh Keong
    
<pre>





    17
    8
    Soh Keong
    
int result = service.createBill(Connection conn, String user, double amount,





    18
    
    
    
			String comment, String transaction, String transactionType,





    19
    
    
    
			int shopperRefNo, String currency, String lifetime, int alarm,





    20
    
    
    
			boolean create);





    21
    
    
    





    22
    
    
    
               > > > > > > > > > > OR < < < < < < < < < < 





    23
    
    
    





    24
    
    
    
int result = service.createBill(Connection conn, String user, double amount,





    25
    
    
    
			String comment, String transaction, String transactionType,





    26
    
    
    
			int shopperRefNo, String currency, String lifetime, int alarm,





    27
    
    
    
			boolean create, boolean split, double maxAmount);





    28
    1
    Soh Keong
    
</pre>





    29
    9
    Soh Keong
    





    30
    10
    Soh Keong
    
# conn         - java.sql.Connection.





    31
    
    
    
# user         - user ID. (MSISDN)





    32
    
    
    
# amount       - amount of bill.





    33
    
    
    
# comment      - comment to the bill displayed to the user.





    34
    
    
    
# transaction  - unique bill ID / Order ID.





    35
    
    
    
# transactionType - type of transaction.





    36
    
    
    
# shopperRefNo - Shopper Reference No.





    37
    1
    Soh Keong
    
# currency     - The currency of the order expressed as an ISO 4217 alpha code.





    38
    10
    Soh Keong
    
# lifetime     - bill lifetime. (in dd.MM.yyyy HH:mm:ss format)





    39
    
    
    
# alarm        - send a notification to the user. (sms or call)





    40
    
    
    
# create       - flag to create a new user. (if he’s not registered in the system yet)





    41
    
    
    
# split        - flag to split bill.





    42
    1
    Soh Keong
    
# maxAmount    - maximum amount in single bill. (will ignore if NOT split)





    43
    
    
    





    44
    11
    Soh Keong
    
h2. Development Server:





    45
    1
    Soh Keong
    





    46
    
    
    
<pre>





    47
    
    
    
http://192.168.2.68:8080/qiwi-billManagementTest/





    48
    11
    Soh Keong
    
</pre>





    49
    
    
    





    50
    
    
    
h2. Database Tables (ECOS.QIWI_INTERFACE & ECOS.QIWI_INTERFACE_SUB)





    51
    
    
    





    52
    
    
    
h3. ECOS.QIWI_INTERFACE





    53
    
    
    





    54
    
    
    
<pre>





    55
    
    
    
CREATE TABLE ECOS.QIWI_INTERFACE (





    56
    
    
    
	ORDER_ID VARCHAR(15) NOT NULL, 





    57
    
    
    
	TRX_TYPE VARCHAR(5),





    58
    
    
    
	SHOPPER_REF_NO INTEGER,





    59
    
    
    
	CURRENCY VARCHAR(3),





    60
    
    
    
	CHARGE_AMT DECIMAL(15,2), 





    61
    
    
    
	STATUS VARCHAR(5),





    62
    
    
    
	MOBILE VARCHAR(30),





    63
    
    
    
	CREATE_DATETIME TIMESTAMP,





    64
    
    
    
	MODIFY_DATETIME TIMESTAMP,





    65
    
    
    
	ERROR_MSG VARCHAR(155),





    66
    
    
    
	IS_VALID VARCHAR(5),





    67
    
    
    
	PRIMARY KEY (ORDER_ID));





    68
    
    
    
</pre>





    69
    
    
    





    70
    
    
    
h3. ECOS.QIWI_INTERFACE_SUB





    71
    
    
    





    72
    
    
    
<pre>





    73
    
    
    
CREATE TABLE ECOS.QIWI_INTERFACE_SUB (





    74
    
    
    
	SUB_ORDER_ID VARCHAR(18) NOT NULL, 





    75
    
    
    
	ORDER_ID VARCHAR(15) NOT NULL, 





    76
    
    
    
	SUB_AMT DECIMAL(15,2), 





    77
    
    
    
	STATUS VARCHAR(5),





    78
    
    
    
	ERROR_MSG VARCHAR(155),





    79
    
    
    
	CREATE_DATETIME TIMESTAMP,





    80
    
    
    
	MODIFY_DATETIME TIMESTAMP, 





    81
    
    
    
	PRIMARY KEY (SUB_ORDER_ID),





    82
    
    
    
	FOREIGN KEY (ORDER_ID) REFERENCES ECOS.QIWI_INTERFACE(ORDER_ID));





    83
    1
    Soh Keong
    
</pre>