Function getPrivateChatMemberAvatar

packages/core/src/query/session-queries.ts:839–868

(
  db: DatabaseAdapter,
  sessionName: string,
  ownerId: string | null | undefined
)

 * Finds the "other" member (not the owner) in a private chat, falling back to name match or first with avatar.
 */
export function getPrivateChatMemberAvatar(
  db: DatabaseAdapter,
  sessionName: string,
  ownerId: string | null | undefined
): string | null {
  const members = db
    .prepare(
      `SELECT
        m.platform_id as platformId,
        COALESCE(m.group_nickname, m.account_name, m.platform_id) as name,
        m.avatar
      FROM member m
      WHERE COALESCE(m.account_name, '') != '系统消息'
      ORDER BY (SELECT COUNT(*) FROM message WHERE sender_id = m.id) DESC`
    )
    .all() as unknown as Array<{ platformId: string; name: string; avatar: string | null }>

  if (members.length === 0) return null

  if (ownerId) {
    const other = members.find((m) => m.platformId !== ownerId)
    if (other?.avatar) return other.avatar
  }

  const sameName = members.find((m) => m.name === sessionName)
  if (sameName?.avatar) return sameName.avatar

  const firstWithAvatar = members.find((m) => m.avatar)
  return firstWithAvatar?.avatar || null
}