Project Overview We are extending an existing Python/Flask-based system that parses theatrical Playbill PDFs and stores structured data (actors, shows, theaters, roles). Phase 1 is complete. We are now moving into Phase 1.2, which focuses on public-facing views, Joomla integration, and deployment. This is not a greenfield project. Current System (Already Built) Python + Flask application Admin UI for: Uploading Playbill PDFs Parsing cast & crew Human review / edit / approve Structured MySQL schema Categories handled: Cast, Ensemble, Swings, Dance Captain, Understudies Equity (union) detection via asterisk (*) Clean, working proof already demonstrated Phase 1.2 Scope (What You Will Build) 1. Public Read-Only Views Actor profile pages Show pages Theater pages IMDb-style navigation between them 2. Actor Profile Enhancements Credits grouped by discipline Equity indicator per show (not global) Simple USA map showing theaters an actor has worked at Read-only No advanced analytics or sharing logic 3. Search & Browsing Global search across actors, shows, theaters Filters (e.g. Equity vs Non-Equity) 4. Duplicate Protection Prevent duplicate Playbill uploads Detect duplicates using: Show name Theater Date / year 5. Joomla Integration (Mandatory) Client site is built on Joomla Existing Theater database must be reused No duplicate theater records Integration can be via: Joomla module API-based embedding Menu routing Public pages must feel native to Joomla 6. Deployment (Mandatory) Deploy system to client’s server Configure Flask environment Wire MySQL connections Verify production access Technical Requirements Strong experience with: Python Flask MySQL Experience integrating with CMS platforms (Joomla preferred) Comfortable deploying production apps Must understand relational data modeling Must write deterministic logic (no hallucinating AI extractors) Important Notes This phase is read-only for public users No user accounts No payments No subscriptions No mobile apps (future phase) Deliverables Live deployment on client server Public Actor / Show / Theater pages Working search & navigation Joomla integration verified Duplicate upload protection How to Apply Please include: Relevant Flask + MySQL projects Experience with Joomla or CMS integrations Fixed-price quote for Phase 1.2 Estimated timeline ⚠️ Do not apply if you are planning to rebuild the system from scratch.