import os

directory = r'c:\Users\gvalg\Documents\Tripulacion Sireco\sireco-2.0\sireco-2.0\database\migrations\tenant'

replacements = [
    ("foreignId('empresa_id')->constrained('saas_empresas')->cascadeOnDelete()", "unsignedBigInteger('empresa_id')"),
    ("foreignId('empresa_id')->constrained('saas_empresas')", "unsignedBigInteger('empresa_id')"),
    ("foreignId('empresa_id')->nullable()->after('id')->constrained('saas_empresas')->nullOnDelete()", "unsignedBigInteger('empresa_id')->nullable()->after('id')"),
    ("foreignId('empresa_id')->nullable()->constrained('saas_empresas')->nullOnDelete()", "unsignedBigInteger('empresa_id')->nullable()")
]

for filename in os.listdir(directory):
    if filename.endswith(".php"):
        filepath = os.path.join(directory, filename)
        with open(filepath, 'r', encoding='utf-8') as f:
            content = f.read()
        
        new_content = content
        for target, replacement in replacements:
            new_content = new_content.replace(target, replacement)
        
        if new_content != content:
            with open(filepath, 'w', encoding='utf-8') as f:
                f.write(new_content)
            print(f"Fixed: {filename}")