<?php

namespace App\Jobs;

use Illuminate\Bus\Queueable;
use Illuminate\Queue\SerializesModels;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Symfony\Component\Process\Exception\ProcessFailedException;
use Symfony\Component\Process\Process;

class ComposerInstall implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

    /**
     * Create a new job instance.
     *
     * @return void
     */
    protected $AppName;
    protected $AppName2;
    protected $AppName3;
    public function __construct($nom, $dbname, $sousdomaine)
    {
        $this->AppName = $nom;
        $this->AppName2 = $dbname;
        $this->AppName3 = $sousdomaine;
    }

    /**
     * Execute the job.
     *
     * @return void
     */
public function handle()
{

    $nom = $this->AppName;
    $dbname = $this->AppName2;
    $sousdomaine = $this->AppName3;
    $process = new Process('./cloning.sh ' . $nom . ' ' . $dbname . '');
    $process->run();
   if (!$process->isSuccessful()) {
     throw new ProcessFailedException($process);
    }

     $process->getOutput();
     $process = new Process('./hostconfig.sh ' . $nom . ' ' . $sousdomaine . '');
     $process->run();


    if (!$process->isSuccessful()) {
   throw new ProcessFailedException($process);
    }

$process->getOutput();

    
    //shell_exec('sudo systemctl reload httpd.service');
   // $process = new Process("php /var/www/clients/$nom/artisan migrate --database=$dbname");
//$process->run();


//if (!$process->isSuccessful()) {
  //  throw new ProcessFailedException($process);
//}

//$process->getOutput();

    $process = new Process('mysql -u sagatec -pSagaTeC@2016 -h 62.171.189.81 ' . $dbname . ' < /var/www/clients/cloud.sql');
    $process->run();
    
    
    if (!$process->isSuccessful()) {
        throw new ProcessFailedException($process);
    }
    
            $process->getOutput();
     
    $process = new Process('sudo systemctl reload httpd.service');
    $process->run();
    
    
    if (!$process->isSuccessful()) {
        throw new ProcessFailedException($process);
    }
    
            $process->getOutput();
}
}