<?php
/**
 * Created by PhpStorm.
 * User: zhl
 * Date: 2023/2/7
 * Time: 17:58
 */
namespace App\Console\Commands\Test;


use App\Helper\Arr;
use App\Helper\Translate;
use App\Models\Blog\Blog;
use App\Models\Blog\BlogCategory;
use App\Models\Com\KeywordVideoTask;
use App\Models\Com\KeywordVideoTaskLog;
use App\Models\CustomModule\CustomModuleCategory;
use App\Models\CustomModule\CustomModuleContent;
use App\Models\Devops\ServerConfig;
use App\Models\Devops\Servers;
use App\Models\Devops\ServersIp;
use App\Models\File\File;
use App\Models\File\File as FileModel;
use App\Models\File\Image;
use App\Models\File\Image as ImageModel;
use App\Models\News\News;
use App\Models\News\NewsCategory;
use App\Models\Product\Keyword;
use App\Models\Product\Product;
use App\Models\Project\DeployOptimize;
use App\Models\Project\MinorLanguages;
use App\Models\Project\Project;
use App\Models\Purchaser\PurchaserInfo;
use App\Models\RouteMap\RouteMap;
use App\Models\Template\BCustomTemplate;
use App\Models\Template\BTemplateCom;
use App\Services\AmazonS3Service;
use App\Services\ProjectServer;
use App\Utils\EncryptUtils;
use GuzzleHttp\Exception\GuzzleException;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;


class Demo extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'demo';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'demo';

    public function handle(){
        $projectModel = new Project();
        $list = $projectModel->list(['is_upgrade'=>1]);
        $data = [];
        foreach ($list as $v){
            echo date('Y-m-d H:i:s') . 'project_id:'.$v['id'] . PHP_EOL;
            ProjectServer::useProject($v['id']);
            $this->init404Page($v['id']);
            DB::disconnect('custom_mysql');
        }
        echo date('Y-m-d H:i:s') . 'end' . PHP_EOL;
    }

    public function getProduct(){
        $productModel = new Product();
        $lists = $productModel->list(['status'=>['!=',2]]);
        if(!empty($lists)){
            foreach ($lists as $v){
                if(!empty($v['route'])){
                    $tag = "-product";
                    if (!(substr($v['route'], -strlen($tag)) === $tag)) {
                        echo date('Y-m-d H:i:s') . '拼接'.$tag . PHP_EOL;
                        $route = $v['route'].$tag;
                        // 如果不是以 '-product' 结尾,则拼接上 '-product'
                        $route = RouteMap::setRoute($route, RouteMap::SOURCE_PRODUCT, $v['id'], $v['project_id']);
                        $productModel->edit(['route'=>$route],['id'=>$v['id']]);
                    }else{
                        echo date('Y-m-d H:i:s') . 'id :'.$v['id'] . PHP_EOL;
                        $route = RouteMap::setRoute($v['title'], RouteMap::SOURCE_PRODUCT, $v['id'], $v['project_id']);
                        $productModel->edit(['route'=>$route],['id'=>$v['id']]);
                    }
                    continue;
                }else{
                    echo date('Y-m-d H:i:s') . 'id :'.$v['id'] . PHP_EOL;
                    $v['title'] = Translate::tran($v['title'], 'en');
                    $v['title'] = str_replace('.','',$v['title']).'-product';
                    $route = RouteMap::setRoute($v['title'], RouteMap::SOURCE_PRODUCT, $v['id'], $v['project_id']);
                    $productModel->edit(['route'=>$route],['id'=>$v['id']]);
                }
            }
        }
    }
}