Commit graph

  • bb38d354e5 fix(geocode): precise location geoms survive delta re-upserts (FT-BUG-01) fix/location-geom-resolution david kiania 2026-07-02 09:47:15 +0300
  • c980f3edd0 feat(crq): dashboard parity functions (migration 16) + recover inc 13/14 main feat/crq-ingestion david kiania 2026-06-26 00:19:54 +0300
  • 066d866b90 fix(crq): migration 15 creates tickets.crq (live DB never materialized it) david kiania 2026-06-25 23:55:17 +0300
  • 5f5d71d500 feat(crq): add CRQ ingestion via shared engine + thin inc/crq entrypoints david kiania 2026-06-25 23:16:38 +0300
  • 0787d3a185 docs: add deployment & operations runbook (Coolify, webhook, bucket cutover) david kiania 2026-06-25 22:24:23 +0300
  • f06c11fd11 Merge fix/inc-changes-stream: isptickets bucket cutover + --reseed + 20-min cron david kiania 2026-06-25 18:40:57 +0300
  • 7d3bba8d78 chore(schedule): INC ingest cron -> every 20 min, 06:00-20:40 EAT fix/inc-changes-stream david kiania 2026-06-25 18:23:17 +0300
  • 509338c076 feat(import_tickets): migrate INC ingest to isptickets bucket + --reseed cutover david kiania 2026-06-25 18:20:04 +0300
  • a4b90a33d8 fix(inc): ingest the incremental changes/ stream (baseline + deltas) david kiania 2026-06-23 14:37:17 +0300
  • 73c5f31f97 feat(reporting): fn_inc_filter_options for explorer dropdowns (migration 14) fix/bug-report-20260618 david kiania 2026-06-19 12:34:43 +0300
  • 5ea3f287d3 feat(reporting): fn_inc_search for the ticket explorer (migration 13) david kiania 2026-06-19 11:48:22 +0300
  • e71c8914f1 feat(geocode): two-pass estate fallback for building-level location_names david kiania 2026-06-18 18:51:58 +0300
  • cdb6186dca feat(reporting): add closure-by-engineer analytics to fn_inc_dashboard (migration 12) david kiania 2026-06-18 17:53:32 +0300
  • dca2c94c75 fix: address valid findings from 20260618 bug report david kiania 2026-06-18 13:41:38 +0300
  • 764dee986f feat: history capture — closure_events + daily backlog snapshot (migration 10) david kiania 2026-06-16 01:19:23 +0300
  • da6da9d26f docs: dashboard_api endpoint contract for fn_inc_dashboard (handoff) david kiania 2026-06-16 01:13:09 +0300
  • 752ac9e418 feat: reporting.fn_inc_dashboard — INC operations dashboard read-API (migration 09) david kiania 2026-06-16 01:10:18 +0300
  • f2408f113e docs: add docs/ — phase-1/phase-2 PRDs + implementation record david kiania 2026-06-16 01:05:18 +0300
  • e17553ccbf docs: comprehensive README — column reference, query runbook, DQ/SLA notes, status david kiania 2026-06-16 00:10:27 +0300
  • 8e119e2328 feat: tickets.inc_open_sla view + lowercase legacy region david kiania 2026-06-16 00:03:55 +0300
  • e54e2b7c56 feat: drop constant service_type column (migration 07) david kiania 2026-06-15 23:54:43 +0300
  • b86c0b2d13 feat: mttr -> minutes; drop constant alarm/auto flags (migration 06) david kiania 2026-06-15 23:51:28 +0300
  • 565cd592a0 feat: add geography column + GiST index for routing (migration 05) david kiania 2026-06-15 23:33:45 +0300
  • b323e8a1ac feat: populate inc latitude/longitude from geocoded geom (migration 04) david kiania 2026-06-15 23:26:39 +0300
  • 073db9b5b8 feat: unpack tickets.inc.raw into typed generated columns (migration 03) david kiania 2026-06-15 23:08:31 +0300
  • 4be5159d21 docs: Coolify scheduled tasks run in EAT — cron 15 7-19 (no UTC shift) david kiania 2026-06-15 22:43:01 +0300
  • 68f2b99cd3 feat: S3 via boto3 + Dockerfile for Coolify deploy david kiania 2026-06-15 20:08:05 +0300
  • 4532643247 chore: add hourly INC ingest cron wrapper + schedule docs david kiania 2026-06-15 19:40:50 +0300
  • df054c92be feat: INC hourly-CSV ingestion (newest-file, ETag dedup, clean + archive) david kiania 2026-06-15 19:33:16 +0300
  • 4631cc6382 feat: fleettickets — INC/CRQ ticket ingestion, geocoding + read-schema david kiania 2026-06-11 20:13:50 +0300