@isTest
|
public class AssetPowerBIBatchTest {
|
|
@isTest
|
static void makeSqlTest() {
|
|
// 2020/07/08 taoqz start
|
User u = [select id,Dept__c from user where id = :UserInfo.getUserId()];
|
u.Dept__c = null;
|
update u;
|
// 2020/07/08 taoqz end
|
|
// 省
|
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 = hospital.Id;
|
contact2.FirstName = '責任者';
|
contact2.Strategic_dept_Class__c = dep.Id;
|
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 = 'testra';
|
raObj.Product_category__c = 'GI';
|
raObj.Demo_purpose1__c = '产品试用';
|
raObj.demo_purpose2__c = '试用（无询价）';
|
raObj.direct_send__c = '医疗机构';
|
raObj.Loaner_received_staff__c = '王五';
|
raObj.Loaner_received_staff_phone__c = '110';
|
raObj.direct_shippment_address__c = '北京市';
|
raObj.Hospital__c = hospital.Id;
|
raObj.Strategic_dept__c = strategicDep[0].Id;
|
raObj.Account__c = dep.Id;
|
raObj.Request_shipping_day__c = Date.toDay();
|
raObj.Request_return_day__c = Date.toDay();
|
raObj.Phone_number__c = '1234567890';
|
raObj.Loaner_medical_Staff__c = contact2.Id;
|
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 = '北京 备品中心';
|
// 2020/07/08 taoqz start update
|
// assetC1.Loaner_accsessary__c = true;
|
assetC1.Loaner_accsessary__c = false;
|
assetC1.AssetManageConfirm__c = true;
|
// 2020/07/08 taoqz end update
|
assetC1.Delete_Flag__c = false;
|
assetC1.Freeze_sign__c = false;
|
assetC1.Out_of_wh__c = 0;
|
// 保有设备
|
List<RecordType> rectCo = [select Id, DeveloperName from RecordType where DeveloperName = 'Shipment' and SobjectType = 'Asset'];
|
Asset asset = new Asset(Asset_Owner__c = 'Olympus');
|
asset.RecordTypeId = rectCo[0].Id; //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};
|
List<Id> assetId = new List<Id>();
|
assetId.add(asset.Id);
|
SS_Batch_Column_Mapping__c oppMapping = new SS_Batch_Column_Mapping__c(Name = 'asset', SS_TableName__c = 'asset_Power_BI__c');
|
oppMapping.From_Column_001__c = 'Name';
|
oppMapping.SS_Column_001__c = 'Name';
|
insert oppMapping;
|
Id execBTId = Database.executeBatch(new AssetPowerBIBatch(), 100);
|
Id execBTIdA02 = Database.executeBatch(new AssetPowerBIBatch(assetId), 100);
|
AssetPowerBIBatch t = new AssetPowerBIBatch();
|
t.test();
|
|
}
|
}
|
