2024/3/11 15:45 从stagefull沙盘拉取下来

liuyn

2024-03-11 a87f1c3df03078814ee97ad0c8ac200a232419e9

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
public with sharing class IDInformationAnalyseHospitalController {
    public String fileName { get; set; }
    public List < ChoiceAssetDetailedInfo > choiceAssetDetailedview {
        get;
        set;
    }
 
    public IDInformationAnalyseHospitalController(ApexPages.StandardController stdController) {
 
    }
    public String AccountID; //医院Id
    public String AssetModel; //设备型号
    public String YearRange; //设备型号
    public IDInformationAnalyseHospitalController() {
        AccountID = ApexPages.currentPage().getParameters().get('Id');
        AssetModel = ApexPages.currentPage().getParameters().get('Type');
        YearRange = ApexPages.currentPage().getParameters().get('Year');
        choiceAssetDetailedview = new List < ChoiceAssetDetailedInfo > ();
    }
 
    // 画面初始化
    public void init() {
        choiceAssetDetailedview.clear();
    }
 
    class ChoiceAssetDetailedInfo {
        public Repair__c Repair { get; set; }
        public Boolean ColorFlag; //颜色标记
        public String StyleColor { get; set; }
        public String RepairShippedDate { get; set; }
        public String RepairOrderCompleteDay { get; set; }
        public String RepairInspectionDate { get; set; } // WYL add
    }
    public String StyleColor1 = 'background-color:#FFF0F5';//EEEED1
    public String StyleColor2 = 'background-color:#FFFFF0';//FFF5EE
    public String StyleColor = StyleColor1;
    public void hospitalCount(){
 
        String url = '修理ID信息清单';
        fileName = EncodingUtil.urlEncode(url, 'UTF-8');
        Date dateToday = Date.today();
        Integer year = dateToday.year() - Integer.valueOf(YearRange);
        Date mon1stDate = Date.newInstance(year, dateToday.month(), dateToday.day());
        system.debug('111111111111111111111111111日期'+mon1stDate);
        system.debug('111111111111111111111111111设备型号'+AssetModel);
        List<Repair__c> repairList = [select id,name,Repair_Severity_Rank__c,Repair_List_Price_formula__c,Hospital__c,Hospital__r.Name,Cumulative_Times__c,
                                    SAP_Service_Repair_No__c,Status2__c,Account__c,Account__r.name,Repair_Shipped_Date__c
                                    ,RepairOrder_Complete_Day__c,Cumulative_Uses__c,Cycle_between_failure__c
                                    ,Average_Maintenance_Cost__c,Average_Usage_Time__c
                                    ,SerialNumber__c
                                    //DB202310061111 LY 20231015 start
                                    ,Repair_Inspection_Date__c
                                    ,Repair_Rank__c
                                    ,Difference_in_repair_intervals__c
                                    //DB202310061111 LY 20231015 end
                                    from Repair__c where 
                                    Repair_Severity_Rank__c ='大修理' AND Status1__c !='0.删除' AND Status1__c !='0.取消'
                                    AND Delivered_Product__r.Product2.Asset_Model_No__c like : AssetModel
                                    AND createddate > :mon1stDate
                                    AND Hospital__c = : AccountID
                                    AND Hospital__r.Is_Active__c = '有効'
                                    // Order by createddate Desc
                                    Order by SerialNumber__c,RepairOrder_Complete_Day__c ASC
                                    ];//通过医院找修理
 
        if (repairList.size()>0) {
            Boolean ColorFlag = false;
            String SerialNumber;
            for (Repair__c re : repairList){
                ChoiceAssetDetailedInfo cdinfo = new ChoiceAssetDetailedInfo();
                cdinfo.Repair = re;
                if (String.isBlank(SerialNumber) || SerialNumber == re.SerialNumber__c) {
                    cdinfo.ColorFlag = true;
                }else{
                    StyleColor = colorChange(StyleColor);
                }
                SerialNumber = re.SerialNumber__c;
                cdinfo.StyleColor = StyleColor;
                cdinfo.RepairShippedDate = re.Repair_Shipped_Date__c != null?re.Repair_Shipped_Date__c.format():'';
                cdinfo.RepairOrderCompleteDay = re.RepairOrder_Complete_Day__c != null?re.RepairOrder_Complete_Day__c.format():'';
                cdinfo.RepairInspectionDate = re.Repair_Inspection_Date__c != null?re.Repair_Inspection_Date__c.format():''; // WYL add
                if (!choiceAssetDetailedview.contains(cdinfo)) {
                    choiceAssetDetailedview.add(cdinfo);
                }
            }
        }
 
    }
    //导出
    public Pagereference exportBycsv() {
        return page.IDInformationAnalyseHospitalcsv;
    }
 
    public String colorChange(String colornow) {
        return colornow == StyleColor1 ? StyleColor2 : StyleColor1;
    }
}