22f073d8e7
- 前后端分离架构 (Nuxt 3 + Element Plus) - SQLite 数据库 (better-sqlite3) - 比赛项目管理 (田赛/径赛/团体赛) - 队伍管理 (5 个组别) - 成绩录入与积分统计 - 记分板展示 (排名/奖牌榜) - 移动端响应式适配 - 侧边栏布局 + 抽屉菜单 - 自动生成初始化数据接口
25 lines
433 B
TypeScript
25 lines
433 B
TypeScript
import db from '../../db'
|
|
|
|
export default defineEventHandler((event) => {
|
|
const query = getQuery(event)
|
|
const { group } = query
|
|
|
|
let sql = 'SELECT * FROM teams WHERE 1=1'
|
|
const params: any[] = []
|
|
|
|
if (group) {
|
|
sql += ' AND team_group = ?'
|
|
params.push(group)
|
|
}
|
|
|
|
sql += ' ORDER BY name ASC'
|
|
|
|
const stmt = db.prepare(sql)
|
|
const teams = stmt.all(...params)
|
|
|
|
return {
|
|
success: true,
|
|
data: teams
|
|
}
|
|
})
|