ic-ctbu-backend/apis/Download/Admin/List.js

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

class AdminDownloadList extends API {
    constructor() {
        super();
        this.setPath('/Admin/Download/List');
        this.setMethod('GET');
    }

    async onRequest(req, res) {
        const { uuid, session } = req.query;
        if ([uuid, session].some(v => v === '' || v === null || v === undefined))
            return res.json({ ...BaseStdResponse.MISSING_PARAMETER });

        if (!await AccessControl.checkSession(uuid, session))
            return res.status(401).json({ ...BaseStdResponse.ACCESS_DENIED });

        const permission = await AccessControl.getPermission(uuid);
        if (!permission.includes('admin') && !permission.includes('service'))
            return res.json({ ...BaseStdResponse.PERMISSION_DENIED });

        const sql = `
            SELECT id, title, description, download_url, version, icon,
                   button_text, button_color, platform, extract_code,
                   changelog_html, sort_order, is_active, created_at, updated_at
            FROM download_item
            ORDER BY sort_order ASC, id ASC
        `;
        try {
            const rows = await db.query(sql);
            res.json({ ...BaseStdResponse.OK, data: rows || [] });
        } catch (err) {
            this.logger.error(`获取下载项列表失败！${err.stack}`);
            res.json({ ...BaseStdResponse.ERR, msg: '获取下载项列表失败！' });
        }
    }
}

module.exports.AdminDownloadList = AdminDownloadList;