// create by tcm 20211220 处理失单报告历史数据
// 2022-01-18 修改 从失单报告处理历史数据
global class LostCancelReportOppBatch implements Database.Batchable<sObject> {

	public List<String> IdList=new List<String> ();

	public Date start_date;

	public Date end_date;

	public Boolean update_all = true;

	global LostCancelReportOppBatch() {
	}

	// 通过询价Id查找
	global LostCancelReportOppBatch(List<string> IdList) {
		this.IdList = IdList;
	}

	// 通过日期查找
	global LostCancelReportOppBatch(String str_start, String str_end, Boolean if_upd_all) {
		this.start_date = String.isNotBlank(str_start) ? Date.parse(str_start) : null;
		this.end_date = String.isNotBlank(str_end) ? Date.parse(str_end) : null;
		this.update_all = if_upd_all != null ? if_upd_all : true;
	}

	global Database.QueryLocator start(Database.BatchableContext bc) {
		// string query ='select id from Opportunity ';
		// if (IdList.size() > 0) {
		// 	query += ' where Id in :IdList';
		// }
		// 2022-01-18 修改 从失单报告取值
		String query = 'SELECT Id, Opportunity__c FROM Lost_cancel_report__c WHERE Report_Status__c = \'批准\' AND LostType__c in (\'失单\', \'部分失单\') ';
		//20230215 lt DB202302247719 add , Opportunity__c
		if (start_date != null) {
			query += ' AND Submit_Day__c >= :start_date';
		}
		if (end_date != null) {
			query += ' AND Submit_Day__c >= :start_date';
		}
		if (IdList != null && IdList.size() > 0) {
			query += ' AND Opportunity__c in :IdList';
		}
		if (!update_all) {
			query += ' AND Opportunity__r.PCLLostBrands__c != null';
		}
		return Database.getQueryLocator(query);
	}

	// global void execute(Database.BatchableContext BC, List<Opportunity> scope) {

	// 	List<String> oppIdList=new List<String>();
	// 	for (Opportunity opp : scope) {
	// 		oppIdList.add(opp.Id);
	// 	}

	// 	List<PCLLostProduct__c> pclLpList=[select id,Quantity__c, LostProduct__r.Name, LostProductMannual__c, PCLLostBrand__r.Lost_By_Company__c, PCLLostBrand__r.Lost_reason_main__c, PCLLostBrand__r.Lost_Reason_Sub__c, PCLLostBrand__r.Lost_By_Company_Mannual__c, PCLLostBrand__r.Agency__r.Name, PCLLostBrand__r.AgencyMannual__c, PCLLostBrand__r.Lost_cancel_report__r.LostType__c, PCLLostBrand__r.Lost_cancel_report__r.LostTotalAmount__c, PCLLostBrand__r.Lost_cancel_report__r.of_lost_system_processor__c,PCLLostBrand__r.Lost_cancel_report__r.Opportunity__c from PCLLostProduct__c where PCLLostBrand__r.Lost_cancel_report__r.Report_Status__c = '批准' and PCLLostBrand__r.Lost_cancel_report__r.Opportunity__c in : oppIdList and LostProduct__c!=null];

	// 	List<Opportunity> oppList=new List<Opportunity>();
	// 	for (String oppId : oppIdList) {

	// 		Opportunity opp=new Opportunity();
	// 		opp.Id=Id.valueOf(oppId); opp.PCLLostBrands__c=''; opp.Agencies__c=''; opp.Lost_Reason_Sub__c='';opp.of_lost_system_processor__c=0;    //Id ,品牌,经销商,原因次
	// 		Integer i=0;
	// 		List<String> ppList=new List<String>(); //品牌List
	// 		List<String> jxsList=new List<String>(); //经销商List


	// 		for (PCLLostProduct__c lp : pclLpList) {
	// 			if (oppId==lp.PCLLostBrand__r.Lost_cancel_report__r.Opportunity__c) {
	// 				if (i==0) {
	// 					opp.LostTypeText__c=lp.PCLLostBrand__r.Lost_cancel_report__r.LostType__c;  //失单类型
	// 					opp.LostPrices__c=lp.PCLLostBrand__r.Lost_cancel_report__r.LostTotalAmount__c; //失单金额
	// 					// opp.of_lost_system_processor__c=lp.PCLLostBrand__r.Lost_cancel_report__r.of_lost_system_processor__c; //失单主机台数(总)
	// 					opp.Lost_reason_main__c=lp.PCLLostBrand__r.Lost_reason_main__c; //失单理由（主）
	// 				}
	// 				opp.of_lost_system_processor__c+=lp.Quantity__c; 	//失单主机台数（累加）
	// 				if (lp.PCLLostBrand__r.Lost_Reason_Sub__c!=null) {
	// 					opp.Lost_Reason_Sub__c=lp.PCLLostBrand__r.Lost_Reason_Sub__c;   //失单理由（次）
	// 				}

	// 				// 失单产品123 start
	// 				if (opp.CompetitorProduct1__c==null) {
	// 					opp.CompetitorProduct1__c=lp.LostProduct__r.Name;
	// 				}else if (opp.CompetitorProduct2__c==null) {
	// 					opp.CompetitorProduct2__c=lp.LostProduct__r.Name;
	// 				}else if (opp.CompetitorProduct3__c==null) {
	// 					opp.CompetitorProduct3__c=lp.LostProduct__r.Name;
	// 				}
	// 				// 失单产品123 end

	// 				//失单品牌 start
	// 				if (!ppList.contains(lp.PCLLostBrand__r.Lost_By_Company__c)) {
	// 					ppList.add(lp.PCLLostBrand__r.Lost_By_Company__c);
	// 					if (ppList.size()==1) {
	// 						if (lp.PCLLostBrand__r.Lost_By_Company__c=='其他') {
	// 							opp.PCLLostBrands__c+=lp.PCLLostBrand__r.Lost_By_Company_Mannual__c;
	// 						}else {
	// 							opp.PCLLostBrands__c+=lp.PCLLostBrand__r.Lost_By_Company__c;
	// 						}
	// 					}else {
	// 						if (lp.PCLLostBrand__r.Lost_By_Company__c=='其他') {
	// 							opp.PCLLostBrands__c+=','+lp.PCLLostBrand__r.Lost_By_Company_Mannual__c;
	// 						}else {
	// 							opp.PCLLostBrands__c+=','+lp.PCLLostBrand__r.Lost_By_Company__c;
	// 						}
	// 					}
	// 				}
	// 				//失单品牌 end

	// 				//经销商 start
	// 				if (!jxsList.contains(lp.PCLLostBrand__r.Agency__r.Name)) {
	// 					jxsList.add(lp.PCLLostBrand__r.Agency__r.Name);
	// 					if (jxsList.size()==1) {
	// 						if (lp.PCLLostBrand__r.AgencyMannual__c==null) {
	// 							opp.Agencies__c+=lp.PCLLostBrand__r.Agency__r.Name;
	// 						}else {
	// 							opp.Agencies__c+=lp.PCLLostBrand__r.AgencyMannual__c;
	// 						}
	// 					}else {
	// 						if (lp.PCLLostBrand__r.AgencyMannual__c==null) {
	// 							opp.Agencies__c+='，'+lp.PCLLostBrand__r.Agency__r.Name;
	// 						}else {
	// 							opp.Agencies__c+='，'+lp.PCLLostBrand__r.AgencyMannual__c;
	// 						}
	// 					}
	// 				}
	// 				//经销商 end
	// 				i++;
	// 			}
	// 		}
	// 		oppList.add(opp);
	// 		system.debug('opp等于'+opp);
	// 	}
	// 	system.debug('oppList等于'+oppList);
	// 	update oppList;
	// }

	// 2022-01-18 修改 从失单报告取值
	global void execute(Database.BatchableContext BC, List<Lost_cancel_report__c> scope) {
		
		// List<String> reportIdList=new List<String>();//20230215 lt DB202302247719 注释
		Set<String> oppIdList = new Set<String>();//20230215 lt DB202302247719 

		for (Lost_cancel_report__c report : scope) {
			// reportIdList.add(report.Id);   //20230215 lt DB202302247719 注释
			oppIdList.add(report.Opportunity__c);      //20230215 lt DB202302247719
		}

		//DB202302247719 注释  lt  注释原因：DB202302247719课题刷失单报告数据只刷失单金额
		// List<PCLLostProduct__c> pclLpList=[select 
		// 									id,                                                                  // 失单型号id
		// 									Quantity__c,                                                         // 失单数量
		// 									LostProductName__c,                                                  // 失单对手型号
		// 									LostProductMannual__c,                                               // 失单对手型号（手动）
		// 									PCLLostBrand__r.Lost_By_Company__c,                                  // 失单品牌
		// 									PCLLostBrand__r.Lost_reason_main__c,                                 // 失单原因（主）
		// 									PCLLostBrand__r.Lost_Reason_Sub__c,                                  // 失单原因（次）
		// 									PCLLostBrand__r.Lost_By_Company_Mannual__c,                          // 失单品牌（手动）
		// 									PCLLostBrand__r.Agency__r.Name,                                      // 中标经销商
		// 									PCLLostBrand__r.AgencyMannual__c,                                    // 中标经销商（手动）
		// 									PCLLostBrand__r.Lost_cancel_report__r.LostType__c,                   // 失单类型
		// 									PCLLostBrand__r.Lost_cancel_report__r.LostTotalAmount__c,            // 失单总金额
		// 									PCLLostBrand__r.Lost_cancel_report__r.TotalAmountLost__c,  			// 失单总金额（不含税）  //20230215 lt DB202302247719
		// 									PCLLostBrand__r.Lost_cancel_report__r.of_lost_system_processor__c,   // 失单主机台数
		// 									PCLLostBrand__r.Lost_cancel_report__r.Opportunity__c 
		// 								from 
		// 									PCLLostProduct__c 
		// 								where 
		// 								PCLLostBrand__r.Lost_cancel_report__r.Opportunity__c in :reportIdList];
										//20230215 lt DB202302247719   PCLLostBrand__r.Lost_cancel_report__c  ---update---  PCLLostBrand__r.Lost_cancel_report__r.Opportunity__c

		List<Lost_cancel_report__c> lcrList = [SELECT Id, Opportunity__c, TotalAmountLost__c
											   FROM Lost_cancel_report__c
											   WHERE Opportunity__c in :oppIdList];
		//DB202302247719 注释  lt  注释原因：DB202302247719课题刷失单报告数据只刷失单金额

		//DB202302247719 lt start
		Map<String, Opportunity> opp_map = new Map<String, Opportunity>();

		for (Lost_cancel_report__c lcr : lcrList){
			// 询价id
			String opp_id = lcr.Opportunity__c;

			// 询价
			Opportunity opp = opp_map.get(opp_id);
			if (opp == null) {
				opp = new Opportunity();
				opp.Id = opp_id;
				opp_map.put(opp_id, opp);
			}

			System.debug('---lt123---询价失单金额---'+opp.LostPrices__c);
			System.debug('---lt123---失单总金额，千元不含税---'+lcr.TotalAmountLost__c);
			if(lcr.TotalAmountLost__c != null){
				if(opp.LostPrices__c == null){
					opp.LostPrices__c = 0;
				}
				opp.LostPrices__c += lcr.TotalAmountLost__c;  // 失单金额  
				System.debug('---lt123---累加后询价失单金额---'+opp.LostPrices__c);
			}

		}
		//DB202302247719 lt end
		
		//DB202302247719 注释  lt  注释原因：DB202302247719课题刷失单报告数据只刷失单金额
		// // 初始化保存参数
		// Map<String, Opportunity> opp_map = new Map<String, Opportunity>();
		// Map<String, String> prod_map = new Map<String, String>();
		// Map<String, String> agency_map = new Map<String, String>();

		// // 循环整理数据
		// for (PCLLostProduct__c lost : pclLpList) {
		// 	// 判断是否可用数据
		// 	// if (String.isBlank(lost.LostProductName__c) && String.isBlank(lost.LostProductMannual__c)) {
		// 	// 	continue;
		// 	// }
		// 	// 询价id
		// 	String opp_id = lost.PCLLostBrand__r.Lost_cancel_report__r.Opportunity__c;
		// 	// 询价
		// 	Opportunity opp = opp_map.get(opp_id);
		// 	if (opp == null) {
		// 		opp = new Opportunity();
		// 		opp.Id = opp_id;
		// 		opp.of_lost_system_processor__c = 0;
		// 		opp_map.put(opp_id, opp);
		// 	}

		// 	//20230215 lt DB202302247719 start
		// 	System.debug('---lt123---询价失单金额---'+opp.LostPrices__c);
		// 	System.debug('---lt123---失单总金额，千元不含税---'+lost.PCLLostBrand__r.Lost_cancel_report__r.TotalAmountLost__c);

		// 	if(lost.PCLLostBrand__r.Lost_cancel_report__r.TotalAmountLost__c != null){
		// 		if(opp.LostPrices__c == null){
		// 			opp.LostPrices__c = 0;
		// 		}
		// 		opp.LostPrices__c += lost.PCLLostBrand__r.Lost_cancel_report__r.TotalAmountLost__c;  // 失单金额  
		// 	}
		
		// 	//DB202302247719 注释  lt  注释原因：DB202302247719课题刷失单报告数据只刷失单金额
		// 	// 赋值
		// 	// opp.LostTypeText__c = lost.PCLLostBrand__r.Lost_cancel_report__r.LostType__c;       // 失单类型
		// 	// //opp.LostPrices__c = lost.PCLLostBrand__r.Lost_cancel_report__r.LostTotalAmount__c;  // 失单金额 
		// 	// opp.Lost_reason_main__c = lost.PCLLostBrand__r.Lost_reason_main__c;                 // 失单原因（主）
		// 	// opp.Lost_Reason_Sub__c = lost.PCLLostBrand__r.Lost_Reason_Sub__c;                   // 失单理由（次）
		// 	// opp.of_lost_system_processor__c += lost.Quantity__c; 	                            // 失单主机台数（累加）
			

		// 	// 失单产品123 start
		// 	// if (opp.CompetitorProduct1__c == null) {
		// 	// 	opp.CompetitorProduct1__c = lost_product_name(lost.LostProductName__c, lost.LostProductMannual__c);
		// 	// }else if (opp.CompetitorProduct2__c == null) {
		// 	// 	opp.CompetitorProduct2__c = lost_product_name(lost.LostProductName__c, lost.LostProductMannual__c);
		// 	// }else if (opp.CompetitorProduct3__c == null) {
		// 	// 	opp.CompetitorProduct3__c = lost_product_name(lost.LostProductName__c, lost.LostProductMannual__c);
		// 	// }
		// 	// 失单产品123 end

		// 	// 失单品牌
		// 	// opp.PCLLostBrands__c = lost_brand_name(opp.PCLLostBrands__c, lost.PCLLostBrand__r.Lost_By_Company__c, lost.PCLLostBrand__r.Lost_By_Company_Mannual__c);

		// 	// 中标经销商
		// 	// opp.Agencies__c = lost_agency_name(opp.Agencies__c, lost.PCLLostBrand__r.Agency__r.Name, lost.PCLLostBrand__r.AgencyMannual__c);
		// 	//DB202302247719 注释  lt
		// 	//20230215 lt DB202302247719 end

		// }
		//DB202302247719 注释  lt  注释原因：DB202302247719课题刷失单报告数据只刷失单金额
		System.debug(opp_map);
		StaticParameter.EscapeOppandStaTrigger = true; //20230215 lt DB202302247719
		update opp_map.values();
		StaticParameter.EscapeOppandStaTrigger = true; //20230215 lt DB202302247719
	}

	//DB202302247719 注释  lt  注释原因：DB202302247719课题刷失单报告数据只刷失单金额
	// 失单对手型号
	// private String lost_product_name(String lost_product, String lost_product_mannual) {
	// 	if (String.isBlank(lost_product) && String.isNotBlank(lost_product_mannual)) {
	// 		return lost_product_mannual;
	// 	}
	// 	return lost_product;
	// }

	// // 失单品牌
	// private String lost_brand_name(String lost_brand_in_opp, String lost_brand, String lost_brand_mannual) {
	// 	// 初始化参数
	// 	String plus = '';
	// 	// 判断	
	// 	// SWAG-CCC6F6 2022-04-22 ssm start
	// 	// 询价上都只显示选项列表的值，不需要手动的值
	// 	// if ('其他'.equals(lost_brand) && String.isNotBlank(lost_brand_mannual)) {
	// 	// 	plus = lost_brand_mannual;
	// 	// } else {
	// 	// 	plus = lost_brand;
	// 	// }
	// 	plus = lost_brand;
	// 	// SWAG-CCC6F6 2022-04-22 ssm end
	// 	// 初始化返回值
	// 	if (String.isBlank(lost_brand_in_opp)) {
	// 		lost_brand_in_opp = '';
	// 	}
	// 	// 拼接
	// 	if (String.isNotBlank(plus) && !lost_brand_in_opp.contains(plus)) {
	// 		// 增加分隔标识
	// 		if (String.isNotBlank(lost_brand_in_opp)) {
	// 			lost_brand_in_opp += ',';
	// 		}
	// 		lost_brand_in_opp += plus;
	// 	}
	// 	return lost_brand_in_opp;
	// }

	// // 中标经销商
	// private String lost_agency_name(String lost_agency_in_opp, String lost_agency, String lost_agency_mannual) {
	// 	// 初始化参数
	// 	String plus = '';
	// 	// 判断	
	// 	// SWAG-CCC6F6 2022-04-22 ssm start
	// 	// 询价上都只显示选项列表的值，不需要手动的值
	// 	// if ('对手经销商'.equals(lost_agency) && String.isNotBlank(lost_agency_mannual)) {
	// 	// 	plus = lost_agency_mannual;
	// 	// } else {
	// 	// 	plus = lost_agency;
	// 	// }
	// 	plus = lost_agency;
	// 	// SWAG-CCC6F6 2022-04-22 ssm end
	// 	// 初始化返回值
	// 	if (String.isBlank(lost_agency_in_opp)) {
	// 		lost_agency_in_opp = '';
	// 	}
	// 	// 拼接
	// 	if (String.isNotBlank(plus) && !lost_agency_in_opp.contains(plus)) {
	// 		// 增加分隔标识
	// 		if (String.isNotBlank(lost_agency_in_opp)) {
	// 			lost_agency_in_opp += ',';
	// 		}
	// 		lost_agency_in_opp += plus;
	// 	}
	// 	return lost_agency_in_opp;
	// }
	//DB202302247719 注释  lt  注释原因：DB202302247719课题刷失单报告数据只刷失单金额

	global void finish(Database.BatchableContext BC) {

	}
}


// List<String> IdList=new List<String>{'0061m000003fUz6'};
// Database.executeBatch(new LostCancelReportOppBatch(IdList));

// Database.executeBatch(new LostCancelReportOppBatch());