# kanav-arora/financify architecture

> Architecture diagram of the GitHub repository kanav-arora/financify, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-07-09). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/kanav-arora/financify
- Repository: https://github.com/kanav-arora/financify

## Overview

##### Project type and purpose
- Financify is a monolithic, full-stack desktop accounting application.
- Front-end: Java Swing GUI (multiple frames for register, login, main dashboard, items, ledger, sale/purchase invoices, vouchers, analysis).
- Back-end: Java business-logic and data-access layers using JDBC to a MySQL database.
- Build & deploy: Apache Ant (build.xml), NetBeans project.

##### File structure
- /Financify/src/Frames → all Swing UI classes and .form definitions
- /Financify/src/Data → utility classes (Excel export)
- /Financify/lib → third-party JARs (mysql-connector, Apache POI, JFreeChart, jCalendar, etc.)
- /db → SQL schema/dump files for MySQL
- build.xml & nbproject → Ant and NetBeans build configurations

##### Main components
A. Presentation Layer (UI)
- RegisterFrame, LoginFrame, MainFrame, ItemsFrame, LedgerAccountsFrame, TrialBalanceFrame, SaleFrame, PurchaseFrame, VoucherFrame, AnalysisFrame
- Uses Swing components (JPanel, JTable, JComboBox, etc.)
B. Business Logic Layer
- Controller classes embedded in each Frame or in Data/Excel.java
- Validation (e.g., regex in Register/Login), invoice generation, balance calculations
C. Data Access Layer (DAL)
- JDBC utility code (java.sql.*)
- DAO or direct SQL in Frame code invoking mysql-connector-java
D. Database
- MySQL instance
- Tables: users, accounts, items, stocks, transactions, vouchers, etc. (see db/*.sql and database.dbml)
E. External Libraries/Services
- Apache POI (Excel export)
- JFreeChart (graphical analysis)
- jCalendar (date pickers)
- MySQL Connector/J (JDBC driver)

##### Relationships and interactions
- UI Layer → invokes Business Logic → calls Data Access Layer → communicates with MySQL DB
- UI Layer → directly uses external libs for charts and Excel export
- Build tool (Ant) packages UI + logic + libs into a runnable JAR

##### Architectural patterns and design principles
- Layered architecture (Presentation → Logic → Data)
- MVC-style separation (Swing views, embedded controllers, data models in DB & Data package)
- Single deployment unit (desktop application)

##### Technologies/Frameworks to annotate
- Java Swing (javax.swing.*)
- JDBC (java.sql) with MySQL Connector/J
- Apache POI (org.apache.poi.*)
- JFreeChart (org.jfree.chart.*)
- jCalendar (com.toedter.calendar.*)
- Apache Ant (build.xml)

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Build & Deployment
    Build["Ant build.xml & NetBeans project"]:::build
    Build -->|"packages into JAR"| DesktopApp

    %% Desktop Application Container
    subgraph "Desktop Application"
        direction TB

        %% Presentation Layer
        subgraph "Presentation Layer"
            direction TB
            RegisterFrame["RegisterFrame UI"]:::ui
            LoginFrame["LoginFrame UI"]:::ui
            MainFrame["MainFrame UI (Dashboard)"]:::ui
            ItemsFrame["ItemsFrame UI (Stocks)"]:::ui
            LedgerAccountsFrame["LedgerAccountsFrame UI"]:::ui
            TrialBalanceFrame["TrialBalanceFrame UI"]:::ui
            SaleFrame["SaleFrame UI"]:::ui
            SaleLedgerFrame["SaleLedgerFrame UI"]:::ui
            PurchaseFrame["PurchaseFrame UI"]:::ui
            PurchaseLedgerFrame["PurchaseLedgerFrame UI"]:::ui
            VoucherFrame["VoucherFrame UI"]:::ui
            AnalysisFrame["AnalysisFrame UI"]:::ui
            AccountSetup["AccountSetup UI"]:::ui
            AccDeleteConfirm["Acc_Delete_Confirm UI"]:::ui
        end

        %% Business Logic Layer
        subgraph "Business Logic Layer"
            direction TB
            ExcelUtil["Excel Export Utility (Data/Excel.java)"]:::logic
        end

        %% Data Access Layer
        subgraph "Data Access Layer"
            direction TB
            JDBCCalls["JDBC & SQL Calls in Frames"]:::data
            MySQLConnector["MySQL Connector/J Jar"]:::data
        end
    end

    %% Database
    MySQLDB["MySQL Database\n(users, transactions, vouchers, etc.)"]:::db

    %% External Libraries
    ApachePOI["Apache POI JARs"]:::ext
    JFreeChart["JFreeChart JARs"]:::ext
    JCalendar["jCalendar JAR"]:::ext

    %% Relationships
    RegisterFrame -->|"invoke logic"| ExcelUtil
    LoginFrame -->|"validate credentials"| JDBCCalls
    MainFrame -->|"generate dashboard data"| JDBCCalls
    ItemsFrame -->|"load/update items"| JDBCCalls
    LedgerAccountsFrame -->|"fetch ledger"| JDBCCalls
    TrialBalanceFrame -->|"calculate trial balance"| JDBCCalls
    SaleFrame -->|"create sale invoice"| JDBCCalls
    PurchaseFrame -->|"create purchase invoice"| JDBCCalls
    VoucherFrame -->|"issue voucher"| JDBCCalls
    AnalysisFrame -->|"render charts"| JFreeChart
    AnalysisFrame -->|"export to Excel"| ExcelUtil

    ExcelUtil -->|"writes Excel via POI"| ApachePOI
    ExcelUtil -->|"called by UI"| JDBCCalls

    JDBCCalls -->|"DB operations"| MySQLDB
    MySQLConnector -->|"driver for JDBC"| JDBCCalls

    %% External libs usage
    ApachePOI --- ExcelUtil
    JFreeChart --- AnalysisFrame
    JCalendar --- RegisterFrame

    %% Click Events
    click RegisterFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Register.java"
    click LoginFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Login.java"
    click MainFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Main.java"
    click ItemsFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Stocks.java"
    click LedgerAccountsFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/LedgerAccounts.java"
    click TrialBalanceFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Trial_Balance.java"
    click SaleFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Sale.java"
    click SaleLedgerFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Sale_Ledger.java"
    click PurchaseFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Purchase.java"
    click PurchaseLedgerFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Purchase_Ledger.java"
    click VoucherFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Vouchers.java"
    click AnalysisFrame "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Analysis.java"
    click AccountSetup "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/AccountSetup.java"
    click AccDeleteConfirm "https://github.com/kanav-arora/financify/blob/main/Financify/src/Frames/Acc_Delete_Confirm.java"
    click ExcelUtil "https://github.com/kanav-arora/financify/blob/main/Financify/src/Data/Excel.java"
    click MySQLConnector "https://github.com/kanav-arora/financify/blob/main/Financify/lib/mysql-connector-java-8.0.24.jar"
    click MySQLDB "https://github.com/kanav-arora/financify/blob/main/database.dbml"
    click ApachePOI "https://github.com/kanav-arora/financify/tree/main/Financify/lib/"
    click JFreeChart "https://github.com/kanav-arora/financify/tree/main/Financify/lib/"
    click JCalendar "https://github.com/kanav-arora/financify/blob/main/Financify/lib/jcalendar-1.4.jar"
    click Build "https://github.com/kanav-arora/financify/blob/main/Financify/build.xml"
    click Build "https://github.com/kanav-arora/financify/tree/main/Financify/nbproject/"

    %% Styles
    classDef ui fill:#ADD8E6,stroke:#333,stroke-width:1px
    classDef logic fill:#90EE90,stroke:#333,stroke-width:1px
    classDef data fill:#FFA500,stroke:#333,stroke-width:1px
    classDef db fill:#D3D3D3,stroke:#333,stroke-width:1px
    classDef ext fill:#FFFFE0,stroke:#333,stroke-width:1px
    classDef build fill:#E0E0E0,stroke:#333,stroke-width:1px
```
