Project

General

Profile

Edit History

Deployment Guide - qiwi-billManagement » History » Version 15

Soh Keong, 07/02/2012 09:51 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
    
    
    
http://192.168.2.68:8080/qiwi-billManagementTest/





    51
    11
    Soh Keong
    
</pre>





    52
    
    
    





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





    54
    
    
    





    55
    
    
    
h3. ECOS.QIWI_INTERFACE





    56
    
    
    





    57
    
    
    
<pre>





    58
    
    
    
CREATE TABLE ECOS.QIWI_INTERFACE (





    59
    
    
    
	ORDER_ID VARCHAR(15) NOT NULL, 





    60
    
    
    
	TRX_TYPE VARCHAR(5),





    61
    
    
    
	SHOPPER_REF_NO INTEGER,





    62
    
    
    
	CURRENCY VARCHAR(3),





    63
    
    
    
	CHARGE_AMT DECIMAL(15,2), 





    64
    
    
    
	STATUS VARCHAR(5),





    65
    
    
    
	MOBILE VARCHAR(30),





    66
    
    
    
	CREATE_DATETIME TIMESTAMP,





    67
    
    
    
	MODIFY_DATETIME TIMESTAMP,





    68
    
    
    
	ERROR_MSG VARCHAR(155),





    69
    
    
    
	IS_VALID VARCHAR(5),





    70
    
    
    
	PRIMARY KEY (ORDER_ID));





    71
    
    
    
</pre>





    72
    
    
    





    73
    
    
    
h3. ECOS.QIWI_INTERFACE_SUB





    74
    
    
    





    75
    
    
    
<pre>





    76
    
    
    
CREATE TABLE ECOS.QIWI_INTERFACE_SUB (





    77
    
    
    
	SUB_ORDER_ID VARCHAR(18) NOT NULL, 





    78
    
    
    
	ORDER_ID VARCHAR(15) NOT NULL, 





    79
    
    
    
	SUB_AMT DECIMAL(15,2), 





    80
    
    
    
	STATUS VARCHAR(5),





    81
    
    
    
	ERROR_MSG VARCHAR(155),





    82
    14
    Soh Keong
    
	RU_PAYMENT_DATETIME TIMESTAMP,





    83
    11
    Soh Keong
    
	CREATE_DATETIME TIMESTAMP,





    84
    
    
    
	MODIFY_DATETIME TIMESTAMP, 





    85
    15
    Soh Keong
    
	PRIMARY KEY (SUB_ORDER_ID));





    86
    1
    Soh Keong
    
</pre>