init 代码初始化

P15GEN2\59518

2025-10-10 9f6890646993d16260d4201d613c092132856127

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
package biz.target;
 
import java.util.ArrayList;
import java.util.List;
 
import biz.report.Report;
import foundation.data.entity.Entity;
import foundation.data.entity.EntitySet;
import foundation.data.entity.Filter;
import foundation.data.entity.OrderBy;
import foundation.data.object.DataObject;
import foundation.persist.NamedSQL;
import foundation.util.ContentBuilder;
 
public enum TargetType {
    Detail("tgt_planning_detail", "id", "detail", new String[] {"customer_id", "sku_id"}, "机构品规指标"),
    Customer("tgt_planning_customer", "planning_customer_id", "customer", new String[] {"customer_id"}, "机构指标"),
    Product("tgt_planning_product", "planning_product_id", "product", new String[] {"product_id"}, "产品指标"),
    Sku("tgt_planning_sku", "planning_sku_id", "sku", new String[] {"sku_id"}, "品规指标"),
    Position("tgt_planning_position", "planning_position_id", "position", new String[] {"position_id"}, "岗位指标"),
    Unknown("", "", "", new String[] {}, "");
    
    private String tableName;
    private String code;
    private String name;
    private String idField;
    private String[] keyFields;
    
    private TargetType(String dataName, String code, String idField, String[] keyFields, String name) {
        this.tableName = dataName;
        this.idField = idField;
        this.keyFields = keyFields;
        this.code = code;
        this.name = name;
    }
    
 
    public String getTableName() {
        return tableName;
    }
 
    public String getCode() {
        return code;
    }
 
    public String getName() {
        return name;
    }
 
    public String getIdField() {
        return idField;
    }
 
    public String[] getKeyFields() {
        return keyFields;
    }
 
    public static TargetType parse(String dataname) {
        dataname = dataname.toLowerCase();
        
        if ("tgt_planning_detail".equalsIgnoreCase(dataname)) {
            return Detail;
        }
        else if ("tgt_planning_customer".equalsIgnoreCase(dataname)) {
            return Customer;
        }
        else if ("tgt_planning_position".equalsIgnoreCase(dataname)) {
            return Position;
        }
        else if ("tgt_planning_sku".equalsIgnoreCase(dataname)) {
            return Sku;
        }
        else if ("tgt_planning_product".equalsIgnoreCase(dataname)) {
            return Product;
        }
        
        return Unknown;
    }
 
    public String getKeyValue(Entity entity) {
        ContentBuilder builder =  new ContentBuilder("-");
        for (String keyField : keyFields) {
            builder.append(entity.getString(keyField));
        }
        
        return builder.toString();
    }
    
    public List<NamedSQL> getTargetAction() throws Exception{
        List<NamedSQL> sqlList = new ArrayList<NamedSQL>();
        
        DataObject dataObject = DataObject.getInstance("tgt_create_flow");
        Filter filter = new Filter();
        filter.add("dataname", tableName);
        EntitySet entitySet = dataObject.getTableEntitySet(filter, new OrderBy("code asc, index_no asc"));
        
        for(Entity entity : entitySet) {
            NamedSQL namedSQL = NamedSQL.getInstance(entity.getString("exec_sql"));
            namedSQL.setTableName(entity.getString("dataname"));
            sqlList.add(namedSQL);
        }
        
        return sqlList;
    }
}