Roadmap: Production Finalization (P0–P3) – Sigortacu

[Kinin-Code-Offical]

This issue tracks the multi-phase effort to make the Sigortacu repository production-ready.

See the main plan in Discussion #79.

This issue will serve as a checklist. Each item will link to a dedicated implementation issue.

Phase 0: Stabilization

• P0: Fix CarInfo API contract mismatch (assetID vs ID) (P0: Fix CarInfo API contract mismatch (assetID vs ID) #81)
• P0: Standardize API response envelope (P0: Standardize API response envelope #82)

Phase 1: DB & Local Dev

• P1: Fix sigortacudb.sql and add migrations (P1: Fix sigortacudb.sql and add migrations #83)
• P1: Add docker-compose local stack (mysql + php) + env templates (P1: Add docker-compose local stack (mysql + php) + env templates #84)

Phase 2: Security & Auth

• P2: Standardize auth to JWT (deprecate phpPassword) (P2: Standardize auth to JWT (deprecate phpPassword) #85)
• P2: Refactor raw SQL endpoints to prepared statements (P2: Refactor raw SQL endpoints to prepared statements #86)

Phase 3: CI/CD & Releases

• P3: Add GitHub Actions CI for Flutter + PHP (P3: Add GitHub Actions CI for Flutter + PHP #87)
• P3: Release process + CHANGELOG + docs enforcement (P3: Release process + CHANGELOG + docs enforcement #88)