dev 契约锁

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
143
144
145
146
147
148
149
150
151
package target;
 
import foundation.dao.DataPackage;
import foundation.data.meta.field.FieldsRuntime;
import foundation.data.object.DataObject;
import foundation.util.Util;
 
public enum TargetType {
    Implant("so_implant", "md_target_hospital", "hospital", "implant", "植入指标"),
    Dealer("so_order", "md_target_dealer_hospital", "department", "dealer", "商采指标"),
    Unknown("", "", "", "", "");
    
    private String achieveName;
    private String tableName;
    private String positionConnect;
    private String positionTable;
    private String joinSql;
    private String code;
    private String name;
    private String qtyField;
    private String amtField;
    private DataObject document;
    private DataObject documentDetail;
    
    private TargetType(String achieveName, String tableName, String positionConnect, String code, String name) {
        this.achieveName = achieveName;
        this.tableName = tableName;
        this.positionConnect = positionConnect;
        this.code = code;
        this.name = name;
 
        loadDocument();
        loadPositioJoin();
    }
    
    public void loadPackage() throws Exception {
        DataPackage dataPackage =  DataPackage.getInstance(achieveName);
        document = dataPackage.getMasterDataObject();
        documentDetail = dataPackage.getDetailDataObject();
    }
    
    public void loadPositioJoin() {
        if ("hospital".equalsIgnoreCase(positionConnect)) {
            positionTable = "md_position_hospital";
            joinSql = " positionTable.hospital_id = target.hospital_id "; 
        }
        else if ("department".equalsIgnoreCase(positionConnect)) {
            positionTable = "md_position_hospital";
            joinSql = " positionTable.hospital_id = target.hospital_id and ifnull(positionTable.department,'--') = ifnull(target.department ,'--') ";
        }
        else if ("account".equalsIgnoreCase(positionConnect)) {
            positionTable = "md_org_account_position";
            joinSql = " target.account_id = positionTable.parent_id "; 
        }
    }
    
    public void loadDocument() {
        if ("so_implant".equalsIgnoreCase(achieveName)) {
            qtyField = "qty";
            amtField = "";
        }
        else if ("so_order".equalsIgnoreCase(achieveName)) {
            qtyField = "qty_list";
            amtField = "amt_after_discount";
        }
    }
 
    public String getAchieveName() {
        return achieveName;
    }
 
    public String getTableName() {
        return tableName;
    }
 
    public String getPositionConnect() {
        return positionConnect;
    }
 
    public String getPositionTable() {
        return positionTable;
    }
 
    public String getJoinSql() {
        return joinSql;
    }
 
    public String getCode() {
        return code;
    }
 
    public String getName() {
        return name;
    }
 
    public String getDocument() {
        return document.getTableName();
    }
    
    public String getDocumentDetail() {
        return documentDetail.getTableName();
    }
 
    public String getQtyField() {
        if (Util.isEmpty(qtyField)) {
            return "0";
        }
        return "document_detail."  + qtyField;
    }
 
    public String getAmtField() {
        if (Util.isEmpty(amtField)) {
            return "0";
        }
        
        return "document_detail."  + amtField;
    }
 
    public String getDocumentPosition() throws Exception {
        FieldsRuntime fields = document.getTableFieldMetas();
        
        if (fields.get("position_id") == null ) {
            return "sale_position_id";
        }
        return "position_id";
    }
 
    public static TargetType parse(String targetType) {
        targetType = targetType.toLowerCase();
        
        if ("implant".equalsIgnoreCase(targetType)) {
            return Implant;
        }
        else if ("dealer".equalsIgnoreCase(targetType)) {
            return Dealer;
        }
        return Unknown;
    }
 
    public static TargetType parseByTableName(String tableName) {
        tableName = tableName.toLowerCase();
        
        if ("md_target_hospital".equalsIgnoreCase(tableName)) {
            return Implant;
        }
        else if ("md_target_dealer_hospital".equalsIgnoreCase(tableName)) {
            return Dealer;
        }
        return Unknown;
    }
}