Project

General

Profile

Edit History

Online Redemption » History » Version 2

Soh Keong, 08/22/2022 04:56 PM

1 1 Soh Keong 
h1. Online Redemption
2 





    3
    
    
    
h2. Steps





    4
    
    
    





    5
    
    
    
1. Verify data formating:





    6
    
    
    





    7
    
    
    
!redeem_1.png!





    8
    2
    Soh Keong
    





    9
    
    
    
2. Save to csv file  with seperator pipe "|" , remove header





    10
    
    
    





    11
    
    
    
!redeem_2.png!





    12
    
    
    





    13
    
    
    
3. Put the csv file to 'offline' folder





    14
    
    
    





    15
    
    
    
!redeem_3.png!





    16
    
    
    





    17
    
    
    





    18
    
    
    
4. Execute script at "src-cosway" :





    19
    
    
    





    20
    
    
    
$JAVA_PATH/java -Dprogram.name=OfflineOnlineRedemptionItem -classpath $CP OfflineOnlineRedemptionItem ONLINE_REDEMPTION_ITEM_17032022.csv 





    21
    
    
    





    22
    
    
    





    23
    
    
    
5. Verify data is correct:





    24
    
    
    





    25
    
    
    
by ORDER_ID:





    26
    
    
    





    27
    
    
    
SELECT * FROM ONLINE_REDEMPTION_ITEM WHERE ORDER_ID IN ('CW100153355MY','CW100153363MY','CW100153378MY','CW100153397MY','CW100153399MY','CW100153405MY','CW100153424MY','CW100153445MY','CW100153484MY','CW100153595MY','CW100153596MY','CW100153620MY','CW100153788MY','CW100153956MY','CW100153999MY','CW100154020MY','CW100154021MY','CW100154170MY','CW100154224MY','CW100154242MY','CW100154269MY','CW100154319MY','CW100154404MY','CW100154441MY','CW100154554MY','CW100154696MY','CW100154716MY','CW100154726MY','CW100154766MY','CW100154782MY','CW100154783MY','CW100154832MY','CW100154833MY','CW100154834MY','CW100154835MY','CW100154836MY','CW100154847MY','CW100154848MY','CW100154849MY','CW100154850MY','CW100154857MY','CW100154858MY','CW100154859MY','CW100154860MY','CW100154873MY','CW100154876MY','CW100154883MY','CW100154884MY','CW100154901MY','CW100154910MY','CW100154911MY','CW100154912MY','CW100154913MY','CW100154923MY','CW100154929MY','CW100154930MY','CW100154931MY','CW100154933MY','CW100154952MY','CW100154975MY','CW100154979MY','CW100154985MY')





    28
    
    
    





    29
    
    
    
!redeem_4.png!





    30
    
    
    





    31
    
    
    





    32
    
    
    
SELECT count(*) FROM ONLINE_REDEMPTION_ITEM WHERE ORDER_ID IN ('CW100153355MY','CW100153363MY','CW100153378MY','CW100153397MY','CW100153399MY','CW100153405MY','CW100153424MY','CW100153445MY','CW100153484MY','CW100153595MY','CW100153596MY','CW100153620MY','CW100153788MY','CW100153956MY','CW100153999MY','CW100154020MY','CW100154021MY','CW100154170MY','CW100154224MY','CW100154242MY','CW100154269MY','CW100154319MY','CW100154404MY','CW100154441MY','CW100154554MY','CW100154696MY','CW100154716MY','CW100154726MY','CW100154766MY','CW100154782MY','CW100154783MY','CW100154832MY','CW100154833MY','CW100154834MY','CW100154835MY','CW100154836MY','CW100154847MY','CW100154848MY','CW100154849MY','CW100154850MY','CW100154857MY','CW100154858MY','CW100154859MY','CW100154860MY','CW100154873MY','CW100154876MY','CW100154883MY','CW100154884MY','CW100154901MY','CW100154910MY','CW100154911MY','CW100154912MY','CW100154913MY','CW100154923MY','CW100154929MY','CW100154930MY','CW100154931MY','CW100154933MY','CW100154952MY','CW100154975MY','CW100154979MY','CW100154985MY')





    33
    
    
    





    34
    
    
    
!redeem_5.png!