println("Hello world! - groovy.jsrun.net")
def info = [
[
"adverse_item": null,
"device_code": null,
"device_type": null,
"examine_proj": "达因",
"factory": "电池箔分厂",
"inspection_date": "2023-11-29 00:00:00",
"lot_no": "301423112708-4-2-2",
"lot_status": null,
"material_code": "13",
"material_type": "1060",
"peculiarity": null,
"process": "一次合格",
"production_line": "倒卷机41#",
"quality_status": "合格",
"quantity": 36,
"shipment": null,
"sort_no": null,
"updated_time": null,
"weight": 0.41,
"workshop": "D2"
]
]
def catl_module_fac = new StringBuilder()
if (info) {
info.eachWithIndex { item, index ->
def concatenatedFields = "('${item.adverse_item ?: ''}','${item.device_code ?: ''}','${item.device_type ?: ''}','${item.examine_proj ?: ''}'," +
"'${item.factory ?: ''}','${item.inspection_date ?: ''}','${item.lot_no ?: ''}'," +
"'${item.lot_status ?: ''}','${item.material_code ?: ''}','${item.material_type ?: ''}','${item.peculiarity ?: ''}'," +
"'${item.process ?: ''}','${item.production_line ?: ''}','${item.quality_status ?: ''}',${item.quantity ?: 0},'${item.shipment ?: ''}','${item.sort_no ?: ''}'," +
"'${item.updated_time ?: ''}',${item.weight ?: 0},'${item.workshop ?: ''}')"
if (index != 0) {
catl_module_fac.append(",")
}
catl_module_fac.append(concatenatedFields)
}
} else {
catl_module_fac.append("('','','','','','','','','','','','','','','','',0,'')")
}
def result = catl_module_fac.toString()
println(result)