@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 racId = new List(); 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); } }