Project

General

Profile

Actions

Deployment Guide - qiwi-billManagement » History » Revision 14

« Previous | Revision 14/16 (diff) | Next »
Soh Keong, 06/28/2012 02:47 PM


Deployment Guide - qiwi-billManagement

ADBillCreation
cancelBill

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/qiwi-billManagementTest/

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),
    FOREIGN KEY (ORDER_ID) REFERENCES ECOS.QIWI_INTERFACE(ORDER_ID));

Updated by Soh Keong over 12 years ago · 14 revisions