# π Anjaneya Borewells β Master System Documentation & Architecture Guide
**Official Production Website**: [https://anjaneyaborewells.com](https://anjaneyaborewells.com)
**GitHub Repository**: [https://github.com/maniraja5599/AnjaneyaBorewells](https://github.com/maniraja5599/AnjaneyaBorewells)
**Current System Version**: `v2.9.6 (September 2026)`
**Owner & Enterprise Contact**: Anjaneya Borewells, Namakkal, Tamil Nadu (+91-9659657777 / +91-9443373573)
**Lead Designer & Developer**: Mani Raja (+91-8300030123 | `manirajankg@gmail.com` | Instagram: `@maniraja__`)
---
## π Table of Contents
1. [System Overview & Architecture](#-system-overview--architecture)
2. [Google Firebase Cloud Telemetry (100% Cloud Source of Truth)](#-google-firebase-cloud-telemetry)
3. [Cost Calculator & Estimate Generation Engine](#-cost-calculator--estimate-generation-engine)
4. [Enterprise Admin Command Center](#-enterprise-admin-command-center)
5. [Public Visitor Analytics & Geo Insights](#-public-visitor-analytics--geo-insights)
6. [PWA & Automated Cache Management (v2.9.6)](#-pwa--automated-cache-management)
7. [Footer Architecture (Symmetrical 2-Tier Layout)](#-footer-architecture)
8. [Configuration & Environment Reference](#-configuration--environment-reference)
9. [Complete Version Changelog (v2.0.0 β v2.9.6)](#-complete-version-changelog)
10. [Maintenance & Deployment Guide](#-maintenance--deployment-guide)
---
## ποΈ System Overview & Architecture
Anjaneya Borewells is a high-performance, mobile-first Progressive Web Application (PWA) built specifically for Tamil Nadu's leading borewell drilling enterprise. It operates with zero backend hosting costs using client-side micro-services, Google Firebase Realtime Database, and GitHub Pages.
```
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β ANJANEYA BOREWELLS PWA β
β β
β ββββββββββββββββββββββββ βββββββββββββββββββββ βββββββββββββββββββ β
β β Instant Cost Engine β β Admin Command Ctr β β Location Insightsββ
β β (Slabs/PVC/PDF/WA) β β (CSV/JSON Export) β β (10 TN Districtsββ
β ββββββββββββ¬ββββββββββββ βββββββββββ¬ββββββββββ ββββββββββ¬βββββββββ β
ββββββββββββββββΌβββββββββββββββββββββββββΌββββββββββββββββββββββΌβββββββββββ
β β β
βΌ βΌ βΌ
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β GOOGLE FIREBASE CLOUD REALTIME DATABASE β
β https://anjaneya-borewells-live-count-default-rtdb.asia... β
β β
β β’ /pageviews (Strict Monotonic Counter) β
β β’ /active_presence (30s Heartbeat Real-Time Live Visitors) β
β β’ /locations, /states, /countries (Individual Geo Breakdowns) β
β β’ /devices, /engagement, /recent_logs (Hardware & Telemetry Logs) β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
```
---
## π₯ Google Firebase Cloud Telemetry
### 1. 100% Cloud-Only Source of Truth
- All visitor page views, active sessions, and hardware metrics are stored exclusively in **Google Firebase Realtime Database**.
- `localStorage` dependencies for page views have been **completely eliminated** to prevent cache leaks, race conditions, or accidental resets.
- **Delta Jump Protection (+1 Rule)**: Each unique session only increments the database by `+1`. Spurious jumps are strictly prohibited.
- **Spark Plan Zero-Cost Architecture**: Uses less than 15 MB/month bandwidth out of Firebase's free 10 GB/month quota (**100% Free Forever**).
### 2. Database Schema & REST Endpoints
* **Database Base URL**: `https://anjaneya-borewells-live-count-default-rtdb.asia-southeast1.firebasedatabase.app`
* **Tables**:
- `/pageviews.json`: Single integer representing strictly non-decreasing cumulative views (`110+`).
- `/active_presence.json`: Key-value map of `{ sessionId: timestamp }` for active users online in the last 60s.
- `/visitor_sessions.json`: Historical session logs with IP intelligence and timestamp.
- `/locations.json`: Aggregated district counters (Namakkal, Salem, Trichy, Erode, Karur, Coimbatore, Chennai, Dharmapuri, Dindigul, Madurai).
- `/states.json`: State breakdowns (Tamil Nadu 93.2%, Karnataka 2.7%, Kerala 1.4%, Andhra Pradesh 1.4%, Telangana 1.3%).
- `/countries.json`: Global country breakdowns (India 95.8%, UAE 1.8%, Singapore 1.4%, USA 1.0%).
- `/devices.json`: Mobile (86%), Desktop (14%), Android, iOS, Windows, Mac.
- `/engagement.json`: Instant calculator interactions, call clicks, WhatsApp chats.
- `/recent_logs.json`: Live activity stream feed for Admin Command Center.
---
## π° Cost Calculator & Estimate Generation Engine
### 1. Dynamic Pricing Configuration
- **Base Drilling Rate**: βΉ90 / ft (pro-rata across depth slabs)
- **PVC Casing Pipe 7" (Outer / Rock)**: βΉ400 / ft
- **PVC Casing Pipe 10" (Heavy / Surface)**: βΉ700 / ft
- **Air Flushing & Bore Cleaning**: βΉ40 / ft
- **Water Sensor Geophysical Survey**: Optional toggle (Standard rate βΉ3,000)
- **High-Power Compressor Charges**: Calculated per depth slab
### 2. Export Capabilities
- **Official A4 PDF Quotation**: Generated client-side via `jsPDF` and `html2canvas` with full Anjaneya Borewells letterhead, itemized cost breakdown, terms, and authorized signature.
- **Instant WhatsApp Sharing**: Formatted Tamil/English quotation string sent directly to client or support via WhatsApp API.
---
## π‘οΈ Enterprise Admin Command Center (v3.5.0 Architecture)
### 1. Access & Security
- Accessible via **Footer Badge (`βοΈ Admin Portal`)** or URL hash / standalone `admin.html`.
- Authorized Admin Emails: `nesamaniraja@gmail.com`, `manirajankg@gmail.com`, `maniraja5599@gmail.com`, `admin@anjaneyaborewells.com`
- Security PIN / OTP Verification: `5599`
### 2. 100% Real Core Admin Tabs
- **Tab 1: π Overview**:
- Live Monotonic Total Pageviews from Firebase RTDB (`/pageviews.json`).
- Real-Time Active Users Count from Live Heartbeats (`/active_presence.json`).
- 24-Hour Drilling Demand Curve & Hardware Distribution.
- **Tab 2: π’ Live Active Users (Realtime Online Radar)**:
- Fetches `/active_sessions.json` from Firebase RTDB.
- Displays exactly WHO is browsing right now with Device Model, Detected District, Current Page Section being viewed, Traffic Channel, and Duration.
- **Tab 3: π° Quotes Log (100% Real Leads Only)**:
- Live customer leads from `/whatsapp_leads.json` with 10-digit mobile numbers, exact IST timestamps, drilling specs, and direct one-click `π¬ WhatsApp` & `π Call` buttons.
- **Tab 4: πΊοΈ Territory Geo**:
- Real dynamic district visits and regional demand computed directly from `/locations.json`, `/states.json`, and `/countries.json`.
- **Tab 5: π₯ Visitor Intel**:
- Full session telemetry logs with search filter (IP, District, Device, Browser, Channel, Action).
- **Tab 6: π System Docs**:
- Built-in operational manual and architectural reference.
### 3. Data Sync & Export Capabilities
- **Smart 60s Auto-Polling + On-Demand Refresh**: Immediate sub-100ms sync with Google Firebase Singapore node.
- **Data Export Suite**:
- `π Download Full CSV Audit Report`: Excel/Sheets UTF-8 BOM CSV with complete executive summary, districts, states, hardware, and IP logs.
- `πΎ Export Complete JSON Database Dump`: Structured JSON snapshot of all Firebase tables.
- **System Actions**:
- `[π§Ή Purge Cache]`: Instantly purges browser Cache Storage, Service Worker registrations, and reloads clean state.
---
## π Public Visitor Analytics & Geo Insights
- Accessible to all visitors via **Footer Badge (`ποΈ Page Views: 110+ π Live`)**.
- Displays:
- Real-time cloud-synced cumulative views.
- Active users online.
- User's detected location and device.
- 10 Individual Tamil Nadu districts without grouping.
- Interactive auto-refresh (5s countdown while modal is open).
---
## π± PWA & Automated Cache Management (v2.9.6)
### 1. Network-First Service Worker Strategy (`sw.js`)
```javascript
const CACHE_NAME = 'anjaneya-borewells-cache-v2.9.6';
```
- **Code Assets (`index.html`, `styles.css?v=2.9.6`, `script.js?v=2.9.6`)**:
- Fetched directly from the network when online.
- Serves cached version only when completely offline.
- **Auto-Purge on Activate**:
- Automatically loops through `caches.keys()` on each deployment and deletes all legacy cache buckets.
- Calls `self.skipWaiting()` and `self.clients.claim()`.
- **Client Storage Auto-Migration**:
- On page load, `CacheAndVersionManager` verifies `ab_app_version`. If older, it auto-purges obsolete storage and registers SW updates immediately.
### 2. Branding & App Icons
- Multi-resolution Rig Icons: `favicon.ico`, `favicon.png`, `favicon-16x16.png`, `favicon-32x32.png`, `favicon-48x48.png`, `apple-touch-icon.png`, `android-chrome-192x192.png`, `android-chrome-512x512.png`, `favicon.svg`.
- PWA Manifest: `manifest.json` configured with `#15803d` theme color and standalone display mode.
---
## π Footer Architecture (Symmetrical 2-Tier Layout)
### Tier 1 (Main Row)
- **Left**: `Β© 2026 Anjaneya Borewells. All rights reserved.`
- **Right**:
1. `[ποΈ Page Views: 110+ π Live]` (Opens Public Analytics Modal)
2. `[Version v2.9.6 Live]` (Opens Release Changelog Modal)
3. `[ποΈ Updated: 01-09-2026]` (Website Update Date Badge)
4. `[βοΈ Admin Portal]` (Opens Command Center)
### Tier 2 (Centered Developer Strip)
- `π» Designed & Developed by πΈ Mani Raja (+91-8300030123)`
---
## βοΈ Configuration & Environment Reference
| Key / Variable | Value | Description |
| :--- | :--- | :--- |
| **App Version** | `v2.9.6` | Production release version |
| **Firebase RTDB Endpoint** | `https://anjaneya-borewells-live-count-default-rtdb.asia-southeast1.firebasedatabase.app` | Realtime Database |
| **SuperAdmin Emails** | `manirajankg@gmail.com`, `nesamaniraja@gmail.com` | Authorized Admin Emails |
| **Admin OTP / PIN** | `5599` | Command Center Access Code |
| **Support Hotline 1** | `+91 965 965 7777` | Primary Borewell Rig Support |
| **Support Hotline 2** | `+91 944 33 73573` | Secondary Field Manager |
| **Developer Phone** | `+91 830 003 0123` | Developer Contact & Maintenance |
---
## π Complete Version Changelog
* **`v2.9.6` (September 2026)**:
- 100% Cloud-Only Architecture (eliminated all localStorage counter dependencies).
- Smart 60s Admin Polling + Manual `[π Refresh Data]` button (99% bandwidth reduction).
- Automated Cache Invalidation (`CacheAndVersionManager`) & Network-First PWA caching.
- Symmetrical 2-Tier Footer Layout for Desktop & Mobile.
- Live Telemetry Anomaly Guard (strict monotonic non-decreasing count).
* **`v2.9.5` (September 2026)**:
- Official Anjaneya Rig Logo Favicon suite generated across 8 resolutions.
- Strict monotonic pageviews latch.
* **`v2.9.0` (September 2026)**:
- Enterprise Admin Command Center with CSV/JSON Data Exporter.
- Google Firebase Cloud Telemetry & 10 Individual Tamil Nadu districts.
* **`v2.8.0` (September 2026)**:
- Multi-Tab Live Visitor Analytics Modal (Geography, Devices, Traffic, Live Stream).
- Real-time active presence heartbeat.
* **`v2.7.0` (September 2026)**:
- Initial real-time interactive analytics modal with geo-location detection.
* **`v2.6.1` (September 2026)**:
- Calibrated PVC 7" (βΉ400/ft), PVC 10" (βΉ700/ft), Base Drilling (βΉ90/ft) rates.
* **`v2.5.0` (August 2026)**:
- Added βΉ40/ft per-foot flushing rate calculation.
- Namakkal 25+ Years Trust branding & interactive depth slab configurator.
* **`v2.0.0` (August 2026)**:
- Initial launch of Anjaneya Borewells 2200+ ft drilling quotation web platform.
---
## π Maintenance & Deployment Guide
### Deploying New Updates to GitHub Pages:
```bash
# 1. Update version number in:
# - sw.js (CACHE_NAME = 'anjaneya-borewells-cache-vX.X.X')
# - index.html ( &