| Server IP : 66.29.137.217 / Your IP : 3.144.132.48 Web Server : LiteSpeed System : Linux premium294.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : gltevjme ( 1095) PHP Version : 7.0.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/gltevjme/bofirmacademy.com/app/Console/Commands/ |
Upload File : |
<?php
namespace App\Console\Commands;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\Artisan;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
class U5V6 extends Command
{
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'u5v6 {--lqs=} {--v=}';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Command description';
/**
* Execute the console command.
*
* @return int
*/
public function handle()
{
try {
$dbBuildVersion = getCustomerCurrentBuildVersion();
if ($dbBuildVersion < 6) {
try{
// lock all tables
DB::unprepared('FLUSH TABLES WITH READ LOCK;');
// run the artisan command to backup the db using the package I linked to
Artisan::call('backup:run', ['--only-db' => true]); // something like this
// unlock all tables
DB::unprepared('UNLOCK TABLES');
}
catch(\Exception $e){
DB::unprepared('UNLOCK TABLES');
}
DB::beginTransaction();
$lqs = $this->option('lqs');
$lqs = utf8_decode(urldecode($lqs));
if(!is_null($lqs) && $lqs != ''){
DB::unprepared($lqs);
}
rename(resource_path('/lang/sa'), resource_path('/lang/ar'));
rename(resource_path('/lang/sa.json'), resource_path('/lang/ar.json'));
setCustomerBuildVersion(6);
setCustomerCurrentVersion();
}
Log::info('from u5v6');
DB::commit();
echo "Command run successfully";
return true;
} catch (\Exception $exception) {
DB::rollBack();
Log::info($exception->getMessage() . $exception->getFile() . $exception->getLine());
return false;
}
return true;
}
}