Deployment Guide - qiwi-billManagement » History » Revision 12
Revision 11 (Soh Keong, 06/14/2012 10:04 AM) → Revision 12/16 (Soh Keong, 06/15/2012 08:57 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. (sms or call)
# create - flag to create a new user. (if he’s not registered in the system yet)
# 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>