# secdevansuraj2026/cdr-report-analyzer architecture

> Architecture diagram of the GitHub repository secdevansuraj2026/cdr-report-analyzer, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-16). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/secdevansuraj2026/cdr-report-analyzer
- Repository: https://github.com/secdevansuraj2026/cdr-report-analyzer

## Overview

CDR Report Analyzer is a browser-only investigation tool: an investigator enters case details, uploads a CDR spreadsheet, inspects the parsed records, runs a telecom-analysis query, and can export the displayed results. The graph keeps upload/routing, shared case data and sheet inspection, query analysis, and reusable presentation/formatting distinct. README documentation supports the overall workflow and Excel parsing/export; sampled source confirms routing, query inputs, analysis calls, and shared-state use. Some filter modules are indexed but not excerpted, so their individual query behavior is not detailed here.

Main entry points: [`src/pages/QueryResult.jsx`](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/pages/QueryResult.jsx) (Query execution), [`src/cdrFilter/utils.js`](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/utils.js) (CDR field helpers), [`src/App.jsx`](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/App.jsx) (Page routing), [`src/Sheet.jsx`](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/Sheet.jsx) (Sheet dashboard)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_workflow["Case workflow"]
  node_upload["Case and upload<br/>[App.jsx]"]
  node_routes["Page routing<br/>[App.jsx]"]
  node_case_state["Case data state<br/>[DataContext.jsx]"]
  node_about["About page<br/>[About.jsx]"]
  node_guide["User guide<br/>[UserGuide.jsx]"]
  node_contact["Contact page<br/>[Contact.jsx]"]
end

subgraph group_inspection["Data inspection"]
  node_sheet["Sheet dashboard<br/>[Sheet.jsx]"]
end

subgraph group_analysis["CDR analysis"]
  node_query_input["Query parameters<br/>[QueryInput.jsx]"]
  node_query_result["Query execution<br/>[QueryResult.jsx]"]
  node_frequent["Frequent contacts<br/>[frequentContact.js]"]
  node_duration["Duration filters<br/>[durationFilter.js]"]
  node_imei["IMEI tracking<br/>[imeiTracking.js]"]
  node_imsi["IMSI analysis<br/>[imsiAnalysis.js]"]
  node_location["Location analysis<br/>[locationBTS.js]"]
  node_max_duration["Maximum duration<br/>[maxCallDuration.js]"]
  node_time_pattern["Time patterns<br/>[timePattern.js]"]
  node_filter_utils["CDR field helpers<br/>[utils.js]"]
end

subgraph group_shared["Shared presentation"]
  node_table["Reusable table<br/>[ReusableTable.jsx]"]
  node_report_utils["Formatting utilities<br/>[reportUtils.js]"]
  node_row_key["Highlight row keys<br/>[rowKey.js]"]
end

node_investigator(("Investigator"))
node_xlsx["SheetJS"]

node_investigator -->|"enters and uploads"| node_upload
node_upload -->|"parses workbook"| node_xlsx
node_upload -->|"stores parsed data"| node_case_state
node_upload -->|"navigates to sheet"| node_routes
node_routes -->|"routes to"| node_sheet
node_routes -->|"routes to"| node_query_result
node_routes -->|"routes to"| node_about
node_routes -->|"routes to"| node_guide
node_routes -->|"routes to"| node_contact
node_sheet -->|"reads and updates"| node_case_state
node_sheet -->|"renders rows"| node_table
node_sheet -->|"exports workbook"| node_xlsx
node_investigator -->|"sets parameters"| node_query_input
node_query_result -->|"renders inputs"| node_query_input
node_query_result -->|"reads records"| node_case_state
node_query_result -->|"runs analysis"| node_frequent
node_query_result -->|"runs analysis"| node_duration
node_query_result -->|"runs analysis"| node_imei
node_query_result -->|"runs analysis"| node_imsi
node_query_result -->|"runs analysis"| node_location
node_query_result -->|"runs analysis"| node_max_duration
node_query_result -->|"runs analysis"| node_time_pattern
node_query_result -->|"renders results"| node_table
node_query_result -->|"builds highlight keys"| node_row_key
node_query_result -->|"exports results"| node_xlsx
node_frequent -->|"reads normalized fields"| node_filter_utils
node_duration -->|"reads normalized fields"| node_filter_utils
node_imei -->|"reads normalized fields"| node_filter_utils
node_imsi -->|"reads normalized fields"| node_filter_utils
node_location -->|"reads normalized fields"| node_filter_utils
node_max_duration -->|"reads normalized fields"| node_filter_utils
node_time_pattern -->|"reads normalized fields"| node_filter_utils
node_filter_utils -->|"parses dates and durations"| node_report_utils
node_table -->|"sanitizes display rows"| node_report_utils
node_row_key -->|"reads row fields"| node_filter_utils
node_row_key -->|"parses row dates"| node_report_utils

click node_upload "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/App.jsx"
click node_routes "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/App.jsx"
click node_case_state "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/DataContext.jsx"
click node_sheet "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/Sheet.jsx"
click node_query_input "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/pages/QueryInput.jsx"
click node_query_result "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/pages/QueryResult.jsx"
click node_frequent "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/frequentContact.js"
click node_duration "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/durationFilter.js"
click node_imei "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/imeiTracking.js"
click node_imsi "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/imsiAnalysis.js"
click node_location "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/locationBTS.js"
click node_max_duration "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/maxCallDuration.js"
click node_time_pattern "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/timePattern.js"
click node_filter_utils "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/utils.js"
click node_table "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/components/ReusableTable.jsx"
click node_report_utils "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/utils/reportUtils.js"
click node_row_key "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/utils/rowKey.js"
click node_about "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/pages/About.jsx"
click node_guide "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/pages/UserGuide.jsx"
click node_contact "https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/pages/Contact.jsx"

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_upload,node_routes,node_case_state,node_about,node_guide,node_contact toneBlue
class node_sheet toneAmber
class node_query_input,node_query_result,node_frequent,node_duration,node_imei,node_imsi,node_location,node_max_duration,node_time_pattern,node_filter_utils toneMint
class node_table,node_report_utils,node_row_key toneRose
class node_investigator,node_xlsx toneIndigo
```

## Components

### Case workflow

- [Case and upload](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/App.jsx): `src/App.jsx`
- [Page routing](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/App.jsx): `src/App.jsx`
- [Case data state](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/DataContext.jsx): `src/DataContext.jsx`
- [About page](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/pages/About.jsx): `src/pages/About.jsx`
- [User guide](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/pages/UserGuide.jsx): `src/pages/UserGuide.jsx`
- [Contact page](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/pages/Contact.jsx): `src/pages/Contact.jsx`

### Data inspection

- [Sheet dashboard](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/Sheet.jsx): `src/Sheet.jsx`

### CDR analysis

- [Query parameters](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/pages/QueryInput.jsx): `src/pages/QueryInput.jsx`
- [Query execution](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/pages/QueryResult.jsx): `src/pages/QueryResult.jsx`
- [Frequent contacts](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/frequentContact.js): `src/cdrFilter/frequentContact.js`
- [Duration filters](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/durationFilter.js): `src/cdrFilter/durationFilter.js`
- [IMEI tracking](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/imeiTracking.js): `src/cdrFilter/imeiTracking.js`
- [IMSI analysis](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/imsiAnalysis.js): `src/cdrFilter/imsiAnalysis.js`
- [Location analysis](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/locationBTS.js): `src/cdrFilter/locationBTS.js`
- [Maximum duration](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/maxCallDuration.js): `src/cdrFilter/maxCallDuration.js`
- [Time patterns](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/timePattern.js): `src/cdrFilter/timePattern.js`
- [CDR field helpers](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/cdrFilter/utils.js): `src/cdrFilter/utils.js`

### Shared presentation

- [Reusable table](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/components/ReusableTable.jsx): `src/components/ReusableTable.jsx`
- [Formatting utilities](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/utils/reportUtils.js): `src/utils/reportUtils.js`
- [Highlight row keys](https://github.com/secdevansuraj2026/cdr-report-analyzer/blob/main/src/utils/rowKey.js): `src/utils/rowKey.js`

### Other components

- **Investigator**
- **SheetJS**

## Connections

- Investigator → Case and upload: enters and uploads (evidence: `README.md`)
- Case and upload → SheetJS: parses workbook (evidence: `README.md`)
- Case and upload → Case data state: stores parsed data (evidence: `README.md`)
- Case and upload → Page routing: navigates to sheet (evidence: `README.md`)
- Page routing → Sheet dashboard: routes to (evidence: `src/App.jsx`)
- Page routing → Query execution: routes to (evidence: `src/App.jsx`)
- Page routing → About page: routes to (evidence: `src/App.jsx`)
- Page routing → User guide: routes to (evidence: `src/App.jsx`)
- Page routing → Contact page: routes to (evidence: `src/App.jsx`)
- Sheet dashboard → Case data state: reads and updates (evidence: `src/Sheet.jsx`)
- Sheet dashboard → Reusable table: renders rows (evidence: `src/Sheet.jsx`)
- Sheet dashboard → SheetJS: exports workbook (evidence: `README.md`)
- Investigator → Query parameters: sets parameters (evidence: `README.md`)
- Query execution → Query parameters: renders inputs (evidence: `src/pages/QueryResult.jsx`)
- Query execution → Case data state: reads records (evidence: `src/pages/QueryResult.jsx`)
- Query execution → Frequent contacts: runs analysis (evidence: `src/pages/QueryResult.jsx`)
- Query execution → Duration filters: runs analysis (evidence: `src/pages/QueryResult.jsx`)
- Query execution → IMEI tracking: runs analysis (evidence: `src/pages/QueryResult.jsx`)
- Query execution → IMSI analysis: runs analysis (evidence: `src/pages/QueryResult.jsx`)
- Query execution → Location analysis: runs analysis (evidence: `src/pages/QueryResult.jsx`)
- Query execution → Maximum duration: runs analysis (evidence: `src/pages/QueryResult.jsx`)
- Query execution → Time patterns: runs analysis (evidence: `src/pages/QueryResult.jsx`)
- Query execution → Reusable table: renders results (evidence: `src/pages/QueryResult.jsx`)
- Query execution → Highlight row keys: builds highlight keys (evidence: `src/pages/QueryResult.jsx`)
- Query execution → SheetJS: exports results (evidence: `README.md`)
- Frequent contacts → CDR field helpers: reads normalized fields (evidence: `src/cdrFilter/frequentContact.js`)
- Duration filters → CDR field helpers: reads normalized fields (evidence: `src/cdrFilter/durationFilter.js`)
- IMEI tracking → CDR field helpers: reads normalized fields (evidence: `src/cdrFilter/imeiTracking.js`)
- IMSI analysis → CDR field helpers: reads normalized fields (evidence: `src/cdrFilter/imsiAnalysis.js`)
- Location analysis → CDR field helpers: reads normalized fields (evidence: `src/cdrFilter/locationBTS.js`)
- Maximum duration → CDR field helpers: reads normalized fields (evidence: `src/cdrFilter/maxCallDuration.js`)
- Time patterns → CDR field helpers: reads normalized fields (evidence: `src/cdrFilter/timePattern.js`)
- CDR field helpers → Formatting utilities: parses dates and durations (evidence: `src/cdrFilter/utils.js`)
- Reusable table → Formatting utilities: sanitizes display rows (evidence: `src/components/ReusableTable.jsx`)
- Highlight row keys → CDR field helpers: reads row fields (evidence: `src/utils/rowKey.js`)
- Highlight row keys → Formatting utilities: parses row dates (evidence: `src/utils/rowKey.js`)
