Taiwan Services » DP Client

08/22/2011

06:17 PM Feature #118: DP Profit Batch File

The file encoding of the profit batch file will be *UTF-8*.
FYI, the file encoding for all of the VP/DP batch fil... chin-yeh

05:46 PM Feature #118: DP Profit Batch File

*Important notes:*
* Refer to the *format2Decimal* method in *my.com.eCosway.util.MyUtil* class in usa-mall reposito... chin-yeh

05:03 PM Feature #118: DP Profit Batch File

Add requirements:
1) Finance Report
- Filename Format: DP_PROFIT_FINANCE_REFERENCE_MMyyyy.csv
- File Encoding: ISO... Chooi-Mey

12:29 PM Feature #118: DP Profit Batch File

For DP Amount in profit file, the value need to be in Local currency of the mapped country.
The retrieval value fro... Chooi-Mey

08/19/2011

05:28 PM Feature #120: VIP Upgrade Web Service

Already integrated. The demo app can be found in:
> http://192.168.2.66:8080/dp-test/vip_upgrade.html
> If do not... chin-yeh

11:56 AM Feature #118 (Feedback): DP Profit Batch File

Ok. Verified. Chooi-Mey

11:41 AM Feature #118: DP Profit Batch File

ok i get wat u mean. now the file regenerated Chee-Hoong

11:24 AM Feature #118: DP Profit Batch File

The Currency_to should mapped to HKD as well, besides the residing country. Same to exchange rate.
It means when sy... Chooi-Mey

11:17 AM Feature #118: DP Profit Batch File

the macau and china residing country is mapped to hong kong residing country in program and file generated.
only dat... Chee-Hoong

10:57 AM Feature #118: DP Profit Batch File

Bugs:
1) Those VIP residing in China, Macau and Hong Kong, should mapped into HKD currency (Currency_To), instead of... Chooi-Mey

08/18/2011

05:15 PM Feature #118: DP Profit Batch File

yes, please generate again and send to Benny. chin-yeh

04:33 PM Feature #118: DP Profit Batch File

neeed to gen and send sample file again? Chee-Hoong

03:48 PM Feature #118: DP Profit Batch File

Just prepare for the profit batch program first.
Besides that, here are the latest changes needed:
* change the *... chin-yeh

08/17/2011

06:13 PM Feature #118: DP Profit Batch File

•how to deploy the batch program
•how to execute the batch program
•how to configure the application properties if ... Chee-Hoong

05:49 PM Feature #118: DP Profit Batch File

Could you prepare the following guide:
* how to deploy the batch program
* how to execute the batch program
* how ... chin-yeh

11:36 AM Feature #118: DP Profit Batch File

ok Chee-Hoong

11:23 AM Feature #118: DP Profit Batch File

*Updates:*
* output filename convention is *DP_PROFITMMyyyy.txt*
** *MMyyyy* - profit month, e.g. 092011 for Septem... chin-yeh

08/16/2011

12:32 PM Feature #120 (In Progress): VIP Upgrade Web Service

chin-yeh

12:25 PM Feature #119 (Feedback): Sales Return Web Services

Done. Try out the demo application:
> http://192.168.2.66:8080/dp-test/return.html
> If you've accessed the demo ... chin-yeh

08/15/2011

05:07 PM Feature #118: DP Profit Batch File

As request by Benny, you need to provide him the batch file that contains:
* -The Profit from member of country Taiw... chin-yeh

08/12/2011

11:52 AM Feature #118: DP Profit Batch File

sample file sent to benny and waiting for feedback
Chee-Hoong

08/10/2011

03:58 PM Feature #117: DP Client Interface

As feedback by Benny on 9-Aug, the system was able to process the submitted batch file. Will submit a new set of batc... chin-yeh

08/09/2011

05:39 PM Feature #118: DP Profit Batch File

to chooi mey, is it if date not null then READY_TO_GENERATE set to true value in hashtable? Chee-Hoong

05:01 PM Feature #118: DP Profit Batch File

Need to apply the logic (same as bank file generation checking) that check whether is ready to generate not.
Refer t... Chooi-Mey

04:53 PM Feature #118: DP Profit Batch File

There's some changes:
* *TRAN_ID* column - the data month will be the previous month of the report generation date
... chin-yeh

12:43 PM Feature #118: DP Profit Batch File

work with Benny to make sure the system can process the generated file.
do update the issue to reflect the current... chin-yeh

12:35 PM Feature #118: DP Profit Batch File

to chin yeh, the sample file is gen-ed.
u wan to hav a look first or i direct email to the receipient? Chee-Hoong

11:40 AM Feature #118: DP Profit Batch File

Please send the sample generated file to *Benny Kuok Chan Weng* [CWKuok@cosway.com.my] by today, do CC me and chooi-m... chin-yeh

08/08/2011

03:04 PM Feature #119: Sales Return Web Services

DP always returns error code *50104 - Invalid or Wrong PIN* when submit SReturn transaction. Hoong is looking into this. chin-yeh

11:14 AM Feature #119 (In Progress): Sales Return Web Services

chin-yeh

08/05/2011

05:13 PM Feature #117 (Feedback): DP Client Interface

chin-yeh

05:07 PM Feature #117: DP Client Interface

*change logs*:
* submitted 2 sample batch files to Benny
* a new test page to demonstrate how to integrate with DP's ... chin-yeh

11:33 AM Feature #118: DP Profit Batch File

ok ty Chee-Hoong

11:22 AM Feature #118: DP Profit Batch File

refer to the issue description for the latest data retrievin SQL chin-yeh

11:12 AM Feature #118: DP Profit Batch File

Only remove the UNION SELECT MEMBER_STAT from SQL query. Chooi-Mey

11:10 AM Feature #118: DP Profit Batch File

or remove the UNION SELECT MEMBER_STAT? Chee-Hoong

11:09 AM Feature #118: DP Profit Batch File

means the the SQL to retrive VIP_STAT and MEMBER_STAT table did not need to execute? ty Chee-Hoong

10:54 AM Feature #118: DP Profit Batch File

Changes:
Do not need to retrieve records from MEMBER_STAT, as BO earned DP profit has already been converted into ca... Chooi-Mey

08/03/2011

10:36 AM Feature #120 (Closed): VIP Upgrade Web Service

Requirement:
1) Build the DP client interface to cater for VIP upgrade to BO, to be call real time towards DP System... Chooi-Mey

09:34 AM Feature #118: DP Profit Batch File

removed all old attachments. refer to the document:"DP Batch File Format" for the latest documents. chin-yeh

08/02/2011

06:18 PM Feature #119 (Closed): Sales Return Web Services

Requirement:
1) Build the DP client interface to cater for refund member's previous utilized DP after member return ... Chooi-Mey

03:34 PM Feature #117: DP Client Interface

Updated the prototype: (press ctrl+F5 to do a force refresh)
> http://192.168.2.66:8080/dp-test/index.html
*Changes ... chin-yeh

10:52 AM Feature #117: DP Client Interface

For the batch file format, please refer to Documents - Batch File Format, for the latest version. Chooi-Mey

10:53 AM Feature #118: DP Profit Batch File

For the batch file format, please refer to document:"DP Batch File Format", for the latest version. Chooi-Mey

08/01/2011

05:59 PM Feature #118: DP Profit Batch File

Add in:
item 11) TRAN_ID, set it to 'PROFITmmyyyy', where mmyyyy is the profit month. Chooi-Mey

04:57 PM Feature #118: DP Profit Batch File

planning program flow soon
Chee-Hoong

04:55 PM Feature #118: DP Profit Batch File

Amendment on item (5) TRAN_AMT:
TRAN_AMT = dp_earned (retrieval) * EXCHG_RATE
Note: dp_earned is in USD currenc... Chooi-Mey

04:21 PM Feature #118 (Closed): DP Profit Batch File

Requirement:
# Construct Currency Hashtable:
** Query all latest currency info from Mend_CurrConv table, into a ... Chooi-Mey

07/29/2011

07:03 PM Feature #117: DP Client Interface

The prototype is ready:
> http://192.168.2.66:8080/dp-test/index.html
Feel free to give any feedback. The documen... chin-yeh

10:23 AM Feature #117: DP Client Interface

Production URL: http://210.64.216.74:8080/Dp/dpservices.asmx?wsdl Chooi-Mey

07/27/2011

05:26 PM Feature #117 (In Progress): DP Client Interface

chin-yeh

04:09 PM Feature #117: DP Client Interface

Confirm fingerprint encryption to use HMacMd5 method with:
message (combination of) = CENTERCODE^MEMBERID^PIN^DP_AM... Chooi-Mey

02:53 PM Feature #117: DP Client Interface

Upload DP Batch File Format.xls, refer to column "Daily Recon Batch" for the data file format (fixed length).
Curren... Chooi-Mey

10:13 AM Feature #117 (Closed): DP Client Interface

Features:
Build a client Interface Call to DP Web Services (http://60.249.0.211:8080/DP/DPServices.asmx?wsdl):
#... Chooi-Mey