basquetWi + New ticket
venus VENUS-438

Date filter: selectable axis fecha de cirugía vs fecha de carga

Done normal cvcoder-venus-cc

Source: Puia PTT-20260706-WA0011 + PTT-20261005-WA0014 (WhatsApp export 2026-10-06). ASK: the date filter must let the user choose WHICH date it applies to, fecha de cirugía or fecha de carga, and selecting either must not alter the other filters. MEASURED: desde/hasta filter ONLY on practicas.fecha (the surgery date): src/lib/practica-queries.ts:163-170, src/app/api/export/practicas/csv/route.ts:101-106. There is no fecha-de-carga (createdAt) axis. Keep the default on fecha de cirugía (Elazar 2026-07-06: 'el filtro será por fecha de cirugía'). Apply it to /practicas, /informes, and the CSV and PDF exports together, so an export matches the screen (report-filter-axes.ts). createdAt is UTC timestamptz: convert to America/Buenos_Aires before comparing to a date.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Activity

  • coder-venus-cc created · 1w ago
  • coder-venus-cc statusChanged · 1w ago
    Pass 1 of /loop. Design: boolean URL param porFechaCarga=1 (a boolean toggle, allowed inline under No Hardcoded Options; no option list). Default stays fecha de cirugía. One server-only-free helper lib/report-date-filter.ts owns desde/hasta + axis, used by practica-queries, report-actions (3 builders), CSV route; PDF + /informes export links carry it via REPORT_AXES. Carga axis = (createdAt AT TIME ZONE 'America/Argentina/Buenos_Aires')::date. UI: Checkbox in PracticaFilters.
  • coder-venus-cc note · 1w ago
    Pushed c9ccf2e (package.json 1.17.36, unbumped). Vercel deploy pending at 04:12Z; PTD (deploymentId change + status success for c9ccf2e) owed next loop pass. Review asked of audit-venus-ca. Not exercised: UI in a browser.
  • coder-venus-cc note · 1w ago
    audit-venus-ca BLOCK c9ccf2e: printed scope claimed a dropped impossible bound; year 0000 passed JS. Fixed 74a7cf1 (label uses isoDateOrNull; tie test; both forced red separately). c9ccf2e PTD: status success, live deploymentId dpl_qvjPZCrxwUXR9DGJTiVjDP3bckUi = its Vercel target. 74a7cf1 deploy pending; re-review asked.
  • coder-venus-cc completed · 1w ago
    PASS:74a7cf1 (audit-venus-ca). SHAs c9ccf2e (feature) + 74a7cf1 (BLOCK fix), v1.17.36. PTD: gh status success, live /api/health deploymentId dpl_6e6MXu7BfH4WVToAMpEHXtACGxuc = 74a7cf1 Vercel target, dbOk true. NOT EXERCISED: checkbox UI in a browser.
feature
1w ago by coder-venus-cc
1w ago
2026-10-06 04:19