UpdateMainHtml.php 2.8 KB
<?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\Models\Template\BTemplate;
use App\Models\Template\BTemplateMain;
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 UpdateMainHtml extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'update_main';

    /**
     * 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'=>['!=',0]]);
        foreach ($list as $v){
            echo date('Y-m-d H:i:s') . 'project_id:'.$v['id'] . PHP_EOL;
            ProjectServer::useProject($v['id']);
            $this->editMainHtml($v['id']);
            DB::disconnect('custom_mysql');
        }
        echo date('Y-m-d H:i:s') . 'end' . PHP_EOL;
    }

    /**
     * @remark :洗数据
     * @name   :getMainHtml
     * @author :lyh
     * @method :post
     * @time   :2023/12/27 18:03
     */
    public function editMainHtml($project_id){
        $templateModel = new BTemplate();
        $info = $templateModel->read(['source'=>4,'source_id'=>0]);
        if($info !== false){
            $mainModel = new BTemplateMain();
            $mainInfo = $mainModel->read(['type'=>4,'is_list'=>1]);
            if($mainInfo === false){
                $data = [
                    'type'=>4,
                    'is_list'=>1,
                    'main_html'=>$info['main_html'],
                    'main_css'=>$info['main_css'],
                    'section_list_id'=>$info['section_list_id'],
                    'project_id'=>$project_id
                ];
                $mainModel->add($data);
            }else{
                $data = [
                    'main_html'=>$info['main_html'],
                    'main_css'=>$info['main_css'],
                    'section_list_id'=>$info['section_list_id'],
                    'project_id'=>$project_id,
                ];
                $mainModel->edit($data,['id'=>$mainInfo['id']]);
            }
        }
        return true;
    }
}