# ahr-array/dbms_project architecture

> Architecture diagram of the GitHub repository ahr-array/dbms_project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-08-15). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/ahr-array/dbms_project
- Repository: https://github.com/ahr-array/dbms_project

## Overview

##### Project Type and Purpose
- This is a full-stack, server-rendered web application built with Node.js/Express, EJS templates, and MySQL.
- Purpose: manage warehouse inventory, perform billing, and analyze stock/sales via dynamic pages and filters.

##### File Structure
- Top-level files:
- server.js – application entry point
- passport-config.js – authentication setup
- package.json – dependencies, scripts
- .env / process.env – credentials & secrets
- Procfile – Heroku deployment
- error.log – runtime logs
- Directories:
- public/ – static assets (CSS)
- views/ – EJS templates for each feature (stocks, bills, analysis, auth)

##### README Insights
- Tech stack: Node, Express, MySQL, JS, Bootstrap, Semantic-UI.
- Features: stock inventory, billing (PDF generation), sales/stock analysis, Passport authentication.
- Deployment: runs on localhost:5000, environment variables configure DB & admin credentials.

##### Main Components
a. Client Layer
- Browser (User Interface)
- Static Assets: CSS, JS (public/)
b. Web Server Layer
- Node.js + Express
- Middleware:
- Passport.js for authentication
- body-parser, static-file serving
- Route Handlers (defined in server.js; map URL → EJS view + DB operations)
- Template Engine: EJS (views/*.ejs)
c. Data Layer
- MySQL Database (warehousedb)
- Tables: stocks, orders, brands, categories, sizes, users, sales
d. External/Deployment
- Heroku (Procfile) or any PaaS
- Environment configuration (.env)
- PDF Generation (via EJS → PDF on billing view)

##### Relationships & Data Flow
1. User in browser issues HTTP(S) request (login, view stocks, bill creation).
2. Express middleware authenticates (Passport) or rejects.
3. Valid requests hit route handler → business logic (CRUD queries to MySQL).
4. Query results → EJS renders HTML → sent back to browser.
5. On “print bill,” server compiles bill.ejs into printable PDF.
6. Logs (error.log) capture runtime errors; environment variables supply DB credentials & secrets.

##### Architectural Patterns & Principles
- MVC-style separation:
- Model = MySQL tables + queries
- View = EJS templates
- Controller = Express route handlers
- Middleware pipeline for authentication & parsing
- Layered architecture: Presentation → Application → Data
- Configuration via 12-factor app (.env, Procfile)

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Client Layer
    subgraph "Client Layer"
        Browser["Browser / User"]:::frontend
        subgraph "Static Assets"
            CSS1["login.css"]:::static
            CSS2["styles.css"]:::static
        end
    end

    %% Web Server Layer
    subgraph "Web Server Layer"
        Express["Express Server (server.js)"]:::backend
        Passport["Passport Auth (passport-config.js)"]:::backend
        BodyParser["Body Parser"]:::backend
        StaticServe["Static File Serve"]:::backend

        subgraph "Routes & Controllers"
            Stocks["Stocks Routes"]:::backend
            Orders["Orders/Billing Routes"]:::backend
            Analysis["Sales Analysis Routes"]:::backend
            Categories["Categories/Brands/Sizes Routes"]:::backend
            AuthRoutes["Auth Routes"]:::backend
        end

        subgraph "Template Engine"
            bill["bill.ejs"]:::views
            stocks["stocks.ejs"]:::views
            viewstocks["viewstocks.ejs"]:::views
            stockfilter["stock_filter.ejs"]:::views
            ordersView["orders.ejs"]:::views
            salesfilter["sales_filter.ejs"]:::views
            categoriesView["categories.ejs"]:::views
            brands["brands.ejs"]:::views
            sizes["sizes.ejs"]:::views
            loginView["login.ejs"]:::views
            register["register.ejs"]:::views
            indexView["index.ejs"]:::views
        end

        Env["Environment Config (process.env)"]:::config
        Proc["Deployment Config (Procfile)"]:::config
        Pkg["package.json"]:::config
        Log["error.log"]:::logging

        PDF["PDF Generator"]:::backend
    end

    %% Data Layer
    Database["MySQL (warehousedb)"]:::database

    %% External
    Heroku["Heroku (PaaS)"]:::external

    %% Connections
    Browser -->|"loads CSS/JS"| StaticServe
    StaticServe -->|"serve static"| Browser
    Browser -->|"HTTP Request"| Express

    Express -->|uses| Passport
    Express -->|uses| BodyParser
    Express -->|uses| StaticServe

    Express -->|"routes to"| Stocks
    Express -->|"routes to"| Orders
    Express -->|"routes to"| Analysis
    Express -->|"routes to"| Categories
    Express -->|"routes to"| AuthRoutes

    Stocks -->|"SQL Query"| Database
    Orders -->|"SQL Query"| Database
    Analysis -->|"SQL Query"| Database
    Categories -->|"SQL Query"| Database
    AuthRoutes -->|"SQL Query"| Database

    Database -->|"Query Results"| Stocks
    Database -->|"Query Results"| Orders
    Database -->|"Query Results"| Analysis
    Database -->|"Query Results"| Categories
    Database -->|"Query Results"| AuthRoutes

    Stocks -->|"render view"| stocks
    Stocks -->|"render view"| viewstocks
    Stocks -->|"render view"| stockfilter

    Orders -->|"render view"| ordersView
    Orders -->|"render view"| bill
    Orders -->|"generate PDF"| PDF

    Analysis -->|"render view"| salesfilter
    Categories -->|"render view"| categoriesView
    Categories -->|"render view"| brands
    Categories -->|"render view"| sizes
    AuthRoutes -->|"render view"| loginView
    AuthRoutes -->|"render view"| register
    AuthRoutes -->|"render view"| indexView

    Express -->|loads| Env
    Express -->|loads| Proc
    Express -->|loads| Pkg
    Express -->|logs to| Log

    Express -->|"deployed on"| Heroku

    %% Click Events
    click CSS1 "https://github.com/ahr-array/dbms_project/blob/master/public/login.css"
    click CSS2 "https://github.com/ahr-array/dbms_project/blob/master/public/styles.css"
    click Express "https://github.com/ahr-array/dbms_project/blob/master/server.js"
    click Passport "https://github.com/ahr-array/dbms_project/blob/master/passport-config.js"
    click Env "https://github.com/ahr-array/dbms_project/blob/master/process.env"
    click Proc "https://github.com/ahr-array/dbms_project/tree/master/Procfile"
    click Pkg "https://github.com/ahr-array/dbms_project/blob/master/package.json"
    click Log "https://github.com/ahr-array/dbms_project/blob/master/error.log"
    click bill "https://github.com/ahr-array/dbms_project/blob/master/views/bill.ejs"
    click stocks "https://github.com/ahr-array/dbms_project/blob/master/views/stocks.ejs"
    click viewstocks "https://github.com/ahr-array/dbms_project/blob/master/views/viewstocks.ejs"
    click stockfilter "https://github.com/ahr-array/dbms_project/blob/master/views/stock_filter.ejs"
    click ordersView "https://github.com/ahr-array/dbms_project/blob/master/views/orders.ejs"
    click salesfilter "https://github.com/ahr-array/dbms_project/blob/master/views/sales_filter.ejs"
    click categoriesView "https://github.com/ahr-array/dbms_project/blob/master/views/categories.ejs"
    click brands "https://github.com/ahr-array/dbms_project/blob/master/views/brands.ejs"
    click sizes "https://github.com/ahr-array/dbms_project/blob/master/views/sizes.ejs"
    click loginView "https://github.com/ahr-array/dbms_project/blob/master/views/login.ejs"
    click register "https://github.com/ahr-array/dbms_project/blob/master/views/register.ejs"
    click indexView "https://github.com/ahr-array/dbms_project/blob/master/views/index.ejs"

    %% Styles
    classDef frontend fill:#ADD8E6,stroke:#000,stroke-width:1px
    classDef static fill:#E0FFFF,stroke:#000,stroke-width:1px
    classDef backend fill:#FFA500,stroke:#000,stroke-width:1px
    classDef views fill:#FFFF99,stroke:#000,stroke-width:1px
    classDef database fill:#90EE90,stroke:#000,stroke-width:1px
    classDef config fill:#D3D3D3,stroke:#000,stroke-width:1px
    classDef logging fill:#FFB6C1,stroke:#000,stroke-width:1px
    classDef external fill:#D3D3D3,stroke:#000,stroke-width:1px
```
