ic-ctbu-backend/apis/Corn/StartLepao.js

const API = require("../../lib/API");
const db = require('../../plugin/DataBase/db')
const Redis = require('../../plugin/DataBase/Redis')
const mq = require('../../plugin/mq')
const { BaseStdResponse } = require("../../BaseStdResponse")

// 出现异常情况时补充乐跑
class StartLepao extends API {
    constructor() {
        super();

        this.noEncrypt()
        this.setPath('/Corn/StartLepao');
        this.setMethod('GET');
    }

    async onRequest(req, res) {
        try {
            let { time } = req.query

            if ([time].some(value => value === '' || value === null || value === undefined))
                return res.json({
                    ...BaseStdResponse.MISSING_PARAMETER
                })

            res.json({
                ...BaseStdResponse.OK
            })

            this.logger.info('开始执行补充乐跑任务')

            const day = new Date().getDay()
            let sql = `
                        SELECT name, create_user, student_num, token, uid, school_id, state
                        FROM lepao_account
                        WHERE auto_run = 1
                            AND JSON_CONTAINS(auto_day, CAST(? AS JSON))
                            AND (auto_time = ? OR (auto_time = -1 AND today_auto_time = ?))
                        `
            let r = await db.query(sql, [day, time, time])
            if (!r)
                return this.logger.error('获取补充乐跑账号失败！')

            for (const item of r) {
                const { name, create_user, student_num, token, uid, school_id, state } = item
                this.logger.info(`${name}(${student_num})开始补充乐跑`)

                const isSuccess = await Redis.get(`lepaoSuccess:${student_num}`)
                if (isSuccess) {
                    this.logger.info(`${name}(${student_num})当天已乐跑成功，不执行补充乐跑`)
                    continue
                }

                try {
                    const channel = await mq.getChannel('lepao_corn')
                    await channel.assertQueue('task_queue', { durable: true })

                    const taskId = `lepao:repair:${Date.now()}:${student_num}`
                    const payload = {
                        id: taskId,
                        type: 'lepao.startRun',
                        data: {
                            taskId,
                            account: student_num
                        },
                        retry: 0
                    }

                    channel.sendToQueue(
                        'task_queue',
                        Buffer.from(JSON.stringify(payload)),
                        { persistent: true, contentType: 'application/json' }
                    )
                    this.logger.info(`${name}(${student_num})已投递补充乐跑任务`)
                } catch (err) {
                    this.logger.error(`${name}(${student_num})补充乐跑失败：${err.message || err}`)
                }
            }

            this.logger.info('补充乐跑任务执行完毕')
        } catch (error) {
            this.logger.error(error)
        }
    }
}

module.exports.StartLepao = StartLepao