Taiwan Services » DP Client

08/26/2011

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

finding test data to enable verification Chee-Hoong

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

INV_NO field refer to profit month, for example, if you are generating for May 2011 profit, then it will be BONUS2011... Chooi-Mey

02:58 PM Feature #118: DP Profit Batch File

INV_NO field refers to current date time?
Chee-Hoong

02:50 PM Feature #118: DP Profit Batch File

adding Chee-Hoong

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

Changes:
1) Add in USD_DP_AMT field at last column (position 531-543), with length 13N (13,2). Pass the DP amount ... Chooi-Mey

12:22 PM Feature #117: DP Client Interface

The programming guide is ready and can be found in [[Programming Guide]]. The implementer should understands the requ... chin-yeh

08/25/2011

05:58 PM Feature #119: Sales Return Web Services

Based on the feedback by Benny (25-Aug-2011), the DP system was able to process the sample batch file which contains ... chin-yeh

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

Based on the feedback by Benny (25-Aug-2011), the DP system was able to process the sample batch file which contains ... chin-yeh

05:55 PM Feature #117: DP Client Interface

Based on the feedback by Benny (25-Aug-2011), the DP system was able to process all of the sample batch files, which ... chin-yeh

08/24/2011

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

production generated file sent to ting ting and benny.
bug fixed Chee-Hoong

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

As discussed, do provide the profit batch file, which generated in live environment, to Ting-Ting & Benny for final v... chin-yeh

08/23/2011

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

i just gen the file and send to ting ting? Chee-Hoong

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

I've imported the live *VIP_STAT* & *mend_currconv* tables into development STORE db. Can you generate a copy and pas... chin-yeh

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

wat is the formula or how to calculate the dp that need to convert 2 decimal? Chee-Hoong

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

ok i get it Chee-Hoong

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

Use the util to format all monetary value to 2 decimal places *after* calculation chin-yeh

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

format dp earned to 2 decimal is after currency conversion? for calculation purpose?
Chee-Hoong

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