# redabuziane/qa-account-finder-web- architecture

> Architecture diagram of the GitHub repository redabuziane/qa-account-finder-web-, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-18). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/redabuziane/qa-account-finder-web-
- Repository: https://github.com/redabuziane/qa-account-finder-web-

## Overview

QA Account Finder is a Spring web application for searching account records and changing their availability. Users search and select accounts in the browser; search requests are translated into criteria, matched against loaded account data, and returned for display. Reservation or release actions update availability and persist the workbook. The sources also show Excel-backed storage and local preference settings. Relationships are limited to calls and data flows visible in the excerpts; the UI template and configuration wiring were not sampled.

Main entry points: [`src/main/java/com/team/accountfinder/repository/ExcelAccountRepository.java`](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/repository/ExcelAccountRepository.java) (Excel repository), [`src/main/java/com/team/accountfinder/controller/AccountApiController.java`](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/controller/AccountApiController.java) (Account API), [`src/main/java/com/team/accountfinder/service/AccountService.java`](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/service/AccountService.java) (Search and availability), [`src/main/resources/static/js/app.js`](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/resources/static/js/app.js) (Search and account UI)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Web interface"]
  node_browser["Search and account UI<br/>[app.js]"]
  node_page["Account page<br/>[index.html]"]
end

subgraph group_api["Request handling"]
  node_webroute["Home route"]
  node_api["Account API"]
  node_runtime["Spring Boot runtime"]
end

subgraph group_domain["Account domain"]
  node_criteria["Search criteria"]
  node_service["Search and availability"]
  node_account["Account record<br/>[Account.java]"]
end

subgraph group_storage["Workbook persistence"]
  node_repository["Excel repository"]
  node_mapper["Excel column mapping"]
  node_fileservice["Workbook file setup"]
  node_workbook[("Account workbook<br/>[accounts.xlsx]")]
  node_exception["Repository errors"]
end

subgraph group_settings["Local settings"]
  node_preferences[("Application preferences")]
end

node_user(("Account user"))

node_user -->|"uses"| node_browser
node_browser -->|"requests search"| node_api
node_api -->|"builds criteria"| node_criteria
node_api -->|"delegates search"| node_service
node_service -->|"loads and updates"| node_repository
node_service -->|"matches against"| node_criteria
node_repository -->|"maps columns"| node_mapper
node_repository -->|"creates records"| node_account
node_repository -->|"reads and writes"| node_workbook
node_service -->|"gets workbook path"| node_fileservice
node_fileservice -->|"seeds from resource"| node_workbook
node_repository -->|"throws"| node_exception
node_fileservice -->|"throws"| node_exception
node_user -->|"opens"| node_page
node_webroute -->|"returns view"| node_page
node_browser -->|"updates availability"| node_api
node_runtime -.->|"registers routes"| node_webroute
node_runtime -.->|"registers routes"| node_api

click node_browser "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/resources/static/js/app.js"
click node_page "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/resources/templates/index.html"
click node_webroute "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/controller/AccountController.java"
click node_api "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/controller/AccountApiController.java"
click node_criteria "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/model/SearchCriteria.java"
click node_service "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/service/AccountService.java"
click node_account "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/model/Account.java"
click node_repository "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/repository/ExcelAccountRepository.java"
click node_mapper "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/util/ExcelColumnMapper.java"
click node_fileservice "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/service/ExcelFileService.java"
click node_workbook "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/resources/data/accounts.xlsx"
click node_exception "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/exception/AccountRepositoryException.java"
click node_preferences "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/config/ApplicationConfig.java"
click node_runtime "https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/accountfinder/QaAccountFinderWebApplication.java"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_browser,node_page,node_user toneBlue
class node_webroute,node_api,node_runtime toneAmber
class node_criteria,node_service,node_account toneMint
class node_repository,node_mapper,node_fileservice,node_workbook,node_exception toneRose
class node_preferences toneIndigo
```

## Components

### Web interface

- [Search and account UI](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/resources/static/js/app.js): `src/main/resources/static/js/app.js`
- [Account page](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/resources/templates/index.html): `src/main/resources/templates/index.html`

### Request handling

- [Home route](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/controller/AccountController.java): `src/main/java/com/team/accountfinder/controller/AccountController.java`
- [Account API](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/controller/AccountApiController.java): `src/main/java/com/team/accountfinder/controller/AccountApiController.java`
- [Spring Boot runtime](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/accountfinder/QaAccountFinderWebApplication.java): `src/main/java/accountfinder/QaAccountFinderWebApplication.java`

### Account domain

- [Search criteria](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/model/SearchCriteria.java): `src/main/java/com/team/accountfinder/model/SearchCriteria.java`
- [Search and availability](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/service/AccountService.java): `src/main/java/com/team/accountfinder/service/AccountService.java`
- [Account record](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/model/Account.java): `src/main/java/com/team/accountfinder/model/Account.java`

### Workbook persistence

- [Excel repository](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/repository/ExcelAccountRepository.java): `src/main/java/com/team/accountfinder/repository/ExcelAccountRepository.java`
- [Excel column mapping](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/util/ExcelColumnMapper.java): `src/main/java/com/team/accountfinder/util/ExcelColumnMapper.java`
- [Workbook file setup](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/service/ExcelFileService.java): `src/main/java/com/team/accountfinder/service/ExcelFileService.java`
- [Account workbook](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/resources/data/accounts.xlsx): `src/main/resources/data/accounts.xlsx`
- [Repository errors](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/exception/AccountRepositoryException.java): `src/main/java/com/team/accountfinder/exception/AccountRepositoryException.java`

### Local settings

- [Application preferences](https://github.com/redabuziane/qa-account-finder-web-/blob/main/src/main/java/com/team/accountfinder/config/ApplicationConfig.java): `src/main/java/com/team/accountfinder/config/ApplicationConfig.java`

### Other components

- **Account user**

## Connections

- Account user → Search and account UI: uses
- Search and account UI → Account API: requests search (evidence: `src/main/resources/static/js/app.js`)
- Account API → Search criteria: builds criteria (evidence: `src/main/java/com/team/accountfinder/controller/AccountApiController.java`)
- Account API → Search and availability: delegates search (evidence: `src/main/java/com/team/accountfinder/controller/AccountApiController.java`)
- Search and availability → Excel repository: loads and updates (evidence: `src/main/java/com/team/accountfinder/service/AccountService.java`)
- Search and availability → Search criteria: matches against (evidence: `src/main/java/com/team/accountfinder/service/AccountService.java`)
- Excel repository → Excel column mapping: maps columns (evidence: `src/main/java/com/team/accountfinder/repository/ExcelAccountRepository.java`)
- Excel repository → Account record: creates records (evidence: `src/main/java/com/team/accountfinder/repository/ExcelAccountRepository.java`)
- Excel repository → Account workbook: reads and writes (evidence: `src/main/java/com/team/accountfinder/repository/ExcelAccountRepository.java`)
- Search and availability → Workbook file setup: gets workbook path (evidence: `src/main/java/com/team/accountfinder/service/AccountService.java`)
- Workbook file setup → Account workbook: seeds from resource (evidence: `src/main/java/com/team/accountfinder/service/ExcelFileService.java`)
- Excel repository → Repository errors: throws (evidence: `src/main/java/com/team/accountfinder/repository/ExcelAccountRepository.java`)
- Workbook file setup → Repository errors: throws (evidence: `src/main/java/com/team/accountfinder/service/ExcelFileService.java`)
- Account user → Account page: opens
- Home route → Account page: returns view (evidence: `src/main/java/com/team/accountfinder/controller/AccountController.java`)
- Search and account UI → Account API: updates availability (evidence: `src/main/resources/static/js/app.js`)
- Spring Boot runtime → Home route: registers routes
- Spring Boot runtime → Account API: registers routes
