# jeeva2n/crm architecture

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

- Interactive diagram: https://gitdiagram.com/jeeva2n/crm
- Repository: https://github.com/jeeva2n/crm

## Overview

This PHP CRM supports customer and product records, order creation and production tracking, document management, and separate employee/admin account areas. The principal workflow is entering an order, managing its production pipeline, then viewing its status and history. Shared functions provide database-backed CRM operations and upload helpers; the main CRM uses PDO while the deep admin/user area has a separate MySQLi connection. The README is empty, and excerpts are partial, so links for standalone stage pages and several listed capabilities are omitted where their wiring is not evidenced.

Main entry points: [`functions.php`](https://github.com/jeeva2n/crm/blob/main/functions.php) (CRM Functions), [`db.php`](https://github.com/jeeva2n/crm/blob/main/db.php) (CRM Database Connection), [`sidebar.php`](https://github.com/jeeva2n/crm/blob/main/sidebar.php) (CRM Navigation), [`customers.php`](https://github.com/jeeva2n/crm/blob/main/customers.php) (Customer Records)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_sales["CRM Records"]
  node_customers["Customer Records<br/>[customers.php]"]
  node_products["Product Catalog<br/>[products.php]"]
  node_orders["Order Entry<br/>[orders.php]"]
end

subgraph group_production["Order Production"]
  node_pipeline["Production Pipeline<br/>[pipeline.php]"]
  node_stageview["Order Stage View"]
  node_tracking["Order Tracking<br/>[order_tracking.php]"]
  node_stage2["Raw Materials"]
  node_stage3["Machining"]
  node_stage4["Quality Inspection"]
  node_stage5["Packaging"]
  node_stage6["Shipping Documents"]
  node_stage7["Dispatch"]
end

subgraph group_documents["Document Management"]
  node_employee_docs["Employee Documents"]
  node_admin_docs["Admin Documents"]
end

subgraph group_accounts["Accounts and Access"]
  node_employee_login["Employee Login<br/>[login.php]"]
  node_employee_dashboard["Employee Dashboard<br/>[dashboard.php]"]
  node_employee_auth["Employee Access Check<br/>[checklogin.php]"]
  node_employee_dbconn["Employee DB Connection<br/>[dbconnection.php]"]
  node_admin_login["Admin Login<br/>[index.php]"]
  node_admin_home["Admin Home<br/>[home.php]"]
  node_admin_users["User Administration<br/>[manage-users.php]"]
  node_admin_auth["Admin Access Check<br/>[checklogin.php]"]
  node_admin_dbconn["Admin DB Connection<br/>[dbconnection.php]"]
end

subgraph group_shared["Shared Services"]
  node_functions["CRM Functions<br/>[functions.php]"]
  node_db["CRM Database Connection<br/>[db.php]"]
  node_sidebar["CRM Navigation<br/>[sidebar.php]"]
end

node_user(("CRM User"))

node_user -->|"creates order"| node_orders
node_user -.->|"manages customers"| node_customers
node_user -.->|"manages products"| node_products
node_user -.->|"updates production"| node_pipeline
node_user -.->|"views status"| node_tracking
node_orders -->|"uses CRM operations"| node_functions
node_orders -->|"uses connection"| node_db
node_orders -->|"renders navigation"| node_sidebar
node_customers -->|"uses CRM operations"| node_functions
node_customers -->|"uses connection"| node_db
node_customers -->|"renders navigation"| node_sidebar
node_products -->|"uses CRM operations"| node_functions
node_products -->|"uses connection"| node_db
node_products -->|"renders navigation"| node_sidebar
node_pipeline -->|"uses CRM operations"| node_functions
node_pipeline -->|"uses connection"| node_db
node_pipeline -->|"renders navigation"| node_sidebar
node_stageview -->|"uses CRM operations"| node_functions
node_tracking -->|"uses CRM operations"| node_functions
node_tracking -->|"renders navigation"| node_sidebar
node_functions -->|"requires connection"| node_db
node_employee_login -->|"queries account"| node_employee_dbconn
node_employee_dashboard -->|"checks access"| node_employee_auth
node_employee_dashboard -->|"queries statistics"| node_employee_dbconn
node_employee_docs -->|"uses upload helpers"| node_functions
node_admin_login -->|"queries credentials"| node_admin_dbconn
node_admin_home -->|"checks access"| node_admin_auth
node_admin_home -->|"queries data"| node_admin_dbconn
node_admin_users -->|"checks access"| node_admin_auth
node_admin_users -->|"queries data"| node_admin_dbconn
node_admin_docs -->|"uses upload helpers"| node_functions

click node_customers "https://github.com/jeeva2n/crm/blob/main/customers.php"
click node_products "https://github.com/jeeva2n/crm/blob/main/products.php"
click node_orders "https://github.com/jeeva2n/crm/blob/main/orders.php"
click node_pipeline "https://github.com/jeeva2n/crm/blob/main/pipeline.php"
click node_stageview "https://github.com/jeeva2n/crm/blob/main/order-stages-view.php"
click node_tracking "https://github.com/jeeva2n/crm/blob/main/order_tracking.php"
click node_stage2 "https://github.com/jeeva2n/crm/blob/main/stages/stage2-raw-materials.php"
click node_stage3 "https://github.com/jeeva2n/crm/blob/main/stages/stage3-machining-processes.php"
click node_stage4 "https://github.com/jeeva2n/crm/blob/main/stages/stage4-quality-inspection.php"
click node_stage5 "https://github.com/jeeva2n/crm/blob/main/stages/stage5-packaging.php"
click node_stage6 "https://github.com/jeeva2n/crm/blob/main/stages/stage6-shipping-docs.php"
click node_stage7 "https://github.com/jeeva2n/crm/blob/main/stages/stage7-dispatch.php"
click node_employee_docs "https://github.com/jeeva2n/crm/blob/main/deep/document-manager-employee.php"
click node_admin_docs "https://github.com/jeeva2n/crm/blob/main/deep/admin/document-manager-admin.php"
click node_employee_login "https://github.com/jeeva2n/crm/blob/main/deep/login.php"
click node_employee_dashboard "https://github.com/jeeva2n/crm/blob/main/deep/dashboard.php"
click node_employee_auth "https://github.com/jeeva2n/crm/blob/main/deep/checklogin.php"
click node_employee_dbconn "https://github.com/jeeva2n/crm/blob/main/deep/dbconnection.php"
click node_admin_login "https://github.com/jeeva2n/crm/blob/main/deep/admin/index.php"
click node_admin_home "https://github.com/jeeva2n/crm/blob/main/deep/admin/home.php"
click node_admin_users "https://github.com/jeeva2n/crm/blob/main/deep/admin/manage-users.php"
click node_admin_auth "https://github.com/jeeva2n/crm/blob/main/deep/admin/checklogin.php"
click node_admin_dbconn "https://github.com/jeeva2n/crm/blob/main/deep/admin/dbconnection.php"
click node_functions "https://github.com/jeeva2n/crm/blob/main/functions.php"
click node_db "https://github.com/jeeva2n/crm/blob/main/db.php"
click node_sidebar "https://github.com/jeeva2n/crm/blob/main/sidebar.php"

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_customers,node_products,node_orders,node_user toneBlue
class node_pipeline,node_stageview,node_tracking,node_stage2,node_stage3,node_stage4,node_stage5,node_stage6,node_stage7 toneAmber
class node_employee_docs,node_admin_docs toneMint
class node_employee_login,node_employee_dashboard,node_employee_auth,node_employee_dbconn,node_admin_login,node_admin_home,node_admin_users,node_admin_auth,node_admin_dbconn toneRose
class node_functions,node_db,node_sidebar toneIndigo
```

## Components

### CRM Records

- [Customer Records](https://github.com/jeeva2n/crm/blob/main/customers.php): `customers.php`
- [Product Catalog](https://github.com/jeeva2n/crm/blob/main/products.php): `products.php`
- [Order Entry](https://github.com/jeeva2n/crm/blob/main/orders.php): `orders.php`

### Order Production

- [Production Pipeline](https://github.com/jeeva2n/crm/blob/main/pipeline.php): `pipeline.php`
- [Order Stage View](https://github.com/jeeva2n/crm/blob/main/order-stages-view.php): `order-stages-view.php`
- [Order Tracking](https://github.com/jeeva2n/crm/blob/main/order_tracking.php): `order_tracking.php`
- [Raw Materials](https://github.com/jeeva2n/crm/blob/main/stages/stage2-raw-materials.php): `stages/stage2-raw-materials.php`
- [Machining](https://github.com/jeeva2n/crm/blob/main/stages/stage3-machining-processes.php): `stages/stage3-machining-processes.php`
- [Quality Inspection](https://github.com/jeeva2n/crm/blob/main/stages/stage4-quality-inspection.php): `stages/stage4-quality-inspection.php`
- [Packaging](https://github.com/jeeva2n/crm/blob/main/stages/stage5-packaging.php): `stages/stage5-packaging.php`
- [Shipping Documents](https://github.com/jeeva2n/crm/blob/main/stages/stage6-shipping-docs.php): `stages/stage6-shipping-docs.php`
- [Dispatch](https://github.com/jeeva2n/crm/blob/main/stages/stage7-dispatch.php): `stages/stage7-dispatch.php`

### Document Management

- [Employee Documents](https://github.com/jeeva2n/crm/blob/main/deep/document-manager-employee.php): `deep/document-manager-employee.php`
- [Admin Documents](https://github.com/jeeva2n/crm/blob/main/deep/admin/document-manager-admin.php): `deep/admin/document-manager-admin.php`

### Accounts and Access

- [Employee Login](https://github.com/jeeva2n/crm/blob/main/deep/login.php): `deep/login.php`
- [Employee Dashboard](https://github.com/jeeva2n/crm/blob/main/deep/dashboard.php): `deep/dashboard.php`
- [Employee Access Check](https://github.com/jeeva2n/crm/blob/main/deep/checklogin.php): `deep/checklogin.php`
- [Employee DB Connection](https://github.com/jeeva2n/crm/blob/main/deep/dbconnection.php): `deep/dbconnection.php`
- [Admin Login](https://github.com/jeeva2n/crm/blob/main/deep/admin/index.php): `deep/admin/index.php`
- [Admin Home](https://github.com/jeeva2n/crm/blob/main/deep/admin/home.php): `deep/admin/home.php`
- [User Administration](https://github.com/jeeva2n/crm/blob/main/deep/admin/manage-users.php): `deep/admin/manage-users.php`
- [Admin Access Check](https://github.com/jeeva2n/crm/blob/main/deep/admin/checklogin.php): `deep/admin/checklogin.php`
- [Admin DB Connection](https://github.com/jeeva2n/crm/blob/main/deep/admin/dbconnection.php): `deep/admin/dbconnection.php`

### Shared Services

- [CRM Functions](https://github.com/jeeva2n/crm/blob/main/functions.php): `functions.php`
- [CRM Database Connection](https://github.com/jeeva2n/crm/blob/main/db.php): `db.php`
- [CRM Navigation](https://github.com/jeeva2n/crm/blob/main/sidebar.php): `sidebar.php`

### Other components

- **CRM User**

## Connections

- CRM User → Order Entry: creates order (evidence: `orders.php`)
- CRM User → Customer Records: manages customers
- CRM User → Product Catalog: manages products
- CRM User → Production Pipeline: updates production
- CRM User → Order Tracking: views status
- Order Entry → CRM Functions: uses CRM operations (evidence: `orders.php`)
- Order Entry → CRM Database Connection: uses connection (evidence: `orders.php`)
- Order Entry → CRM Navigation: renders navigation (evidence: `orders.php`)
- Customer Records → CRM Functions: uses CRM operations (evidence: `customers.php`)
- Customer Records → CRM Database Connection: uses connection (evidence: `customers.php`)
- Customer Records → CRM Navigation: renders navigation (evidence: `customers.php`)
- Product Catalog → CRM Functions: uses CRM operations (evidence: `products.php`)
- Product Catalog → CRM Database Connection: uses connection (evidence: `products.php`)
- Product Catalog → CRM Navigation: renders navigation (evidence: `products.php`)
- Production Pipeline → CRM Functions: uses CRM operations (evidence: `pipeline.php`)
- Production Pipeline → CRM Database Connection: uses connection (evidence: `pipeline.php`)
- Production Pipeline → CRM Navigation: renders navigation (evidence: `pipeline.php`)
- Order Stage View → CRM Functions: uses CRM operations (evidence: `order-stages-view.php`)
- Order Tracking → CRM Functions: uses CRM operations (evidence: `order_tracking.php`)
- Order Tracking → CRM Navigation: renders navigation (evidence: `order_tracking.php`)
- CRM Functions → CRM Database Connection: requires connection (evidence: `functions.php`)
- Employee Login → Employee DB Connection: queries account (evidence: `deep/login.php`)
- Employee Dashboard → Employee Access Check: checks access (evidence: `deep/dashboard.php`)
- Employee Dashboard → Employee DB Connection: queries statistics (evidence: `deep/dashboard.php`)
- Employee Documents → CRM Functions: uses upload helpers (evidence: `deep/document-manager-employee.php`)
- Admin Login → Admin DB Connection: queries credentials (evidence: `deep/admin/index.php`)
- Admin Home → Admin Access Check: checks access (evidence: `deep/admin/home.php`)
- Admin Home → Admin DB Connection: queries data (evidence: `deep/admin/home.php`)
- User Administration → Admin Access Check: checks access (evidence: `deep/admin/manage-users.php`)
- User Administration → Admin DB Connection: queries data (evidence: `deep/admin/manage-users.php`)
- Admin Documents → CRM Functions: uses upload helpers (evidence: `deep/admin/document-manager-admin.php`)
