Server : ApacheSystem : Linux host.digitalbabaji.in 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64 User : addictionfreeind ( 1003) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system Directory : /home/addictionfreeind/www/admin1/database/migrations/ |
Upload File : |
<?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->show_new_webhook_alert = 1;
$company->saveQuietly();
}
}
$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')->onUpdate('cascade')->onDelete('SET NULL');
$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')->onUpdate('cascade')->onDelete('cascade');
});
}
}
};