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

原创已于 2024-06-16 19:54:30 修改 · 311 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#纷享销客 #发货单产品 #自动生成 #产品编码 #逐一更新

于 2024-06-15 23:56:52 首次发布

Groovy 专栏收录该内容

35 篇文章

订阅专栏

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