Payment Gateway » QIWI Wallet

Deployment Guide - qiwi-billManagement » History » Revision 15

Revision 14 (Soh Keong, 06/28/2012 02:47 PM) → Revision 15/16 (Soh Keong, 07/02/2012 09:51 AM)

h1. Deployment Guide - qiwi-billManagement 

 !ADBillCreation.jpg! 
 !cancelBill.jpg! 

 h2. Steps-By-Steps: 

 # checkout the [[wiki#SCM|qiwi-billManagement]] project into <code>Eclipse</code> 
 # upload application.properties to /data/qiwi-provider/application.properties</code> (\\cwyrnd2-server\src\sohkeong\QIWI\Qiwi_billManagement_Properties) 
 # Jar file (\\cwyrnd2-server\src\sohkeong\QIWI\Qiwi_billManagement_Jar) 
 # By calling below methods will get the result code. 

 <pre> 
 main.java.com.ecosway.service.IShopServerService service = new main.java.com.ecosway.service.impl.IShopServerServiceImpl(); 
 </pre> 

 h2. Create Bill 

 <pre> 
 int result = service.createBill(Connection conn, String user, double amount, 
			 String comment, String transaction, String transactionType, 
			 int shopperRefNo, String currency, String lifetime, int alarm, 
			 boolean create); 

                > > > > > > > > > > OR < < < < < < < < < <  

 int result = service.createBill(Connection conn, String user, double amount, 
			 String comment, String transaction, String transactionType, 
			 int shopperRefNo, String currency, String lifetime, int alarm, 
			 boolean create, boolean split, double maxAmount); 
 </pre> 

 # conn           - java.sql.Connection. 
 # user           - user ID. (MSISDN) 
 # amount         - amount of bill. 
 # comment        - comment to the bill displayed to the user. 
 # transaction    - unique bill ID / Order ID. 
 # transactionType - type of transaction. 
 # shopperRefNo - Shopper Reference No. 
 # currency       - The currency of the order expressed as an ISO 4217 alpha code. 
 # lifetime       - bill lifetime. (in dd.MM.yyyy HH:mm:ss format) 
 # alarm          - send a notification to the user. (main.java.com.ecosway.qiwi.commons.ALARM_NO, ALARM_SMS, ALARM_CALL) 
 # 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) 
 # split          - flag to split bill. 
 # maxAmount      - maximum amount in single bill. (will ignore if NOT split) 

 h2. Development Server: 

 <pre> 
 http://192.168.2.68:8080/qiwi-billManagementTest/ 
 </pre> 

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

 h3. ECOS.QIWI_INTERFACE 

 <pre> 
 CREATE TABLE ECOS.QIWI_INTERFACE ( 
	 ORDER_ID VARCHAR(15) NOT NULL,  
	 TRX_TYPE VARCHAR(5), 
	 SHOPPER_REF_NO INTEGER, 
	 CURRENCY VARCHAR(3), 
	 CHARGE_AMT DECIMAL(15,2),  
	 STATUS VARCHAR(5), 
	 MOBILE VARCHAR(30), 
	 CREATE_DATETIME TIMESTAMP, 
	 MODIFY_DATETIME TIMESTAMP, 
	 ERROR_MSG VARCHAR(155), 
	 IS_VALID VARCHAR(5), 
	 PRIMARY KEY (ORDER_ID)); 
 </pre> 

 h3. ECOS.QIWI_INTERFACE_SUB 

 <pre> 
 CREATE TABLE ECOS.QIWI_INTERFACE_SUB ( 
	 SUB_ORDER_ID VARCHAR(18) NOT NULL,  
	 ORDER_ID VARCHAR(15) NOT NULL,  
	 SUB_AMT DECIMAL(15,2),  
	 STATUS VARCHAR(5), 
	 ERROR_MSG VARCHAR(155), 
	 RU_PAYMENT_DATETIME TIMESTAMP, 
	 CREATE_DATETIME TIMESTAMP, 
	 MODIFY_DATETIME TIMESTAMP,  
	 PRIMARY KEY (SUB_ORDER_ID)); (SUB_ORDER_ID), 
	 FOREIGN KEY (ORDER_ID) REFERENCES ECOS.QIWI_INTERFACE(ORDER_ID)); 
 </pre>