def domain(String fileName) {
def filePath = "" + fileName + ".csv" // 替换为实际的文件路径
def data = []
new File(filePath).eachLine { line ->
def row = line.split(',')
data.add(row)
}
}
def AES = domain("AE");
def CMS = domain("CM");
def MHS = domain("MH");
for (def CM : CMS) {
if (CM.CMAENO != "") {
def list = CM.CMAENO.split(",").collect { p ->
onlyOne(AES.findAll { AE -> AE.SUBJID == CM.SUBJID && AE.AESPID == p }.collect { it.AETERM })
}
CM.CMINDC_Merge = join(list)
} else if (CM.CMMHNO != "") {
def list = CM.CMMHNO.split(",").collect { p ->
onlyOne(MHS.findAll { MH -> MH.SUBJID == CM.SUBJID && MH.MHSPID == p }.collect { it.MHTERM })
}
CM.CMINDC_Merge = join(list)
} else if (CM.CMINDC == "OTHER") {
CM.CMINDC_Merge = CM.CMINDCO
} else {
CM.CMINDC_Merge = ""
}
if (CM.CMROUTE != "OTHER") {
CM.CMROUTE_Merge = CM.CMROUTE
} else if (CM.CMROUTEO != "" && CM.CMROUTE == "OTHER") {
CM.CMROUTE_Merge = CM.CMROUTEO
} else {
CM.CMROUTE_Merge = ""
}
}
return CMS;