@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);
        }
}