Projects using MySQL in SindhProjects using MySQL in Sindh
Cover image for Vanguard & Sterling LLP -
Vanguard & Sterling LLP - Ultra-Luxury Corporate Litigation Web Platform & Executive Portal Role & Services Role: Lead Full-Stack Web Architect & Product Designer Services: Custom WordPress Development, Full-Stack Architecture, UI/UX Design System, LegalTech Engineering, Cloud DevOps (Docker & Railway) Project Overview Vanguard & Sterling LLP is an elite corporate defense and appellate litigation practice operating in high-stakes venues, including the Delaware Court of Chancery and the U.S. Federal Courts. The objective was to transcend conventional corporate legal websites by creating an ultra-luxury sovereign web presence coupled with an authenticated Executive Portal Enclave. The platform provides clients, general counsels, and senior partners with real-time court docket synchronization, conflict-of-interest clearance screening, an FRCP 26(b)(3) privileged document vault, and an ABA Model Rule 1.15-compliant IOLTA fiduciary trust ledger. The Challenge Generic Industry Norms: Traditional law firm websites feel sterile, outdated, and template-driven, failing to project the prestige and authority required for multi-billion-dollar corporate disputes. Dual-Sided Architecture: The platform needed to serve two distinct audiences: prospective Fortune 500 corporate clients seeking counsel, and authenticated enterprise clients/partners accessing privileged litigation work product. Complex Compliance & Data Handling: Legal-grade compliance demands: strict ABA Model Rules 1.6 (Confidentiality), 1.7–1.10 (Conflicts of Interest), and 1.15 (Trust Accounting) workflows with segregated access controls. The Solution & Deliverables Bespoke Sovereign Design System Visual Aesthetic: Tailored obsidian dark mode palette (#060A14, #0A1224), brushed champagne and royal gold accents (#B89552, #DFC080), and polished marble glassmorphism (backdrop-filter: blur(16px)). Institutional Typography: Classical stone-carved judicial serif (Cinzel) paired with contemporary structural sans-serif (Plus Jakarta Sans) and editorial body type (Cormorant Garamond). Interactive Micro-Interactions: Real-time ticker feeds, responsive chamber locator maps across Wilmington, Washington D.C., New York, and London, and zero-flicker glass modals. Executive Portal & Sovereign CMS Modules Engineered an administrative control suite natively inside WordPress without relying on bloated third-party plugins: Certified Litigation Dockets (vg_matter): Chronological procedural histories with PACER docket numbers, presiding judge assignments, and hearing schedules. IOLTA Trust Ledger & Statements (vg_invoice): Complete fiduciary trust accounting engine tracking escrow balances, monthly legal fee drawdowns, itemized hours/disbursements, and instant PDF generation. Conflict Clearance Desk (vg_conflict): Real-time conflict checking mechanism with SLA response countdowns, adverse party tracking, and ethical wall sequestration directives. Privileged Document Vault (vg_vault_doc): Work-product classification system featuring SHA-256 cryptographic digests, audit logs, and encrypted access gates. 3. Custom In-Dashboard Dossier Experience Built an in-dashboard dossier view (vanguard-portal-view) that eliminates public website headers and footers during administrative reviews while preserving the full WordPress CMS sidebar and top bar. Custom architectural twilight rendering on wp-login.php with frosted glass container cards and glowing focus states. Tech Stack & Tools Core Engine: WordPress (Custom Theme & MU-Plugin Architecture), PHP 8.2 Frontend: Semantic HTML5, Vanilla Modern CSS3, JavaScript (ES6+), SVG Vector Engineering Database & Hosting: MySQL, Docker Containerization, Railway Cloud Infrastructure Design & Assets: Custom Design System, Architectural Renderings, Font Interactivity (Google Fonts)
0
52
Cover image for Custom WordPress LMS Plugin —
Custom WordPress LMS Plugin — Khan Academy-Style Learning Platform Designed and built a complete Learning Management System from scratch as a WordPress plugin — no existing LMS framework — for a Portuguese-language personal finance education site. Architected a hybrid data model that keeps course content in WordPress custom post types (so editors keep native tooling) while moving all per-user state into 7 purpose-built MySQL tables, avoiding the postmeta bloat that cripples off-the-shelf LMS plugins at scale. Key work: • Mastery-based progression system with locked/available/completed unit paths and permanent quiz completion • Daily streak engine with activity heatmap to drive learner retention • Visual drag-and-drop certificate designer: admins upload a branded PDF and position fields, with resolution-independent normalized coordinates; output is a QR-coded, publicly verifiable PDF certificate • Automatic YouTube transcript extraction with click-to-seek video navigation • Cookie-based guest progress so visitors can start learning before creating an account • Google / Facebook / X social login and a custom student role • Standalone full-screen admin SPA served outside wp-admin, with a Chart.js analytics dashboard and CSV export • 13 Playwright end-to-end tests across the auth, learning, quiz, certificate, and admin flows Stack: PHP 8.3 · WordPress REST API · MySQL · Vite · Tailwind CSS · Alpine.js · Chart.js · Dompdf/TCPDF/FPDI · OAuth 2.0 · Playwright Website Usign This Plugin URL: https://financasparatodos.org/courses/educacao-financeira/ Github URL: https://github.com/hamzasispn/lms-plugin
0
63