eCosway » eCosway HK » RP_Purge

Wiki » History » Revision 5

Revision 4 (Soh Keong, 11/07/2023 11:06 AM) → Revision 5/6 (Soh Keong, 11/16/2023 02:15 PM)

{{toc}} 

 h1. Wiki 

 h2. Specification 

 See [[Batch]] 
 See [[WebService]] 

 h2. Description 

 <pre> 
 RP 2023 - expiry on 31 Dec 2024 
 RP Jan - Jun 2024 - expiry on 31 Dec 2025 (period 1.5 years) 
 RP Jul - Dec 2024 - expiry on 30 Jun 2026 (period 1.5 years) 
 RP Jan - Jun 2025 - expiry on 31 Dec 2026 (period 1.5 years) 




 ============================================================ 
     In the backend, we need to prepare 3 separate pieces of code for these changes because each condition is different: 
         Starting from 1st Nov 2023, the current balance should be updated to December 31, 2024. 

     On 4 Jan 2024, the balance for 2023 should be adjusted by subtracting the earnings and utilization for January 2024. 
         The reason for updating only on January 4, 2024, is that POS sales data is imported daily, and in case of any late imports, we need to deduct the utilization and account for returns related to December 2023 sales that were imported in January 2024. 

     The program will run by transaction for six months: 
         RP from January to June 2024 will expire on December 31, 2025 (a period of 1.5 years). 
         RP from July to December 2024 will expire on June 30, 2026 (a period of 1.5 years). 
         RP from January to June 2025 will expire on December 31, 2026 (a period of 1.5 years). 
 </pre> 


 h2. Table 

 <pre> 
 CREATE TABLE RP_PURGE_TRANSACTION ( 
	 PROCESS_DATE DATE NOT NULL, 
	 TRX_REF_NO INTEGER NOT NULL, 
	 STATUS VARCHAR(2) DEFAULT 'A', 
	 CREATE_DATETIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP, 
	 PRIMARY KEY(PROCESS_DATE,TRX_REF_NO)) 
 </pre> 

 <pre> 
 CREATE TABLE RP_PURGE ( 
     PROCESS_DATE INTEGER NOT NULL, 
     MEMBER_ID VARCHAR(20) NOT NULL, 
     RP_EARN DECIMAL(15,2),  
	 RP_UTILIZE DECIMAL(15,2), 
	 RP_TOTAL_UTILIZED DECIMAL(15,2) DEFAULT 0, 
	 RP_UTILIZED_PROCESS_DATE VARCHAR(25), 
	 RP_PURGE DECIMAL(15,2), 
	 RP_TO_BE_EXPIRED DECIMAL(15,2), 
	 EXPIRY_DATE DATE, 
	 PROCESS_IND VARCHAR(1) DEFAULT 'N', 
	 PURGE_IND VARCHAR(1) DEFAULT 'N', 
     CREATE_DATETIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP, 
     MODIFY_DATETIME TIMESTAMP,  
     PRIMARY KEY (PROCESS_DATE,MEMBER_ID)); 
 </pre> 

 h2. SCM 

 h3. Batch 

 <pre> 
 Host: svn+ssh://192.168.2.66/svn/ecosway-batch 
 Path: /ecosway-batch/src-ecos 
 Class: ECpurgeRP , GenHKRPDaily 
 Tag: HEAD 
 </pre> 

 h3. Web Service 

 <pre> 
 Host: svn+ssh://192.168.2.66/svn/OnlineControllerDaoService 
 Path: /OnlineControllerDaoService 
 Tag: HEAD 
 </pre>