@isTest
|
public class SSPowerBIBatchTest {
|
@isTest
|
static void makeTest() {
|
|
StaticParameter.EscapeNFM001AgencyContractTrigger = true;
|
StaticParameter.EscapeNFM001Trigger = true;
|
// システム管理者
|
User user = new User(Test_staff__c = true);
|
user.LastName = '_サンブリッジ';
|
user.FirstName = 'う';
|
user.Alias = 'う';
|
user.Email = 'olympusTest03@sunbridge.com';
|
user.Username = 'olympusTest03@sunbridge.com';
|
user.CommunityNickname = 'う';
|
user.IsActive = true;
|
user.EmailEncodingKey = 'ISO-2022-JP';
|
user.TimeZoneSidKey = 'Asia/Tokyo';
|
user.LocaleSidKey = 'ja_JP';
|
user.LanguageLocaleKey = 'ja';
|
user.ProfileId = System.Label.ProfileId_SystemAdmin;
|
user.Job_Category__c = '销售推广';
|
user.Province__c = '上海市';
|
user.Use_Start_Date__c = Date.today().addMonths(-6);
|
user.SalesManager__c = UserInfo.getUserId();
|
user.BuchangApprovalManagerSales__c = UserInfo.getUserId();
|
user.JingliApprovalManager__c = UserInfo.getUserId();
|
user.BuchangApprovalManager__c = UserInfo.getUserId();
|
user.ZongjianApprovalManager__c = UserInfo.getUserId();
|
|
System.runAs(new User(Id = Userinfo.getUserId())) {
|
insert user;
|
}
|
// 省
|
Address_Level__c al = new Address_Level__c();
|
al.Name = '東京';
|
al.Level1_Code__c = 'CN-99';
|
al.Level1_Sys_No__c = '999999';
|
insert al;
|
// 市
|
Address_Level2__c al2 = new Address_Level2__c();
|
al2.Level1_Code__c = 'CN-99';
|
al2.Level1_Sys_No__c = '999999';
|
al2.Level1_Name__c = '東京';
|
al2.Name = '渋谷区';
|
al2.Level2_Code__c = 'CN-9999';
|
al2.Level2_Sys_No__c = '9999999';
|
al2.Address_Level__c = al.id;
|
insert al2;
|
// 病院を作る
|
Account hospital = new Account();
|
hospital.recordtypeId = [Select Id FROM RecordType WHERE IsActive = true and SobjectType = 'Account' and DeveloperName = 'HP'].id;
|
hospital.Name = 'test hospital';
|
hospital.Is_Active__c = '有効';
|
hospital.Attribute_Type__c = '卫生部';
|
hospital.Speciality_Type__c = '综合医院';
|
hospital.Grade__c = '一级';
|
hospital.OCM_Category__c = 'SLTV';
|
hospital.Is_Medical__c = '医疗机构';
|
hospital.State_Master__c = al.id;
|
hospital.City_Master__c = al2.id;
|
hospital.Town__c = '东京';
|
insert hospital;
|
// 戦略科室を得る
|
Account[] strategicDep = [SELECT ID, Name FROM Account WHERE parentId = :hospital.Id AND recordType.DeveloperName = 'Department_Class_OTH'];
|
// 診療科を作る
|
Account dep = new Account();
|
dep.recordtypeId = [Select Id FROM RecordType WHERE IsActive = true and SobjectType = 'Account' and DeveloperName = 'Department_OTH'].id;
|
dep.Name = 'test dep';
|
dep.AgentCode_Ext__c = '9999998';
|
dep.ParentId = strategicDep[0].Id;
|
dep.Department_Class__c = strategicDep[0].Id;
|
dep.Hospital__c = hospital.Id;
|
insert dep;
|
Contact contact2 = new Contact();
|
contact2.AccountId = dep.Id;
|
contact2.FirstName = '責任者';
|
contact2.LastName = 'test1经销商';
|
insert contact2;
|
// 产品
|
Product2 pro5 = new Product2(Name = 'name05', IsActive = true, Family = 'SP',
|
Fixture_Model_No__c = 'n05', Serial_Lot_No__c = 'S/N tracing',
|
Fixture_Model_No_T__c = 'n05',
|
ProductCode_Ext__c = 'pc05', Manual_Entry__c = false);
|
insert pro5;
|
//备品借出申请
|
|
|
Rental_Apply__c raObj = new Rental_Apply__c();
|
raObj.Name = 'test';
|
raObj.applyUser__c = user.Id;
|
raObj.Status__c = FixtureUtil.raStatusMap.get(FixtureUtil.RaStatus.Cao_An_Zhong.ordinal());
|
raObj.Request_shipping_day__c = Date.today().addDays(3);
|
raObj.Hope_Lonaer_date_Num__c = 6;
|
//raObj.Request_return_day__c = Date.today().addDays(8);
|
raObj.Person_In_Charge__c = user.Id;
|
raObj.demo_purpose1__c = '其他';
|
raObj.demo_purpose2__c = '其他';
|
insert raObj;
|
// 保有设备C (只有附属品 个体管理)
|
Asset assetC1 = new Asset(Asset_Owner__c = 'Olympus');
|
assetC1.RecordTypeId = System.Label.Asset_RecordType;
|
assetC1.SerialNumber = 'assetC1';
|
assetC1.Name = 'assetC1';
|
assetC1.AccountId = dep.Id;
|
assetC1.Department_Class__c = strategicDep[0].Id;
|
assetC1.Hospital__c = hospital.Id;
|
assetC1.Product2Id = pro5.Id;
|
assetC1.Quantity = 1;
|
assetC1.Status = '有库存';
|
assetC1.Manage_type__c = '个体管理';
|
assetC1.Internal_asset_location__c = '北京 备品中心';
|
assetC1.Loaner_accsessary__c = true;
|
assetC1.Delete_Flag__c = false;
|
assetC1.Freeze_sign__c = false;
|
assetC1.Out_of_wh__c = 0;
|
// 保有设备
|
Asset asset = new Asset(Asset_Owner__c = 'Olympus');
|
asset.RecordTypeId = System.Label.Asset_RecordType;
|
asset.SerialNumber = 'asset';
|
asset.Name = 'asset';
|
asset.AccountId = dep.Id;
|
asset.Department_Class__c = strategicDep[0].Id;
|
asset.Hospital__c = hospital.Id;
|
asset.Product2Id = pro5.Id;
|
asset.Quantity = 1;
|
asset.Status = '有库存';
|
asset.Manage_type__c = '个体管理';
|
asset.Internal_asset_location__c = '北京 备品中心';
|
asset.Loaner_accsessary__c = true;
|
asset.Delete_Flag__c = false;
|
asset.Freeze_sign__c = false;
|
asset.Out_of_wh__c = 0;
|
insert new Asset[] {assetC1, asset};
|
// 备品配套(只有附属品)
|
Fixture_Set__c fsObjC1 = new Fixture_Set__c();
|
fsObjC1.Name = 'setC1';
|
fsObjC1.Fixture_Set_Body_Model_No__c = 'modelNoC1';
|
fsObjC1.Loaner_name__c = 'nameC1';
|
insert fsObjC1;
|
// 备品配套明细(只有附属品)
|
Fixture_Set_Detail__c fsdObjC1 = new Fixture_Set_Detail__c();
|
fsdObjC1.Name = 'detailAccessory';
|
fsdObjC1.Name_CHN_Created__c = 'detailAccessoryName';
|
fsdObjC1.Product2__c = pro5.Id;
|
fsdObjC1.Fixture_Set__c = fsObjC1.Id;
|
fsdObjC1.Is_Body__c = false;
|
fsdObjC1.Is_Optional__c = true;
|
fsdObjC1.UniqueKey__c = fsObjC1.Id + ':' + pro5.Id;
|
fsdObjC1.SortInt__c = 1;
|
insert fsdObjC1;
|
// 借出备品配套一览
|
Rental_Apply_Equipment_Set__c raesObjC1 = new Rental_Apply_Equipment_Set__c();
|
raesObjC1.Rental_Apply__c = raObj.Id;
|
raesObjC1.Fixture_Set__c = fsObjC1.Id;
|
raesObjC1.Cancel_Select__c = false;
|
raesObjC1.Shipment_request_time__c = Date.toDay();
|
raesObjC1.Rental_Start_Date__c = Date.toDay();
|
raesObjC1.Rental_End_Date__c = Date.toDay();
|
raesObjC1.IndexFromUniqueKey__c = 1;
|
raesObjC1.UniqueKey__c = '1:' + fsObjC1.Id + ':1';
|
insert raesObjC1;
|
// 借出备品配套一览明细
|
Rental_Apply_Equipment_Set_Detail__c raesdObjC1 = new Rental_Apply_Equipment_Set_Detail__c();
|
raesdObjC1.Rental_Apply__c = raObj.Id;
|
raesdObjC1.Fixture_Set_Detail__c = fsdObjC1.Id;
|
raesdObjC1.Rental_Num__c = 1;
|
raesdObjC1.Queue_Number__c = null;
|
raesdObjC1.Is_Body__c = false;
|
raesdObjC1.Rental_Apply_Equipment_Set__c = raesObjC1.Id;
|
raesdObjC1.Asset__c = assetC1.Id;
|
raesdObjC1.IndexFromUniqueKey__c = 1;
|
raesdObjC1.UniqueKey__c = '1:' + raesObjC1.Id + ':' + fsdObjC1.Id + ':1';
|
raesdObjC1.Salesdepartment_before__c = '1.华北营业本部';
|
raesdObjC1.Internal_asset_location_before__c = '北京 备品中心';
|
raesdObjC1.Product_category_text__c = 'GI';
|
raesdObjC1.Equipment_Type_text__c = '产品试用';
|
insert raesdObjC1;
|
List<Id> racId = new List<Id>();
|
racId.add(raObj.Id);
|
SS_Batch_Column_Mapping__c oppMapping = new SS_Batch_Column_Mapping__c(Name = 'Rental_Apply__c', SS_TableName__c = 'Rental_Apply_Power_BI__c');
|
oppMapping.From_Column_001__c = 'Name';
|
oppMapping.SS_Column_001__c = 'Name';
|
insert oppMapping;
|
SS_Batch_Column_Mapping__c a02Mapping = new SS_Batch_Column_Mapping__c(Name = 'Rental_Apply_Equipment_Set__c', SS_TableName__c = 'Rental_Apply_Equipment_Set_Power_BI__c');
|
a02Mapping.From_Column_001__c = 'Name';
|
a02Mapping.SS_Column_001__c = 'Name';
|
insert a02Mapping;
|
SS_Batch_Column_Mapping__c a03Mapping = new SS_Batch_Column_Mapping__c(Name = 'Rental_Apply_Equipment_Set_Detail__c', SS_TableName__c = 'Rental_Apply_Equipment_Set_DetailPower_B__c');
|
a03Mapping.From_Column_001__c = 'Name';
|
a03Mapping.SS_Column_001__c = 'Name';
|
insert a03Mapping;
|
Id execBTId = Database.executeBatch(new SSPowerBIBatch(), 1);
|
Id execBTIdA02 = Database.executeBatch(new SSPowerBIBatch(racId), 1);
|
Id execBTIdA03 = Database.executeBatch(new SSPowerBIBatch(Date.today()), 1);
|
Id execBTIdA04 = Database.executeBatch(new SSPowerBIBatch(racId,Date.today()), 1);
|
}
|
}
|
