Make a Call

0935-9475770
Dashboard Overview
📡 Fleet & Traffic Intelligence · Offline Demo
LIVE
Loading…
🌙
Active Vehicles
24
7 on task now
🚗
Tasks Today
22
12 completed
Billable KM Today
847
847 km logged
📍
Fuel Cost Today
₹ 3,242
Violations Today
7
3 critical · Zone B
🚨
Gate Traffic Today🚛
1,428
↑ +12% vs yesterday
Active Alerts⚠️
3
⚠ 2 high priority
Parking Occupancy🅿️
68%
340 / 500 slots
Avg Speed
23 km/h
✓ Within limit
Violations Breakdown🚨
7
🚀 Speeding4
🚫 Unauthorised2
⚠ Wrong Zone1
📊 Traffic Flow (24h)
AI Powered
✅ Recent Tasks
Task IDVehicleDriverKMStatus
TSK-0041WXY 1234Ahmad R. 42.3 Completed
TSK-0042BJK 5678Siti N. 18.2 Active
TSK-0043PQR 9012Ravi K. 0 Pending
TSK-0040DEF 3456Lim C.H. 67.8 Completed
🔔 Notifications
3
09:38 Unauthorized vehicle at Gate 2 — security notified
09:18 Forklift FKL-03 exceeded 30 km/h in Zone B3
08:30 Unusual vehicle clustering near Warehouse 4
Current Fuel Rates
RON 95
₹ 2.05
⟳ Auto-fetched
DIESEL
₹ 2.15
✎ Manual override
🛡️ Safety Risk Score
35
MODERATE
Speed Violations7 events
Unauthorized Access2 hits
Near-miss Events1 today
Parking OvercrowdingNormal
📍 KM Breakdown Today
Billable (Work) KM 847 km
Non-Billable (Personal) KM 214 km
Flagged / Under Review 42 km
Total GPS Distance: 1,103 km across 24 vehicles
💰 Monthly Fuel Cost Summary
Total Billable KM18,420 km
Avg Fuel Rate₹ 2.07/L
Avg Consumption8.5L / 100km
Est. Litres Used1,565.7 L
Total Fuel Cost₹ 3,241.00
Vehicles On Map
24
📡
Currently On Task
7
🟢
Idle / Standby
17
GPS Signal Lost
0
⚠️
🗺️ Live GPS Tracking
7 On Task 17 Idle
📡 GPS Active · 24 Devices · 12 States
Tracking Live
On Task Assigned Idle
BJK 5678
Toyota Hilux — Siti N.
🟢 On TaskTSK-0042📍 Bandra
18.2 km travelled · Est. 40 km task
DEF 3456
Honda CR-V — Lim C.H.
🟢 On TaskTSK-0044📍 Thane
62.4 km travelled · Est. 80 km task
WXY 1234
Proton X70 — Ahmad R.
⚪ IdleHQ Depot
Last seen: 11:45 · TSK-0041 completed
PQR 9012
Nissan Navara — Ravi K.
🟡 AssignedTSK-0043 pending
Scheduled: 15:00 today
MNO 7890
Toyota Vios — Farid A.
⚪ IdleBranch Mumbai
No task today
GHI 3456
Ford Ranger — Zul H.
🟢 On TaskTSK-0045📍 Navi Mumbai
11.3 km travelled · Est. 35 km task
Total Registered
24
🚗
Active / On Task
7
🟢
Idle
17
Contracts Active
24
📄
🚗 Registered GPS Contract Vehicles
Plate No.VehicleTypeFuel DriverContractGPS ID ConsumptionStatus
WXY 1234Proton X70SUVRON95 Ahmad RazaliCON-001GPS-A01 8.5 L/100km Active
BJK 5678Toyota HiluxPickupDiesel Siti NabilahCON-002GPS-B03 10.2 L/100km On Task
PQR 9012Nissan NavaraPickupDiesel Ravi KumarCON-003GPS-C07 9.8 L/100km Assigned
DEF 3456Honda CR-VSUVRON95 Lim Chee HoongCON-004GPS-D02 7.9 L/100km On Task
MNO 7890Toyota ViosSedanRON95 Farid AmirCON-005GPS-E04 7.2 L/100km Active
GHI 3456Ford RangerPickupDiesel Zul HakimCON-006GPS-F06 11.0 L/100km On Task
📊 Fleet Consumption Overview
Billing Reference
RON 95 Vehicles
12
Avg 7.9 L/100km
Diesel Vehicles
10
Avg 10.3 L/100km
EV Vehicles
2
Avg 0.18 kWh/km
💡 Billing Formula: Litres = (Work KM × Consumption Rate) ÷ 100  |  Cost = Litres × Current Fuel Rate  |  Manual KM edits are not allowed — GPS-locked only
Pending
3
Active
7
🔄
Completed
12
Total KM Billed
847
📍
📋 All Tasks
Task IDDescriptionVehicleDriver Check-InCheck-OutWork KM LitresFuel CostStatus
TSK-0041 Site Inspection — Andheri WXY 1234 Ahmad R. 08:12 11:45 42.3 3.6 L ₹ 74.02 Completed
TSK-0042 Delivery — Pune BJK 5678 Siti N. 13:20 18.2 1.9 L ₹ 31.85 Active
TSK-0043 Client Visit — Nashik PQR 9012 Ravi K. 0 Pending
TSK-0040 Material Transport — Bhiwandi DEF 3456 Lim C.H. 07:00 12:30 67.8 5.4 L ₹ 118.65 Completed
TSK-0039 Audit Visit — Kalyan MNO 7890 Farid A. 09:00 14:20 55.1 4.0 L ₹ 81.95 Completed
TSK-0045 Equipment Delivery — Navi Mumbai GHI 3456 Zul H. 14:10 11.3 1.2 L ₹ 20.83 Active
🔒 Anti-Abuse Billing Rules
✅ GPS-Only KM
Kilometres are calculated exclusively from GPS logs. No manual edits permitted post check-out.
📍 Task-Gated Billing
Only KM logged between Check-In and Check-Out events are billable. Personal travel is excluded.
⚠️ Geofence Alerts
Out-of-zone GPS activity triggers an automatic alert to supervisors for review and flagging.
📍 My Active Task
● GPS Recording
🚗
TSK-0042 · BJK 5678
Delivery — Pune
Started: 13:20 · GPS Active · Diesel · 10.2L/100km
18.2km (work)
31.85
📡 GPS Log (last 3 pings)
13:47:02 · 3.1478°N, 101.6953°E · 42 km/h
13:46:52 · 3.1482°N, 101.6948°E · 38 km/h
13:46:42 · 3.1487°N, 101.6941°E · 45 km/h
🔒 KM counter only runs during active task. Personal travel is excluded from billing. No manual override allowed.
📋 Assigned Tasks
📋
TSK-0043 · PQR 9012
Client Visit — Nashik
Scheduled: 15:00 today · Nissan Navara · Diesel
📋
TSK-0046 · WXY 1234
Depot Run — Panvel
Scheduled: Tomorrow 08:00
Future
🕐 Check In / Out Log
Today
TaskEventTimeKM at Event
TSK-0042 Check In 13:200.0
TSK-0041 Check Out 11:4542.3
TSK-0041 Check In 08:120.0
TSK-0039 Check Out Prev55.1
TSK-0039 Check In Prev0.0
🧮 Today's KM & Cost Summary
Work KM (Billable) 60.5 km
Personal KM (Excluded) 34.2 km
Fuel Type Diesel
Fuel Rate ₹ 2.15/L
Consumption Rate 10.2 L/100km
Litres Used (Work) 6.17 L
Billable Fuel Cost ₹ 132.66
📌 Formula: Litres = (Work KM × 10.2) ÷ 100 = 6.17 L  |  Cost = 6.17 × ₹ 2.15 = ₹ 13.27 per task
⛽ Fuel Rate Configuration
● Live
⟳ Auto Fetch
✎ Manual Entry
Auto-sync Enabled
Last synced: 2 minutes ago · Next: 23:58
Rate Priority Layering
1. Contract Rate (if defined) → 2. Manual Override → 3. Auto-fetched Live Rate
🕐 Rate History
DateFuel TypeRateSourceSet By
18 Mar 2024RON 95₹ 2.05/L AutoPPAC India
01 Mar 2024RON 95₹ 2.05/L AutoPPAC India
15 Feb 2024Diesel₹ 2.15/L ManualAhmad R.
01 Feb 2024RON 97₹ 2.60/L AutoPPAC India
01 Jan 2024EV₹ 0.45/kWh ManualAdmin
🔥 Current Active Rates
RON 95
₹ 2.05
⟳ Auto-fetched
RON 97
₹ 2.65
⟳ Auto-fetched
DIESEL
₹ 2.15
✎ Manual override
EV (per kWh)
₹ 0.45
✎ Manual entry
🧮 Cost Estimator
Live Calc
Fill in values and click Calculate
This Month Total
₹ 3,242
18,420 km billed
💰
Invoices Generated
8
6 approved
📄
Pending Approval
2
Action required
Total Billable KM
18,420
km this period
📍
💰 Invoice History
InvoicePeriodVehicle Work KMRateAmount Status
INV-2024-18Mar 2024ALL Fleet 18,420₹ 2.07 ₹ 3,242.00 Pending
INV-2024-12Feb 2024ALL Fleet 16,890₹ 2.05 ₹ 2,940.00 Approved
INV-2024-09Feb 2024WXY 1234 3,540₹ 2.05 ₹ 617.11 Paid
INV-2024-06Jan 2024WXY 1234 3,210₹ 2.05 ₹ 559.74 Paid
INV-2024-03Jan 2024BJK 5678 4,120₹ 2.15 ₹ 887.86 Paid
📊 Current Period Breakdown
March 2024
Total Billable KM 18,420 km
RON 95 Vehicles (12) ₹ 1,279.14
Diesel Vehicles (10) ₹ 1,846.80
EV Vehicles (2) ₹ 116.06
Total Litres / kWh 1,565.7 L
Total Fuel Cost ₹ 3,242.00
🚗 Per-Vehicle Cost (Top 5)
BJK 5678 — Toyota Hilux ₹ 898.00
4,180 km · Diesel
DEF 3456 — Honda CR-V ₹ 651.00
3,910 km · RON 95
WXY 1234 — Proton X70 ₹ 559.74
3,210 km · RON 95
GHI 3456 — Ford Ranger ₹ 461.00
2,140 km · Diesel
PQR 9012 — Nissan Navara ₹ 391.17
1,810 km · Diesel
Entries Today➡️
847
↑ +5% vs yesterday
Exits Today⬅️
812
35 still on-site
Pre-registered📅
124
✓ 98 cleared
Blacklist Hits🚫
2
⚠ Action required
✅ Gate Activity (Live)
Real-time
TimePlateType GateDirStatus
09:42TR-7821 TruckGate 1Entry ✓ Approved
09:38CAR-439 CarGate 3Entry ✓ Approved
09:17LKW-789 VanGate 1Entry ✗ Denied
09:05FKL-03 ForkliftGate 2Entry ✓ Approved
08:58BUS-44 BusGate 4Entry ✓ Approved
📊 Gate Distribution (Today)
👤 Pre-registration Queue
CompanyTypeETAGateStatus
ABC LogisticsTruck 14:00Gate 1 ⏳ Pending
XYZ CorpCar 15:30Gate 3 ✓ Approved
FastCargo Sdn BhdTruck 16:00Gate 1 ⏳ Pending
Mega TransportVan 16:45Gate 2 ✓ Approved
🚦 Gate Status Overview
Gate 1
380
🟢 Open
Gate 2
290
🟢 Open
Gate 3
210
🟢 Open
Gate 4
140
🟡 Busy
🚫 Blacklist Incidents Today
2 Hits
TimePlateGateReasonAction
09:38 CAR-001X Gate 2 Unauthorized Security Alert
07:15 TR-9911 Gate 1 Expired pass Under Review
Trucks🚛
48%
684 vehicles
Cars & SUVs🚗
32%
457 vehicles
Forklifts🏗️
12%
171 vehicles
Buses & Others🚌
8%
114 vehicles
📊 Classification Breakdown
AI Vision
📈 Hourly Traffic by Type
Live
🤖 AI Classification Confidence
94.2% Accuracy
🚛 Trucks 97.3%
🚗 Cars 96.1%
🏗️ Forklifts 91.8%
🚌 Buses 88.5%
🤖 ANPR camera + deep learning model classifies vehicles in real-time. Misclassified entries are flagged for manual review.
Total On-site👥
285
↑ +18 since 08:00
Zone A — Production📍
42
Capacity: 80
Zone B — Warehouse📍
88
⚠ Near capacity (110)
Near-miss Events⚠️
1
⚠ Review required
📊 Zone Occupancy (Live)
Live
📋 Zone Capacity Detail
ZoneNameCurrentCapacityUtilisationStatus
AProduction Floor 4280
53%
Normal
BWarehouse 88110
80%
Near Full
CLoading Bay 65150
43%
Normal
DAdmin Block 55120
46%
Normal
ECanteen / Rest Area 35200
18%
Normal
🔥 Pedestrian Heatmap
AI Vision Live
🤖 AI Overlay Active
⚠ Zone B Near Capacity
High Med Low
📈 Hourly Count Trend
🕐 Recent Incidents
1 open
09:17 Pedestrian detected in vehicle lane near Gate 4 — cleared
08:45 Crosswalk C — vehicle yielded correctly
08:02 Zone B headcount reached 80% — supervisor notified
Avg Speed Today
23 km/h
✓ Within 30 km/h limit
Speeding Events⚠️
7
↑ +3 vs yesterday
Highest Speed🚨
58 km/h
⚠ FKL-03 · Zone B3
Speed Limit🛑
30 km/h
Plant-wide enforced
📊 Speed Distribution (Today)
AI Analysis
📍 Speed by Zone
Zone A2 — Production Entry Max: 45 km/h ⚠
Avg 18 km/h · 2 violations
Zone B3 — Warehouse Road Max: 58 km/h ⚠
Avg 22 km/h · 4 violations (hotspot)
Zone C1 — Admin Road Max: 28 km/h ✓
Avg 16 km/h · 0 violations
Zone D — Loading Bay Max: 32 km/h !
Avg 20 km/h · 1 violation
📋 Recent Violations
TimePlateType SpeedZoneStatus
09:42FKL-03 Forklift38 km/h B3 ⚠ Warning
09:18TR-112 Truck45 km/h A2 ✗ Critical
08:55CAR-221 Car58 km/h B3 ✗ Critical
08:30VAN-88 Van35 km/h D ⚠ Warning
07:54FKL-07 Forklift41 km/h B3 ✗ Critical
07:21TR-880 Truck34 km/h A2 ⚠ Warning
06:45CAR-107 Car33 km/h D ⚠ Warning
📈 Violation Trend (7 Days)
Total Slots🅿️
500
4 zones · A B C D
Occupied🚗
340
↑ +22 since 08:00
Free Slots
160
✓ Available now
Utilisation📊
68%
Peak at 14:30
🅿️ Parking Bay Map — All Zones
Live
Free Occupied
📍 Zone-by-Zone Status
Zone A — General 95 / 150 (63%)
Zone B — Staff 120 / 150 (80%)
Zone C — Visitor 75 / 100 (75%)
Zone D — Heavy Vehicle 50 / 100 (50%)
📈 Occupancy Trend (24h)
🚛 Truck Staging Queue
3 Waiting
TruckWaitingBayETA FreeStatus
TRK-200 22 minBay A~10 min Waiting
TRK-315 18 minBay B~25 min Waiting
TRK-441 12 minBay A~10 min Waiting
🤖 AI Parking Prediction
Neural Model
🅿️
Activate Zone D Overflow at 14:00
Predicted 92% occupancy by 14:30 based on historical patterns. Activate 50 overflow slots in Zone D to prevent congestion.
🚦
Direct Trucks to Zone D Pre-emptively
3 pre-registered trucks arriving 14:00–16:00. Assign Zone D staging to reduce Bay A wait time by ~18 minutes.
Risk Score🛡️
35
Moderate level
Anomalies Detected🔍
4
⚠ 1 critical
Predictions Active
8
✓ All running
AI Accuracy🎯
94%
↑ +2% this week
📊 Traffic Prediction Model (24h)
Neural Network
💡 AI Recommendations
3 Active
Reduce speed limit in Zone B3
3 violations detected in Zone B3 today. Consider reducing limit to 20 km/h during peak hours (08:00–17:00) to reduce incident risk.
🅿️
Open overflow parking at 14:00
Predicted 92% occupancy by 14:30. Activate Zone D overflow (50 slots) to prevent gate congestion and reduce truck wait time.
🚦
Pre-clear Gate 2 for incoming trucks
3 pre-registered trucks arriving 14:00–16:00. Assign dedicated lane at Gate 2 to reduce average wait time by 18 minutes.
Flag TSK-0042 for fuel review
Vehicle BJK 5678 showing 14% higher consumption than fleet average for diesel pickups. Recommend fuel efficiency inspection.
🛡️ Safety Risk Score
35
MODERATE
Speed Violations 7 events today
Unauthorized Access 2 hits
Near-miss Events 1 today
Parking Overcrowding Normal
Fuel Anomalies 1 vehicle flagged
⚠️ Anomaly Log
4 today
09:38 Unauthorized vehicle CAR-001X at Gate 2 — security alerted
09:18 Forklift FKL-03 exceeded 30 km/h (38 km/h) in Zone B3
08:55 CAR-221 speed anomaly — 58 km/h recorded in Zone B3
08:30 Unusual vehicle clustering detected near Warehouse 4
📊 Risk Score Trend (7 Days)
📤 Generate Report
AI Summary
📄 PDF
📊 Excel
📋 CSV
📁 Export History
ReportPeriodFormatGenerated
Full Site ReportFeb 2024 PDF 24 Feb
Fleet BillingFeb 2024 Excel 01 Mar
Safety ReportJan 2024 PDF 31 Jan
📅 Scheduled Reports
ReportScheduleRecipientsStatus
Daily Summary Every day 07:00 admin@unicircuit.in ✓ Active
Weekly Safety Monday 08:00 safety@unicircuit.in ✓ Active
Monthly Billing 1st of month finance@unicircuit.in ✓ Active
Fleet KM Digest Every Friday 17:00 fleet@unicircuit.in ✓ Active
📊 Historical Traffic Trend (7 Days)
📈 Month-to-Date Highlights
March 2024
🚛 Avg daily gate traffic 1,428 vehicles
⚡ Total speed violations 47 events
🅿️ Peak parking occupancy 92% at 14:30
💰 Fleet fuel cost (MTD) ₹ 3,242.00
📍 Total billable KM (MTD) 18,420 km
🛡️ Avg safety risk score 35 / 100 (Moderate)
Total Users
18
👥
Active Now
6
🟢
Drivers
12
🚗
Admins / Supervisors
6
🛡️
👤 User Management
NameEmailRoleVehicle StatusLast LoginTasks (MTD)
A
Ahmad Razali
ahmad@unicircuit.in Admin WXY 1234 Active Now 14
S
Siti Nabilah
siti@unicircuit.in Driver BJK 5678 On Task 13:20 18
R
Ravi Kumar
ravi@unicircuit.in Driver PQR 9012 Active 12:00 11
L
Lim Chee Hoong
lim@unicircuit.in Supervisor DEF 3456 On Task 09:00 22
F
Farid Amir
farid@unicircuit.in Driver MNO 7890 Active 10:30 9
Z
Zul Hakim
zul@unicircuit.in Driver GHI 3456 On Task 14:10 16
🔐 Role-Based Access Control (RBAC)
🛡️ Admin
✅ All dashboard access ✅ User management ✅ System configuration ✅ Billing & invoices ✅ Fuel rate management ✅ Report generation
👔 Supervisor
✅ Task management ✅ View all reports ✅ Driver performance ✅ Fleet monitoring ❌ System config ❌ User management
🚗 Driver
✅ Own tasks only ✅ Check-in / Check-out ✅ Own KM & cost view ❌ Other drivers' data ❌ Billing & invoices ❌ System access
Register Vehicle
Upload Vehicle Data
VehicleDetailTemplate.csv
Upload bulk vehicle registration data in CSV.
Recent Registrations
VehicleOwnerStatusAdded
WXY 1234Ahmad RazaliActiveToday
BJK 5678Siti NabilahPendingYesterday
DEF 3456Lim Chee HoongReview2 days ago
Total Vehicles
264
+12 this month
Active Today
198
+8 vs yesterday
Average Speed
23 km/h
-2 km/h
Maximum Speed
58 km/h
FKL-03
Vehicle Count by Campus
Speed Distribution
Vehicle Count Details
CampusVehiclesActiveAvg SpeedUpdated
Plant A1209224 km/h2 min ago
Plant B846122 km/h5 min ago
Plant C604520 km/h7 min ago
Report Filters
Violations Trend
Violations by Zone
Violation Summary
TypeCountCriticalTop Zone
Overspeed478Zone B3
No Helmet182Zone A1
Uncontrolled61Zone C2
Violation Logs
TimeVehicleViolationSpeedZoneStatus
09:42FKL-03Overspeed38 km/hB3Critical
09:18TR-112No Helmet--A2Warning
08:55CAR-221Overspeed58 km/hB3Critical
08:32VAN-310Uncontrolled--C2Resolved
Register Violation
Speed Range
Recent Manual Entries
VehicleTypeStatus
TR-112No HelmetPending
CAR-221OverspeedProcessed
Challan Rules
Auto-generate challan
Create challan on critical overspeed
Email vehicle owner
Send challan via email
SMS owner contact
Optional SMS notification
Speed Ranges
FromToSeverityAction
3040WarningEmail
4050CriticalEmail + SMS
50+--CriticalAuto Challan
Total Devices
48
+4 added
Online
42
Healthy
Offline
6
Needs review
Alerts Today
3
2 camera errors
Device Status
Device IDCamera IPLocationStatusLast Seen
CAM-0110.0.1.12Gate 1OnlineNow
CAM-0710.0.2.18Zone B3Warning5 min ago
CAM-1110.0.3.05Zone C2Offline32 min ago
Add New Device
Roles & Permissions
RoleAccessUsers
AdminFull access4
SupervisorView + Approvals7
DriverTasks + Check-in32
Create Role
SMTP Configuration
Email Queue
TimestampRecipientSubjectStatus
10:02owner@fleet.comOverspeed ChallanSent
09:47ops@fleet.comDaily Violations ReportQueued
09:12admin@fleet.comDevice OfflineRetry
Zone Map
Zone Map Placeholder
Add Zone
Configured Zones
ZoneTypeSpeed LimitAlerts
Zone A1Speed Zone25 km/hEmail
Zone B3Speed Zone30 km/hEmail + SMS
Gate 2Pedestrian10 km/hDashboard
🏗️ System Architecture Overview
4-Layer Stack
Layer 1 — Data Sources
📡 GPS Devices
Vehicle trackers (MQTT / REST)
⛽ Fuel Price API
PPAC India / CollectAPI
📱 Driver Mobile App
Check-in / Check-out
🚦 AI Traffic Cameras
ANPR · Speed Radar · CCTV
🌐 Web Scraper
IOCL / BPCL prices
🅿️ Parking Sensors
IoT ultrasonic / IR sensors
↓↓↓
Layer 2 — Backend Services (Node.js / FastAPI)
🔐 Auth Service
JWT + RBAC
🗺️ GPS Service
Real-time tracking
📋 Task Service
Assignment + check-in/out
⛽ Fuel Rate Engine
Auto / manual rate mgr
💰 Billing Engine
KM × Rate = Invoice
🤖 AI Traffic Engine
Vision · classification · risk
🔔 Notification
Alerts + geofence triggers
↓↓↓
Layer 3 — Data Storage
🗄️ PostgreSQL
Users · tasks · billing · contracts
⚡ Redis Cache
Live GPS + fuel rates
📦 TimescaleDB
GPS time-series data
☁️ S3 / Blob Storage
Invoice PDFs · reports
↓↓↓
Layer 4 — Frontend Clients
🖥️ Admin Dashboard
Elementor HTML Widget
📱 Driver Mobile
React Native / Flutter
📊 Reports Portal
PDF / Excel export
🔐 Authentication Flow
User Login Request
↓ POST /api/auth/login
Validate Email + Password (bcrypt)
↓ Check Role: Admin / Supervisor / Driver
Generate JWT Token (expires: 8h)
↓ Return token + user profile + permissions
Frontend stores token (httpOnly cookie)
Role-Based Access Control (RBAC)
Admin → Full access to all modules
Supervisor → Tasks + Reports + Fleet view
Driver → Own tasks + Check-in/out only
📍 GPS Billing Logic
Driver checks in → Task starts
↓ GPS begins recording lat/lng every 10s
Haversine formula calculates incremental distance
↓ KM accumulated = WORK KM (billable)
Driver checks out → Task ends
↓ Final work KM locked — no edits allowed
Non-task GPS movement → Personal KM (excluded)
Litres = (Work KM × Consumption) ÷ 100
Cost = Litres × Current Fuel Rate
Invoice = Σ Cost (per billing period)
🔒 Anti-abuse: KM values are GPS-locked. Manual edits rejected by API.
🗄️ Database Schema — PostgreSQL
6 Core Tables
👤users
idPKUUID
emailVARCHAR UNIQUE
password_hashVARCHAR
full_nameVARCHAR
roleENUM(admin,supervisor,driver)
is_activeBOOLEAN
last_loginTIMESTAMP
created_atTIMESTAMP
🚗vehicles
idPKUUID
plate_numberVARCHAR UNIQUE
modelVARCHAR
vehicle_typeVARCHAR
fuel_typeENUM(ron95,ron97,diesel,ev)
gps_device_idVARCHAR
contract_idFKUUID
assigned_driverFKUUID → users
consumption_per_100kmDECIMAL(5,2)
is_activeBOOLEAN
📋tasks
idPKUUID
task_codeVARCHAR UNIQUE
descriptionTEXT
vehicle_idFKUUID → vehicles
driver_idFKUUID → users
statusENUM(pending,active,completed)
checkin_timeTIMESTAMP
checkout_timeTIMESTAMP
work_kmDECIMAL(8,2)
is_km_lockedBOOLEAN DEFAULT false
notesTEXT NULLABLE
📍gps_logs
idPKUUID
vehicle_idFKUUID → vehicles
task_idFKUUID → tasks (nullable)
latitudeDECIMAL(10,8)
longitudeDECIMAL(11,8)
speed_kmhDECIMAL(5,2)
is_billableBOOLEAN
distance_from_prevDECIMAL(8,4)
recorded_atTIMESTAMPTZ
fuel_rates
idPKUUID
fuel_typeENUM(ron95,ron97,diesel,ev)
rate_per_litreDECIMAL(6,4)
sourceENUM(auto,manual,contract)
source_urlVARCHAR NULLABLE
effective_fromDATE
effective_toDATE NULLABLE
set_byFKUUID → users
is_activeBOOLEAN
💰invoices
idPKUUID
invoice_codeVARCHAR UNIQUE
vehicle_idFKUUID → vehicles
billing_period_startDATE
billing_period_endDATE
total_work_kmDECIMAL(10,2)
total_litresDECIMAL(10,4)
avg_fuel_rateDECIMAL(6,4)
total_amountDECIMAL(10,2)
statusENUM(draft,pending,approved,paid)
approved_byFKUUID → users
pdf_urlVARCHAR NULLABLE
👥 Active Sessions
UserRoleLast ActiveStatus
Admin ManagerAdministratorNow Online
Security LeadSupervisor5 min ago Online
Ops ManagerSupervisor1h ago Away
Gate Operator 1Operator2h ago Offline
🔌 Integrations
ServiceTypeStatus
SAP ERPLogistics Connected
PPAC India Fuel APIFuel Pricing Active
Weather APIEnvironmental Active
SMS GatewayNotifications Active
CollectAPIFuel Backup Standby
💻 Device Status
📡
ANPR Cameras
12 / 12 online
Speed Radars
8 / 8 online
📍
GPS Trackers
24 / 24 active
🅿️
Parking Sensors
498 / 500 online
⚙️ System Configuration
🔔 Notification Settings
Speed violation alerts
Notify supervisor on every violation
Geofence breach alerts
Alert when vehicle exits assigned zone
Fuel rate auto-sync
Auto-update rates from PPAC India daily
Parking overflow alerts
Alert at 85% capacity threshold
Unauthorized access alerts
Instant security notification on blacklist hit
📋 Assign New Task
🚗 Register Vehicle
👤 Add User
🔲 Vehicle QR Sticker Generator
🔲 Vehicle Details
Quick Load — Fleet
🔲
Fill in vehicle details and click
Generate QR Sticker