<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Symfony\Component\Process\Exception\ProcessFailedException;
use Symfony\Component\Process\Process;

class TuneTheAsteriskCorrectly extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //
        DB::table('asterisk.freepbx_settings')->where('keyword','=','HTTPENABLESTATIC')->update(['value' => '1']);
        // Update CEL Reporting to be disabled in order to save resources
        DB::table('asterisk.freepbx_settings')->where('keyword','=','CEL_ENABLED')->update(['value' => '0']);
        // Disable the collection of system statstics
        DB::table('asterisk.freepbx_settings')->where('keyword','=','SYS_STATS_DISABLE')->update(['value' => '0']);
        // Disable writing all the debug to log/debug file
        DB::table('asterisk.freepbx_settings')->where('keyword','=','FPBXDBUGDISABLE')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','DEVICE_REMOVE_MAILBOX')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','ENABLECW')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','DISABLECUSTOMCONTEXTS')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','RINGTIMER')->update(['value' => '45']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','SHOWLANGUAGE')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','QUEUES_UPDATECDR')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','QUEUES_EVENTS_WHEN_CALLED_DEFAULT')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','QUEUES_EVENTS_MEMEBER_STATUS_DEFAULT')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','AMPDISABLELOG')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','LOG_NOTIFICATIONS')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','BROWSER_STATS')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','SIGNATURECHECK')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','RSSFEEDS')->update(['value' => '']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','FREEPBX_SYSTEM_IDENT')->update(['value' => env('APP_NAME', 'fallback_app_name')]);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','UCPRSSFEEDS')->update(['value' => '']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','USERESMWIBLF')->update(['value' => '0']);
        DB::table('asterisk.kvstore_Sipsettings')->where('key','=','kvstore_Sipsettings')->update(['val' => 'no']);
        $process = new Process(['touch', '/etc/asterisk/acl.conf']);
        $process->run();
        $process = new Process(['touch', '/etc/asterisk/pjproject.conf']);
        $process->run();
        $process = new Process(['touch', '/etc/asterisk/pjsip_wizard.conf']);
        $process->run();
        $process = new Process(['touch', '/etc/asterisk/resolver_unbound.conf']);
        $process->run();
        $process = new Process(['touch', '/etc/asterisk/pjsip_wizard.conf']);
        $process->run();
        $process = new Process(['touch', '/etc/asterisk/stir_shaken.conf']);
        $process->run();
        $process = new Process(['touch', '/var/lib/asterisk/firmware/iax']);
        $process->run();
        $process = new Process(['touch', '/var/asterisk/flite.conf']);
        $process->run();
        $manager_contents           = file_get_contents('/etc/asterisk/manager.conf');
        $manager_contents           = explode('[general]',$manager_contents);
        $manager_contents           = implode('[general]
webenabled=yes',$manager_contents);
        file_put_contents('/etc/asterisk/manager.conf',$manager_contents);
        $process = new Process(['cp', public_path('pbxCore.php'),'/var/www/html/pbxCore.php']);
        $process->run();
        $process = new Process(['chown','asterisk:asterisk' , '/var/www/html/pbxCore.php']);
        $process->run();
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        DB::table('asterisk.freepbx_settings')->where('keyword','=','CEL_ENABLED')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','SYS_STATS_DISABLE')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','FPBXDBUGDISABLE')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','DEVICE_REMOVE_MAILBOX')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','ENABLECW')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','DISABLECUSTOMCONTEXTS')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','RINGTIMER')->update(['value' => '15']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','SHOWLANGUAGE')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','QUEUES_UPDATECDR')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','QUEUES_EVENTS_WHEN_CALLED_DEFAULT')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','QUEUES_EVENTS_MEMEBER_STATUS_DEFAULT')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','AMPDISABLELOG')->update(['value' => '0']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','LOG_NOTIFICATIONS')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','BROWSER_STATS')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','SIGNATURECHECK')->update(['value' => '1']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','RSSFEEDS')->update(['value' => '']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','FREEPBX_SYSTEM_IDENT')->update(['value' => 'PBX']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','UCPRSSFEEDS')->update(['value' => 'PBX']);
        DB::table('asterisk.freepbx_settings')->where('keyword','=','USERESMWIBLF')->update(['value' => '1']);
        DB::table('asterisk.kvstore_Sipsettings')->where('key','=','kvstore_Sipsettings')->update(['val' => 'yes']);
        $process = new Process(['rm', '/etc/asterisk/acl.conf']);
        $process->run();
        $process = new Process(['rm', '/etc/asterisk/pjproject.conf']);
        $process->run();
        $process = new Process(['rm', '/etc/asterisk/pjsip_wizard.conf']);
        $process->run();
        $process = new Process(['rm', '/etc/asterisk/resolver_unbound.conf']);
        $process->run();
        $process = new Process(['rm', '/etc/asterisk/pjsip_wizard.conf']);
        $process->run();
        $process = new Process(['rm', '/etc/asterisk/stir_shaken.conf']);
        $process->run();
        $process = new Process(['rm', '/var/lib/asterisk/firmware/iax']);
        $process->run();
        $process = new Process(['rm', '/var/asterisk/flite.conf']);
        $process->run();
        $manager_contents           = file_get_contents('/etc/asterisk/manager.conf');
        $manager_contents           = str_replace('webenabled=yes','',$manager_contents);
        file_put_contents('/etc/asterisk/manager.conf',$manager_contents);
    }
}