纷享销客工单对象业务流程批量终止_groovy fx.object.update-优快云博客

本文链接：https://blog.youkuaiyun.com/netuser1937/article/details/139955150
Groovy代码如下：
//工单流程状态 进行中、其他
List statusList = ["in_progress", "other"];
//业务类型
def recordType = "record_m4ElO__c";
//def caseId = "6673716fa75eb1000122d7b5";
//name = "20240620019289";
//def caseId = "666b88a4a75eb10001fef4bf";
//name = "20240614019053";
def searchCondition = QueryTemplate.AND(
        //["_id": QueryOperator.EQ(caseId)],
        ["field_workflowStatus__c": QueryOperator.IN(statusList)],
        ["record_type": QueryOperator.EQ(recordType)]
)
Fx.log.info("查询条件为 :" + searchCondition)
//查询条件 要以id 进行排序，find默认的排序是最后修改时间，如果排序字段存在重复，数据库是不能保证每次查询出来顺序是一致的
//分页的时候可能会出现重复数据，导致执行遗漏。
Map orderBy = ["_id": -1]
boolean hasData = true
Integer limit = 100
//循环聚合所有数据
Map updateData = [:]
Range range = Ranges.of(0, 200)
range.each { i ->
    if (hasData == false) {
        return
    }
    Integer skip = i * limit
    def (Boolean error, QueryResult result, String errorMessage) = Fx.object.find("CasesObj",
            FQLAttribute.builder()
                    .orderBy(orderBy)
                    .limit(limit)
                    .skip(skip)
                    .columns(["_id", "name", "field_workflowStatus__c", "cases_status"])
                    .queryTemplate(searchCondition)
                    .build(),
            SelectAttribute.builder().build())

    if (error) {
        hasData = false
        Fx.log.info("查询失败" + "当前跳过的数量为 " + skip + "错误原因为" + errorMessage)
        return
    }
    //获取所有更新的数据,如果是预设对象，就在循环里面直接更新。
    List dataList = result.dataList
    if (dataList.size() < limit) {
        hasData = false
    }
    //如果不需要合并数据，在这里就可以100条
    dataList.each { item ->
        Map objectData = item as Map
        log.info(objectData)
        updateData.put(objectData._id, objectData._id)
    }
}
//极端情况，所有查询都失败了
if (!updateData) {
    Fx.log.info("循环查询出来数据为空")
    return
}
//如果是自定义对象，直接调用更新即可,更新单次500条限制，所以我们拆分数据
List idList = updateData.keys() as List
//log.info(updateData)
//log.info(idList)
List partitionList = Fx.utils.listPartition(idList, 500)
partitionList.each { item ->
    Map currentUpdateMap = [:]
    //根据id分批组装数据
    List ids = item as List
    ids.each { id ->
        String stringId = id as String
        //工单流程状态：取消-cancel、状态：关闭-4
        def result2 = Fx.object.update("CasesObj", QueryTemplate.AND(["_id": QueryOperator.EQ(stringId)]), ["field_workflowStatus__c": "cancel", "cases_status": "4"], UpdateAttribute.builder().build()).result() as String
        if (result2) {
            QueryResult data2 = Fx.bpm.findInstances("CasesObj", "in_progress", stringId, 100, 1)[1]
            log.info("query instances data:" + data2)
            if (data2 != null && data2.size > 0) {
                List<Map> dataList2 = data2.dataList;
                dataList2.each { it2 ->
                    String instanceId = it2.instanceId;
                    String workflowName = it2.workflowName;
                    log.info("instanceId:" + instanceId + ",workflowName:" + workflowName)
                    //参数是:流程实例id , 终止原因(可以根据自己的业务,修改下原因)
                    APIResult ret2 = Fx.bpm.cancel(instanceId, "统一终止");
                    if (ret2[0] == false) {
                        //执行到这里  说明终止已经成功了
                        log.info("bpm instance cancel success,instanceId:" + instanceId + ",workflowName:" + workflowName)
                    } else {
                        log.info("ret:" + ret2)
                    }
                }
            } else {
                log.info("no data found:" + data2)
            }
        }
        log.info(result2)
    }
}
Fx.log.info("实际的数据为" + idList.size())