芝麻web文件管理V1.00

编辑当前文件:/home/sditechnicalteam/www/database/migrations/2022_11_23_070556_show_new_webhook_alert.php

<?php

use App\Models\Company;
use App\Models\Contract;
use App\Models\ContractTemplate;
use App\Models\GlobalSetting;
use App\Models\LanguageSetting;
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;

return new class extends Migration {

/**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {

DB::statement("ALTER TABLE file_storage CHANGE COLUMN storage_location storage_location ENUM('local', 'aws_s3', 'digitalocean') NOT NULL DEFAULT 'local'");

$companies = Company::select('id')->get();

if (!Schema::hasColumn('companies', 'show_new_webhook_alert')) {
            Schema::table('companies', function (Blueprint $table) {
                $table->boolean('show_new_webhook_alert')->default(0);
            });

foreach ($companies as $company) {
                $company->update(['show_new_webhook_alert' => 1]);
            }
        }

$this->foreignKeyFixCompaniesTable();
        $this->languageFlags();
        $this->contractNumbers();
    }

/**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('companies', function (Blueprint $table) {
            $table->dropColumn('show_new_webhook_alert');
        });
    }

private function contractNumbers()
    {
        Schema::table('contracts', function (Blueprint $table) {
            $table->bigInteger('contract_number')->after('id')->nullable();
        });
        Schema::table('contract_templates', function (Blueprint $table) {
            $table->bigInteger('contract_template_number')->after('id')->nullable();
        });

$companies = Company::select('id')->get();

foreach ($companies as $company) {

$contracts = Contract::where('company_id', $company->id)->get();

foreach ($contracts as $key => $contract) {
                $contract->contract_number = $key + 1;
                $contract->saveQuietly();
            }

$templates = ContractTemplate::where('company_id', $company->id)->get();

foreach ($templates as $key => $template) {
                $template->contract_template_number = $key + 1;
                $template->saveQuietly();
            }
        }
    }

private function languageFlags()
    {
        LanguageSetting::where('language_code', 'ar')
            ->where('flag_code', '<>', 'sa')
            ->update(['flag_code' => 'sa']); // Saudi Arabia

LanguageSetting::where('language_code', 'pt-br')
            ->where('flag_code', '<>', 'br')
            ->update(['flag_code' => 'br']); // Brazil

LanguageSetting::where('language_code', 'fa')
            ->where('flag_code', '<>', 'ir')
            ->update(['flag_code' => 'ir']); // Iraq

LanguageSetting::whereIn('language_code', ['zh-CN', 'zh-TW'])
            ->where('flag_code', '<>', 'cn')
            ->update(['flag_code' => 'cn']); // China
    }

private function foreignKeyFixCompaniesTable()
    {
        try {
            // Renaming the index names
            Schema::table('companies', function (Blueprint $table) {
                $table->dropForeign('organisation_settings_currency_id_foreign');
                $table->dropForeign('organisation_settings_default_task_status_foreign');
                $table->dropForeign('organisation_settings_last_updated_by_foreign');
                $table->foreign('currency_id')->references('id')->on('currencies')->onDelete('RESTRICT');
                $table->foreign(['default_task_status'])->references(['id'])->on('taskboard_columns')->onUpdate('CASCADE');
                $table->foreign(['last_updated_by'])->references(['id'])->on('users')->onUpdate('CASCADE')->onDelete('SET NULL');
            });
            //phpcs:ignore
        } catch (\Throwable $th) {
        }

$currencyTables = GlobalSetting::CURRENCY_TABLES;

// We are restricting the currency id delete to prevent deleting records
        foreach ($currencyTables as $currencyTable) {
            Schema::table($currencyTable, function (Blueprint $table) {
                $table->dropForeign(['currency_id']);
                $table->foreign('currency_id')->references('id')->on('currencies')->onDelete('RESTRICT');
            });
        }
    }

};