This is NOT a new development project. This is a targeted backend stabilization and correction project based on a full production audit. The system is already built (Laravel + MySQL + Redis), but critical issues were identified during automated validation. The objective is to fix specific failing modules and ensure the system becomes production-ready. ━━━━━━━━━━━━━━━━━━━━━━━ CURRENT SYSTEM STATUS ━━━━━━━━━━━━━━━━━━━━━━━ A full backend validation was executed directly in production. Critical failures identified: - Financial inconsistency (token purchases without ledger entries) - Escrow system incomplete (missing required columns and lifecycle) - Subscription system not functional (missing structure and logic) - Boost system incomplete (missing required fields and ranking logic) - Database structure inconsistent with application logic - Security vulnerabilities (admin routes without authentication) - No confirmed revenue split implementation - Core flows failing during simulation ━━━━━━━━━━━━━━━━━━━━━━━ SCOPE OF WORK ━━━━━━━━━━━━━━━━━━━━━━━ The developer must FIX and VALIDATE the following modules: 1. Ledger Integrity - Ensure every financial transaction generates ledger entries - Enforce append-only ledger logic - Eliminate direct balance mutation 2. Escrow Lifecycle - Implement full lifecycle: created → active → completed → released/refunded - Ensure atomic transactions - Guarantee no double settlement 3. Token Purchase Flow - Ensure token purchases generate: - ledger entries - correct balance updates - Validate consistency between payments and ledger 4. Subscription System - Fix database structure - Implement recurring logic - Validate activation, renewal, expiration, cancellation 5. Boost System - Fix database structure (user_id, amount, etc.) - Implement ranking priority logic - Implement expiration handling 6. Database Alignment - Fix missing columns: - escrows: user_id, amount, status - subscriptions: user_id - Ensure schema matches backend logic 7. Security Fixes - Protect all admin routes with authentication middleware - Ensure no financial endpoints are publicly accessible 8. Revenue Split - Implement or validate platform/streamer commission logic - Ensure consistency across all financial operations ━━━━━━━━━━━━━━━━━━━━━━━ MANDATORY DELIVERABLES ━━━━━━━━━━━━━━━━━━━━━━━ 1. End-to-end video demonstration (REQUIRED) Must show: - Token purchase - Ledger entry generation - Escrow lifecycle - Subscription working - Boost working - Admin reflecting correct data 2. Production validation All flows must run successfully on production server. 3. Code delivery - Clean, structured commits - No temporary fixes - No hardcoded logic 4. Final validation report System must pass validation without critical failures. ━━━━━━━━━━━━━━━━━━━━━━━ IMPORTANT ━━━━━━━━━━━━━━━━━━━━━━━ - This is a FIXING and VALIDATION project, not a redesign - Do NOT propose rewriting the system - Do NOT send generic proposals - Only apply if you have real experience with: - Laravel financial systems - payment flows (Stripe or similar) - escrow logic - production debugging Timeline: 5 a 7 days