gzw 测试环境代码更新

高章伟

2023-03-03 d8dc84a3d56df839895f1c417a4d9cbee763d262

 force-app/main/default/classes/BatchSelectRepairPageController.cls

@@ -1,69 +1,250 @@
public with sharing class BatchSelectRepairPageController {
    public List<RetrievalData> RevalInfoList { get; set; }
    public RetrievalData RevalInfo { get; set; }
    public List<RepairData> RAInfoList { get; set; }
    public List<Repair__c> RepairList { get; set; }
    public List<String> repairIdList{ get; set; }
    public List<SelectOption> StatusItems1 { get; private set; }
    public List<SelectOption> StatusItems { get; private set; }
    public List<SelectOption> SiteRepairItems { get; private set; }
    public String pdfURL { get; private set; }
    public Integer RACount {
        get { return RAInfoList == null ? 0 : RAInfoList.size(); }
    }

    public BatchSelectRepairPageController() {
        StatusItems = new List<SelectOption>();
        StatusItems.add(new SelectOption('','--无--'));
        StatusItems.add(new SelectOption('00.申请完毕','00.申请完毕'));
        StatusItems.add(new SelectOption('01.分公司受理完毕','01.分公司受理完毕'));
        StatusItems.add(new SelectOption('02.RC受理完毕','02.RC受理完毕'));
        StatusItems.add(new SelectOption('03.报价检查结束','03.报价检查结束'));
        StatusItems.add(new SelectOption('04.报价跟进中','04.报价跟进中'));
        StatusItems.add(new SelectOption('05.报价同意完备','05.报价同意完备'));
        StatusItems.add(new SelectOption('06.零件齐备','06.零件齐备'));
        StatusItems.add(new SelectOption('07.修理開始','07.修理開始'));
        StatusItems.add(new SelectOption('08.修理预计完成','08.修理预计完成'));
        StatusItems.add(new SelectOption('09.修理完成','09.修理完成'));
        StatusItems.add(new SelectOption('10.最终检查完成','10.最终检查完成'));
        StatusItems.add(new SelectOption('11.RC修理品已返送','11.RC修理品已返送'));
        StatusItems.add(new SelectOption('12.发票已发送','12.发票已发送'));
        StatusItems.add(new SelectOption('13.已返送到用户','13.已返送到用户'));
        StatusItems.add(new SelectOption('14.收到验收单','14.收到验收单'));
        StatusItems.add(new SelectOption('15.验收单签收复核通过','15.验收单签收复核通过'));
        StatusItems.add(new SelectOption('16.部分付款','16.部分付款'));
        StatusItems.add(new SelectOption('16.完毕','16.完毕'));
        StatusItems.add(new SelectOption('17.付款完毕','17.付款完毕'));
        StatusItems.add(new SelectOption('00.取消','00.取消'));
        StatusItems.add(new SelectOption('00.删除','00.删除'));
        StatusItems.add(new SelectOption('00.关闭','00.关闭'));

        StatusItems1 = new List<SelectOption>();
        StatusItems1.add(new SelectOption('','--无--'));
        StatusItems1.add(new SelectOption('0.申请完毕','0.申请完毕'));
        StatusItems1.add(new SelectOption('2.维修报价阶段','2.维修报价阶段'));
        StatusItems1.add(new SelectOption('3.维修阶段','3.维修阶段'));
        StatusItems1.add(new SelectOption('4.修理品返送阶段','4.修理品返送阶段'));
        StatusItems1.add(new SelectOption('5.完毕','5.完毕'));
        StatusItems1.add(new SelectOption('0.删除','0.删除'));
        StatusItems1.add(new SelectOption('0.取消','0.取消'));
    
        SiteRepairItems = new List<SelectOption>();
        SiteRepairItems.add(new SelectOption('','--无--'));
        SiteRepairItems.add(new SelectOption('RC修理','RC修理'));
        SiteRepairItems.add(new SelectOption('直送SORC修理','直送SORC修理'));
        SiteRepairItems.add(new SelectOption('直送OGZ修理','直送OGZ修理'));
        SiteRepairItems.add(new SelectOption('办事处修理','办事处修理'));
        SiteRepairItems.add(new SelectOption('现场修理','现场修理'));

        
       
      
    }

    public void init(){
        RetrievalData reval = new RetrievalData();
        RevalInfoList = new List<RetrievalData>();
        RevalInfoList.add(reval);
        RevalInfo = new RetrievalData();
    }

    // public List<SelectOption> getworkLocationSelect() {
    //     List<SelectOption> workLocationSelect = new List<SelectOption>();
    //     workLocationSelect.add(new SelectOption('','--无--'));
    //     workLocationSelect.add(new SelectOption('北京办事处','北京办事处'));
    //     workLocationSelect.add(new SelectOption('天津办事处','天津办事处'));
    //     workLocationSelect.add(new SelectOption('河北办事处','河北办事处'));
    //     workLocationSelect.add(new SelectOption('济南办事处','济南办事处'));
    //     workLocationSelect.add(new SelectOption('青岛办事处','青岛办事处'));
    //     workLocationSelect.add(new SelectOption('内蒙办事处','内蒙办事处'));
    //     workLocationSelect.add(new SelectOption('黑龙江办事处','黑龙江办事处'));
    //     workLocationSelect.add(new SelectOption('吉林办事处','吉林办事处'));
    //     workLocationSelect.add(new SelectOption('沈阳办事处','沈阳办事处'));
    //     workLocationSelect.add(new SelectOption('大连办事处','大连办事处'));
    //     workLocationSelect.add(new SelectOption('陕西办事处','陕西办事处'));
    //     workLocationSelect.add(new SelectOption('青海办事处','青海办事处'));
    //     workLocationSelect.add(new SelectOption('宁夏办事处','宁夏办事处'));
    //     workLocationSelect.add(new SelectOption('甘肃办事处','甘肃办事处'));
    //     workLocationSelect.add(new SelectOption('新疆办事处','新疆办事处'));
    //     workLocationSelect.add(new SelectOption('山西办事处','山西办事处'));
    //     workLocationSelect.add(new SelectOption('河南办事处','河南办事处'));
    //     workLocationSelect.add(new SelectOption('上海办事处','上海办事处'));
    //     workLocationSelect.add(new SelectOption('江苏办事处','江苏办事处'));
    //     workLocationSelect.add(new SelectOption('江西办事处','江西办事处'));
    //     workLocationSelect.add(new SelectOption('浙江办事处','浙江办事处'));
    //     workLocationSelect.add(new SelectOption('安徽办事处','安徽办事处'));
    //     workLocationSelect.add(new SelectOption('福建办事处','福建办事处'));
    //     workLocationSelect.add(new SelectOption('广东办事处','广东办事处'));
    //     workLocationSelect.add(new SelectOption('深圳办事处','深圳办事处'));
    //     workLocationSelect.add(new SelectOption('湖北办事处','湖北办事处'));
    //     workLocationSelect.add(new SelectOption('湖南办事处','湖南办事处'));
    //     workLocationSelect.add(new SelectOption('云南办事处','云南办事处'));
    //     workLocationSelect.add(new SelectOption('贵州办事处','贵州办事处'));
    //     workLocationSelect.add(new SelectOption('四川办事处','四川办事处'));
    //     workLocationSelect.add(new SelectOption('重庆办事处','重庆办事处'));
    //     workLocationSelect.add(new SelectOption('杭州办事处','杭州办事处'));
    //     workLocationSelect.add(new SelectOption('杭州共通办事处','杭州共通办事处'));
    //     workLocationSelect.add(new SelectOption('西安办事处','西安办事处'));
    //     workLocationSelect.add(new SelectOption('西安共通办事处','西安共通办事处'));
    //     workLocationSelect.add(new SelectOption('共通办事处','共通办事处'));
    //     workLocationSelect.add(new SelectOption('成都办事处','成都办事处'));
    //     workLocationSelect.add(new SelectOption('成都共通办事处','成都共通办事处'));
    //     workLocationSelect.add(new SelectOption('广州办事处','广州办事处'));
    //     return workLocationSelect;
    // }

    public PageReference RetrievalBtn() {
        RepairList = new List<Repair__c>();
        RAInfoList = new List<RepairData>();
        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);
        if(String.isBlank(RevalInfo.Status1) && String.isBlank(RevalInfo.Status2) && String.isBlank(RevalInfo.RepairName) && String.isBlank(RevalInfo.SAPRepairNo) 
            && String.isBlank(RevalInfo.SerialNumber) && String.isBlank(RevalInfo.repair.Incharge_Staff__c) && String.isBlank(RevalInfo.onSiteRepair)
            && String.isBlank(String.valueOf(RevalInfo.repair.Aware_date__c)) && String.isBlank(String.valueOf(RevalInfo.repair.Aware_date2__c)) && String.isBlank(RevalInfo.workLocationSelect)
            && String.isBlank(RevalInfo.State_Hospital)){
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO, '请至少添加一个检索条件!'));
            return null;
        }
        String 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(RevalInfo.Status2)){
            sql += ' and Status2__c = \'' + RevalInfo.Status2 + '\'';
        }
        if(String.isNotBlank(RevalInfo.Status1)){
            sql += ' and Status1__c = \'' + RevalInfo.Status1 + '\'';
        }
        if(String.isNotBlank(RevalInfo.HospitalName)){

            sql += ' and HP_Name__c like \'%' + RevalInfo.HospitalName.trim() + '%\'';
        }
        if(String.isNotBlank(RevalInfo.RepairName)){
            System.debug(LoggingLevel.INFO, '***RevalInfo.RepairName.contains(): ' + RevalInfo.RepairName.contains(' '));
            String splitStr = null;
            if(RevalInfo.RepairName.contains(' ')){
                splitStr = ' ';
            }else if(RevalInfo.RepairName.contains(',')){
                splitStr = ',';
            }
            if(splitStr != null && RevalInfo.RepairName.contains(splitStr)){
                sql += ' and (';
                list <String> nameList = RevalInfo.RepairName.split(splitStr);
                for(String name: nameList){
                   sql += 'Name like \'%' + name + '%\' or ';
                }
                sql = sql.removeEnd('or ');
                sql += ')';
            }else{
                sql += ' and Name like \'%' + RevalInfo.RepairName.trim() + '%\'';
            }
            System.debug(LoggingLevel.INFO, '*** sql: ' + sql);
        }
        if(String.isNotBlank(RevalInfo.SAPRepairNo)){
            System.debug(LoggingLevel.INFO, '***RevalInfo.SAPRepairNo.contains(): ' + RevalInfo.SAPRepairNo.contains(' '));
            String splitStr = null;
            if(RevalInfo.SAPRepairNo.contains(' ')){
                splitStr = ' ';
            }else if(RevalInfo.SAPRepairNo.contains(',')){
                splitStr = ',';
            }
            if(splitStr != null && RevalInfo.SAPRepairNo.contains(splitStr)){
                sql += ' and (';
                
                list <String> noList = RevalInfo.SAPRepairNo.split(splitStr);
                for(String no: noList){
                   sql += 'SAP_Service_Repair_No__c like \'%' + no + '%\' or ';
                }
                sql = sql.removeEnd('or ');
                sql += ')';
            }else{
                sql += ' and SAP_Service_Repair_No__c like \'%' + RevalInfo.SAPRepairNo.trim() + '%\'';
            }
            System.debug(LoggingLevel.INFO, '*** sql: ' + sql);
        }
        if(String.isNotBlank(RevalInfo.SerialNumber)){
            List<String> SerialNumberList = new List<String>();
            if(RevalInfo.SerialNumber.indexOf(',') != -1){
                SerialNumberList = RevalInfo.SerialNumber.split(',');
            }
            System.debug('SerialNumberList1:' + SerialNumberList);
            // 支持模糊查询多个，文本框输入用英文半角逗号分隔
            if(SerialNumberList.size() > 0){
                sql += ' and (SerialNumber__c like \'%';
                Integer i = 0;
                for(String SerialNumber : SerialNumberList){
                    if(i == 0){
                        sql += SerialNumber.trim() + '%\'';
                    }else{
                        sql += 'or SerialNumber__c like \'%' + SerialNumber.trim() + '%\'';
                    }
                    i++;
                }
                sql += ')';
            } else{
                sql += ' and SerialNumber__c like \'%' + RevalInfo.SerialNumber.trim() + '%\'';
            }
        }
        if(String.isNotBlank(RevalInfo.repair.Incharge_Staff__c)){
            sql += ' and Incharge_Staff__c = \'' + RevalInfo.repair.Incharge_Staff__c + '\'';
        }
        if(String.isNotBlank(String.valueof(RevalInfo.repair.Aware_date__c))&&String.isNotBlank(String.valueof(RevalInfo.repair.Aware_date2__c))){
            String day = String.valueof(RevalInfo.repair.Aware_date__c);
            String day2 = String.valueof(RevalInfo.repair.Aware_date2__c);
            day = day.substring(0,10);
            day2 = day2.substring(0,10);
            sql += ' and FSE_ApplyForRepair_Day__c >= ' + day + 'and FSE_ApplyForRepair_Day__c <=' +day2;
        }
        if(String.isNotBlank(RevalInfo.onSiteRepair)){
            sql += ' and On_site_repair__c = \'' + RevalInfo.onSiteRepair + '\'';
        }
        if(String.isNotBlank(RevalInfo.workLocationSelect)){
            List<String> workLocationSelectList = new List<String>();
            if(RevalInfo.workLocationSelect.indexOf(',') != -1){
                workLocationSelectList = RevalInfo.workLocationSelect.split(',');
            }
            System.debug('workLocationSelectList1:' + workLocationSelectList);
            if(workLocationSelectList.size() > 0){
                sql += ' and (work_location_select__c like \'%';
                Integer i = 0;
                for(String workLocationSelect : workLocationSelectList){
                    if(i == 0){
                        sql += workLocationSelect.trim() + '%\'';
                    }else{
                        sql += 'or work_location_select__c like \'%' + workLocationSelect.trim() + '%\'';
                    }
                    i++;
                }
                sql += ')';
            } else{
                sql += ' and work_location_select__c like \'%' + RevalInfo.workLocationSelect.trim() + '%\'';
            }
        }
        if(String.isNotBlank(RevalInfo.State_Hospital)){
            sql += ' and State_Hospital__c like \'%' + RevalInfo.State_Hospital.trim() + '%\'';
        }
        sql += 'and Status1__c not in(\'0.删除\',\'0.取消\') limit 200';
        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() == 200){
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, '检索数据太多,请缩小检索范围！'));
        }
        if(RepairList.size() <= 0 ){
        if(RepairList.size() <= 0){
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO, '没检索到任何修理'));
            return null;
        }
@@ -75,33 +256,45 @@
    }

    public PageReference showPDF() {
        System.debug(LoggingLevel.INFO, '*** joinshoPDF: ');
        repairIdList = new List<String>();
        RepairList = new List<Repair__c>();
        String url = '=';
        if(RAInfoList == null){
        System.debug('RAInfoList:' + RAInfoList);
        if(RAInfoList == null || RAInfoList.isEmpty()){
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO, '请先检索修理'));
            return null;
        }
        for(RepairData rd : RAInfoList) {
            System.debug(LoggingLevel.INFO, '*** rd: ' + rd);
            if(rd.IFCheck){
                repairIdList.add(rd.repair.Id);
                RepairList.add(rd.repair);
            }
        }
        System.debug(LoggingLevel.INFO, '***repairIdList : ' + repairIdList);
        System.debug(LoggingLevel.INFO, '***RepairList : ' + RepairList);
        if(repairIdList.size() > 0){
            if(repairIdList.size() <= 50){
                if(RepairList.size() > 0){
                    System.debug(LoggingLevel.INFO, '*** if size>0 generateAttachment: ');
                    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;
                // PageReference pageRef = new PageReference('/apex/MaintenanceCommissionPDF?id' + url);
                // pageRef.setRedirect(true);
                // return pageRef;
                if(isSandbox()){
                    pdfURL = 'https://ocsm--stagefull--c.visualforce.com/apex/MaintenanceCommissionPDF?id' + url;
                } else{
                    pdfURL = 'https://ocsm.my.salesforce.com/apex/MaintenanceCommissionPDF?id' + url;
                }
                return null;
            } else{
                ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, '多单打印最大数量为50,请选择少于50个修理!'));
                ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, '多单打印最大数量为50,请选择少于50个修理！'));
                return null;
            }
        } else{
@@ -112,33 +305,58 @@

    // 生成pdf添加到对应的修理中
    public static PageReference generateAttachment(List<Repair__c> repList){
        PageReference pdfPage;
        List<Attachment> attachments = new List<Attachment>();
        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;
        System.debug(LoggingLevel.INFO, '*** generateAttachment: ');
        // PageReference pdfPage;
        // List<Attachment> attachments = new List<Attachment>();
        // List<String> attachmentNameList = new List<String>();
        // List<Attachment> isGeneratedPDFList = new List<Attachment>();
        // //删除已存在的附件，生成新的附件
        // for(Repair__c re : repList){   
        //     attachmentNameList.add(re.name + '_' + 'MaintenanceCommission.pdf');
        // }
        // isGeneratedPDFList = [select id from Attachment where name IN:attachmentNameList];
        // System.debug(LoggingLevel.INFO, '*** isGeneratedPDFList: ' + isGeneratedPDFList);
        // if(isGeneratedPDFList.size() > 0){
        //     delete isGeneratedPDFList;
        // }
        BatchSelectRepairPDFDelete pdf = new BatchSelectRepairPDFDelete();
        pdf.deletePDF(repList);
        pdf.createPDF(repList);

        // 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);
        // }
        // System.debug(LoggingLevel.INFO, '*** attachments: ' + attachments);
        // insert attachments;
        return null;
    }

    // 判断是否是测试环境
    public  Boolean isSandbox() {
        return [SELECT IsSandbox FROM Organization LIMIT 1].IsSandbox;
    }

    public class RetrievalData {
        public String Status1{ get; set; }
        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 String onSiteRepair{ get; set; }
        public String workLocationSelect{ get; set; }
        public String State_Hospital{ get; set; }
        public String HospitalName{ get; set; }
        public Repair__c repair{ get; set; }
        public RetrievalData(){
            repair = new Repair__c();