public class SelectAssetExtension { private String targetHospitalId { get; set; } private String targetContractId { get; set; } // 引数のサービス契約の情報を格納する。 public Maintenance_Contract__c contract { get; set; } // 病院配下の納入機器の情報を格納する。 //public List assetRecords { get; set; }//20191220 modify //public static List assetRecords = new List(); public List> assetLists { get; set; } // zzm 20231026 start private static integer MAX_RECORD_NUM = 500; //SelectAssetExtension.cls // zzm 20231026 end public Integer getProductCount() { //return this.assetRecords.size(); Integer listSize = assetLists.size(); Integer pCount = 0; if (listSize > 0) { for (Integer i = 0; i < listSize; i++) { List aList = assetLists.get(i); pCount += aList.size(); } } return pCount; } // 選択済みの納入機器の public List selectedAsset { get; set; } public List selectedAsset2 { get; set; } //public List selectedAsset2{ get; set; } public String sortKey { get; set; } public String preSortKey { get; set; } public Boolean sortOrderAsc { get; set; } public String[] sortOrder { get; set; } public String[] columus = new String[] { 'asset.name', 'asset.SerialNumber', 'asset.Department_Name__c', 'asset.Installation_Site__c', 'asset.Posting_Date__c', 'asset.Asset_Owner__c' }; //zzm 230831增加检索条件解决数据超量报错的问题 start public static List textOpts { get; private set; } static { textOpts = new List(); // textOpts.add(new SelectOption('S:AssetMark__c', '主机/耗材')); textOpts.add(new SelectOption('S:Name', Schema.SObjectType.Asset.fields.Name.label)); textOpts.add(new SelectOption('S:SerialNumber', Schema.SObjectType.Asset.fields.SerialNumber.label)); // textOpts.add(new SelectOption('S:CurrentContract__r.Management_Code__c', Schema.SObjectType.Asset.fields.CurrentContract__c.label)); textOpts.add(new SelectOption('S:Installation_Site__c', Schema.SObjectType.Asset.fields.Installation_Site__c.label)); textOpts.add(new SelectOption('S:Department_Name__c', Schema.SObjectType.Asset.fields.Department_Name__c.label)); } public static List equalOpts { get; private set; } static { equalOpts = new List(); equalOpts.add(new SelectOption('equals', '等于')); equalOpts.add(new SelectOption('contains', '包含')); equalOpts.add(new SelectOption('notequals', '不等于')); } public String text1 { get; set; } // 对象 public String cond1 { get; set; } // 条件 public String val1 { get; set; } //zzm 230831增加检索条件解决数据超量报错的问题 end public void init() { List assetRecords = new List();//20191220 add //zzm 230831增加检索条件解决数据超量报错的问题 start List selectAssetRecords = new List(); List notSelectedAssetRecords = new List(); //zzm 230831增加检索条件解决数据超量报错的问题 end // サービス契約の情報を取得 try { this.contract = [SELECT Id, Name, Management_Code__c, Hospital__c, Contract_Start_Date__c, Contract_End_Date__c FROM Maintenance_Contract__c WHERE Id = :this.targetContractId][0]; this.targetHospitalId = this.contract.Hospital__c; } catch ( System.ListException le) { this.contract = new Maintenance_Contract__c(); } // 納入機器の情報を取得 if ( this.targetHospitalId == null || ( this.targetHospitalId.length() != 15 && this.targetHospitalId.length() != 18)) { system.debug('assetRecords123456789==' + assetRecords); } else { // HWAG-BHD66X start //zzm 230831增加检索条件解决数据超量报错的问题 start /*assetRecords = [SELECT Id, Name, CheckBox__c, SerialNumber,TransferToOther__c , Department_Name__c, Installation_Site__c, Posting_Date__c, Asset_Owner__c, Product2Id // Gzw 20200826 保存上一期合同临时用 start , Remarks__c,MDM_Model_No__c // Gzw 20200826 保存上一期合同临时用 end // fxk 2021/9/17 点检对象临时用 star // , Freeze_sign__c // fxk 2021/9/17 点检对象临时用 end FROM Asset WHERE Hospital__c = :this.targetHospitalId // XLIU-CK46FR zyh start AND Status != '廃棄' AND Status != '待报废' AND (Competitor_Name__c = '奥林巴斯' OR Competitor_Name__c = '' OR Competitor_Name__c = '其他') AND Category1__c != 'ET' AND (Category1__c != 'SP' OR Category2__c != '附属品' ) AND (Category1__c != 'GI' OR Category2__c != '附属品' OR Category4__c != 'OER' ) AND (Category1__c != 'GI' OR Category2__c != '其他' ) AND (Category1__c != 'ENG' OR Category2__c != '附属品' ) AND (Category1__c != 'ENG' OR Category2__c != '耗材' ) // AND (Category1__c != 'SP' OR Category2__c != '附属品' ) // AND (Category1__c != 'GI' OR (Category2__c != '附属品' OR Category2__c != '其他') ) // AND (Category1__c != 'ENG' OR (Category2__c != '附属品' OR Category2__c != '耗材') ) // AND AssetMark__c != '耗材' // XLIU-CK46FR zyh end AND ( AssetMark__c != '耗材' OR Product2.Family != 'ET' ) ORDER BY Department_Name__c, Posting_Date__c, SerialNumber ];*/ String sqlStr = this.makeSoqlconfim(); sqlStr += ' and id in (SELECT Asset__c FROM Maintenance_Contract_Asset__c WHERE Maintenance_Contract__c =\'' + this.targetContractId + '\') '; // if (String.isNotBlank(text1) && String.isNotBlank(cond1) && String.isNotBlank(val1)) { // sqlStr += makeTextSql(text1, cond1, val1); // } sqlStr += ' ORDER BY Department_Name__c, Posting_Date__c, SerialNumber'; selectAssetRecords = Database.query(sqlstr); integer assetSize = selectAssetRecords.size(); integer limitNum = MAX_RECORD_NUM - assetSize; String notSelectedAssetSql = this.makeSoqlconfim(); notSelectedAssetSql += ' and id not in (SELECT Asset__c FROM Maintenance_Contract_Asset__c WHERE Maintenance_Contract__c =\'' + this.targetContractId + '\') '; notSelectedAssetSql += ' ORDER BY Department_Name__c, Posting_Date__c, SerialNumber '; notSelectedAssetSql += ' limit :limitNum'; notSelectedAssetRecords = Database.query(notSelectedAssetSql); assetRecords.addAll(selectAssetRecords); assetRecords.addAll(notSelectedAssetRecords); system.debug('assetRecords123456789' + assetRecords.size()); } assetRecords = this.markAsset(assetRecords); /* // 選択済みの納入機器情報を取得 this.selectedAsset = [SELECT Id, Name, Check_object__c, Maintenance_Contract__c, LastMContract__c, Asset__c FROM Maintenance_Contract_Asset__c WHERE Maintenance_Contract__c = :this.targetContractId]; system.debug('selectedAsset==========>'+selectedAsset); //Maintenance_Contract_Asset_Estimate__c this.selectedAsset2 = [SELECT Id, Name,Product_Manual__c,Product_Manual__r.MDM_Model_No__c, Check_object__c,Maintenance_Contract_Estimate__r.Maintenance_Contract__c,Asset__c,Asset__r.product2Id FROM Maintenance_Contract_Asset_Estimate__c WHERE Maintenance_Contract_Estimate__r.Maintenance_Contract__c = :this.targetContractId]; system.debug('selectedAsset2==========>'+selectedAsset2); //SELECT Id, Name, Check_object__c, Asset__c FROM Maintenance_Contract_Asset_Estimate__c WHERE Maintenance_Contract_Estimate__r.Maintenance_Contract__c = 'a0H1m000002shhL' // 選択済みのものにチェックを付ける Boolean selected = false; for ( Asset local : assetRecords) { selected = false; local.Remarks__c = null; local.TransferToOther__c = null; // local.Freeze_sign__c = false; for ( Maintenance_Contract_Asset__c selectedLocal : this.selectedAsset) { if ( local.Id == selectedLocal.Asset__c) { local.CheckBox__c = true; local.Remarks__c = selectedLocal.LastMContract__c; local.TransferToOther__c = selectedLocal.Check_object__c; //占用一个复选框字段用于展示“点检对象” // fxk 2021/9/17 点检对象临时用 star // local.Freeze_sign__c = selectedLocal.Check_object__c; // fxk 2021/9/17 点检对象临时用 end selected = true; break; } } for(Maintenance_Contract_Asset_Estimate__c selectedLocal : this.selectedAsset2){ if(local.MDM_Model_No__c == selectedLocal.Product_Manual__r.MDM_Model_No__c){ //local.TransferToOther__c = true; local.TransferToOther__c = selectedLocal.Check_object__c; system.debug('TransferToOther__c============>'+local.TransferToOther__c); } } if ( selected == true) { continue; } } // List assetRecordsv = new List(); // for(Asset local : assetRecords){ // local.Internal_Asset_photo__c = false; // for(Maintenance_Contract_Asset_Estimate__c equipment : this.selectedAsset2){ // if(local.Id == equipment.Maintenance_Contract_Estimate__r.Maintenance_Contract__c){ // local.Internal_Asset_photo__c = equipment.Check_object__c; // } // } // assetRecordsv.add(local); // } */ //zzm 230831增加检索条件解决数据超量报错的问题 end this.sortKey = '0'; this.preSortKey = '0'; this.sortOrderAsc = true; this.sortOrder = new String[6]; this.sortOrder = new String[] { '↓', '　', '　', '　', '　', '　',' '}; this.cutListSize(assetRecords); } //private void cutListSize() {//20191220 modify private void cutListSize(List assetRecordsv) { this.assetLists = new List>(); List tempList = new List(); //for (Integer i = 0; i < this.assetRecords.size(); i++) {//20191220 modify for (Integer i = 0; i < assetRecordsv.size(); i++) { //Asset a = this.assetRecords.get(i);//20191220 modify Asset a = assetRecordsv.get(i); if (Math.mod(i, 1000) == 0) { if ( tempList.size() > 0) { assetLists.add(tempList); } tempList = new List(); } tempList.add(a); } if (tempList.size() > 0) { this.assetLists.add(tempList); } //this.assetRecords.clear()//20191220 modify assetRecordsv.clear(); } //private void mergeList() {//20191220 modify private List mergeList() { List assetRecords = new List();//20191220 add Integer listSize = this.assetLists.size(); if (listSize == 1) { assetRecords.addAll(this.assetLists.get(0)); } else { for (Integer i = 0; i < listSize; i++) { assetRecords.addAll(this.assetLists.get(i)); } } return assetRecords;//20191220 add } /** * Visaulforceから呼ばれるコンストラクタです。 */ public SelectAssetExtension( ApexPages.StandardController controller) { this.targetContractId = (String)(ApexPages.currentPage().getParameters().get( 'targetContractId')); this.init(); } /** * 保存メソッドです。 */ public void save() { //20231026 zzm // Map mCAssetEstMap = new Map(); // List mCAssetEstList = [select Id, Check_Object__c, Maintenance_Contract_Estimate__c, Product_Manual__r.Name // from Maintenance_Contract_Asset_Estimate__c // where Check_Object__c = true and Maintenance_Contract_Estimate__r.Estimation_Decision__c = true // and Maintenance_Contract_Estimate__r.Maintenance_Contract__c =: targetContractId ]; // for(Maintenance_Contract_Asset_Estimate__c mCAssetEstinfo : mCAssetEstList){ // mCAssetEstMap.put(mCAssetEstinfo.Product_Manual__r.Name, mCAssetEstinfo.Check_Object__c); // } //this.mergeList();//20191220 modify List assetRecords = new List();//20191220 add assetRecords = this.mergeList(); List insertTarget = new List(); Maintenance_Contract_Asset__c target = null; for ( Asset input : assetRecords) { if ( input.CheckBox__c == true) { target = new Maintenance_Contract_Asset__c(); target.Maintenance_Contract__c = this.targetContractId; target.Asset__c = input.Id; target.LastMContract__c = input.Remarks__c; target.Check_object__c = input.TransferToOther__c; // fxk 2021/9/17 点检对象临时用 star // target.Check_object__c = input.Freeze_sign__c; // fxk 2021/9/17 点检对象临时用 end insertTarget.add( target); } } // delete and insertする if ( this.selectedAsset.size() > 0) { delete selectedAsset; } if ( insertTarget.size() > 0) { insert insertTarget; } // system.debug('insertTarget=============>'+insertTarget); system.debug('insertTarget.size=============>'+insertTarget.size()); //zzm 20231026 // return null; // return cancel(); //zzm 20231026 } /** * キャンセルメソッドです。 */ public PageReference cancel() { PageReference ret = null; if ( this.targetContractId != null) { ret = new PageReference( '/' + this.targetContractId); // zzm 20231026 start ret.setRedirect(true); // ret.setRedirectCode(301); // aura.redirect(ret); system.debug('已进入'); }else{ system.debug('未进入'); // zzm 20231026 end } return ret; } /** * ソートメソッドです。 */ public void sortTable() { System.debug( '-----:sortTable start!!'); //this.mergeList();//20191220 modify List assetRecords = new List();//20191220 add assetRecords = this.mergeList(); // check済み退避 List checkedAssets = new List(); for ( Asset local : assetRecords) { if ( local.checkBox__c == true) { checkedAssets.add( local); } } if ( this.sortKey == this.preSortKey) { // 方向が変わるのみ this.sortOrderAsc = !this.sortOrderAsc; this.sortOrder[Integer.valueOf( this.sortKey)] = ( this.sortOrderAsc == true ? '↓' : '↑'); } else { this.sortOrderAsc = true; this.sortOrder[Integer.valueOf( this.preSortKey)] = '　'; this.sortOrder[Integer.valueOf( this.sortKey)] = ( this.sortOrderAsc == true ? '↓' : '↑'); } this.preSortKey = this.sortKey; // HWAG-BHD66X start string sqlstr = 'SELECT Id, Name, CheckBox__c,' + 'SerialNumber, Department_Name__c, ' + ' Installation_Site__c, Posting_Date__c, ' + 'Asset_Owner__c FROM Asset WHERE Hospital__c = \'' + this.targetHospitalId + '\' AND ( AssetMark__c != \'耗材\' OR Product2.Family != \'ET\' )' + ' ORDER BY ' + this.columus[Integer.valueOf(this.sortKey)] + ' ' + (this.sortOrderAsc == true ? 'ASC NULLS FIRST' : 'DESC NULLS LAST'); System.debug(sqlstr); assetRecords = Database.query(sqlstr); // HWAG-BHD66X end // 選択済みのものにチェックを付ける Boolean selected = false; for ( Asset local : assetRecords) { selected = false; local.Remarks__c = null; for ( Asset selectedLocal : checkedAssets) { if ( local.Id == selectedLocal.Id) { local.CheckBox__c = true; local.Remarks__c = selectedLocal.Remarks__c; selected = true; break; } } if ( selected == true) { continue; } } this.cutListSize(assetRecords); System.debug( '-----:sortTable end!!'); } //zzm 230831增加检索条件解决数据超量报错的问题 start // 检索按钮 public PageReference searchBtn() { List assetRecords = new List();//20191220 add assetRecords = this.mergeList(); List selectedIds = new List(); List insertTarget = new List(); Maintenance_Contract_Asset__c target = null; for ( Asset input : assetRecords) { if ( input.CheckBox__c == true) { insertTarget.add(input); selectedIds.add(input.Id); } } Integer limitNum = MAX_RECORD_NUM - insertTarget.size(); List seachAssetRecords = new List(); String seachAssetSql = this.makeSoqlconfim(); seachAssetSql += ' and id not in : selectedIds'; if (String.isNotBlank(text1) && String.isNotBlank(cond1) && String.isNotBlank(val1)) { seachAssetSql += makeTextSql(text1, cond1, val1); } seachAssetSql += ' ORDER BY Department_Name__c, Posting_Date__c, SerialNumber '; seachAssetSql += ' limit :limitNum '; seachAssetRecords = Database.query(seachAssetSql); assetRecords = new List(); assetRecords.addAll(insertTarget); assetRecords.addAll(this.markAsset(seachAssetRecords)); this.cutListSize(assetRecords); return null; } //检索验证 // private List getAssetconfim(String txt, String con, String val) { // String soql = this.makeSoqlconfim(); // soql += makeTextSql(txt, con, val); // // system.debug('makeTextSql_soql' + soql); // // if (isSoft) { // // soql += ' order by ' + this.columus[Integer.valueOf(this.sortKey)] + ' ' + (this.sortOrderAsc == true ? 'asc nulls first' : 'desc nulls last '); // // } else { // // soql += ' order by SerialNumber, Name, Department_Name__c, InstallDate'; // // } // // system.debug('====getAssetconfim:' + soql); // return Database.query(soql); // } // private List getAsset(String txt, String con, String val) { // String soql = this.makeSoqlconfim(); // soql += makeTextSql(txt, con, val); // // if (isSoft) { // // soql += ' order by ' + this.columus[Integer.valueOf(this.sortKey)] + ' ' + (this.sortOrderAsc == true ? 'asc nulls first' : 'desc nulls last '); // // } else { // // soql += ' order by SerialNumber, Name, Department_Name__c, InstallDate'; // // } // // soql += ' limit ' + System.Label.Asset_Maxcount; // // soql += ' OFFSET ' + (countorder - 1) * Integer.valueOf(System.Label.Asset_Maxcount); // return Database.query(soql); // } private String makeSoqlconfim() { String sqlStr = 'SELECT Id, Name, CheckBox__c, SerialNumber,TransferToOther__c,' + 'Department_Name__c, Installation_Site__c, Posting_Date__c,' + 'Asset_Owner__c, Product2Id' +', Remarks__c,MDM_Model_No__c,Product2.Asset_Model_No__c' +' FROM Asset' +' WHERE Hospital__c =\'' + this.targetHospitalId + '\' ' +' AND Status != \'廃棄\'' +' AND Status != \'待报废 \'' +' AND (Competitor_Name__c = \'奥林巴斯\' OR Competitor_Name__c = \'\' OR Competitor_Name__c = \'其他\')' +' AND Category1__c != \'ET \'' +' AND (Category1__c != \'SP\' OR Category2__c != \'附属品\' )' +' AND (Category1__c != \'GI\' OR Category2__c != \'附属品\' OR Category4__c != \'OER\' )' +' AND (Category1__c != \'GI\' OR Category2__c != \'其他\' )' +' AND (Category1__c != \'ENG\' OR Category2__c != \'附属品\' )' +' AND (Category1__c != \'ENG\' OR Category2__c != \'耗材\' )' +' AND ( AssetMark__c != \'耗材\' OR Product2.Family != \'ET\' ) ' ; return sqlstr; } // 拼接检索条件sql文 private String makeTextSql(String txt1, String con, String val) { String soql = ''; if (String.isBlank(con)) { con = 'equals'; } // containsの場合、日報画面の病院検索を真似し、spaceで分けて、and検索 // equalsの場合、SF標準の検索を真似し、「,」で分けて、or検索 if (!String.isBlank(txt1)) { if ((con == 'contains' || con == 'notcontains') && val.contains(' ')) { String[] vals = val.split(' '); String cSql = ''; if (vals.size() > 0) { String txt = txt1.substring(2); soql += ' and ( '; for (String v : vals) { if (String.isNotBlank(v)) { if (con == 'contains') { soql += txt + ' like \'%' + v + '%\' or '; } else { soql += txt + ' not like \'%' + v + '%\' and '; } } } soql = soql.substring(0, soql.length() - 4); soql += ')'; } system.debug('containssoql: ' + soql); } else if ((con == 'equals' || con == 'notequals') && val.contains(',')) { String[] vals = val.split(','); if (vals.size() > 0) { String txt = txt1.substring(2); // S:Name 、最初の２文字がタイプです soql += ' and ( '; for (String v : vals) { if (con == 'equals') { soql += txt + ' = \'' + v + '\' or '; } else { // notequals soql += txt + ' <> \'' + v + '\' and '; } } soql = soql.substring(0, soql.length() - 4); soql += ')'; } } else { String cSql = this.makeTextSqlStr(txt1, con, val); if (con != 'notcontains') { soql += this.makeTextSqlStr(txt1, con, val); } else { // notcontains if (!String.isBlank(cSql)) { cSql = cSql.substring(5); // ' and ' の5文字を外す soql += ' and (NOT ' + cSql + ') '; } } } } // //JZHG-BSDUT4 ---20200825---update By rentongxiao---Start // else{ // soql += 'And AssetMark__c = \'主机\''; // } // //JZHG-BSDUT4 ---20200825---update By rentongxiao---End return soql; } private String makeTextSqlStr(String txt1, String con, String val) { String soql = ''; if (!String.isBlank(txt1)) { String txt = txt1.substring(2); String colType = txt1.substring(0, 2); String tmpVal = val.trim(); // 空白の場合''にする if (String.isBlank(tmpVal)) { if (con == 'equals') { //soql += ' and ' + txt + ' = ' + tmpVal; soql += ' and ' + txt + ' = null'; } else if (con == 'notequals') { soql += ' and ' + txt + ' <> null'; } else { // 空白の場合、contains, notcontains と starts withは無視 } } else { soql += ' and ' + txt; if (con == 'equals') { if (colType == 'S:') { soql += ' = \'' + tmpVal + '\''; } else { soql += ' = ' + tmpVal + ' '; } } else if (con == 'notequals') { if (colType == 'S:') { soql += ' <> \'' + tmpVal + '\''; } else { soql += ' <> ' + tmpVal + ' '; } } else if (con == 'contains' || con == 'notcontains') { soql += ' like \'%' + String.escapeSingleQuotes(tmpVal.replaceAll('%', '\\%')) + '%\''; } else if (con == 'starts with') { soql += ' like \'' + String.escapeSingleQuotes(tmpVal.replaceAll('%', '\\%')) + '%\''; } else { if (colType == 'S:') { soql += ' ' + con + '\'' + tmpVal + '\''; } else { soql += ' ' + con + ' ' + tmpVal + ' '; } } } } return soql; } private List markAsset(List allAsset) { // 選択済みの納入機器情報を取得 this.selectedAsset = [SELECT Id, Name, Check_object__c, Maintenance_Contract__c, LastMContract__c, Asset__c FROM Maintenance_Contract_Asset__c WHERE Maintenance_Contract__c = :this.targetContractId]; system.debug('selectedAsset==========>'+selectedAsset); //Maintenance_Contract_Asset_Estimate__c this.selectedAsset2 = [SELECT Id, Name,Product_Manual__c,Product_Manual__r.MDM_Model_No__c,Product_Manual__r.Asset_Model_No__c, Check_object__c,Maintenance_Contract_Estimate__r.Maintenance_Contract__c,Asset__c,Asset__r.product2Id FROM Maintenance_Contract_Asset_Estimate__c WHERE Maintenance_Contract_Estimate__r.Maintenance_Contract__c = :this.targetContractId]; system.debug('selectedAsset2==========>'+selectedAsset2); //SELECT Id, Name, Check_object__c, Asset__c FROM Maintenance_Contract_Asset_Estimate__c WHERE Maintenance_Contract_Estimate__r.Maintenance_Contract__c = 'a0H1m000002shhL' // 選択済みのものにチェックを付ける Boolean selected = false; for ( Asset local : allAsset) { selected = false; local.Remarks__c = null; local.TransferToOther__c = null; // local.Freeze_sign__c = false; for ( Maintenance_Contract_Asset__c selectedLocal : this.selectedAsset) { if ( local.Id == selectedLocal.Asset__c) { local.CheckBox__c = true; local.Remarks__c = selectedLocal.LastMContract__c; local.TransferToOther__c = selectedLocal.Check_object__c; //占用一个复选框字段用于展示“点检对象” // fxk 2021/9/17 点检对象临时用 star // local.Freeze_sign__c = selectedLocal.Check_object__c; // fxk 2021/9/17 点检对象临时用 end selected = true; break; } } for(Maintenance_Contract_Asset_Estimate__c selectedLocal : this.selectedAsset2){ if(local.MDM_Model_No__c == selectedLocal.Product_Manual__r.MDM_Model_No__c){ //local.TransferToOther__c = true; local.TransferToOther__c = selectedLocal.Check_object__c; system.debug('TransferToOther__c============>'+local.TransferToOther__c); //zzm 230908 start MDM_Model_No__c 匹配不上的话，再用Asset_Model_No__c 匹配一下 } else if(local.Product2.Asset_Model_No__c == selectedLocal.Product_Manual__r.Asset_Model_No__c){ local.TransferToOther__c = selectedLocal.Check_object__c; } //zzm 230908 end MDM_Model_No__c 匹配不上的话，再用Asset_Model_No__c 匹配一下 } if ( selected == true) { continue; } } return allAsset; } //zzm 230831增加检索条件解决数据超量报错的问题 end }