Function getMembers

packages/core/src/query/message-queries.ts:293–308

(
  db: DatabaseAdapter
)

 * 获取成员列表
 */
export function getMembers(
  db: DatabaseAdapter
): Array<{ id: number; platformId: string; name: string; messageCount: number }> {
  return db
    .prepare(
      `SELECT
        m.id as id,
        m.platform_id as platformId,
        COALESCE(m.group_nickname, m.account_name, m.platform_id) as name,
        (SELECT COUNT(*) FROM message WHERE sender_id = m.id) as messageCount
      FROM member m
      WHERE COALESCE(m.account_name, '') != '系统消息'
      ORDER BY messageCount DESC`
    )
    .all() as Array<{ id: number; platformId: string; name: string; messageCount: number }>
}

export interface MemberDetailed {
  id: number