根据银行流水批量创建到款认领并根据角色查询所有员工ID并发送CRM消息通知

最新推荐文章于 2025-07-17 09:15:00 发布

原创最新推荐文章于 2025-07-17 09:15:00 发布 · 228 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Groovy #getRolesByUsers #sendNotice #find #create

Groovy 专栏收录该内容

35 篇文章

订阅专栏

/**
 * @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
/**
 * @codeName 根据角色查询所有员工ID并发送CRM消息通知
 * @description 根据角色查询所有员工ID并发送CRM消息通知
 * @note 排除合伙人
 * @函数需求编号
 */
List roleCodes = ["00000000000000000000000000000015"]
// 调用方法获取用户信息
def (boolean errorR, List dataR, String messageR) = Fx.auth.user.getUsersByRoleCodes(roleCodes)
if (errorR) {
    // 如果有错误信息，记录日志
    log.info("error: " + messageR)
} else {
    // 记录成功获取的数据
    log.info(dataR)
}
boolean isBj = false
// 定义正则表达式模式 需要过滤的 userId 列表
def bJPattern = ~/^(1186|1187|1188|1189|1050|1075)$/
List userIdList = [];
dataR.each { itemR ->
    String userId = itemR['userId'] as String;
    isBj = bJPattern.matcher(userId).matches();
    if (!isBj) {
        userIdList.add(userId);
    }
}
log.info(userIdList)
List partitionList = Fx.utils.listPartition(dataList, 100)
partitionList.each { item ->
    List formattedList
    formattedList = item.collect { data ->
        def dataMap = data as Map // 将data转换为Map类型
        Date arrDate = dataMap['arrival_date'] as Date;
        Map masterData = [
                "bank_statement_id": dataMap['_id'] as String,
                "name"             : dataMap['name'] as String,
                "arrival_date"     : arrDate.toTimestamp(),
                "amount_received"  : dataMap['amount_received'] as String,
                "owner"            : dataMap['owner'] as List,
        ]
        def (Boolean error2, Map result2, String errorMessage2) = Fx.object.create("ReceivedPaymentObj", masterData, null, true)
        if (error2) {
            log.info(errorMessage2)
        } else {
            String id = result2.data['_id'] as String;
            //自定义接收用户ID
            //def userTest = ["1331", "1332"]
            //List partitionListR = Fx.utils.listPartition(userTest, 1)
            List partitionListR = Fx.utils.listPartition(userIdList, 50)
            partitionListR.each { itemR2 ->
                //根据id分批组装数据
                List userIds = itemR2 as List
                Fx.log.info("当前id分批组装数据条数：" + userIds.size())
                log.info(userIds)
                //Fx.log.info("实际发送的数据条数：" + userIdList.size())
                Notice objectNotify = Notice.objectNotice("ReceivedPaymentObj", id)
                def (Boolean dataErrorR, String dataNoticeR, String errorMessageR) = Fx.message.sendNotice("到款认领", "请确认到款认领", userIds, objectNotify)
                if (dataErrorR) {
                    log.info(errorMessageR)
                } else {
                    log.info(dataNoticeR)
                }
            }
        }
    }
}