Method rejectRequest

server/src/db/join-request-db.ts:141–159

* Reject a join request

(id: string, handled_by_user_id: string, reason?: string)

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

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

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

  /**
   * Cancel a join request (by the user who made it)