高章伟
2022-02-18 8b5f4c6c281cfa548f92de52c8021e37aa81901e
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
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
/**
 * wangweipeng  2021/07/12 11:25    SWAG-C4P8CM
 * OPDIfNewestHaveOpportunityBatch   测试类
 * 每天更新 opd计划表的 if_Newest_HaveOpportunity__c 字段值
 */
@isTest
private class OPDIfNewestHaveOpportunityBatchTest {
    static testMethod void testMethod1() {
        SS_Batch_Column_Mapping__c oppMapping = new SS_Batch_Column_Mapping__c(Name = 'targetKeyProduct', SS_TableName__c='targetKeyProduct__c');
 
        oppMapping.From_Column_118__c = 'Sales_target_CV290__c';
        oppMapping.SS_Column_118__c = 'CV-290';
        oppMapping.From_Column_119__c = 'Sales_target_290Miro__c';
        oppMapping.SS_Column_119__c = 'GI-290镜子,GI-290镜子放大,GI-290镜子CF,BF-290镜子';
        oppMapping.From_Column_120__c = 'Sales_target_TB__c';
        oppMapping.SS_Column_120__c = 'TB';
        oppMapping.From_Column_129__c = 'Opp_cnt_290MiroBF__c';
        oppMapping.SS_Column_129__c = 'BF-290镜子';
        oppMapping.From_Column_130__c = 'Opp_cnt_290MiroGI__c';
        oppMapping.SS_Column_130__c = 'GI-290镜子';
        oppMapping.From_Column_131__c = 'Opp_cnt_290MiroGI_CF__c';
        oppMapping.SS_Column_131__c = 'GI-290镜子CF';
        oppMapping.From_Column_146__c = 'Asset_Cnt_290MiroBF__c';
        oppMapping.SS_Column_146__c = 'BF-290镜子';
        oppMapping.From_Column_147__c = 'Asset_Cnt_290MiroGI__c';
        oppMapping.SS_Column_147__c = 'GI-290镜子';
        oppMapping.From_Column_148__c = 'Asset_Cnt_290MiroGI_CF__c';
        oppMapping.SS_Column_148__c = 'GI-290镜子CF';
        oppMapping.From_Column_163__c = 'OPD_amount_290MiroBF__c';
        oppMapping.SS_Column_163__c = 'BF-290镜子';
        oppMapping.From_Column_164__c = 'OPD_amount_290MiroGI__c';
        oppMapping.SS_Column_164__c = 'GI-290镜子';
        oppMapping.From_Column_165__c = 'OPD_amount_290MiroGI_CF__c';
        oppMapping.SS_Column_165__c = 'GI-290镜子CF';
        insert new SS_Batch_Column_Mapping__c[] {oppMapping};
        
 
       //医院 记录类型
        List<RecordType> rectHp = [select Id from RecordType where IsActive = true and SobjectType = 'Account' and DeveloperName = 'HP'];
        if (rectHp.size() == 0) {
            return;
        }
        //科室 记录类型
        List<RecordType> rectDpt = [select Id from RecordType where IsActive = true and SobjectType = 'Account' and DeveloperName = 'Department_GI'];
        if (rectDpt.size() == 0) {
            return;
        }
 
        //简档
        Profile p = [select Id from Profile where id =:System.Label.ProfileId_SystemAdmin];
 
        //用户
        User hpOwner = new User(Test_staff__c = true, LastName = 'hp', FirstName = 'owner', Alias = 'hp', Work_Location__c = '北京', CommunityNickname = 'hpOwner', Email = 'olympus_hpowner@sunbridge.com', Username = 'olympus_hpowner@sunbridge.com', IsActive = true, EmailEncodingKey = 'ISO-2022-JP', TimeZoneSidKey = 'Asia/Tokyo', LocaleSidKey = 'ja_JP', LanguageLocaleKey = 'ja', ProfileId = p.id);
        insert hpOwner;
        User hpOwner2 = new User(Test_staff__c = true, LastName = 'hp2', FirstName = 'owner', Alias = 'hp2', Work_Location__c = '重庆', CommunityNickname = 'hpOwner2', Email = 'olympus_hpowner@sunbridge.com', Username = 'olympus_hpowner2@sunbridge.com', IsActive = true, EmailEncodingKey = 'ISO-2022-JP', TimeZoneSidKey = 'Asia/Tokyo', LocaleSidKey = 'ja_JP', LanguageLocaleKey = 'ja', ProfileId = p.id);
        insert hpOwner2;
 
 
        //医院
        Account hp = new Account(RecordTypeId = rectHp[0].Id, Name = 'hp', OwnerId = hpOwner.Id);
        hp.FSE_GI_Main_Leader__c = hpOwner.Id;
        hp.FSE_SP_Main_Leader__c = hpOwner2.Id;
        insert hp;
 
        //战略科室
        Account dc = [select Id, Name, RecordType_DeveloperName__c, Account2__c from Account where ParentId = :hp.Id and RecordType_DeveloperName__c = 'Department_Class_GI'];
        //科室
        Account dpt = new Account(RecordTypeId = rectDpt[0].Id);
        dpt.Name         = '*';
        dpt.Department_Name__c  = 'TestDepart';
        dpt.ParentId            = dc.Id;
        dpt.Department_Class__c = dc.Id;
        dpt.Hospital__c         = hp.Id;
        insert dpt;
        //科室1
        Account dpt1 = new Account(RecordTypeId = rectDpt[0].Id);
        dpt1.Name         = '123';
        dpt1.Department_Name__c  = 'TestDepart1';
        dpt1.ParentId            = dc.Id;
        dpt1.Department_Class__c = dc.Id;
        dpt1.Hospital__c         = hp.Id;
        insert dpt1;
 
         //根据opd计划实施日期 算出本财年
        Date dateToday = Date.today();
        Integer year = dateToday.year();
        Integer month = dateToday.month();
        if (month < 4) {
            year -= 1;
        }
        String selectedTab = String.valueOf(year - 1867 - 1 + 'P'); 
        String selectedTab1 = String.valueOf(year - 1867 + 'P'); //今财年
 
        //客户-目标客户 默认让opd计划和客户-目标客户的财年相同
        Account_Number_of_target__c anot = new Account_Number_of_target__c();
        anot.Account__c = dc.Id;
        anot.Account_HP__c = hp.Id;
        anot.OCM_Period__c = selectedTab;
        anot.Target_amount_170_190__c =36597;
        anot.OPD_amount_290MiroBF__c =1;
        anot.OCM_Year__c = '2021年度';
        anot.OPD_amount_290MiroGI_CF__c =1;
        insert anot;
 
        Account_Number_of_target__c anot1 = new Account_Number_of_target__c();
        anot1.Account__c = dc.Id;
        anot1.Account_HP__c = hp.Id;
        anot1.OCM_Period__c = selectedTab1;
        anot1.Target_amount_170_190__c =36597;
        anot1.OPD_CV290__c =1;
        anot1.OPD_290Miro__c =1;
        anot1.OPD_TB__c =1;
        anot1.Rental_Cnt_CV290__c =1;
        anot1.Rental_Cnt_TB__c =1;
        anot1.Target_amount_CV290__c =1;
        anot1.Target_amount_TB__c  =1;//Sales_target_TB__c
        anot1.Opp_cnt_290MiroGI__c =1;
        anot1.Opp_cnt_290MiroGI_CF__c =1;
        anot1.Asset_Cnt_290MiroBF__c =1;
        anot1.OPD_amount_290MiroBF__c =1;
        anot1.OPD_amount_290MiroGI_CF__c =1;
        anot1.OCM_Year__c = '2021年度';
 
        insert anot1;
 
        OPDPlan__c oPDPlan0 = new OPDPlan__c();
        oPDPlan0.Status__c = '审批中';
        oPDPlan0.OPDType__c = '学会';
        oPDPlan0.if_OPDTarget__c=1;
        oPDPlan0.if_HaveSalestarget__c =1;
        oPDPlan0.Cnt_OPD_ThisYear__c=1;
        oPDPlan0.Cnt_OPD_LastYear__c=1;
        oPDPlan0.if_HaveOpportunity__c=1;
        oPDPlan0.if_HaveEquipment__c =1;
        oPDPlan0.Cnt_Rentals__c =1;
        oPDPlan0.PlanProdDetail__c ='CV-290*4; GI-290镜子*1; GI-290镜子CF*1;';
        oPDPlan0.Account_Laboratory__c =dpt.Id;
        oPDPlan0.OPDPlan_ImplementDate__c = Date.today();
        oPDPlan0.OPDPlan_ImplementDate_temp__c = Date.today();
        oPDPlan0.NoOpp_Reason__c = 'HCP对应';
       // oPDPlan0.OPD_Customers_Target_Last__c=anot.id;
       // oPDPlan0.OPD_Customers_Target__c =anot1.id;
        insert oPDPlan0;
        //opd计划1
        OPDPlan__c oPDPlan1 = new OPDPlan__c();
        oPDPlan1.ThisMonthPlan__c = 1;
        oPDPlan1.Status__c = '草案中';
        oPDPlan1.Account_Laboratory__c =dpt.Id;
        oPDPlan1.OPD_Customers_Target_Last__c=null;
        oPDPlan1.OPDPlan_ImplementDate__c = Date.today().addDays(3);
        oPDPlan1.NoOpp_Reason__c = 'HCP对应';
        insert oPDPlan1;
        oPDPlan0.Account_Laboratory__c =dpt.Id;
        oPDPlan0.OPDPlan_ImplementDate__c = oPDPlan1.OPDPlan_ImplementDate__c.addDays(40);
        update oPDPlan0;
 
        OPDPlan__c oPDPlan3 = new OPDPlan__c();
        oPDPlan3.ThisMonthPlan__c = 1;
        oPDPlan3.Status__c = '计划中';
        oPDPlan3.Account_Laboratory__c =dpt.Id;
        oPDPlan3.OPD_Customers_Target_Last__c=null;
        oPDPlan3.OPDPlan_ImplementDate__c = Date.today().addDays(3);
        oPDPlan3.NoOpp_Reason__c = 'HCP对应';
        insert oPDPlan3;
 
        
        OPDPlan__c oPDPlan2 = new OPDPlan__c();
        oPDPlan2.Status__c = '草案中';
        oPDPlan2.Account_Laboratory__c =dpt.Id;
        //oPDPlan2.OPDPlan_ImplementDate__c = Date.today();
        oPDPlan2.NoOpp_Reason__c = 'HCP对应';
        oPDPlan2.if_OPDTarget__c=1;
        oPDPlan2.if_HaveSalestarget__c =1;
        oPDPlan2.Cnt_OPD_ThisYear__c=1;
        oPDPlan2.Cnt_OPD_LastYear__c=1;
        oPDPlan2.if_HaveOpportunity__c=1;
        oPDPlan2.if_HaveEquipment__c =1;
        oPDPlan2.Cnt_Rentals__c =1;
        oPDPlan0.OPDType__c = '学会';
        oPDPlan2.OPD_Customers_Target_Last__c=anot.id;
        oPDPlan2.OPD_Customers_Target__c =anot1.id;
        oPDPlan2.PlanProdDetail__c ='CV-290*4; GI-290镜子*1; GI-290镜子CF*1;';
        // oPDPlan2.OriginalOpdPlan__c = oPDPlan3.Id;
        insert oPDPlan2;
        oPDPlan2.Status__c = '审批中'; 
        
        update oPDPlan2;
 
        //2021-06-26   mzy  add 
 
        OPDPlan__c oPDPlan4 = new OPDPlan__c();
        oPDPlan4.Status__c = '草案中';
        oPDPlan4.Account_Laboratory__c =dpt.Id;
        oPDPlan4.OPDPlan_ImplementDate__c = Date.today();
        oPDPlan4.NoOpp_Reason__c = 'HCP对应';
        oPDPlan4.if_OPDTarget__c=1;
        oPDPlan4.if_HaveSalestarget__c =1;
        oPDPlan4.Cnt_OPD_ThisYear__c=1;
        oPDPlan4.Cnt_OPD_LastYear__c=1;
        oPDPlan4.if_HaveOpportunity__c=1;
        oPDPlan4.if_HaveEquipment__c =1;
        oPDPlan4.Cnt_Rentals__c =1;
        oPDPlan4.OPD_Customers_Target_Last__c=anot.id;
        oPDPlan4.OPD_Customers_Target__c =anot1.id;
        oPDPlan4.PlanProdDetail__c ='CV-290*4; GI-290镜子*1; GI-290镜子CF*1;';
        insert oPDPlan4;
 
        //取消
        CancelPostponePlan__c tempCancelPostponePlan = new  CancelPostponePlan__c();
        tempCancelPostponePlan.Status__c = '取消成功';
        tempCancelPostponePlan.CancelOPDPlan__c = oPDPlan4.Id;
        tempCancelPostponePlan.RecordTypeId = '01210000000gQyL';
        tempCancelPostponePlan.cancelReasonCombobox__c  = '无备品';
        insert tempCancelPostponePlan;
 
 
        oPDPlan4 = [select id,DelayCancel_Reason__c,Status__c from OPDPlan__c where id = :oPDPlan4.Id];
        //System.assertEquals('',oPDPlan4.Status__c);
        //System.assertEquals('',oPDPlan4.DelayCancel_Reason__c);
 
 
        OPDPlan__c oPDPlan5 = new OPDPlan__c();
        oPDPlan5.Status__c = '审批中';
        oPDPlan5.Account_Laboratory__c =dpt.Id;
        oPDPlan5.OPDPlan_ImplementDate__c = Date.today();
        oPDPlan5.NoOpp_Reason__c = 'HCP对应';
        oPDPlan5.if_OPDTarget__c=1;
        oPDPlan5.if_HaveSalestarget__c =1;
        oPDPlan5.Cnt_OPD_ThisYear__c=1;
        oPDPlan5.Cnt_OPD_LastYear__c=1;
        oPDPlan5.if_HaveOpportunity__c=1;
        oPDPlan5.if_HaveEquipment__c =1;
        oPDPlan5.Cnt_Rentals__c =1;
        oPDPlan5.OPD_Customers_Target_Last__c=anot.id;
        oPDPlan5.OPD_Customers_Target__c =anot1.id;
        oPDPlan5.PlanProdDetail__c ='CV-290*4; GI-290镜子*1; GI-290镜子CF*1;';
        oPDPlan5.OriginalOpdPlan__c = oPDPlan4.Id;
        insert oPDPlan5;
 
 
 
        OPDPlan__c oPDPlan6 = new OPDPlan__c();
        oPDPlan6.Status__c = '审批中';
        oPDPlan6.OPDType__c = '学会';
        oPDPlan6.Account_Laboratory__c =dpt.Id;
        oPDPlan6.OPDPlan_ImplementDate__c = Date.today().addDays(3);
        oPDPlan6.NoOpp_Reason__c = 'HCP对应';
        oPDPlan6.if_OPDTarget__c=1;
        oPDPlan6.if_HaveSalestarget__c =1;
        oPDPlan6.Cnt_OPD_ThisYear__c=1;
        oPDPlan6.Cnt_OPD_LastYear__c=1;
        oPDPlan6.if_HaveOpportunity__c=1;
        oPDPlan6.if_HaveEquipment__c =1;
        oPDPlan6.Cnt_Rentals__c =1;
        oPDPlan6.OPD_Customers_Target_Last__c=anot.id;
        oPDPlan6.OPD_Customers_Target__c =anot1.id;
        oPDPlan6.PlanProdDetail__c ='CV-290*4; GI-290镜子*1; GI-290镜子CF*1;';
        oPDPlan6.OriginalOpdPlanApplication__c = oPDPlan3.Id;
        oPDPlan6.RentalReson__c = '追加配套';
        insert oPDPlan6;
 
        List<Id> listId = new List<ID>();
        listId.add(oPDPlan0.id);
        Id execBTId = Database.executeBatch(new OPDIfNewestHaveOpportunityBatch(listId), 200);
 
        Database.executeBatch(new OPDIfNewestHaveOpportunityBatch(), 200);
    }
}