const { models } = require('./db')

// 团购页面接口
const groupbuy = require('./interface/groupbuy')
// 异常行为报警页面接口
const abnormal = require('./interface/abnormal')
// 售后管理页面接口
const aftersales = require('./interface/aftersales')
// 下载量统计页面接口
const download = require('./interface/download')
// 订单管理页面接口
const order = require('./interface/order')
// 用户行为统计页面接口
const userstats = require('./interface/userstats')
// 付款统计页面接口
const payment = require('./interface/payment')
// 首页接口
const home = require('./interface/home')
// 课程接口
const recommend = require('./interface/recommend')

// 测试
async function getActiveByName(name) {
    const sql = 'SELECT * FROM lxpceshi WHERE name like {{name}}'
    const result = await models.$runSQL(sql, { name: `%${name}%` })
    return result.data.executeResultList;
}

module.exports = {
    getActiveByName,
    groupbuy,
    abnormal,
    aftersales,
    download,
    order,
    userstats,
    payment,
    home,
    recommend
}