• DevPilot's avatar
    fix(accounting): gap detail queries referenced columns that do not exist · fa94e5b8
    DevPilot authored
    The drill-down queries were written against assumed column names and
    every one of them failed, so "عرض التفاصيل" always answered "لا توجد
    تفاصيل متاحة". Corrected against the real schema: pool zone bookings
    have label/zone_row/zone_col and no zone table, player cards use
    valid_from/issued_at and card_number, pool bookings carry booker_name
    rather than a member join, and private match bookings store total_cost
    rather than total_amount.
    fa94e5b8
GapToolService.php 20.9 KB