• 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
Name
Last commit
Last update
.claude Loading commit data...
Another ERP that we may want to cheat from Loading commit data...
HR requests Loading commit data...
Proposal Loading commit data...
Server Connection Data Loading commit data...
app Loading commit data...
config Loading commit data...
cron Loading commit data...
database Loading commit data...
docker Loading commit data...
docs Loading commit data...
public Loading commit data...
support_tickets_downloads/support_screenshots Loading commit data...
tests Loading commit data...
tools Loading commit data...
.dockerignore Loading commit data...
.editorconfig Loading commit data...
.env Loading commit data...
.env.example Loading commit data...
.gitignore Loading commit data...
.php-cs-fixer.php Loading commit data...
BalanceSheet.html Loading commit data...
CLAUDE.md Loading commit data...
Dockerfile Loading commit data...
Makefile Loading commit data...
SYSTEM_MAP.md Loading commit data...
Sports Module System Design DETAILED.md Loading commit data...
UPGRADE_PLAN.md Loading commit data...
captain-definition Loading commit data...
cli.php Loading commit data...
composer.json Loading commit data...
composer.lock Loading commit data...
interesting_features.md Loading commit data...
phpstan.neon Loading commit data...
phpunit.xml Loading commit data...
sports activity stuff .txt Loading commit data...
sports-activity-alignment-plan.md Loading commit data...
sports-activity-smart-filtering-plan.md Loading commit data...
trial_balance_2026-01-01_to_2026-05-10.csv Loading commit data...