<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Support\Facades\DB;

class AddDialedStatusToCallsDictStatus extends Migration
{
    public function up()
    {
        $exists = DB::table('calls_dict_status')
            ->where('name', 'Dialed')
            ->where('company_id', 1)
            ->exists();

        if (!$exists) {
            DB::table('calls_dict_status')->insert([
                'name'       => 'Dialed',
                'company_id' => 1,
                'created_at' => now(),
                'updated_at' => now(),
            ]);
        }
    }

    public function down()
    {
        DB::table('calls_dict_status')
            ->where('name', 'Dialed')
            ->where('company_id', 1)
            ->delete();
    }
}