o `pji @srdZddlZddlZddlmZejZdddZdeefdd Z d e deefd d Z d e dedBfddZ dS)u2活动数据读取（bot 写入，web 只读）。N)configcCsBtt}tj|_zdd|||DW|S|w)NcSsg|]}t|qSr)dict).0rrr=/home/dore/onebot/Bot_Ero/checkin_gallery/activity_service.py sz_rows..)sqlite3connectDB_PATHRow row_factoryexecutefetchallclose)sqlparamsconnrrr_rows s rreturncCs6td}|D]}|ddvrtd|df|d<q|S)u[全部活动：进行中（open/running）在前且附成员列表，归档/取消在后。aSELECT a.id, a.type, a.title, a.description, a.status, a.group_id, a.signup_deadline, a.deadline, a.hours_per_user, a.created_at, a.finished_at, (SELECT COUNT(*) FROM activity_members m WHERE m.activity_id = a.id) AS member_count, (SELECT COUNT(*) FROM activity_members m WHERE m.activity_id = a.id AND m.status = 'done') AS done_count FROM activities a ORDER BY CASE a.status WHEN 'open' THEN 0 WHEN 'running' THEN 1 ELSE 2 END, a.id DESCstatus)openrunningzbSELECT user_id, nickname, seq, status FROM activity_members WHERE activity_id = ? ORDER BY seq ASCidmembers)r)actsactrrrlist_activitiess ruser_idcCstdt|fS)uH当前用户参加过的全部活动（含自己在其中的状态）。aSELECT a.id, a.type, a.title, a.status, a.signup_deadline, a.deadline, a.finished_at, m.status AS my_status, m.seq AS my_seq, m.submitted_at AS my_submitted_at, (SELECT COUNT(*) FROM activity_members mm WHERE mm.activity_id = a.id) AS member_count, (SELECT COUNT(*) FROM activity_members mm WHERE mm.activity_id = a.id AND mm.status = 'done') AS done_count FROM activities a JOIN activity_members m ON m.activity_id = a.id WHERE m.user_id = ? ORDER BY a.id DESC)rstr)rrrrget_my_activities'sr activity_idc Cstd|f}|s dS|d}td|f|d<|dD]#}z|dr)t|dng|d<Wqttfy=g|d<Yqw|S)Nz%SELECT * FROM activities WHERE id = ?rzSELECT user_id, nickname, seq, status, submitted_at, content, images FROM activity_members WHERE activity_id = ? ORDER BY seq ASCrimages)rgetjsonloads TypeError ValueError)r!rowsrmrrr get_activity6s  $ r*)r)__doc__r$r checkin_galleryrr rlistrrrr intr*rrrrs