Expanding Truck Import Management Platform

# PROYECTO FREELANCER --- ## RESUMEN (español) Se busca desarrollador backend con experiencia en **Python/Flask, JavaScript y MySQL** para ampliar una plataforma de gestión de importación de camiones desde Europa. El sistema ya tiene un backend funcional para las áreas de técnicos, taller y cliente. El trabajo consiste en añadir las nuevas áreas internas (Precompra y Postcompra), mejorar la autenticación y conectar la pasarela de pago con Stripe. Se proporciona documentación completa: prototipo HTML con todos los flujos definidos y un documento de requisitos detallado en inglés. Plazo aproximado: **5 semanas**. Presupuesto: **800 € – 2.000 €**. --- ## PROJECT DESCRIPTION (English) We are looking for a backend developer to extend an existing vehicle import management platform built with **Python (Flask) + MySQL**. ### What already exists (do not rebuild) The platform already has a working backend for: - Technician area — full inspection workflow, 13-tab form, draft/autosave, multimedia via SFTP, PDF report generation with Playwright. - Workshop area — client management, inspections, adjustments. - Client area — panel, inspections, adjustments. - Public website — static pages, served by Flask. All of this is in production and must not be broken. ### What needs to be built **1. Authentication migration (required before anything else)** The current authentication system needs to be upgraded before adding new areas: - Migrate to token-based authentication (JWT or Flask sessions). - Improve password security. - Add role-based endpoint authorization. - Review CORS policy. **2. New user roles and login routing** Add three new internal roles to the existing login system ([login to view URL]): - PRECOMPRA — redirects to Precompra area after login. - POSTCOMPRA — redirects to Postcompra area after login. - ADMIN — access to both areas. After login, store role and user name in sessionStorage so the frontend builds the correct navigation header automatically. **3. Precompra area (new — full backend)** - Lead management: receive leads from website forms (contact, vehicle search, vehicle detail page), create leads manually, manage statuses. - Internal vehicle stock: add vehicles manually, assign to one or multiple clients, track status (unassigned / assigned / reserved / sold). - Client file: channel configuration (direct / via workshop / both), proposed vehicles, notes, conversion to Postcompra (with payment validation). - Connection to technician area: when an inspection is finalised, notify Precompra automatically. **4. Postcompra area (new — full backend)** - Import file management with 6 tabs: Documents, Payments, Transport, Homologation, Chat, Activity. - Phase tracking: advance phases, propagate status updates to client area in real time. - Homologation incidents: assign to workshop or client, propagate visibility automatically. - Payment blocking rules: certain phases cannot advance until specific payments are confirmed. - Completed imports: list, reopen for warranty or post-delivery incidents. **5. Client area extensions** - Dashboard showing active phases (reviews, precompra, postcompra). - Proposed vehicles view: client marks preferences. - Import tracking: phases, progress, incidents assigned to client. - Document management: view requested documents and upload them. - 'I want to import it' button: creates a lead in Precompra automatically. **6. Workshop area extensions** - Assigned homologation incidents: view, comment, upload resolution photos. - Workshop billing: view own earnings from collaborating with IC (never sees IC margins or commissions). **7. Stripe payment integration (new)** Integrate Stripe for the paid services on the public website (vehicle search from €69, inspection from €269). After successful payment: create CLIENT account automatically and send credentials by email, create lead in Precompra. **8. Internal billing — Postcompra (new)** Invoice management for the internal team: list, summary by concept, mark as paid, send reminders, download PDF. **9. Account creation and credential delivery** All accounts are created by Importar Camión — no self-registration. The system must support manual account creation (client, workshop, technician) with automatic credential email delivery. --- ### Technical stack - **Backend:** Python / Flask - **Database:** MySQL - **Production server:** Gunicorn - **PDF generation:** HTML template to PDF (current implementation needs to be reviewed and improved as part of this project) - **Frontend:** HTML + vanilla JavaScript (no framework, no build system) - **Media storage:** SFTP server (separate from the app server) - **Email:** SMTP - **Config:** python-dotenv --- ### What you will receive - Full HTML prototype of all areas with annotated buttons and forms. - Backend requirements document (English) covering endpoints, business rules, flows and connections between areas. This document reflects the current state — minor details may evolve during development, please flag anything unclear before implementing. - Existing backend code. - Document describing what is already implemented and what needs to be built from scratch. - Server access documentation (SSH, deployment guide). --- ### Requirements - Solid experience with **Python and Flask**. - Experience with **MySQL**. - Experience integrating **Stripe**. - Ability to work with an existing codebase without breaking it. - Clear communication — if something in the requirements is unclear or incomplete, flag it before implementing rather than making assumptions. - Deliver within **5 weeks**. --- ### Budget €800 – €2,000 depending on experience and approach. Fixed price preferred. Please include a brief breakdown of how you would approach this project in your proposal.

Project ID: 40541204