Deployment Guide - qiwi-billManagement¶

Steps-By-Steps:¶

1. checkout the qiwi-billManagement project into Eclipse
2. upload application.properties to /data/qiwi-provider/application.properties (\\cwyrnd2-server\src\sohkeong\QIWI\Qiwi_billManagement_Properties)
3. Jar file (\\cwyrnd2-server\src\sohkeong\QIWI\Qiwi_billManagement_Jar)
4. By calling below methods will get the result code.

main.java.com.ecosway.service.IShopServerService service = new main.java.com.ecosway.service.impl.IShopServerServiceImpl();

Create Bill¶

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);

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

Development Server:¶

http://192.168.2.68:8080/TestPage/page/qiwi/createBill.jsp
http://192.168.2.68:8080/TestPage/page/qiwi/cancelBill.jsp
http://192.168.2.68:8080/TestPage/page/qiwi/cancelPayedAmtBill.jsp

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

ECOS.QIWI_INTERFACE¶

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));

ECOS.QIWI_INTERFACE_SUB¶

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));