Administration is a sectioned page with a left-hand menu e8e7158bbc73

/// A page of the audit log, newest first, older than `before` (an id) when given.

pub async fn audit_page(pool: &Pool, before: Option<i64>, limit: i64) -> sqlx::Result<Vec<AuditRow>> {

    sqlx::query_as("SELECT id, at_ms, actor, action, target, detail FROM audit WHERE (? IS NULL OR id < ?) ORDER BY id DESC LIMIT ?")

        .bind(before)

        .bind(before)

        .bind(limit)

        .fetch_all(pool)

        .await

}

    /// The audit log's next page: rows older than this id (#110).

    audit_older: Option<i64>,

    admin_page_at(app, shell, notice, None).await

}

/// The audit log shows this many rows a page.

const AUDIT_PAGE: i64 = 50;

async fn admin_page_at(app: &Shared, shell: Shell, notice: Option<String>, audit_before: Option<i64>) -> Result<Page<AdminPage>, Error> {

    let mut audit = accounts::audit_page(&app.db, audit_before, AUDIT_PAGE + 1).await.map_err(e)?;

    let audit_older = if audit.len() as i64 > AUDIT_PAGE {

        audit.truncate(AUDIT_PAGE as usize);

        audit.last().map(|r| r.id)

    } else {

        None

    };

        audit_older,

#[derive(Deserialize)]

pub struct IndexQuery {

    audit_before: Option<i64>,

}

pub async fn index(

    State(app): State<Shared>,

    viewer: Viewer,

    axum::extract::Query(q): axum::extract::Query<IndexQuery>,

) -> Result<Page<AdminPage>, Error> {

    admin_page_at(&app, shell, None, q.audit_before).await

#[tokio::test(flavor = "multi_thread")]

async fn administration_is_sectioned_and_its_audit_log_pages() {

    let h = hub().await;

    let app = &h.app;

    let andy = register(app, "andy", "").await;

    let andy_row = db::accounts::account_by_name(&app.db, "andy").await.unwrap().unwrap();

    for i in 0..60 {

        db::accounts::audit(&app.db, Some(&andy_row), "test.event", &format!("t{i}"), "").await.unwrap();

    }

    let page = get(app, "/admin", Some(&andy)).await.body;

    for id in ["accounts", "registration", "organisations", "signin", "mail", "variables", "secrets", "assistants", "audit"] {

        assert!(page.contains(&format!("href=\"#{id}\"")) && page.contains(&format!("id=\"{id}\"")), "section {id}: {page}");

    }

    assert!(page.contains("class=\"section-nav\""));

    assert!(page.contains(">t59<") && !page.contains(">t5<"), "the newest page only");

    let i = page.find("audit_before=").expect("an older link") + "audit_before=".len();

    let before: String = page[i..].chars().take_while(|c| c.is_ascii_digit()).collect();

    let older = get(app, &format!("/admin?audit_before={before}"), Some(&andy)).await.body;

    assert!(older.contains(">t5<") && !older.contains(">t59<"), "the next page: {older}");

}

<div class="sectioned">

<nav class="section-nav" aria-label="Sections">

  <a href="#accounts">Accounts</a>

  <a href="#registration">Registration</a>

  <a href="#organisations">Organisations</a>

  <a href="#signin">Sign in with</a>

  <a href="#mail">Mail</a>

  <a href="#variables">Variables</a>

  <a href="#secrets">Secrets</a>

  <a href="#assistants">AI assistants</a>

  <a href="#audit">Audit log</a>

  <a href="/admin/runners">Runners ↗</a>

  <a href="/admin/storage">Storage and maintenance ↗</a>

</nav>

<div class="sections">

<section class="panel" id="accounts">

  <div class="table"><table class="small"><tr><th>Username</th><th>Email</th><th>Flags</th><th>Last seen</th><th></th></tr>

  </table></div>

<section class="panel" id="registration">

  <h2>Registration and invitations</h2>

    <label for="regmode">Who may register</label>

    <select id="regmode" name="mode">{% for m in ["open", "invite", "closed"] %}<option value="{{ m }}"{% if mode.as_str() == *m %} selected{% endif %}>{{ m }}</option>{% endfor %}</select>

  {% if !invitations.is_empty() %}<ul class="plain small">{% for (code, used, at) in invitations %}<li><code>{{ code }}</code> {% if used.is_some() %}<span class="mute">used</span>{% else %}<a href="/register?invite={{ code }}">link</a>{% endif %} · {{ at|ago_i }}</li>{% endfor %}</ul>{% endif %}

</section>

<section class="panel" id="organisations">

  <h2>Organisations</h2>

  {% if orgs.is_empty() %}<p class="mute small">None yet.</p>{% else %}<ul class="plain">{% for o in orgs %}<li><img class="avatar xs" src="/avatar/{{ o.name }}" alt=""> <a href="/{{ o.name }}">{{ o.name }}</a> · <a class="small" href="/orgs/{{ o.name }}/settings">settings</a></li>{% endfor %}</ul>{% endif %}

</section>

<section class="panel" id="signin">

  <h2>Sign in with</h2>

  <p class="small mute">A first sign-in links the account with the same verified email, or makes an account when registration is open. Secrets are kept sealed.</p>

    <h3>{{ p.name }} {% if p.enabled && p.has_secret && !p.client_id.is_empty() %}<span class="tag head">on</span>{% else %}<span class="tag dim">off</span>{% endif %}</h3>

</section>

<section class="panel" id="mail">

  <h2>Mail</h2>

    <label for="smtp">SMTP URL</label>

    <input type="text" id="smtp" name="smtp" value="{{ mail_smtp }}" placeholder="smtps://user:[email protected]:465">

    <label for="mailfrom">From</label>

    <input type="text" id="mailfrom" name="from" value="{{ mail_from }}" placeholder="OxygenHub &lt;[email protected]&gt;">

</section>

<section class="panel" id="audit">

  <h2>Audit log</h2>

  <div class="table"><table class="small"><tr><th>When</th><th>Who</th><th>Action</th><th>Target</th><th>Detail</th></tr>

  {% for r in audit %}<tr><td><time title="{{ r.at_ms|when_i }}">{{ r.at_ms|ago_i }}</time></td><td>{{ r.actor }}</td><td><code>{{ r.action }}</code></td><td>{{ r.target }}</td><td class="mute">{{ r.detail }}</td></tr>{% endfor %}

  </table></div>

  <p class="pager small"><a href="/admin#audit">newest</a>{% if let Some(o) = audit_older %} <a class="go small" href="/admin?audit_before={{ o }}#audit">older</a>{% endif %}</p>

</section>

</div>

</div>