<?php
/**
 * @remark :
 * @name   :lyhDemo.php
 * @author :lyh
 * @method :post
 * @time   :2025/3/24 9:38
 */

namespace App\Console\Commands\LyhTest;

use App\Helper\OaGlobalsoApi;
use App\Models\Ai\AiBlog;
use App\Models\News\News;
use App\Models\Product\Category;
use App\Models\Project\AggregateKeywordAffix;
use App\Models\Project\AiBlogTask;
use App\Models\Project\DeployBuild;
use App\Models\Project\KeywordPrefix;
use App\Models\Project\Project;
use App\Models\Project\ProjectAiSetting;
use App\Models\Project\ProjectWhiteHatAffix;
use App\Models\Template\BTemplateMain;
use App\Models\Template\TemplateTypeMain;
use App\Models\WebSetting\WebSetting;
use App\Services\AiBlogService;
use App\Services\CosService;
use App\Services\Geo\GeoService;
use App\Services\MidJourneyService;
use App\Services\ProjectServer;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

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

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

    public function handle(){
//        $content = "{Introducing the cutting-edge product from Zhejiang Yuexiang Gas Technology Co., Ltd., the Bracket Gas Flowmeter. This innovative gas flowmeter is designed to provide accurate and reliable measurements for a wide range of industrial applications,Equipped with advanced technology and precision components, the Bracket Gas Flowmeter ensures exceptional performance and durability. It offers highly accurate gas flow readings, allowing users to closely monitor and control gas consumption in various processes. The meter's user-friendly interface displays real-time flow rates and totalized flow data, facilitating efficient and convenient data management,With its robust construction and corrosion-resistant materials, the Bracket Gas Flowmeter guarantees long-term reliability, even in harsh operating conditions. It is compatible with various gases such as natural gas, propane, and hydrogen, making it a versatile choice for multiple industries including oil and gas, chemical, and manufacturing,Furthermore, the Bracket Gas Flowmeter is engineered with ease of installation and maintenance in mind. Its compact and space-saving design allows for flexible mounting options, while its modular construction enables quick and hassle-free maintenance. Additionally, it meets international standards for accuracy and safety, ensuring compliance with industry regulations,Choose the Bracket Gas Flowmeter for precise and efficient gas flow measurement, backed by the expertise and commitment of Zhejiang Yuexiang Gas Technology Co., Ltd}，{Shop Quality Brackets: Top China Products & Services for Your Needs}，4K，高清 --no logo --ar 16:9";
//        $midJourneyService = new MidJourneyService();
//        $result = $midJourneyService->imagine($content);
        $url = 'https://ecdn6-nc.globalso.com/upload/p/1/png/2025-08/688dcebc26a7a59911.png';
        $cosService = new CosService();
        $data = $cosService->cropAndUploadToCOS($url);
        dd($data);
    }

    /**
     * @remark :查看路由是否为空
     * @name   :_actionRoute
     * @author :lyh
     * @method :post
     * @time   :2025/7/22 15:14
     */
    public function _actionRoute(){
        $geo_service = new GeoService();
        $data = $geo_service->getDeepSeekResult("创贸总共多少人？",'gpt-4o-mini');
        dd($data);
//        $projectModel = new Project();
//        $lists = $projectModel->list(['delete_status' => 0,'project_type'=>0,'extend_type'=>0,'type'=>['in',[2,3,4,6]]], 'id', ['id']);
//        $data = [];
//        foreach ($lists as $item){
//            echo date('Y-m-d H:i:s') . '开始--项目的id:'. $item['id'] . PHP_EOL;
//            ProjectServer::useProject($item['id']);
//            $aiBlogModel = new AiBlog();
//            $info = $aiBlogModel->read(['route'=>null],['id']);
//            if($info !== false){
//                echo '项目id:'.$item['id'].PHP_EOL;
//                $data[] = $item['id'];
//            }
//            dd($data);
//            echo 'end';
//            DB::disconnect('custom_mysql');
//        }
    }

    public function _actionTemplateMain(){
        $data = [];
        $projectModel = new Project();
        $lists = $projectModel->list(['delete_status' => 0,'project_type'=>0,'extend_type'=>0,'type'=>['in',[2,3,4,6]]], 'id', ['id']);
        foreach ($lists as $val){
            echo date('Y-m-d H:i:s') . '开始--项目的id:'. $val['id'] . PHP_EOL;
            ProjectServer::useProject($val['id']);
            $bTemplateMainModel = new BTemplateMain();
            $info = $bTemplateMainModel->read(['type'=>2,'is_list'=>1],['id']);
            $categoryModel = new Category();
            $count = $categoryModel->counts(['id'=>['>',0]]);
            if(($info === false) && ($count > 0)){
                $mainModel = new TemplateTypeMain();
                $mainInfo = $mainModel->read(['type'=>2,'is_list'=>1]);
                $main_html = $mainInfo['main_html'];
                $main_css = "<style id='globalsojs-styles'></style>";
                //写入一条初始数据
                $bTemplateMainModel->addReturnId(['type'=>2,'is_list'=>1,'is_custom'=>0,'project_id'=>$val['id'],'main_html'=>$main_html,'main_css'=>$main_css]);
                $data[] = $val['id'];
            }
            DB::disconnect('custom_mysql');
            echo date('Y-m-d H:i:s') . '结束--项目的id:'. $val['id'] . PHP_EOL;
        }
        dd($data);
    }

    public function _action_ai_blog(){
        $projectModel = new Project();
        $lists = $projectModel->list(['delete_status' => 0,'extend_type'=>0,'type'=>['in',[2,3,4,6]]], 'id', ['id']);
        foreach ($lists as $val) {
            $aiSettingInfo = $this->getSetting($val['id']);
            if($aiSettingInfo === false){
                echo '当前项目未注册。'.$val['id'].PHP_EOL;
                continue;
            }
            $aiBlogTaskModel = new AiBlogTask();
            $blog_lists = $aiBlogTaskModel->list(['type'=>2,'status'=>2,'project_id'=>$val['id']]);
            if(empty($blog_lists)){
                echo '未获取到ao_blog'.PHP_EOL;
                continue;
            }
            echo date('Y-m-d H:i:s') . '开始--项目的id:'. $val['id'] . PHP_EOL;
            ProjectServer::useProject($val['id']);
            $aiBlogService = new AiBlogService($val['id']);
            foreach ($blog_lists as $item) {
                $aiBlogModel = new AiBlog();
                $aiBlogInfo = $aiBlogModel->read(['task_id' => $item['task_id']], ['id']);
                if ($aiBlogInfo === false) {
                    continue;
                }
                try {
                    $aiBlogService->task_id = $item['task_id'];
                    //拉取文章数据
                    $result = $aiBlogService->getDetail();
                    if (isset($result) && ($result['status'] == 200)) {
                        $aiBlogModel->edit(['seo_description' => $result['data']['description']], ['task_id' => $item['task_id']]);
                    }
                } catch (\Exception $e) {
                    echo '跳过。' . PHP_EOL;
                    continue;
                }
            }
            DB::disconnect('custom_mysql');
            echo date('Y-m-d H:i:s') . '结束--项目的id:'. $val['id'] . PHP_EOL;
        }
        return true;
    }

    public function _action(){
        $aiBlogTaskModel = new AiBlogTask();
        $lists = $aiBlogTaskModel->list(['type'=>2,'status'=>2,'project_id'=>467]);
        foreach ($lists as $item){
            echo date('Y-m-d H:i:s') . '开始--项目的id:'. $item['project_id'] . PHP_EOL;
            ProjectServer::useProject($item['project_id']);
            $aiBlogModel = new AiBlog();
            $aiBlogInfo = $aiBlogModel->read(['task_id'=>$item['task_id']],['id','route']);
            if($aiBlogInfo === false){
                continue;
            }
            try {
                $aiBlogService = new AiBlogService($item['project_id']);
                $aiBlogService->task_id = $item['task_id'];
                //拉取文章数据
                $result = $aiBlogService->getDetail();
                if(isset($result) && ($result['status'] == 200)){
                    $aiBlogModel->edit(['seo_description'=>$result['data']['description']],['task_id'=>$item['task_id']]);
                }
            }catch (\Exception $e){
                echo '跳过。'.PHP_EOL;
            }
            DB::disconnect('custom_mysql');
            echo date('Y-m-d H:i:s') . '结束--项目的id:'. $item['project_id'] . PHP_EOL;
        }
    }

    public function getSetting($project_id)
    {
        $projectAiSettingModel = new ProjectAiSetting();
        $aiSettingInfo = $projectAiSettingModel->read(['project_id'=>$project_id]);
        return $aiSettingInfo;
    }


    public function _actions() {
        echo '开始执行...' . PHP_EOL;
        ProjectServer::useProject(565);
        $table = 'gl_product_category';
        $connection = DB::connection('custom_mysql');
        $dbName = $connection->getDatabaseName();
        $brandsStr = 'Trimos,insize,Fowler,Mahr,Starrett,Tesa,Mitutoyo,Wixey,Shars,Fisso,Spi,Grizzly,Accumaster,Accuremote,Baker,Sharpe,Compac,Earth,Etalon,Federal,Fell,Fisso,Fowler,Gem,Grizzly,Husky,iGaging,Insize,Kanetec,Magnetics,Mighty,Mitutoyo,Noga,Pittsburgh,Procheck,Saker,Scherr Tumico,Shars,Shinwa,SPI,Starrett,Tesa,Technidea,Trimos,Verdict,Wyler,Wixey';
        $brands = array_unique(array_map('trim', explode(',', $brandsStr)));
        // 获取文本字段
        $columns = $connection->table('information_schema.columns')
            ->where('table_schema', $dbName)
            ->where('table_name', $table)
            ->whereIn('data_type', ['varchar', 'text', 'mediumtext', 'longtext'])
            ->pluck('column_name')
            ->toArray();
        if (empty($columns)) {
            echo "未找到文本字段，退出。" . PHP_EOL;
            return;
        }
        foreach ($columns as $field) {
            $sqlField = "`$field`";
            // 构造第一轮REPLACE表达式（原样品牌）
            $replaceExprRaw = $sqlField;
            foreach ($brands as $brand) {
                $safeBrand = addslashes($brand);
                $replaceExprRaw = "REPLACE(REPLACE($replaceExprRaw, '$safeBrand-', ''), '$safeBrand', '')";
            }
            // 构造第二轮REPLACE表达式（小写品牌）
            $lowerBrands = array_map('strtolower', $brands);
            $replaceExprLower = $sqlField;
            foreach ($lowerBrands as $brand) {
                $safeBrand = addslashes($brand);
                $replaceExprLower = "REPLACE(REPLACE($replaceExprLower, '$safeBrand-', ''), '$safeBrand', '')";
            }
            // 先执行原样品牌替换
            $sqlRaw = "UPDATE `$table` SET $sqlField = $replaceExprRaw WHERE $sqlField IS NOT NULL AND $sqlField != ''";
            echo "执行字段（品牌原样替换）：$field" . PHP_EOL;
            try {
                $connection->update($sqlRaw);
            } catch (\Exception $e) {
                echo "字段 $field 原样替换出错：" . $e->getMessage() . PHP_EOL;
            }
            // 再执行小写品牌替换
            $sqlLower = "UPDATE `$table` SET $sqlField = $replaceExprLower WHERE $sqlField IS NOT NULL AND $sqlField != ''";
            echo "执行字段（品牌小写替换）：$field" . PHP_EOL;
            try {
                $connection->update($sqlLower);
            } catch (\Exception $e) {
                echo "字段 $field 小写替换出错：" . $e->getMessage() . PHP_EOL;
            }
        }

        echo '执行结束' . PHP_EOL;

        DB::disconnect('custom_mysql');
    }
}