已知:7个产品编码字段:【"cpxlh01__c", "cpxlh02__c", "cpxlh03__c", "cpxlh04__c", "cpxlh05__c", "cpxlh06__c", "cpxlh07__c"】
需求:当产品数量小于等于7时,依次按照产品数量逐一更新至第一个,第二个,,,第N个字段。当产品数量大于7时,第七个字段存储:{ 第七个到第N个数据 } 一个用英文分号【;】进行分隔的拼接字符串。
Groovy代码:
import java.util.List;
String generateProductSerialNumber(String productSn, String deliverySn, int index) {
// 格式化数字,整数前自动补零
String serialNumber = String.format("%02d", index);
return productSn + deliverySn.substring(deliverySn.lastIndexOf("_") + 1) + serialNumber;
}
String generateExtraFields(String productSn, String deliverySn, int startIdx, int endIdx, List<String> extraFields) {
if (startIdx <= endIdx) {
extraFields.add(generateProductSerialNumber(productSn, deliverySn, startIdx));
generateExtraFields(productSn, deliverySn, startIdx + 1, endIdx, extraFields);
}
return String.join(';', extraFields);
}
void updateFieldsBasedOnProductDataCount(int productDataCount) {
String fieldPrefix = "cpxlh";
String deliverySn = context.data['name'];
List productList = context.details['DeliveryNoteProductObj'] as List;
updateFields(productDataCount, fieldPrefix, deliverySn, 1, 1, productList, 1);
}
void updateFields(int productDataCount, String fieldPrefix, String deliverySn, int i, int j, List productList, int updateCounter) {
if (i <= productDataCount) {
def product = productList.get(i - 1) as Map
String productSn = product['field_0641A__c'] as String;
int quantity = product['delivery_num'] as int;
String fieldQFDcq = product['field_QFDcq__c'] as String;
// Check if field_QFDcq__c contains '@', if so, skip generating and updating serial numbers
if (!fieldQFDcq.contains('@')) {
if (j <= Math.min(quantity, 7)) {
String fieldName = "${fieldPrefix}${j < 10 ? '0' + j : j}__c";
if (fieldName != "${fieldPrefix}07__c") {
product[fieldName] = generateProductSerialNumber(productSn, deliverySn, j);
} else {
if (quantity > 7) {
product["${fieldPrefix}07__c"] = generateExtraFields(productSn, deliverySn, 7, quantity, [] as List<String>);
} else {
product["${fieldPrefix}07__c"] = generateProductSerialNumber(productSn, deliverySn, j);
}
}
j++;
updateCounter++;
if (updateCounter <= productDataCount * 6) {
updateFields(productDataCount, fieldPrefix, deliverySn, i, j, productList, updateCounter);
} else {
updateFields(productDataCount, fieldPrefix, deliverySn, i + 1, 1, productList, updateCounter);
}
} else {
updateFields(productDataCount, fieldPrefix, deliverySn, i + 1, 1, productList, updateCounter);
}
} else {
// If field_QFDcq__c contains '@', skip generating and updating serial numbers
updateFields(productDataCount, fieldPrefix, deliverySn, i + 1, 1, productList, updateCounter);
}
}
}
int productDataCount = (context.details['DeliveryNoteProductObj'] as List).size();
//是否具备打印条件
if ((context.data['field_v98mg__c'] == 'yes')) {
updateFieldsBasedOnProductDataCount(productDataCount);
//log.info(context.details)
//log.info(context.details['DeliveryNoteProductObj'])
/**
* 批量更新产品序列号字段
*/
def dataList = context.details['DeliveryNoteProductObj']
dataList.each { item ->
def updateFields = ["cpxlh01__c", "cpxlh02__c", "cpxlh03__c", "cpxlh04__c", "cpxlh05__c", "cpxlh06__c", "cpxlh07__c"].collectEntries { [it, item[it]] }
def (Boolean error, Map data, String errorMessage) = Fx.object.update("DeliveryNoteProductObj", item["_id"].toString(), updateFields, UpdateAttribute.builder().triggerWorkflow(false).build())
if (!error) {
log.info(data)
} else {
log.info(errorMessage)
}
}
}
参考:
1、Fx.object.update
Fx.object | 纷享销客 | 帮助中心