Geofence-validated attendance
Supervisor scans capture GPS and timestamps. Accepted check-in and check-out events create one attendance unit per truck and business day under defined business rules.
Project 03
EDC Operation Management System
A bilingual, offline-capable operations platform that replaces manual truck timesheets with geofence-validated field events, approval workflows, and locked vendor billing outputs.
Overview
Oilfield Fleet Attendance, Compliance & Billing
The EDC Operation Management System digitises truck operations across oilfield sites and rigs. A supervisor scans a driver or truck QR code in the field, the system captures time and GPS evidence, validates the event against the active geofence, and converts accepted operational activity into auditable attendance and billing data.
The platform serves four roles through purpose-built web and Flutter interfaces. It supports disconnected field work, approval-controlled exceptions, truck movement tracking, document expiry monitoring, vendor self-service, immutable audit history, and Excel timesheet export without hard-deleting operational records.
- Audience
- System administrators, vendors, rig supervisors, and drivers
- Operational scope
- Oilfield sites, rigs/primas, vendors, trucks, and drivers
- Delivery
- Admin/Vendor web · Supervisor/Driver mobile
154 trucksSeeded operational fleet
40 daysDemo operational history
4 rolesAdmin, vendor, supervisor, driver
AR / ENBilingual web and mobile
Main features
A connected operational experience.
Offline-first field operations
Hive-backed queues preserve check-ins, violations, manual entries, and half-day requests without connectivity, then synchronise and revalidate against original event times.
Approvals and violations
Violations, manual entries, adjustments, and half-day requests move through Sys Admin approval. Vendor-visible deductions appear only after approval.
Truck movement control
Site-to-site, rig-to-rig, initial assignment, and correction movements track expected arrival, current state, arrival, cancellation, and operational notifications.
Auditable timesheets
Readiness checks expose unresolved issues before generation. Generated timesheets lock covered truck and date combinations and export to Excel with one worksheet per truck.
Versioned geofences
Each rig/prima geofence is maintained through versioned polygons and validity windows, preserving the spatial rule applied to historical events.
Vendor and fleet management
Administrators oversee vendors, sites, rigs/primas, categories, price history, trucks, drivers, supervisors, assignments, and operational states.
Vendor self-service
Vendors access only their trucks, drivers, movements, violations, documents, notifications, and timesheets through an isolated portal.
Documents and review queues
Expiry heat maps identify expired or soon-to-expire files, while suspicious offline or conflicting events enter a review queue before billing.
Notifications, audit, and settings
Contextual bilingual notifications support each role. Every state change is recorded in the audit log and configurable business parameters are centrally managed.
Workflows
Designed around the way work actually happens.
01
Daily attendance
- 01
Driver presents the assigned truck QR
- 02
Supervisor scans at the rig and captures GPS
- 03
Backend validates the active geofence
- 04
Check-in and later check-out events are recorded
- 05
The truck receives its attendance unit for the business day
02
Offline synchronisation
- 01
Supervisor records work with no connection
- 02
Events remain in the local Hive queue
- 03
The app synchronises when connectivity returns
- 04
Backend revalidates original timestamps and geofence evidence
- 05
Conflicts become review items for Sys Admin
03
Violation to billing
- 01
Supervisor creates a field violation
- 02
Sys Admin reviews and enters a required deduction
- 03
Approval makes the deduction effective
- 04
The deduction enters the next eligible timesheet
- 05
Vendor sees the approved financial impact
04
Timesheet generation
- 01
Select scope and date period
- 02
Run readiness checks for pending or missing data
- 03
Resolve blockers
- 04
Generate and lock truck/date combinations
- 05
Export the auditable Excel workbook
05
Truck movement
- 01
Create a site or rig movement order
- 02
Set the truck to In Transit with expected arrival
- 03
Confirm arrival through field activity or administration
- 04
Update the current operational assignment
- 05
Notify stakeholders about delays or cancellation
Architecture
Technology selected for geospatial performance and operational reliability.
Clean Architecture separates a React operations suite, Flutter mobile workflows, an ASP.NET Core API, and PostgreSQL persistence. Optimistic concurrency, audit records, role isolation, offline queues, and test coverage support reliable operational behaviour.
- ASP.NET Core 8
- EF Core 8
- PostgreSQL 16
- JWT
- React 18
- Vite
- TypeScript 5
- Tailwind CSS
- shadcn/ui
- TanStack Query
- Flutter 3
- Riverpod
- Hive
- QR generation and scanning
- xUnit
- Vitest
- Playwright
- Docker Compose
- React i18next
- Flutter ARB
Screenshots
Product experience, fully documented.
Every supplied project image is presented at its natural aspect ratio. Select any screenshot to inspect it at full size.
System overview dashboard
The Sys Admin dashboard summarises vendors, sites, rigs, fleet status, approvals, documents, and movements.
Supervisor QR scan
The field scan screen recognises the assigned truck QR and prepares a GPS-backed attendance action.
Supervisor home and offline operations
The mobile home screen exposes the assigned rig, geofence version, quick actions, and offline-capable field workflows.
Approval queues
Pending violations and related approval types are reviewed with context, financial input, and accept or reject actions.
Manual entries and adjustments
Exception workflows let authorised users create operational entries or financial attendance adjustments for approval.
Truck movements
Current and historical movements expose source, destination, expected arrival, status, and operational actions.
Sys Admin timesheets
Scope controls, readiness checks, timesheet status, totals, and exports support controlled billing generation.
Vendor timesheets
The vendor portal restricts timesheets to the vendor fleet and provides status, totals, and export access.
Geofence editor
A rig geofence is edited on the map while version information and validity details remain visible.
Sys Admin operational dashboard
Operational KPIs and attention panels bring approvals, document expiry, and active work into one view.
Truck management
The administrator reviews fleet records, categories, approval status, operating state, and current assignment.
Vendor dashboard
Vendor-specific cards and queues summarise active trucks, issues, documents, and notifications.
Document tracking
Truck and driver files are presented with expiry dates, validity states, attachments, and renewal actions.
Review queue
Suspicious or conflicting operational events are resolved or rejected before they can affect final billing.
Driver QR application
The driver app displays the assigned truck identity and QR code for supervisor scanning.