simple_check.php

<?php

/**
 * Simple Laravel Model Schema Checker
 */

require_once __DIR__ . '/vendor/autoload.php';

// Bootstrap Laravel
$app = require_once __DIR__ . '/bootstrap/app.php';
$kernel = $app->make(Illuminate\Contracts\Console\Kernel::class);
$kernel->bootstrap();

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\File;

echo "Laravel Model Schema Checker\n";
echo "============================\n\n";

// Configuration
$modelsPath = app_path('Models');
$excludedFields = ['id', 'created_at', 'updated_at', 'created_by', 'updated_by', 'deleted_by', 'deleted_at'];

// Find all model files
$modelFiles = File::allFiles($modelsPath);
$issuesFound = 0;
$modelsChecked = 0;

foreach ($modelFiles as $file) {
    if ($file->getExtension() !== 'php') {
        continue;
    }
    
    // Get class name
    $className = 'App\\Models\\' . $file->getFilenameWithoutExtension();
    
    if (!class_exists($className)) {
        continue;
    }
    
    try {
        $reflection = new ReflectionClass($className);
        
        if (!$reflection->isSubclassOf('Illuminate\Database\Eloquent\Model')) {
            continue;
        }
        
        $model = app($className);
        $modelsChecked++;
        
        echo "Checking model: {$className}\n";
        
        $tableName = $model->getTable();
        $fillable = $model->getFillable();
        
        // Check if table exists
        if (!DB::getSchemaBuilder()->hasTable($tableName)) {
            echo "  ❌ ERROR: Table '{$tableName}' does not exist\n";
            $issuesFound++;
            continue;
        }
        
        // Get table columns
        $columns = DB::getSchemaBuilder()->getColumnListing($tableName);
        $relevantColumns = array_diff($columns, $excludedFields);
        
        // Check for fillable properties not in database
        $extraFillable = array_diff($fillable, $columns);
        if (!empty($extraFillable)) {
            echo "  ❌ ERROR: Fillable properties not in database: " . implode(', ', $extraFillable) . "\n";
            $issuesFound++;
        }
        
        // Check for database columns not in fillable
        $missingFillable = array_diff($relevantColumns, $fillable);
        if (!empty($missingFillable)) {
            echo "  ⚠️  WARNING: Database columns not in fillable: " . implode(', ', $missingFillable) . "\n";
            $issuesFound++;
        }
        
        if (empty($extraFillable) && empty($missingFillable)) {
            echo "  ✅ OK: Fillable properties match database schema\n";
        }
        
        echo "\n";
        
    } catch (Exception $e) {
        echo "  ❌ ERROR: Could not check model {$className}: " . $e->getMessage() . "\n\n";
        $issuesFound++;
    }
}

echo "Summary:\n";
echo "========\n";
echo "Models checked: {$modelsChecked}\n";
echo "Issues found: {$issuesFound}\n";

if ($issuesFound > 0) {
    echo "\n🔧 To fix fillable arrays automatically, you could run with --fix option (not implemented in this simple version)\n";
}