<?php

namespace App\Http\Controllers\Aside\Optimize;

use App\Enums\Common\Code;
use App\Helper\Arr;
use App\Http\Controllers\Aside\BaseController;
use App\Http\Logic\Aside\Project\ProjectLogic;
use App\Models\Ai\AiBlog;
use App\Models\Ai\AiPrefix;
use App\Models\ASide\APublicModel;
use App\Models\Channel\Channel;
use App\Models\Com\KeywordVideoTask;
use App\Models\Domain\DomainInfo;
use App\Models\HomeCount\AfterCount;
use App\Models\Manage\ManageHr;
use App\Models\Product\Category;
use App\Models\Product\Keyword;
use App\Models\Product\Product;
use App\Models\Project\DeployOptimize;
use App\Models\Project\Project;
use App\Models\RankData\RankData;
use App\Services\ProjectServer;
use Illuminate\Support\Facades\DB;

/**
 * @remark :优化
 * @name   :OptimizeController
 * @author :lyh
 * @time   :2023/6/20 14:33
 */
class OptimizeController extends BaseController
{
    /**
     * @remark :优化中台列表
     * @name   :middleGroundList
     * @author :lyh
     * @method :post
     * @time   :2023/8/18 10:49
     */
    public function lists(Project $project){
        $query = $project->leftJoin('gl_project_payment', 'gl_project.id', '=', 'gl_project_payment.project_id')
            ->leftJoin('gl_project_deploy_build', 'gl_project.id', '=', 'gl_project_deploy_build.project_id')
            ->leftJoin('gl_domain_info', 'gl_project.id', '=', 'gl_domain_info.project_id')
            ->leftJoin('gl_project_deploy_optimize', 'gl_project.id', '=', 'gl_project_deploy_optimize.project_id')
            ->leftJoin('gl_project_online_check', 'gl_project.id', '=', 'gl_project_online_check.project_id');
        $query = $this->searchParam($query)->orderByRaw("FIELD(gl_project.level, '2') DESC")
            ->orderByRaw('CASE WHEN gl_project_deploy_optimize.start_date IS NULL THEN 0 ELSE 1 END')
            ->orderBy('gl_project_deploy_optimize.start_date','desc');
        $lists = $query->paginate($this->row, $this->selectParam(), 'page', $this->page)->toArray();
        if(!empty($lists) && !empty($lists['list'])){
            //多apino项目
            $api_no_project = [2104,3041];
            $rankDataModel = new RankData();
            foreach ($lists['list'] as $k => $v){
                if(in_array($v['id'],$api_no_project)){
                    switch ($v['id']){
                        case 2104:
                            $keyword_num_map = [10690=>100, 11201 => 50];
                            break;
                        case 3041:
                            $keyword_num_map = [11298=>100, 10659 => 50];
                            break;
                        default:break;
                    }
                    $v['first_page_num'] = $v['indexed_pages_num'] = $v['g'] = $v['keyword_num'] = [];
                    foreach ($keyword_num_map as $api_no => $keyword_num){
                        $data = $rankDataModel->read(['project_id'=>$v['id'],'api_no' => $api_no, 'lang'=>''],['updated_date','first_page_num','indexed_pages_num']);
                        $v['first_page_num'][] = $data['first_page_num'] ?? 0;
                        $v['indexed_pages_num'][] = $data['indexed_pages_num'] ?? 0;
                        $v['g'][] = $this->getGNum($v['id'], $api_no);
                        $v['keyword_num'][] = $keyword_num;
                        $v['updated_date'] = $data['updated_date'] ?? '';
                    }
                    $v['first_page_num'] = implode(',', $v['first_page_num']);
                    $v['indexed_pages_num'] = implode(',', $v['indexed_pages_num']);
                    $v['g'] = implode(',', $v['g']);
                    $v['keyword_num'] = implode(',', $v['keyword_num']);
                }else {
                    $data = $rankDataModel->read(['project_id' => $v['id'], 'lang' => '', 'api_no' => $v['api_no']], ['updated_date','first_page_num', 'indexed_pages_num']);
                    $v['first_page_num'] = $data['first_page_num'] ?? 0;
                    $v['indexed_pages_num'] = $data['indexed_pages_num'] ?? 0;
                    $v['g'] = $this->getGNum($v['id']);
                    $v['updated_date'] = $data['updated_date'] ??'';
                }
                $v = $this->handleParam($v);
                $lists['list'][$k] = $v;
            }
        }
        $this->response('success',Code::SUCCESS,$lists);
    }

    /**
     * @remark :导出数据
     * @name   :importOptimize
     * @author :lyh
     * @method :post
     * @time   :2024/1/25 14:36
     */
    public function importOptimize(Project $project){
        $query = $project->select(['gl_project.title AS title',
            'gl_project_deploy_optimize.domain AS domain',
            'gl_project.is_translate AS is_translate',
            'gl_project.is_translate_tag AS is_translate_tag',
            'gl_project_deploy_optimize.optimist_mid AS optimize_optimist_mid'])
            ->leftJoin('gl_project_deploy_optimize', 'gl_project.id', '=', 'gl_project_deploy_optimize.project_id')
            ->leftJoin('gl_project_online_check', 'gl_project.id', '=', 'gl_project_online_check.project_id');
        $query = $query->whereIn('gl_project.type',[2,4]);//TODO::2,4代表优化项目
        $query->where(function ($subQuery) {
            $subQuery->orwhere('gl_project_online_check.qa_status',1)->orwhere('gl_project.is_upgrade',1);
        });
        $lists = $query->orderBy('gl_project_deploy_optimize.start_date','desc')->get()->toArray();
        if(!empty($lists)){
            $manageModel = new ManageHr();
            $domainModel = new DomainInfo();
            foreach ($lists as $k => $v){
                $v['optimize_optimist'] = $manageModel->getName($v['optimize_optimist_mid']);
                $v['domain'] = !empty($v['domain']) ?  $domainModel->getDomain($v['domain']) : '';
                $lists[$k] = $v;
            }
        }
        $this->response('success',Code::SUCCESS,$lists);
    }

    /**
     * @remark :统计数量
     * @name   :getGNum
     * @author :lyh
     * @method :post
     * @time   :2024/1/6 11:12
     */
    public function getGNum($project_id, $api_no = ''){
        $num = 0;
        $list = RankData::where('project_id', $project_id)->where('lang', '')
            ->when($api_no, function ($query, $api_no) {
                return $query->where('api_no', $api_no);
            })->value('data') ?: [];
        if(!empty($list)){
            foreach ($list as $v) {
                $last = Arr::last($v);
                if(isset($last['g']) && ($last['g'] == 1) && ($last['position'] <= 10) && ($last['position'] >= 1)){
                    $num = $num+1;
                }
            }
        }
        return $num;
    }

    /**
     * @remark :参数处理
     * @name   :handleParam
     * @author :lyh
     * @method :post
     * @time   :2023/8/18 14:44
     */
    public function handleParam(&$item){
        if($item['type'] != Project::TYPE_ZERO){
            $data = APublicModel::getNumByProjectId($item['id']);
        }
        $manageModel = new ManageHr();
        $plan = Project::planMap();
        $seo_plan = Project::seoMap();
        $item['plan'] = $plan[$item['plan']] ?? ($seo_plan[$item['seo_plan']] ?? '');
        $item['channel'] = Channel::getChannelText($item['channel']['user_id'] ?? 0);
        $item['build_leader'] = $manageModel->getName($item['leader_mid']);
        $item['build_manager'] = $manageModel->getName($item['manager_mid']);
        $item['build_designer'] = $manageModel->getName($item['designer_mid']);
        $item['build_tech'] = $manageModel->getName($item['tech_mid']);
        $item['optimize_manager'] = $manageModel->getName($item['optimize_manager_mid']);
        $item['optimize_optimist'] = $manageModel->getName($item['optimize_optimist_mid']);
        $item['optimize_assist'] = $manageModel->getName($item['optimize_assist_mid']);
        $item['optimize_tech'] = $manageModel->getName($item['optimize_tech_mid']);
        $item['quality_mid_name'] = $manageModel->getName($item['quality_mid']);
        $item['created_at'] = date('Y年m月d日', strtotime($item['cooperate_date']));
        $item['autologin_code'] = getAutoLoginCode($item['id']);
        $item['domain'] = 'https://'.$item['domain'].'/';
        if(!empty($item['domain']) && $item['amp_status'] == 1){
            $item['amp_domain'] = str_replace('www','m',$item['domain']);
        }
        $item['product_num'] = $data['product'] ?? 0;
        $item['keyword_num'] = $item['key'] ?? 0;
        $item['inquiry_num'] = $data['inquiry'] ?? 0;
        $item['autologin_code'] = getAutoLoginCode($item['id']);
        return $item;
    }
    /**
     * @remark :查询字段处理
     * @name   :selectParam
     * @author :lyh
     * @method :post
     * @time   :2023/8/18 10:59
     */
    public function selectParam(){
        $select = [
            'gl_project.id AS id',
            'gl_project.title AS title',
            'gl_project.level AS level',
            'gl_project.channel AS channel',
            'gl_project.company AS company',
            'gl_project.type AS type',
            'gl_project.created_at AS created_at',
            'gl_project.is_language AS is_language',
            'gl_project.cooperate_date AS cooperate_date',
            'gl_project.finish_remain_day AS finish_remain_day',
            'gl_project.is_remain_today AS is_remain_today',
            'gl_project.remain_day AS remain_day',
            'gl_project.seo_remain_day AS seo_remain_day',
            'gl_project.robots AS robots',
            'gl_project.is_analysis AS is_analysis',
            'gl_project.is_minor_languages AS is_minor_languages',
            'gl_project.is_translate AS is_translate',
            'gl_project.is_translate_tag AS is_translate_tag',
            'gl_project.is_upgrade AS is_upgrade',
            'gl_project.project_type AS project_type',
            'gl_project.site_status AS site_status',
            'gl_project_online_check.id AS online_check_id',
            'gl_project_online_check.question AS question',
            'gl_project_online_check.go_question AS go_question',
            'gl_project_online_check.optimist_status AS optimist_status',
            'gl_project_online_check.qa_status AS qa_status',
            'gl_project_online_check.updated_at AS online_updated_at',
            'gl_project_payment.amount AS amount',
            'gl_project_deploy_build.dept_id AS dept_id',
            'gl_project_deploy_build.keyword_num AS key',
            'gl_project_deploy_build.service_duration AS day',
            'gl_project_deploy_build.leader_mid AS leader_mid',
            'gl_project_deploy_build.manager_mid AS manager_mid',
            'gl_project_deploy_build.designer_mid AS designer_mid',
            'gl_project_deploy_build.tech_mid AS tech_mid',
            'gl_project_deploy_build.test_domain AS test_domain',
            'gl_project_deploy_build.plan AS plan',
            'gl_project_deploy_build.seo_plan AS seo_plan',
            'gl_project_deploy_optimize.dept_id AS optimize_dept_id',
            'gl_project_deploy_optimize.manager_mid AS optimize_manager_mid',
            'gl_project_deploy_optimize.optimist_mid AS optimize_optimist_mid',
            'gl_project_deploy_optimize.assist_mid AS optimize_assist_mid',
            'gl_project_deploy_optimize.tech_mid AS optimize_tech_mid',
            'gl_project_deploy_optimize.design_mid AS design_mid',
            'gl_project_deploy_optimize.tech_leader AS tech_leader',
            'gl_project_deploy_optimize.quality_mid AS quality_mid',
            'gl_project_deploy_optimize.design_mid AS design_mid',
            'gl_project_deploy_optimize.start_date AS start_date',
            'gl_project_deploy_optimize.backlink AS backlink',
            'gl_project_deploy_optimize.ai_video AS ai_video',
            'gl_project_deploy_optimize.api_no AS api_no',
            'gl_project_deploy_optimize.first_compliance_time AS first_compliance_time',
            'gl_domain_info.amp_status AS amp_status',
            'gl_domain_info.domain AS domain',
            'gl_domain_info.ai_domain AS ai_domain',
        ];
        return $select;
    }

    /**
     * @remark :搜索参数处理
     * @name   :searchParam
     * @author :lyh
     * @method :post
     * @time   :2023/8/18 10:58
     */
    public function searchParam(&$query){
        //搜索条件处理
        if(isset($this->map['title']) && !empty($this->map['title'])){
            $query = $query->where('gl_project.title','like','%'.$this->map['title'].'%');
        }
        if(isset($this->map['site_status'])){
            $query = $query->where('gl_project.site_status',$this->map['site_status']);
        }
        if(isset($this->map['seo_plan'])){
            if(is_array($this->map['seo_plan'])){
                $query = $query->whereIn('gl_project_deploy_build.seo_plan',$this->map['seo_plan']);
            }else{
                $query = $query->where('gl_project_deploy_build.seo_plan',$this->map['seo_plan']);
            }
        }
        if(isset($this->map['main_lang_id'])){
            $query = $query->where('gl_project.main_lang_id',$this->map['main_lang_id']);
        }
        if(isset($this->map['ai_video']) && !empty($this->map['ai_video'])){
            $query = $query->where('gl_project_deploy_optimize.ai_video',$this->map['ai_video']);
        }
        if(isset($this->map['ai_domain']) && !empty($this->map['ai_domain'])){
            $query = $query->whereNotNull('gl_domain_info.ai_domain');
        }
        if(isset($this->map['amp_status'])){
            $query = $query->where('gl_domain_info.amp_status',$this->map['amp_status']);
        }
        if(isset($this->map['level']) && !empty($this->map['level'])){
            $query = $query->whereRaw("FIND_IN_SET(?, gl_project.level) > 0", [$this->map['level']]);
        }
        if(isset($this->map['online_updated_at']) && !empty($this->map['online_updated_at']) && is_array($this->map['online_updated_at'])){
            $query = $query->where('gl_project_deploy_optimize.start_date','>=' ,$this->map['online_updated_at'][0])->where('gl_project_deploy_optimize.start_date','<' ,$this->map['online_updated_at'][1]);
        }
        if(isset($this->map['special'])){
            $query = $query->whereRaw("FIND_IN_SET(?, gl_project_deploy_optimize.special) > 0", [$this->map['special']]);
        }
        if(isset($this->map['search'])){
            $query = $query->where('gl_project_deploy_optimize.ai_video', 1);
        }
        if(isset($this->map['is_remain_today'])){
            $query = $query->where('gl_project.is_remain_today',$this->map['is_remain_today']);
        }
        if(isset($this->map['manager_mid'])){
            $query = $query->where('gl_project_deploy_build.manager_mid',$this->map['manager_mid']);
        }
        if(isset($this->map['optimize_manager_mid'])){
            $query = $query->where('gl_project_deploy_optimize.manager_mid',$this->map['optimize_manager_mid']);
        }
        if(isset($this->map['is_upgrade'])){
            $query = $query->where('gl_project.is_upgrade',$this->map['is_upgrade']);
        }
        if(isset($this->map['optimize_tech_mid'])){
            $query = $query->where('gl_project_deploy_optimize.tech_mid',$this->map['optimize_tech_mid']);
        }
        if(isset($this->map['optimize_optimist_mid'])){
            $query = $query->where('gl_project_deploy_optimize.optimist_mid',$this->map['optimize_optimist_mid']);
        }
        if(isset($this->map['optimize_assist_mid'])){
            $query = $query->where('gl_project_deploy_optimize.assist_mid',$this->map['optimize_assist_mid']);
        }
        if(isset($this->map['channel_id']) && !empty($this->map['channel_id'])){
            $query->where(function ($subQuery) {
                $subQuery->orWhere('gl_project.channel','like','%"channel_id": "'.$this->map['channel_id'].'"%')
                    ->orWhere('gl_project.channel','like','%"zone_id": '.$this->map['channel_id'].'%');
            });
        }
        if(isset($this->map['domain']) && !empty($this->map['domain'])){
            $parsedUrl = parse_url($this->map['domain']);
            $this->map['domain'] = $parsedUrl['host'] ?? $this->map['domain'];
//            $ids = DomainInfo::where('domain', 'like', '%'.$this->map['domain'].'%')->pluck('id')->toArray();
            $query = $query->where('gl_domain_info.domain', 'like' ,'%'.$this->map['domain'].'%');
        }
        if(isset($this->map['test_domain']) && !empty($this->map['test_domain'])){
            $query = $query->where('gl_project_deploy_build.test_domain','like','%'.$this->map['test_domain'].'%');
        }
        $query = $query->where('gl_project.type',2)->where('gl_project.extend_type','!=',5);//TODO::2,4代表优化项目; 2024-06-05修改项目中台只显示为类型为2
//        $query->where(function ($subQuery) {
//            $subQuery->where('gl_project.is_upgrade',1);
//        });
        return $query;
    }

    /**
     * @remark :获取项目Ai前后缀
     * @name   :getAiPrefix
     * @author :lyh
     * @method :post
     * @time   :2023/9/27 15:20
     */
    public function getAiPrefix(AiPrefix $aiPrefix){
        $info = $aiPrefix->read(['status'=>0]);
        if($info === false){
            $info = [];
        }
        $this->response('success',Code::SUCCESS,$info);
    }

    /**
     * @remark :保存数据
     * @name   :saveAiPrefix
     * @author :lyh
     * @method :post
     * @time   :2023/9/27 15:35
     */
    public function saveAiPrefix(AiPrefix $aiPrefix){
        $this->request->validate([
            'title_prefix'=>'required',
            'description_prefix'=>'required',
            'long_suffix'=>'required',
            'short_suffix'=>'required',
        ],[
            'title_prefix.required' => 'title_prefix不能为空',
            'description_prefix.required' => 'description_prefix不能为空',
            'long_suffix.required' => 'long_suffix不能为空',
            'short_suffix.required' => 'short_suffix不能为空',
        ]);
        $info = $aiPrefix->read(['status'=>0]);
        if($info === false){
            $rs = $aiPrefix->add($this->param);
        }else{
            $rs = $aiPrefix->edit($this->param,['id'=>$info['id']]);
        }
        if($rs === false){
            $this->response('系统错误，请联系管理员',Code::SYSTEM_ERROR);
        }
        $this->response('success');
    }

    /**
     * @remark :设置开关
     * @name   :setRobots
     * @author :lyh
     * @method :post
     * @time   :2023/11/20 9:42
     */
    public function setRobots(){
        $this->request->validate([
            'robots'=>'required',
            'project_id'=>'required',
        ],[
            'robots.required' => 'robots不能为空',
            'project_id.required' => 'project_id不能为空',
        ]);
        $projectModel = new Project();
        if($this->param['robots'] != $projectModel::STATUS_ONE){
            $this->response('robots只能开启不能关闭',Code::SYSTEM_ERROR);
        }
        $rs = $projectModel->edit(['robots'=>$this->param['robots']],['id'=>$this->param['project_id']]);
        if($rs === false){
            $this->response('执行错误，请联系开发人员',Code::SYSTEM_ERROR);
        }
        //TODO::通知C端
        $projectLogic = new ProjectLogic();
        $project = $projectLogic->getProjectInfo($this->param['project_id']);
        $domain = !empty($project['deploy_optimize']['domain']) ? ((new DomainInfo())->getDomain($project['deploy_optimize']['domain'])) :  '';
        if(empty($domain)){
            $domain = $project['deploy_build']['test_domain'];
        }
        $url = $domain.'api/update_robots/?project_id='.$this->param['project_id'];
        $res = curlGet($url);
        if(empty($res) || !isset($res['status']) || $res['status'] != 200){
            $this->response('生成robots失败，请联系开发人员',Code::SYSTEM_ERROR,['url'=>$url]);
        }
        $this->response('success',Code::SUCCESS,['url'=>$domain.'robots.txt']);
    }

    /**
     * @remark :更改状态
     * @name   :editTranslateStatus
     * @author :lyh
     * @method :post
     * @time   :2023/12/29 15:28
     */
    public function editTranslateStatus(){
        $this->request->validate([
            'project_id'=>'required',
            'status'=>'required',
            'type'=>'required|in:is_translate,is_translate_tag',
        ],[
            'project_id.required' => 'project_id不能为空',
            'status.required' => 'status不能为空',
            'type.required' => 'type不能为空',
            'type.in' => 'type类型错误',
        ]);
        $projectModel = new Project();
        $projectModel->edit([$this->param['type']=>$this->param['status']],['id'=>$this->param['project_id']]);
        $this->response('success');
    }

    /**
     * @remark :标记反向链接
     * @name   :editBacklink
     * @author :lyh
     * @method :post
     * @time   :2024/2/29 9:18
     */
    public function editBacklink(){
        $this->request->validate([
            'project_id'=>'required',
            'backlink'=>'required',
        ],[
            'project_id.required' => 'project_id不能为空',
            'backlink.required' => 'backlink不能为空',
        ]);
        $optimizeModel = new DeployOptimize();
        $optimizeModel->edit(['backlink'=>$this->param['backlink']],['project_id'=>$this->param['project_id']]);
        $this->response('success');
    }

    /**
     * @remark :开启视频模块
     * @name   :setAiVideo
     * @author :lyh
     * @method :post
     * @time   :2024/5/30 10:30
     */
    public function setAiVideo(){
        $this->request->validate([
            'project_id'=>'required',
            'status'=>'required',
        ],[
            'project_id.required' => 'project_id不能为空',
            'status.required' => '状态不能为空',
        ]);
        $keywordVideoModel = new KeywordVideoTask();
        $info = $keywordVideoModel->read(['project_id'=>$this->param['project_id']]);
        if($info === false){
            $this->response('请先创建视频任务，才能开启',Code::SYSTEM_ERROR);
        }
        $optimizeModel = new DeployOptimize();
        $optimizeModel->edit(['ai_video'=>$this->param['status']],['project_id'=>$this->param['project_id']]);
        $this->response('success');
    }

    /**
     * @remark :锚文本链接
     * @name   :anchorTextList
     * @author :lyh
     * @method :post
     * @time   :2024/7/17 14:04
     */
    public function anchorTextList(){
        $this->request->validate([
            'project_id' => 'required',
        ], [
            'project_id.required' => 'project_id不能为空',
        ]);
        // 获取当前网站正式域名
        $domainModel = new DomainInfo();
        $domainInfo = $domainModel->read(['project_id' => $this->param['project_id']], ['domain']);
        if ($domainInfo === false) {
            $this->fail('请先设置域名');
        }
        $domain = 'https://' . $domainInfo['domain'] . '/';
        $data = [
            'ai_blog' => [],
            'product' => [],
            'product_category'=>[],
            'product_keyword' => [],
        ];
        ProjectServer::useProject($this->param['project_id']);
        $productModel = new Product();
        $this->processChunkedList($productModel, ['status' => $productModel::STATUS_ON], ['id', 'title', 'route'], $domain, $data, 'product');
        $productCategoryModel = new Category();
        $this->processChunkedList($productCategoryModel, ['status' => $productCategoryModel::STATUS_ACTIVE], ['id', 'title', 'route'], $domain, $data, 'product_category');
        $productKeywordModel = new Keyword();
        $this->processChunkedList($productKeywordModel, ['status' => $productKeywordModel::STATUS_ACTIVE], ['id', 'title', 'route'], $domain, $data, 'product_keyword');
        $aiBlogModel = new AiBlog();
        $list = $aiBlogModel->list(['route'=>['!=',null]],'id',['route','new_title']);
        if(!empty($list)){
            foreach ($list as $v){
                $data['ai_blog'][] = $domain . 'blog/' . $v['route'] . '/{' . $v['new_title'] . '}';
            }
        }
        DB::disconnect('custom_mysql');
        $this->response('success', Code::SUCCESS, $data);
    }

    /**
     * @remark :获取聚合页链接数据
     * @name   :getKeywordRouteList
     * @author :lyh
     * @method :post
     * @time   :2025/8/22 15:02
     */
    public function getKeywordRouteList(){
        $this->request->validate([
            'project_id' => 'required',
        ], [
            'project_id.required' => 'project_id不能为空',
        ]);
        // 获取当前网站正式域名
        $domainModel = new DomainInfo();
        $domainInfo = $domainModel->read(['project_id' => $this->param['project_id']], ['domain']);
        if ($domainInfo === false) {
            $this->fail('请先设置域名');
        }
        $domain = 'https://' . $domainInfo['domain'] . '/';
        ProjectServer::useProject($this->param['project_id']);
        $productKeywordModel = new Keyword();
        $data = [];
        $lists = $productKeywordModel->lists(['route'=>['!=',null]],1,500,'id',['id','route','seo_title']);
        if (!empty($lists['list'])){
            foreach ($lists['list'] as $item){
                $data[] = $domain . $item['route'] . '/{' . $item['seo_title'] . '}';
            }
        }
        DB::disconnect('custom_mysql');
        $this->response('success', Code::SUCCESS, $data);
    }

    /**
     * @remark :分片查询
     * @name   :processChunkedList
     * @author :lyh
     * @method :post
     * @time   :2024/7/17 14:55
     */
    public function processChunkedList($model, $conditions, $fields, $domain, &$data, $key) {
        $offset = 1;
        $chunkSize = 5000; // 每次查询的记录数
        while (true) {
            $chunk = $model->lists($conditions,$offset,$chunkSize, 'id', $fields);
            if (count($chunk['list']) == 0) {
                break;
            }
            foreach ($chunk['list'] as $item) {
                if(empty($item['route'])){
                    continue;
                }
                $data[$key][] = $domain . $item['route'] . '/{' . $item['title'] . '}';
            }
            $offset++;
        }
    }

    /**
     * @remark :保存小语种监控配置
     * @name   :saveMinorLanguages
     * @author :lyh
     * @method :post
     * @time   :2024/11/21 14:35
     */
    public function saveMinorLanguages(){
        $this->request->validate([
            'id' => 'required',
            'is_minor_languages' => 'required',
        ], [
            'id.required' => '项目id不能为空',
            'is_minor_languages.required' => '项目is_minor_languages不能为空',
        ]);
        $projectModel = new Project();
        $info = $projectModel->read(['id'=>$this->param['id']],['main_lang_id']);
        if($info['main_lang_id'] != 1){
            $this->fail('当前主语种不允许操作小语种监控配置');
        }
        $projectModel->edit(['is_minor_languages'=>$this->param['is_minor_languages']],['id'=>$this->param['id']]);
        $this->response('success');
    }

    /**
     * @remark :更新锚文本链接
     * @name   :getAnchorLink
     * @author :lyh
     * @method :post
     * @time   :2025/3/21 14:06
     */
    public function getAnchorLink(){
        $this->request->validate([
            'project_id' => 'required',
        ], [
            'project_id.required' => '项目id不能为空',
        ]);
        $domainModel = new DomainInfo();
        $domainInfo = $domainModel->read(['project_id'=>$this->param['project_id']],['domain']);
        if($domainInfo === false){
            $this->response('success');
        }
        ProjectServer::useProject($this->param['project_id']);
        $aiBlogModel = new AiBlog();
        $list = $aiBlogModel->list(['route'=>['!=',null]],'id',['route','new_title']);
        $resultData = [];
        if(!empty($list)){
            $DomainInfo['domain'] = $DomainInfo['domain'] ?? '';
            foreach ($list as $v){
                $resultData[] = ('https://'.$DomainInfo['domain'].'/') . 'blog/' . $v['route'] . '/{' . $v['new_title'] . '}';
            }
        }
        DB::disconnect('custom_mysql');
        $this->response('success',Code::SUCCESS,$resultData);
    }

    /**
     * @remark :是否开启泛解析
     * @name   :saveIsAnalysis
     * @author :lyh
     * @method :post
     * @time   :2025/5/24 14:48
     */
    public function saveIsAnalysis(){
        $this->request->validate([
            'id' => 'required',
            'is_analysis' => 'required',
        ], [
            'id.required' => '项目id不能为空',
            'is_analysis.required' => 'is_analysis不能为空',
        ]);
        $projectModel = new Project();
        $data = $projectModel->edit(['is_analysis'=>$this->param['is_analysis']],['id'=>$this->param['id']]);
        $this->response('success',Code::SUCCESS,$data);
    }
}