= UseCase17 - Billing Admin Login / Authentication =

== Initiating Actor - `Billing Admin` ==

== Description ==
A billing administrator logs into the Medora system using their credentials. The admin gains access to billing administrative functions.

== Scenario ==

1. Administrator navigates to the Medora login page.

2. Administrator enters their username and password and submits the login form.

{{{
#!sql
SELECT
  u.user_id,
  u.username,
  u.password,
  u.role,
  u.first_name,
  u.last_name,
  u.is_active
FROM users u
WHERE u.username = 'admin_ilija'
  AND u.role = 'BILLING_ADMIN';
}}}

3. System verifies the account is active and the password matches.

{{{
#!sql
SELECT u.user_id
FROM users u
WHERE u.username = 'admin_ilija'
  AND u.is_active = TRUE
  AND u.role = 'BILLING_ADMIN';
}}}

4. System retrieves the linked admin profile.

{{{
#!sql
SELECT
  a.admin_id,
  a.username,
  a.name,
  a.lastname,
  a.email
FROM admin a
JOIN users u ON u.admin_id = a.admin_id
WHERE u.username = 'admin_ilija';
}}}

5. Administrator is authenticated and redirected to the admin dashboard.