/**
* @author 翘楚
* @codeName 根据银行流水批量创建到款认领
* @description 是否生成到款认款:否【true、false】
*/
def retSel = Fx.object.find("BankStatementObj",
FQLAttribute.builder()
.columns(["_id", "name", "arrival_date", "amount_received", "owner"])
.queryTemplate(QueryTemplate.AND(["is_related_received_payment": QueryOperator.EQ("false")]))
.build(),
SelectAttribute.builder().build()).result() as QueryResult
List dataList = retSel['dataList'] as List
List partitionList = Fx.utils.listPartition(dataList, 100)
partitionList.each { item ->
//log.info(item)
List formattedList = item.collect { data ->
def dataMap = data as Map // 将data转换为Map类型
Date arrDate = dataMap['arrival_date'] as Date;
return [
"bank_statement_id": dataMap['_id'] as String,
"name" : dataMap['name'] as String,
"arrival_date" : dataMap['arrival_date'].toTimestamp() as String,
"amount_received" : dataMap['amount_received'] as String,
"owner" : dataMap['owner'] as List,
]
}
log.info(formattedList)
def retCreate = Fx.object.batchCreate("ReceivedPaymentObj", formattedList, CreateAttribute.builder().build()).result() as List
log.info(retCreate)
}
参考:
1、Fx.object.find
Fx.object | 纷享销客 | 帮助中心
2、Fx.object.batchCreate
Fx.object | 纷享销客 | 帮助中心