ENTERPRISE FULL-STACK ARCHITECTURE

Laravel 11 & Next.js 14 System Architecture

High-performance decoupled architecture designed for sub-second page loads, bank-grade API security, and resilient MySQL persistence at our Waluj HQ operations.

System Topology

Decoupled SSG & REST API Topology

Next.js 14 SSG Frontend

Pre-rendered static HTML/CSS/JS served directly from edge Apache servers. Zero Node.js CPU overhead, sub-second TTFB, and offline-capable client state.

Tech: React 18, TypeScript, Tailwind CSS, Lucide

Laravel 11.2 API Core

PHP 8.2+ stateless REST API engine enforcing strict typing, CORS hardening, Sanctum token authentication, and rate-limited endpoints.

Base URL: api.omagrodrone.com/api

MySQL 8.0 Waluj HQ Database

Enterprise relational persistence with foreign key constraints, atomic transactions, and automated daily backup dumps via Artisan CLI.

Tables: 8 Production Schemas

Database Schemas & Eloquent Models

8 Production Database Tables (MySQL 8.0)

Table: dronesEloquent Model

Drone fleet specifications, payload capacities, AUW ratings, and commercial subsidy pricing.

Key Columns:

id (PK)model_nameslugtank_capacityauw_weightmax_auw_kgcoverage_per_dayspray_systembase_pricenet_farmer_pricestatus

Table: dgca_certificatesEloquent Model

Statutory compliance tracking, official Type Certificate TC-2924-009988, and chassis UIN plates.

Key Columns:

id (PK)drone_id (FK)model_nameuin_number (UK)certificate_novalid_fromvalid_untilcompliance_statusrpto_training_partner

Table: inventory_partsEloquent Model

Real-time stock management across 23 standardized factory kit components at Waluj & Paithan plants.

Key Columns:

id (PK)part_number (UK)component_namecategorystock_qtyminimum_reorder_qtywarehousestorage_bayunit_cost_inr

Table: export_shipmentsEloquent Model

International export logistics tracking to Jeddah Islamic Port, Saudi Arabia (Aldayfe client).

Key Columns:

id (PK)consignment_number (UK)importer_clientdestination_portad_codeiec_numberhs_codeunits_countshipment_status

Table: workshop_stationsEloquent Model

8-station manufacturing bay operational status, tooling specifications, and quality gate ownership.

Key Columns:

id (PK)station_number (UK)station_namefacility_plantprimary_operationtooling_specquality_gate_codestatus

Table: assembly_sopEloquent Model

Step-by-step 8-stage precision drone assembly sequence, quality gates G0–G8, and hold points H1–H4.

Key Columns:

id (PK)stage_numberstage_nameresponsible_stationquality_gatemandatory_checksacceptance_criteriahold_point

Table: aadiyogi_metricsEloquent Model

CSR afforestation tracking, 100,000 tree plantation count, drone seed ball dispersal, farmer literacy.

Key Columns:

id (PK)campaign_nametarget_treesplanted_treessurvival_rate_percentfarmers_trainedvillages_coveredseed_ball_payload_dispersed

Table: taluka_dealersEloquent Model

Franchise dealership network management across rural talukas and agricultural districts in Maharashtra.

Key Columns:

id (PK)dealer_namebusiness_nametalukadistrictstatephoneannual_drone_quotaservice_center_statusstatus

REST API Specification

Core Production API Endpoints

GET/api/dronesList all DGCA certified drone fleet models

GET/api/dgca/verify?uin={UIN}Verify statutory DGCA certificate by UIN plate

GET/api/inventoryFetch real-time stock of 23 factory kit parts

GET/api/exportsTrack Jeddah Port export consignments

POST/api/dealers/inquirySubmit Taluka franchise dealership inquiry