<?php
/**
 * @remark :
 * @name   :UpdateRoute.php
 * @author :lyh
 * @method :post
 * @time   :2023/11/20 15:07
 */

namespace App\Console\Commands;

use App\Models\Blog\Blog;
use App\Models\Blog\BlogCategory;
use App\Models\News\News;
use App\Models\News\NewsCategory;
use App\Models\Product\Category;
use App\Models\Product\Keyword;
use App\Models\Product\Product;
use App\Models\Project\Project;
use App\Models\RouteMap\RouteMap;
use App\Services\ProjectServer;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

/**
 * @remark :更新所有项目的路由
 * @name   :UpdateRoute
 * @author :lyh
 * @method :post
 * @time   :2023/11/20 15:08
 */
class UpdateRoute extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'update_route';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '更新路由';

    /**
     * @remark :统一更新路由
     * @name   :handle
     * @author :lyh
     * @method :post
     * @time   :2023/11/20 15:13
     */
    public function handle(){
        $projectModel = new Project();
        $list = $projectModel->list(['type'=>['in',[1,2,3,4]]]);
        foreach ($list as $v){
            ProjectServer::useProject($v['id']);
            $this->getProductKeyword();
            DB::disconnect('custom_mysql');
        }
        echo date('Y-m-d H:i:s') . 'end' . PHP_EOL;
    }

    /**
     * @remark :产品关键字
     * @name   :getProductKeyword
     * @author :lyh
     * @method :post
     * @time   :2023/12/8 11:13
     */
    public function getProductKeyword(){
        $keywordModel = new Keyword();
        $lists = $keywordModel->list(['status'=>1]);
        if(!empty($lists)){
            foreach ($lists as $v){
                $tag = "-tag";
                if (!(substr($v['route'], -strlen($tag)) === $tag)) {
                    echo date('Y-m-d H:i:s') . '拼接'.$tag . PHP_EOL;
                    $route = $v['route'].$tag;
                    // 如果不是以 '-tag' 结尾，则拼接上 '-tag'
                    $routeModel = new RouteMap();
                    $routeModel->edit(['route'=>$route],['source'=>RouteMap::SOURCE_PRODUCT_KEYWORD,'source_id'=>$v['id']]);
                    $keywordModel->edit(['route'=>$route],['id'=>$v['id']]);
                }
            }
        }
    }

    /**
     * @remark :删除路由通知C端
     * @name   :curlDelRoute
     * @author :lyh
     * @method :post
     * @time   :2023/11/30 14:43
     */
    public function curlDelRoute($data){
        $data['project_id'] = 75;
        $str = http_build_query($data);
        $url = 'https://www.zrutong.com/api/delHtml/?'.$str;
        curlGet($url);
        return true;
    }
}