Data Filter JAVA

package com;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

public class DataFilter {
public static void main(String[] args) {
//声明数组，通过数组注明需要获取的colnum
//0 Item Id、1 Title 、3 Assigned To、4 Country 、10 Item Type 、11 Last Modified Date 、16 Severity 、19 Submitter
int [] ca = new int[]{0,1,3,4,10,11,16,19};
//0 Item Id、1 Title 、2 Assigned To、4 Country 、9 Item Type 、10 Last Modified Date 、17 Severity 、20 Submitter
int [] fem = new int[]{0,1,2,4,9,10,17,20};
//0 Item Id、1 Title 、3 Assigned To、4 Country 、9 Item Type 、10 Last Modified Date 、17 Severity 、20 Submitter
int [] flextrade = new int[]{0,1,3,4,9,10,17,20};
//0 Item Id、1 Title 、6 Assigned To、5 Country 、2 Item Type 、10 Last Modified Date 、8 Severity 、4 Submitter 、
int [] ibor = new int[]{0,1,6,5,2,10,8,4};
//0 Item Id、1 Title 、3 Assigned To、4 Country 、13 Item Type 、14 Last Modified Date 、22 Severity 、25 Submitter
int [] ibor_it = new int[]{0,1,3,4,13,14,22,25};
//0 Item Id、1 Title 、3 Assigned To、4 Country 、9 Item Type 、10 Last Modified Date 、17 Severity 、20 Submitter
int [] icrm = new int[]{0,1,3,4,9,10,17,20};
//0 Item Id、1 Title 、3 Assigned To、4 Country 、9 Item Type 、10 Last Modified Date 、17 Severity 、20 Submitter
int [] ilevel = new int[]{0,1,3,4,9,10,14,17,20};
//0 Item Id、1 Title 、3 Assigned To、4 Country 、9 Item Type 、10 Last Modified Date 、17 Severity 、20 Submitter
int [] maya_etl = new int[]{0,1,3,4,9,10,14,17,20};
//0 Item Id、1 Title 、3 Assigned To、4 Country 、9 Item Type 、10 Last Modified Date 、17 Severity 、20 Submitter
int [] others = new int[]{0,1,3,4,9,10,17,20};
//0 Item Id、1 Title 、3 Assigned To、4 Country 、9 Item Type 、10 Last Modified Date 、17 Severity 、20 Submitter
int [] ro = new int[]{0,1,3,4,9,10,17,20};
//0 Item Id、1 Title 、3 Assigned To、5 Country 、13 Item Type 、14 Last Modified Date 、25 Severity 、28 Submitter
int [] sianii = new int[]{0,1,3,5,13,14,25,28};

    //声明数组jira，通过数组注明需要获取的colnum
    //1 jirafem Summary、5 Invest_report_itemtype、8 Severity、13 Updated、15 TT_Assignee、17 TT_Country、19 TT_Submitter、20 Team Track ID
    int [] jirafem = new int[]{1,5,8,13,15,17,19,20};
    int [] jiraflextrade = new int[]{1,5,8,13,15,17,19,20};
    //IBOR和IBOR_IT合成了一份
    int [] jiraibor = new int[]{1,5,8,13,15,17,19,20};
    int [] jiraicrm = new int[]{1,5,8,13,15,17,19,20};
    int [] jirailevel = new int[]{1,5,8,13,15,17,19,20};
    int [] jiramaya = new int[]{1,5,8,13,15,17,19,20};
    int [] jiraothers = new int[]{1,5,8,13,15,17,19,20};
    int [] jiraro = new int[]{1,5,8,13,15,17,19,20};
    int [] jirasaaniity = new int[]{1,5,8,13,15,17,19,20};
    int [] jiratlm = new int[]{1,5,8,13,15,17,19,20};
    //获取每个xlsx的list；
    List<List> caList = Utils.readAssignByExcelca("C:\\wz\\Crester\\9-20\\marked//CA.xlsx",0,ca);

// System.out.println("caList : "+caList);
// System.out.println("caList.size() : "+caList.size());
List femList = Utils.readAssignByExcelfem(“C:\wz\Crester\9-20\marked//FEM.xlsx”,0,fem);
// System.out.println("femList : "+femList);
// System.out.println("femList.size() : "+femList.size());
List flextradeList = Utils.readAssignByExcel(“C:\wz\Crester\9-20\marked//FlexTrade.xlsx”,0,flextrade);
// System.out.println("flextradeList : "+flextradeList);
// System.out.println("flextradeList.size() : "+flextradeList.size());
List iborList = Utils.readAssignByExcelibor(“C:\wz\Crester\9-20\marked//IBOR.xlsx”,0,ibor);
// System.out.println("iborList : "+iborList);
// System.out.println("iborList.size() : "+iborList.size());
List ibor_itList = Utils.readAssignByExcelibor_it(“C:\wz\Crester\9-20\marked//IBOR_IT.xlsx”,0,ibor_it);
// System.out.println("ibor_itList : "+ibor_itList);
// System.out.println("ibor_itList.size() : "+ibor_itList.size());
List icrmList = Utils.readAssignByExcelicrm(“C:\wz\Crester\9-20\marked//iCRM.xlsx”,0,icrm);
// System.out.println("icrmList : "+icrmList);
// System.out.println("icrmList.size() : "+icrmList.size());
List ilevelList = Utils.readAssignByExcelilevel(“C:\wz\Crester\9-20\marked//iLevel.xlsx”,0,ilevel);
// System.out.println("ilevelList : "+ilevelList);
// System.out.println("ilevelList.size() : "+ilevelList.size());
List maya_etlList = Utils.readAssignByExcelmayaetl(“C:\wz\Crester\9-20\marked//MAYA_ETL.xlsx”,0,maya_etl);
// System.out.println("maya_etlList : "+maya_etlList);
// System.out.println("maya_etlList.size() : "+maya_etlList.size());
// List maya1List = Utils.readAssignByExcel1(“C:\wz\Crester\9-20\marked//MAYA1.xlsx”,0,maya1);
List othersList = Utils.readAssignByExcel(“C:\wz\Crester\9-20\marked//Others.xlsx”,0,others);
// System.out.println("othersList : "+othersList);
// System.out.println("othersList.size() : "+othersList.size());
List roList = Utils.readAssignByExcel(“C:\wz\Crester\9-20\marked//RO.xlsx”,0,ro);
// System.out.println("roList : "+roList);
// System.out.println("roList.size() : "+roList.size());
List sianiiList = Utils.readAssignByExcel1(“C:\wz\Crester\9-20\marked//SIANII.xlsx”,0,sianii);
// System.out.println("sianiiList : "+sianiiList);
// System.out.println("sianiiList.size() : "+sianiiList.size());
// System.exit(1);

    //获取JIRA List;
    List<List>  jiraList = Utils.readAssignByJiraExcel("C:\\wz\\Crester\\9-20\\JIRA//Jira_Flextrade (2).xlsx",0,jiraflextrade);
    List<List>  Jira_Fem_List = Utils.readAssignByJiraExcel("C:\\wz\\Crester\\9-20\\JIRAxlsx//Jira_FEM_new.xlsx",0,jirafem);

// System.out.println("Jira_Fem_List : "+Jira_Fem_List);
// System.out.println("Jira_Fem_List.get(0).get(7) : "+Jira_Fem_List.get(0).get(7));
List Jira_Fem_TeamTrackIDList = new ArrayList();
for (int i = 0;i<Jira_Fem_List.size();i++){
Jira_Fem_TeamTrackIDList.add(Jira_Fem_List.get(i).get(7));
}
List Fem_ItemIdList = new ArrayList();
for(int i = 0;i<femList.size();i++){
Fem_ItemIdList.add(femList.get(i).get(0));
}
// System.out.println("Fem_ItemIdList.size() : "+Fem_ItemIdList.size());
// System.out.println(Fem_ItemIdList);

    //求交集
    //fem、jira_fem
    List<List> FemInterSection = Utils.findIntersection(Jira_Fem_List,Jira_Fem_TeamTrackIDList);

// System.out.println(FemInterSection.get(0).get(7));
int fls = femList.size();
int jfls =Jira_Fem_List.size();
int fiss = FemInterSection.size();

// System.out.println("Jira_Fem_List : "+Jira_Fem_List);
//list
List errorList = new ArrayList<>();
List unExistList = new ArrayList<>();
for(int i = 0;i < fls;i++){
int n = 0;
//0 Item Id、1 Title、2 Assigned To、4 Country、9 Item Type、10 Last Modified Date、17 Severity、20 Submitter
// System.out.println("femList : "+femList);
String fem_item_id = femList.get(i).get(0).toString();
String fem_Title = femList.get(i).get(1).toString();
String fem_Assigned_To = femList.get(i).get(2).toString();
String fem_Country = femList.get(i).get(3).toString();
String fem_Item_Type = femList.get(i).get(4).toString();
String fem_Last_Modified_Date = femList.get(i).get(5).toString();
String fem_Severity = femList.get(i).get(6).toString();
// System.out.println(fem_Severity);
String fem_Submitter = femList.get(i).get(7).toString();
// System.out.println(fem_Submitter);
List errli = new ArrayList<>();
for(int j = 0;j < jfls ;j++){
//1 jirafem Summary、5 Invest_report_itemtype、8 Severity、13 Updated、15 TT_Assignee、17 TT_Country、19 TT_Submitter、20 Team Track ID
String Jira_Summary = Jira_Fem_List.get(j).get(0).toString();
String Jira_Invest_report_itemtype = Jira_Fem_List.get(j).get(1).toString();
String Jira_Severity = Jira_Fem_List.get(j).get(2).toString();
String Jira_Updated = Jira_Fem_List.get(j).get(3).toString();
String Jira_TT_Assignee = Jira_Fem_List.get(j).get(4).toString();
String Jira_TT_Country = Jira_Fem_List.get(j).get(5).toString();
String Jira_TT_Submitter = Jira_Fem_List.get(j).get(6).toString();
String Jira_Team_Track_ID = Jira_Fem_List.get(j).get(7).toString();
if(fem_item_id.equals(Jira_Team_Track_ID)){
if(!fem_Title.equals(Jira_Summary)){
System.out.println("Jira_Summary : "+Jira_Summary);
errli.add(Jira_Summary);
}
if(!fem_Item_Type.equals(Jira_Invest_report_itemtype)){
System.out.println("Jira_Invest_report_itemtype : "+Jira_Invest_report_itemtype);
errli.add(Jira_Invest_report_itemtype);
}
if(!fem_Severity.equals(Jira_Severity)){
System.out.println("Jira_Severity : "+Jira_Severity);
errli.add(Jira_Severity);
}
if(!fem_Last_Modified_Date.equals(Jira_Updated)){
System.out.println("Jira_Updated : "+Jira_Updated);
errli.add(Jira_Updated);
}
if(!fem_Assigned_To.equals(Jira_TT_Assignee)){
System.out.println("Jira_TT_Assignee : "+Jira_TT_Assignee);
errli.add(Jira_TT_Assignee);
}
if(!fem_Country.equals(Jira_TT_Country)){
System.out.println("Jira_TT_Country : "+Jira_TT_Country);
errli.add(Jira_TT_Country);
}
if(!fem_Submitter.equals(Jira_TT_Submitter)){
System.out.println("Jira_TT_Submitter : "+Jira_TT_Submitter);
errli.add(Jira_TT_Submitter);
}
if(errli.size()>0){
System.out.println("Jira_Team_Track_ID : "+Jira_Team_Track_ID);
errli.add(0,Jira_Team_Track_ID);
}
n = n+1;
}
}
errorList.add(errli);
if(n == 0){
unExistList.add(femList.get(i));
}
}

    System.out.println("errorList : "+errorList);
    System.out.println("unExistList : "+unExistList);

// for(int i = 0;i < fiss;i++){
// if(FemInterSection.get(i).get(7).toString().equals(femList.get(3).get(0).toString())){
// System.out.println(FemInterSection.get(i).get(7).toString());
// }
// }

    System.exit(1);

    //合并list

// List mergeList = new ArrayList<>();
// mergeList.addAll(caList);
// mergeList.addAll(femList);
// mergeList.addAll(flextradeList);
// mergeList.addAll(iborList);
// mergeList.addAll(ibor_itList);
// mergeList.addAll(icrmList);
// mergeList.addAll(ilevelList);
// mergeList.addAll(maya_etlList);
// mergeList.addAll(maya1List);
// mergeList.addAll(othersList);
// mergeList.addAll(roList);
// mergeList.addAll(sianiiList);

// int mls = mergeList.size();
List TeamTrackIDList = new ArrayList();
for (int i = 0;i<jiraList.size();i++){
TeamTrackIDList.add(jiraList.get(i).get(4));
}

    //找出两个集合 Team Track ID与Issue_id相同部分;

// List interSectList = Utils.findIntersection(mergeList,TeamTrackIDList);

    List<List> idL = new ArrayList<>();

// for (int i = 0;i<interSectList.size();i++){
// idL.add((interSectList.get(i)));
// }

    for(int i = 0;i < idL.size();i++){

// if(!interSectList.get(1).equals(TeamTrackIDList.get(1))){
// System.out.println("!interSectList.get(1).equals(TeamTrackIDList.get(1))"+interSectList.get(1));
// }
}

}

}