@RestResource(urlMapping = '/SBG204/*') global with sharing class SBG204Rest { global class GeDatas { public NFMUtil.Monitoring Monitoring; public GeData[] GeData; } global class GeData { public String MaterialNo; //物料号 public String RegisterNo; //注册证号 public String RegisterNoClass_New; //注册证号经营范围编号(新) public String RegisterNoClass_Old; //注册证号经营范围编号(旧) public String ValidFrom; //注册证号效期从 public String ValidTo; //注册证号效期至 public String MedPrdClass; //医疗器械分类 public String EffectDate; //系统维护日 public String Model; //产品型号 public String ProductName; //产品名称(委托产品名称) public String PrdCompanyLicense; //生产企业许可证号/备案凭证号 public String PrdCompanyAddr; //生产企业地址 public String ClinicalCode; //型号规格 public String REG_Name; // 注册人名称 public String REG_ADD; // 注册人住所 public String AuthorizedCompany; //委托方企业名称 public String ApprovedDate; //委托批准日期 public String Z3PLAuthorized; //是否3PL委托产品 public String AuthorizedCompany_SH; public String ApprovedDate_SH; public String YXQX; public String Other1; public String Other2; public String Other3; public String MaterialGroup; //物料组 public String MaterialStatus; //物料状态 public String RegisterNoStatus; //注册证号状态 public String Unit; //单位(基本单位) public String StroageCondition; //储存条件 public String TransCondition; //运输条件 public String Z3PLAuthorizedNo; //3PL业务委托协议号 public String PrdValidFrom; //委托产品效期从 public String PrdValidTo; //委托产品效期至 public String BusinessScope; //经营范围 public String MaterialStatusType; // 状态 1:只更新物料状态 public String APP_NAME_BJ; // 北京首营审核人 public String APP_DATE_BJ; // 北京审核日期 public String APP_RSLT_BJ; // 北京首营审核结果 public String APP_NAME_SH; // 上海首营审核人 public String APP_DATE_SH; // 上海审核日期 public String APP_RSLT_SH; // 上海首营审核结果 public String APP_NAME_GZ; // 广州首营审核人 public String APP_DATE_GZ; // 广州审核日期 public String APP_RSLT_GZ; // 广州首营审核结果 public String APP_NAME_OSH; // OSH首营审核人 public String APP_DATE_OSH; // OSH审核日期 public String APP_RSLT_OSH; // OSH首营审核结果 public String PROD_ADD; // 生产地址 public String STRU_COM; // 结构及组成 public String ADOPT_RANGE; // 适用范围 } @HttpPost global static void execute() { // 取得接口传输内容 String strData = RestContext.request.requestBody.toString(); GeDatas ges = (GeDatas) JSON.deserializeStrict(strData, GeDatas.class); if (ges == null ) { return; } NFMUtil.Monitoring Monitoring = ges.Monitoring; if (Monitoring == null) { return; } BatchIF_Log__c rowData = NFMUtil.saveRowData(Monitoring, 'SBG204', ges.GeData); if (String.isBlank(rowData.Log__c) == false) { executefuture(rowData.Id); } // JSONを戻す RestResponse res = RestContext.response; res.addHeader('Content-Type', 'application/json'); res.statusCode = 200; String jsonResponse = '{"status": "0", "Message":""}'; res.responseBody = blob.valueOf(jsonResponse); return; } @future global static void executefuture(String rowData_Id) { main(rowData_Id); } global static void main (String rowData_Id) { Integer batch_retry_max_cnt = Integer.valueOf(System.Label.batch_retry_max_cnt); BatchIF_Log__c rowData = [Select Id, Name, Log__c, ErrorLog__c, Log2__c, Log3__c, Log4__c, Log5__c, Log6__c, Log7__c, Log8__c, Log9__c, Log10__c, Log11__c, Log12__c, MessageGroupNumber__c, retry_cnt__c from BatchIF_Log__c where RowDataFlg__c = true and Id = :rowData_Id]; String logstr = rowData.MessageGroupNumber__c + ' start\n'; BatchIF_Log__c iflog = new BatchIF_Log__c(); iflog.Type__c = 'SBG204'; iflog.MessageGroupNumber__c = rowData.MessageGroupNumber__c; iflog.Log__c = logstr; iflog.ErrorLog__c = ''; insert iflog; String groupNumber = rowData.MessageGroupNumber__c; String rowDataStr = NFMUtil.getRowDataStr(rowData); List GeDataList = (List) JSON.deserialize(rowDataStr, List.class); if (GeDataList == null || GeDataList.size() == 0) { return; } Map transferMap = new Map(); List transferList = [select Table__c, Column__c, External_value__c, Internal_value__c from BatchIF_Transfer__c where Dropped_Flag__c = false and (Table__c = 'Product_Register__c' or Table__c = 'Product2')]; for (BatchIF_Transfer__c t : transferList) { transferMap.put(t.Column__c + t.External_value__c, t.Internal_value__c); } Savepoint sp = Database.setSavepoint(); try { List productNoList = new List(); List mD5KeyList = new List(); List registerNoDelList = new List(); List satisfyGeData = new List(); for (GeData data : GeDataList) { //作为产品注册证的唯一标识必须都有值才算正确的产品注册证 if (String.isNotBlank(data.RegisterNo) && String.isNotBlank(data.ValidFrom)) { mD5KeyList.add(MD5Encrypt(data.RegisterNo,data.ValidFrom)); } else { iflog.ErrorLog__c += 'RegisterNo/ValidFrom is required,This data is skipped.\n'; continue; } //产品Code的List if (String.isNotBlank(data.MaterialNo)) { Pattern pattern = Pattern.compile('^[0-9]*$'); Matcher isNum = pattern.matcher(data.MaterialNo); if (isNum.matches()) { data.MaterialNo = data.MaterialNo.leftPad(18, '0'); } productNoList.add(data.MaterialNo); } else { iflog.ErrorLog__c += 'RegisterNo[ ' + data.RegisterNo + ' ] of MaterialNo is required,This data is skipped.\n'; continue; } // 删除注册证关系List if (String.isNotBlank(data.RegisterNo)) { registerNoDelList.add(MD5Encrypt(data.RegisterNo,data.ValidFrom)); } satisfyGeData.add(data); } Map productMap = new Map(); Map registerMap = new Map(); // 产品 List productList = [select id, ProductCode from Product2 where ProductCode = :productNoList]; for (Product2 product : productList) { productMap.put(product.ProductCode, product); } List registerList2 = [select id, Name, MD5EncryptionKey__c from Product_Register__c where MD5EncryptionKey__c = :mD5KeyList]; for (Product_Register__c register : registerList2) { registerMap.put(register.MD5EncryptionKey__c, register); } List prlinkList = new List(); prlinkList = [select id, Product2__c, Product2__r.ProductCode, Product_Register__c, Product_Register__r.Name from Product_Register_Link__c where Product_Register__r.MD5EncryptionKey__c in :registerNoDelList]; Map upd_productMap = new Map(); Map ups_registerMap = new Map(); Map ins_linkMap = new Map(); for (GeData data : satisfyGeData) { Product2 prd = new Product2(); Product_Register__c pr = new Product_Register__c(); if (String.isNotBlank(data.MaterialNo)) { if (productMap.containsKey(data.MaterialNo)) { prd = productMap.get(data.MaterialNo); prd.Product_CCode__c = data.Model; String prdCompanyAddr = data.REG_Name; if (String.isNotBlank(prdCompanyAddr)) { if (prdCompanyAddr.indexOf(';') != -1) { String splitPrdCompanyAddr = prdCompanyAddr.split(';')[0]; prd.Factory__c = splitPrdCompanyAddr.indexOf(':') == -1 ? splitPrdCompanyAddr : splitPrdCompanyAddr.split(':')[1]; } else { prd.Factory__c = prdCompanyAddr; } } else { prd.Factory__c = prdCompanyAddr; } } else { iflog.ErrorLog__c += 'OTCode[' + data.MaterialNo + ']不存在\n'; continue; } upd_productMap.put(data.MaterialNo, prd); logstr += 'Product:' + data.MaterialNo; } if (String.isNotBlank(data.RegisterNo) ) { String mD5key = MD5Encrypt(data.RegisterNo,data.ValidFrom); if (registerMap.containsKey(mD5key)) { pr = registerMap.get(mD5key); } pr.MD5EncryptionKey__c = mD5key; //产品注册证号的唯一标识 pr.Name = data.RegisterNo; //注册证号 pr.IsFromSPO__c = true; pr.RegisterNoClass_New__c = data.RegisterNoClass_New; //注册证号分类编号(新) pr.RegisterNoClass_Old__c = data.RegisterNoClass_Old; //注册证号分类编号(旧) pr.ValidFrom__c = NFMUtil.parseStr2Date(data.ValidFrom); //注册证号效期从 pr.ValidTo__c = NFMUtil.parseStr2Date(data.ValidTo); //注册证号效期至 pr.Stelsedag__c = NFMUtil.parseStr2Date(data.EffectDate); //系统维护日 pr.MedPrdClass__c = data.MedPrdClass; //医疗器械分类 pr.PrdCompanyLicense__c = data.PrdCompanyLicense; //生产企业许可证号/备案凭证号 pr.PrdCompanyAddr__c = data.PrdCompanyAddr; //生产企业地址 pr.ClinicalProductCode__c = data.ClinicalCode; //型号规格 pr.RegistrantName__c = data.REG_Name ; // 注册人名称 pr.RegistrantResidence__c = data.REG_ADD ; // 注册人住所 ups_registerMap.put(data.RegisterNo, pr); logstr += ' Register:' + data.RegisterNo + '\n'; } } if (upd_productMap.keySet().size() > 0) update upd_productMap.values(); if (ups_registerMap.keySet().size() > 0) upsert ups_registerMap.values(); // 删除注册证号下所有物料 List delList = new List(); for (Product_Register_Link__c prlc : prlinkList) { delList.add(prlc); } if (delList.size() > 0 ) delete delList; // 取得所有注册证ID registerList2 = [select id, Name, MD5EncryptionKey__c from Product_Register__c where MD5EncryptionKey__c = :mD5KeyList]; for (Product_Register__c register : registerList2) { registerMap.put(register.MD5EncryptionKey__c, register); } // 产品和注册证关系表 for (GeData data : satisfyGeData) { if (!productMap.containsKey(data.MaterialNo)) { // 产品不存在的场合 continue; } String prlink = data.MaterialNo + '_' + data.RegisterNo; Product_Register_Link__c prl = new Product_Register_Link__c(); prl.Product2__c = productMap.get(data.MaterialNo).id; prl.Product_Register__c = registerMap.get(MD5Encrypt(data.RegisterNo,data.ValidFrom)).id; prl.If_Delete__c = false; ins_linkMap.put(prlink, prl); } if (ins_linkMap.keySet().size() > 0) insert ins_linkMap.values(); logstr += '\nend'; rowData.retry_cnt__c = 0; } catch (Exception ex) { // エラーが発生した場合 Database.rollback(sp); System.debug(Logginglevel.ERROR, 'SBG204_' + rowData.MessageGroupNumber__c + ':' + ex.getMessage()); System.debug(Logginglevel.ERROR, 'SBG204_' + rowData.MessageGroupNumber__c + ':' + ex.getStackTraceString()); logstr += '\n' + ex.getMessage(); iflog.ErrorLog__c = ex.getMessage() + '\n' + ex.getStackTraceString() + '\n' + iflog.ErrorLog__c; if (rowData.retry_cnt__c == null) rowData.retry_cnt__c = 0; if (rowData.retry_cnt__c < batch_retry_max_cnt) { rowData.retry_cnt__c++; LogAutoSendSchedule.assignOneMinute(); } if (rowData.retry_cnt__c >= batch_retry_max_cnt) { rowData.ErrorLog__c = ex.getMessage() + '\n' + ex.getStackTraceString() + '\n' + rowData.ErrorLog__c + '错误次数已经超过自动收信设定的最大次数，请手动收信'; } } update rowData; iflog.Log__c = logstr; if (iflog.Log__c.length() > 131072) { iflog.Log__c = iflog.Log__c.subString(0, 131065) + ' ...'; } if (iflog.ErrorLog__c.length() > 32768) { iflog.ErrorLog__c = iflog.ErrorLog__c.subString(0, 32760) + ' ...'; } update iflog; } //将"产品注册证号"与"注册证号效期从"进行MD5加密作为产品注册证的唯一标识 public static String MD5Encrypt(String RegisterNo,String ValidFrom){ if (String.isBlank(RegisterNo) || String.isBlank(ValidFrom)) { return null; } String result = ''; //注册证号效期从 Date startOfDay = NFMUtil.parseStr2Date(ValidFrom); //时间戳 Long timestamp = Datetime.newInstanceGmt(startOfDay.year(), startOfDay.Month(),startOfDay.Day(), 0, 0, 0).getTime(); //MD5转化 String mD5EncryptionKey = EncodingUtil.convertToHex(Crypto.generateDigest('MD5', Blob.valueOf(RegisterNo+timestamp))).toUpperCase(); result = mD5EncryptionKey; return result; } }