public with sharing class BatchSelectRepairPageController { public List RevalInfoList { get; set; } public List RAInfoList { get; set; } public List RepairList { get; set; } public List repairIdList{ get; set; } public Integer RACount { get { return RAInfoList == null ? 0 : RAInfoList.size(); } } public BatchSelectRepairPageController() { } public void init(){ RetrievalData reval = new RetrievalData(); RevalInfoList = new List(); RevalInfoList.add(reval); } public PageReference RetrievalBtn() { RepairList = new List(); RAInfoList = new List(); String sql; System.debug('RevalInfoList1:' + RevalInfoList); for(RetrievalData reval : RevalInfoList){ if(String.isBlank(reval.Status2) && String.isBlank(reval.RepairName) && String.isBlank(reval.SAPRepairNo) && String.isBlank(reval.SerialNumber) && String.isBlank(reval.repair.Incharge_Staff__c) && String.isBlank(String.valueOf(reval.repair.Final_complete_day__c))){ ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO, '请至少添加一个检索条件!')); return null; } sql += 'select Id, Name, SAP_Service_Repair_No__c, Status1__c, Status2__c, Delivered_Product__c, SerialNumber__c, '; sql += 'HP_Name__c, State_Hospital__c, Incharge_Staff__c, FSE_ApplyForRepair_Day__c, work_location_select__c, On_site_repair__c,'; sql += 'Number_of_EffectiveContract__c, NewProductGuaranteeObject__c from Repair__c where Id != null '; if(String.isNotBlank(reval.Status2)){ sql += ' and Status2__c like \'%' + reval.Status2 + '%\' '; } if(String.isNotBlank(reval.RepairName)){ sql += ' and Name like \'%' + reval.RepairName + '%\' '; } if(String.isNotBlank(reval.SAPRepairNo)){ sql += ' and SAP_Service_Repair_No__c like \'%' + reval.SAPRepairNo + '%\' '; } if(String.isNotBlank(reval.SerialNumber)){ sql += ' and SerialNumber__c like \'%' + reval.SerialNumber + '%\' '; } if(String.isNotBlank(reval.repair.Incharge_Staff__c)){ sql += ' and Incharge_Staff__c = \'' + reval.repair.Incharge_Staff__c + '\' '; } if(String.isNotBlank(String.valueof(reval.repair.Final_complete_day__c))){ String day = String.valueof(reval.repair.Final_complete_day__c); day = day.substring(0,10); sql += ' and FSE_ApplyForRepair_Day__c = ' + day; } sql += ' limit 200'; sql = sql.substring(4); } System.debug('sql1:' + sql); if(String.isNotBlank(sql)){ RepairList = Database.query(sql); } if(RepairList.size() >= 200 ){ ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, '检索数据太多,请缩小检索范围')); return null; } if(RepairList.size() <= 0 ){ ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO, '没检索到任何修理')); return null; } for(Repair__c ra : RepairList){ RepairData raData = new RepairData(ra); RAInfoList.add(raData); } return null; } public PageReference showPDF() { repairIdList = new List(); RepairList = new List(); String url = '='; if(RAInfoList == null){ ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO, '请先检索修理')); return null; } for(RepairData rd : RAInfoList) { if(rd.IFCheck){ repairIdList.add(rd.repair.Id); RepairList.add(rd.repair); } } if(repairIdList.size() > 0){ if(repairIdList.size() <= 50){ if(RepairList.size() > 0){ generateAttachment(RepairList); } for(String Id : repairIdList){ url += Id + '='; } url = url.substring(0, url.lastIndexOf('=')); PageReference pageRef = new PageReference('/apex/MaintenanceCommissionPDF?id' + url); pageRef.setRedirect(true); return pageRef; } else{ ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, '多单打印最大数量为50,请选择少于50个修理!')); return null; } } else{ ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO, '请至少选择一个修理')); return null; } } // 生成pdf添加到对应的修理中 public static PageReference generateAttachment(List repList){ PageReference pdfPage; List attachments = new List(); for(Repair__c re : repList){ pdfPage = new PageReference('/apex/MaintenanceCommissionPDF?id=' + re.Id); Blob pdfBody; if(Test.isRunningTest()) { pdfBody = blob.valueOf('Unit.Test'); } else { pdfBody = pdfPage.getContentAsPDF(); } Attachment attach = new Attachment(); attach.Body = pdfBody; attach.Name = re.name + '_' + 'MaintenanceCommission.pdf'; attach.ParentId = re.id; attachments.add(attach); } insert attachments; return null; } public class RetrievalData { public String Status2{ get; set; } public String RepairName{ get; set; } public String SAPRepairNo{ get; set; } public String SerialNumber{ get; set; } // public String FSE_ApplyForRepair_Day{ get; set; } // public String InchargeStaffName{ get; set; } public Repair__c repair{ get; set; } public RetrievalData(){ repair = new Repair__c(); } } public class RepairData { public Boolean IFCheck { get; set; } public Repair__c repair { get; set; } public RepairData(Repair__c RepairInfo){ IFCheck = null; repair = RepairInfo; } } }