P15GEN2\59518
2024-05-29 d4210c7c4b04abde20037ea8aa0f54ef8a2649aa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
package policy;
 
import java.util.Date;
 
import foundation.dao.Filter;
import foundation.dao.OrderBy;
import foundation.data.entity.Entity;
import foundation.data.entity.EntitySet;
import foundation.data.object.DataObject;
import foundation.persist.NamedSQL;
import foundation.server.Initializer;
import policy.price.PolicyBucket;
 
public class PolicyLoader extends Initializer {
 
    @Override
    public void startUp() throws Exception {
        load();
    }
 
    private void load() throws Exception {
        PolicyBucket policyBucket = PolicyBucket.getInstance();
        
        policyBucket.setStarting(true);
        try {
            //1. 加载产品
            loadProduct(policyBucket);
            
            //2. 加载标准价价格列表
            loadStandardPriceLists(policyBucket);
            
            //3. 加载经销商价格价格列表
            loadCustomerPriceLists(policyBucket);
            
            //4. 加载买赠优惠(即时数量政策)
            loadQtyOnsiteDiscount(policyBucket);
            
            //5. 加载价格优惠(即时价格政策)
            loadPriceOnsiteDiscount(policyBucket);
            
            //6. 记录当前时间
            PolicyBucket.Now = new Date();            
        }
        finally {
            policyBucket.setStarting(false);
        }
    }
 
    private void loadProduct(PolicyBucket policyBucket) throws Exception {
        NamedSQL namedSQL = NamedSQL.getInstance("policyGetProduct");
        EntitySet entitySet = namedSQL.getEntitySet();
        
        for (Entity entity: entitySet) {
            policyBucket.loadOnePolicy(entity);
        }
    }
 
    private void loadStandardPriceLists(PolicyBucket policyBucket) throws Exception {
        DataObject dataObject = DataObject.getInstance("md_prod_price_detail");
        Filter filter = new Filter("type_code", "Standard").add("state_code", "Open");
        EntitySet entitySet = dataObject.getTableEntitySet(filter, new OrderBy("type_code, product_id"));
        
        for (Entity entity: entitySet) {
            policyBucket.loadOneStandardPriceLine(entity);
        }
    }
    
    private void loadCustomerPriceLists(PolicyBucket policyBucket) throws Exception {
        DataObject dataObject = DataObject.getInstance("md_prod_price_detail");
        Filter filter = new Filter("type_code", "Customer").add("state_code", "Open");
        EntitySet entitySet = dataObject.getTableEntitySet(filter, new OrderBy("type_code, product_id"));
        
        for (Entity entity: entitySet) {
            policyBucket.loadOnePriceListLine(entity);
        }
    }
 
    private void loadQtyOnsiteDiscount(PolicyBucket policyBucket) throws Exception {
        DataObject dataObject = DataObject.getInstance("agm_record_gift");
        Filter filter = new Filter("category_code", "Onsite").add("state_code", "Open");
        
        EntitySet entitySet = dataObject.getTableEntitySet(filter, new OrderBy("type_code, product_id"));
        
        for (Entity entity: entitySet) {
            policyBucket.loadOneQtyOnsiteDiscount(entity);
        }
    }
    
    private void loadPriceOnsiteDiscount(PolicyBucket policyBucket) throws Exception {
        DataObject dataObject = DataObject.getInstance("md_prod_price_detail");
        Filter filter = new Filter("type_code", "Onsite").add("state_code", "Open");
        EntitySet entitySet = dataObject.getTableEntitySet(filter, new OrderBy("type_code, product_id"));
        
        for (Entity entity: entitySet) {
            policyBucket.loadOnePriceOnsiteDiscount(entity);
        }
    }
 
    public static int refreshPriceList() throws Exception {
        PolicyBucket policyBucket = PolicyBucket.getInstance();
        
        NamedSQL namedSQL = NamedSQL.getInstance("getUpdatedPrice");
        namedSQL.setParam("loadTime", PolicyBucket.PriceTime, true);
        EntitySet entitySet = namedSQL.getEntitySet();
        
        boolean standard;
        for (Entity entity: entitySet) {
            standard = "Standard".equals(entity.getString("type_code"));
            
            if (standard) {
                policyBucket.loadOneStandardPriceLine(entity);
            }
            else {
                policyBucket.loadOnePriceListLine(entity);
            }
        }
        
        PolicyBucket.PriceTime = new Date();
        return entitySet.size();
    }    
 
    public static int refreshOnsiteList() throws Exception {
        PolicyBucket policyBucket = PolicyBucket.getInstance();
        
        NamedSQL namedSQL = NamedSQL.getInstance("getUpdatedQtyOnsiteDiscount");
        namedSQL.setParam("loadTime", PolicyBucket.OnsiteTime, true);
        EntitySet entitySet = namedSQL.getEntitySet();
        
        for (Entity entity: entitySet) {
            policyBucket.loadOneQtyOnsiteDiscount(entity);
        }
        
        PolicyBucket.OnsiteTime = new Date();
        return entitySet.size();
    }
 
    @Override
    public void shutDown() throws Exception {
        
    }
 
}