Load command for DB -> files about translation HOT 4 OPEN

/**
 * The console command description.
 *
 * @var string
 */
protected $description = 'Export database translations back to file system';

public function __construct()
{
    parent::__construct();
}

private function listFiles()
{
    foreach(RESOURCE_FILES as $key => $value)
    {
        $this->info($key . ' - '. $value);
    }
}

private function makeResourseFile($group, $lang = null)
{
    $supported_locales = !empty($lang)?[$lang]:config('app.support_local');
    foreach($supported_locales as $locale) {
        $dir = $locale == 'cn' ? 'zh-CN' : $locale;
        $file_name = base_path() . '/resources/lang/'.$dir.'/'.$group.'.php';
        $f = fopen($file_name, "w+") or die("Unable to open file!");
        fwrite($f, "<?php\n");
        fwrite($f, "\n");
        fwrite($f, "return [\n");
        DB::table('translator_translations')->where(['locale' => $locale, 'group' => $group])->orderBy('item', 'asc')->each(function($row) use (&$f) {
            fwrite($f, sprintf("'%s' => '%s',\n", $row->item, $row->text));
        });
        fwrite($f, "];\n");
        fclose($f);
    }
}

private function testResourseFile($group, $lang = null)
{
    $supported_locales = !empty($lang)?[$lang]:config('app.support_local');
    foreach($supported_locales as $locale) {
        DB::table('translator_translations')->where(['locale' => $lang, 'group' => $group])->orderBy('item', 'desc')->each(function($row) use (&$f) {
            $this->info(sprintf("'%s' => '%s',\n", $row->item, $row->text));
        });
    }
}

/**
 * Execute the console command.
 *
 * @return mixed
 */
public function handle()
{
    try {
        $list = $this->option('list');
        if (!empty($list)) {
            $this->listFiles();
            return;
        }
        $lang = $this->option('lang');
        $group = $this->option('group');
        if (!empty($group)) {
            $do_test = $this->option('test');
            if (!empty($do_test)) {
                $this->testResourseFile($group, $lang);
            } else {
                $this->makeResourseFile($group, $lang);
            }
        } else {
            $this->info('You should specify group name first. Use trans:export --list to see available groups');
        }
    } catch (\Exception $e) {
        \Log::error($e->getMessage());
        $this->error($e->getMessage());
    }
}