Elnasser Backend & Logistics Engine

The project represents a highly sophisticated, enterprise-grade e-commerce and logistics backend built on the Laravel ecosystem. The system expertly handles multi-leveled product taxonomy, complex logistics (Internal Delivery Payroll, Delivery Fee Engine), scalable API architectures for a vast cross-platform ecosystem (powering 3 distinct mobile apps: Vendor, Delivery, and User, alongside a comprehensive e-commerce website), dynamic customer loyalty and tier programs, and real-time backend processing.

- Database & Query Optimization: Re-engineered the category system to move away from rigid 2-level nested loops to infinite-depth traversal using WITH RECURSIVE SQL CTEs. Implemented cache invalidation strategies using tree-version mechanics with Laravel Cache. Managed zero-downtime database schema upgrades for large datasets. - Background Jobs & Queue Processing: Real-time Trash System and Bulk Delete implementations running via Laravel Queues. Handlers softly delete nested subcategories recursively and flush storage/cache. UI maintains live interactivity using AJAX polling. - Comprehensive API Layer: Microservices-influenced separation using strict headers. Token-based auth via Bearer Tokens, secure password storage, and Multi-Factor/OTP. Robust Postman Collections integration dynamically exported via custom Artisan commands.

- Advanced Recursive Category Architecture: Unlimited subcategory levels allowing complex taxonomies. Implemented descendant/ancestor lookups using SQL CTEs. Deep API endpoints return nested tree JSON structures up to specific depths. - Category Groups API: Admin customizable "Groups" for dynamic storefront features, allowing carousels containing categories and products natively with level type mapping embedded in API responses. - Mobile App V1 API Expansion: Full checkout capability, offline payments via multipart/form-data with up to 5MB screenshot uploads, campaign tracking, and robust filtering rules for items intercepting dynamic query scopes. New checkout summary engine computes live projections for coupons and loyalty points. - Delivery Man Ecosystem & Payroll Engine: Completely functional dispatch and delivery portal. Solved critical visibility bugs for non-vehicular constrained orders. Internal delivery teams earn base monthly salaries plus task commissions while freelancers earn dynamic commissions. Engineered Delivery Fee APIs simulating costs based on distance, volumetric weight, and vehicle mappings. - Delivery & Payment Admin Reports: Dedicated reporting interfaces for delivery operations powered by Eloquent Scopes to resolve complex SQL ambiguity. Devised advanced Seeders demonstrating operational behavior logical flows. - Customer Loyalty, Tiers, & Referral Setup: Automated tiered setups (Bronze, Silver, Gold). End-to-end payload routing dynamically pushes user preferences configuration directly to the settings vault. Integrated helper logic calculating validation tokens natively at the payload layer without persistent coupon entities. Rigorous PHPUnit testing sequence to validate the calculations. - SMS OTP Authentication Protocol: Frictionless phone-based onboarding. Tri-state workflow handler mapping logic into new, old, and existing states seamlessly without premature auth token issuance. - Frontend Images & Dashboard Theme Overrides: System-wide native theme handling supporting layout partial overrides. Devilled an intelligent CSS pyramid grid engine visualizing category structures depending on recursive depth calculations. Dedicated UI bridging image payload storage dynamically. - Admin Tools & Python Automation: Orchestrated python helpers alongside PHP loops (seed_products.py, fetch_product_images.py, cleanup_category_images.py) destroying orphaned blobs, handling mass api integration (Pixabay), and processing raw file dumps efficiently.

- Nginx & Network Tuning: Deployed infrastructure overhauls interacting with Nginx server blocks, upgrading client_max_body_size thresholds allowing large payload delivery natively. - Advanced SSH Deployment Protocols: Developed custom single-process tar stream protocols bypassing SSH packet loss, cleanly deploying 1.2 GB of unstructured binary image data natively to server nodes.

Operating as the Lead Backend & DevOps Engineer, I architected this massive Laravel backend to scale. My work heavily centered on advanced database engineering, scalable API designs, caching, seamless queuing algorithms, and comprehensive DevOps pipeline optimizations.