Taiwan Services » DP Client

01/09/2012

05:45 PM Feature #133: [EC-CR-1270] put those lapsed VIP into exception report

the code is just commited again.
only found 1 filewriter object that not been closed in writeLog() method.
no idea ... Chee-Hoong

02:55 PM Feature #133: [EC-CR-1270] put those lapsed VIP into exception report

Chee-Hoong wrote:
> all files and db resources is properly closed. code changes is commited.
> veryfing the generat... chin-yeh

12:37 PM Feature #133: [EC-CR-1270] put those lapsed VIP into exception report

all files and db resources is properly closed. code changes is commited.
veryfing the generated report now Chee-Hoong

10:38 AM Feature #133: [EC-CR-1270] put those lapsed VIP into exception report

As reported by ting-ting, those exception records, e.g. lapsed VIP, appeared in the *FINANCE_REPORT*. The latest code... chin-yeh

01/04/2012

05:04 PM Feature #133: [EC-CR-1270] put those lapsed VIP into exception report

here is the yyyy-MM-dd format report Chee-Hoong

03:34 PM Feature #133: [EC-CR-1270] put those lapsed VIP into exception report

use the value in the *data_month* column (*vip_network* table), e.g.:
> Lapse Status in yyyy-MM-dd
>> Lapse Status ... chin-yeh

02:31 PM Feature #133: [EC-CR-1270] put those lapsed VIP into exception report

profit month in MMyyyy? Chee-Hoong

02:02 PM Feature #133: [EC-CR-1270] put those lapsed VIP into exception report

the format of the reason message for lapsed VIP who have earned DP is:
> Lapse Status in profit_month
_where *pro... chin-yeh

11:22 AM Feature #133: [EC-CR-1270] put those lapsed VIP into exception report

here is the report generated.
including new request (VIP lapsed staus in exception report) Chee-Hoong

09:44 AM Feature #133: [EC-CR-1270] put those lapsed VIP into exception report

provides the following expected output files before the *due date*:
* DP_PROFIT_... chin-yeh

12/27/2011

03:09 PM Feature #132 (Closed): exclude lapsed VIP from DP profit batch file

Fixed and deployed.
See also #133 chin-yeh

10:01 AM Feature #132: exclude lapsed VIP from DP profit batch file

Below are the files that generated last week (24-Dec):
* attachment:"DP_PROFIT_EXCEPTION_112011.csv"
* attachment:"... chin-yeh

09:52 AM Feature #132: exclude lapsed VIP from DP profit batch file

the DP batch is deployed on 22/12/2011 07:30 pm Chee-Hoong

03:07 PM Feature #133 (Closed): [EC-CR-1270] put those lapsed VIP into exception report

The first part of the CR is already implemented in #132.
The second part of the CR is to put those lapsed VIP (who... chin-yeh

02:30 PM Feature #118 (Closed): DP Profit Batch File

fixed and deployed chin-yeh

12/22/2011

05:49 PM Feature #132: exclude lapsed VIP from DP profit batch file

ok Chee-Hoong

01:48 PM Feature #132 (In Progress): exclude lapsed VIP from DP profit batch file

Thanks for the help.
Liaise with Hann or Chee-Wei to deploy the changes to production environment before *23-Dec*.... chin-yeh

12:13 PM Feature #132: exclude lapsed VIP from DP profit batch file

here is the report with updated condition (excluding status lapsed) records Chee-Hoong

12/21/2011

06:55 PM Feature #132 (Closed): exclude lapsed VIP from DP profit batch file

In the coming profit month, those *lapsed VIP* needed to be *excluded* from the batch file:
* use *VIP_NETWORK* tabl... chin-yeh