# BudgetDatabaseJobWorker.java

    package cloud.wconnect.rateshop.scheduler.budgetdatabase;

    import cloud.wconnect.commonlib.cons.FunctionIdConstant;
    import cloud.wconnect.commonlib.cons.SchedulerCons;
    import cloud.wconnect.commonlib.service.CommonService;
    import cloud.wconnect.commonlib.service.IdentityProvider;
    import cloud.wconnect.commonlib.service.MailInternalService;
    import cloud.wconnect.commonlib.util.RateLimitUtils;
    import cloud.wconnect.rateshop.businesstask.budgetdatabase.BudgetDatabaseExpirationNoticeTask;
    import cloud.wconnect.rateshop.cons.budgetdatabase.BudgetDatabaseNotifyCons;
    import cloud.wconnect.rateshop.entity.budgetdatabase.BudgetDatabaseConfigSchedulerJob;
    import cloud.wconnect.rateshop.service.AmazonSqsSchedulerService;
    import cloud.wconnect.rateshop.service.budgetdatabase.IBudgetDatabaseConfigSchedulerJobService;
    import com.alibaba.fastjson.JSONObject;
    import jakarta.annotation.Resource;
    import lombok.extern.slf4j.Slf4j;
    import org.apache.commons.collections.CollectionUtils;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.scheduling.annotation.Scheduled;
    import org.springframework.stereotype.Component;
    import software.amazon.awssdk.services.sqs.model.Message;

    import java.text.MessageFormat;
    import java.util.List;
    import java.util.Objects;

    /**
     * @author: yyt
     * 2025-08-18
     */
    @Slf4j
    @Component
    public class BudgetDatabaseJobWorker implements IdentityProvider {

        @Autowired
        private AmazonSqsSchedulerService amazonSqsSchedulerService;
        @Autowired
        private MailInternalService mailInternalService;
        @Autowired
        private IBudgetDatabaseConfigSchedulerJobService schedulerJobService;
        @Autowired
        private BudgetDatabaseExpirationNoticeTask budgetDatabaseExpirationNoticeTask;
        @Resource
        private CommonService commonService;

        /**
         * 定时消息的队列 url
         */
        @Value("${sqs.scheduler.queue-url.budget_database_scheduler}")
        private String schedulerUrl;

        /**
         * 消费功能队列任务
         *
         * @author yyt
         * @date 2025/8/18
         */
        @Scheduled(cron = "0 0/1 * * * ?", zone = "${default.timezone}")
        public void run() {
            List<Message> messages = amazonSqsSchedulerService.getMessagesBatch(schedulerUrl);
            if (CollectionUtils.isNotEmpty(messages)) {
                for (Message message : messages) {
                    // message为json字符串：{"jobId": "894bd865a742c84d9a74c190b1e3cb92"}, 该jobId 为 revenue_scheduler_job 表的id，该对应记录保存着任务的详细信息
                    // 警告: 执行任务的具体方法应该使用新的线程，而不是在本线程执行（要确保本线程不会被阻塞或异常退出）

                    BudgetDatabaseConfigSchedulerJob schedulerJob = null;
                    try {
                        JSONObject jsonObject = JSONObject.parseObject(message.body());
                        String jobId = (String) jsonObject.get(SchedulerCons.JOB_ID);
                        schedulerJob = schedulerJobService.getById(jobId);

                        if (Objects.nonNull(schedulerJob)) {
                            if (!commonService.checkPropertyEffectiveAndOpenFunction(schedulerJob.getPropertyId(), FunctionIdConstant.BUDGET_DATABASE)) {
                                return;
                            }

                            //获取分类
                            Integer category = schedulerJob.getCategory();
                            if (category.equals(BudgetDatabaseNotifyCons.EXPIRATION_NOTICE)) {
                                budgetDatabaseExpirationNoticeTask.notifyExpired(schedulerJob.getPropertyId());
                            }

                            //任务执行次数加1
                            schedulerJobService.plusRunTimes(jobId);
                        }
                    } catch (Exception e) {
                        log.error("SQS consume error[BudgetDatabaseJobWorker] - Message: {}; Exception: {}", message.body(), e.getMessage());
                        if (RateLimitUtils.tryAcquire(this)) {
                            sendAlertEmail(schedulerUrl, message.body(), schedulerJob, e.getMessage());
                        }
                    } finally {
                        // 删除消息
                        amazonSqsSchedulerService.deleteMessage(schedulerUrl, message.receiptHandle());
                    }
                }
                run();
            }
        }

        /**
         * 发送alertEmail
         *
         * @param schedulerUrl 定时任务调度URL
         * @param message      消息
         * @param schedulerJob 定时任务对象
         * @param exception    异常信息
         * @author yyt
         * @date 2025/8/18
         */
        public void sendAlertEmail(String schedulerUrl, String message, BudgetDatabaseConfigSchedulerJob schedulerJob, String exception) {
            // 主题
            String subject = "[Warning] - process BudgetDatabaseJobWorker";
            // 邮件内容
            String mailContent = MessageFormat.format("SQS url:{0}<br/>Message:{1}<br/>SchedulerJob:{2}<br/>Exception:{3}",
                    schedulerUrl, message, Objects.nonNull(schedulerJob) ? schedulerJob.toString() : "", exception);
            // 发送 alert
            mailInternalService.sendAlertEmail(subject, mailContent);
        }

        /**
         * 获取身份信息
         *
         * @return 身份信息
         * @author zc
         * @date 2024/4/12
         */
        @Override
        public String identity() {
            return this.getClass().getSimpleName();
        }

    }