Method approveRequest

server/src/db/join-request-db.ts:119–136

* Approve a join request

(id: string, handled_by_user_id: string)

   * Approve a join request
   */
  async approveRequest(id: string, handled_by_user_id: string): Promise<JoinRequest | null> {
    const result = await query<JoinRequest>(
      `UPDATE organization_join_requests
       SET status = 'approved', handled_by_user_id = $2, handled_at = NOW(), updated_at = NOW()
       WHERE id = $1 AND status = 'pending'
       RETURNING *`,
      [id, handled_by_user_id]
    );

    if (result.rows[0]) {
      logger.info({
        requestId: id,
        handledBy: handled_by_user_id
      }, 'Join request approved');
    }

    return result.rows[0] || null;
  }

  /**
   * Reject a join request