• DevPilot's avatar
    fix(procurement,hr): fix crashing reports — wrong PO-item columns, missing view, wrong join · f5c65f90
    DevPilot authored
    PO balance and purchase-volume reports referenced poi.quantity /
    poi.qty_received, which don't exist — the real columns are
    quantity_ordered / quantity_received. Price-deviation report pointed
    at a view that was never created. HR insurance form2 joined
    hr_salary_adjustments through employees.id, but that table links
    straight to hr_employee_profiles via employee_profile_id (confirmed
    against the model and every other query on that table) — the extra
    employees join used a column, employee_id, that was never there.
    Found live via BOOT FAILURE pages while capturing screenshots for the
    accountant's tutorial PDF.
    f5c65f90
InsuranceController.php 6.81 KB