# Clear cache
php artisan cache:clear
php artisan config:clear
php artisan view:clear

# Optimize autoload
composer dump-autoload -o

# Database optimization
php artisan optimize
php artisan db:optimize

# Check system resources
free -h  # Check RAM
df -h    # Check disk space
top      # Check CPU usage

# Increase PHP memory limit
echo 'memory_limit = 512M' >> /etc/php/7.4/fpm/php.ini
systemctl restart php7.4-fpm

-- Check database status
SHOW STATUS LIKE 'Threads_connected';
SHOW PROCESSLIST;

-- Repair tables
REPAIR TABLE users, invoices, products;

-- Optimize tables
OPTIMIZE TABLE journal_entries, stock_transactions, audit_logs;

-- Reset auto-increment
ALTER TABLE sessions AUTO_INCREMENT = 1;

-- Check foreign key constraints
SELECT 
    TABLE_NAME,
    COLUMN_NAME,
    CONSTRAINT_NAME,
    REFERENCED_TABLE_NAME,
    REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = 'decconz_erp'
    AND REFERENCED_TABLE_NAME IS NOT NULL;

// Check email configuration
// config/mail.php
return [
    'default' => env('MAIL_MAILER', 'smtp'),
    'mailers' => [
        'smtp' => [
            'transport' => 'smtp',
            'host' => env('MAIL_HOST', 'smtp.gmail.com'),
            'port' => env('MAIL_PORT', 587),
            'encryption' => env('MAIL_ENCRYPTION', 'tls'),
            'username' => env('MAIL_USERNAME'),
            'password' => env('MAIL_PASSWORD'),
            'timeout' => null,
            'auth_mode' => null,
        ],
    ],
    'from' => [
        'address' => env('MAIL_FROM_ADDRESS', 'noreply@decconz-erp.com'),
        'name' => env('MAIL_FROM_NAME', 'Decconz ERP'),
    ],
];

// Test email sending
php artisan mail:test user@example.com

// .env file configuration
APP_DEBUG=true
APP_ENV=local

LOG_CHANNEL=stack
LOG_LEVEL=debug

# Detailed error logging
APP_LOG=errorlog
APP_LOG_LEVEL=debug

// Debug routes for testing
Route::get('/debug/session', function() {
    return session()->all();
});

Route::get('/debug/config/{key}', function($key) {
    return config($key);
});

Route::get('/debug/db', function() {
    return DB::connection()->getPdo();
});