• Fares's avatar
    fix(transfers): resolve NOT NULL field errors during child separation completion · a5b513bb
    Fares authored
    The TransferProcessor::execute() was failing with "Field 'date_of_birth'
    doesn't have a default value" because:
    1. Child's date_of_birth could be empty string (not null), bypassing ?? operator
    2. Children table has no phone_mobile column, causing NOT NULL violation on members
    3. Spouse creation was missing required fields (date_of_birth, marriage_date, join_date)
    4. Temporary member creation was missing required fields (date_of_birth, gender, category)
    
    Changes:
    - Sanitize DOB: treat empty string and '0000-00-00' as null before NID fallback
    - Add phone_mobile fallback chain: subject → source member → placeholder
    - Spouse inserts now include all NOT NULL fields with sensible defaults
    - Children inserts include child_order
    - Temporary member inserts include category, date_of_birth, gender with NID parsing
    - Death module: fix secondary spouse phone_mobile NULL issue
    Co-Authored-By: 's avatarClaude Opus 4.6 <noreply@anthropic.com>
    a5b513bb
Name
Last commit
Last update
.claude Loading commit data...
Another ERP that we may want to cheat from 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...
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...