纷享逍客根据发货单产品数量自动生成产品编码并逐一更新

已知: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 | 纷享销客 | 帮助中心

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值