Deployment Guide - qiwi-billManagement » History » Revision 13
Revision 12 (Soh Keong, 06/15/2012 08:57 AM) → Revision 13/16 (Soh Keong, 06/25/2012 11:48 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) (sms or 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), CREATE_DATETIME TIMESTAMP, MODIFY_DATETIME TIMESTAMP, PRIMARY KEY (SUB_ORDER_ID), FOREIGN KEY (ORDER_ID) REFERENCES ECOS.QIWI_INTERFACE(ORDER_ID)); </pre>