• Mahmoud Aglan's avatar
    Fix all column mismatches between code and live database schema · 0cc5b982
    Mahmoud Aglan authored
    Critical SQL fixes (pages were crashing):
    - GlobalSearch: remove non-existent branch_id/invoice_number, fix relationship
    - RevenueWidget: payment_method → method
    - FinancialReport: line_total → total_amount, balance_due → due_amount
    - PaymentPlanCreate: rewrite to match actual payment_plans/installments schema
    
    High-priority display fixes (features showing null):
    - invoice_number → number (8 locations)
    - balance_due → due_amount (6 locations)
    - full_name_ar → full_name (7 locations, accessor doesn't exist)
    - payment_method → method in print view
    - subtotal → subtotal_amount
    - description → notes on invoice
    - line_total → total_amount on invoice items
    - receipt_number → reference on payment
    
    Medium fixes:
    - Dashboard: fix format() call on string time column
    - Participant card: access person fields via relationship
    
    Low fixes:
    - daily-financial-print: createdBy → creator relationship
    - reports-page: payment_method key → method
    
    Infrastructure:
    - Add migration for cash_session_id on payments table
    - Add cash_session_id to Payment model fillable
    - Fix float → decimal:2 casts on Evaluation/EvaluationScore
    - Update enum registry docs to match actual DB CHECK constraints
    Co-Authored-By: 's avatarClaude Opus 4.6 <noreply@anthropic.com>
    0cc5b982
Name
Last commit
Last update
..
Activities Loading commit data...
Admin Loading commit data...
Assignments Loading commit data...
Attendance Loading commit data...
Audit Loading commit data...
Auth Loading commit data...
Branches Loading commit data...
CashSessions Loading commit data...
Components Loading commit data...
Dashboard Loading commit data...
Enrollments Loading commit data...
Evaluations Loading commit data...
Facilities Loading commit data...
Financial Loading commit data...
Groups Loading commit data...
Guardian Loading commit data...
Inventory Loading commit data...
Invoices Loading commit data...
Messaging Loading commit data...
Notifications Loading commit data...
POS Loading commit data...
Participants Loading commit data...
People Loading commit data...
Pricing Loading commit data...
Profile Loading commit data...
Programs Loading commit data...
Receptionist Loading commit data...
Reports Loading commit data...
Roles Loading commit data...
Schedule Loading commit data...
Settings Loading commit data...
Trainer Loading commit data...
Training Loading commit data...
Users Loading commit data...
Wallets Loading commit data...
Wizards Loading commit data...
BranchSwitcher.php Loading commit data...
Dashboard.php Loading commit data...
GlobalSearch.php Loading commit data...