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

namespace App\Console\Commands\LyhTest;

use App\Console\Commands\Domain\DomainInfo;
use App\Http\Logic\Aside\Project\ProjectLogic;
use App\Models\Ai\AiBlog;
use App\Models\Ai\AiBlogAuthor;
use App\Models\Com\NoticeLog;
use App\Models\Com\V6WeeklyReport;
use App\Models\Project\AiBlogTask;
use App\Models\Project\DeployBuild;
use App\Models\Project\DeployOptimize;
use App\Models\Project\OnlineCheck;
use App\Models\Project\Project;
use App\Models\Project\ProjectAiSetting;
use App\Models\ProjectAssociation\ProjectAssociation;
use App\Models\RouteMap\RouteMap;
use App\Models\Visit\Visit;
use App\Models\WebSetting\WebLanguage;
use App\Models\WebSetting\WebSetting;
use App\Models\Workchat\MessagePush;
use App\Services\AiBlogService;
use App\Services\ProjectServer;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\Artisan;
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(){
        $projectModel = new Project();
        $lists = $projectModel->list(['delete_status' => 0,'id'=>467,'extend_type'=>0,'type'=>['in',[1,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']);
            $aiBlogModel = new AiBlog();
            $aiLists = $aiBlogModel->list(['status'=>2],'id',['id','seo_description']);
            if(!empty($aiLists)){
                foreach ($aiLists as $item){
                    if(!empty($item['seo_description'])){
                        $arr = explode('.',$item['seo_description']);
                        if($arr[0].'.' != $item['seo_description']){
                            echo '进入'.PHP_EOL;
                            $text = $this->trimToLastFullWord($item['seo_description']);
                        }else{
                            $text = $arr[0].'.';
                        }
                        dd($text);
                        $aiBlogModel->edit(['seo_description'=>$text],['id'=>$item['id']]);
                    }
                }
            }
            DB::disconnect('custom_mysql');
            echo date('Y-m-d H:i:s') . '结束--项目的id:'. $val['id'] . PHP_EOL;
        }
        return true;
    }

    public function trimToLastFullWord($text) {
        // 去掉结尾非字母数字字符
        $text = rtrim($text);
        // 如果最后一个单词被截断,就删除它
        if (preg_match('/^(.*?\b)\w*$/', $text, $matches)) {
            return $matches[1];
        }
        return trim($text); // fallback
    }
}